1 DROP TABLE IF EXISTS reminder_type
;
3 CREATE TABLE IF NOT EXISTS reminder_type (
4 type_id
INT NOT NULL AUTO_INCREMENT
,
5 name VARCHAR(255) NOT NULL,
7 remind_delay_yes
INT NOT NULL DEFAULT 0,
8 remind_delay_no
INT NOT NULL DEFAULT 0,
9 remind_delay_dismiss
INT NOT NULL DEFAULT 0,
14 INSERT INTO reminder_type (name, weight
, remind_delay_yes
, remind_delay_no
, remind_delay_dismiss
)
15 VALUES ('email_warning', 100, 0, 0, 7),
16 ('no_redirection', 100, 0, 0, 1),
17 ('profile_update', 90, 0, 0, 2),
18 ('nl', 80, 0, 365, 7),
19 ('promotion_ml', 70, 0, 365, 7),
21 ('email_backup', 60, 0, 365, 7),
22 ('gapps', 50, 0, 365, 7),
23 ('ax_letter', 50, 0, 365, 14);
25 DROP TABLE IF EXISTS reminder
;
27 CREATE TABLE IF NOT EXISTS reminder (
30 status
ENUM('yes', 'no', 'dismiss') NOT NULL,
31 remind_last
TIMESTAMP NOT NULL,
32 remind_next
TIMESTAMP NULL,
33 PRIMARY KEY(uid
, type_id
)
36 ALTER TABLE register_pending
ADD services
SET('ax_letter', 'imap', 'ml_promo', 'nl') NOT NULL DEFAULT '' AFTER hash
;
38 -- vim:set syntax=mysql: