No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

View Options

	diff --git a/plugins/calendar/drivers/kolab/SQL/mysql.sql b/plugins/calendar/drivers/kolab/SQL/mysql.sql
	index bc350159..0dbd39c5 100644
	--- a/plugins/calendar/drivers/kolab/SQL/mysql.sql
	+++ b/plugins/calendar/drivers/kolab/SQL/mysql.sql
	@@ -1,28 +1,28 @@
	/**
	* Roundcube Calendar Kolab backend
	*
	- * @version 0.6 beta
	+ * @version 0.7-beta
	* @author Thomas Bruederli
	- * @licence GNU GPL
	+ * @licence GNU AGPL
	**/

	-CREATE TABLE `kolab_alarms` (
	+CREATE TABLE IF NOT EXISTS `kolab_alarms` (
	`event_id` VARCHAR(255) NOT NULL,
	`notifyat` DATETIME DEFAULT NULL,
	`dismissed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY(`event_id`)
	) /!40000 ENGINE=INNODB /;

	-CREATE TABLE `itipinvitations` (
	+CREATE TABLE IF NOT EXISTS `itipinvitations` (
	`token` VARCHAR(64) NOT NULL,
	`event_uid` VARCHAR(255) NOT NULL,
	`user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
	`event` TEXT NOT NULL,
	`expires` DATETIME DEFAULT NULL,
	`cancelled` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY(`token`),
	INDEX `uid_idx` (`event_uid`,`user_id`),
	CONSTRAINT `fk_itipinvitations_user_id` FOREIGN KEY (`user_id`)
	REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
	) /!40000 ENGINE=INNODB / /!40101 CHARACTER SET utf8 COLLATE utf8_general_ci /;