D5295.1775390631.diff
No OneTemporary
Actions

Authored By

Unknown

Size

1 KB

Referenced Files

None

Subscribers

None

D5295.1775390631.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,6 +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 `device_id--is_deleted` (`device_id`,`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 /;
	@@ -128,4 +129,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,2 @@
	+
	+CREATE INDEX `device_id--is_deleted` ON `syncroton_content`(`device_id`,`is_deleted`);