Database Table: pollproplist2

From Dreamwidth Notes
Revision as of 19:05, 7 December 2010 by Xtina (Talk | contribs)

Jump to: navigation, search

This is a global table.

This table stores metadata of poll properties used. This is populated from possibilities stored in pollproplist2.

Definition

CREATE TABLE pollproplist2 (
    propid SMALLINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) DEFAULT NULL,
    des VARCHAR(255) DEFAULT NULL,
    scope ENUM('general', 'local') DEFAULT 'general' NOT NULL,
 
    UNIQUE KEY (name)
)

Relationships