liquid_feedback_core

changeset 81:dfa8e6a1f1e7

add usefull index
author Daniel Poelzleithner <poelzi@poelzi.org>
date Fri Oct 08 04:29:43 2010 +0200 (2010-10-08)
parents ca13b2614d10
children 7744034552a3
files core.sql update/core-update.v1.2.8-v1.2.9.sql
line diff
     1.1 --- a/core.sql	Fri Oct 08 01:57:10 2010 +0200
     1.2 +++ b/core.sql	Fri Oct 08 04:29:43 2010 +0200
     1.3 @@ -446,6 +446,7 @@
     1.4            CHECK (("agreed" NOTNULL AND "agreed" = TRUE) OR "rank" ISNULL) );
     1.5  CREATE INDEX "initiative_created_idx" ON "initiative" ("created");
     1.6  CREATE INDEX "initiative_revoked_idx" ON "initiative" ("revoked");
     1.7 +CREATE INDEX "initiative_issue_id_idx" ON "initiative" ("issue_id");
     1.8  CREATE INDEX "initiative_text_search_data_idx" ON "initiative" USING gin ("text_search_data");
     1.9  CREATE TRIGGER "update_text_search_data"
    1.10    BEFORE INSERT OR UPDATE ON "initiative"
     2.1 --- a/update/core-update.v1.2.8-v1.2.9.sql	Fri Oct 08 01:57:10 2010 +0200
     2.2 +++ b/update/core-update.v1.2.8-v1.2.9.sql	Fri Oct 08 04:29:43 2010 +0200
     2.3 @@ -98,4 +98,6 @@
     2.4  
     2.5  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)';
     2.6  
     2.7 +CREATE INDEX "initiative_issue_id_idx" ON "initiative" ("issue_id");
     2.8 +
     2.9  COMMIT;

Impressum / About Us