Asynchronous mailing list mail moderation... This means:

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

diff --git a/upgrade/0.9.15/01_mailman.sql b/upgrade/0.9.15/01_mailman.sql
new file mode 100644 (file)
index 0000000..1bb1c64
--- /dev/null
+++ b/upgrade/0.9.15/01_mailman.sql
@@ -0,0 +1,13 @@
+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: