# HG changeset patch
# User Daniel Poelzleithner <poelzi@poelzi.org>
# Date 1286504983 -7200
# Node ID dfa8e6a1f1e72edc8cca28ebb218fb3f9f11bfd7
# Parent  ca13b2614d101692c6f44077145bdf6ff2fe2fdc
add usefull index

diff -r ca13b2614d10 -r dfa8e6a1f1e7 core.sql
--- a/core.sql	Fri Oct 08 01:57:10 2010 +0200
+++ b/core.sql	Fri Oct 08 04:29:43 2010 +0200
@@ -446,6 +446,7 @@
           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"
diff -r ca13b2614d10 -r dfa8e6a1f1e7 update/core-update.v1.2.8-v1.2.9.sql
--- a/update/core-update.v1.2.8-v1.2.9.sql	Fri Oct 08 01:57:10 2010 +0200
+++ b/update/core-update.v1.2.8-v1.2.9.sql	Fri Oct 08 04:29:43 2010 +0200
@@ -98,4 +98,6 @@
 
 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;