Difference between revisions of "Database Table: users for paid accounts"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (Robot: Updating: Format, needs desc) |
Exor674Bot (Talk | contribs) (Robot: Updating: Format, definition) |
||
| Line 6: | Line 6: | ||
time_inserted int unsigned not null default 0, | time_inserted int unsigned not null default 0, | ||
points int(5) unsigned not null default 0, | points int(5) unsigned not null default 0, | ||
| + | journaltype char(1) NOT NULL DEFAULT 'P', | ||
PRIMARY KEY ( userid, time_inserted ), | PRIMARY KEY ( userid, time_inserted ), | ||
| − | INDEX ( time_inserted ) | + | INDEX ( time_inserted ), |
| + | INDEX ( journaltype ) | ||
) | ) | ||
</source> | </source> | ||
{{Database Table Footer}} | {{Database Table Footer}} | ||
Revision as of 01:16, 9 July 2010
"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a global table.
Definition
CREATE TABLE users_for_paid_accounts ( userid INT UNSIGNED NOT NULL, time_inserted INT UNSIGNED NOT NULL DEFAULT 0, points INT(5) UNSIGNED NOT NULL DEFAULT 0, journaltype CHAR(1) NOT NULL DEFAULT 'P', PRIMARY KEY ( userid, time_inserted ), INDEX ( time_inserted ), INDEX ( journaltype ) )
