Difference between revisions of "Database Table: media prop list"

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

Latest revision as of 16:58, 29 July 2013

This is a global table.

Definition

CREATE TABLE `media_prop_list` (
  `propid` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(50) DEFAULT NULL,
  `prettyname` VARCHAR(60) DEFAULT NULL,
  `ownership` enum('system','user') NOT NULL DEFAULT 'user',
  `scope` enum('general','local') NOT NULL DEFAULT 'general',
  `des` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`propid`),
  UNIQUE KEY `name` (`name`)
)

Relationships