| 9 |
primary key(id) |
primary key(id) |
| 10 |
); |
); |
| 11 |
|
|
| 12 |
|
create unique index users_email_ind on users(email); |
| 13 |
|
|
| 14 |
create table lists ( |
create table lists ( |
| 15 |
id serial, |
id serial, |
| 16 |
name text not null, |
name text not null, |
| 17 |
email text default '', |
email text not null, |
| 18 |
bounce_limit int not null default 3, |
bounce_limit int not null default 3, |
| 19 |
date timestamp not null default now(), |
date timestamp not null default now(), |
| 20 |
primary key(id) |
primary key(id) |
| 21 |
); |
); |
| 22 |
|
|
| 23 |
create index lists_name_ind on lists(name); |
create unique index lists_name_ind on lists(name); |
| 24 |
|
create unique index lists_email_ind on lists(email); |
| 25 |
|
|
| 26 |
create table user_list ( |
create table user_list ( |
| 27 |
user_id int not null references users(id) on update cascade on delete cascade, |
user_id int not null references users(id) on update cascade on delete cascade, |
Parent Directory
| 
Revision Log
| 
Patch