Database Table: statushistory
From Dreamwidth Notes
Revision as of 16:19, 31 March 2009 by Dreamnestia (Talk | contribs)
Definition
CREATE TABLE statushistory ( userid INT UNSIGNED NOT NULL, adminid INT UNSIGNED NOT NULL, shtype VARCHAR(20) NOT NULL, shdate TIMESTAMP NOT NULL, notes TEXT, INDEX (userid, shdate), INDEX (adminid, shdate), INDEX (adminid, shtype, shdate), INDEX (shtype, shdate) )
