diff options
| author | ramon <ramongomez@us.es> | 2017-05-29 11:13:43 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2017-05-29 11:13:43 +0000 |
| commit | dee9faca9e07f9d7b974ebf5213dc38e94a3f599 (patch) | |
| tree | 61b657b655eda89b6e882824997c69265dc51704 /admin/Database/ogAdmBD.sql | |
| parent | fa3eca02e3806fa7ff1f5f19468b5855f67a3ce1 (diff) | |
#676 #730: Definir particiones para volúmenes LVM y ZFS; modificar configuración para evitar errores con MySQL 5.7 (Ubuntu 16.04).
git-svn-id: https://opengnsys.es/svn/branches/version1.1@5322 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 419dc59a..009bb3b5 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -1,6 +1,7 @@ -- Fichero de instalación de la base de datos. -SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; +SET sql_mode = "NO_AUTO_VALUE_ON_ZERO"; +SET GLOBAL sql_mode = TRIM(BOTH ',' FROM REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', '')); SET GLOBAL event_scheduler = ON; -- @@ -1052,7 +1053,10 @@ INSERT INTO `tipospar` (`codpar`, `tipopar`, `clonable`) VALUES (CONV('FB01',16,10), 'VMFS-RESERV', 1), (CONV('FB02',16,10), 'VMFS-KRN', 1), (CONV('FD00',16,10), 'LINUX-RAID', 1), -(CONV('FFFF',16,10), 'UNKNOWN', 1); +(CONV('FFFF',16,10), 'UNKNOWN', 1), +(CONV('10000',16,10), 'LVM-LV', 1), +(CONV('10010',16,10), 'ZFS-VOL', 1); + -- -------------------------------------------------------- |