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
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,
10 primary key id (uid
, type, sub
, domain)
13 # vim
:set syntax
=mysql
: