diff options
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.0pre.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0pre.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0pre.sql b/admin/Database/ogAdmBD-1.1.0pre.sql index 90a413d4..811aed1f 100644 --- a/admin/Database/ogAdmBD-1.1.0pre.sql +++ b/admin/Database/ogAdmBD-1.1.0pre.sql @@ -56,6 +56,17 @@ CREATE PROCEDURE addcols() BEGIN ALTER TABLE aulas ADD ntp VARCHAR(30) AFTER proxy; END IF; + # Directorios en repo para distintas UO (ticket #678). + IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='ogunit' AND TABLE_NAME='entidades' AND TABLE_SCHEMA=DATABASE()) + ALTER TABLE entidades + ADD ogunit TINYINT(1) NOT NULL DEFAULT 0; + END IF; + IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='directorio' AND TABLE_NAME='centros' AND TABLE_SCHEMA=DATABASE()) + ALTER TABLE centros + ADD directorio VARCHAR(50) DEFAULT ''; + END IF; END// # Ejecutar actualización condicional. delimiter ';' |