upgrade/0.9.15/01_mailman.sql

   1 CREATE TABLE ml_moderate (
   2     ml VARCHAR(64) NOT NULL,
   3     domain VARCHAR(64) NOT NULL,
   4     mid SMALLINT(5) UNSIGNED NOT NULL,
   5     uid SMALLINT(5) UNSIGNED NOT NULL,
   6     action ENUM('accept', 'refuse', 'delete') NOT NULL,
   7     ts TIMESTAMP NOT NULL,
   8     message TEXT,
   9     handler INT(8) UNSIGNED DEFAULT NULL,
  10     PRIMARY KEY(ml, domain, mid)
  11 ) CHARSET=utf8;
  12
  13 # vim:set syntax=mysql: