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;