Commits

Daniel Poelzleithner committed dfa8e6a

add usefull index

Comments (0)

Files changed (2)

           CHECK (("agreed" NOTNULL AND "agreed" = TRUE) OR "rank" ISNULL) );
 CREATE INDEX "initiative_created_idx" ON "initiative" ("created");
 CREATE INDEX "initiative_revoked_idx" ON "initiative" ("revoked");
+CREATE INDEX "initiative_issue_id_idx" ON "initiative" ("issue_id");
 CREATE INDEX "initiative_text_search_data_idx" ON "initiative" USING gin ("text_search_data");
 CREATE TRIGGER "update_text_search_data"
   BEFORE INSERT OR UPDATE ON "initiative"

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

 
 COMMENT ON FUNCTION "delete_member"("member_id_p" "member"."id"%TYPE) IS 'Deactivate member and clear certain settings and data of this member (data protection)';
 
+CREATE INDEX "initiative_issue_id_idx" ON "initiative" ("issue_id");
+
 COMMIT;