Labs/Weave/Sync/1.0/Setup: Difference between revisions

→‎Mysql: update table creation based on README
(→‎Mysql: update table creation based on README)
Line 79: Line 79:
   `payload` longtext,
   `payload` longtext,
   `payload_size` int(11) default NULL,
   `payload_size` int(11) default NULL,
  `ttl` int(11) default '2100000000',
   PRIMARY KEY  (`username`,`collection`,`id`),
   PRIMARY KEY  (`username`,`collection`,`id`),
   KEY `parentindex` (`username`,`collection`,`parentid`),
   KEY `parentindex` (`username`,`collection`,`parentid`),
Line 86: Line 87:
   KEY `size_index` (`username`,`payload_size`)
   KEY `size_index` (`username`,`payload_size`)
) ENGINE=InnoDB;
) ENGINE=InnoDB;
</pre>
</pre>


2

edits