Difference between revisions of "Database Table: userproplite"
From Dreamwidth Notes
(New page: Global database; deprecated in favor of userproplite2 (clustered). userproplite) |
|||
| Line 1: | Line 1: | ||
| − | + | Associates users to properties at the global level. See also [[Database table: userproplite2|userproplite2]] | |
| − | [[Category: | + | [[Category: Database Table|userproplite]] |
| + | =Definition= | ||
| + | <source lang="sql"> | ||
| + | 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) | ||
| + | ) | ||
| + | </source> | ||
| + | |||
| + | =Relationships= | ||
| + | |||
| + | =Location= | ||
| + | [[Global database]] | ||
Revision as of 22:10, 22 March 2009
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) )
