Services/Sync/Server/Archived/0.3/Setup/Server: Difference between revisions

Services/Sync/Server/Archived/0.3/Setup/Server (view source)

376 bytes added , 20 August 2009

canmove, Confirmed users

1,173

edits

@@ Line 107: / Line 107: @@
 === Mysql ===
-Create the mysql database. Add the following tables:
+Create the mysql database. Add the following table:
 <pre>
-create table wbo
+CREATE TABLE `wbo` (
-(
+  `username` varbinary(32) NOT NULL default '',
- username varchar(32),
+  `collection` varbinary(64) NOT NULL default '',
- collection varbinary(64),
+  `id` varbinary(64) NOT NULL default '',
- id varbinary(64),
+  `parentid` varbinary(64) default NULL,
- parentid varbinary(64),
+  `predecessorid` varbinary(64) default NULL,
- modified decimal(12,2),
+  `modified` decimal(12,2) default NULL,
- sortindex int,
+  `sortindex` int(11) default NULL,
- depth tinyint,
+  `depth` tinyint(4) default NULL,
- payload longtext,
+  `payload` longtext,
-  primary key(username, collection, id),
+  `payload_size` int(11) default NULL,
- index parentindex(username, collection, parentid),
+  PRIMARY KEY  (`username`,`collection`,`id`),
- index modified(username, collection, modified)
+  KEY `parentindex` (`username`,`collection`,`parentid`),
-) engine=InnoDB;
+  KEY `modified` (`username`,`collection`,`modified`),
+  KEY `weightindex` (`username`,`collection`,`sortindex`),
+  KEY `predecessorindex` (`username`,`collection`,`predecessorid`)
+) ENGINE=InnoDB
 </pre>