Database Table: media
From Dreamwidth Notes
This is a clustered table.
Definition
CREATE TABLE `media` ( `userid` INT(10) UNSIGNED NOT NULL, `mediaid` INT(10) UNSIGNED NOT NULL, `anum` tinyint(3) UNSIGNED NOT NULL, `ext` VARCHAR(10) NOT NULL, `state` CHAR(1) NOT NULL DEFAULT 'A', `mediatype` tinyint(3) UNSIGNED NOT NULL, `security` enum('public','private','usemask') NOT NULL DEFAULT 'public', `allowmask` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `logtime` INT(10) UNSIGNED NOT NULL, `mimetype` VARCHAR(60) NOT NULL, `filesize` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`userid`,`mediaid`) )