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

diff --git a/upgrade/0.10.1/00_inscription.sql b/upgrade/0.10.1/00_inscription.sql
index 36f5e77..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 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: