diff options
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.1pre.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1pre.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.1pre.sql b/admin/Database/ogAdmBD-1.1.1pre.sql index cdac985b..e29c4e42 100644 --- a/admin/Database/ogAdmBD-1.1.1pre.sql +++ b/admin/Database/ogAdmBD-1.1.1pre.sql @@ -14,6 +14,13 @@ CREATE PROCEDURE addcols() BEGIN ALTER TABLE aulas ADD idordprofesor INT(11) DEFAULT 0 AFTER puestos; END IF; + # Borrar campo de puerto 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 puertorepo; + END IF; END// # Ejecutar actualización condicional. DELIMITER ';' |