D5295.1775399795.diff
No OneTemporary
Actions

Authored By

Unknown

Size

1 KB

Referenced Files

None

Subscribers

None

D5295.1775399795.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
	@@ -79,7 +79,7 @@
	`is_deleted` tinyint(1) DEFAULT '0',
	PRIMARY KEY (`id`),
	UNIQUE KEY `device_id--folder_id--contentid` (`device_id`(40),`folder_id`(40),`contentid`(128)),
	- KEY `syncroton_contents::device_id` (`device_id`),
	+ KEY `device_id--is_deleted` (`device_id`,`is_deleted`),
	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 /;

	@@ -128,4 +128,4 @@
	PRIMARY KEY (`name`)
	) /!40000 ENGINE=INNODB / /!40101 CHARACTER SET utf8 COLLATE utf8_general_ci /;

	-INSERT INTO `system` (`name`, `value`) VALUES ('syncroton-version', '2025043000');
	+INSERT INTO `system` (`name`, `value`) VALUES ('syncroton-version', '2025060200');
	diff --git a/docs/SQL/mysql/2025060200.sql b/docs/SQL/mysql/2025060200.sql
	new file mode 100644
	--- /dev/null
	+++ b/docs/SQL/mysql/2025060200.sql
	@@ -0,0 +1,3 @@
	+
	+CREATE INDEX `device_id--is_deleted` ON `syncroton_content`(`device_id`,`is_deleted`);
	+DROP INDEX `syncroton_contents::device_id` ON `syncroton_content`;