Tallify/seed.sql at master · tiffam/Tallify · GitHub

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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
-- populate table with seed data
INSERT INTO users
(name, email, password)
VALUES
('Rose', 'rose@gmail.com', 'password');

INSERT INTO users
(name, email, password)
VALUES
('Alice', 'alice@gmail.com', 'password');

INSERT INTO users
(name, email, password)
VALUES
('Tom', 'tom@gmail.com', 'password');

INSERT INTO vouchers
(value, expiry_date, created_at, redeemed, user_id, company_id)
VALUES
('10', '10/10/2018', '10/9/2018', 'No', 1, 1);

INSERT INTO vouchers
(value, expiry_date, created_at, redeemed,  user_id, company_id)
VALUES
('10', '10/10/2018', '10/9/2018', 'No', 1, 1);

INSERT INTO vouchers
(value, expiry_date, created_at, redeemed, user_id, company_id)
VALUES
('20', '10/10/2018', '10/9/2018', 'No', 1, 2);

INSERT INTO vouchers
(value, expiry_date, created_at, redeemed, user_id, company_id)
VALUES
('20', '10/10/2018', '10/9/2018', 'No', 2, 1);

INSERT INTO vouchers
(value, expiry_date, created_at, redeemed, user_id, company_id)
VALUES
('50', '10/10/2018', '10/9/2018', 'No', 2, 1);

INSERT INTO vouchers
(value, expiry_date, created_at, redeemed, user_id, company_id)
VALUES
('20', '01/10/2018', '01/9/2018', 'No', 1, 2);

INSERT INTO company
(company_name, company_image, shop_listing)
VALUES
('NTUC', '/fairprice.jpeg', 'https://www.google.com.sg/maps/search/NTUC/');

INSERT INTO company
(company_name, company_image, shop_listing)
VALUES
('Takashimaya', '/takashimaya.png', 'https://www.google.com.sg/maps/search/takashimaya/');