Database Table: media_versions

From Dreamwidth Notes
Revision as of 16:58, 29 July 2013 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 `media_versions` (
  `userid` INT(10) UNSIGNED NOT NULL,
  `mediaid` INT(10) UNSIGNED NOT NULL,
  `versionid` INT(10) UNSIGNED NOT NULL,
  `width` SMALLINT(5) UNSIGNED NOT NULL,
  `height` SMALLINT(5) UNSIGNED NOT NULL,
  `filesize` INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`userid`,`mediaid`,`versionid`)
)

Relationships