| 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), |
| 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 | ('ml', 70, 0, 0, 7), |
| 21 | ('email_backup', 60, 0, 365, 7), |
| 22 | ('gapps', 50, 0, 365, 7), |
| 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, |
| 30 | status ENUM('yes', 'no', 'dismissed') NOT NULL, |
| 31 | remind_last TIMESTAMP NOT NULL, |
| 32 | remind_next TIMESTAMP NULL, |
| 33 | PRIMARY KEY(uid, type_id) |
| 34 | ) CHARSET=utf8; |
| 35 | |
| 36 | -- vim:set syntax=mysql: |