2 commits - plugins/calendar

[Thomas Brüderli]

 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');