liquid_feedback_core
changeset 74:1d4c2f9ff9d8
Fixed unique constraints in table "delegation"; Update script to v1.2.8
author | jbe |
---|---|
date | Tue Sep 07 21:08:23 2010 +0200 (2010-09-07) |
parents | b95f2b9cb144 |
children | f77c0f3d443c |
files | core.sql update/core-update.v1.2.7-v1.2.8.sql |
line diff
1.1 --- a/core.sql Mon Aug 30 23:49:54 2010 +0200 1.2 +++ b/core.sql Tue Sep 07 21:08:23 2010 +0200 1.3 @@ -6,7 +6,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('1.2.7', 1, 2, 7)) 1.8 + SELECT * FROM (VALUES ('1.2.8', 1, 2, 8)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -656,10 +656,10 @@ 1.13 ("scope" = 'global' AND "area_id" ISNULL AND "issue_id" ISNULL ) OR 1.14 ("scope" = 'area' AND "area_id" NOTNULL AND "issue_id" ISNULL ) OR 1.15 ("scope" = 'issue' AND "area_id" ISNULL AND "issue_id" NOTNULL) ), 1.16 - UNIQUE ("area_id", "truster_id", "trustee_id"), 1.17 - UNIQUE ("issue_id", "truster_id", "trustee_id") ); 1.18 + UNIQUE ("area_id", "truster_id"), 1.19 + UNIQUE ("issue_id", "truster_id") ); 1.20 CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx" 1.21 - ON "delegation" ("truster_id", "trustee_id") WHERE "scope" = 'global'; 1.22 + ON "delegation" ("truster_id") WHERE "scope" = 'global'; 1.23 CREATE INDEX "delegation_truster_id_idx" ON "delegation" ("truster_id"); 1.24 CREATE INDEX "delegation_trustee_id_idx" ON "delegation" ("trustee_id"); 1.25
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/update/core-update.v1.2.7-v1.2.8.sql Tue Sep 07 21:08:23 2010 +0200 2.3 @@ -0,0 +1,16 @@ 2.4 +BEGIN; 2.5 + 2.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS 2.7 + SELECT * FROM (VALUES ('1.2.8', 1, 2, 8)) 2.8 + AS "subquery"("string", "major", "minor", "revision"); 2.9 + 2.10 +ALTER TABLE "delegation" DROP CONSTRAINT "delegation_area_id_key"; 2.11 +ALTER TABLE "delegation" DROP CONSTRAINT "delegation_issue_id_key"; 2.12 +DROP INDEX "delegation_global_truster_id_trustee_id_unique_idx"; 2.13 + 2.14 +ALTER TABLE "delegation" ADD UNIQUE ("area_id", "truster_id"); 2.15 +ALTER TABLE "delegation" ADD UNIQUE ("issue_id", "truster_id"); 2.16 +CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx" 2.17 + ON "delegation" ("truster_id") WHERE "scope" = 'global'; 2.18 + 2.19 +COMMIT;