Difference between revisions of "Database Table: collections"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) 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`) )
