diff --git a/plugins/calendar/UPGRADING b/plugins/calendar/UPGRADING new file mode 100644 index 00000000..3038233a --- /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//sql/.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 00000000..089b06d0 --- /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 00000000..facb1950 --- /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 00000000..da567b61 --- /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 c422d2a7..881ce650 100644 --- a/plugins/calendar/package.xml +++ b/plugins/calendar/package.xml @@ -1,188 +1,188 @@ calendar http://git.kolab.org/roundcubemail-plugins-kolab/ Calendar plugin - Thomas Bruederli bruederli bruederli@kolabsys.com yes Alensader Machniak machniak machniak@kolabsys.com yes - 2012-12-16 + 2012-11-08 - 0.8-alpha - 0.9-alpha + 0.9-beta + 0.9-beta stable stable GNU AGPLv3 - 5.3.1 1.7.0