diff options
| author | Ramón M. Gómez <ramongomez@us.es> | 2018-11-21 13:08:37 +0100 |
|---|---|---|
| committer | Ramón M. Gómez <ramongomez@us.es> | 2018-11-21 13:08:37 +0100 |
| commit | 60ea634fed995dbbf238a284ed18a1f60bdf3e0b (patch) | |
| tree | 5e667de4706613407f55891914742cd829bce8cd /admin/Database | |
| parent | b3dfeb6d33eab2e0a664d111bf6a30679e9df057 (diff) | |
#875: Remove unused field from repositories table and update list of closed tickets.
Diffstat (limited to 'admin/Database')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql | 3 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1pre.sql | 3 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 5 |
3 files changed, 6 insertions, 5 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 2ad8b0df..d0b3e0a7 100644 --- a/admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql +++ b/admin/Database/ogAdmBD-1.1.0a-1.1.1pre.sql @@ -6,7 +6,8 @@ ALTER TABLE aulas ADD idordprofesor INT(11) DEFAULT 0 AFTER puestos; -# Borrar campo de puerto del antiguo servicio ogAdmRepo (ticket #875). +# Borrar campos sin uso del antiguo servicio ogAdmRepo (ticket #875). ALTER TABLE repositorios + DROP passguor, DROP puertorepo; diff --git a/admin/Database/ogAdmBD-1.1.1pre.sql b/admin/Database/ogAdmBD-1.1.1pre.sql index e29c4e42..d10e2e5d 100644 --- a/admin/Database/ogAdmBD-1.1.1pre.sql +++ b/admin/Database/ogAdmBD-1.1.1pre.sql @@ -14,11 +14,12 @@ 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). + # 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// diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index b8d18132..d411d243 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -807,7 +807,6 @@ CREATE TABLE `repositorios` ( `idrepositorio` int(11) NOT NULL AUTO_INCREMENT, `nombrerepositorio` varchar(250) NOT NULL DEFAULT '', `ip` varchar(15) NOT NULL DEFAULT '', - `passguor` varchar(50) NOT NULL DEFAULT '', `idcentro` int(11) DEFAULT NULL, `grupoid` int(11) DEFAULT NULL, `comentarios` text, @@ -815,8 +814,8 @@ CREATE TABLE `repositorios` ( PRIMARY KEY (`idrepositorio`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -INSERT INTO `repositorios` (`idrepositorio`,`nombrerepositorio`,`ip`,`passguor`,`idcentro`,`grupoid`,`comentarios`,`puertorepo`,`apikey`) VALUES - (1,'Repositorio (Default)','SERVERIP','',1,0,'',2002,'REPOKEY'); +INSERT INTO `repositorios` (`idrepositorio`,`nombrerepositorio`,`ip`,`idcentro`,`grupoid`,`comentarios`,`apikey`) VALUES + (1,'Repositorio (Default)','SERVERIP',1,0,'','REPOKEY'); -- -------------------------------------------------------- |