upgrade/0.10.1/00_inscription.sql

   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              ('email_backup',   60, 0, 365, 7),
  21              ('gapps',          50, 0, 365, 7),
  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 NULL,
  32   PRIMARY KEY(uid, type_id)
  33 ) CHARSET=utf8;
  34
  35 -- vim:set syntax=mysql: