diff options
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.1pre.sql')
-rw-r--r-- | admin/Database/ogAdmBD-1.1.1pre.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.1pre.sql b/admin/Database/ogAdmBD-1.1.1pre.sql index 8d815040..0f03188b 100644 --- a/admin/Database/ogAdmBD-1.1.1pre.sql +++ b/admin/Database/ogAdmBD-1.1.1pre.sql @@ -14,6 +14,14 @@ CREATE PROCEDURE addcols() BEGIN ALTER TABLE aulas ADD idordprofesor INT(11) DEFAULT 0 AFTER puestos; END IF; + # Borrar campos sin uso del antiguo servicio ogAdmRepo (ticket #875). + IF EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='puertorepo' AND TABLE_NAME='repositorios' AND TABLE_SCHEMA=DATABASE()) + THEN + ALTER TABLE repositorios + DROP passguor, + DROP puertorepo; + END IF; END// # Ejecutar actualizaciĆ³n condicional. DELIMITER ';' |