Database Table: sysban
From Dreamwidth Notes
Revision as of 16:00, 22 July 2010 by Exor674Bot (Talk | contribs)
This is a global table.
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) )