Page MenuHomePhorge
Files F3312225

No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

View Options

diff --git a/plugins/libkolab/SQL/mysql/2018122700.sql b/plugins/libkolab/SQL/mysql/2018122700.sql
index 519a1e8a..08030dd0 100644
--- a/plugins/libkolab/SQL/mysql/2018122700.sql
+++ b/plugins/libkolab/SQL/mysql/2018122700.sql
@@ -1,9 +1,10 @@
--- remove xml column
+-- remove xml column, and change data format (clear cache needed)
+DELETE FROM `kolab_folders`;
ALTER TABLE `kolab_cache_contact` DROP COLUMN `xml`;
ALTER TABLE `kolab_cache_event` DROP COLUMN `xml`;
ALTER TABLE `kolab_cache_task` DROP COLUMN `xml`;
ALTER TABLE `kolab_cache_journal` DROP COLUMN `xml`;
ALTER TABLE `kolab_cache_note` DROP COLUMN `xml`;
ALTER TABLE `kolab_cache_file` DROP COLUMN `xml`;
ALTER TABLE `kolab_cache_configuration` DROP COLUMN `xml`;
ALTER TABLE `kolab_cache_freebusy` DROP COLUMN `xml`;
diff --git a/plugins/libkolab/SQL/oracle/2018122700.sql b/plugins/libkolab/SQL/oracle/2018122700.sql
index 4f4892b4..45fccb74 100644
--- a/plugins/libkolab/SQL/oracle/2018122700.sql
+++ b/plugins/libkolab/SQL/oracle/2018122700.sql
@@ -1,9 +1,10 @@
--- remove xml column
+-- remove xml column, and change data format (clear cache needed)
+DELETE FROM "kolab_folders";
ALTER TABLE "kolab_cache_contact" DROP COLUMN "xml";
ALTER TABLE "kolab_cache_event" DROP COLUMN "xml";
ALTER TABLE "kolab_cache_task" DROP COLUMN "xml";
ALTER TABLE "kolab_cache_journal" DROP COLUMN "xml";
ALTER TABLE "kolab_cache_note" DROP COLUMN "xml";
ALTER TABLE "kolab_cache_file" DROP COLUMN "xml";
ALTER TABLE "kolab_cache_configuration" DROP COLUMN "xml";
ALTER TABLE "kolab_cache_freebusy" DROP COLUMN "xml";

File Metadata

Mime Type
text/x-diff
Expires
Thu, Apr 9, 1:39 PM (6 h, 5 s)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
540511
Default Alt Text
(1 KB)

Event Timeline