-
Notifications
You must be signed in to change notification settings - Fork 0
/
transactions.sql
45 lines (44 loc) · 9.34 KB
/
transactions.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
37
38
39
40
41
42
43
44
45
/*
-- Query: select * from `e.tracker`.transactions
LIMIT 0, 1000
-- Date: 2020-03-02 10:03
*/
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (1,1,'Housing','Airbnb',101.61,'2020-01-19','expense','44 N.Board St.','2020-02-27 21:18:58','2020-02-27 21:18:58');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (2,1,'Food','Lunch',4.05,'2020-01-21','expense','Golden Artist Color','2020-02-27 21:19:33','2020-02-27 21:19:33');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (3,1,'Vehicle','Gas',25.41,'2020-01-22','expense','BYRNE DAIRY','2020-02-27 21:20:06','2020-02-27 21:20:06');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (4,1,'Food','Lunch',4.05,'2020-01-22','expense','Golden Artist Color','2020-02-27 21:20:33','2020-02-27 21:20:33');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (5,1,'Groceries','Groceries',19.51,'2020-01-22','expense','TOPS','2020-02-27 21:21:24','2020-02-27 21:21:24');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (6,1,'Food','Dinner',28.00,'2020-01-23','expense','Norwich Buffett','2020-02-27 21:23:29','2020-02-27 21:23:29');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (7,1,'Housing','Airbnb',1017.98,'2020-01-24','expense','44 N.Board St.','2020-02-27 21:24:03','2020-02-27 21:24:03');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (8,1,'Food','Dinner',21.60,'2020-01-25','expense','KFC','2020-02-27 21:24:44','2020-02-27 21:24:44');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (9,1,'Groceries','Car Wiper',81.58,'2020-01-25','expense','Walmart','2020-02-27 21:25:20','2020-02-27 21:25:20');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (10,1,'Food','Lunch',5.70,'2020-01-27','expense','Golden Artist Color','2020-02-27 21:25:49','2020-02-27 21:25:49');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (11,1,'Food','Lunch',4.05,'2020-01-29','expense','Golden Artist Color','2020-02-27 21:26:20','2020-02-27 21:26:20');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (12,1,'Groceries','Groceries',22.14,'2020-01-29','expense','TOPS','2020-02-27 21:26:44','2020-02-27 21:26:44');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (13,1,'Vehicle','Gas',31.61,'2020-01-30','expense','BYRNE DAIRY','2020-02-27 21:29:02','2020-02-27 21:29:02');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (14,1,'Income','Salary',792.22,'2020-01-30','income','Golden Artist Color','2020-02-27 21:29:25','2020-02-27 21:29:25');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (15,1,'Groceries',NULL,79.48,'2020-02-01','expense','TOPS','2020-02-27 21:30:42','2020-02-27 21:30:42');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (16,1,'Food',NULL,4.05,'2020-02-03','expense','Golden Artist Color','2020-02-27 21:31:06','2020-02-27 21:31:06');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (17,1,'Food',NULL,5.97,'2020-02-04','expense','Golden Artist Color','2020-02-27 21:31:31','2020-02-27 21:31:31');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (18,1,'Groceries',NULL,15.10,'2020-02-04','expense','Walgreens','2020-02-27 21:32:18','2020-02-27 21:32:18');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (19,1,'Vehicle','Gas',29.68,'2020-02-06','expense','BYRNE DAIRY','2020-02-27 21:32:52','2020-02-27 21:32:52');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (20,1,'Food',NULL,5.70,'2020-02-06','expense','Golden Artist Color','2020-02-27 21:33:05','2020-02-27 21:33:05');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (21,1,'Income','Salary',792.22,'2020-02-06','income','Golden Artist Color','2020-02-27 21:33:23','2020-02-27 21:33:23');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (22,1,'Food',NULL,5.13,'2020-02-07','expense','Golden Artist Color','2020-02-27 21:34:11','2020-02-27 21:34:11');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (23,1,'Groceries',NULL,92.07,'2020-02-07','expense','TOPS','2020-02-27 21:34:27','2020-02-27 21:34:27');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (24,1,'Groceries',NULL,88.71,'2020-02-09','expense','Walmart','2020-02-27 21:35:07','2020-02-27 21:35:07');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (25,1,'Food',NULL,4.05,'2020-02-11','expense','Golden Artist Color','2020-02-27 21:35:47','2020-02-27 21:35:47');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (26,1,'Groceries',NULL,20.82,'2020-02-12','expense','TOPS','2020-02-27 21:36:09','2020-02-27 21:36:09');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (27,1,'Vehicle','Gas',29.08,'2020-02-13','expense','BYRNE DAIRY','2020-02-27 21:36:27','2020-02-27 21:36:27');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (28,1,'Food',NULL,4.05,'2020-02-13','expense','Golden Artist Color','2020-02-27 21:36:40','2020-02-27 21:36:40');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (29,1,'Income','Salary',792.22,'2020-02-13','income','Golden Artist Color','2020-02-27 21:36:54','2020-02-27 21:36:54');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (30,1,'Groceries',NULL,117.48,'2020-02-14','expense','Walmart','2020-02-27 21:37:42','2020-02-27 21:37:42');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (31,1,'Food',NULL,4.05,'2020-02-18','expense','Golden Artist Color','2020-02-27 21:39:21','2020-02-27 21:39:21');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (32,1,'Groceries',NULL,55.98,'2020-02-18','expense','TOPS','2020-02-27 21:39:51','2020-02-27 21:39:51');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (33,1,'Food',NULL,5.13,'2020-02-18','expense','Golden Artist Color','2020-02-27 21:40:23','2020-02-27 21:40:23');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (34,1,'Others','T-Mobile',81.58,'2020-02-18','expense','Online TMobile','2020-02-27 21:41:03','2020-02-27 21:41:03');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (35,1,'Income','Salary',792.22,'2020-02-20','income','Golden Artist Color','2020-02-27 21:41:31','2020-02-27 21:41:31');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (36,1,'Vehicle','Gas',32.25,'2020-02-21','expense','BYRNE DAIRY','2020-02-27 21:42:16','2020-02-27 21:42:16');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (37,1,'Groceries',NULL,42.75,'2020-02-22','expense','TOPS','2020-02-27 21:42:44','2020-02-27 21:42:44');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (38,1,'Food',NULL,5.13,'2020-02-24','expense','Golden Artist Color','2020-02-27 21:43:05','2020-02-27 21:43:05');
INSERT INTO `transactions` (`id`,`user_id`,`on`,`description`,`amount`,`date`,`type`,`location`,`created_at`,`updated_at`) VALUES (39,1,'Entertainment',NULL,16.32,'2020-02-24','expense','Online','2020-02-27 21:43:23','2020-02-27 21:43:23');