Changeset:
f0c0d29e6786
https://sourceforge.net/p/mrbs/hg-code/ci/f0c0d29e6786d6714d8b9e5da638de7cbd6034e9
Author:
Campbell Morrison <[email protected]>
Date:
Fri Sep 18 12:51:35 2015 +0100
Log message:
Fixed bug causing problem upgrading when using PostgreSQL with $db_schema
defined
diffstat:
web/upgrade/44/pgsql.sql | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diffs (25 lines):
diff -r a514d91d9117 -r f0c0d29e6786 web/upgrade/44/pgsql.sql
--- a/web/upgrade/44/pgsql.sql Thu Sep 17 21:37:10 2015 +0100
+++ b/web/upgrade/44/pgsql.sql Fri Sep 18 12:51:35 2015 +0100
@@ -3,16 +3,16 @@
-- Add some UNIQUE constraints
ALTER TABLE %DB_TBL_PREFIX%room
- ADD CONSTRAINT %DB_TBL_PREFIX%uq_room_name UNIQUE (area_id, room_name);
+ ADD CONSTRAINT "%DB_TBL_PREFIX%uq_room_name" UNIQUE (area_id, room_name);
ALTER TABLE %DB_TBL_PREFIX%area
- ADD CONSTRAINT %DB_TBL_PREFIX%uq_area_name UNIQUE (area_name);
+ ADD CONSTRAINT "%DB_TBL_PREFIX%uq_area_name" UNIQUE (area_name);
ALTER TABLE %DB_TBL_PREFIX%users
- ADD CONSTRAINT %DB_TBL_PREFIX%uq_name UNIQUE (name);
+ ADD CONSTRAINT "%DB_TBL_PREFIX%uq_name" UNIQUE (name);
ALTER TABLE %DB_TBL_PREFIX%variables
- ADD CONSTRAINT %DB_TBL_PREFIX%uq_variable_name UNIQUE (variable_name);
+ ADD CONSTRAINT "%DB_TBL_PREFIX%uq_variable_name" UNIQUE (variable_name);
ALTER TABLE %DB_TBL_PREFIX%zoneinfo
- ADD CONSTRAINT %DB_TBL_PREFIX%uq_timezone UNIQUE (timezone,
outlook_compatible);
+ ADD CONSTRAINT "%DB_TBL_PREFIX%uq_timezone" UNIQUE (timezone,
outlook_compatible);
------------------------------------------------------------------------------
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
