Database Table: statushistory
From Dreamwidth Notes
Revision as of 18:02, 22 March 2009 by SlowSculpture (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) )
