Database Table: media_versions

From Dreamwidth Notes
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