diff options
| author | ramon <ramongomez@us.es> | 2016-09-23 07:40:53 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2016-09-23 07:40:53 +0000 |
| commit | e8d28512c9e3fb6f80227d430813bc475cc1439d (patch) | |
| tree | 722e6b9080189c7b0dc909934b96a11324fd1f09 /admin/Database/ogAdmBD.sql | |
| parent | 79c119cab709be7ed750e30a51a825f40d5de92f (diff) | |
#730: Incluir índice en BD para que el estado de los equipos sea consistente, según se indica en el topic:280 del foro.
git-svn-id: https://opengnsys.es/svn/branches/version1.1@5009 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 63c795c6..e69b66f7 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -496,7 +496,8 @@ CREATE TABLE IF NOT EXISTS `ordenadores` ( `paginalogin` varchar(100), `paginavalidacion` varchar(100), `agentkey` varchar(32), - PRIMARY KEY (`idordenador`) + PRIMARY KEY (`idordenador`), + KEY `idaulaip` (`idaula` ASC, `ip` ASC) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |