Database Table: userproplite

From Dreamwidth Notes
Jump to: navigation, search

This is a global table. Associates users to properties at the global level. See also userproplite2

Definition

CREATE TABLE userproplite (
    userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
    upropid SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
    VALUE VARCHAR(255) DEFAULT NULL,
 
    PRIMARY KEY  (userid,upropid),
    KEY (upropid)
)

Relationships