('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;
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: