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;