summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Machniak <machniak@kolabsys.com>2014-09-04 19:28:52 (GMT)
committerAleksander Machniak <machniak@kolabsys.com>2014-09-04 19:28:52 (GMT)
commita8e3172d26082389bcebc9007f35f3b9aa9d574a (patch)
treee24396919634e2c623f8675c0647f4e9806e52af
parent4f12f064ffdff954e2010fa156257be2a64ff83c (diff)
downloadkolab-syncroton-a8e3172d26082389bcebc9007f35f3b9aa9d574a.tar.gz
Properly fix tables charset with ALTER TABLE (#3262)
-rw-r--r--docs/SQL/mysql.initial.sql2
-rw-r--r--docs/SQL/mysql/2014093000.sql10
-rw-r--r--docs/SQL/oracle.initial.sql2
3 files changed, 12 insertions, 2 deletions
diff --git a/docs/SQL/mysql.initial.sql b/docs/SQL/mysql.initial.sql
index 2e0de38..7c68bf2 100644
--- a/docs/SQL/mysql.initial.sql
+++ b/docs/SQL/mysql.initial.sql
@@ -113,4 +113,4 @@ CREATE TABLE IF NOT EXISTS `system` (
PRIMARY KEY(`name`)
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-INSERT INTO `system` (`name`, `value`) VALUES ('syncroton-version', '2013100800');
+INSERT INTO `system` (`name`, `value`) VALUES ('syncroton-version', '2014093000');
diff --git a/docs/SQL/mysql/2014093000.sql b/docs/SQL/mysql/2014093000.sql
new file mode 100644
index 0000000..b1a010f
--- /dev/null
+++ b/docs/SQL/mysql/2014093000.sql
@@ -0,0 +1,10 @@
+SET foreign_key_checks = 0;
+/*!40101 ALTER TABLE `syncroton_device` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+/*!40101 ALTER TABLE `syncroton_policy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+/*!40101 ALTER TABLE `syncroton_folder` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+/*!40101 ALTER TABLE `syncroton_synckey` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+/*!40101 ALTER TABLE `syncroton_content` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+/*!40101 ALTER TABLE `syncroton_data` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+/*!40101 ALTER TABLE `syncroton_data_folder` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+/*!40101 ALTER TABLE `syncroton_modseq` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci */;
+SET foreign_key_checks = 1;
diff --git a/docs/SQL/oracle.initial.sql b/docs/SQL/oracle.initial.sql
index cb78340..f3d1894 100644
--- a/docs/SQL/oracle.initial.sql
+++ b/docs/SQL/oracle.initial.sql
@@ -101,4 +101,4 @@ CREATE TABLE "syncroton_modseq" (
PRIMARY KEY ("device_id", "folder_id", "synctime")
);
-INSERT INTO "system" ("name", "value") VALUES ('syncroton-version', '2013100800');
+INSERT INTO "system" ("name", "value") VALUES ('syncroton-version', '2014093000');