Commit | Line | Data |
---|---|---|
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: |