diff options
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 98f56c41..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; @@ -824,17 +824,15 @@ 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, - `puertorepo` int(11) NOT NULL DEFAULT '0', `apikey` varchar(32) NOT NULL DEFAULT '', 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'); -- -------------------------------------------------------- |