plugins/calendar

[Thomas Brüderli]

 plugins/calendar/UPGRADING                                     |   11 +++++++
 plugins/calendar/drivers/database/sql/mysql.upgrade-0.7.sql    |    5 +++
 plugins/calendar/drivers/database/sql/postgres.upgrade-0.7.sql |    5 +++
 plugins/calendar/drivers/kolab/SQL/mysql.upgrade-0.7.sql       |   15 ++++++++++
 plugins/calendar/package.xml                                   |    6 ++--
 5 files changed, 39 insertions(+), 3 deletions(-)

New commits:
commit e292aec5dcc71cbac4f79abf0ee3bae494c3d91b
Author: Thomas Bruederli <bruederli at kolabsys.com>
Date:   Thu Nov 8 12:18:28 2012 +0100

    Added upgrading instructions for the calendar module (#1179)

diff --git a/plugins/calendar/UPGRADING b/plugins/calendar/UPGRADING
new file mode 100644
index 0000000..3038233
--- /dev/null
+++ b/plugins/calendar/UPGRADING
@@ -0,0 +1,11 @@
+UPGRADING instructions
+======================
+
+From version 0.7 and 0.8
+------------------------
+
+The schemas of the backend databases have changed. Depending on the driver
+you're using, please execute all statements from divers/<driver>/sql/<db>.upgrade-0.7.sql
+on your local database.
+
+
diff --git a/plugins/calendar/drivers/database/sql/mysql.upgrade-0.7.sql b/plugins/calendar/drivers/database/sql/mysql.upgrade-0.7.sql
new file mode 100644
index 0000000..089b06d
--- /dev/null
+++ b/plugins/calendar/drivers/database/sql/mysql.upgrade-0.7.sql
@@ -0,0 +1,5 @@
+/**
+ * MySQL database updates since version 0.7/0.8
+ **/
+
+ALTER TABLE `events` ADD `sequence` int(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `changed`;
diff --git a/plugins/calendar/drivers/database/sql/postgres.upgrade-0.7.sql b/plugins/calendar/drivers/database/sql/postgres.upgrade-0.7.sql
new file mode 100644
index 0000000..facb195
--- /dev/null
+++ b/plugins/calendar/drivers/database/sql/postgres.upgrade-0.7.sql
@@ -0,0 +1,5 @@
+/**
+ * Postgres database updates since version 0.7/0.8
+ **/
+
+ALTER TABLE events ADD sequence integer NOT NULL DEFAULT 0;
diff --git a/plugins/calendar/drivers/kolab/SQL/mysql.upgrade-0.7.sql b/plugins/calendar/drivers/kolab/SQL/mysql.upgrade-0.7.sql
new file mode 100644
index 0000000..da567b6
--- /dev/null
+++ b/plugins/calendar/drivers/kolab/SQL/mysql.upgrade-0.7.sql
@@ -0,0 +1,15 @@
+/**
+ * Kolab backend SQL updates
+ **/
+
+DROP TABLE IF EXISTS `kolab_alarms`;
+
+CREATE TABLE `kolab_alarms` (
+  `event_id` VARCHAR(255) NOT NULL,
+  `user_id` int(10) UNSIGNED NOT NULL,
+  `notifyat` DATETIME DEFAULT NULL,
+  `dismissed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY(`event_id`),
+  CONSTRAINT `fk_kolab_alarms_user_id` FOREIGN KEY (`user_id`)
+    REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
+) /*!40000 ENGINE=INNODB */;
diff --git a/plugins/calendar/package.xml b/plugins/calendar/package.xml
index c422d2a..881ce65 100644
--- a/plugins/calendar/package.xml
+++ b/plugins/calendar/package.xml
@@ -19,10 +19,10 @@
 		<email>machniak at kolabsys.com</email>
 		<active>yes</active>
 	</developer>
-	<date>2012-12-16</date>
+	<date>2012-11-08</date>
 	<version>
-		<release>0.8-alpha</release>
-		<api>0.9-alpha</api>
+		<release>0.9-beta</release>
+		<api>0.9-beta</api>
 	</version>
 	<stability>
 		<release>stable</release>