diff options
| author | Ramón M. Gómez <ramongomez@us.es> | 2018-11-26 12:52:31 +0100 |
|---|---|---|
| committer | Ramón M. Gómez <ramongomez@us.es> | 2018-11-26 12:52:31 +0100 |
| commit | 51e67a2cc790796cf3e6832d430c4473e6377ed8 (patch) | |
| tree | 41e24b0c7e74d95f55dcaca94f778f008774bb4f /admin/Database/ogAdmBD-1.1.1pre.sql | |
| parent | 910a4c358af0191b5c83f45f93a444b60a633fff (diff) | |
| parent | 518d4d84f755185f224c82d5cc3f49b350af4b05 (diff) | |
#794: Fast-forward.
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.1pre.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1pre.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.1pre.sql b/admin/Database/ogAdmBD-1.1.1pre.sql index cdac985b..a89f37be 100644 --- a/admin/Database/ogAdmBD-1.1.1pre.sql +++ b/admin/Database/ogAdmBD-1.1.1pre.sql @@ -14,9 +14,29 @@ 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 ';' CALL addcols(); DROP PROCEDURE addcols; +# Nueva tabla de proyectores (ticket #794). +DROP TABLE IF EXISTS projectors; +CREATE TABLE `projectors` ( + id INT(11) NOT NULL AUTO_INCREMENT, + name VARCHAR(50) NOT NULL DEFAULT '', + model VARCHAR(50) NOT NULL DEFAULT '', + type ENUM('no-net', 'net-pjlink', 'net-other', 'unknown') NOT NULL DEFAULT 'no-net', + ipaddr VARCHAR(16) NOT NULL DEFAULT '', + lab_id INT(11) NOT NULL DEFAULT 0, + PRIMARY KEY(`id`) + ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; + |