12 |
create table lists ( |
create table lists ( |
13 |
id serial, |
id serial, |
14 |
name text not null, |
name text not null, |
15 |
email text not null, |
email text default '', |
16 |
bounce_limit int not null default 3, |
bounce_limit int not null default 3, |
17 |
date timestamp not null default now(), |
date timestamp not null default now(), |
18 |
primary key(id) |
primary key(id) |
34 |
primary key(id) |
primary key(id) |
35 |
); |
); |
36 |
|
|
|
create index messages_md5_ind on messages(md5); |
|
|
|
|
37 |
create table queue ( |
create table queue ( |
38 |
message_id int not null references messages(id) on update cascade on delete cascade, |
message_id int not null references messages(id) on update cascade on delete cascade, |
39 |
list_id int not null references lists(id) on update cascade on delete cascade, |
list_id int not null references lists(id) on update cascade on delete cascade, |