Difference between revisions of "Database Table: collections"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table collections)
 
(No difference)

Latest revision as of 23:08, 28 November 2012

This is a clustered table.

Definition

CREATE TABLE `collections` (
  `userid` INT(10) UNSIGNED NOT NULL,
  `colid` INT(10) UNSIGNED NOT NULL,
  `paruserid` INT(10) UNSIGNED NOT NULL,
  `parcolid` INT(10) UNSIGNED NOT NULL,
  `anum` tinyint(3) UNSIGNED NOT NULL,
  `state` CHAR(1) NOT NULL DEFAULT 'A',
  `security` enum('public','private','usemask') NOT NULL DEFAULT 'public',
  `allowmask` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `logtime` INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`userid`,`colid`),
  INDEX (`paruserid`,`parcolid`)
)

Relationships