From df92eece251eaf6dd860962556997ebbc38754b8 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Thu, 22 Oct 2009 18:34:39 +0200 Subject: [PATCH] Add kronolith_resources.. --- kronolith/scripts/sql/kronolith.mysql.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/kronolith/scripts/sql/kronolith.mysql.sql b/kronolith/scripts/sql/kronolith.mysql.sql index 460f2648f..2b7e0c340 100644 --- a/kronolith/scripts/sql/kronolith.mysql.sql +++ b/kronolith/scripts/sql/kronolith.mysql.sql @@ -79,3 +79,16 @@ 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_id INT NOT NULL, + resource_name VARCHAR(255), + resource_calendar VARCHAR(255), + resource_description TEXT, + resource_category VARCHAR(255), + resource_response_type INT, + resource_type VARCHAR(255) NOT NULL, + resource_members BLOB, + + PRIMARY KEY (resource_id) +); -- 2.11.0