Database Table: media_prop_list

From Dreamwidth Notes
Jump to: navigation, search

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