summaryrefslogtreecommitdiffstats
path: root/admin/Database/ogAdmBD.sql
diff options
context:
space:
mode:
authorramon <ramongomez@us.es>2015-06-14 16:17:07 +0000
committerramon <ramongomez@us.es>2015-06-14 16:17:07 +0000
commit7829e4e9833f433746363856d446d08a367beb0c (patch)
tree12ac3af378b8fdfb671772f9ce1c72f0d77275a7 /admin/Database/ogAdmBD.sql
parent304533cd78dfe799a01922d70ff00d3e71fb60ea (diff)
#708: Integrar código del ticket:708 en versión 1.1.
git-svn-id: https://opengnsys.es/svn/branches/version1.1@4652 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
-rw-r--r--admin/Database/ogAdmBD.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql
index 03ea47dd..15822364 100644
--- a/admin/Database/ogAdmBD.sql
+++ b/admin/Database/ogAdmBD.sql
@@ -109,6 +109,7 @@ CREATE TABLE IF NOT EXISTS `aulas` (
`validacion` tinyint(1) DEFAULT '0',
`paginalogin` varchar(100),
`paginavalidacion` varchar(100),
+ `inremotepc` tinyint DEFAULT 0,
PRIMARY KEY (`idaula`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
@@ -1049,6 +1050,7 @@ CREATE TABLE IF NOT EXISTS `usuarios` (
`email` varchar(200) DEFAULT NULL,
`ididioma` int(11) DEFAULT NULL,
`idtipousuario` tinyint(4) DEFAULT NULL,
+ `apikey` varchar(32) NOT NULL,
PRIMARY KEY (`idusuario`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
@@ -1057,6 +1059,6 @@ CREATE TABLE IF NOT EXISTS `usuarios` (
--
INSERT INTO `usuarios` (`idusuario`, `usuario`, `pasguor`, `nombre`, `email`, `ididioma`, `idtipousuario`) VALUES
-(1, 'DBUSER', 'DBPASSWORD', 'Usuario de la base de datos MySql', '', 1, 1);
+(1, 'DBUSER', 'DBPASSWORD', 'Usuario de la base de datos MySql', '', 1, 1, 'APIKEY');