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;

Impressum / About Us