Difference between revisions of "Database Table: media versions"

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

Latest revision as of 16:58, 29 July 2013

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