Database Table: sysban
From Dreamwidth Notes
Revision as of 15:33, 31 March 2009 by Dreamnestia (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) )