Difference between revisions of "Database Table: media versions"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (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`) )