diff options
Diffstat (limited to 'admin/Database')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql | 12 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 4 |
2 files changed, 14 insertions, 2 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; diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index ca45212f..3057f953 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -783,7 +783,7 @@ CREATE TABLE `programaciones` ( -- -------------------------------------------------------- -- --- Estructura de tabla para la tabla `projector` +-- Estructura de tabla para la tabla `projectors` -- DROP TABLE IF EXISTS projectors; @@ -793,7 +793,7 @@ CREATE TABLE `projectors` ( `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) DEFAULT NULL, + `lab_id` int(11) NOT NULL DEFAULT 0, PRIMARY KEY(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; |