diff options
| author | Ramón M. Gómez <ramongomez@us.es> | 2018-11-20 12:52:28 +0100 |
|---|---|---|
| committer | Ramón M. Gómez <ramongomez@us.es> | 2018-11-20 12:52:28 +0100 |
| commit | b3dfeb6d33eab2e0a664d111bf6a30679e9df057 (patch) | |
| tree | 593488b601e6129b773a37aac7b9985c3f43aff2 /admin/Database | |
| parent | a37e8cbbc4557c4407a0d29edd97bf472da0b4b1 (diff) | |
#875: Remove port from repository properties form and alter the database.
Diffstat (limited to 'admin/Database')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql | 4 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1pre.sql | 7 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 1 |
3 files changed, 11 insertions, 1 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql b/admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql index 9b5ccadd..2ad8b0df 100644 --- a/admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql +++ b/admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql @@ -6,3 +6,7 @@ ALTER TABLE aulas ADD idordprofesor INT(11) DEFAULT 0 AFTER puestos; +# Borrar campo de puerto del antiguo servicio ogAdmRepo (ticket #875). +ALTER TABLE repositorios + DROP puertorepo; + 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 ';' diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index b45b59d8..b8d18132 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -811,7 +811,6 @@ CREATE TABLE `repositorios` ( `idcentro` int(11) DEFAULT NULL, `grupoid` int(11) DEFAULT NULL, `comentarios` text, - `puertorepo` int(11) NOT NULL DEFAULT '0', `apikey` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`idrepositorio`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |