36f5e77e46bb013471f7b7fc9e0d4d2ede561632
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),
20 ('email_backup', 60, 0, 365, 7),
21 ('gapps', 50, 0, 365, 7),
22 ('ax_letter', 50, 0, 365, 14);
24 DROP TABLE IF EXISTS reminder
;
26 CREATE TABLE IF NOT EXISTS reminder (
29 status
ENUM('yes', 'no', 'dismissed') NOT NULL,
30 remind_last
TIMESTAMP NOT NULL,
31 remind_next
TIMESTAMP NOT NULL,
32 PRIMARY KEY(uid
, type_id
)
35 -- vim:set syntax=mysql: