From 2e1898b21ce1b6f9edd7c6a1e1ee62a89866379d Mon Sep 17 00:00:00 2001
From: mjollnir_ <mjollnir_>
Date: Tue, 21 Dec 2004 18:30:19 +0000
Subject: [PATCH] Merged from MOODLE_14_STABLE: Fixing postgres bug on unique
 constraint

---
 lib/db/postgres7.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index c2599d4f2f..e176e9dd4b 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -299,8 +299,7 @@ CREATE TABLE prefix_user (
    maildisplay integer NOT NULL default '2',
    htmleditor integer NOT NULL default '1',
    autosubscribe integer NOT NULL default '1',
-   timemodified integer NOT NULL default '0',
-   CONSTRAINT prefix_user_username_uk UNIQUE (username)
+   timemodified integer NOT NULL default '0'
 );
 
 CREATE UNIQUE INDEX prefix_user_username_uk ON prefix_user (username);
-- 
2.39.5