[platal.git] / upgrade / 0.9.15 / 01_mailman.sql

CREATE TABLE ml_moderate (
    ml VARCHAR(64) NOT NULL,
    domain VARCHAR(64) NOT NULL,
    mid SMALLINT(5) UNSIGNED NOT NULL,
    uid SMALLINT(5) UNSIGNED NOT NULL,
    action ENUM('accept', 'refuse', 'delete') NOT NULL,
    ts TIMESTAMP NOT NULL,
    message TEXT,
    handler INT(8) UNSIGNED DEFAULT NULL,
    PRIMARY KEY(ml, domain, mid)
) CHARSET=utf8;

# vim:set syntax=mysql:
Commit	Line	Data
834fd0f6	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: