diff options
| author | ramon <ramongomez@us.es> | 2016-01-13 10:19:24 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2016-01-13 10:19:24 +0000 |
| commit | b0cd6afeb70bf112734cb25cc7a63b1227f0060d (patch) | |
| tree | e2490cf0abe8c682f412eb9daff6ec83a9b2a5ea /admin | |
| parent | 077d8df15f977882852020adfe5abc6a6c122b24 (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')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0pre.sql | 2 |
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; |