upgrade/0.9.14/05_marketing.sql

   1 alter table register_marketing add column message varchar(16) not null default 'default';
   2 alter table register_marketing add column message_data varchar(64);
   3 create table register_subs
   4 (
   5     uid smallint(4) unsigned not null,
   6     type enum('list', 'group') not null default 'list',
   7     sub varchar(32) not null,
   8     domain varchar(64) not null,
   9
  10     primary key id (uid, type, sub, domain)
  11 ) charset=utf8;
  12
  13 # vim:set syntax=mysql: