-
Notifications
You must be signed in to change notification settings - Fork 40
/
friends.sql
29 lines (23 loc) · 920 Bytes
/
friends.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
DROP DATABASE IF EXISTS friends_example;
CREATE DATABASE friends_example;
\c friends_example
CREATE TABLE biking_friends (
id SERIAL PRIMARY KEY,
name varchar(255)
);
CREATE TABLE running_friends (
id SERIAL PRIMARY KEY,
name varchar(255)
);
INSERT INTO biking_friends (name) VALUES ('john doe');
INSERT INTO biking_friends (name) VALUES ('jane doe');
INSERT INTO biking_friends (name) VALUES ('jack doe');
INSERT INTO biking_friends (name) VALUES ('jay doe');
INSERT INTO biking_friends (name) VALUES ('jen doe');
INSERT INTO biking_friends (name) VALUES ('jesse doe');
INSERT INTO running_friends (name) VALUES ('max doe');
INSERT INTO running_friends (name) VALUES ('jen doe');
INSERT INTO running_friends (name) VALUES ('john doe');
INSERT INTO running_friends (name) VALUES ('jane doe');
INSERT INTO running_friends (name) VALUES ('jesse doe');
INSERT INTO running_friends (name) VALUES ('ruby doe');