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              ('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', 'dismiss') NOT NULL,
  31   remind_last TIMESTAMP NOT NULL,
  32   remind_next TIMESTAMP NULL,
  33   PRIMARY KEY(uid, type_id)
  34 ) CHARSET=utf8;
  35
  36 ALTER TABLE register_pending ADD services SET('ax_letter', 'imap', 'ml_promo', 'nl') NOT NULL DEFAULT '' AFTER hash;
  37
  38 -- vim:set syntax=mysql: