X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.10.1%2F00_inscription.sql;h=199aad9212e4316ea1551abf8e47bedf9c8e9247;hb=49056fe2c32629b7b63b7936e6d9a25562fe5b5a;hp=4eed42d25dd469b9bd45cf33318335136c2814cd;hpb=3c47e985c1d86730de08ada85ea6642bc0d8faef;p=platal.git diff --git a/upgrade/0.10.1/00_inscription.sql b/upgrade/0.10.1/00_inscription.sql index 4eed42d..199aad9 100644 --- a/upgrade/0.10.1/00_inscription.sql +++ b/upgrade/0.10.1/00_inscription.sql @@ -17,7 +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; @@ -25,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: