liquid_feedback_core
changeset 591:d955519f7471
Renamed indices on issue to match naming convention
| author | jbe | 
|---|---|
| date | Fri Dec 07 17:49:53 2018 +0100 (2018-12-07) | 
| parents | c918d08f5a80 | 
| children | 332a2177e208 | 
| files | core.sql | 
   line diff
1.1 --- a/core.sql Fri Dec 07 15:57:34 2018 +0100 1.2 +++ b/core.sql Fri Dec 07 17:49:53 2018 +0100 1.3 @@ -872,10 +872,10 @@ 1.4 CREATE INDEX "issue_closed_idx" ON "issue" ("closed"); 1.5 CREATE INDEX "issue_created_idx_open" ON "issue" ("created") WHERE "closed" ISNULL; 1.6 CREATE INDEX "issue_closed_idx_canceled" ON "issue" ("closed") WHERE "fully_frozen" ISNULL; 1.7 -CREATE INDEX "issue_latest_snapshot_id" ON "issue" ("latest_snapshot_id"); 1.8 -CREATE INDEX "issue_admission_snapshot_id" ON "issue" ("admission_snapshot_id"); 1.9 -CREATE INDEX "issue_half_freeze_snapshot_id" ON "issue" ("half_freeze_snapshot_id"); 1.10 -CREATE INDEX "issue_full_freeze_snapshot_id" ON "issue" ("full_freeze_snapshot_id"); 1.11 +CREATE INDEX "issue_latest_snapshot_id_idx" ON "issue" ("latest_snapshot_id"); 1.12 +CREATE INDEX "issue_admission_snapshot_id_idx" ON "issue" ("admission_snapshot_id"); 1.13 +CREATE INDEX "issue_half_freeze_snapshot_id_idx" ON "issue" ("half_freeze_snapshot_id"); 1.14 +CREATE INDEX "issue_full_freeze_snapshot_id_idx" ON "issue" ("full_freeze_snapshot_id"); 1.15 1.16 COMMENT ON TABLE "issue" IS 'Groups of initiatives'; 1.17