# HG changeset patch
# User jbe
# Date 1283886503 -7200
# Node ID 1d4c2f9ff9d82af65ddfdc42cc79a948d8733e67
# Parent  b95f2b9cb1441588174361ea63b274acb89f4de3
Fixed unique constraints in table "delegation"; Update script to v1.2.8

diff -r b95f2b9cb144 -r 1d4c2f9ff9d8 core.sql
--- a/core.sql	Mon Aug 30 23:49:54 2010 +0200
+++ b/core.sql	Tue Sep 07 21:08:23 2010 +0200
@@ -6,7 +6,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('1.2.7', 1, 2, 7))
+  SELECT * FROM (VALUES ('1.2.8', 1, 2, 8))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -656,10 +656,10 @@
           ("scope" = 'global' AND "area_id" ISNULL  AND "issue_id" ISNULL ) OR
           ("scope" = 'area'   AND "area_id" NOTNULL AND "issue_id" ISNULL ) OR
           ("scope" = 'issue'  AND "area_id" ISNULL  AND "issue_id" NOTNULL) ),
-        UNIQUE ("area_id", "truster_id", "trustee_id"),
-        UNIQUE ("issue_id", "truster_id", "trustee_id") );
+        UNIQUE ("area_id", "truster_id"),
+        UNIQUE ("issue_id", "truster_id") );
 CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx"
-  ON "delegation" ("truster_id", "trustee_id") WHERE "scope" = 'global';
+  ON "delegation" ("truster_id") WHERE "scope" = 'global';
 CREATE INDEX "delegation_truster_id_idx" ON "delegation" ("truster_id");
 CREATE INDEX "delegation_trustee_id_idx" ON "delegation" ("trustee_id");
 
diff -r b95f2b9cb144 -r 1d4c2f9ff9d8 update/core-update.v1.2.7-v1.2.8.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/update/core-update.v1.2.7-v1.2.8.sql	Tue Sep 07 21:08:23 2010 +0200
@@ -0,0 +1,16 @@
+BEGIN;
+ 
+CREATE OR REPLACE VIEW "liquid_feedback_version" AS
+  SELECT * FROM (VALUES ('1.2.8', 1, 2, 8))
+  AS "subquery"("string", "major", "minor", "revision");
+
+ALTER TABLE "delegation" DROP CONSTRAINT "delegation_area_id_key";
+ALTER TABLE "delegation" DROP CONSTRAINT "delegation_issue_id_key";
+DROP INDEX "delegation_global_truster_id_trustee_id_unique_idx";
+
+ALTER TABLE "delegation" ADD UNIQUE ("area_id", "truster_id");
+ALTER TABLE "delegation" ADD UNIQUE ("issue_id", "truster_id");
+CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx"
+  ON "delegation" ("truster_id") WHERE "scope" = 'global';
+
+COMMIT;