-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathseed.sql
36 lines (35 loc) · 3.2 KB
/
seed.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
30
31
32
33
34
35
36
USE Stocks;
INSERT INTO Users (first_name,last_name,email,account_balance,createdAt,updatedAt) VALUES ('Devin','Thomas','dthomase30@gmail.com',10000,'2018-03-22T00:17:42','2018-03-22T00:17:42');
INSERT INTO Users (first_name,last_name,email,account_balance,createdAt,updatedAt) VALUES ('Nema','Darban','nema.darban@gmail.com',10000,'2018-03-22T00:17:42','2018-03-22T00:17:42');
INSERT INTO Users (first_name,last_name,email,account_balance,createdAt,updatedAt) VALUES ('Daphne','Chen','daphne@gmail.com',10000,'2018-03-22T00:17:42','2018-03-22T00:17:42');
INSERT INTO Users (first_name,last_name,email,account_balance,createdAt,updatedAt) VALUES ('Jeremy','Gruhlkey','jeremygruhlkey@gmail.com',10000,'2018-03-22T00:17:42','2018-03-22T00:17:42');
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("TSLA",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',1);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("TSLA",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',2);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("TSLA",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',3);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("TSLA",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',4);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("FB",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',1);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("MNKD",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',2);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("FB",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',3);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("FB",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',4);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("SNAP",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',4);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("SNAP",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',3);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("SNAP",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',1);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("FB",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',3);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("SNAP",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',3);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("MNKD",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',1);
INSERT INTO Ledgers (symbol,purchase_price,stock_count,is_owned,createdAt,updatedAt,UserId)
VALUES ("SNAP",50,5,true,'2018-03-22T00:17:42','2018-03-22T00:17:42',3);