From 3da92686e8a3d2f70272fd7c26660b83c1884427 Mon Sep 17 00:00:00 2001 From: moodler Date: Thu, 15 Jul 2004 05:57:55 +0000 Subject: [PATCH] Added patch for bug 1514 to add prefix onto constraints --- lib/db/postgres7.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql index d21c60ce3e..9f04818d6d 100644 --- a/lib/db/postgres7.sql +++ b/lib/db/postgres7.sql @@ -2,7 +2,7 @@ CREATE TABLE prefix_config ( id SERIAL PRIMARY KEY, name varchar(255) NOT NULL default '', value text NOT NULL default '', - CONSTRAINT config_name_uk UNIQUE (name) + CONSTRAINT prefix_config_name_uk UNIQUE (name) ); CREATE TABLE prefix_course ( @@ -230,7 +230,7 @@ CREATE TABLE prefix_user ( htmleditor integer NOT NULL default '1', autosubscribe integer NOT NULL default '1', timemodified integer NOT NULL default '0', - CONSTRAINT user_username_uk UNIQUE (username) + CONSTRAINT prefix_user_username_uk UNIQUE (username) ); CREATE TABLE prefix_user_admins ( -- 2.39.5