X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.10.1%2F00_inscription.sql;h=199aad9212e4316ea1551abf8e47bedf9c8e9247;hb=7a5d8476a10ef09b09b0128bb145b5407e6ed1e4;hp=4534770af122abea6bc53678d77d074355ff50fd;hpb=b7cce89632a6be6d344dd0d26a47b2f31fc8a90e;p=platal.git

diff --git a/upgrade/0.10.1/00_inscription.sql b/upgrade/0.10.1/00_inscription.sql
index 4534770..199aad9 100644
--- a/upgrade/0.10.1/00_inscription.sql
+++ b/upgrade/0.10.1/00_inscription.sql
@@ -17,6 +17,9 @@ 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);
 
 DROP TABLE IF EXISTS reminder;
@@ -24,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: