Difference between revisions of "Database Table: media props"

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

Latest revision as of 16:58, 29 July 2013

This is a clustered table.

Definition

CREATE TABLE `media_props` (
  `userid` INT(10) UNSIGNED NOT NULL,
  `mediaid` INT(10) UNSIGNED NOT NULL,
  `propid` tinyint(3) UNSIGNED NOT NULL,
  `value` MEDIUMBLOB NOT NULL,
  PRIMARY KEY (`userid`, `mediaid`, `propid`)
)

Relationships