liquid_feedback_core

diff core.sql @ 81:dfa8e6a1f1e7

find changesets by author, revision, files, or words in the commit message
add usefull index
author Daniel Poelzleithner <poelzi@poelzi.org>
date Fri Oct 08 04:29:43 2010 +0200 (2010-10-08)
parents ca13b2614d10
children bb04e4d1c68c
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"

Impressum / About Us