-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathtables.sql
More file actions
13 lines (13 loc) · 1.07 KB
/
tables.sql
File metadata and controls
13 lines (13 loc) · 1.07 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
-- +-------------
-- id | integer | | not null | nextval('listings_id_seq'::regclass) | plain | |
-- seller_id | integer | | | | plain | |
-- album_id | character varying | | | | extended | |
-- price | double precision | | | | plain | |
-- created_at | timestamp without time zone | | not null | | plain | |
-- updated_at | timestamp without time zone | | not null | | plain | |
-- Indexes:
-- "listings_pkey" PRIMARY KEY, btree (id)
--
INSERT INTO listings (seller_id, album_id, price) VALUES (1, 1, 50);
INSERT INTO listings (seller_id, album_id, price) VALUES (1, 2, 500);
INSERT INTO listings (seller_id, album_id, price) VALUES (2, 3, 100);