1 |
create table users ( |
create table users ( |
2 |
id serial, |
id serial, |
3 |
email text not null, |
email text not null, |
4 |
full_name text default '', |
name text default '', |
5 |
date timestamp not null default now(), |
date timestamp not null default now(), |
6 |
active boolean not null default true, |
active boolean not null default true, |
7 |
bounce_count int not null default 0, |
bounce_count int not null default 0, |
70 |
create index received_list_id_int on received(list_id); |
create index received_list_id_int on received(list_id); |
71 |
|
|
72 |
|
|
73 |
insert into users (email, full_name) values ('dpavlin@rot13.org', 'DbP'); |
insert into users (email, name) values ('dpavlin@rot13.org', 'DbP'); |
74 |
insert into users (email, full_name) values ('dpavlin@gmail.com', 'DbP'); |
insert into users (email, name) values ('dpavlin@gmail.com', 'DbP'); |
75 |
insert into users (email, full_name) values ('xxx_doesnt_exist_xxx@gmail.com', 'fake'); |
insert into users (email, name) values ('xxx_doesnt_exist_xxx@gmail.com', 'fake'); |
76 |
|
|
77 |
insert into lists (name, email) values ('Just me','my-alter-ego@rot13.org'); |
insert into lists (name, email) values ('Just me','my-alter-ego@rot13.org'); |
78 |
insert into lists (name, email) values ('All users','announce@example.com'); |
insert into lists (name, email) values ('All users','announce@example.com'); |