Commits

Anonymous committed f77c0f3

Renamed "delegation_global_truster_id_trustee_id_unique_idx" to "delegation_global_truster_id_unique_idx" in core.sql and update script

Comments (0)

Files changed (2)

           ("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");

update/core-update.v1.2.7-v1.2.8.sql

 
 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;