liquid_feedback_core

changeset 75:f77c0f3d443c v1.2.8

Renamed "delegation_global_truster_id_trustee_id_unique_idx" to "delegation_global_truster_id_unique_idx" in core.sql and update script
author jbe
date Tue Sep 07 21:20:18 2010 +0200 (2010-09-07)
parents 1d4c2f9ff9d8
children f37b47c23a5d e588fdf1676e
files core.sql update/core-update.v1.2.7-v1.2.8.sql
line diff
     1.1 --- a/core.sql	Tue Sep 07 21:08:23 2010 +0200
     1.2 +++ b/core.sql	Tue Sep 07 21:20:18 2010 +0200
     1.3 @@ -658,7 +658,7 @@
     1.4            ("scope" = 'issue'  AND "area_id" ISNULL  AND "issue_id" NOTNULL) ),
     1.5          UNIQUE ("area_id", "truster_id"),
     1.6          UNIQUE ("issue_id", "truster_id") );
     1.7 -CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx"
     1.8 +CREATE UNIQUE INDEX "delegation_global_truster_id_unique_idx"
     1.9    ON "delegation" ("truster_id") WHERE "scope" = 'global';
    1.10  CREATE INDEX "delegation_truster_id_idx" ON "delegation" ("truster_id");
    1.11  CREATE INDEX "delegation_trustee_id_idx" ON "delegation" ("trustee_id");
     2.1 --- a/update/core-update.v1.2.7-v1.2.8.sql	Tue Sep 07 21:08:23 2010 +0200
     2.2 +++ b/update/core-update.v1.2.7-v1.2.8.sql	Tue Sep 07 21:20:18 2010 +0200
     2.3 @@ -10,7 +10,7 @@
     2.4  
     2.5  ALTER TABLE "delegation" ADD UNIQUE ("area_id", "truster_id");
     2.6  ALTER TABLE "delegation" ADD UNIQUE ("issue_id", "truster_id");
     2.7 -CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx"
     2.8 +CREATE UNIQUE INDEX "delegation_global_truster_id_unique_idx"
     2.9    ON "delegation" ("truster_id") WHERE "scope" = 'global';
    2.10  
    2.11  COMMIT;

Impressum / About Us