Changes

create table CREATE TABLE `collections ` ( `userid ` int(11) NOT NULL, `collectionid ` smallint (6) NOT NULL, `name ` varchar(32) NOT NULL, primary key PRIMARY KEY (`userid`, `collectionid`), key KEY `nameindex ` (`userid`, `name`)) engineENGINE=InnoDB;

create table CREATE TABLE `wbo` ( `username ` int(11) NOT NULL, `collection ` smallint (6) NOT NULLdefault '0', `id ` varbinary(64) NOT NULLdefault '', `parentid ` varbinary(64)default NULL, `predecessorid ` varbinary(64)default NULL, `sortindex ` int (11) default nullNULL, depth int default null, `modified decimal` bigint(12,220)default NULL, `payload text` longtext, `payload_size ` int(11) default NULL, PRIMARY KEY primary key(`username`, `collection`, `id`), key KEY `parentindex` (`username`, `collection`, `parentid`), key predecessorindex KEY `modified` (`username`, `collection`, predecessorid`modified`), key KEY `weightindex` (`username`, `collection`, `sortindex`), key modified KEY `predecessorindex` (`username`, `collection`, modified`predecessorid`), key KEY `size_index ` (`username`, `payload_size`)) engineENGINE=InnoDB;