diff options
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.0a-1.1.1c.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0a-1.1.1c.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0a-1.1.1c.sql b/admin/Database/ogAdmBD-1.1.0a-1.1.1c.sql index ba206053..f0d5c1f6 100644 --- a/admin/Database/ogAdmBD-1.1.0a-1.1.1c.sql +++ b/admin/Database/ogAdmBD-1.1.0a-1.1.1c.sql @@ -22,6 +22,13 @@ CREATE PROCEDURE addcols() BEGIN DROP passguor, DROP puertorepo; END IF; + # Add tipodisco (ticket #1037). + IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='tdisk' AND TABLE_NAME='ordenadores_particiones' AND TABLE_SCHEMA=DATABASE()) + THEN + ALTER TABLE ordenadores_particiones + ADD tdisk VARCHAR(4) DEFAULT NULL AFTER idordenador; + END IF; END// # Ejecutar actualización condicional. DELIMITER ';' |