Stores if a user wants her unsubscription to be remembered.

[platal.git] / upgrade / 0.10.1 / 00_inscription.sql

diff --git a/upgrade/0.10.1/00_inscription.sql b/upgrade/0.10.1/00_inscription.sql
index 4534770..199aad9 100644 (file)
--- 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: