# HG changeset patch
# User jbe
# Date 1330179754 -3600
# Node ID ae08a20808d410af3ff8131d0b5240161fb78251
# Parent  cd5fa6c46e13cf91bf2026db848d517ab9074db4
Added index on "event"."occurrence"

diff -r cd5fa6c46e13 -r ae08a20808d4 core.sql
--- a/core.sql	Sat Feb 25 15:13:01 2012 +0100
+++ b/core.sql	Sat Feb 25 15:22:34 2012 +0100
@@ -1159,7 +1159,7 @@
             "initiative_id" NOTNULL AND
             "draft_id"      ISNULL  AND
             "suggestion_id" NOTNULL )) );
--- TODO: indicies
+CREATE INDEX "event_occurrence_idx" ON "event" ("occurrence");
 
 COMMENT ON TABLE "event" IS 'Event table, automatically filled by triggers';