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), | |
f75b677b | 20 | ('ml', 70, 0, 0, 7), |
3c47e985 | 21 | ('email_backup', 60, 0, 365, 7), |
d7320497 | 22 | ('gapps', 50, 0, 365, 7), |
fb0ee2e8 SJ |
23 | ('ax_letter', 50, 0, 365, 14); |
24 | ||
25 | DROP TABLE IF EXISTS reminder; | |
26 | ||
27 | CREATE TABLE IF NOT EXISTS reminder ( | |
28 | uid INT NOT NULL, | |
29 | type_id INT NOT NULL, | |
22f99f96 | 30 | status ENUM('yes', 'no', 'dismiss') NOT NULL, |
fb0ee2e8 | 31 | remind_last TIMESTAMP NOT NULL, |
a6b247ae | 32 | remind_next TIMESTAMP NULL, |
fb0ee2e8 SJ |
33 | PRIMARY KEY(uid, type_id) |
34 | ) CHARSET=utf8; | |
35 | ||
3546b253 VZ |
36 | ALTER TABLE register_pending ADD services SET('ax_letter', 'imap', 'ml_promo', 'nl') NOT NULL DEFAULT '' AFTER hash; |
37 | ||
fb0ee2e8 | 38 | -- vim:set syntax=mysql: |