Difference between revisions of "Database Table: userproplite"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
|||
Line 1: | Line 1: | ||
Associates users to properties at the global level. See also [[Database Table: userproplite2|userproplite2]] | Associates users to properties at the global level. See also [[Database Table: userproplite2|userproplite2]] | ||
− | + | = Definition = | |
− | =Definition= | + | |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE userproplite ( | CREATE TABLE userproplite ( | ||
Line 13: | Line 13: | ||
</source> | </source> | ||
− | =Relationships= | + | = Relationships = |
+ | |||
+ | = Location = | ||
− | |||
[[Global database]] | [[Global database]] | ||
+ | |||
+ | [[Category: Database Tables|userproplite]] |
Revision as of 10:38, 4 April 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) )