summaryrefslogtreecommitdiffstats
path: root/admin/Database
diff options
context:
space:
mode:
authorramon <ramongomez@us.es>2016-01-13 10:19:24 +0000
committerramon <ramongomez@us.es>2016-01-13 10:19:24 +0000
commitb0cd6afeb70bf112734cb25cc7a63b1227f0060d (patch)
treee2490cf0abe8c682f412eb9daff6ec83a9b2a5ea /admin/Database
parent077d8df15f977882852020adfe5abc6a6c122b24 (diff)
#678: Corregir errata al actualizar la BD en la versiĆ³n 1.1
git-svn-id: https://opengnsys.es/svn/branches/version1.1@4772 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database')
-rw-r--r--admin/Database/ogAdmBD-1.1.0pre.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0pre.sql b/admin/Database/ogAdmBD-1.1.0pre.sql
index 4900c3f4..51e9910a 100644
--- a/admin/Database/ogAdmBD-1.1.0pre.sql
+++ b/admin/Database/ogAdmBD-1.1.0pre.sql
@@ -59,11 +59,13 @@ CREATE PROCEDURE addcols() BEGIN
# Directorios en repo para distintas UO (ticket #678).
IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS
WHERE COLUMN_NAME='ogunit' AND TABLE_NAME='entidades' AND TABLE_SCHEMA=DATABASE())
+ THEN
ALTER TABLE entidades
ADD ogunit TINYINT(1) NOT NULL DEFAULT 0;
END IF;
IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS
WHERE COLUMN_NAME='directorio' AND TABLE_NAME='centros' AND TABLE_SCHEMA=DATABASE())
+ THEN
ALTER TABLE centros
ADD directorio VARCHAR(50) DEFAULT '';
END IF;