docs/SQL

[Aleksander Machniak]

 docs/SQL/mysql.initial.sql    |    2 +-
 docs/SQL/mysql/2014093000.sql |   10 ++++++++++
 docs/SQL/oracle.initial.sql   |    2 +-
 3 files changed, 12 insertions(+), 2 deletions(-)

New commits:
commit a8e3172d26082389bcebc9007f35f3b9aa9d574a
Author: Aleksander Machniak <machniak at kolabsys.com>
Date:   Thu Sep 4 15:28:52 2014 -0400

    Properly fix tables charset with ALTER TABLE (#3262)

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');