From 735c6fdfbd2844064ca101cd49887b8dc7388015 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Mon, 17 Aug 2009 13:43:18 -0400 Subject: [PATCH] add sql upgrade script and update creation scripts for resource field --- kronolith/scripts/sql/kronolith.mssql.sql | 1 + kronolith/scripts/sql/kronolith.mysql.sql | 1 + kronolith/scripts/sql/kronolith.oci8.sql | 1 + kronolith/scripts/sql/kronolith.pgsql.sql | 1 + kronolith/scripts/sql/kronolith.sql | 1 + kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql | 1 + 6 files changed, 6 insertions(+) create mode 100644 kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql diff --git a/kronolith/scripts/sql/kronolith.mssql.sql b/kronolith/scripts/sql/kronolith.mssql.sql index b22798fca..3c5377453 100644 --- a/kronolith/scripts/sql/kronolith.mssql.sql +++ b/kronolith/scripts/sql/kronolith.mssql.sql @@ -7,6 +7,7 @@ CREATE TABLE kronolith_events ( event_location VARCHAR(MAX), event_status INT DEFAULT 0, event_attendees VARCHAR(MAX), + event_resources VARCHAR(MAX), event_exceptions VARCHAR(MAX), event_title VARCHAR(255), event_recurtype INT DEFAULT 0, diff --git a/kronolith/scripts/sql/kronolith.mysql.sql b/kronolith/scripts/sql/kronolith.mysql.sql index 92e3073c2..e8ef3d708 100644 --- a/kronolith/scripts/sql/kronolith.mysql.sql +++ b/kronolith/scripts/sql/kronolith.mysql.sql @@ -7,6 +7,7 @@ CREATE TABLE kronolith_events ( event_location TEXT, event_status INT DEFAULT 0, event_attendees TEXT, + event_resources TEXT, event_exceptions TEXT, event_title VARCHAR(255), event_recurtype SMALLINT DEFAULT 0, diff --git a/kronolith/scripts/sql/kronolith.oci8.sql b/kronolith/scripts/sql/kronolith.oci8.sql index 2af01c86d..237034ff9 100644 --- a/kronolith/scripts/sql/kronolith.oci8.sql +++ b/kronolith/scripts/sql/kronolith.oci8.sql @@ -7,6 +7,7 @@ CREATE TABLE kronolith_events ( event_location VARCHAR2(4000), event_status INT DEFAULT 0, event_attendees VARCHAR2(4000), + event_resources VARCHAR2(4000), event_exceptions VARCHAR2(4000), event_title VARCHAR2(255), event_recurtype INT DEFAULT 0, diff --git a/kronolith/scripts/sql/kronolith.pgsql.sql b/kronolith/scripts/sql/kronolith.pgsql.sql index e83c044a8..9af38a324 100644 --- a/kronolith/scripts/sql/kronolith.pgsql.sql +++ b/kronolith/scripts/sql/kronolith.pgsql.sql @@ -7,6 +7,7 @@ CREATE TABLE kronolith_events ( event_location TEXT, event_status INT DEFAULT 0, event_attendees TEXT, + event_resources TEXT, event_exceptions TEXT, event_title VARCHAR(255), event_recurtype SMALLINT DEFAULT 0, diff --git a/kronolith/scripts/sql/kronolith.sql b/kronolith/scripts/sql/kronolith.sql index e938cd674..167c5b10a 100644 --- a/kronolith/scripts/sql/kronolith.sql +++ b/kronolith/scripts/sql/kronolith.sql @@ -7,6 +7,7 @@ CREATE TABLE kronolith_events ( event_location TEXT, event_status INT DEFAULT 0, event_attendees TEXT, + event_resources TEXT, event_exceptions TEXT, event_title VARCHAR(255), event_recurtype INT DEFAULT 0, diff --git a/kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql b/kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql new file mode 100644 index 000000000..093195b0e --- /dev/null +++ b/kronolith/scripts/upgrades/2009-08-17_add_resource_field.sql @@ -0,0 +1 @@ +ALTER TABLE kronolith_events ADD event_resources TEXT; -- 2.11.0