From fa82a4caa07630ba88a7761ef90bce5bed625cc8 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Mon, 17 Aug 2009 14:37:53 -0400 Subject: [PATCH] add kronolith_resource table --- kronolith/scripts/sql/kronolith.sql | 10 ++++++++++ kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql | 9 +++++++++ 2 files changed, 19 insertions(+) diff --git a/kronolith/scripts/sql/kronolith.sql b/kronolith/scripts/sql/kronolith.sql index 167c5b10a..37b2f180a 100644 --- a/kronolith/scripts/sql/kronolith.sql +++ b/kronolith/scripts/sql/kronolith.sql @@ -79,3 +79,13 @@ CREATE TABLE kronolith_shares_users ( CREATE INDEX kronolith_shares_users_share_id_idx ON kronolith_shares_users (share_id); CREATE INDEX kronolith_shares_users_user_uid_idx ON kronolith_shares_users (user_uid); CREATE INDEX kronolith_shares_users_perm_idx ON kronolith_shares_users (perm); + +CREATE TABLE kronolith_resources { + resource_uid INT NOT NULL, + resource_name VARCHAR(255), + resource_calendar VARCHAR(255), + resource_category VARCHAR(255), + + PRIMARY_KEY (resource_uid) +); + \ No newline at end of file diff --git a/kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql b/kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql index 093195b0e..655fcaacd 100644 --- a/kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql +++ b/kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql @@ -1 +1,10 @@ ALTER TABLE kronolith_events ADD event_resources TEXT; + +CREATE TABLE kronolith_resources ( + resource_uid INT NOT NULL, + resource_name VARCHAR(255), + resource_calendar VARCHAR(255), + resource_category VARCHAR(255), + + PRIMARY KEY (resource_uid) +); -- 2.11.0