Database Table: collection_items

From Dreamwidth Notes
Revision as of 23:08, 28 November 2012 by Exor674Bot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

Relationships