Page MenuHomePhorge
Files F2531189

No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

View Options

diff --git a/docs/SQL/mysql/2013011200.sql b/docs/SQL/mysql/2013011200.sql
index d9169ee..32eec10 100644
--- a/docs/SQL/mysql/2013011200.sql
+++ b/docs/SQL/mysql/2013011200.sql
@@ -1,11 +1,11 @@
ALTER TABLE `syncroton_device` ADD `lastsynccollection` longblob DEFAULT NULL;
ALTER TABLE `syncroton_folder` ADD `supportedfields` longblob DEFAULT NULL;
ALTER TABLE `syncroton_data` CHANGE `type` `class` varchar(40) NOT NULL;
CREATE TABLE `syncroton_data_folder` (
`id` varchar(40) NOT NULL,
`type` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`owner_id` varchar(40) NOT NULL,
`parent_id` varchar(40) DEFAULT NULL,
PRIMARY KEY (`id`)
-) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
+) /*!40000 ENGINE=INNODB */;
diff --git a/docs/SQL/mysql/2013011600.sql b/docs/SQL/mysql/2013011600.sql
index 0c6b7ec..0e8457c 100644
--- a/docs/SQL/mysql/2013011600.sql
+++ b/docs/SQL/mysql/2013011600.sql
@@ -1,9 +1,9 @@
CREATE TABLE IF NOT EXISTS `syncroton_modseq` (
`device_id` varchar(40) NOT NULL,
`folder_id` varchar(40) NOT NULL,
`synctime` varchar(14) NOT NULL,
`data` longblob,
PRIMARY KEY (`device_id`,`folder_id`,`synctime`),
KEY `syncroton_modseq::device_id` (`device_id`),
CONSTRAINT `syncroton_modseq::device_id--syncroton_device::id` FOREIGN KEY (`device_id`) REFERENCES `syncroton_device` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
-) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
+) /*!40000 ENGINE=INNODB */;
diff --git a/docs/SQL/mysql/2013040700.sql b/docs/SQL/mysql/2013040700.sql
index b68440c..453ab94 100644
--- a/docs/SQL/mysql/2013040700.sql
+++ b/docs/SQL/mysql/2013040700.sql
@@ -1,9 +1,9 @@
DROP TABLE IF EXISTS `syncroton_policy`;
CREATE TABLE IF NOT EXISTS `syncroton_policy` (
`id` varchar(40) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`policy_key` varchar(64) NOT NULL,
`json_policy` blob NOT NULL,
PRIMARY KEY (`id`)
-) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
+) /*!40000 ENGINE=INNODB */;

File Metadata

Mime Type
text/x-diff
Expires
Tue, Feb 3, 3:59 PM (11 h, 1 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
427376
Default Alt Text
(2 KB)

Event Timeline