D5298.1775351707.diff
No OneTemporary
Actions

Authored By

Unknown

Size

1 KB

Referenced Files

None

Subscribers

None

D5298.1775351707.diff
View Options

	diff --git a/docs/SQL/mysql.initial.sql b/docs/SQL/mysql.initial.sql
	--- a/docs/SQL/mysql.initial.sql
	+++ b/docs/SQL/mysql.initial.sql
	@@ -50,8 +50,8 @@
	`resync` tinyint(1) DEFAULT NULL,
	`is_deleted` tinyint(1) DEFAULT '0',
	PRIMARY KEY (`id`),
	- UNIQUE KEY `device_id--class--folderid` (`device_id`(40),`class`(40),`folderid`(40)),
	- KEY `folderstates::device_id--devices::id` (`device_id`),
	+ UNIQUE KEY `device_id--class--folderid` (`device_id`,`class`,`folderid`),
	+ KEY (`is_deleted`),
	CONSTRAINT `folderstates::device_id--devices::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 /;

	@@ -78,9 +78,8 @@
	`creation_synckey` int(11) NOT NULL,
	`is_deleted` tinyint(1) DEFAULT '0',
	PRIMARY KEY (`id`),
	- UNIQUE KEY `device_id--folder_id--contentid` (`device_id`(40),`folder_id`(40),`contentid`(128)),
	+ UNIQUE KEY `device_id--folder_id--contentid` (`device_id`,`folder_id`,`contentid`),
	KEY (`is_deleted`),
	- KEY `syncroton_contents::device_id` (`device_id`),
	CONSTRAINT `syncroton_contents::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 /;