Database Table: collection_items

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`)
)