X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.15%2F01_mailman.sql;fp=upgrade%2F0.9.15%2F01_mailman.sql;h=1bb1c64b4d84c9c08a901b1861fea9d23798a1ac;hb=834fd0f608437a2621e437225a0f779b0cad25c8;hp=0000000000000000000000000000000000000000;hpb=8fc4efa394721853bca6ee0e4f2028f33ed0867d;p=platal.git

diff --git a/upgrade/0.9.15/01_mailman.sql b/upgrade/0.9.15/01_mailman.sql
new file mode 100644
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: