1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/core-update.v1.2.7-v1.2.8.sql	Tue Sep 07 21:08:23 2010 +0200
     1.3 @@ -0,0 +1,16 @@
     1.4 +BEGIN;
     1.5 + 
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('1.2.8', 1, 2, 8))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +ALTER TABLE "delegation" DROP CONSTRAINT "delegation_area_id_key";
    1.11 +ALTER TABLE "delegation" DROP CONSTRAINT "delegation_issue_id_key";
    1.12 +DROP INDEX "delegation_global_truster_id_trustee_id_unique_idx";
    1.13 +
    1.14 +ALTER TABLE "delegation" ADD UNIQUE ("area_id", "truster_id");
    1.15 +ALTER TABLE "delegation" ADD UNIQUE ("issue_id", "truster_id");
    1.16 +CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx"
    1.17 +  ON "delegation" ("truster_id") WHERE "scope" = 'global';
    1.18 +
    1.19 +COMMIT;