From 4fc8a25fcbc6b0a34837e4bd2c5bc1d9d10ff86e Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Fri, 23 Oct 2009 00:21:43 +0200 Subject: [PATCH] Make this a new script. --- kronolith/scripts/upgrades/2009-08-17_add_resources.sql | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/kronolith/scripts/upgrades/2009-08-17_add_resources.sql b/kronolith/scripts/upgrades/2009-08-17_add_resources.sql index ba5a2cbfc..44fe81634 100644 --- a/kronolith/scripts/upgrades/2009-08-17_add_resources.sql +++ b/kronolith/scripts/upgrades/2009-08-17_add_resources.sql @@ -5,12 +5,10 @@ CREATE TABLE kronolith_resources ( resource_name VARCHAR(255), resource_calendar VARCHAR(255), resource_description TEXT, - resource_response_type INT, + resource_category VARCHAR(255) DEFAULT '', + resource_response_type INT DEFAULT 0, resource_type VARCHAR(255) NOT NULL, - resource_members TEXT, --- + resource_members BLOB, + PRIMARY KEY (resource_id) ); - -CREATE INDEX kronolith_resources_type_idx ON kronolith_resources (resource_type); -CREATE INDEX kronolith_resources_calendar_idx ON kronolith_resources (resource_calendar); \ No newline at end of file -- 2.11.0