summaryrefslogtreecommitdiff
path: root/plugins/libkolab
diff options
context:
space:
mode:
authorThomas Bruederli <bruederli@kolabsys.com>2015-02-05 15:15:16 (GMT)
committerThomas Bruederli <bruederli@kolabsys.com>2015-02-05 15:15:16 (GMT)
commit67568dda20f8ccd779d5332c0a6f39a246da0f58 (patch)
tree66930befa9d52d3649000f06d750c67b2690aacd /plugins/libkolab
parent39449c11ce0fc00546cab84ac873a2d6ceb44194 (diff)
downloadroundcubemail-plugins-kolab-67568dda20f8ccd779d5332c0a6f39a246da0f58.tar.gz
Update schema version string; remove outdated postgres database schema
Diffstat (limited to 'plugins/libkolab')
-rw-r--r--plugins/libkolab/SQL/mysql.initial.sql2
-rw-r--r--plugins/libkolab/SQL/oracle.initial.sql2
-rw-r--r--plugins/libkolab/SQL/postgres.initial.sql31
3 files changed, 2 insertions, 33 deletions
diff --git a/plugins/libkolab/SQL/mysql.initial.sql b/plugins/libkolab/SQL/mysql.initial.sql
index 8f50d94..6a671ac 100644
--- a/plugins/libkolab/SQL/mysql.initial.sql
+++ b/plugins/libkolab/SQL/mysql.initial.sql
@@ -186,4 +186,4 @@ CREATE TABLE `kolab_cache_freebusy` (
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-INSERT INTO `system` (`name`, `value`) VALUES ('libkolab-version', '2015011600');
+INSERT INTO `system` (`name`, `value`) VALUES ('libkolab-version', '2015020600');
diff --git a/plugins/libkolab/SQL/oracle.initial.sql b/plugins/libkolab/SQL/oracle.initial.sql
index 19027ee..cf1fae5 100644
--- a/plugins/libkolab/SQL/oracle.initial.sql
+++ b/plugins/libkolab/SQL/oracle.initial.sql
@@ -183,4 +183,4 @@ CREATE TABLE "kolab_cache_freebusy" (
CREATE INDEX "kolab_cache_fb_uid2msguid" ON "kolab_cache_freebusy" ("folder_id", "uid", "msguid");
-INSERT INTO "system" ("name", "value") VALUES ('libkolab-version', '2015011600');
+INSERT INTO "system" ("name", "value") VALUES ('libkolab-version', '2015020600');
diff --git a/plugins/libkolab/SQL/postgres.initial.sql b/plugins/libkolab/SQL/postgres.initial.sql
deleted file mode 100644
index e06346c..0000000
--- a/plugins/libkolab/SQL/postgres.initial.sql
+++ /dev/null
@@ -1,31 +0,0 @@
-/**
- * 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');