Difference between revisions of "Database Table: collection items"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) m (Create page for new table collection_items) |
(No difference)
|
Latest revision as of 23:08, 28 November 2012
This is a clustered table.
Definition
CREATE TABLE `collection_items` ( `userid` INT(10) UNSIGNED NOT NULL, `colitemid` INT(10) UNSIGNED NOT NULL, `colid` INT(10) UNSIGNED NOT NULL, `itemtype` tinyint(3) UNSIGNED NOT NULL, `itemownerid` INT(10) UNSIGNED NOT NULL, `itemid` INT(10) UNSIGNED NOT NULL, `logtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`userid`,`colid`,`colitemid`), UNIQUE (`userid`,`colid`,`itemtype`,`itemownerid`,`itemid`), INDEX (`itemtype`,`itemownerid`,`itemid`) )
