Database Table: statushistory
From Dreamwidth Notes
Revision as of 13:21, 2 October 2009 by Exor674Bot (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) )