summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorAleksander Machniak <machniak@kolabsys.com>2013-01-12 16:00:25 (GMT)
committerAleksander Machniak <machniak@kolabsys.com>2013-01-12 16:00:25 (GMT)
commit21df8cc4801b633416bf0a6f121270d1084880e2 (patch)
treeaaacfe281cd12c179d713585b3d457b01e6b6d99 /docs
parent0dffe2b42b0fe77a756ad96b3bccc4a4b2953d5e (diff)
downloadkolab-syncroton-21df8cc4801b633416bf0a6f121270d1084880e2.tar.gz
Increase UID length limit from 64 to 128 characters (Bug #1534)
Diffstat (limited to 'docs')
-rw-r--r--docs/SQL/mysql/2013011201.sql3
-rw-r--r--docs/syncroton.sql4
2 files changed, 5 insertions, 2 deletions
diff --git a/docs/SQL/mysql/2013011201.sql b/docs/SQL/mysql/2013011201.sql
new file mode 100644
index 0000000..892a14c
--- /dev/null
+++ b/docs/SQL/mysql/2013011201.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `syncroton_content` DROP KEY `device_id--folder_id--contentid`;
+ALTER TABLE `syncroton_content` MODIFY `contentid` varchar(128) DEFAULT NULL;
+ALTER TABLE `syncroton_content` ADD UNIQUE KEY `device_id--folder_id--contentid` (`device_id`(40),`folder_id`(40),`contentid`(128));
diff --git a/docs/syncroton.sql b/docs/syncroton.sql
index b35a6b4..c0581a5 100644
--- a/docs/syncroton.sql
+++ b/docs/syncroton.sql
@@ -108,12 +108,12 @@ CREATE TABLE IF NOT EXISTS `syncroton_content` (
`id` varchar(40) NOT NULL,
`device_id` varchar(40) DEFAULT NULL,
`folder_id` varchar(40) DEFAULT NULL,
- `contentid` varchar(64) DEFAULT NULL,
+ `contentid` varchar(128) DEFAULT NULL,
`creation_time` datetime DEFAULT NULL,
`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`(40)),
+ UNIQUE KEY `device_id--folder_id--contentid` (`device_id`(40),`folder_id`(40),`contentid`(128)),
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
) ENGINE=InnoDB;