X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=upgrade%2F0.10.1%2F00_inscription.sql;h=199aad9212e4316ea1551abf8e47bedf9c8e9247;hb=c76545c351fae4e2298624ff9ee5bf854dc5a5b6;hp=554421724398839032e434ba42aa4748eb7fa7dc;hpb=a6b247aeaa2eb84a038a68f398f910d4f301b154;p=platal.git

diff --git a/upgrade/0.10.1/00_inscription.sql b/upgrade/0.10.1/00_inscription.sql
index 5544217..199aad9 100644
--- a/upgrade/0.10.1/00_inscription.sql
+++ b/upgrade/0.10.1/00_inscription.sql
@@ -17,6 +17,7 @@ INSERT INTO  reminder_type (name, weight, remind_delay_yes, remind_delay_no, rem
              ('profile_update', 90, 0, 0,   2),
              ('nl',             80, 0, 365, 7),
              ('promotion_ml',   70, 0, 365, 7),
+             ('ml',             70, 0, 0,   7),
              ('email_backup',   60, 0, 365, 7),
              ('gapps',          50, 0, 365, 7),
              ('ax_letter',      50, 0, 365, 14);
@@ -26,10 +27,12 @@ DROP TABLE IF EXISTS reminder;
 CREATE TABLE IF NOT EXISTS reminder (
   uid INT NOT NULL,
   type_id INT NOT NULL,
-  status ENUM('yes', 'no', 'dismissed') NOT NULL,
+  status ENUM('yes', 'no', 'dismiss') NOT NULL,
   remind_last TIMESTAMP NOT NULL,
   remind_next TIMESTAMP NULL,
   PRIMARY KEY(uid, type_id)
 ) CHARSET=utf8;
 
+ALTER TABLE register_pending ADD services SET('ax_letter', 'imap', 'ml_promo', 'nl') NOT NULL DEFAULT '' AFTER hash;
+
 -- vim:set syntax=mysql: