a284b576c8e58d26c9b6f91bb4223cb54bd607f3
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 ('profile_update', 90, 0, 0, 2),
17 ('nl', 80, 0, 365, 7),
18 ('promotion_ml', 70, 0, 365, 7),
19 ('ax_letter', 50, 0, 365, 14);
21 DROP TABLE IF EXISTS reminder
;
23 CREATE TABLE IF NOT EXISTS reminder (
26 status
ENUM('yes', 'no', 'dismissed') NOT NULL,
27 remind_last
TIMESTAMP NOT NULL,
28 remind_next
TIMESTAMP NOT NULL,
29 PRIMARY KEY(uid
, type_id
)
32 -- vim:set syntax=mysql: