diff options
| author | ramon <ramongomez@us.es> | 2016-11-18 11:52:00 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2016-11-18 11:52:00 +0000 |
| commit | 0cfe47a57c12950dd73c5e876e457e9a9674d81d (patch) | |
| tree | c401102486cd2b0adbd98b50bc037a6c85c23c8d /admin/Database | |
| parent | 7b3dc7ab2fcebebef7229ac663a3d3ee61263d0e (diff) | |
#765: Corregir errata en revisión r5097 en camino de ficheros SQL y evitar duplicado de índice.
git-svn-id: https://opengnsys.es/svn/branches/version1.1@5100 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0pre.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0pre.sql b/admin/Database/ogAdmBD-1.1.0pre.sql index a761e26c..5f8c0262 100644 --- a/admin/Database/ogAdmBD-1.1.0pre.sql +++ b/admin/Database/ogAdmBD-1.1.0pre.sql @@ -50,8 +50,8 @@ CREATE PROCEDURE addcols() BEGIN ADD agentkey VARCHAR(32) DEFAULT NULL; END IF; # Añadir índice para mostrar correctamente el formulario de estado. - IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS - WHERE COLUMN_NAME='idaulaip' AND TABLE_NAME='ordenadores' AND TABLE_SCHEMA=DATABASE()) + IF NOT EXISTS (SELECT * FROM information_schema.STATISTICS + WHERE INDEX_NAME='idaulaip' AND TABLE_NAME='ordenadores' AND TABLE_SCHEMA=DATABASE()) THEN ALTER TABLE ordenadores ADD KEY idaulaip (idaula ASC, ip ASC); |