diff --git a/plugins/libkolab/SQL/mysql/2018122700.sql b/plugins/libkolab/SQL/mysql/2018122700.sql index 08030dd0..519a1e8a 100644 --- a/plugins/libkolab/SQL/mysql/2018122700.sql +++ b/plugins/libkolab/SQL/mysql/2018122700.sql @@ -1,10 +1,9 @@ --- remove xml column, and change data format (clear cache needed) -DELETE FROM `kolab_folders`; +-- remove xml column 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 45fccb74..4f4892b4 100644 --- a/plugins/libkolab/SQL/oracle/2018122700.sql +++ b/plugins/libkolab/SQL/oracle/2018122700.sql @@ -1,10 +1,9 @@ --- remove xml column, and change data format (clear cache needed) -DELETE FROM "kolab_folders"; +-- remove xml column 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";