Commit | Line | Data |
---|---|---|
fb0ee2e8 SJ |
1 | DROP TABLE IF EXISTS reminder_type; |
2 | ||
3 | CREATE TABLE IF NOT EXISTS reminder_type ( | |
4 | type_id INT NOT NULL AUTO_INCREMENT, | |
5 | name VARCHAR(255) NOT NULL, | |
6 | weight INT 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, | |
10 | PRIMARY KEY(type_id), | |
11 | UNIQUE KEY(name) | |
12 | ) CHARSET=utf8; | |
13 | ||
14 | INSERT INTO reminder_type (name, weight, remind_delay_yes, remind_delay_no, remind_delay_dismiss) | |
15 | VALUES ('email_warning', 100, 0, 0, 7), | |
b7cce896 | 16 | ('no_redirection', 100, 0, 0, 1), |
fb0ee2e8 SJ |
17 | ('profile_update', 90, 0, 0, 2), |
18 | ('nl', 80, 0, 365, 7), | |
19 | ('promotion_ml', 70, 0, 365, 7), | |
3c47e985 | 20 | ('email_backup', 60, 0, 365, 7), |
d7320497 | 21 | ('gapps', 50, 0, 365, 7), |
fb0ee2e8 SJ |
22 | ('ax_letter', 50, 0, 365, 14); |
23 | ||
24 | DROP TABLE IF EXISTS reminder; | |
25 | ||
26 | CREATE TABLE IF NOT EXISTS reminder ( | |
27 | uid INT NOT NULL, | |
28 | type_id INT NOT NULL, | |
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) | |
33 | ) CHARSET=utf8; | |
34 | ||
35 | -- vim:set syntax=mysql: |