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              ('ax_letter',      50, 0, 365, 14);
  21
  22 DROP TABLE IF EXISTS reminder;
  23
  24 CREATE TABLE IF NOT EXISTS reminder (
  25   uid INT NOT NULL,
  26   type_id INT NOT NULL,
  27   status ENUM('yes', 'no', 'dismissed') NOT NULL,
  28   remind_last TIMESTAMP NOT NULL,
  29   remind_next TIMESTAMP NOT NULL,
  30   PRIMARY KEY(uid, type_id)
  31 ) CHARSET=utf8;
  32
  33 -- vim:set syntax=mysql: