From cf3c705a70c95975766483cb17c53cdde2d0ad0b Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Fri, 23 Oct 2009 00:25:03 +0200 Subject: [PATCH] Make this a new script. --- kronolith/scripts/upgrades/2009-10-22_resource_indexes.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 kronolith/scripts/upgrades/2009-10-22_resource_indexes.sql diff --git a/kronolith/scripts/upgrades/2009-10-22_resource_indexes.sql b/kronolith/scripts/upgrades/2009-10-22_resource_indexes.sql new file mode 100644 index 000000000..36d08f62b --- /dev/null +++ b/kronolith/scripts/upgrades/2009-10-22_resource_indexes.sql @@ -0,0 +1,3 @@ +ALTER TABLE kronolith_resources DROP resource_category; +CREATE INDEX kronolith_resources_type ON kronolith_resources (resource_type); +CREATE INDEX kronolith_resources_calendar ON kronolith_resources (resource_calendar); -- 2.11.0