plugins/libkolab

[Aleksander Machniak]

 plugins/libkolab/SQL/postgres.initial.sql |   31 ++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)

New commits:
commit fd645a9e96e7d4fc589151448b8803bdde111f6f
Author: Aleksander Machniak <machniak at kolabsys.com>
Date:   Wed Jul 31 14:28:18 2013 +0200

    Added DDL for postgres (Bug #2039)

diff --git a/plugins/libkolab/SQL/postgres.initial.sql b/plugins/libkolab/SQL/postgres.initial.sql
new file mode 100644
index 0000000..e06346c
--- /dev/null
+++ b/plugins/libkolab/SQL/postgres.initial.sql
@@ -0,0 +1,31 @@
+/**
+ * libkolab database schema
+ *
+ * @version @package_version@
+ * @author Sidlyarenko Sergey
+ * @licence GNU AGPL
+ **/
+
+DROP TABLE IF EXISTS kolab_cache;
+
+CREATE TABLE kolab_cache (
+  resource character varying(255) NOT NULL,
+  type character varying(32) NOT NULL,
+  msguid NUMERIC(20) NOT NULL,
+  uid character varying(128) NOT NULL,
+  created timestamp without time zone DEFAULT NULL,
+  changed timestamp without time zone DEFAULT NULL,
+  data text NOT NULL,
+  xml text NOT NULL,
+  dtstart timestamp without time zone,
+  dtend timestamp without time zone,
+  tags character varying(255) NOT NULL,
+  words text NOT NULL,
+  filename character varying(255) DEFAULT NULL,
+  PRIMARY KEY(resource, type, msguid)
+);
+
+CREATE INDEX kolab_cache_resource_filename_idx ON kolab_cache (resource, filename);
+
+
+INSERT INTO system (name, value) VALUES ('libkolab-version', '2013041900');