blob: 809d8c9c81a0d4b9801dc5c8a7bb6e36fa847c75 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
create table guest (
id serial PRIMARY KEY,
first_name varchar(64),
last_name varchar(64),
attendance varchar(8) DEFAULT 'no' NOT NULL,
email varchar(64),
message varchar(128),
party_size integer
);
create table party (
guest_id integer NOT NULL references guest(id) ON DELETE CASCADE,
first_name varchar(64),
last_name varchar(64)
);
create table admin (
id serial PRIMARY KEY,
username varchar(64),
password varchar(64)
)
|
