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