# HG changeset patch # User jbe # Date 1283887218 -7200 # Node ID f77c0f3d443c79d7c70e3f5075b31a9afe6ff4cb # Parent 1d4c2f9ff9d82af65ddfdc42cc79a948d8733e67 Renamed "delegation_global_truster_id_trustee_id_unique_idx" to "delegation_global_truster_id_unique_idx" in core.sql and update script diff -r 1d4c2f9ff9d8 -r f77c0f3d443c core.sql --- a/core.sql Tue Sep 07 21:08:23 2010 +0200 +++ b/core.sql Tue Sep 07 21:20:18 2010 +0200 @@ -658,7 +658,7 @@ ("scope" = 'issue' AND "area_id" ISNULL AND "issue_id" NOTNULL) ), UNIQUE ("area_id", "truster_id"), UNIQUE ("issue_id", "truster_id") ); -CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx" +CREATE UNIQUE INDEX "delegation_global_truster_id_unique_idx" ON "delegation" ("truster_id") WHERE "scope" = 'global'; CREATE INDEX "delegation_truster_id_idx" ON "delegation" ("truster_id"); CREATE INDEX "delegation_trustee_id_idx" ON "delegation" ("trustee_id"); diff -r 1d4c2f9ff9d8 -r f77c0f3d443c update/core-update.v1.2.7-v1.2.8.sql --- a/update/core-update.v1.2.7-v1.2.8.sql Tue Sep 07 21:08:23 2010 +0200 +++ b/update/core-update.v1.2.7-v1.2.8.sql Tue Sep 07 21:20:18 2010 +0200 @@ -10,7 +10,7 @@ ALTER TABLE "delegation" ADD UNIQUE ("area_id", "truster_id"); ALTER TABLE "delegation" ADD UNIQUE ("issue_id", "truster_id"); -CREATE UNIQUE INDEX "delegation_global_truster_id_trustee_id_unique_idx" +CREATE UNIQUE INDEX "delegation_global_truster_id_unique_idx" ON "delegation" ("truster_id") WHERE "scope" = 'global'; COMMIT;