1 |
create table users ( |
2 |
id serial, |
3 |
email text not null, |
4 |
full_name text not null, |
5 |
date timestamp default now(), |
6 |
primary key(id) |
7 |
); |
8 |
|
9 |
create table lists ( |
10 |
id serial, |
11 |
name text not null, |
12 |
date timestamp default now(), |
13 |
primary key(id) |
14 |
); |
15 |
|
16 |
create table user_list ( |
17 |
user_id int not null references users(id), |
18 |
list_id int not null references lists(id), |
19 |
date timestamp default now(), |
20 |
primary key (user_id, list_id) |
21 |
); |
22 |
|
23 |
create table messages ( |
24 |
id serial, |
25 |
message text not null, |
26 |
date timestamp default now(), |
27 |
primary key(id) |
28 |
); |
29 |
|
30 |
insert into users (email, full_name) values ('dpavlin@rot13.org', 'DbP'); |
31 |
insert into users (email, full_name) values ('dpavlin@gmail.com', 'DbP'); |
32 |
insert into users (email, full_name) values ('xxx_doesnt_exist_xxx@gmail.com', 'fake'); |
33 |
|
34 |
insert into lists (name) values ('Just me'); |
35 |
insert into lists (name) values ('All users'); |
36 |
|
37 |
insert into user_list (user_id, list_id) select users.id,1 from users limit 1; |
38 |
insert into user_list (user_id, list_id) select users.id,2 from users; |