Database Table: sysban
From Dreamwidth Notes
Revision as of 18:08, 22 March 2009 by SlowSculpture (Talk | contribs)
Definition
CREATE TABLE sysban ( banid MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (banid), STATUS ENUM('active','expired') NOT NULL DEFAULT 'active', INDEX (STATUS), bandate DATETIME, banuntil DATETIME, what VARCHAR(20) NOT NULL, VALUE VARCHAR(80), note VARCHAR(255) )