summaryrefslogtreecommitdiffstats
path: root/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql
diff options
context:
space:
mode:
authorRamón M. Gómez <ramongomez@us.es>2019-10-01 09:26:19 +0200
committerRamón M. Gómez <ramongomez@us.es>2019-10-01 09:26:19 +0200
commitf66e791fa44de4f2ea7b572503d8128b6b543386 (patch)
tree88f3cc52d69aebfc23ed67e3c21b33288af7deaa /admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql
parent8256de50847692558d12bda5647ea3ec71c0a22b (diff)
parent51e67a2cc790796cf3e6832d430c4473e6377ed8 (diff)
#794: Fast-forwardpjlink
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql')
-rw-r--r--admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql b/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql
index 759da7bd..6d075d40 100644
--- a/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql
+++ b/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql
@@ -30,3 +30,15 @@ DROP PROCEDURE addcols;
# Cambio del nombre de las plantillas PXE para compatibilidad con UEFI.
UPDATE ordenadores SET arranque='10' WHERE arranque='01';
+
+# 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;