From b0e1d67229578dec7cda7e433a326831cdb14f18 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Tue, 29 Sep 2009 11:20:15 -0400 Subject: [PATCH] Add sql script updates --- kronolith/scripts/sql/kronolith.mssql.sql | 13 +++++++++++++ kronolith/scripts/sql/kronolith.oci8.sql | 13 +++++++++++++ kronolith/scripts/sql/kronolith.pgsql.sql | 13 +++++++++++++ kronolith/scripts/sql/kronolith.sql | 10 +++++++--- 4 files changed, 46 insertions(+), 3 deletions(-) diff --git a/kronolith/scripts/sql/kronolith.mssql.sql b/kronolith/scripts/sql/kronolith.mssql.sql index 3c5377453..662de9a62 100644 --- a/kronolith/scripts/sql/kronolith.mssql.sql +++ b/kronolith/scripts/sql/kronolith.mssql.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 VARCHAR(MAX), + resource_category VARCHAR(255) DEFAULT '', + resource_response_type INT DEFAULT 0, + resource_type VARCHAR(255) NOT NULL, + resource_members BLOB, + + PRIMARY KEY (resource_id) +); diff --git a/kronolith/scripts/sql/kronolith.oci8.sql b/kronolith/scripts/sql/kronolith.oci8.sql index 237034ff9..9cc5b6e8f 100644 --- a/kronolith/scripts/sql/kronolith.oci8.sql +++ b/kronolith/scripts/sql/kronolith.oci8.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 CLOB, + resource_category VARCHAR(255) DEFAULT '', + resource_response_type INT DEFAULT 0, + resource_type VARCHAR(255) NOT NULL, + resource_members CLOB, + + PRIMARY KEY (resource_id) +); diff --git a/kronolith/scripts/sql/kronolith.pgsql.sql b/kronolith/scripts/sql/kronolith.pgsql.sql index 9af38a324..76c67e4f4 100644 --- a/kronolith/scripts/sql/kronolith.pgsql.sql +++ b/kronolith/scripts/sql/kronolith.pgsql.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) DEFAULT '', + resource_response_type INT DEFAULT 0, + resource_type VARCHAR(255) NOT NULL, + resource_members TEXT, + + PRIMARY KEY (resource_id) +); diff --git a/kronolith/scripts/sql/kronolith.sql b/kronolith/scripts/sql/kronolith.sql index 507054bfe..94c064786 100644 --- a/kronolith/scripts/sql/kronolith.sql +++ b/kronolith/scripts/sql/kronolith.sql @@ -80,12 +80,16 @@ CREATE INDEX kronolith_shares_users_share_id_idx ON kronolith_shares_users (shar 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 { +CREATE TABLE kronolith_resources ( resource_id INT NOT NULL, resource_name VARCHAR(255), resource_calendar VARCHAR(255), - resource_category VARCHAR(255), + resource_description TEXT, + resource_category VARCHAR(255) DEFAULT '', + resource_response_type INT DEFAULT 0, + resource_type VARCHAR(255) NOT NULL, + resource_members BLOB, - PRIMARY_KEY (resource_uid) + PRIMARY KEY (resource_id) ); \ No newline at end of file -- 2.11.0