-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathseed.sql
More file actions
26 lines (15 loc) · 1.07 KB
/
seed.sql
File metadata and controls
26 lines (15 loc) · 1.07 KB
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
INSERT INTO users (username, password, email) VALUES ('herda', 'herda', 'herda@email.com' );
INSERT INTO users (username, password, email) VALUES ('weijun', 'weijun', 'weijun@email.com' );
INSERT INTO users (username, password, email) VALUES ('chris', 'chris', 'chris@email.com' );
INSERT INTO users (username, password, email) VALUES ('andrew', 'andrew', 'andrew@email.com' );
INSERT INTO receipts (user_id, group_id, img_token, subtotal, total) VALUES (1, 1, 'guQnFRzRY4MXMm6F', 30, null );
INSERT INTO groups (receipt_id, friend_id, amount) VALUES (1, 2, null);
INSERT INTO groups (receipt_id, friend_id, amount) VALUES (1, 3, null);
INSERT INTO items (receipt_id, item_name, price, quantity, users_id) VALUES( 1, 'Ice Mocha', 10.00, 1, ARRAY[1,2] );
INSERT INTO items (receipt_id, item_name, price, quantity, users_id) VALUES( 1, 'Ice Latte', 10.00, 1, ARRAY[1] );
INSERT INTO items (receipt_id, item_name, price, quantity, users_id) VALUES( 1, 'Ps.Fluffy Pancake', 10.00, 1, ARRAY[3] );
-- img token
-- J5LnLAjvkIiLdqLF
-- 63tVCbpFsFMpvE9A
-- 4fC7yVPQ9uzfdmJD
-- 5GpcpUozlUTCbEtd