2 commits - plugins/calendar
Thomas Brüderli
bruederli at kolabsys.com
Thu Jul 25 11:07:59 CEST 2013
plugins/calendar/drivers/kolab/SQL/postgres.initial.sql | 30 ++++++++++++++++
1 file changed, 30 insertions(+)
New commits:
commit 821fab28c03bda933fdad5fc1d24b7d662771f38
Author: Thomas Bruederli <bruederli at kolabsys.com>
Date: Thu Jul 25 11:07:53 2013 +0200
Fix author string
diff --git a/plugins/calendar/drivers/kolab/SQL/postgres.initial.sql b/plugins/calendar/drivers/kolab/SQL/postgres.initial.sql
index 10b4ac4..b869240 100644
--- a/plugins/calendar/drivers/kolab/SQL/postgres.initial.sql
+++ b/plugins/calendar/drivers/kolab/SQL/postgres.initial.sql
@@ -1,8 +1,7 @@
/**
* Roundcube Calendar Kolab backend
*
- * @version @package_version@
- * @author Thomas Bruederli
+ * @author Sergey Sidlyarenko
* @licence GNU AGPL
**/
commit 9df99187dfe50e214875d26b6d9672a54ab8357d
Author: Thomas Bruederli <bruederli at kolabsys.com>
Date: Thu Jul 25 11:06:13 2013 +0200
Add database schema file for Postgres (#2044)
diff --git a/plugins/calendar/drivers/kolab/SQL/postgres.initial.sql b/plugins/calendar/drivers/kolab/SQL/postgres.initial.sql
new file mode 100644
index 0000000..10b4ac4
--- /dev/null
+++ b/plugins/calendar/drivers/kolab/SQL/postgres.initial.sql
@@ -0,0 +1,31 @@
+/**
+ * Roundcube Calendar Kolab backend
+ *
+ * @version @package_version@
+ * @author Thomas Bruederli
+ * @licence GNU AGPL
+ **/
+
+CREATE TABLE IF NOT EXISTS kolab_alarms (
+ event_id character varying(255) NOT NULL,
+ user_id integer NOT NULL
+ REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+ notifyat timestamp without time zone DEFAULT NULL,
+ dismissed smallint NOT NULL DEFAULT 0,
+ PRIMARY KEY(event_id)
+);
+
+CREATE TABLE IF NOT EXISTS itipinvitations (
+ token character varying(64) NOT NULL,
+ event_uid character varying(255) NOT NULL,
+ user_id integer NOT NULL
+ REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+ event text NOT NULL,
+ expires timestamp without time zone DEFAULT NULL,
+ cancelled smallint NOT NULL DEFAULT 0,
+ PRIMARY KEY(token)
+);
+
+CREATE INDEX itipinvitations_event_uid_user_id_idx ON itipinvitations (event_uid, user_id);
+
+INSERT INTO system (name, value) VALUES ('calendar-kolab-version', '2013011000');
More information about the commits
mailing list