-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `invoice_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `product_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `notes` text COLLATE utf8_unicode_ci NOT NULL,
  `cost` decimal(15,4) NOT NULL,
  `qty` decimal(15,4) DEFAULT 0.0000,
  `tax_name1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_rate1` decimal(13,3) DEFAULT NULL,
  `public_id` int(10) unsigned NOT NULL,
  `custom_value1` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_value2` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_name2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_rate2` decimal(13,3) NOT NULL,
  `invoice_item_type_id` smallint(6) NOT NULL DEFAULT 1,
  `discount` decimal(13,2) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoice_items_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `invoice_items_product_id_foreign` (`product_id`),
  KEY `invoice_items_user_id_foreign` (`user_id`),
  KEY `invoice_items_invoice_id_index` (`invoice_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `invoice_items`
--

INSERT INTO `invoice_items` VALUES
(5, 1, 1, 4, 4, '2020-06-18 18:00:11', '2020-06-18 18:00:11', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues', 40.0000, 1.0000, '', 0.000, 1, NULL, NULL, '', 0.000, 1, 0.00),
(11, 1, 1, 6, 4, '2020-06-18 18:06:12', '2020-06-18 18:06:12', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues', 40.0000, 1.0000, '', 0.000, 5, NULL, NULL, '', 0.000, 1, 0.00),
(14, 1, 1, 7, 4, '2020-06-18 18:20:02', '2020-06-18 18:20:02', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues', 40.0000, 1.0000, '', 0.000, 6, NULL, NULL, '', 0.000, 1, 0.00),
(16, 1, 1, 8, 4, '2020-06-18 18:58:29', '2020-06-18 18:58:29', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues', 10000.0000, 1.0000, '', 0.000, 7, NULL, NULL, '', 0.000, 1, 0.00),
(19, 1, 1, 9, 3, '2020-06-18 19:33:58', '2020-06-18 19:33:58', NULL, 'Pubes hours', '37.50', 111.0000, 1.0000, '', 0.000, 9, NULL, NULL, '', 0.000, 1, 0.00),
(20, 1, 2, 10, NULL, '2020-06-18 20:26:18', '2020-06-18 20:26:18', NULL, 'Pubes hours', '## Alex Test\r\n\r\nTEST\r\n\r\n### June 19, 2020 2:15 am - 4:45 pm', 3.0000, 710.5000, '', 0.000, 10, NULL, NULL, '', 0.000, 2, 0.00),
(22, 1, 1, 11, 4, '2020-06-19 14:20:57', '2020-06-19 14:20:57', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 40.0000, 1.0000, '', 0.000, 12, '', '', '', 0.000, 1, 0.00),
(23, 1, 2, 12, 2, '2020-06-19 14:24:52', '2020-06-19 14:24:52', NULL, 'VA Anne Work', 'Anne is sexy', 400.0000, 1.0000, '', 0.000, 13, NULL, NULL, '', 0.000, 1, 0.00),
(24, 1, 1, 13, 4, '2020-06-19 14:48:09', '2020-06-19 14:48:09', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 40.0000, 1.0000, '', 0.000, 14, NULL, NULL, '', 0.000, 1, 0.00),
(28, 1, 2, 14, 7, '2020-06-19 15:28:08', '2020-06-19 15:28:08', NULL, 'Bert''s Weekly Pay', 'Eubert''s Total Work Hours - 12 hours\r\nJune 14-June 20', 3.0000, 12.0000, '', 0.000, 15, NULL, NULL, '', 0.000, 1, 0.00),
(32, 1, 1, 16, 1, '2020-06-19 15:43:43', '2020-06-19 15:43:43', NULL, 'Virtual Assistant Hours', 'Hourly Rate For Your Virtual Assistant (From Last Week)', 13.7000, 1.0000, '', 0.000, 17, NULL, NULL, '', 0.000, 1, 0.00),
(34, 1, 1, 17, 4, '2020-06-19 15:46:06', '2020-06-19 15:46:06', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 30.0000, 1.0000, '', 0.000, 19, NULL, NULL, '', 0.000, 1, 0.00),
(35, 1, 1, 15, 4, '2020-06-19 15:47:09', '2020-06-19 15:47:09', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 30.0000, 1.0000, '', 0.000, 20, NULL, NULL, '', 0.000, 1, 0.00),
(36, 1, 2, 18, 1, '2020-06-19 15:56:59', '2020-06-19 15:56:59', NULL, 'Virtual Assistant Hours', 'Bert''s total worked hours for June 14-June 20- 16 hrs', 3.0000, 16.0000, '', 0.000, 21, NULL, NULL, '', 0.000, 1, 0.00),
(37, 1, 2, 19, 1, '2020-06-19 16:01:49', '2020-06-19 16:01:49', NULL, 'Virtual Assistant Hours', 'Sharly''s total worked hours \r\nJune 14- June 20 \r\n5 hrs and 30 minutes', 3.0000, 5.5000, '', 0.000, 22, NULL, NULL, '', 0.000, 1, 0.00),
(38, 1, 2, 20, 4, '2020-06-20 12:30:02', '2020-06-20 12:30:02', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant (JUNE TO JULY)', 40.0000, 1.0000, '', 0.000, 23, NULL, NULL, '', 0.000, 1, 0.00),
(39, 1, 2, 21, 7, '2020-06-20 12:31:33', '2020-06-20 12:31:33', NULL, 'Bert''s Weekly Pay', 'Eubert''s Total Work Hours - 12 hours\r\nJune 14-June 20', 3.0000, 12.0000, '', 0.000, 24, NULL, NULL, '', 0.000, 1, 0.00),
(45, 1, 1, 23, 7, '2020-06-23 00:18:05', '2020-06-23 00:18:05', NULL, 'Bert''s Weekly Pay', 'Eubert''s Total Work Hours - 12 hours\r\nJune 14-June 20', 3.0000, 1.0000, '', 0.000, 27, NULL, NULL, '', 0.000, 1, 0.00),
(46, 1, 1, 23, 7, '2020-06-23 00:18:05', '2020-06-23 00:18:05', NULL, 'Bert''s Weekly Pay', 'Eubert''s Total Work Hours - 12 hours\r\nJune 14-June 212', 3.0000, 1.0000, '', 0.000, 28, NULL, NULL, '', 0.000, 1, 0.00),
(48, 1, 1, 22, 4, '2020-06-23 00:27:54', '2020-06-23 00:27:54', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant (JUNE TO JULY)', 40.0000, 1.0000, '', 0.000, 29, NULL, NULL, '', 0.000, 1, 0.00),
(49, 1, 1, 22, 4, '2020-06-23 00:27:54', '2020-06-23 00:27:54', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jun 22, 2020', 2.0000, 1.0000, '', 0.000, 30, NULL, NULL, '', 0.000, 3, 0.00),
(51, 1, 2, 25, 4, '2020-06-25 22:15:10', '2020-06-25 22:15:10', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant (JUNE TO JULY)', 140.0000, 1.0000, '', 0.000, 32, NULL, NULL, '', 0.000, 1, 0.00),
(53, 1, 1, 24, 8, '2020-06-26 02:10:02', '2020-06-26 02:10:02', NULL, 'Weekly Pay', '', 34.0000, 1.0000, '', 0.000, 34, NULL, NULL, '', 0.000, 1, 0.00),
(65, 1, 1, 27, 7, '2020-06-26 03:10:33', '2020-06-26 03:10:33', NULL, 'Bert''s Weekly Pay', 'Eubert''s Total Work Hours - 12 hours\r\nJune 14-June 212', 3.0000, 1.0000, '', 0.000, 35, NULL, NULL, '', 0.000, 1, 0.00),
(66, 1, 1, 27, 7, '2020-06-26 03:10:33', '2020-06-26 03:10:33', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jun 25, 2020', 0.1500, 1.0000, '', 0.000, 36, NULL, NULL, '', 0.000, 3, 0.00),
(69, 1, 1, 28, 6, '2020-06-26 03:17:54', '2020-06-26 03:17:54', NULL, 'Prepay', 'Prepayment For Future Services', 100.0000, 1.0000, '', 0.000, 37, NULL, NULL, '', 0.000, 1, 0.00),
(70, 1, 1, 28, 5, '2020-06-26 03:17:54', '2020-06-26 03:17:54', NULL, 'Misc', 'Misc Charge Not Listed', 3.0000, 1.0000, '', 0.000, 38, NULL, NULL, '', 0.000, 1, 0.00),
(72, 1, 2, 29, NULL, '2020-06-26 17:40:49', '2020-06-26 17:40:49', NULL, '', '## Kate''s Requests\r\n\r\nCasting\r\n\r\n### June 26, 2020 12:05 pm - 4:05 pm', 3.0000, 4.0000, '', 0.000, 39, NULL, NULL, '', 0.000, 2, 0.00),
(74, 1, 2, 30, NULL, '2020-06-26 17:45:08', '2020-06-26 17:45:08', NULL, '', '## Marcela''s Project\r\n\r\nYT/Podcasts\r\n\r\n### June 23, 2020 12:04 pm - 3:04 pm', 5.0000, 3.0000, '', 0.000, 40, NULL, NULL, '', 0.000, 2, 0.00),
(75, 1, 2, 31, NULL, '2020-06-26 17:47:50', '2020-06-26 17:47:50', NULL, 'VA Hours', '## Joe''s Requests\r\n\r\nIG\r\n\r\n### June 20, 2020 11:53 am - 2:23 pm\r\n### June 21, 2020 11:53 am - 1:23 pm\r\n### June 22, 2020 11:54 am - 12:54 pm\r\n### June 23, 2020 11:54 am - 1:24 pm\r\n### June 24, 2020 11:55 am - 1:25 pm\r\n### June 25, 2020 12:01 pm - 1:31 pm\r\n### June 26, 2020 12:01 pm - 1:31 pm', 3.0000, 11.0100, '', 0.000, 41, NULL, NULL, '', 0.000, 2, 0.00),
(76, 1, 2, 32, NULL, '2020-06-26 17:50:07', '2020-06-26 17:50:07', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nHours for calling alex lola\r\n\r\n### June 23, 2020 12:30 pm - 1:30 pm', 3.0000, 1.0000, '', 0.000, 42, NULL, NULL, '', 0.000, 2, 0.00),
(77, 1, 2, 33, NULL, '2020-06-26 17:51:22', '2020-06-26 17:51:22', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nTuesday, June 23, 2020\r\n  - Training in Anna System (Invoice Ninja)\r\n  - Work on LinkedIn (replied to messages, sent messages and connect) - Evening only\r\n  - Message Alex Lola. Because she''s not answering my call for 3x. \r\n  - Withdraw all the Business Group on LinkedIn that still not accepting us. \r\n  - Add/join an additional 5 business owners group\r\n  - Sent follow up emails to "TARGET MARKET LINKEDIN" \r\n\r\nWednesday, June 24, 2020\r\n  - Work in LinkedIn (replied to a message, sent message and connect) - Morning and Evening\r\n  - Call Alex''s grandma and ask if she needs help this week and she said nothing. \r\n  - Check "TARGET MARKET - LINKEDIN" new group but still waiting for approval as of today (June 24)\r\n  - Search for target clients on "TARGET MARKET - LINKEDIN".\r\n\r\nThursday, June 25, 2020\r\n  - Work on LinkedIn (replied to message, connect) - Morning and Evening\r\n  - Search for traget clients on "FB GROUP BUSINESS OWNERS"\r\n  - Search for target clients on "INSTAGRAM TASK"\r\n  - Search for target clients on "YELP Leads"\r\n  - Search for target clients on "FB PAGE GROUP TARGET MARKET "\r\n\r\nFriday, June 26, 2020\r\n  - Work on LinkedIn (sent messages and connect) - Morning only\r\n  - Sent emails to "FB PAGE GROUP TARGET MARKET" target clients\r\n  - Sent emails to "YELP Leads" target clients\r\n  - Sent emails to "TARGET MARKET - LINKEDIN" target clients\r\n  - Sent emails to "INSTAGRAM TASK" target clients\r\n  - Sent emails to "FB GROUP BUSINESS OWNERS" target clients\r\n\r\n### June 22, 2020 11:31 pm - 1:27 am\r\n### June 23, 2020 11:39 pm - 12:55 am\r\n### June 24, 2020 12:42 pm - 2:33 pm\r\n### June 25, 2020 12:43 pm - 1:33 pm', 3.0000, 5.8800, '', 0.000, 43, NULL, NULL, '', 0.000, 2, 0.00),
(79, 1, 2, 34, NULL, '2020-06-26 17:54:42', '2020-06-26 17:54:42', NULL, '', '## Email Support\r\n\r\nJune 21- June 27\r\n\r\nSaturday, June 20, 2020\r\n  - Replied to 10 emails\r\n  - Update CS Form sheet\r\n  - Update Shipping Update for Anita sheet.\r\n  - Sent new customers concern to paul\r\n\r\nSunday, June 21, 2020\r\n  - Replied to 5 emails\r\n  - Update CS Form sheet\r\n  - Sent new customers concern to paul\r\n\r\nMonday, June 22, 2020\r\n  - Replied to 5 emails\r\n  - Update CS Forms sheet\r\n  - Update Shipping Update for Anita sheet\r\n\r\nTuesday, June 23, 2020\r\n  - Replied to 7 emails\r\n  - Update CS Form sheet\r\n  - Update Shipping Update fro Anita sheet\r\n  - Message Paul the new set of customers concenrs\r\n\r\nWednesday, June 24, 2020\r\n  - Replied to 3 emails\r\n  - Update CS Form sheet\r\n  - Update Shipping Update to Anit sheet\r\n  - Update Emails sheet\r\n  - message paul about new set of customers concern\r\n\r\nThursday, June 25, 2020\r\n  - Replied to 6 emails\r\n  - Send new customers concerns to paul\r\n\r\nFriday, June 26, 2020\r\n  - Replied to 8 emails\r\n  - Update CS Forms sheet\r\n  - Update Shipping Update for Anita sheet.\r\n  - Replied to 2 sets of customers concerns\r\n\r\n### June 20, 2020 8:15 am - 9:34 am\r\n### June 20, 2020 10:00 pm - 10:35 pm\r\n### June 21, 2020 10:32 pm - 11:12 pm\r\n### June 23, 2020 10:20 am - 11:06 am\r\n### June 24, 2020 10:21 am - 11:19 am\r\n### June 25, 2020 10:21 am - 10:46 am\r\n### June 26, 2020 12:22 pm - 1:22 pm', 3.0000, 5.7200, '', 0.000, 44, NULL, NULL, '', 0.000, 2, 0.00),
(80, 1, 2, 35, 8, '2020-06-26 18:07:46', '2020-06-26 18:07:46', NULL, 'Weekly Pay', 'SHARLY--\r\n6/21-6/27  $34.8\r\n6/1  6/5 - $16.50 \r\n(5 hrs and 30 mins)\r\n6/7-6/13 $45.60 \r\n(6hrs& 30mins. and 6hrs and 3mins) + $6 bonus\r\n6/14-6/20 $34.50 \r\n(5 hrs and 30 minutes- Paul)\r\n (6 hrs- ALEX)  ', 131.4000, 1.0000, '', 0.000, 45, NULL, NULL, '', 0.000, 1, 0.00),
(81, 1, 2, 35, 8, '2020-06-26 18:07:46', '2020-06-26 18:07:46', NULL, 'Weekly Pay', 'BERT -- 12+15+33= 60', 60.0000, 1.0000, '', 0.000, 46, NULL, NULL, '', 0.000, 1, 0.00),
(86, 1, 2, 26, NULL, '2020-06-26 18:40:11', '2020-06-26 18:40:11', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant (JUNE TO JULY)', 50.0000, 1.0000, '', 0.000, 47, NULL, NULL, '', 0.000, 1, 0.00),
(87, 1, 2, 26, NULL, '2020-06-26 18:40:11', '2020-06-26 18:40:44', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jun 26, 2020', 2.5000, 1.0000, '', 0.000, 48, NULL, NULL, '', 0.000, 4, 0.00),
(89, 1, 1, 36, 4, '2020-06-26 19:02:39', '2020-06-26 19:02:39', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant (JUNE TO JULY)', 50.0000, 1.0000, '', 0.000, 49, NULL, NULL, '', 0.000, 1, 0.00),
(90, 1, 1, 37, 1, '2020-06-26 20:06:55', '2020-06-26 20:06:55', NULL, 'VA Hours', 'Virtual Assistant Hours 5/24 - 5/20', 30.0000, 1.0000, '', 0.000, 50, NULL, NULL, '', 0.000, 1, 0.00),
(91, 1, 1, 37, 4, '2020-06-26 20:06:55', '2020-06-26 20:06:55', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant (JUNE TO JULY)', 40.0000, 1.0000, '', 0.000, 51, NULL, NULL, '', 0.000, 1, 0.00),
(92, 1, 1, 37, 1, '2020-06-26 20:06:55', '2020-06-26 20:06:55', NULL, 'VA Hours', 'Virtual Assistant Hours 6/13', 33.0000, 1.0000, '', 0.000, 52, NULL, NULL, '', 0.000, 1, 0.00),
(93, 1, 1, 37, 1, '2020-06-26 20:06:55', '2020-06-26 20:06:55', NULL, 'VA Hours', 'Virtual Assistant Hours 6/6', 30.0000, 1.0000, '', 0.000, 53, NULL, NULL, '', 0.000, 1, 0.00),
(105, 1, 1, 38, NULL, '2020-06-29 19:18:20', '2020-06-29 19:18:20', NULL, 'Corrected Balances', 'Corrected Balances', 18.0000, 1.0000, '', 0.000, 57, NULL, NULL, '', 0.000, 1, 0.00),
(106, 1, 1, 38, NULL, '2020-06-29 19:18:20', '2020-06-29 19:20:22', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jun 29, 2020', 1.0200, 1.0000, '', 0.000, 58, NULL, NULL, '', 0.000, 4, 0.00),
(108, 1, 2, 40, NULL, '2020-06-30 05:01:41', '2020-06-30 05:01:41', NULL, 'Prepay', 'Prepayment For Future Services', 100.0000, 1.0000, '', 0.000, 59, NULL, NULL, '', 0.000, 1, 0.00),
(109, 1, 2, 40, NULL, '2020-06-30 05:01:41', '2020-06-30 05:01:58', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jun 30, 2020', 6.0000, 1.0000, '', 0.000, 60, NULL, NULL, '', 0.000, 4, 0.00),
(110, 1, 2, 41, 8, '2020-07-03 15:43:53', '2020-07-03 15:43:53', NULL, 'Weekly Pay', 'Rheina''s Pay June 28- July 4', 34.0000, 1.0000, '', 0.000, 61, NULL, NULL, '', 0.000, 1, 0.00),
(115, 1, 2, 43, NULL, '2020-07-03 15:52:59', '2020-07-03 15:52:59', NULL, 'Weekly Pay', '## Joe''s Requests\r\n\r\nIG\r\n\r\n### June 27, 2020 6:18 pm - 8:18 pm\r\n### June 29, 2020 7:19 am - 8:49 am\r\n### June 30, 2020 7:19 am - 8:50 am\r\n### July 1, 2020 7:20 am - 8:50 am\r\n### July 2, 2020 7:22 am - 8:52 am\r\n### July 3, 2020 7:22 am - 9:22 am\r\n### July 4, 2020 7:23 am - 9:23 am', 3.0000, 12.0100, '', 0.000, 65, NULL, NULL, '', 0.000, 2, 0.00),
(116, 1, 2, 44, NULL, '2020-07-03 15:53:26', '2020-07-03 15:53:26', NULL, 'Weekly Pay', '## Email Support\r\n\r\nJune 28 - July 4, 2020 (Sun-Sat)\r\n\r\nSaturday, June 27, 2020\r\n  - Replied to 4 emails\r\n  - Replied to 12 emails from "ATTENTION" sheet \r\n  - Update CS Forms sheet\r\n  - Update Shipping Update to Anita sheet\r\n  - Update Emails sheet\r\n  - Update Attention sheet\r\n  - Sent new customers concern to Paul\r\n\r\nSunday, June 28, 2020\r\n  - Replied to 4 email\r\n  - Update CS Forms sheet\r\n  - Update ATTENTION sheet\r\n  - Update EMAILS sheet\r\n  - Update Shipping Update to Anita sheet\r\n  - Replied to 1 email from "ATTENTION" sheet \r\n\r\nMonday, June 29, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Form sheet\r\n\r\nTuesday, June 30, 2020\r\n  - Replied to 1 email\r\n  - message paul about new set of customers concern\r\n  - Update CS Form sheet\r\n  - Replied to 3 emails from customers concern sent to Paul\r\n\r\nWednesday, July 1, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Sent new customers concern to paul\r\n  - Replied to 4 emails from customers concern sent to Paul\r\n\r\nThursday, July 2, 2020\r\n  - Replied to 2 emails\r\n  - Update EMAILS sheet\r\n  - Sent 1 customer concern to Paul\r\n\r\nFriday, July 3, 2020\r\n  - Replied to 5 emails\r\n  - Sent 5 emails from customer concer.\r\n  - Update CS Form sheet\r\n  - message paul about new set of customers concern\r\n  - Updpate EMAILS sheet\r\n\r\n### June 26, 2020 8:29 pm - 9:39 pm\r\n### June 27, 2020 8:31 pm - 9:44 pm\r\n### June 28, 2020 8:32 pm - 8:52 pm\r\n### June 29, 2020 8:33 pm - 8:53 pm\r\n### June 30, 2020 8:35 pm - 9:35 pm\r\n### July 1, 2020 8:36 pm - 8:46 pm\r\n### July 3, 2020 9:37 am - 10:37 am', 3.0000, 5.2200, '', 0.000, 66, NULL, NULL, '', 0.000, 2, 0.00),
(122, 1, 2, 46, NULL, '2020-07-03 18:34:57', '2020-07-03 18:34:57', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nJuly 1-3, 2020 (Wed-Fri)\r\n\r\nWednesday, July 1, 2020\r\n  - Call Alex grandma and ask if she needs help this week and she said nothing. \r\n\r\nThursday, July 2, 2020\r\n  - Call Alex grandma as per Alex. And also ask if she needs anything. She said she only needs the thing about Dr.Murray \r\n\r\nFriday, July 3, 2020\r\n  - Read reviews about Dr.Murray\r\n  - Call Alex grandma and explain some things about Dr.Murray\r\n\r\n### June 30, 2020 8:42 pm - 8:52 pm\r\n### July 2, 2020 9:43 am - 9:53 am\r\n### July 3, 2020 9:44 am - 10:04 am', 3.0000, 0.6700, '', 0.000, 72, NULL, NULL, '', 0.000, 2, 0.00),
(136, 1, 2, 45, 13, '2020-07-03 18:38:10', '2020-07-03 18:38:10', NULL, 'June 28- July 4', 'Sharly- 5 hrs 22 Mins (PAUL) + Alex', 17.6700, 1.0000, '', 0.000, 73, NULL, NULL, '', 0.000, 1, 0.00),
(137, 1, 2, 45, 13, '2020-07-03 18:38:10', '2020-07-03 18:38:10', NULL, 'June 28- July 4', 'Bert- 12 hours and 01 (JOE)', 36.0300, 1.0000, '', 0.000, 74, NULL, NULL, '', 0.000, 1, 0.00),
(138, 1, 2, 45, 13, '2020-07-03 18:38:10', '2020-07-03 18:38:10', NULL, 'June 28- July 4', 'Bert- 32.01 hours (MARCELLA)', 160.0500, 1.0000, '', 0.000, 75, NULL, NULL, '', 0.000, 1, 0.00),
(139, 1, 2, 45, 13, '2020-07-03 18:38:10', '2020-07-03 23:18:24', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 3, 2020', 12.7000, 1.0000, '', 0.000, 76, NULL, NULL, '', 0.000, 4, 0.00),
(157, 1, 2, 42, NULL, '2020-07-03 19:32:24', '2020-07-03 19:32:24', NULL, 'Weekly Pay', '## Marcela''s Project\r\n\r\nEcom and Pocast --- Bert\r\n\r\n### June 29, 2020 7:25 am - 1:25 pm\r\n### June 30, 2020 7:25 am - 1:25 pm\r\n### July 1, 2020 7:25 am - 2:26 pm\r\n### July 2, 2020 7:26 am - 2:26 pm\r\n### July 3, 2020 7:26 am - 1:26 pm', 5.0000, 32.0100, '', 0.000, 77, NULL, NULL, '', 0.000, 2, 0.00),
(158, 1, 2, 42, NULL, '2020-07-03 19:32:24', '2020-07-03 19:32:45', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 3, 2020', 8.0000, 1.0000, '', 0.000, 78, NULL, NULL, '', 0.000, 4, 0.00),
(166, 1, 2, 39, NULL, '2020-07-08 01:05:09', '2020-07-08 01:05:09', NULL, '1 Flyer', '1 flyer for Decks for Less', 5.0000, 1.0000, '', 0.000, 79, NULL, NULL, '', 0.000, 1, 0.00),
(167, 1, 2, 39, NULL, '2020-07-08 01:05:09', '2020-07-08 01:05:09', NULL, '1 Business Card', '1 business card for Decks for less', 5.0000, 1.0000, '', 0.000, 80, NULL, NULL, '', 0.000, 1, 0.00),
(168, 1, 2, 39, NULL, '2020-07-08 01:05:09', '2020-07-08 01:07:56', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 7, 2020', 0.5000, 1.0000, '', 0.000, 81, NULL, NULL, '', 0.000, 4, 0.00),
(173, 1, 2, 47, NULL, '2020-07-08 01:21:18', '2020-07-08 01:21:18', NULL, 'Bonus', '--for Rheina \r\nTHANK YOU SO MUCH, FLO!', 40.0000, 1.0000, '', 0.000, 82, NULL, NULL, '', 0.000, 1, 0.00),
(174, 1, 2, 47, NULL, '2020-07-08 01:21:18', '2020-07-08 01:21:49', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 7, 2020', 2.0000, 1.0000, '', 0.000, 83, NULL, NULL, '', 0.000, 4, 0.00),
(175, 1, 2, 48, NULL, '2020-07-10 16:00:33', '2020-07-10 16:00:33', NULL, '', '## Email Support\r\n\r\nSunday, July 5, 2020\r\n  - Replied to email\r\n  - Update CS Form sheet\r\n  - Update EMAILS sheet\r\n  - message paul about new set of customers concern\r\n\r\nMonday. July 6, 2020\r\n  - Replied to email\r\n  - message paul about new set of customers concern\r\n  - Update CS Form sheet\r\n\r\nTuesday, July 7, 2020\r\n  - Replied to emails\r\n  - Update EMAILS sheet\r\n  - Replied 7 emails from customers concern\r\n  - Update CS Forms sheet\r\n  - message paul about new set of customers concern\r\n\r\nWednesday, July 8, 2020\r\n  - Replied to emails\r\n  - Update EMAILS sheet\r\n  - Message Paul 1 customer concern\r\n  - Update CS Forms sheet\r\n  - Sent 3 emails from customer concern\r\n\r\nThursday, July 9, 2020\r\n  - Replied to emails\r\n  - Update EMAILS sheet\r\n  - Update CS Forms sheet\r\n  - message paul about new set of customers concern\r\n  - List new set of customers concerns\r\n\r\nFriday, July 10, 2020\r\n  - Update EMAILS sheet\r\n  - List new set of customers concerns\r\n  - message paul about new set of customers concern\r\n\r\n### July 5, 2020 9:54 am - 10:14 am\r\n### July 6, 2020 9:55 am - 10:25 am\r\n### July 7, 2020 9:56 am - 10:56 am\r\n### July 8, 2020 9:57 am - 11:12 am\r\n### July 9, 2020 9:58 am - 10:58 am\r\n### July 10, 2020 9:59 am - 10:29 am', 3.0000, 4.5900, '', 0.000, 84, NULL, NULL, '', 0.000, 2, 0.00),
(176, 1, 2, 49, NULL, '2020-07-10 16:06:40', '2020-07-10 16:06:40', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nSunday, July 5, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages, accept 3 connections, and connect)\r\n\r\nMonday. July 6, 2020\r\n  - Work on LinkedIn (replied to messages and connect)\r\n  - Search for target clients on TARGET MARKET - LINKEDIN\r\n\r\nTuesday, July 7, 2020\r\n  - Search for target client on INSTAGRAM TASK.\r\n  - Work on LinkedIn (replied to messages and connect)\r\n  - Call grandma but there is no answer\r\n  - Call again Alex grandma and ask if she needs anything for this week and she said nothing. Ask also if she needs some groceries and she can tell me and I''ll pass it to Alex and he will be the one to pay. But for this week, she said nothing. \r\n  - Search for target client on FB GROUP BUSINESS OWNERS\r\n\r\nWednesday, July 8, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages and connect)\r\n  - Search for target client on FB PAGE GROUP TARGET MARKET \r\n\r\nThursday, July 9, 2020\r\n  - Work on LinkedIn (replied to messges, connect and sent messages)\r\n  - Searc for target client on YELP Leads\r\n\r\nFriday, July 10, 2020\r\n  - Work on LinkedIn (replied to messages and connect) \r\n  - Sent emails to YELP Leads target clients\r\n  - Sent emails to TARGET MARKET - LINKEDIN target clients\r\n  - Sent emails to INSTAGRAM TASK target clients\r\n  - Sent emails to FB GROUP BUSINESS OWNERS target clients\r\n  - Sent emails to FB PAGE GROUP TARGET MARKET  target clients\r\n  - Look for target clients VA needs on FB Group Business Owners\r\n\r\nFriday, July 10, 2020\r\n  - $10 Bonus as per Ms.Rheina and Alex -- THANK YOU <3\r\n\r\n### July 5, 2020 10:10 am - 10:30 am\r\n### July 6, 2020 10:10 am - 11:00 am\r\n### July 7, 2020 10:11 am - 11:43 am\r\n### July 8, 2020 10:12 am - 10:57 am\r\n### July 9, 2020 10:12 am - 11:19 am\r\n### July 10, 2020 10:14 am - 11:29 am\r\n### July 10, 2020 9:14 pm - 12:14 am', 3.0000, 8.8200, '', 0.000, 85, NULL, NULL, '', 0.000, 2, 0.00),
(179, 1, 2, 51, NULL, '2020-07-10 16:09:43', '2020-07-10 16:09:43', NULL, '', '## Joe''s Requests\r\n\r\nIG\r\n\r\n### July 5, 2020 9:55 am - 11:56 am\r\n### July 6, 2020 9:56 am - 12:01 pm\r\n### July 7, 2020 9:56 am - 11:26 am\r\n### July 8, 2020 9:57 am - 11:27 am\r\n### July 9, 2020 9:57 am - 11:57 am\r\n### July 10, 2020 9:57 am - 11:57 am\r\n### July 11, 2020 9:57 am - 11:58 am', 3.0000, 13.0900, '', 0.000, 87, NULL, NULL, '', 0.000, 2, 0.00),
(180, 1, 2, 52, NULL, '2020-07-10 16:14:19', '2020-07-10 16:14:19', NULL, '', '## bonus\r\n\r\nBonus\r\n\r\n### July 10, 2020 10:05 am - 1:05 pm', 0.0000, 3.0000, '', 0.000, 88, NULL, NULL, '', 0.000, 2, 0.00),
(181, 1, 2, 50, NULL, '2020-07-10 16:14:48', '2020-07-10 16:14:48', NULL, '', '## Marcela''s Project\r\n\r\nEcom and Podcast Guest\r\n\r\n### July 7, 2020 10:00 am - 1:00 pm\r\n### July 8, 2020 10:00 am - 4:00 pm\r\n### July 9, 2020 10:00 am - 4:00 pm\r\n### July 10, 2020 10:01 am - 4:01 pm', 5.0000, 21.0100, '', 0.000, 89, NULL, NULL, '', 0.000, 2, 0.00),
(186, 1, 2, 54, NULL, '2020-07-14 16:00:17', '2020-07-14 16:00:17', NULL, '', '## Marcela''s Project\r\n\r\nEcom/Podcast\r\n\r\n### July 7, 2020 9:41 am - 12:41 pm\r\n### July 7, 2020 10:41 pm - 4:41 am\r\n### July 8, 2020 10:41 pm - 4:42 am', 5.0000, 15.0100, '', 0.000, 92, NULL, NULL, '', 0.000, 2, 0.00),
(187, 1, 2, 54, NULL, '2020-07-14 16:00:17', '2020-07-14 16:00:51', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 14, 2020', 3.7500, 1.0000, '', 0.000, 93, NULL, NULL, '', 0.000, 4, 0.00),
(188, 1, 2, 53, 15, '2020-07-14 17:14:38', '2020-07-14 17:14:38', NULL, 'Sharly', 'Sharly: \r\n       Paul (4.59hrs) --- $13.77\r\n       Alex (8.82hrs) --- $26.46\r\n      BONUS           ---- $10 \r\n   TOTAL                    $50.23', 50.2300, 1.0000, '', 0.000, 94, NULL, NULL, '', 0.000, 1, 0.00),
(189, 1, 2, 53, 16, '2020-07-14 17:14:38', '2020-07-14 17:14:38', NULL, 'bert', 'Joe     (13hrs) ---- $39.27\r\n        BONUS             -----$10', 49.2700, 1.0000, '', 0.000, 95, NULL, NULL, '', 0.000, 1, 0.00),
(190, 1, 1, 5, 4, '2020-07-14 17:20:11', '2020-07-14 17:20:11', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 40.0000, 1.0000, '', 0.000, 96, NULL, NULL, '', 0.000, 1, 0.00),
(198, 1, 2, 55, 8, '2020-07-14 17:28:43', '2020-07-14 17:28:43', NULL, 'Weekly Pay', 'Bert''s pay from Marcella. -Delay', 75.0000, 1.0000, '', 0.000, 97, NULL, NULL, '', 0.000, 1, 0.00),
(199, 1, 2, 55, 17, '2020-07-14 17:28:43', '2020-07-14 17:28:43', NULL, 'week', 'Bert''s Early Pay (Joe''s last remaining credit', 39.2000, 1.0000, '', 0.000, 98, NULL, NULL, '', 0.000, 1, 0.00),
(202, 1, 1, 56, NULL, '2020-07-14 18:11:18', '2020-07-14 18:11:18', NULL, '', '## Joe''s Requests\r\n\r\nIG #\r\n\r\n### July 11, 2020 11:33 pm - 1:33 am\r\n### July 12, 2020 12:33 pm - 2:33 pm\r\n### July 13, 2020 12:34 pm - 2:34 pm\r\n### July 14, 2020 12:34 pm - 2:36 pm\r\n### July 15, 2020 12:34 pm - 2:34 pm\r\n### July 16, 2020 12:35 pm - 1:35 pm', 3.0000, 13.0000, '', 0.000, 99, NULL, NULL, '', 0.000, 2, 0.00),
(203, 1, 2, 57, 8, '2020-07-15 19:15:28', '2020-07-15 19:15:28', NULL, 'Weekly Pay', 'Rheina''s pay for July 5- July 11 (Late Invoice)', 30.0000, 1.0000, '', 0.000, 100, NULL, NULL, '', 0.000, 1, 0.00),
(204, 1, 2, 58, NULL, '2020-07-17 15:38:46', '2020-07-17 15:38:46', NULL, '', '## Email Support\r\n\r\nSaturday, July 11, 2020\r\n  - Replied to 6 emails from customers concern\r\n  - Update EMAILS sheet\r\n\r\nSunday, July 12, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 1 email\r\n  - message paul about new set of customers concern\r\n\r\nMonday, July 13, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 4 emails\r\n\r\nTuesday, July 14, 2020\r\n  - Replied to 4 emails \r\n  - Update EMAIL sheet\r\n  - Update CS Form sheet\r\n  - Message Paul about the new set of customers concern\r\n\r\nWednesday, July 15, 2020\r\n  - Update EMAIL sheet\r\n  - Replied to 4 emails\r\n  - Update CS Forms sheet\r\n  - Update Shipping Update for Anita\r\n  - Replied to 9 emails from customer concerns that I sent to Paul\r\n  - message paul about new set of customers concern\r\n\r\nThursday, July 16, 2020\r\n  - Replied to 9 emails\r\n  - Update EMAIL sheet\r\n  - Update CS Forms sheet\r\n\r\nFriday, July 17, 2020\r\n  - Replied to 3 emails\r\n  - Update EMAIL sheet\r\n  - Update CS Forms sheet\r\n  - Sent new set of customers concern to Paul\r\n  - Update ATTENTION sheet\r\n\r\n### July 11, 2020 9:59 am - 10:39 am\r\n### July 12, 2020 10:00 am - 10:30 am\r\n### July 13, 2020 10:00 am - 10:20 am\r\n### July 14, 2020 10:01 am - 10:41 am\r\n### July 15, 2020 10:02 am - 11:12 am\r\n### July 16, 2020 10:03 am - 10:43 am\r\n### July 17, 2020 10:04 am - 11:14 am', 3.0000, 5.1700, '', 0.000, 101, NULL, NULL, '', 0.000, 2, 0.00),
(205, 1, 2, 59, NULL, '2020-07-17 22:10:57', '2020-07-17 22:10:57', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nTuesday, July 14, 2020\r\n  - Call grandma but there is no answer. So I sent a voice mail. \r\n\r\nWednesday, July 15, 2020\r\n  - Call Alex Lola and ask if she needs something or some grocery list for this week and she said she will call me back. Or I told her that she can leave a voice message if ever she needs more time because she''s taking something on her husband.\r\n\r\n### July 14, 2020 10:06 am - 10:16 am\r\n### July 15, 2020 10:08 am - 10:18 am', 3.0000, 0.3400, '', 0.000, 102, NULL, NULL, '', 0.000, 2, 0.00),
(217, 1, 2, 62, 8, '2020-07-21 20:09:29', '2020-07-21 20:09:29', NULL, 'Weekly Pay', '## Marcela''s Project\r\n\r\nYT/Podcast/ecom and others\r\n\r\n### July 12, 2020 2:11 pm - 7:12 pm\r\n### July 13, 2020 2:13 pm - 3:13 pm\r\n### July 14, 2020 2:13 pm - 5:43 pm\r\n### July 15, 2020 2:14 pm - 6:14 pm\r\n### July 16, 2020 2:14 pm - 7:14 pm', 5.0000, 18.5200, '', 0.000, 108, NULL, NULL, '', 0.000, 1, 0.00),
(219, 1, 2, 60, NULL, '2020-07-21 22:04:47', '2020-07-21 22:04:47', NULL, '', '## Marcela''s Project\r\n\r\nYT/Podcast/ecom and others\r\n\r\n### July 12, 2020 2:11 pm - 7:12 pm\r\n### July 13, 2020 2:13 pm - 3:13 pm\r\n### July 14, 2020 2:13 pm - 5:43 pm\r\n### July 15, 2020 2:14 pm - 6:14 pm\r\n### July 16, 2020 2:14 pm - 7:14 pm', 5.0000, 18.5200, '', 0.000, 109, NULL, NULL, '', 0.000, 2, 0.00),
(220, 1, 2, 60, NULL, '2020-07-21 22:04:47', '2020-07-21 22:05:36', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 21, 2020', 4.6300, 1.0000, '', 0.000, 110, NULL, NULL, '', 0.000, 4, 0.00),
(221, 1, 2, 61, 8, '2020-07-22 00:20:49', '2020-07-22 00:20:49', NULL, 'Weekly Pay', 'Bert\r\nMarcella (18:52 hours)', 92.6000, 1.0000, '', 0.000, 111, NULL, NULL, '', 0.000, 1, 0.00),
(222, 1, 2, 61, 8, '2020-07-22 00:20:49', '2020-07-22 00:20:49', NULL, 'Weekly Pay', 'Sharly \r\nPaul (5:17 hours) $15.51\r\n\r\nAlex (20 minutes) $1.02', 16.5300, 1.0000, '', 0.000, 112, NULL, NULL, '', 0.000, 1, 0.00),
(223, 1, 2, 61, 8, '2020-07-22 00:20:49', '2020-07-22 00:20:49', NULL, 'Weekly Pay', 'Bert''Pay from Marcella \r\nJuly 11-July 17', 92.6200, 1.0000, '', 0.000, 113, NULL, NULL, '', 0.000, 1, 0.00),
(224, 1, 2, 63, NULL, '2020-07-24 17:35:55', '2020-07-24 17:35:55', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nJuly 19-25, 2020 (Sun-Sat)\r\n\r\nSaturday, July 18, 2020\r\n  - Work on LinkedIn (sent message and connect)\r\n\r\nSunday, July 19, 2020\r\n  - Work on LinkedIn (sent messages and connect)\r\n  - Search for target client on FB GROUP BUSINESS OWNERSJoined 3 new FB Page Group\r\n\r\nMonday, July 20, 2020\r\n  - Work on LinkedIn (sent message and connect) \r\n  - Got approved on 3 new groupf from FB GROUP BUSINESS OWNERS\r\n  - Search for target client on new FB GROUP BUSINESS OWNERS groups\r\n  - Search for target client on INSTAGRAM TASK.\r\n\r\nTuesday, July 21, 2020\r\n  - Work on LinkedIn (replied to messages, sent message and connect)\r\n  - Search for target client on TARGET MARKET - LINKEDIN\r\n  - Call Alex grandma (twice) but there is no answer. I just leave a voice message and will contact her again tomorrow. \r\n\r\nWednesday, July 22, 2020\r\n  - Work on LinkedIn (replied to messages and sent messages)\r\n  - Sent 81 new messages to LinkedIN\r\n  - Search for target client on INSTAGRAM TASK.\r\n  - Call Alex grandma and ask if she needs help of need some grocery but she said shes fine.\r\n  \r\nTursday, July 23, 2020\r\n  - Work on LinkedIn (replied to messages, connect and sent messages)\r\n  - Search for target clients on LINKEDIN LEADS\r\n\r\nFriday, July 24, 2020\r\n  - Work on LinkedIn (replied to messages and send message)\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Sent emails to FB TARGET LEADS\r\n  - Sent emails to FB PAGE GROUP TARGET MARKET  target clients\r\n\r\nJuly 25, 2020\r\n  - CA Meeting\r\n\r\nPS. It''s ok to Ms.Rheina and Alex if you pay only the 7hrs.\r\n\r\n### July 18, 2020 11:43 am - 11:53 am\r\n### July 19, 2020 11:44 am - 12:44 pm\r\n### July 20, 2020 10:54 pm - 11:54 pm\r\n### July 21, 2020 11:48 am - 12:48 pm\r\n### July 22, 2020 11:49 am - 1:19 pm\r\n### July 23, 2020 11:51 am - 12:51 pm\r\n### July 24, 2020 11:55 am - 1:56 pm\r\n### July 24, 2020 10:59 pm - 11:29 pm', 3.0000, 8.1800, '', 0.000, 114, NULL, NULL, '', 0.000, 2, 0.00),
(225, 1, 2, 64, NULL, '2020-07-24 17:37:08', '2020-07-24 17:37:08', NULL, '', '## Email Support\r\n\r\nJuly 19-25, 2020 (Sun-Sat)\r\n\r\nSaturday, July 18, 2020\r\n  - Replied to 3 emails\r\n  - Update EMAIL sheet\r\n  - Update Shipping Update for Anita\r\n  - Replied to 8 customer concern\r\n  - Update CS Forms sheet\r\n\r\nSunday, July 19, 2020\r\n  - Replied to 3 emails\r\n  - Update CS Form sheet\r\n  - Update EMAIL sheet\r\n  - Sent new set of customers concern to Paul\r\n\r\nMonday, July 20, 2020\r\n  - Replied to 4 emails\r\n  - Update CS Form sheet\r\n  - Sent 1 customer concern to Paul\r\n  - Sent follow up customers concerns to Paul\r\n\r\nTuesday, July 21, 2020\r\n  - Replied to 1 email\r\n  - Update CS Form sheet\r\n  - Update EMAILS sheet\r\n  - Sent new set of customers concern to Paul\r\n\r\nWednesday, July 22, 2020\r\n  - Replied to 5 emails\r\n  - Replied to 8 emails from customers concern\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Sent 2 customers concern from Paul\r\n  - Replied to Paul''s and Anita''s messages on Skype Group Chat\r\n  - Sent 1 customer concern to Anita\r\n\r\nThursday, July 23, 2020\r\n  - Repllied to 2 emails\r\n  - Update EMAIL sheet\r\n  - Update CS Forms sheet\r\n  - Sent customerc concerns reply to our emails.\r\n  - Message back Anita regarding 1 customer concern\r\n\r\nFriday, July 24, 2020\r\n  - Replied to 2 emails\r\n  - Sent 1 customer concern to Anita\r\n  - Update CS Form sheet\r\n  - Replied to 4 customers concerns from Paul\r\n  - Replied to Anita''s messages\r\n\r\n### July 18, 2020 10:51 am - 11:51 am\r\n### July 19, 2020 10:53 am - 11:23 am\r\n### July 20, 2020 10:56 am - 11:26 am\r\n### July 21, 2020 10:59 am - 11:29 am\r\n### July 22, 2020 9:03 am - 10:04 am\r\n### July 22, 2020 10:08 pm - 10:38 pm\r\n### July 23, 2020 11:26 am - 12:16 pm', 3.0000, 4.8500, '', 0.000, 115, NULL, NULL, '', 0.000, 2, 0.00),
(234, 1, 1, 67, NULL, '2020-07-27 16:47:46', '2020-07-27 16:47:46', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant (JUNE TO JULY)', 50.0000, 1.0000, '', 0.000, 121, NULL, NULL, '', 0.000, 1, 0.00),
(235, 1, 1, 67, NULL, '2020-07-27 16:47:46', '2020-07-27 16:48:23', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 27, 2020', 2.0000, 1.0000, '', 0.000, 122, NULL, NULL, '', 0.000, 4, 0.00),
(240, 1, 2, 68, NULL, '2020-07-28 16:52:47', '2020-07-28 16:52:47', NULL, '', '## Marcela''s Project\r\n\r\ntask\r\n\r\n### July 19, 2020 12:57 pm - 3:27 pm\r\n### July 20, 2020 12:57 pm - 3:27 pm\r\n### July 21, 2020 12:58 pm - 2:58 pm\r\n### July 22, 2020 12:58 pm - 2:58 pm\r\n### July 23, 2020 12:58 pm - 3:58 pm', 5.0000, 12.0100, '', 0.000, 123, NULL, NULL, '', 0.000, 2, 0.00),
(241, 1, 2, 68, NULL, '2020-07-28 16:52:47', '2020-07-28 18:23:16', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 28, 2020', 2.0000, 1.0000, '', 0.000, 124, NULL, NULL, '', 0.000, 4, 0.00),
(245, 1, 2, 65, 8, '2020-07-28 18:50:57', '2020-07-28 18:50:57', NULL, 'Weekly Pay', 'SHARLY (Alex) 8.10 hrs', 24.5400, 1.0000, '', 0.000, 125, NULL, NULL, '', 0.000, 1, 0.00),
(246, 1, 2, 65, 8, '2020-07-28 18:50:57', '2020-07-28 18:50:57', NULL, 'Weekly Pay', 'SHARLY (Paul) 4.85 hours', 14.5500, 1.0000, '', 0.000, 126, NULL, NULL, '', 0.000, 1, 0.00),
(247, 1, 2, 65, 8, '2020-07-28 18:50:57', '2020-07-28 18:50:57', NULL, 'Weekly Pay', 'BERT (Marcella) 12.01 hrs', 60.0200, 1.0000, '', 0.000, 127, NULL, NULL, '', 0.000, 1, 0.00),
(249, 1, 1, 66, NULL, '2020-07-29 16:58:02', '2020-07-29 16:58:02', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 30.0000, 1.0000, '', 0.000, 128, NULL, NULL, '', 0.000, 1, 0.00),
(250, 1, 1, 66, NULL, '2020-07-29 16:58:02', '2020-07-29 16:58:20', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Jul 29, 2020', 2.0000, 1.0000, '', 0.000, 129, NULL, NULL, '', 0.000, 4, 0.00),
(251, 1, 2, 69, NULL, '2020-07-31 16:46:46', '2020-07-31 16:46:46', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nJuly 26-August 1, 2020 (Sun-Sat)\r\n\r\nTuesday, July 28, 2020\r\n  - Work on LinkedIn (connect and sent message)\r\n\r\nWednesday, July 29, 2020\r\n  - Work on LinkedIn (replied to messages and sent 20 new messages)\r\n  - Search for new target clients on INSTAGRAM LEADS\r\n  - Call Alex grandma and ask if she needs anything for this week but she said no.\r\n\r\nThursday, July 30, 2020\r\n  - Work on LinkedIn (replied to messages and sent message)\r\n  - Search for target clients on LINKEDIN LEADS\r\n\r\nFriday, July 31, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages and connect)\r\n  - Search for taget clients on FB TARGET LEADS\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Sent emails to FB TARGET LEADS\r\n\r\n### July 28, 2020 9:50 am - 10:00 am\r\n### July 29, 2020 9:50 am - 10:55 am\r\n### July 30, 2020 9:51 am - 10:56 am\r\n### July 31, 2020 9:52 am - 11:22 am', 3.0000, 3.8400, '', 0.000, 130, NULL, NULL, '', 0.000, 2, 0.00),
(252, 1, 2, 70, NULL, '2020-07-31 16:47:37', '2020-07-31 16:47:37', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nFind leads on LinkedIn / Connect on business owners and get contact information\r\n\r\n### July 26, 2020 11:00 am - 12:00 pm\r\n### July 27, 2020 11:00 am - 12:00 pm', 3.0000, 2.0000, '', 0.000, 131, NULL, NULL, '', 0.000, 2, 0.00),
(253, 1, 2, 71, NULL, '2020-07-31 16:51:46', '2020-07-31 16:51:46', NULL, '', '## Email Support\r\n\r\nJuly 26-August 1, 2020 (Sun-Sat)\r\n\r\nSaturday, July 25, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 5 emails\r\n  - Update CS Forms sheet\r\n  - Replied to 1 email fom customer concerns from Anita\r\n  - Replied to Anita''s messages\r\n  - Message Paul for 2 new customers concerns\r\n\r\nSunday, July 26, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 1 email\r\n  - Update CS Form sheet\r\n  - Message 1 customer concern to Paul\r\n\r\nMonday, July 27, 2020\r\n  - Repllied to 2 emails\r\n  - Update EMAILS sheet\r\n  - Update CS Forms sheet\r\n\r\nTuesday, July 28, 2020\r\n  - Replied to Anita''s messages\r\n  - Replied to Paul''s question\r\n  - Replied to 1 previous customer concer from Paul\r\n  - Replied to 4 emails\r\n  - Update EMAILS sheet\r\n  - Sent 3 customers concerns to Anita\r\n  - Update CS Forms sheet\r\n\r\nWednesday, July 29, 2020\r\n  - Replied to Anita''s messages\r\n  - Update EMAILS sheet\r\n  - Replied to 1 email\r\n  - Update CS Forms sheet\r\n  - Replied to Paul''s messages regarding customer concerns\r\n  - Replied to 1 customers concern from Paul\r\n  - Message Paul about customer concern\r\n\r\nThursday, July 30, 2020\r\n  - Message Anita for 1 customer concern\r\n  - Udate EMAILS sheet\r\n  - Message Paul about 1 customer concern\r\n\r\nFriday, July 31, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Replied to Paul''s messages\r\n  - Replied to 2 customers concern from Paul\r\n  - Message Paul about customers concern in Skype\r\n  - Sent to Paul the 3 customers concerns from Skype\r\n\r\n### July 25, 2020 9:38 am - 10:38 am\r\n### July 26, 2020 9:38 am - 10:03 am\r\n### July 27, 2020 9:39 am - 9:59 am\r\n### July 28, 2020 9:41 am - 10:41 am\r\n### July 29, 2020 9:42 am - 10:27 am\r\n### July 30, 2020 9:43 am - 9:58 am\r\n### July 31, 2020 9:44 am - 10:24 am', 3.0000, 4.4200, '', 0.000, 132, NULL, NULL, '', 0.000, 2, 0.00),
(267, 1, 1, 75, 4, '2020-08-04 14:52:04', '2020-08-04 14:52:04', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 65.0000, 1.0000, '', 0.000, 145, NULL, NULL, '', 0.000, 1, 0.00),
(268, 1, 2, 73, NULL, '2020-08-04 14:53:01', '2020-08-05 18:26:48', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Aug 2, 2020', 2.0000, 1.0000, '', 0.000, 146, NULL, NULL, '', 0.000, 4, 0.00),
(269, 1, 2, 73, NULL, '2020-08-04 14:53:01', '2020-08-04 14:53:01', NULL, '', '## Marcela''s Project\r\n\r\nAmazon, Yt podcast collab/ email\r\n\r\n### July 27, 2020 7:01 am - 10:32 am\r\n### July 27, 2020 8:02 pm - 11:08 pm\r\n### July 28, 2020 7:02 am - 10:32 am\r\n### July 29, 2020 7:02 am - 10:02 am\r\n### July 30, 2020 8:02 pm - 11:03 pm', 5.0000, 16.1100, '', 0.000, 147, NULL, NULL, '', 0.000, 2, 0.00),
(276, 1, 2, 74, NULL, '2020-08-04 20:29:24', '2020-08-04 20:29:24', NULL, 'Monthly Service Pay', 'Concierge Assist Monthly Dues (1) Virtual Assistant \r\nAugust to September', 65.0000, 1.0000, '', 0.000, 150, NULL, NULL, '', 0.000, 1, 0.00),
(277, 1, 2, 74, NULL, '2020-08-04 20:29:24', '2020-08-04 20:29:24', NULL, 'Weekly Pay', 'Linneth — $3/hr \r\n20 hrs/week', 3.0000, 20.0000, '', 0.000, 151, NULL, NULL, '', 0.000, 1, 0.00),
(278, 1, 2, 74, NULL, '2020-08-04 20:29:24', '2020-08-04 20:30:44', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Aug 4, 2020', 2.0000, 1.0000, '', 0.000, 152, NULL, NULL, '', 0.000, 4, 0.00),
(279, 1, 2, 76, NULL, '2020-08-05 01:08:38', '2020-08-05 01:08:38', NULL, 'Prepay', 'Prepayment For Future Services', 199.0000, 1.0000, '', 0.000, 153, NULL, NULL, '', 0.000, 1, 0.00),
(280, 1, 2, 76, NULL, '2020-08-05 01:08:38', '2020-08-05 01:08:38', NULL, 'Weekly Pay', 'Bert (July 27- July 30) \r\n   - 16.11hrs * $5  ($80.55)', 80.5500, 1.0000, '', 0.000, 154, NULL, NULL, '', 0.000, 1, 0.00),
(281, 1, 2, 76, NULL, '2020-08-05 01:08:38', '2020-08-05 01:14:23', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Aug 4, 2020', 2.0000, 1.0000, '', 0.000, 155, NULL, NULL, '', 0.000, 4, 0.00),
(282, 1, 2, 72, 8, '2020-08-05 18:26:22', '2020-08-05 18:26:22', NULL, 'Weekly Pay', 'Linneth (Alex) 2 hrs', 6.0000, 1.0000, '', 0.000, 156, NULL, NULL, '', 0.000, 1, 0.00),
(283, 1, 2, 72, 8, '2020-08-05 18:26:22', '2020-08-05 18:26:22', NULL, 'Weekly Pay', 'Sharly (Alex) 3 hrs and 50 mins', 11.5200, 1.0000, '', 0.000, 157, NULL, NULL, '', 0.000, 1, 0.00),
(284, 1, 2, 72, 8, '2020-08-05 18:26:22', '2020-08-05 18:26:22', NULL, 'Weekly Pay', 'Sharly (Paul) 4.42hrs', 13.2600, 1.0000, '', 0.000, 158, NULL, NULL, '', 0.000, 1, 0.00),
(285, 1, 2, 72, 8, '2020-08-05 18:26:22', '2020-08-05 18:26:22', NULL, 'Weekly Pay', 'Eubert (Marcella) 16.11 hrs', 80.5500, 1.0000, '', 0.000, 159, NULL, NULL, '', 0.000, 1, 0.00),
(286, 1, 2, 77, NULL, '2020-08-07 15:49:36', '2020-08-07 15:49:36', NULL, '', 'test', 1.0000, 1.0000, '', 0.000, 160, NULL, NULL, '', 0.000, 1, 0.00),
(287, 1, 2, 78, NULL, '2020-08-07 17:09:47', '2020-08-07 17:09:47', NULL, '', '## Email Support\r\n\r\nAugust 2-8, 2020 (Sun-Sat)\r\n\r\nSaturday, August 1, 2020\r\n  - Replied to 1 email\r\n  - Update CS Form sheet\r\n\r\nSunday, August 2, 2020\r\n  - Replied to 2 emails\r\n  - Message Anita about 1 customer concern. \r\n  - Update CS Form Sheet\r\n\r\nMonday, August 3, 2020\r\n  - Replied to 1 email\r\n  - Update CS Forms sheet\r\n  - Message Anita for 2 customer concern \r\n\r\nTuesday, August 4, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Sent new set of customers concern\r\n\r\nWednesday, August 5, 2020\r\n  - Replied to 5 emails\r\n  - Update CS Forms sheet\r\n  - Message Anita for 2 customer concern \r\n  - Update EMAILS sheet\r\n\r\nThursday, August 6, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 4 customers concern from Paul\r\n  - Replied back to Paul''s messages regarding the tentative customers from Skype\r\n  - Message Anita for 1 customer concern\r\n\r\nFriday, August 7, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Sent 1 customer concern to Anita\r\n\r\n### August 1, 2020 9:41 am - 9:51 am\r\n### August 2, 2020 9:41 am - 10:11 am\r\n### August 3, 2020 9:42 am - 9:57 am\r\n### August 4, 2020 9:43 am - 10:13 am\r\n### August 5, 2020 9:43 am - 10:43 am\r\n### August 6, 2020 9:44 am - 10:14 am\r\n### August 7, 2020 9:45 am - 10:00 am', 3.0000, 3.1700, '', 0.000, 161, NULL, NULL, '', 0.000, 2, 0.00),
(288, 1, 2, 79, NULL, '2020-08-07 17:13:50', '2020-08-07 17:13:50', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nAugust 5, 2020 - Work on LinkedIn (connect and sent message)\r\n\r\n### August 4, 2020 11:00 am - 12:00 pm', 3.0000, 1.0000, '', 0.000, 162, NULL, NULL, '', 0.000, 2, 0.00),
(289, 1, 2, 80, NULL, '2020-08-07 17:14:45', '2020-08-07 17:14:45', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nAugust 2-8, 2020 (Sun-Sat)\r\n\r\nTuesday, August 4, 2020\r\n  - Bonus 1hr as per Alex\r\n  - Call Alex grandma and ask if she needs something this week but she said nothing. \r\n\r\nWednesday, August 5, 2020\r\n  - Work on LinkedIn (replied to messages and connect)Search for target clients on LINKEDIN LEADS\r\n\r\nThursday, August 6, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages and connect)\r\n  - Search for new target clients on LINKEDIN LEADS\r\n  - Search for target clients on INSTAGRAM LEADS\r\n  - Search for target clients on FB TARGET LEADS\r\n\r\nFriday, August 7, 2020\r\n  - Work on LinkedIn (replied to messages and connect)\r\n  - Search for targer clients on FB GROUP LEADS\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Sent emails to FB TARGET LEADS\r\n  - Sent emails to FB GROUP LEADS\r\n\r\n### August 4, 2020 9:51 am - 11:01 am\r\n### August 5, 2020 9:51 am - 10:51 am\r\n### August 6, 2020 9:52 am - 11:22 am\r\n### August 7, 2020 9:53 am - 11:23 am', 3.0000, 5.1700, '', 0.000, 163, NULL, NULL, '', 0.000, 2, 0.00),
(298, 1, 2, 82, NULL, '2020-08-08 12:09:41', '2020-08-08 12:09:41', NULL, '', '## Marcela''s Project\r\n\r\netsy / prouct configuration/ research /tags/ pictures\r\n\r\n### August 3, 2020 12:17 pm - 12:48 pm\r\n### August 3, 2020 7:39 pm - 8:17 pm\r\n### August 3, 2020 9:03 pm - 9:30 pm', 5.0000, 1.6000, '', 0.000, 168, NULL, NULL, '', 0.000, 2, 0.00),
(299, 1, 2, 83, NULL, '2020-08-08 12:11:06', '2020-08-08 12:11:06', NULL, '', 'amazon dropshipping/ meeting with tim / reseach for new products hetting familiar with the calculator\r\n\r\n### August 3, 2020 9:33 pm - 10:03 pm\r\n### August 3, 2020 11:25 pm - 12:26 am', 5.0000, 1.5100, '', 0.000, 169, NULL, NULL, '', 0.000, 2, 0.00),
(300, 1, 2, 84, NULL, '2020-08-08 12:12:57', '2020-08-08 12:12:57', NULL, '', '## Marcela''s Project\r\n\r\nResponding to email :Nimi and other yt collab and podcast\r\ngetting photo banner for social media\r\n/clear acryllic for etsy\r\n\r\nFollow uo for podcast and yt. \r\nCheck spam emails\r\n\r\n### August 4, 2020 6:53 pm - 8:24 pm', 5.0000, 1.5100, '', 0.000, 170, NULL, NULL, '', 0.000, 2, 0.00),
(301, 1, 2, 85, NULL, '2020-08-08 12:13:58', '2020-08-08 12:13:58', NULL, '', '## Marcela''s Project\r\n\r\netsy excel file/ product name / amazon dropshipping /email\r\n\r\n### August 5, 2020 8:34 pm - 11:08 pm', 5.0000, 2.5600, '', 0.000, 171, NULL, NULL, '', 0.000, 2, 0.00),
(302, 1, 2, 86, NULL, '2020-08-08 12:14:56', '2020-08-08 12:14:56', NULL, '', '## Marcela''s Project\r\n\r\nemail prospecting video/ etsy moon/\r\n\r\n### August 6, 2020 6:40 pm - 7:12 pm', 5.0000, 0.5400, '', 0.000, 172, NULL, NULL, '', 0.000, 2, 0.00),
(303, 1, 2, 87, NULL, '2020-08-08 12:46:40', '2020-08-08 12:46:40', NULL, '', '## Marcela''s Project\r\n\r\nAmazon Dropshipping\r\n\r\n### August 6, 2020 8:06 pm - 9:14 pm', 5.0000, 1.1400, '', 0.000, 173, NULL, NULL, '', 0.000, 2, 0.00),
(304, 1, 2, 88, NULL, '2020-08-08 12:47:46', '2020-08-08 12:47:46', NULL, '', '## Marcela''s Project\r\n\r\netsy store/ Change imagge for floating shelves/ publishe coloring sheets\r\n\r\n### August 7, 2020 6:52 pm - 7:29 pm', 5.0000, 0.6100, '', 0.000, 174, NULL, NULL, '', 0.000, 2, 0.00),
(305, 1, 2, 89, NULL, '2020-08-08 13:04:03', '2020-08-08 13:04:03', NULL, '', '## Marcela''s Project\r\n\r\nAMazon /listed 4 items and another 3 out of stocks\r\n\r\n### August 7, 2020 10:31 pm - 1:02 am', 5.0000, 2.5200, '', 0.000, 175, NULL, NULL, '', 0.000, 2, 0.00),
(323, 1, 2, 90, 19, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 3', 'etsy / prouct configuration/ research /tags/ pictures\r\n\r\nAugust 3, 2020 12:17 pm - 12:48 pm\r\nAugust 3, 2020 7:39 pm - 8:17 pm\r\nAugust 3, 2020 9:03 pm - 9:30 pm', 5.0000, 1.6000, '', 0.000, 189, NULL, NULL, '', 0.000, 1, 0.00),
(324, 1, 2, 90, 19, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 3', 'amazon dropshipping/ meeting with tim / reseach for new products hetting familiar with the calculator\r\n\r\nAugust 3, 2020 9:33 pm - 10:03 pm\r\nAugust 3, 2020 11:25 pm - 12:26 am', 5.0000, 1.5100, '', 0.000, 190, NULL, NULL, '', 0.000, 1, 0.00),
(325, 1, 2, 90, 20, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 4', 'Responding to email :Nimi and other yt collab and podcast\r\ngetting photo banner for social media\r\n/clear acryllic for etsy\r\n\r\nFollow up for podcast and yt. \r\nCheck spam emails\r\n\r\nAugust 4, 2020 6:53 pm - 8:24 pm', 5.0000, 1.5100, '', 0.000, 191, NULL, NULL, '', 0.000, 1, 0.00),
(326, 1, 2, 90, 21, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 5', 'etsy excel file/ product name / amazon dropshipping /email\r\n\r\nAugust 5, 2020 8:34 pm - 11:08 pm', 5.0000, 2.5600, '', 0.000, 192, NULL, NULL, '', 0.000, 1, 0.00),
(327, 1, 2, 90, 22, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 6', 'email prospecting video/ etsy moon/\r\n\r\nAugust 6, 2020 6:40 pm - 7:12 pm', 5.0000, 0.5400, '', 0.000, 193, NULL, NULL, '', 0.000, 1, 0.00),
(328, 1, 2, 90, 22, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 6', 'email prospecting video/ etsy moon/\r\n\r\nAugust 6, 2020 6:40 pm - 7:12 pm', 5.0000, 0.5400, '', 0.000, 194, NULL, NULL, '', 0.000, 1, 0.00),
(329, 1, 2, 90, 22, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 6', 'Amazon Dropshipping\r\n\r\nAugust 6, 2020 8:06 pm - 9:14 pm', 5.0000, 1.1400, '', 0.000, 195, NULL, NULL, '', 0.000, 1, 0.00),
(330, 1, 2, 90, 23, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 7', 'etsy store/ Change image for floating shelves/ published coloring sheets\r\n\r\nAugust 7, 2020 6:52 pm - 7:29 pm', 5.0000, 0.6100, '', 0.000, 196, NULL, NULL, '', 0.000, 1, 0.00),
(331, 1, 2, 90, 23, '2020-08-08 13:10:48', '2020-08-08 13:10:48', NULL, 'Aug 7', 'Amazon /listed 4 items and another 3 out of stocks\r\n\r\nAugust 7, 2020 10:31 pm - 11:42 pm\r\nAugust 7, 2020 11:49 pm - 7:48 am', 5.0000, 2.5200, '', 0.000, 197, NULL, NULL, '', 0.000, 1, 0.00),
(353, 1, 2, 91, 19, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 3', 'etsy / prouct configuration/ research /tags/ pictures\r\n\r\nAugust 3, 2020 12:17 pm - 12:48 pm\r\nAugust 3, 2020 7:39 pm - 8:17 pm\r\nAugust 3, 2020 9:03 pm - 9:30 pm', 5.0000, 1.6000, '', 0.000, 210, NULL, NULL, '', 0.000, 1, 0.00),
(354, 1, 2, 91, 19, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 3', 'amazon dropshipping/ meeting with tim / reseach for new products hetting familiar with the calculator\r\n\r\nAugust 3, 2020 9:33 pm - 10:03 pm\r\nAugust 3, 2020 11:25 pm - 12:26 am', 5.0000, 1.5100, '', 0.000, 211, NULL, NULL, '', 0.000, 1, 0.00),
(355, 1, 2, 91, 20, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 4', 'Responding to email :Nimi and other yt collab and podcast\r\ngetting photo banner for social media\r\n/clear acryllic for etsy\r\n\r\nFollow up for podcast and yt. \r\nCheck spam emails\r\n\r\nAugust 4, 2020 6:53 pm - 8:24 pm', 5.0000, 1.5100, '', 0.000, 212, NULL, NULL, '', 0.000, 1, 0.00),
(356, 1, 2, 91, 21, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 5', 'etsy excel file/ product name / amazon dropshipping /email\r\n\r\nAugust 5, 2020 8:34 pm - 11:08 pm', 5.0000, 2.5600, '', 0.000, 213, NULL, NULL, '', 0.000, 1, 0.00),
(357, 1, 2, 91, 22, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 6', 'email prospecting video/ etsy moon/\r\n\r\nAugust 6, 2020 6:40 pm - 7:12 pm', 5.0000, 0.5400, '', 0.000, 214, NULL, NULL, '', 0.000, 1, 0.00),
(358, 1, 2, 91, 22, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 6', 'Amazon Dropshipping\r\n\r\nAugust 6, 2020 8:06 pm - 9:14 pm', 5.0000, 1.1400, '', 0.000, 215, NULL, NULL, '', 0.000, 1, 0.00),
(359, 1, 2, 91, 23, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 7', 'etsy store/ Change image for floating shelves/ published coloring sheets\r\n\r\nAugust 7, 2020 6:52 pm - 7:29 pm', 5.0000, 0.6100, '', 0.000, 216, NULL, NULL, '', 0.000, 1, 0.00),
(360, 1, 2, 91, 23, '2020-08-08 13:22:43', '2020-08-08 13:22:43', NULL, 'Aug 7', 'Amazon /listed 4 items and another 3 out of stocks\r\n\r\nAugust 7, 2020 10:31 pm - 11:42 pm\r\nAugust 7, 2020 11:49 pm - 7:48 am', 5.0000, 2.5200, '', 0.000, 217, NULL, NULL, '', 0.000, 1, 0.00),
(365, 1, 2, 81, 8, '2020-08-09 08:35:50', '2020-08-09 08:35:50', NULL, 'Weekly Pay', 'Sharly (PAUL) 3.17 hrs', 9.5100, 1.0000, '', 0.000, 218, NULL, NULL, '', 0.000, 1, 0.00),
(366, 1, 2, 81, 8, '2020-08-09 08:35:50', '2020-08-09 08:35:50', NULL, 'Weekly Pay', 'Sharly (Alex) 5.17 hrs', 15.5100, 1.0000, '', 0.000, 219, NULL, NULL, '', 0.000, 1, 0.00),
(367, 1, 2, 81, 8, '2020-08-09 08:35:50', '2020-08-09 08:35:50', NULL, 'Weekly Pay', 'Linneth (Alex) 1 hr', 3.0000, 1.0000, '', 0.000, 220, NULL, NULL, '', 0.000, 1, 0.00),
(368, 1, 2, 81, 8, '2020-08-09 08:35:50', '2020-08-09 08:35:50', NULL, 'Weekly Pay', 'Eubert (Marcella) 11.99 hrs', 59.9500, 1.0000, '', 0.000, 221, NULL, NULL, '', 0.000, 1, 0.00),
(369, 1, 2, 92, NULL, '2020-08-14 18:20:57', '2020-08-14 18:20:57', NULL, '', '## Email Support\r\n\r\nAugust 9-15, 2020 (Sun-Sat)\r\n\r\nSaturday, August 8, 2020\r\n  - Received email from Klaviyo\r\n  - Replied to 2 emails\r\n  - Message Paul about new set of customers concern\r\n\r\nSunday, August 9, 2020\r\n  - Replied to 1 email\r\n  - Update EMAILS sheet\r\n  - Replied to Anita message\r\n\r\nMonday, August 10, 2020\r\n  - Message Paul about 1 customer concern\r\n  - Replied to Anita messages\r\n  - Replied to 2 emails\r\n\r\nTuesday, August 11, 2020\r\n  - Replied to 1 email\r\n  - Update EMAILS sheet\r\n  - Replied to Anita''s messages\r\n\r\nWednesday, August 12, 2020\r\n  - Replied to 3 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Replied to 2 emails from customers concern from Paul\r\n  - Replied to 1 email from customers concern from Anita\r\n  - Messgae Anita for another customer concern\r\n\r\nThursday, August 13, 2020\r\n  - Replied to 1 email\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Message Paul about 1 customer concern reply\r\n\r\nFriday, August 14, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to Anita''s messages\r\n  - Message Paul about 1 new customer concern from Skype\r\n\r\n### August 8, 2020 9:34 am - 9:54 am\r\n### August 9, 2020 9:35 am - 9:50 am\r\n### August 10, 2020 9:37 am - 9:57 am\r\n### August 11, 2020 9:37 am - 9:53 am\r\n### August 12, 2020 9:38 am - 10:38 am\r\n### August 13, 2020 9:39 am - 9:59 am\r\n### August 14, 2020 9:40 am - 9:55 am', 3.0000, 2.7600, '', 0.000, 222, NULL, NULL, '', 0.000, 2, 0.00),
(370, 1, 2, 93, NULL, '2020-08-14 18:22:21', '2020-08-14 18:22:21', NULL, '', 'Monday, August 10, 2020\r\n- Training&Orientation\r\n- worked on LinkedIn (connect and sent messages)\r\n- update spreadsheet\r\n\r\nTuesday, August 11, 2020\r\n- Continued training\r\n- Worked on LinkedIn ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Update spreadsheet\r\n\r\nWednesday, August 12, 2020\r\n- Worked on LinkedIn ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Training for Facebook management\r\n- Sent friend request to Facebook group leads\r\n- Update spreadsheet\r\n\r\nThursday, August 13, 2020\r\n- Worked on Linkedin ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Sent friend request to relevant profiles\r\n- Check Facebook group activity/discussion ( interact and react as necessary )\r\n- Update spreadsheet\r\n\r\nFriday, August 14, 2020\r\n- Worked on Linkedin ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Sent friend request to relevant profiles\r\n- Check Facebook group activity/discussion ( interact and react as necessary )\r\n- Update spreadsheet\r\n\r\n### August 10, 2020 9:00 am - 1:00 pm\r\n### August 11, 2020 9:00 am - 1:00 pm\r\n### August 12, 2020 9:00 am - 1:00 pm\r\n### August 13, 2020 9:00 am - 1:00 pm\r\n### August 14, 2020 9:00 am - 1:00 pm', 3.0000, 20.0000, '', 0.000, 223, NULL, NULL, '', 0.000, 2, 0.00),
(371, 1, 2, 94, NULL, '2020-08-14 18:23:52', '2020-08-14 18:23:52', NULL, '', '## Bill to Alex / ConciergeAssist\r\n\r\nAugust 9-15, 2020 (Sun-Sat)\r\n\r\nTuesday, August 11, 2020\r\n  - Call Alex grandma and ask if she need something this week, and she said none. \r\n\r\nFriday, August 14, 2020\r\n  - Work on LinkedIn (connect, replied to messages and sent messages)\r\n  - Search for target clients on LINKEDIN LEADS\r\n  - Search for target clients on INSTAGRAM  LEADS\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Search for target clients on FB TARGET LEADS \r\n  - Sent emails to FB TARGET LEADS\r\n  - Work on LinkedIn (replied to message and connect)\r\n\r\n### August 11, 2020 9:45 am - 9:55 am\r\n### August 14, 2020 9:48 am - 12:03 pm', 3.0000, 2.4200, '', 0.000, 224, NULL, NULL, '', 0.000, 2, 0.00),
(379, 1, 2, 96, NULL, '2020-08-16 17:26:08', '2020-08-16 17:26:08', NULL, 'Prepay', 'Aug 17- Aug 21', 3.0000, 20.0000, '', 0.000, 228, NULL, NULL, '', 0.000, 1, 0.00),
(380, 1, 2, 96, NULL, '2020-08-16 17:26:08', '2020-08-16 17:26:08', NULL, '', 'Aug 24 - Aug 28', 3.0000, 20.0000, '', 0.000, 229, NULL, NULL, '', 0.000, 1, 0.00),
(381, 1, 2, 96, NULL, '2020-08-16 17:26:08', '2020-08-16 17:26:08', NULL, '', 'Aug 31 - Sep 4', 3.0000, 20.0000, '', 0.000, 230, NULL, NULL, '', 0.000, 1, 0.00),
(382, 1, 2, 96, NULL, '2020-08-16 17:26:08', '2020-08-16 17:26:08', NULL, '', 'Sep 7 - Sept 11', 3.0000, 20.0000, '', 0.000, 231, NULL, NULL, '', 0.000, 1, 0.00),
(383, 1, 2, 96, NULL, '2020-08-16 17:26:08', '2020-08-16 17:26:46', NULL, 'Gateway Fee Item', 'Gateway Fee Surcharge • Aug 16, 2020', 14.4000, 1.0000, '', 0.000, 232, NULL, NULL, '', 0.000, 4, 0.00),
(384, 1, 2, 95, 15, '2020-08-18 13:36:07', '2020-08-18 13:36:07', NULL, 'Sharly', 'Paul''s Task \r\n— 2.76 hours', 8.2800, 1.0000, '', 0.000, 233, NULL, NULL, '', 0.000, 1, 0.00),
(385, 1, 2, 95, 15, '2020-08-18 13:36:07', '2020-08-18 13:36:07', NULL, 'Sharly', 'Alex''s Task \r\n— 2.42 hours', 7.2600, 1.0000, '', 0.000, 234, NULL, NULL, '', 0.000, 1, 0.00),
(386, 1, 2, 95, 24, '2020-08-18 13:36:07', '2020-08-18 13:36:07', NULL, 'Linneth', 'Tania''s Task \r\n— 20 hours', 60.0000, 1.0000, '', 0.000, 235, NULL, NULL, '', 0.000, 1, 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `invoice_statuses`
--

CREATE TABLE `invoice_statuses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `invoice_statuses`
--

INSERT INTO `invoice_statuses` VALUES
(1, 'Draft'),
(2, 'Sent'),
(3, 'Viewed'),
(4, 'Approved'),
(5, 'Partial'),
(6, 'Paid');

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES
(1, 'English', 'en'),
(2, 'Italian', 'it'),
(3, 'German', 'de'),
(4, 'French', 'fr'),
(5, 'Portuguese - Brazilian', 'pt_BR'),
(6, 'Dutch', 'nl'),
(7, 'Spanish', 'es'),
(8, 'Norwegian', 'nb_NO'),
(9, 'Danish', 'da'),
(10, 'Japanese', 'ja'),
(11, 'Swedish', 'sv'),
(12, 'Spanish - Spain', 'es_ES'),
(13, 'French - Canada', 'fr_CA'),
(14, 'Lithuanian', 'lt'),
(15, 'Polish', 'pl'),
(16, 'Czech', 'cs'),
(17, 'Croatian', 'hr'),
(18, 'Albanian', 'sq'),
(19, 'Greek', 'el'),
(20, 'English - United Kingdom', 'en_GB'),
(21, 'Portuguese - Portugal', 'pt_PT'),
(22, 'Slovenian', 'sl'),
(23, 'Finnish', 'fi'),
(24, 'Romanian', 'ro'),
(25, 'Turkish - Turkey', 'tr_TR'),
(26, 'Thai', 'th'),
(27, 'Macedonian', 'mk_MK'),
(28, 'Chinese - Taiwan', 'zh_TW'),
(29, 'English - Australia', 'en_AU'),
(30, 'Serbian', 'sr_RS'),
(31, 'Bulgarian', 'bg');

-- --------------------------------------------------------

--
-- Table structure for table `licenses`
--

CREATE TABLE `licenses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `affiliate_id` int(10) unsigned DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `license_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_claimed` tinyint(1) DEFAULT NULL,
  `transaction_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `licenses_license_key_unique` (`license_key`),
  KEY `licenses_affiliate_id_foreign` (`affiliate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lookup_accounts`
--

CREATE TABLE `lookup_accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lookup_company_id` int(10) unsigned NOT NULL,
  `account_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subdomain` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_accounts_account_key_unique` (`account_key`),
  UNIQUE KEY `lookup_accounts_subdomain_unique` (`subdomain`),
  KEY `lookup_accounts_lookup_company_id_index` (`lookup_company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lookup_account_tokens`
--

CREATE TABLE `lookup_account_tokens` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lookup_account_id` int(10) unsigned NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_tokens_token_unique` (`token`),
  KEY `lookup_tokens_lookup_account_id_index` (`lookup_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lookup_companies`
--

CREATE TABLE `lookup_companies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `db_server_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_companies_db_server_id_company_id_unique` (`db_server_id`,`company_id`),
  KEY `lookup_companies_company_id_index` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lookup_contacts`
--

CREATE TABLE `lookup_contacts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lookup_account_id` int(10) unsigned NOT NULL,
  `contact_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_contacts_contact_key_unique` (`contact_key`),
  KEY `lookup_contacts_lookup_account_id_index` (`lookup_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lookup_invitations`
--

CREATE TABLE `lookup_invitations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lookup_account_id` int(10) unsigned NOT NULL,
  `invitation_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_invitations_invitation_key_unique` (`invitation_key`),
  UNIQUE KEY `lookup_invitations_message_id_unique` (`message_id`),
  KEY `lookup_invitations_lookup_account_id_index` (`lookup_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lookup_proposal_invitations`
--

CREATE TABLE `lookup_proposal_invitations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lookup_account_id` int(10) unsigned NOT NULL,
  `invitation_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_proposal_invitations_invitation_key_unique` (`invitation_key`),
  UNIQUE KEY `lookup_proposal_invitations_message_id_unique` (`message_id`),
  KEY `lookup_proposal_invitations_lookup_account_id_index` (`lookup_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lookup_users`
--

CREATE TABLE `lookup_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lookup_account_id` int(10) unsigned NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `confirmation_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `oauth_user_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `referral_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_users_lookup_account_id_user_id_unique` (`lookup_account_id`,`user_id`),
  UNIQUE KEY `lookup_users_email_unique` (`email`),
  UNIQUE KEY `lookup_users_confirmation_code_unique` (`confirmation_code`),
  UNIQUE KEY `lookup_users_oauth_user_key_unique` (`oauth_user_key`),
  UNIQUE KEY `lookup_users_referral_code_unique` (`referral_code`),
  KEY `lookup_users_lookup_account_id_index` (`lookup_account_id`),
  KEY `lookup_users_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES
(1, '2013_11_05_180133_confide_setup_users_table', 1),
(2, '2013_11_28_195703_setup_countries_table', 1),
(3, '2014_02_13_151500_add_cascase_drops', 1),
(4, '2014_02_19_151817_add_support_for_invoice_designs', 1),
(5, '2014_03_03_155556_add_phone_to_account', 1),
(6, '2014_03_19_201454_add_language_support', 1),
(7, '2014_03_20_200300_create_payment_libraries', 1),
(8, '2014_03_23_051736_enable_forcing_jspdf', 1),
(9, '2014_03_25_102200_add_sort_and_recommended_to_gateways', 1),
(10, '2014_04_03_191105_add_pro_plan', 1),
(11, '2014_04_17_100523_add_remember_token', 1),
(12, '2014_04_17_145108_add_custom_fields', 1),
(13, '2014_04_23_170909_add_products_settings', 1),
(14, '2014_04_29_174315_add_advanced_settings', 1),
(15, '2014_05_17_175626_add_quotes', 1),
(16, '2014_06_17_131940_add_accepted_credit_cards_to_account_gateways', 1),
(17, '2014_07_13_142654_one_click_install', 1),
(18, '2014_07_17_205900_support_hiding_quantity', 1),
(19, '2014_07_24_171214_add_zapier_support', 1),
(20, '2014_10_01_141248_add_company_vat_number', 1),
(21, '2014_10_05_141856_track_last_seen_message', 1),
(22, '2014_10_06_103529_add_timesheets', 1),
(23, '2014_10_06_195330_add_invoice_design_table', 1),
(24, '2014_10_13_054100_add_invoice_number_settings', 1),
(25, '2014_10_14_225227_add_danish_translation', 1),
(26, '2014_10_22_174452_add_affiliate_price', 1),
(27, '2014_10_30_184126_add_company_id_number', 1),
(28, '2014_11_04_200406_allow_null_client_currency', 1),
(29, '2014_12_03_154119_add_discount_type', 1),
(30, '2015_02_12_102940_add_email_templates', 1),
(31, '2015_02_17_131714_support_token_billing', 1),
(32, '2015_02_27_081836_add_invoice_footer', 1),
(33, '2015_03_03_140259_add_tokens', 1),
(34, '2015_03_09_151011_add_ip_to_activity', 1),
(35, '2015_03_15_174122_add_pdf_email_attachment_option', 1),
(36, '2015_03_30_100000_create_password_resets_table', 1),
(37, '2015_04_12_093447_add_sv_language', 1),
(38, '2015_04_13_100333_add_notify_approved', 1),
(39, '2015_04_16_122647_add_partial_amount_to_invoices', 1),
(40, '2015_05_21_184104_add_font_size', 1),
(41, '2015_05_27_121828_add_tasks', 1),
(42, '2015_05_27_170808_add_custom_invoice_labels', 1),
(43, '2015_06_09_134208_add_has_tasks_to_invoices', 1),
(44, '2015_06_14_093410_enable_resuming_tasks', 1),
(45, '2015_06_14_173025_multi_company_support', 1),
(46, '2015_07_07_160257_support_locking_account', 1),
(47, '2015_07_08_114333_simplify_tasks', 1),
(48, '2015_07_19_081332_add_custom_design', 1),
(49, '2015_07_27_183830_add_pdfmake_support', 1),
(50, '2015_08_13_084041_add_formats_to_datetime_formats_table', 1),
(51, '2015_09_04_080604_add_swap_postal_code', 1),
(52, '2015_09_07_135935_add_account_domain', 1),
(53, '2015_09_10_185135_add_reminder_emails', 1),
(54, '2015_10_07_135651_add_social_login', 1),
(55, '2015_10_21_075058_add_default_tax_rates', 1),
(56, '2015_10_21_185724_add_invoice_number_pattern', 1),
(57, '2015_10_27_180214_add_is_system_to_activities', 1),
(58, '2015_10_29_133747_add_default_quote_terms', 1),
(59, '2015_11_01_080417_encrypt_tokens', 1),
(60, '2015_11_03_181318_improve_currency_localization', 1),
(61, '2015_11_30_133206_add_email_designs', 1),
(62, '2015_12_27_154513_add_reminder_settings', 1),
(63, '2015_12_30_042035_add_client_view_css', 1),
(64, '2016_01_04_175228_create_vendors_table', 1),
(65, '2016_01_06_153144_add_invoice_font_support', 1),
(66, '2016_01_17_155725_add_quote_to_invoice_option', 1),
(67, '2016_01_18_195351_add_bank_accounts', 1),
(68, '2016_01_24_112646_add_bank_subaccounts', 1),
(69, '2016_01_27_173015_add_header_footer_option', 1),
(70, '2016_02_01_135956_add_source_currency_to_expenses', 1),
(71, '2016_02_25_152948_add_client_password', 1),
(72, '2016_02_28_081424_add_custom_invoice_fields', 1),
(73, '2016_03_14_066181_add_user_permissions', 1),
(74, '2016_03_14_214710_add_support_three_decimal_taxes', 1),
(75, '2016_03_22_168362_add_documents', 1),
(76, '2016_03_23_215049_support_multiple_tax_rates', 1),
(77, '2016_04_16_103943_enterprise_plan', 1),
(78, '2016_04_18_174135_add_page_size', 1),
(79, '2016_04_23_182223_payments_changes', 1),
(80, '2016_05_16_102925_add_swap_currency_symbol_to_currency', 1),
(81, '2016_05_18_085739_add_invoice_type_support', 1),
(82, '2016_05_24_164847_wepay_ach', 1),
(83, '2016_07_08_083802_support_new_pricing', 1),
(84, '2016_07_13_083821_add_buy_now_buttons', 1),
(85, '2016_08_10_184027_add_support_for_bots', 1),
(86, '2016_09_05_150625_create_gateway_types', 1),
(87, '2016_10_20_191150_add_expense_to_activities', 1),
(88, '2016_11_03_113316_add_invoice_signature', 1),
(89, '2016_11_03_161149_add_bluevine_fields', 1),
(90, '2016_11_28_092904_add_task_projects', 1),
(91, '2016_12_13_113955_add_pro_plan_discount', 1),
(92, '2017_01_01_214241_add_inclusive_taxes', 1),
(93, '2017_02_23_095934_add_custom_product_fields', 1),
(94, '2017_03_16_085702_add_gateway_fee_location', 1),
(95, '2017_04_16_101744_add_custom_contact_fields', 1),
(96, '2017_04_30_174702_add_multiple_database_support', 1),
(97, '2017_05_10_144928_add_oauth_to_lookups', 1),
(98, '2017_05_16_101715_add_default_note_to_client', 1),
(99, '2017_06_19_111515_update_dark_mode', 1),
(100, '2017_07_18_124150_add_late_fees', 1),
(101, '2017_08_14_085334_increase_precision', 1),
(102, '2017_10_17_083846_add_default_rates', 1),
(103, '2017_11_15_114422_add_subdomain_to_lookups', 1),
(104, '2017_12_13_074024_add_remember_2fa_token', 1),
(105, '2018_01_10_073825_add_subscription_format', 1),
(106, '2018_03_08_150414_add_slack_notifications', 1),
(107, '2018_03_30_115805_add_more_custom_fields', 1),
(108, '2018_04_16_142434_add_custom_domain', 1),
(109, '2018_05_14_091806_limit_notifications', 1),
(110, '2018_05_19_095124_add_json_permissions', 1),
(111, '2018_06_29_110607_add_dart_format_column', 1),
(112, '2018_07_26_170243_fix_payment_contact_foreign_key', 1),
(113, '2018_10_22_084326_add_option_for_product_notes', 1),
(114, '2019_08_27_074711_add_app_store_order_id', 2);

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` VALUES
('sarahtoretto04@gmail.com', '2020-07-11 06:25:28', NULL, '$2y$10$8VWHG6Gdiq9k5gt4Ort8wOZq4KPOQMN5GmCnKPHo31nRl2uRBtATe');

-- --------------------------------------------------------

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned DEFAULT NULL,
  `invitation_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `account_gateway_id` int(10) unsigned DEFAULT NULL,
  `payment_type_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `amount` decimal(13,2) NOT NULL,
  `payment_date` date DEFAULT NULL,
  `transaction_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payer_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `public_id` int(10) unsigned NOT NULL,
  `refunded` decimal(13,2) NOT NULL,
  `payment_status_id` int(10) unsigned NOT NULL DEFAULT 4,
  `routing_number` int(10) unsigned DEFAULT NULL,
  `last4` smallint(5) unsigned DEFAULT NULL,
  `expiration` date DEFAULT NULL,
  `gateway_error` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_method_id` int(10) unsigned DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `credit_ids` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `private_notes` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `exchange_rate` decimal(13,4) NOT NULL DEFAULT 1.0000,
  `exchange_currency_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payments_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `payments_account_gateway_id_foreign` (`account_gateway_id`),
  KEY `payments_user_id_foreign` (`user_id`),
  KEY `payments_payment_type_id_foreign` (`payment_type_id`),
  KEY `payments_invoice_id_index` (`invoice_id`),
  KEY `payments_account_id_index` (`account_id`),
  KEY `payments_client_id_index` (`client_id`),
  KEY `payments_public_id_index` (`public_id`),
  KEY `payments_payment_status_id_foreign` (`payment_status_id`),
  KEY `payments_payment_method_id_foreign` (`payment_method_id`),
  KEY `payments_contact_id_foreign` (`contact_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES
(1, 9, 1, 5, NULL, NULL, 1, NULL, 1, '2020-06-18 19:36:27', '2020-06-19 14:48:47', '2020-06-19 14:48:47', 1, 111.00, '2020-06-18', '', NULL, 1, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(2, 11, 1, 2, NULL, NULL, 1, NULL, 1, '2020-06-19 14:39:38', '2020-06-19 14:39:38', NULL, 0, 40.00, '2020-06-19', '', NULL, 2, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(3, 14, 1, 2, NULL, NULL, 2, NULL, 13, '2020-06-19 15:13:39', '2020-06-19 15:23:17', '2020-06-19 15:23:17', 1, 36.00, '2020-06-19', NULL, NULL, 3, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(4, 14, 1, 2, NULL, NULL, 1, NULL, 1, '2020-06-19 15:25:39', '2020-06-19 15:26:22', '2020-06-19 15:26:22', 1, 12.50, '2020-06-19', '', NULL, 4, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(5, 16, 1, 3, NULL, NULL, 1, NULL, 1, '2020-06-19 15:44:04', '2020-06-19 15:44:04', NULL, 0, 13.70, '2020-06-19', '', NULL, 5, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(6, 17, 1, 3, NULL, NULL, 1, NULL, 1, '2020-06-19 15:46:29', '2020-06-19 15:46:29', NULL, 0, 30.00, '2020-06-19', '', NULL, 6, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(7, 18, 1, 4, NULL, NULL, 2, NULL, 1, '2020-06-19 15:57:36', '2020-06-19 15:57:36', NULL, 0, 48.00, '2020-06-19', '', NULL, 7, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(8, 19, 1, 3, NULL, NULL, 2, NULL, 1, '2020-06-19 16:02:37', '2020-06-19 16:02:37', NULL, 0, 16.50, '2020-06-20', '', NULL, 8, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(9, 20, 1, 2, NULL, NULL, 2, NULL, 1, '2020-06-20 12:32:16', '2020-06-20 12:32:16', NULL, 0, 40.00, '2020-06-20', '', NULL, 9, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(10, 21, 1, 2, NULL, NULL, 2, NULL, 1, '2020-06-20 12:32:47', '2020-06-20 12:32:47', NULL, 0, 36.00, '2020-06-20', '', NULL, 10, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(11, 24, 1, 5, NULL, NULL, 1, NULL, 1, '2020-06-24 18:43:57', '2020-06-24 18:43:57', NULL, 0, 34.00, '2020-06-24', '', NULL, 11, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(12, 30, 1, 6, NULL, NULL, 1, NULL, 1, '2020-06-26 18:11:31', '2020-06-26 18:11:31', NULL, 0, 15.00, '2020-06-26', '', NULL, 12, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(13, 33, 1, 5, NULL, NULL, 1, NULL, NULL, '2020-06-26 18:15:58', '2020-06-26 18:15:58', NULL, 0, 17.64, '2020-06-26', NULL, NULL, 13, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(14, 34, 1, 3, NULL, NULL, 1, NULL, 1, '2020-06-26 18:17:23', '2020-06-26 18:17:23', NULL, 0, 17.16, '2020-06-26', '', NULL, 14, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(15, 31, 1, 2, NULL, NULL, 1, NULL, 1, '2020-06-26 18:26:41', '2020-06-26 18:26:41', NULL, 0, 33.03, '2020-06-26', '', NULL, 15, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(16, 29, 1, 4, NULL, NULL, 1, NULL, NULL, '2020-06-26 18:29:22', '2020-06-26 18:29:22', NULL, 0, 9.00, '2020-06-26', '', NULL, 16, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'manual credit', 1.0000, 0),
(17, 29, 1, 4, NULL, NULL, 2, NULL, 1, '2020-06-26 18:36:21', '2020-06-26 18:36:21', NULL, 0, 3.00, '2020-06-27', '', NULL, 17, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(18, 26, 1, 6, 6, 26, 2, 5, NULL, '2020-06-26 18:40:44', '2020-06-26 18:40:44', NULL, 0, 52.50, '2020-06-26', '2TE51722VT296723C', '3E89XWX2FX5HC', 18, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '45.26.140.157', NULL, NULL, 1.0000, 0),
(19, 35, 1, 7, NULL, NULL, 1, NULL, NULL, '2020-06-26 19:29:27', '2020-06-26 19:29:27', NULL, 0, 191.40, '2020-06-26', NULL, NULL, 19, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(20, 37, 1, 4, NULL, NULL, 1, NULL, 1, '2020-06-26 20:07:57', '2020-06-26 20:07:57', NULL, 0, 133.00, '2020-06-26', '', NULL, 20, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(21, 38, 1, 4, 4, 38, 1, 5, NULL, '2020-06-29 19:20:21', '2020-06-29 19:20:21', NULL, 0, 17.88, '2020-06-29', '5U850572TW849420F', 'V75SAPTMFCHRS', 21, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '75.84.139.98', NULL, NULL, 1.0000, 0),
(22, 40, 1, 3, 3, 40, 2, 5, NULL, '2020-06-30 05:01:58', '2020-06-30 05:01:58', NULL, 0, 106.00, '2020-06-30', '3TT43722G8601910X', 'NW7XAEDYKTJHA', 22, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '107.223.116.30', NULL, NULL, 1.0000, 0),
(23, 41, 1, 5, NULL, NULL, 2, NULL, 1, '2020-07-03 15:44:56', '2020-07-03 15:44:56', NULL, 0, 34.00, '2020-07-03', '', NULL, 23, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(24, 44, 1, 3, NULL, NULL, 2, NULL, 1, '2020-07-03 15:54:22', '2020-07-03 15:54:22', NULL, 0, 15.66, '2020-07-03', '', NULL, 24, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(25, 43, 1, 2, NULL, NULL, 2, NULL, 1, '2020-07-03 15:55:26', '2020-07-03 15:55:26', NULL, 0, 36.03, '2020-07-03', '', NULL, 25, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(26, 42, 1, 6, 6, 42, 2, 5, NULL, '2020-07-03 19:32:45', '2020-07-03 19:32:45', NULL, 0, 168.05, '2020-07-03', '4K875001JB6404919', '3E89XWX2FX5HC', 26, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '45.26.140.157', NULL, NULL, 1.0000, 0),
(27, 45, 1, 7, NULL, NULL, 1, NULL, NULL, '2020-07-03 23:18:24', '2020-07-03 23:18:24', NULL, 0, 226.45, '2020-07-03', NULL, NULL, 27, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(28, 39, 1, 8, 8, 39, 2, 5, NULL, '2020-07-08 01:07:56', '2020-07-08 01:07:56', NULL, 0, 10.50, '2020-07-07', '17641024D6631741W', 'VT2NKQPAEMXL2', 28, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '99.101.183.211', NULL, NULL, 1.0000, 0),
(29, 47, 1, 8, 8, 47, 2, 5, NULL, '2020-07-08 01:21:49', '2020-07-08 01:21:49', NULL, 0, 42.00, '2020-07-07', '6JE65960JW144581B', 'VT2NKQPAEMXL2', 29, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '99.101.183.211', NULL, NULL, 1.0000, 0),
(30, 48, 1, 3, NULL, NULL, 2, NULL, 1, '2020-07-10 16:15:49', '2020-07-10 16:15:49', NULL, 0, 13.77, '2020-07-11', '', NULL, 30, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(31, 51, 1, 2, NULL, NULL, 2, NULL, 1, '2020-07-10 16:17:42', '2020-07-10 16:17:42', NULL, 0, 39.27, '2020-07-11', '', NULL, 31, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(32, 54, 1, 6, 6, 54, 2, 5, NULL, '2020-07-14 16:00:51', '2020-07-14 16:00:51', NULL, 0, 78.80, '2020-07-14', '0EJ72447DA465511V', '3E89XWX2FX5HC', 32, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '107.77.199.93', NULL, NULL, 1.0000, 0),
(33, 53, 1, 7, NULL, NULL, 1, NULL, NULL, '2020-07-14 17:14:48', '2020-07-14 17:14:48', NULL, 0, 99.50, '2020-07-14', NULL, NULL, 33, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(34, 55, 1, 7, NULL, NULL, 1, NULL, NULL, '2020-07-14 17:32:17', '2020-07-14 17:32:17', NULL, 0, 114.20, '2020-07-14', NULL, NULL, 34, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(35, 56, 1, 2, NULL, NULL, 1, NULL, 1, '2020-07-14 18:12:12', '2020-07-14 18:12:12', NULL, 0, 39.00, '2020-07-14', '', NULL, 35, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pubes advance payment', 1.0000, 0),
(36, 57, 1, 5, NULL, NULL, 2, NULL, 1, '2020-07-15 19:16:03', '2020-07-15 19:16:03', NULL, 0, 30.00, '2020-07-16', '', NULL, 36, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(37, 58, 1, 3, NULL, NULL, 2, NULL, 1, '2020-07-17 15:39:24', '2020-07-17 15:39:24', NULL, 0, 15.51, '2020-07-17', '', NULL, 37, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(38, 60, 1, 6, 6, 60, 2, 5, NULL, '2020-07-21 22:05:36', '2020-07-21 22:05:36', NULL, 0, 97.23, '2020-07-21', '38P82197GE618062G', '3E89XWX2FX5HC', 38, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '45.26.140.157', NULL, NULL, 1.0000, 0),
(39, 61, 1, 7, NULL, NULL, 2, NULL, NULL, '2020-07-22 00:21:03', '2020-07-22 00:21:03', NULL, 0, 201.75, '2020-07-22', NULL, NULL, 39, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(40, 59, 1, 5, NULL, NULL, 2, NULL, NULL, '2020-07-24 17:28:41', '2020-07-24 17:28:41', NULL, 0, 1.02, '2020-07-24', NULL, NULL, 40, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(41, 62, 1, 9, NULL, NULL, 2, NULL, NULL, '2020-07-24 17:28:51', '2020-07-24 17:28:51', NULL, 0, 92.60, '2020-07-24', NULL, NULL, 41, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(42, 64, 1, 3, NULL, NULL, 2, NULL, 1, '2020-07-24 17:45:39', '2020-07-24 17:45:39', NULL, 0, 14.55, '2020-07-25', '', NULL, 42, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(43, 65, 1, 7, NULL, NULL, 1, NULL, NULL, '2020-07-24 17:53:23', '2020-07-24 17:53:23', NULL, 0, 39.09, '2020-07-24', NULL, NULL, 43, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(44, 67, 1, 6, 6, 67, 1, 5, NULL, '2020-07-27 16:48:23', '2020-07-27 16:48:23', NULL, 0, 52.00, '2020-07-27', '779936942B660684P', '3E89XWX2FX5HC', 44, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '107.77.198.6', NULL, NULL, 1.0000, 0),
(45, 68, 1, 6, 6, 68, 2, 5, NULL, '2020-07-28 18:23:16', '2020-07-28 18:23:16', NULL, 0, 62.05, '2020-07-28', '8VM03399KB594483N', '3E89XWX2FX5HC', 45, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '107.77.197.107', NULL, NULL, 1.0000, 0),
(46, 65, 1, 7, NULL, NULL, 2, NULL, NULL, '2020-07-28 18:51:23', '2020-07-28 18:51:23', NULL, 0, 60.02, '2020-07-28', NULL, NULL, 46, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(47, 66, 1, 3, 3, 66, 1, 5, NULL, '2020-07-29 16:58:20', '2020-07-29 16:58:20', NULL, 0, 32.00, '2020-07-29', '2H0486436N253744M', 'NW7XAEDYKTJHA', 47, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '107.223.116.30', NULL, NULL, 1.0000, 0),
(48, 71, 1, 3, NULL, NULL, 2, NULL, 1, '2020-07-31 16:55:41', '2020-07-31 16:55:41', NULL, 0, 13.26, '2020-08-01', '', NULL, 48, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(49, 74, 1, 10, 10, 74, 2, 5, NULL, '2020-08-04 20:30:44', '2020-08-04 20:30:44', NULL, 0, 127.00, '2020-08-04', '1RV90134BX0771045', 'LC3N7742CAWH2', 49, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '69.243.253.194', NULL, NULL, 1.0000, 0),
(50, 76, 1, 6, 6, 76, 2, 5, NULL, '2020-08-05 01:14:23', '2020-08-05 01:14:23', NULL, 0, 281.55, '2020-08-04', '5BT1935884869415S', '3E89XWX2FX5HC', 50, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '45.26.140.157', NULL, NULL, 1.0000, 0),
(51, 72, 1, 7, NULL, NULL, 2, NULL, NULL, '2020-08-05 18:26:37', '2020-08-05 18:26:37', NULL, 0, 111.33, '2020-08-05', NULL, NULL, 51, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(52, 73, 1, 6, NULL, NULL, 2, NULL, NULL, '2020-08-05 18:26:48', '2020-08-05 18:26:48', NULL, 0, 82.55, '2020-08-05', NULL, NULL, 52, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(53, 78, 1, 3, NULL, NULL, 2, NULL, 1, '2020-08-07 17:18:08', '2020-08-07 17:18:08', NULL, 0, 9.51, '2020-08-08', '', NULL, 53, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(54, 90, 1, 6, NULL, NULL, 2, NULL, NULL, '2020-08-08 13:11:07', '2020-08-08 13:11:07', NULL, 0, 62.65, '2020-08-08', NULL, NULL, 54, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(55, 91, 1, 6, NULL, NULL, 2, NULL, 1, '2020-08-08 13:24:11', '2020-08-08 13:24:11', NULL, 0, 59.95, '2020-08-08', '', NULL, 55, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(56, 93, 1, 10, NULL, NULL, 2, NULL, 1, '2020-08-14 18:30:56', '2020-08-14 18:30:56', NULL, 0, 60.00, '2020-08-15', '', NULL, 56, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(57, 92, 1, 3, NULL, NULL, 2, NULL, 1, '2020-08-14 18:31:25', '2020-08-14 18:31:25', NULL, 0, 8.28, '2020-08-15', '', NULL, 57, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1.0000, 0),
(58, 96, 1, 10, 10, 96, 2, 5, NULL, '2020-08-16 17:26:46', '2020-08-16 17:26:46', NULL, 0, 254.40, '2020-08-16', '60F88555EC655090D', 'LC3N7742CAWH2', 58, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '69.243.253.194', NULL, NULL, 1.0000, 0),
(59, 94, 1, 5, NULL, NULL, 2, NULL, NULL, '2020-08-18 13:32:15', '2020-08-18 13:32:15', NULL, 0, 7.26, '2020-08-18', NULL, NULL, 59, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(60, 80, 1, 5, NULL, NULL, 2, NULL, NULL, '2020-08-18 13:32:30', '2020-08-18 13:32:30', NULL, 0, 15.51, '2020-08-18', NULL, NULL, 60, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(61, 79, 1, 5, NULL, NULL, 2, NULL, NULL, '2020-08-18 13:32:47', '2020-08-18 13:32:47', NULL, 0, 3.00, '2020-08-18', NULL, NULL, 61, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(62, 81, 1, 7, NULL, NULL, 2, NULL, NULL, '2020-08-18 13:33:18', '2020-08-18 13:33:18', NULL, 0, 87.97, '2020-08-18', NULL, NULL, 62, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(63, 70, 1, 5, NULL, NULL, 2, NULL, NULL, '2020-08-18 13:39:50', '2020-08-18 13:39:50', NULL, 0, 6.00, '2020-08-18', NULL, NULL, 63, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0),
(64, 69, 1, 5, NULL, NULL, 2, NULL, NULL, '2020-08-18 13:40:14', '2020-08-18 13:40:14', NULL, 0, 11.52, '2020-08-18', NULL, NULL, 64, 0.00, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.0000, 0);

-- --------------------------------------------------------

--
-- Table structure for table `payment_libraries`
--

CREATE TABLE `payment_libraries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_libraries`
--

INSERT INTO `payment_libraries` VALUES
(1, '2020-06-17 08:14:41', '2020-06-17 08:14:41', 'Omnipay', 1),
(2, '2020-06-17 08:14:41', '2020-06-17 08:14:41', 'PHP-Payments [Deprecated]', 1);

-- --------------------------------------------------------

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned DEFAULT NULL,
  `account_gateway_token_id` int(10) unsigned DEFAULT NULL,
  `payment_type_id` int(10) unsigned NOT NULL,
  `source_reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `routing_number` int(10) unsigned DEFAULT NULL,
  `last4` smallint(5) unsigned DEFAULT NULL,
  `expiration` date DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `public_id` int(10) unsigned NOT NULL,
  `bank_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_methods_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `payment_methods_public_id_index` (`public_id`),
  KEY `payment_methods_user_id_foreign` (`user_id`),
  KEY `payment_methods_contact_id_foreign` (`contact_id`),
  KEY `payment_methods_payment_type_id_foreign` (`payment_type_id`),
  KEY `payment_methods_currency_id_foreign` (`currency_id`),
  KEY `payment_methods_account_gateway_token_id_foreign` (`account_gateway_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_statuses`
--

CREATE TABLE `payment_statuses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_statuses`
--

INSERT INTO `payment_statuses` VALUES
(1, 'Pending'),
(2, 'Voided'),
(3, 'Failed'),
(4, 'Completed'),
(5, 'Partially Refunded'),
(6, 'Refunded');

-- --------------------------------------------------------

--
-- Table structure for table `payment_terms`
--

CREATE TABLE `payment_terms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_days` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_terms_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `payment_terms_public_id_index` (`public_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_terms`
--

INSERT INTO `payment_terms` VALUES
(1, 7, 'Net 7', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 1),
(2, 10, 'Net 10', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 2),
(3, 14, 'Net 14', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 3),
(4, 15, 'Net 15', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 4),
(5, 30, 'Net 30', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 5),
(6, 60, 'Net 60', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 6),
(7, 90, 'Net 90', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 7),
(8, -1, 'Net 0', '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `payment_types`
--

CREATE TABLE `payment_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gateway_type_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_types_gateway_type_id_foreign` (`gateway_type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_types`
--

INSERT INTO `payment_types` VALUES
(1, 'Apply Credit', NULL),
(2, 'Bank Transfer', 2),
(3, 'Cash', NULL),
(4, 'Debit', 1),
(5, 'ACH', 2),
(6, 'Visa Card', 1),
(7, 'MasterCard', 1),
(8, 'American Express', 1),
(9, 'Discover Card', 1),
(10, 'Diners Card', 1),
(11, 'EuroCard', 1),
(12, 'Nova', 1),
(13, 'Credit Card Other', 1),
(14, 'PayPal', 3),
(15, 'Google Wallet', NULL),
(16, 'Check', NULL),
(17, 'Carte Blanche', 1),
(18, 'UnionPay', 1),
(19, 'JCB', 1),
(20, 'Laser', 1),
(21, 'Maestro', 1),
(22, 'Solo', 1),
(23, 'Switch', 1),
(24, 'iZettle', 1),
(25, 'Swish', 2),
(26, 'Venmo', NULL),
(27, 'Money Order', NULL),
(28, 'Alipay', 7),
(29, 'Sofort', 8),
(30, 'SEPA', 9),
(31, 'GoCardless', 10),
(32, 'Bitcoin', 4),
(33, 'Zelle', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `product_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `notes` text COLLATE utf8_unicode_ci NOT NULL,
  `cost` decimal(15,4) NOT NULL,
  `qty` decimal(15,4) DEFAULT 0.0000,
  `public_id` int(10) unsigned NOT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `custom_value1` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_value2` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_name1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_rate1` decimal(13,3) NOT NULL,
  `tax_name2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_rate2` decimal(13,3) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `products_user_id_foreign` (`user_id`),
  KEY `products_account_id_index` (`account_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES
(1, 1, 1, '2020-06-17 16:37:49', '2020-06-26 20:06:55', NULL, 'VA Hours', 'Virtual Assistant Hours 6/6', 30.0000, 1.0000, 1, 0, NULL, NULL, '', 0.000, '', 0.000),
(2, 1, 1, '2020-06-17 17:16:59', '2020-06-19 14:57:30', '2020-06-19 14:57:30', 'VA Anne Work', 'Anne is sexy', 400.0000, 0.0000, 2, 1, NULL, NULL, '', 0.000, '', 0.000),
(3, 1, 1, '2020-06-17 17:18:57', '2020-06-19 14:57:35', '2020-06-19 14:57:35', 'Pubes hours', '37.50', 111.0000, 0.0000, 3, 1, NULL, NULL, '', 0.000, '', 0.000),
(4, 1, 1, '2020-06-18 17:59:57', '2020-08-04 14:52:04', NULL, 'Monthly Dues', 'Concierge Assist Monthly Dues (1) Virtual Assistant', 65.0000, 1.0000, 4, 0, NULL, NULL, '', 0.000, '', 0.000),
(5, 1, 1, '2020-06-19 14:58:13', '2020-06-26 03:17:54', NULL, 'Misc', 'Misc Charge Not Listed', 3.0000, 1.0000, 5, 0, NULL, NULL, '', 0.000, '', 0.000),
(6, 1, 1, '2020-06-19 14:58:43', '2020-08-16 16:20:00', NULL, 'Prepay', 'Aug 17- Aug 21', 3.0000, 1.0000, 6, 0, NULL, NULL, '', 0.000, '', 0.000),
(7, 1, 2, '2020-06-19 15:11:16', '2020-06-26 03:33:39', '2020-06-26 03:33:39', 'Bert''s Weekly Pay', 'Berts Weekly Pay', 0.0000, 1.0000, 7, 1, NULL, NULL, '', 0.000, '', 0.000),
(8, 1, 1, '2020-06-24 18:43:25', '2020-08-09 08:35:50', NULL, 'Weekly Pay', 'Eubert (Marcella) 11.99 hrs', 59.9500, 0.0000, 8, 0, NULL, NULL, '', 0.000, '', 0.000),
(9, 1, 1, '2020-06-29 00:16:47', '2020-06-29 00:26:40', NULL, 'Past Due', 'Past Due Balances ** Corrected**', 18.0000, 0.0000, 9, 0, NULL, NULL, '', 0.000, '', 0.000),
(10, 1, 2, '2020-06-29 13:56:21', '2020-07-08 01:03:12', NULL, '1 Flyer', '1 flyer for Decks for Less', 5.0000, 0.0000, 10, 0, NULL, NULL, '', 0.000, '', 0.000),
(11, 1, 2, '2020-06-29 13:56:21', '2020-07-08 01:03:12', NULL, '1 Business Card', '1 business card for Decks for less', 5.0000, 0.0000, 11, 0, NULL, NULL, '', 0.000, '', 0.000),
(12, 1, 1, '2020-06-29 18:57:31', '2020-06-29 18:58:35', NULL, 'Corrected Balances', 'Corrected Balances', 18.0000, 0.0000, 12, 0, NULL, NULL, '', 0.000, '', 0.000),
(13, 1, 2, '2020-07-03 18:30:09', '2020-07-03 18:38:10', NULL, 'June 28- July 4', 'Bert- 32.01 hours (MARCELLA)', 160.0500, 0.0000, 13, 0, NULL, NULL, '', 0.000, '', 0.000),
(14, 1, 2, '2020-07-08 01:16:44', '2020-07-08 01:16:44', NULL, 'Bonus', '--for Rheina \r\nTHANK YOU SO MUCH, FLO!', 40.0000, 0.0000, 14, 0, NULL, NULL, '', 0.000, '', 0.000),
(15, 1, 2, '2020-07-10 18:32:40', '2020-08-18 13:36:07', NULL, 'Sharly', 'Alex''s Task \r\n— 2.42 hours', 7.2600, 0.0000, 15, 0, NULL, NULL, '', 0.000, '', 0.000),
(16, 1, 2, '2020-07-10 18:32:40', '2020-07-14 17:14:38', NULL, 'bert', 'Joe     (13hrs) ---- $39.27\r\n        BONUS             -----$10', 49.2700, 0.0000, 16, 0, NULL, NULL, '', 0.000, '', 0.000),
(17, 1, 1, '2020-07-14 17:26:12', '2020-07-14 17:28:43', NULL, 'week', 'Bert''s Early Pay (Joe''s last remaining credit', 39.2000, 0.0000, 17, 0, NULL, NULL, '', 0.000, '', 0.000),
(18, 1, 2, '2020-08-04 02:58:33', '2020-08-04 19:49:39', NULL, 'Monthly Service Pay', 'Concierge Assist Monthly Dues (1) Virtual Assistant \r\nAugust to September', 65.0000, 0.0000, 18, 0, NULL, NULL, '', 0.000, '', 0.000),
(19, 1, 2, '2020-08-08 13:06:34', '2020-08-08 13:22:43', NULL, 'Aug 3', 'amazon dropshipping/ meeting with tim / reseach for new products hetting familiar with the calculator\r\n\r\nAugust 3, 2020 9:33 pm - 10:03 pm\r\nAugust 3, 2020 11:25 pm - 12:26 am', 5.0000, 0.0000, 19, 0, NULL, NULL, '', 0.000, '', 0.000),
(20, 1, 2, '2020-08-08 13:06:34', '2020-08-08 13:22:43', NULL, 'Aug 4', 'Responding to email :Nimi and other yt collab and podcast\r\ngetting photo banner for social media\r\n/clear acryllic for etsy\r\n\r\nFollow up for podcast and yt. \r\nCheck spam emails\r\n\r\nAugust 4, 2020 6:53 pm - 8:24 pm', 5.0000, 0.0000, 20, 0, NULL, NULL, '', 0.000, '', 0.000),
(21, 1, 2, '2020-08-08 13:06:34', '2020-08-08 13:22:43', NULL, 'Aug 5', 'etsy excel file/ product name / amazon dropshipping /email\r\n\r\nAugust 5, 2020 8:34 pm - 11:08 pm', 5.0000, 0.0000, 21, 0, NULL, NULL, '', 0.000, '', 0.000),
(22, 1, 2, '2020-08-08 13:06:34', '2020-08-08 13:22:43', NULL, 'Aug 6', 'Amazon Dropshipping\r\n\r\nAugust 6, 2020 8:06 pm - 9:14 pm', 5.0000, 0.0000, 22, 0, NULL, NULL, '', 0.000, '', 0.000),
(23, 1, 2, '2020-08-08 13:06:34', '2020-08-08 13:22:43', NULL, 'Aug 7', 'Amazon /listed 4 items and another 3 out of stocks\r\n\r\nAugust 7, 2020 10:31 pm - 11:42 pm\r\nAugust 7, 2020 11:49 pm - 7:48 am', 5.0000, 0.0000, 23, 0, NULL, NULL, '', 0.000, '', 0.000),
(24, 1, 2, '2020-08-14 18:25:40', '2020-08-18 13:36:07', NULL, 'Linneth', 'Tania''s Task \r\n— 20 hours', 60.0000, 0.0000, 24, 0, NULL, NULL, '', 0.000, '', 0.000);

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `public_id` int(10) unsigned NOT NULL,
  `task_rate` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `due_date` date DEFAULT NULL,
  `private_notes` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `budgeted_hours` double(8,2) NOT NULL,
  `custom_value1` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_value2` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `projects_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `projects_user_id_foreign` (`user_id`),
  KEY `projects_account_id_index` (`account_id`),
  KEY `projects_client_id_index` (`client_id`),
  KEY `projects_public_id_index` (`public_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES
(1, 1, 1, 5, '2020-06-18 19:43:06', '2020-06-19 15:01:11', NULL, 'Bill to Alex / ConciergeAssist', 0, 1, 3.0000, NULL, 'For Marketing use, or billing for ConciergeAssist / myARconnect', 0.00, NULL, NULL),
(2, 1, 1, 2, '2020-06-19 14:59:44', '2020-06-19 14:59:44', NULL, 'Joe''s Requests', 0, 2, 3.0000, NULL, '', 0.00, NULL, NULL),
(3, 1, 1, 3, '2020-06-19 15:00:05', '2020-06-23 13:37:24', NULL, 'Paul''s Requests', 0, 3, 3.0000, NULL, '', 0.00, NULL, NULL),
(4, 1, 1, 4, '2020-06-19 15:00:23', '2020-06-19 15:00:23', NULL, 'Kate''s Requests', 0, 4, 3.0000, NULL, '', 0.00, NULL, NULL),
(5, 2, 1, 3, '2020-06-23 05:30:42', '2020-06-26 15:30:07', NULL, 'Email Support', 0, 5, 3.0000, NULL, '', 0.00, NULL, NULL),
(6, 1, 1, 6, '2020-06-23 18:54:23', '2020-06-23 18:58:37', NULL, 'Marcela''s Project', 0, 6, 5.0000, NULL, '', 0.00, NULL, NULL),
(7, 4, 1, 7, '2020-07-10 15:05:57', '2020-07-14 17:35:31', NULL, 'MISC / Bonus Pay', 0, 7, 3.0000, NULL, '', 0.00, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `proposals`
--

CREATE TABLE `proposals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `invoice_id` int(10) unsigned NOT NULL,
  `proposal_template_id` int(10) unsigned DEFAULT NULL,
  `private_notes` text COLLATE utf8_unicode_ci NOT NULL,
  `html` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `css` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `proposals_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `proposals_user_id_foreign` (`user_id`),
  KEY `proposals_invoice_id_index` (`invoice_id`),
  KEY `proposals_proposal_template_id_index` (`proposal_template_id`),
  KEY `proposals_public_id_index` (`public_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `proposal_categories`
--

CREATE TABLE `proposal_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `proposal_categories_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `proposal_categories_user_id_foreign` (`user_id`),
  KEY `proposal_categories_public_id_index` (`public_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `proposal_invitations`
--

CREATE TABLE `proposal_invitations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `proposal_id` int(10) unsigned NOT NULL,
  `invitation_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `sent_date` timestamp NULL DEFAULT NULL,
  `viewed_date` timestamp NULL DEFAULT NULL,
  `opened_date` timestamp NULL DEFAULT NULL,
  `message_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email_error` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `proposal_invitations_account_id_public_id_unique` (`account_id`,`public_id`),
  UNIQUE KEY `proposal_invitations_invitation_key_unique` (`invitation_key`),
  KEY `proposal_invitations_user_id_foreign` (`user_id`),
  KEY `proposal_invitations_contact_id_foreign` (`contact_id`),
  KEY `proposal_invitations_proposal_id_index` (`proposal_id`),
  KEY `proposal_invitations_public_id_index` (`public_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `proposal_snippets`
--

CREATE TABLE `proposal_snippets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `proposal_category_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `private_notes` text COLLATE utf8_unicode_ci NOT NULL,
  `html` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `css` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `proposal_snippets_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `proposal_snippets_user_id_foreign` (`user_id`),
  KEY `proposal_snippets_public_id_index` (`public_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `proposal_templates`
--

CREATE TABLE `proposal_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `private_notes` text COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `html` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `css` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `proposal_templates_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `proposal_templates_user_id_foreign` (`user_id`),
  KEY `proposal_templates_public_id_index` (`public_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `proposal_templates`
--

INSERT INTO `proposal_templates` VALUES
(1, NULL, NULL, '2020-06-17 08:14:41', '2020-06-17 08:14:41', NULL, 0, '', 'Clean', '<table border="0" cellpadding="0" cellspacing="0" width="100%">\n\n	<tr class="grey-bg">\n		<td><img src="$logoUrl" width="193"/></td>\n		<td align="right"><p class="quote quote-number grey-upper">Proposal #$quoteNumber</p></td>\n	</tr>\n\n	<tr class="top-header grey-bg">\n		<td colspan="2" align="center">\n			<h1 class="cover-heading">New Business Proposal</h1>\n			<p class="quote quoteDate grey-upper">Valid Until $validUntil</p>\n		</td>\n	</tr>\n\n	<tr align="center" class="grey-bg proposal-info">\n		<td width="50%">\n			<p class="blue-upper">Prepared for:</p>\n			<h3 class="client name">$client.name</h3>\n			<p>\n				<span class="client address1">$client.address1</span><br/>\n				<span class="client city">$client.city</span>, <span class="client state">$client.state</span> <span class="client postal-code">$client.postal_code</span>\n			</p>\n		</td>\n		<td width="50%">\n			<p class="blue-upper">Prepared by:</p>\n			<h3 class="account name">$account.name</h3>\n			<p>\n				<span class="account address1">$account.address1</span><br/>\n				<span class="account city">$account.city</span>, <span class="account state">$account.state</span> <span class="account postal-code">$account.postal_code</span></p>\n			</td>\n		</tr>\n	</td>\n</tr>\n</table>\n\n<table border="0" cellpadding="0" cellspacing="0">\n	<tr>\n		<td colspan="2" class="card-content">\n			<h2 class="card-title">PROJECT DESCRIPTION:</h2>\n			<p class="card-text">Koala Photography seeks a full review of their historical financial records and future accounting needs. At the start, our experts carefully review your past records and assess your financial services needs according to the nature of your company and suggest the services model best suited to your requirements. The work plan is finalized only after an initial (and possibly subsequent) extensive consultation with [Client.Company]. Periodic review of our services and client feedback is an essential feature of our work plan which ensures that we remain an efficient accounting partner for your business.</p><br/>\n		</td>\n	</tr>\n</table>\n\n<table border="0" cellpadding="0" cellspacing="0">\n	<tr>\n		<td colspan="2">\n			<hr/>\n		</td>\n	</tr>\n</table>\n\n<table>\n	<tr>\n		<td class="grid-item-card card-content">\n			<h2 class="card-title">OBJECTIVE:</h2>\n			<p class="card-text">Koala Photography seeks a full review of their historical financial records and future accounting needs. At the start, our experts carefully review your past records and assess your financial services needs according to the nature of your company and suggest the services model best suited to your requirements. The work plan is finalized only after an initial (and possibly subsequent) extensive consultation with [Client.Company]. Periodic review of our services and client feedback is an essential feature of our work plan which ensures that we remain an efficient accounting partner for your business.</p>\n		</td>\n		<td class="grid-item-card card-content">\n			<h2 class="card-title">GOAL:</h2>\n			<p class="card-text">Koala Photography seeks a full review of their historical financial records and future accounting needs. At the start, our experts carefully review your past records and assess your financial services needs according to the nature of your company and suggest the services model best suited to your requirements. The work plan is finalized only after an initial (and possibly subsequent) extensive consultation with [Client.Company]. Periodic review of our services and client feedback is an essential feature of our work plan which ensures that we remain an efficient accounting partner for your business.</p>\n		</td>\n	</tr>\n</table>\n\n<table>\n	<tr class="block-quote" align="center">\n		<td colspan="2">\n			<img src="$quoteImageUrl" width="25"/>\n			<p class="quote">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce congue auctor magna id sodales. Maecenas mollis justo sed tempor facilisis. Ut malesuada in nibh ultrices auctor. Proin id maximus ipsum. Sed eu magna ac nisl sollicitudin porta in non augue. Mauris feugiat interdum aliquam. Aliquam ultrices interdum dolor.</p>\n		</td>\n	</tr>\n</table>\n\n<table>\n	<tr>\n		<td class="card-content">\n			<img width="150px" srcx="img/thumb-square.jpg"/>\n		</td>\n		<td class="card-content">\n			<h2 class="card-title">OBJECTIVE:</h2>\n			<p class="card-text">Koala Photography seeks a full review of their historical financial records and future accounting needs. At the start, our experts carefully review your past records and assess your financial services needs according to the nature of your company and suggest the services model best suited to your requirements. The work plan is finalized only after an initial (and possibly subsequent) extensive consultation with [Client.Company]. Periodic review of our services and client feedback is an essential feature of our work plan which ensures that we remain an efficient accounting partner for your business.</p>\n		</td>\n	</tr>\n	<tr>\n		<td class="card-content">\n			<img width="150px" srcx="img/thumb-square.jpg"/>\n		</td>\n		<td class="card-content">\n			<h2 class="card-title">OBJECTIVE:</h2>\n			<p class="card-text">Koala Photography seeks a full review of their historical financial records and future accounting needs. At the start, our experts carefully review your past records and assess your financial services needs according to the nature of your company and suggest the services model best suited to your requirements. The work plan is finalized only after an initial (and possibly subsequent) extensive consultation with [Client.Company]. Periodic review of our services and client feedback is an essential feature of our work plan which ensures that we remain an efficient accounting partner for your business.</p>\n		</td>\n	</tr>\n</table>\n\n<table>\n	<tr>\n		<td colspan="2">\n			<hr/>\n		</td>\n	</tr>\n\n	<tr>\n		<td class="grid-item-card card-content">\n			<img/>\n			<h2 class="card-title">OBJECTIVE:</h2>\n			<p class="card-text">Koala Photography seeks a full review of their historical financial records and future accounting needs. At the start, our experts carefully review your past records and assess your financial services needs according to the nature of your company and suggest the services model best suited to your requirements. The work plan is finalized only after an initial (and possibly subsequent) extensive consultation with [Client.Company]. Periodic review of our services and client feedback is an essential feature of our work plan which ensures that we remain an efficient accounting partner for your business.</p>\n		</td>\n		<td class="grid-item-card card-content">\n			<img/>\n			<h2 class="card-title">GOAL:</h2>\n			<p class="card-text">Koala Photography seeks a full review of their historical financial records and future accounting needs. At the start, our experts carefully review your past records and assess your financial services needs according to the nature of your company and suggest the services model best suited to your requirements. The work plan is finalized only after an initial (and possibly subsequent) extensive consultation with [Client.Company]. Periodic review of our services and client feedback is an essential feature of our work plan which ensures that we remain an efficient accounting partner for your business.</p>\n		</td>\n	</tr>\n\n	<tr class="footer" align="center">\n		<td colspan="2"></td>\n	</tr>\n\n</table>\n', 'body {\n    font-family: ''Open Sans'', Helvetica, arial, sans-serif;\n    color: #161616;\n}\n\n.grey-upper {\n	font-size: 11px;\n	letter-spacing: 3px;\n	text-transform: uppercase;\n	color: #9a9a9a;\n}\n\n.blue-upper {\n	padding-bottom: 8px;\n	font-size: 11px;\n	letter-spacing: 3px;\n	text-transform: uppercase;\n	color: #37a3c6;\n	margin: 0;\n}\n\np span.client  {\n	margin:5px 0px 0px 0px;\n}\n\nh1.cover-heading {\n	font-size: 48px;\n	line-height: 53px;\n	text-transform: uppercase;\n	font-weight: 100;\n	letter-spacing: 3px;\n	padding: 0 50px;\n}\n\nh3.client.name {\n	padding: 0;\n	margin: 0 0 -10px 0;\n	font-size:18px;\n	font-weight: 600;\n}\n\nspan.client.address1, span.client.city, span.client.state, span.client.postal-code {\n	font-size: 14px;\n	line-height: 18.5px;\n}\n\nh3.account.name {\n	padding: 0;\n	margin: 0 0 -10px 0;\n	font-size:18px;\n	font-weight: 600;\n}\n\nspan.account.address1, span.account.city, span.account.state, span.account.postal-code {\n	font-size: 14px;\n	line-height: 18.5px;\n}\n\n\n.heading,\n.card-title {\n	font-size: 14px;\n	letter-spacing: 3px;\n	color: #37a3c6;\n	font-weight: 600;\n}\n\n.card-text {\n	font-size: 15px;\n	line-height: 21px;\n}\n\na.button {\n	background: #37a3c6;\n	padding: 12px 25px;\n	border-radius: 2px;\n	color: #fff;\n	text-transform: uppercase;\n	font-size: 12px;\n	text-decoration: none;\n	letter-spacing: 3px;\n	font-weight: 600;\n	margin: 15px 0;\n}\n\na.button:hover {\n	background: #161616;\n}\n\n/****** Table *****************************************/\n\n.grey-bg {\n	background: #eeefef;\n}\n\n.card-content {\n	padding: 20px;\n}\n\ntd {\n    vertical-align: top;\n}\n\ntr.top-header {\n	height: 350px;\n}\n\ntr.top-header td {\n	padding: 80px 0 0 0;\n	border-bottom: 1px solid #dddcdc;\n}\n\ntr.top-header h1.heading {\n	margin: 0;\n}\n\ntr.top-header p {\n	margin: 5px 0 0 0;\n}\n\n.proposal-info {\n	height: 350px;\n}\n\n.proposal-info td {\n	padding: 0 0 120px 0;\n}\n\ntr.block-quote {\n	margin: 50px 0 ;\n}\n\ntr.block-quote td {\n	background: #fbfbfb;\n	font-style: italic;\n	padding: 0 75px;\n	font-size: 17px;\n	line-height: 24px;\n	padding: 80px 120px;\n	color: #686766;\n	border-top: 1px solid #dddcdc;\n	border-bottom: 1px solid #dddcdc;\n}\n\ntr.footer td {\n	background: #f0efef;\n	font-size: 12px;\n	letter-spacing: 3px;\n	color: #8c8b8a;\n	padding: 50px 0;\n	text-transform: uppercase;\n}\n\n/****** Misc *****************************************/\n\n\nhr {\n	border: 0;\n	height: 1px;\n	background: #dddada;\n}\n\n.footer img {\n	vertical-align: middle;\n}\n', 1);

-- --------------------------------------------------------

--
-- Table structure for table `recurring_expenses`
--

CREATE TABLE `recurring_expenses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `vendor_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `amount` decimal(13,2) NOT NULL,
  `private_notes` text COLLATE utf8_unicode_ci NOT NULL,
  `public_notes` text COLLATE utf8_unicode_ci NOT NULL,
  `invoice_currency_id` int(10) unsigned DEFAULT NULL,
  `expense_currency_id` int(10) unsigned DEFAULT NULL,
  `should_be_invoiced` tinyint(1) NOT NULL DEFAULT 1,
  `expense_category_id` int(10) unsigned DEFAULT NULL,
  `tax_name1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_rate1` decimal(13,3) NOT NULL,
  `tax_name2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tax_rate2` decimal(13,3) NOT NULL,
  `frequency_id` int(10) unsigned NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `last_sent_date` date DEFAULT NULL,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `recurring_expenses_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `recurring_expenses_user_id_foreign` (`user_id`),
  KEY `recurring_expenses_account_id_index` (`account_id`),
  KEY `recurring_expenses_invoice_currency_id_index` (`invoice_currency_id`),
  KEY `recurring_expenses_expense_currency_id_index` (`expense_currency_id`),
  KEY `recurring_expenses_expense_category_id_index` (`expense_category_id`),
  KEY `recurring_expenses_public_id_index` (`public_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `scheduled_reports`
--

CREATE TABLE `scheduled_reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `config` text COLLATE utf8_unicode_ci NOT NULL,
  `frequency` enum('daily','weekly','biweekly','monthly') COLLATE utf8_unicode_ci NOT NULL,
  `send_date` date NOT NULL,
  `public_id` int(10) unsigned DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `scheduled_reports_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `scheduled_reports_user_id_foreign` (`user_id`),
  KEY `scheduled_reports_account_id_index` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `security_codes`
--

CREATE TABLE `security_codes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `contact_id` int(10) unsigned DEFAULT NULL,
  `attempts` smallint(6) NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bot_user_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `security_codes_bot_user_id_unique` (`bot_user_id`),
  KEY `security_codes_account_id_index` (`account_id`),
  KEY `security_codes_user_id_foreign` (`user_id`),
  KEY `security_codes_contact_id_foreign` (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sizes`
--

CREATE TABLE `sizes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sizes`
--

INSERT INTO `sizes` VALUES
(1, '1 - 3'),
(2, '4 - 10'),
(3, '11 - 50'),
(4, '51 - 100'),
(5, '101 - 500'),
(6, '500+');

-- --------------------------------------------------------

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `event_id` int(10) unsigned DEFAULT NULL,
  `target_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `public_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `format` enum('JSON','UBL') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'JSON',
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_account_id_public_id_unique` (`account_id`,`public_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned DEFAULT NULL,
  `invoice_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `public_id` int(10) unsigned NOT NULL,
  `is_running` tinyint(1) NOT NULL DEFAULT 0,
  `time_log` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `project_id` int(10) unsigned DEFAULT NULL,
  `task_status_id` int(10) unsigned DEFAULT NULL,
  `task_status_sort_order` smallint(6) NOT NULL DEFAULT 0,
  `custom_value1` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_value2` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tasks_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `tasks_user_id_foreign` (`user_id`),
  KEY `tasks_invoice_id_foreign` (`invoice_id`),
  KEY `tasks_client_id_foreign` (`client_id`),
  KEY `tasks_account_id_index` (`account_id`),
  KEY `tasks_public_id_index` (`public_id`),
  KEY `tasks_project_id_index` (`project_id`),
  KEY `tasks_task_status_id_index` (`task_status_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` VALUES
(1, 1, 1, 5, NULL, '2020-06-18 19:43:55', '2020-06-19 14:20:32', '2020-06-19 14:20:32', 'Test', 1, 1, 0, '[[1592509500,1592524800]]', 1, NULL, 9999, '', ''),
(2, 2, 1, 5, NULL, '2020-06-18 20:22:54', '2020-06-19 14:20:27', '2020-06-19 14:20:27', 'TEST', 1, 2, 0, '[[1592550900,1595108700]]', 1, NULL, 9999, NULL, NULL),
(3, 1, 1, 5, NULL, '2020-06-19 14:43:36', '2020-06-24 18:26:10', '2020-06-24 18:26:10', 'monday works', 1, 3, 0, '[[1592577900,1592588700]]', 1, 1, 0, NULL, NULL),
(4, 2, 1, 3, 34, '2020-06-23 05:30:42', '2020-06-26 17:53:58', NULL, 'June 21- June 27\r\n\r\nSaturday, June 20, 2020\r\n  - Replied to 10 emails\r\n  - Update CS Form sheet\r\n  - Update Shipping Update for Anita sheet.\r\n  - Sent new customers concern to paul\r\n\r\nSunday, June 21, 2020\r\n  - Replied to 5 emails\r\n  - Update CS Form sheet\r\n  - Sent new customers concern to paul\r\n\r\nMonday, June 22, 2020\r\n  - Replied to 5 emails\r\n  - Update CS Forms sheet\r\n  - Update Shipping Update for Anita sheet\r\n\r\nTuesday, June 23, 2020\r\n  - Replied to 7 emails\r\n  - Update CS Form sheet\r\n  - Update Shipping Update fro Anita sheet\r\n  - Message Paul the new set of customers concenrs\r\n\r\nWednesday, June 24, 2020\r\n  - Replied to 3 emails\r\n  - Update CS Form sheet\r\n  - Update Shipping Update to Anit sheet\r\n  - Update Emails sheet\r\n  - message paul about new set of customers concern\r\n\r\nThursday, June 25, 2020\r\n  - Replied to 6 emails\r\n  - Send new customers concerns to paul\r\n\r\nFriday, June 26, 2020\r\n  - Replied to 8 emails\r\n  - Update CS Forms sheet\r\n  - Update Shipping Update for Anita sheet.\r\n  - Replied to 2 sets of customers concerns', 0, 4, 0, '[[1592658900,1592663640],[1592708400,1592710500],[1592796723,1592799123],[1592925648,1592928408],[1593012085,1593015565],[1593098502,1593100002],[1593192124,1593195724]]', 5, 1, 0, NULL, NULL),
(5, 2, 1, 5, NULL, '2020-06-23 13:33:02', '2020-06-24 18:26:04', '2020-06-24 18:26:04', 'JUNE -21- JUNE', 1, 5, 0, '[[1592659992,1592660000],[1592832719,1592836319],[1592872363,1592875963],[1592919249,1592919261],[1593092123,0]]', 1, NULL, 9999, NULL, NULL),
(6, 5, 1, 5, NULL, '2020-06-23 16:28:35', '2020-06-24 18:25:57', '2020-06-24 18:25:57', 'Anne', 1, 6, 0, '[[1592882932,1592886532],[1592929818,1592929825]]', 1, NULL, 9999, NULL, NULL),
(7, 4, 1, 2, 31, '2020-06-26 17:02:29', '2020-06-26 17:47:50', NULL, 'IG', 0, 7, 0, '[[1592671983,1592680983],[1592758422,1592763822],[1592844844,1592848452],[1592931263,1592936663],[1593017702,1593023110],[1593104462,1593109862],[1593190900,1593196305]]', 2, 1, 1, NULL, NULL),
(9, 4, 1, 2, NULL, '2020-06-26 17:02:29', '2020-06-26 17:04:03', '2020-06-26 17:04:03', 'IG', 1, 8, 0, '[[1592671983,1592680983],[1592758422,1592763822],[1592844844,1592848452],[1592931263,1592936663],[1593017702,1593023110],[1593104462,1593109862],[1593190900,1593196305]]', 2, NULL, 9999, NULL, NULL),
(10, 4, 1, 6, 30, '2020-06-26 17:04:55', '2020-06-26 17:44:54', NULL, 'YT/Podcasts', 0, 9, 0, '[[1592931881,1592942686]]', 6, 1, 2, NULL, NULL),
(11, 4, 1, 4, 29, '2020-06-26 17:05:53', '2020-06-26 17:39:51', NULL, 'Casting', 0, 10, 0, '[[1593191137,1593205537]]', 4, 1, 4, NULL, NULL),
(12, 3, 1, 3, NULL, '2020-06-26 17:14:36', '2020-06-26 17:39:44', '2020-06-26 17:39:44', '', 1, 11, 0, '[]', 3, 1, 5, NULL, NULL),
(13, 1, 1, 5, 32, '2020-06-26 17:27:14', '2020-06-26 17:57:47', '2020-06-26 17:57:47', 'Hours for calling alex lola', 1, 12, 0, '[[1592933400,1592937000]]', 1, 1, 3, NULL, NULL),
(14, 3, 1, 5, 33, '2020-06-26 17:44:25', '2020-06-26 17:51:22', NULL, 'Tuesday, June 23, 2020\r\n  - Training in Anna System (Invoice Ninja)\r\n  - Work on LinkedIn (replied to messages, sent messages and connect) - Evening only\r\n  - Message Alex Lola. Because she''s not answering my call for 3x. \r\n  - Withdraw all the Business Group on LinkedIn that still not accepting us. \r\n  - Add/join an additional 5 business owners group\r\n  - Sent follow up emails to "TARGET MARKET LINKEDIN" \r\n\r\nWednesday, June 24, 2020\r\n  - Work in LinkedIn (replied to a message, sent message and connect) - Morning and Evening\r\n  - Call Alex''s grandma and ask if she needs help this week and she said nothing. \r\n  - Check "TARGET MARKET - LINKEDIN" new group but still waiting for approval as of today (June 24)\r\n  - Search for target clients on "TARGET MARKET - LINKEDIN".\r\n\r\nThursday, June 25, 2020\r\n  - Work on LinkedIn (replied to message, connect) - Morning and Evening\r\n  - Search for traget clients on "FB GROUP BUSINESS OWNERS"\r\n  - Search for target clients on "INSTAGRAM TASK"\r\n  - Search for target clients on "YELP Leads"\r\n  - Search for target clients on "FB PAGE GROUP TARGET MARKET "\r\n\r\nFriday, June 26, 2020\r\n  - Work on LinkedIn (sent messages and connect) - Morning only\r\n  - Sent emails to "FB PAGE GROUP TARGET MARKET" target clients\r\n  - Sent emails to "YELP Leads" target clients\r\n  - Sent emails to "TARGET MARKET - LINKEDIN" target clients\r\n  - Sent emails to "INSTAGRAM TASK" target clients\r\n  - Sent emails to "FB GROUP BUSINESS OWNERS" target clients', 0, 13, 0, '[[1592886709,1592893669],[1592973581,1592978141],[1593020541,1593027201],[1593107017,1593110017]]', 1, NULL, 9999, NULL, NULL),
(15, 4, 1, 2, 43, '2020-07-03 12:23:55', '2020-07-03 15:52:03', NULL, 'IG', 0, 14, 0, '[[1593299919,1593307133],[1593433175,1593438583],[1593519595,1593525004],[1593606014,1593611421],[1593692521,1593697924],[1593778968,1593786174],[1593865408,1593872608]]', 2, NULL, 9999, NULL, NULL),
(16, 4, 1, 6, 42, '2020-07-03 12:27:29', '2020-07-03 15:51:02', NULL, 'Ecom and Pocast --- Bert', 0, 15, 0, '[[1593433526,1593455137],[1593519945,1593541549],[1593606357,1593631582],[1593692791,1593717999],[1593779206,1593800809]]', 6, NULL, 9999, NULL, NULL),
(17, 3, 1, 3, 44, '2020-07-03 14:40:55', '2020-07-03 15:53:26', NULL, 'June 28 - July 4, 2020 (Sun-Sat)\r\n\r\nSaturday, June 27, 2020\r\n  - Replied to 4 emails\r\n  - Replied to 12 emails from "ATTENTION" sheet \r\n  - Update CS Forms sheet\r\n  - Update Shipping Update to Anita sheet\r\n  - Update Emails sheet\r\n  - Update Attention sheet\r\n  - Sent new customers concern to Paul\r\n\r\nSunday, June 28, 2020\r\n  - Replied to 4 email\r\n  - Update CS Forms sheet\r\n  - Update ATTENTION sheet\r\n  - Update EMAILS sheet\r\n  - Update Shipping Update to Anita sheet\r\n  - Replied to 1 email from "ATTENTION" sheet \r\n\r\nMonday, June 29, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Form sheet\r\n\r\nTuesday, June 30, 2020\r\n  - Replied to 1 email\r\n  - message paul about new set of customers concern\r\n  - Update CS Form sheet\r\n  - Replied to 3 emails from customers concern sent to Paul\r\n\r\nWednesday, July 1, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Sent new customers concern to paul\r\n  - Replied to 4 emails from customers concern sent to Paul\r\n\r\nThursday, July 2, 2020\r\n  - Replied to 2 emails\r\n  - Update EMAILS sheet\r\n  - Sent 1 customer concern to Paul\r\n\r\nFriday, July 3, 2020\r\n  - Replied to 5 emails\r\n  - Sent 5 emails from customer concer.\r\n  - Update CS Form sheet\r\n  - message paul about new set of customers concern\r\n  - Updpate EMAILS sheet', 0, 16, 0, '[[1593221365,1593225565],[1593307875,1593312255],[1593394342,1593395542],[1593480801,1593482001],[1593567324,1593570924],[1593653778,1593654378],[1593787069,1593790669]]', 5, NULL, 9999, NULL, NULL),
(18, 3, 1, 5, 46, '2020-07-03 14:45:10', '2020-07-03 18:34:57', NULL, 'July 1-3, 2020 (Wed-Fri)\r\n\r\nWednesday, July 1, 2020\r\n  - Call Alex grandma and ask if she needs help this week and she said nothing. \r\n\r\nThursday, July 2, 2020\r\n  - Call Alex grandma as per Alex. And also ask if she needs anything. She said she only needs the thing about Dr.Murray \r\n\r\nFriday, July 3, 2020\r\n  - Read reviews about Dr.Murray\r\n  - Call Alex grandma and explain some things about Dr.Murray', 0, 17, 0, '[[1593567730,1593568330],[1593701031,1593701631],[1593787494,1593788694]]', 1, NULL, 9999, NULL, NULL),
(19, 4, 1, 2, 51, '2020-07-10 14:58:24', '2020-07-10 16:09:43', NULL, 'IG', 0, 18, 0, '[[1593960952,1593968161],[1594047379,1594054879],[1594133792,1594139204],[1594220222,1594225626],[1594306643,1594313846],[1594393057,1594400261],[1594479478,1594486681]]', 2, NULL, 9999, NULL, NULL),
(20, 4, 1, 2, NULL, '2020-07-10 14:58:25', '2020-07-10 14:59:18', '2020-07-10 14:59:18', 'IG', 1, 19, 0, '[[1593960952,1593968161],[1594047379,1594054879],[1594133792,1594139204],[1594220222,1594225626],[1594306643,1594313846],[1594393057,1594400261],[1594479478,1594486681]]', 2, NULL, 9999, NULL, NULL),
(21, 4, 1, 6, NULL, '2020-07-10 15:02:06', '2020-07-14 17:18:01', NULL, 'Ecom and Podcast Guest', 0, 20, 0, '[[1594134024,1594144834],[1594220440,1594242048],[1594306856,1594328459],[1594393272,1594414880]]', 6, 1, 0, NULL, NULL),
(23, 4, 1, 6, NULL, '2020-07-10 15:02:06', '2020-07-10 15:05:15', '2020-07-10 15:05:15', 'Ecom and Podcast Guest', 1, 21, 0, '[[1594134024,1594144834],[1594220440,1594242048],[1594306856,1594328459],[1594393272,1594414880]]', 6, NULL, 9999, NULL, NULL),
(24, 3, 1, 3, 48, '2020-07-10 15:05:37', '2020-07-10 16:00:33', NULL, 'Sunday, July 5, 2020\r\n  - Replied to email\r\n  - Update CS Form sheet\r\n  - Update EMAILS sheet\r\n  - message paul about new set of customers concern\r\n\r\nMonday. July 6, 2020\r\n  - Replied to email\r\n  - message paul about new set of customers concern\r\n  - Update CS Form sheet\r\n\r\nTuesday, July 7, 2020\r\n  - Replied to emails\r\n  - Update EMAILS sheet\r\n  - Replied 7 emails from customers concern\r\n  - Update CS Forms sheet\r\n  - message paul about new set of customers concern\r\n\r\nWednesday, July 8, 2020\r\n  - Replied to emails\r\n  - Update EMAILS sheet\r\n  - Message Paul 1 customer concern\r\n  - Update CS Forms sheet\r\n  - Sent 3 emails from customer concern\r\n\r\nThursday, July 9, 2020\r\n  - Replied to emails\r\n  - Update EMAILS sheet\r\n  - Update CS Forms sheet\r\n  - message paul about new set of customers concern\r\n  - List new set of customers concerns\r\n\r\nFriday, July 10, 2020\r\n  - Update EMAILS sheet\r\n  - List new set of customers concerns\r\n  - message paul about new set of customers concern', 0, 22, 0, '[[1593960862,1593962065],[1594047308,1594049111],[1594133764,1594137367],[1594220251,1594224754],[1594306720,1594310322],[1594393169,1594394971]]', 5, NULL, 9999, NULL, NULL),
(25, 4, 1, 7, NULL, '2020-07-10 15:05:57', '2020-07-14 17:18:01', NULL, 'Bonus', 0, 23, 0, '[[1594393548,1594404352]]', 7, 1, 1, NULL, NULL),
(26, 3, 1, 5, 49, '2020-07-10 15:16:12', '2020-07-10 16:06:40', NULL, 'Sunday, July 5, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages, accept 3 connections, and connect)\r\n\r\nMonday. July 6, 2020\r\n  - Work on LinkedIn (replied to messages and connect)\r\n  - Search for target clients on TARGET MARKET - LINKEDIN\r\n\r\nTuesday, July 7, 2020\r\n  - Search for target client on INSTAGRAM TASK.\r\n  - Work on LinkedIn (replied to messages and connect)\r\n  - Call grandma but there is no answer\r\n  - Call again Alex grandma and ask if she needs anything for this week and she said nothing. Ask also if she needs some groceries and she can tell me and I''ll pass it to Alex and he will be the one to pay. But for this week, she said nothing. \r\n  - Search for target client on FB GROUP BUSINESS OWNERS\r\n\r\nWednesday, July 8, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages and connect)\r\n  - Search for target client on FB PAGE GROUP TARGET MARKET \r\n\r\nThursday, July 9, 2020\r\n  - Work on LinkedIn (replied to messges, connect and sent messages)\r\n  - Searc for target client on YELP Leads\r\n\r\nFriday, July 10, 2020\r\n  - Work on LinkedIn (replied to messages and connect) \r\n  - Sent emails to YELP Leads target clients\r\n  - Sent emails to TARGET MARKET - LINKEDIN target clients\r\n  - Sent emails to INSTAGRAM TASK target clients\r\n  - Sent emails to FB GROUP BUSINESS OWNERS target clients\r\n  - Sent emails to FB PAGE GROUP TARGET MARKET  target clients\r\n  - Look for target clients VA needs on FB Group Business Owners\r\n\r\nFriday, July 10, 2020\r\n  - $10 Bonus as per Ms.Rheina and Alex -- THANK YOU <3', 0, 24, 0, '[[1593961803,1593963005],[1594048228,1594051230],[1594134685,1594140208],[1594221123,1594223825],[1594307567,1594311589],[1594394045,1594398548],[1594433689,1594444491]]', 1, NULL, 9999, NULL, NULL),
(27, 2, 1, 5, NULL, '2020-07-11 02:01:55', '2020-07-11 13:00:04', '2020-07-11 13:00:04', 'July 7 - training 10am till 10:30', 1, 25, 0, '[[1594432889,1594434600]]', 1, NULL, 9999, NULL, NULL),
(28, 4, 1, 6, 54, '2020-07-11 03:42:19', '2020-07-11 13:00:46', NULL, 'Ecom/Podcast', 0, 26, 0, '[[1594132861,1594143674],[1594179685,1594201288],[1594266097,1594287728]]', 6, NULL, 9999, NULL, NULL),
(29, 4, 1, 2, 56, '2020-07-14 17:35:32', '2020-07-14 18:10:55', NULL, 'IG #', 0, 27, 0, '[[1594528412,1594535617],[1594575230,1594582435],[1594661642,1594668853],[1594748059,1594755379],[1594834472,1594841672],[1594920919,1594924526]]', 2, NULL, 9999, NULL, NULL),
(30, 3, 1, 3, 58, '2020-07-17 15:05:12', '2020-07-17 15:38:46', NULL, 'Saturday, July 11, 2020\r\n  - Replied to 6 emails from customers concern\r\n  - Update EMAILS sheet\r\n\r\nSunday, July 12, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 1 email\r\n  - message paul about new set of customers concern\r\n\r\nMonday, July 13, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 4 emails\r\n\r\nTuesday, July 14, 2020\r\n  - Replied to 4 emails \r\n  - Update EMAIL sheet\r\n  - Update CS Form sheet\r\n  - Message Paul about the new set of customers concern\r\n\r\nWednesday, July 15, 2020\r\n  - Update EMAIL sheet\r\n  - Replied to 4 emails\r\n  - Update CS Forms sheet\r\n  - Update Shipping Update for Anita\r\n  - Replied to 9 emails from customer concerns that I sent to Paul\r\n  - message paul about new set of customers concern\r\n\r\nThursday, July 16, 2020\r\n  - Replied to 9 emails\r\n  - Update EMAIL sheet\r\n  - Update CS Forms sheet\r\n\r\nFriday, July 17, 2020\r\n  - Replied to 3 emails\r\n  - Update EMAIL sheet\r\n  - Update CS Forms sheet\r\n  - Sent new set of customers concern to Paul\r\n  - Update ATTENTION sheet', 0, 28, 0, '[[1594479562,1594481971],[1594566010,1594567812],[1594652443,1594653647],[1594738892,1594741294],[1594825346,1594829548],[1594911798,1594914199],[1594998245,1595002447]]', 5, NULL, 9999, NULL, NULL),
(31, 3, 1, 5, 59, '2020-07-17 15:08:33', '2020-07-17 22:10:57', NULL, 'Tuesday, July 14, 2020\r\n  - Call grandma but there is no answer. So I sent a voice mail. \r\n\r\nWednesday, July 15, 2020\r\n  - Call Alex Lola and ask if she needs something or some grocery list for this week and she said she will call me back. Or I told her that she can leave a voice message if ever she needs more time because she''s taking something on her husband.', 0, 29, 0, '[[1594739192,1594739795],[1594825696,1594826299]]', 1, NULL, 9999, NULL, NULL),
(32, 4, 1, 6, 60, '2020-07-17 19:20:43', '2020-07-17 22:15:19', NULL, 'YT/Podcast/ecom and others', 0, 30, 0, '[[1594581109,1594599126],[1594667591,1594671196],[1594754001,1594766621],[1594840458,1594854880],[1594926894,1594944899]]', 6, NULL, 9999, NULL, NULL),
(33, 3, 1, 3, 64, '2020-07-24 16:26:45', '2020-07-24 17:37:08', NULL, 'July 19-25, 2020 (Sun-Sat)\r\n\r\nSaturday, July 18, 2020\r\n  - Replied to 3 emails\r\n  - Update EMAIL sheet\r\n  - Update Shipping Update for Anita\r\n  - Replied to 8 customer concern\r\n  - Update CS Forms sheet\r\n\r\nSunday, July 19, 2020\r\n  - Replied to 3 emails\r\n  - Update CS Form sheet\r\n  - Update EMAIL sheet\r\n  - Sent new set of customers concern to Paul\r\n\r\nMonday, July 20, 2020\r\n  - Replied to 4 emails\r\n  - Update CS Form sheet\r\n  - Sent 1 customer concern to Paul\r\n  - Sent follow up customers concerns to Paul\r\n\r\nTuesday, July 21, 2020\r\n  - Replied to 1 email\r\n  - Update CS Form sheet\r\n  - Update EMAILS sheet\r\n  - Sent new set of customers concern to Paul\r\n\r\nWednesday, July 22, 2020\r\n  - Replied to 5 emails\r\n  - Replied to 8 emails from customers concern\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Sent 2 customers concern from Paul\r\n  - Replied to Paul''s and Anita''s messages on Skype Group Chat\r\n  - Sent 1 customer concern to Anita\r\n\r\nThursday, July 23, 2020\r\n  - Repllied to 2 emails\r\n  - Update EMAIL sheet\r\n  - Update CS Forms sheet\r\n  - Sent customerc concerns reply to our emails.\r\n  - Message back Anita regarding 1 customer concern\r\n\r\nFriday, July 24, 2020\r\n  - Replied to 2 emails\r\n  - Sent 1 customer concern to Anita\r\n  - Update CS Form sheet\r\n  - Replied to 4 customers concerns from Paul\r\n  - Replied to Anita''s messages', 0, 31, 0, '[[1595087482,1595091085],[1595173991,1595175793],[1595260565,1595262368],[1595347153,1595348955],[1595426616,1595430279],[1595473723,1595475525],[1595521581,1595524583]]', 5, NULL, 9999, NULL, NULL),
(34, 3, 1, 5, NULL, '2020-07-24 16:55:08', '2020-07-24 17:03:06', '2020-07-24 17:03:06', 'July 19-25, 2020 (Sun-Sat)\r\n\r\nSaturday, July 18, 2020\r\n  - Work on LinkedIn (sent message and connect)\r\n\r\nSunday, July 19, 2020\r\n  - Work on LinkedIn (sent messages and connect)\r\n  - Search for target client on FB GROUP BUSINESS OWNERSJoined 3 new FB Page Group\r\n\r\nMonday, July 20, 2020\r\n  - Work on LinkedIn (sent message and connect) \r\n  - Got approved on 3 new groupf from FB GROUP BUSINESS OWNERS\r\n  - Search for target client on new FB GROUP BUSINESS OWNERS groups\r\n  - Search for target client on INSTAGRAM TASK.\r\n\r\nTuesday, July 21, 2020\r\n  - Work on LinkedIn (replied to messages, sent message and connect)\r\n  - Search for target client on TARGET MARKET - LINKEDIN\r\n  - Call Alex grandma (twice) but there is no answer. I just leave a voice message and will contact her again tomorrow. \r\n\r\nWednesday, July 22, 2020\r\n  - Work on LinkedIn (replied to messages and sent messages)\r\n  - Sent 81 new messages to LinkedIN\r\n  - Search for target client on INSTAGRAM TASK.\r\n  - Call Alex grandma and ask if she needs help of need some grocery but she said shes fine.\r\n  \r\nTursday, July 23, 2020\r\n  - Work on LinkedIn (replied to messages, connect and sent messages)\r\n  - Search for target clients on LINKEDIN LEADS\r\n\r\nFriday, July 24, 2020\r\n  - Work on LinkedIn (replied to messages and send message)\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Sent emails to FB TARGET LEADS\r\n  - Sent emails to FB PAGE GROUP TARGET MARKET  target clients', 1, 32, 0, '[[1595004016,1595004618],[1595090599,1595094202],[1595177080,1595180682],[1595303649,1595307249],[1595350101,1595355503],[1595436573,1595441077],[1595523066,1595530268]]', 1, NULL, 9999, NULL, NULL),
(35, 3, 1, 5, 63, '2020-07-24 16:55:10', '2020-07-24 17:35:55', NULL, 'July 19-25, 2020 (Sun-Sat)\r\n\r\nSaturday, July 18, 2020\r\n  - Work on LinkedIn (sent message and connect)\r\n\r\nSunday, July 19, 2020\r\n  - Work on LinkedIn (sent messages and connect)\r\n  - Search for target client on FB GROUP BUSINESS OWNERSJoined 3 new FB Page Group\r\n\r\nMonday, July 20, 2020\r\n  - Work on LinkedIn (sent message and connect) \r\n  - Got approved on 3 new groupf from FB GROUP BUSINESS OWNERS\r\n  - Search for target client on new FB GROUP BUSINESS OWNERS groups\r\n  - Search for target client on INSTAGRAM TASK.\r\n\r\nTuesday, July 21, 2020\r\n  - Work on LinkedIn (replied to messages, sent message and connect)\r\n  - Search for target client on TARGET MARKET - LINKEDIN\r\n  - Call Alex grandma (twice) but there is no answer. I just leave a voice message and will contact her again tomorrow. \r\n\r\nWednesday, July 22, 2020\r\n  - Work on LinkedIn (replied to messages and sent messages)\r\n  - Sent 81 new messages to LinkedIN\r\n  - Search for target client on INSTAGRAM TASK.\r\n  - Call Alex grandma and ask if she needs help of need some grocery but she said shes fine.\r\n  \r\nTursday, July 23, 2020\r\n  - Work on LinkedIn (replied to messages, connect and sent messages)\r\n  - Search for target clients on LINKEDIN LEADS\r\n\r\nFriday, July 24, 2020\r\n  - Work on LinkedIn (replied to messages and send message)\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Sent emails to FB TARGET LEADS\r\n  - Sent emails to FB PAGE GROUP TARGET MARKET  target clients\r\n\r\nJuly 25, 2020\r\n  - CA Meeting\r\n\r\nPS. It''s ok to Ms.Rheina and Alex if you pay only the 7hrs.', 0, 33, 0, '[[1595090599,1595091202],[1595177080,1595180682],[1595303649,1595307249],[1595350101,1595353703],[1595436573,1595441977],[1595523066,1595526668],[1595609744,1595616977],[1595649567,1595651369]]', 1, NULL, 9999, NULL, NULL),
(36, 4, 1, 6, 68, '2020-07-27 17:58:49', '2020-07-27 18:14:50', NULL, 'task', 0, 34, 0, '[[1595181442,1595190452],[1595267868,1595276873],[1595354290,1595361493],[1595440699,1595447909],[1595527119,1595537923]]', 6, NULL, 9999, NULL, NULL),
(37, 7, 1, 5, NULL, '2020-07-31 03:52:14', '2020-07-31 16:20:56', '2020-07-31 16:20:56', 'Meeting', 1, 35, 0, '[[1595606400,1595608200]]', 1, NULL, 9999, NULL, NULL),
(38, 7, 1, 5, 70, '2020-07-31 03:54:16', '2020-07-31 16:51:05', NULL, 'July 24, 2020 - Attended Meeting\r\nJuly 27, 2020 - Work on LinkedIn (connect and sent message) \r\nJuly 28, 2020 - Work on LinkedIn (connect and sent message)', 0, 36, 0, '[[1595779200,1595782800],[1595865600,1595869200]]', 1, NULL, 9999, NULL, NULL),
(39, 7, 1, 5, NULL, '2020-07-31 03:55:32', '2020-07-31 16:21:12', '2020-07-31 16:21:12', 'Find leads on LinkedIn / Connect on business owners and get contact information', 1, 37, 0, '[[1595865600,1595869200]]', 1, NULL, 9999, NULL, NULL),
(40, 3, 1, 3, 71, '2020-07-31 14:49:07', '2020-07-31 16:51:46', NULL, 'July 26-August 1, 2020 (Sun-Sat)\r\n\r\nSaturday, July 25, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 5 emails\r\n  - Update CS Forms sheet\r\n  - Replied to 1 email fom customer concerns from Anita\r\n  - Replied to Anita''s messages\r\n  - Message Paul for 2 new customers concerns\r\n\r\nSunday, July 26, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 1 email\r\n  - Update CS Form sheet\r\n  - Message 1 customer concern to Paul\r\n\r\nMonday, July 27, 2020\r\n  - Repllied to 2 emails\r\n  - Update EMAILS sheet\r\n  - Update CS Forms sheet\r\n\r\nTuesday, July 28, 2020\r\n  - Replied to Anita''s messages\r\n  - Replied to Paul''s question\r\n  - Replied to 1 previous customer concer from Paul\r\n  - Replied to 4 emails\r\n  - Update EMAILS sheet\r\n  - Sent 3 customers concerns to Anita\r\n  - Update CS Forms sheet\r\n\r\nWednesday, July 29, 2020\r\n  - Replied to Anita''s messages\r\n  - Update EMAILS sheet\r\n  - Replied to 1 email\r\n  - Update CS Forms sheet\r\n  - Replied to Paul''s messages regarding customer concerns\r\n  - Replied to 1 customers concern from Paul\r\n  - Message Paul about customer concern\r\n\r\nThursday, July 30, 2020\r\n  - Message Anita for 1 customer concern\r\n  - Udate EMAILS sheet\r\n  - Message Paul about 1 customer concern\r\n\r\nFriday, July 31, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Replied to Paul''s messages\r\n  - Replied to 2 customers concern from Paul\r\n  - Message Paul about customers concern in Skype\r\n  - Sent to Paul the 3 customers concerns from Skype', 0, 38, 0, '[[1595687902,1595691505],[1595774329,1595775832],[1595860776,1595861980],[1595947314,1595950916],[1596033775,1596036478],[1596120212,1596121114],[1596206686,1596209089]]', 5, NULL, 9999, NULL, NULL),
(41, 3, 1, 5, 69, '2020-07-31 14:53:08', '2020-07-31 16:46:46', NULL, 'July 26-August 1, 2020 (Sun-Sat)\r\n\r\nTuesday, July 28, 2020\r\n  - Work on LinkedIn (connect and sent message)\r\n\r\nWednesday, July 29, 2020\r\n  - Work on LinkedIn (replied to messages and sent 20 new messages)\r\n  - Search for new target clients on INSTAGRAM LEADS\r\n  - Call Alex grandma and ask if she needs anything for this week but she said no.\r\n\r\nThursday, July 30, 2020\r\n  - Work on LinkedIn (replied to messages and sent message)\r\n  - Search for target clients on LINKEDIN LEADS\r\n\r\nFriday, July 31, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages and connect)\r\n  - Search for taget clients on FB TARGET LEADS\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Sent emails to FB TARGET LEADS', 0, 39, 0, '[[1595947804,1595948407],[1596034251,1596038154],[1596120683,1596124584],[1596207131,1596212533]]', 1, NULL, 9999, NULL, NULL),
(42, 4, 1, 6, 73, '2020-08-03 01:05:29', '2020-08-03 02:46:44', NULL, 'Amazon, Yt podcast collab/ email', 0, 40, 0, '[[1595851312,1595863933],[1595898147,1595909307],[1595937758,1595950358],[1596024167,1596034972],[1596157378,1596168194]]', 6, NULL, 9999, NULL, NULL),
(43, 4, 1, 6, 82, '2020-08-03 17:17:56', '2020-08-08 12:09:41', NULL, 'etsy / prouct configuration/ research /tags/ pictures', 0, 41, 0, '[[1596475076,1596476888],[1596501557,1596503867],[1596506596,1596508236]]', 6, NULL, 9999, 'null', 'null'),
(44, 4, 1, 6, 83, '2020-08-04 02:33:13', '2020-08-08 12:11:06', NULL, 'amazon dropshipping/ meeting with tim / reseach for new products hetting familiar with the calculator', 0, 42, 0, '[[1596508393,1596510205],[1596515158,1596518771]]', NULL, NULL, 9999, 'null', 'null'),
(45, 4, 1, 6, 84, '2020-08-04 23:53:27', '2020-08-08 12:12:57', NULL, 'Responding to email :Nimi and other yt collab and podcast\r\ngetting photo banner for social media\r\n/clear acryllic for etsy\r\n\r\nFollow uo for podcast and yt. \r\nCheck spam emails', 0, 43, 0, '[[1596585207,1596590643]]', 6, NULL, 9999, NULL, NULL),
(46, 4, 1, 6, 85, '2020-08-06 01:34:48', '2020-08-08 12:13:58', NULL, 'etsy excel file/ product name / amazon dropshipping /email', 0, 44, 0, '[[1596677688,1596686908]]', 6, NULL, 9999, NULL, NULL),
(47, 4, 1, 6, NULL, '2020-08-06 23:40:30', '2020-08-07 00:12:41', NULL, 'email prospecting video/ etsy moon/', 0, 45, 0, '[[1596757230,1596759161]]', 6, NULL, 9999, NULL, NULL),
(49, 4, 1, 6, 86, '2020-08-06 23:40:30', '2020-08-08 12:14:56', NULL, 'email prospecting video/ etsy moon/', 0, 46, 0, '[[1596757230,1596759174]]', 6, NULL, 9999, NULL, NULL),
(50, 4, 1, 6, 87, '2020-08-07 01:06:05', '2020-08-08 12:46:40', NULL, 'Amazon Dropshipping', 0, 47, 0, '[[1596762365,1596766466]]', 6, NULL, 9999, NULL, NULL),
(51, 7, 1, 5, 79, '2020-08-07 13:38:48', '2020-08-07 17:13:50', NULL, 'August 5, 2020 - Work on LinkedIn (connect and sent message)', 0, 48, 0, '[[1596556800,1596560400]]', 1, NULL, 9999, NULL, NULL),
(52, 3, 1, 3, 78, '2020-08-07 14:48:44', '2020-08-07 17:09:47', NULL, 'August 2-8, 2020 (Sun-Sat)\r\n\r\nSaturday, August 1, 2020\r\n  - Replied to 1 email\r\n  - Update CS Form sheet\r\n\r\nSunday, August 2, 2020\r\n  - Replied to 2 emails\r\n  - Message Anita about 1 customer concern. \r\n  - Update CS Form Sheet\r\n\r\nMonday, August 3, 2020\r\n  - Replied to 1 email\r\n  - Update CS Forms sheet\r\n  - Message Anita for 2 customer concern \r\n\r\nTuesday, August 4, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Sent new set of customers concern\r\n\r\nWednesday, August 5, 2020\r\n  - Replied to 5 emails\r\n  - Update CS Forms sheet\r\n  - Message Anita for 2 customer concern \r\n  - Update EMAILS sheet\r\n\r\nThursday, August 6, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to 4 customers concern from Paul\r\n  - Replied back to Paul''s messages regarding the tentative customers from Skype\r\n  - Message Anita for 1 customer concern\r\n\r\nFriday, August 7, 2020\r\n  - Replied to 2 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Sent 1 customer concern to Anita', 0, 49, 0, '[[1596292867,1596293469],[1596379306,1596381108],[1596465746,1596466649],[1596552183,1596553985],[1596638619,1596642222],[1596725069,1596726871],[1596811519,1596812421]]', 5, NULL, 9999, NULL, NULL),
(53, 3, 1, 5, 80, '2020-08-07 14:53:50', '2020-08-07 17:14:45', NULL, 'August 2-8, 2020 (Sun-Sat)\r\n\r\nTuesday, August 4, 2020\r\n  - Bonus 1hr as per Alex\r\n  - Call Alex grandma and ask if she needs something this week but she said nothing. \r\n\r\nWednesday, August 5, 2020\r\n  - Work on LinkedIn (replied to messages and connect)Search for target clients on LINKEDIN LEADS\r\n\r\nThursday, August 6, 2020\r\n  - Work on LinkedIn (replied to messages, sent messages and connect)\r\n  - Search for new target clients on LINKEDIN LEADS\r\n  - Search for target clients on INSTAGRAM LEADS\r\n  - Search for target clients on FB TARGET LEADS\r\n\r\nFriday, August 7, 2020\r\n  - Work on LinkedIn (replied to messages and connect)\r\n  - Search for targer clients on FB GROUP LEADS\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Sent emails to FB TARGET LEADS\r\n  - Sent emails to FB GROUP LEADS', 0, 50, 0, '[[1596552673,1596556877],[1596639108,1596642712],[1596725554,1596730957],[1596812017,1596817419]]', 1, NULL, 9999, NULL, NULL),
(54, 4, 1, 6, 88, '2020-08-07 23:52:51', '2020-08-08 12:47:46', NULL, 'etsy store/ Change imagge for floating shelves/ publishe coloring sheets', 0, 51, 0, '[[1596844371,1596846559]]', 6, NULL, 9999, NULL, NULL),
(55, 4, 1, 6, 89, '2020-08-08 03:31:22', '2020-08-08 13:04:03', NULL, 'AMazon /listed 4 items and another 3 out of stocks', 0, 52, 0, '[[1596857482,1596866563]]', 6, NULL, 9999, NULL, NULL),
(56, 4, 1, 6, NULL, '2020-08-14 08:28:04', '2020-08-14 08:28:04', NULL, 'amazon; listed 3 products...', 0, 53, 0, '[[1597220837,1597224437]]', 6, NULL, 9999, NULL, NULL),
(57, 4, 1, 6, NULL, '2020-08-14 08:29:21', '2020-08-14 08:29:21', NULL, 'amazon 2 product listed', 0, 54, 0, '[[1597307347,1597310951]]', 6, NULL, 9999, NULL, NULL),
(58, 4, 1, 6, NULL, '2020-08-14 08:29:23', '2020-08-14 08:30:56', '2020-08-14 08:30:56', 'amazon 2 product listed', 1, 55, 0, '[[1597307347,1597310951]]', 6, NULL, 9999, NULL, NULL),
(59, 4, 1, 6, NULL, '2020-08-14 08:35:13', '2020-08-17 12:58:24', '2020-08-17 12:58:24', 'Stoey Joey look for emails \r\n\r\nhttps://docs.google.com/spreadsheets/d/1pDiPH3Tk8zHdK8M1Mp4I1y0tb4_3cfoZ2MoGWG9tYSM/edit#gid=0', 1, 56, 0, '[[1597394113,1597669085]]', 6, NULL, 9999, NULL, NULL),
(60, 3, 1, 3, 92, '2020-08-14 14:41:31', '2020-08-14 18:20:57', NULL, 'August 9-15, 2020 (Sun-Sat)\r\n\r\nSaturday, August 8, 2020\r\n  - Received email from Klaviyo\r\n  - Replied to 2 emails\r\n  - Message Paul about new set of customers concern\r\n\r\nSunday, August 9, 2020\r\n  - Replied to 1 email\r\n  - Update EMAILS sheet\r\n  - Replied to Anita message\r\n\r\nMonday, August 10, 2020\r\n  - Message Paul about 1 customer concern\r\n  - Replied to Anita messages\r\n  - Replied to 2 emails\r\n\r\nTuesday, August 11, 2020\r\n  - Replied to 1 email\r\n  - Update EMAILS sheet\r\n  - Replied to Anita''s messages\r\n\r\nWednesday, August 12, 2020\r\n  - Replied to 3 emails\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Replied to 2 emails from customers concern from Paul\r\n  - Replied to 1 email from customers concern from Anita\r\n  - Messgae Anita for another customer concern\r\n\r\nThursday, August 13, 2020\r\n  - Replied to 1 email\r\n  - Update CS Forms sheet\r\n  - Update EMAILS sheet\r\n  - Message Paul about 1 customer concern reply\r\n\r\nFriday, August 14, 2020\r\n  - Update EMAILS sheet\r\n  - Replied to Anita''s messages\r\n  - Message Paul about 1 new customer concern from Skype', 0, 57, 0, '[[1596897293,1596898497],[1596983754,1596984658],[1597070235,1597071437],[1597156679,1597157582],[1597243138,1597246739],[1597329573,1597330775],[1597416017,1597416919]]', 5, NULL, 9999, NULL, NULL),
(61, 3, 1, 5, NULL, '2020-08-14 14:48:56', '2020-08-14 18:24:28', '2020-08-14 18:24:28', 'August 9-15, 2020 (Sun-Sat)\r\n\r\nTuesday, August 11, 2020\r\n  - Call Alex grandma and ask if she need something this week, and she said none. \r\n\r\nFriday, August 14, 2020\r\n  - Work on LinkedIn (connect, replied to messages and sent messages)\r\n  - Search for target clients on LINKEDIN LEADS\r\n  - Search for target clients on INSTAGRAM  LEADS\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Search for target clients on FB TARGET LEADS \r\n  - Sent emails to FB TARGET LEADS\r\n  - Work on LinkedIn (replied to message and connect)', 1, 58, 0, '[[1597157102,1597157704],[1597416513,1597424615]]', 1, NULL, 9999, NULL, NULL),
(62, 3, 1, 5, 94, '2020-08-14 14:48:57', '2020-08-14 18:23:52', NULL, 'August 9-15, 2020 (Sun-Sat)\r\n\r\nTuesday, August 11, 2020\r\n  - Call Alex grandma and ask if she need something this week, and she said none. \r\n\r\nFriday, August 14, 2020\r\n  - Work on LinkedIn (connect, replied to messages and sent messages)\r\n  - Search for target clients on LINKEDIN LEADS\r\n  - Search for target clients on INSTAGRAM  LEADS\r\n  - Sent emails to LINKEDIN LEADS\r\n  - Sent emails to INSTAGRAM LEADS\r\n  - Search for target clients on FB TARGET LEADS \r\n  - Sent emails to FB TARGET LEADS\r\n  - Work on LinkedIn (replied to message and connect)', 0, 59, 0, '[[1597157102,1597157704],[1597416513,1597424615]]', 1, NULL, 9999, NULL, NULL),
(63, 7, 1, 10, 93, '2020-08-14 15:42:19', '2020-08-14 18:22:21', NULL, 'Monday, August 10, 2020\r\n- Training&Orientation\r\n- worked on LinkedIn (connect and sent messages)\r\n- update spreadsheet\r\n\r\nTuesday, August 11, 2020\r\n- Continued training\r\n- Worked on LinkedIn ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Update spreadsheet\r\n\r\nWednesday, August 12, 2020\r\n- Worked on LinkedIn ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Training for Facebook management\r\n- Sent friend request to Facebook group leads\r\n- Update spreadsheet\r\n\r\nThursday, August 13, 2020\r\n- Worked on Linkedin ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Sent friend request to relevant profiles\r\n- Check Facebook group activity/discussion ( interact and react as necessary )\r\n- Update spreadsheet\r\n\r\nFriday, August 14, 2020\r\n- Worked on Linkedin ( connect and sent messages )\r\n- Sent messages to LinkedIn leads\r\n- Sent friend request to relevant profiles\r\n- Check Facebook group activity/discussion ( interact and react as necessary )\r\n- Update spreadsheet', 0, 60, 0, '[[1597068000,1597082400],[1597154400,1597168800],[1597240800,1597255200],[1597327200,1597341600],[1597413600,1597428000]]', NULL, NULL, 9999, NULL, NULL),
(64, 4, 1, 6, NULL, '2020-08-17 12:59:26', '2020-08-18 12:15:03', '2020-08-18 12:15:03', 'Stoey JOey / news collab / email look up  /call and email', 1, 61, 0, '[[1597669166,1597671009]]', 6, NULL, 9999, NULL, NULL),
(65, 4, 1, 6, NULL, '2020-08-17 13:31:01', '2020-08-17 15:02:11', NULL, 'Amazon dropshipping / 4 items', 0, 62, 0, '[[1597671061,1597676505]]', 6, NULL, 9999, NULL, NULL),
(66, 4, 1, 6, NULL, '2020-08-18 12:15:57', '2020-08-18 13:33:38', NULL, 'nAmazon Dropshipping/', 0, 63, 1, '[[1597752957,1597754719],[1597757618,false]]', 6, NULL, 9999, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `task_statuses`
--

CREATE TABLE `task_statuses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort_order` smallint(6) NOT NULL DEFAULT 0,
  `public_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_statuses_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `task_statuses_user_id_foreign` (`user_id`),
  KEY `task_statuses_account_id_index` (`account_id`),
  KEY `task_statuses_public_id_index` (`public_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `task_statuses`
--

INSERT INTO `task_statuses` VALUES
(1, 1, 1, '2020-06-18 19:42:00', '2020-06-18 19:42:00', NULL, 'Backlog', 0, 1),
(2, 1, 1, '2020-06-18 19:42:00', '2020-06-18 19:42:00', NULL, 'Ready to do', 1, 2),
(3, 1, 1, '2020-06-18 19:42:00', '2020-06-18 19:42:00', NULL, 'In progress', 2, 3),
(4, 1, 1, '2020-06-18 19:42:00', '2020-06-18 19:42:00', NULL, 'Done', 3, 4);

-- --------------------------------------------------------

--
-- Table structure for table `tax_rates`
--

CREATE TABLE `tax_rates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rate` decimal(13,3) NOT NULL,
  `public_id` int(10) unsigned NOT NULL,
  `is_inclusive` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tax_rates_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `tax_rates_user_id_foreign` (`user_id`),
  KEY `tax_rates_account_id_index` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` VALUES
(1, 'amelia'),
(2, 'cerulean'),
(3, 'cosmo'),
(4, 'cyborg'),
(5, 'flatly'),
(6, 'journal'),
(7, 'readable'),
(8, 'simplex'),
(9, 'slate'),
(10, 'spacelab'),
(11, 'united'),
(12, 'yeti');

-- --------------------------------------------------------

--
-- Table structure for table `timezones`
--

CREATE TABLE `timezones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `timezones`
--

INSERT INTO `timezones` VALUES
(1, 'Pacific/Midway', '(GMT-11:00) Midway Island'),
(2, 'US/Samoa', '(GMT-11:00) Samoa'),
(3, 'US/Hawaii', '(GMT-10:00) Hawaii'),
(4, 'US/Alaska', '(GMT-09:00) Alaska'),
(5, 'US/Pacific', '(GMT-08:00) Pacific Time (US &amp; Canada)'),
(6, 'America/Tijuana', '(GMT-08:00) Tijuana'),
(7, 'US/Arizona', '(GMT-07:00) Arizona'),
(8, 'US/Mountain', '(GMT-07:00) Mountain Time (US &amp; Canada)'),
(9, 'America/Chihuahua', '(GMT-07:00) Chihuahua'),
(10, 'America/Mazatlan', '(GMT-07:00) Mazatlan'),
(11, 'America/Mexico_City', '(GMT-06:00) Mexico City'),
(12, 'America/Monterrey', '(GMT-06:00) Monterrey'),
(13, 'Canada/Saskatchewan', '(GMT-06:00) Saskatchewan'),
(14, 'US/Central', '(GMT-06:00) Central Time (US &amp; Canada)'),
(15, 'US/Eastern', '(GMT-05:00) Eastern Time (US &amp; Canada)'),
(16, 'US/East-Indiana', '(GMT-05:00) Indiana (East)'),
(17, 'America/Bogota', '(GMT-05:00) Bogota'),
(18, 'America/Lima', '(GMT-05:00) Lima'),
(19, 'America/Caracas', '(GMT-04:30) Caracas'),
(20, 'Canada/Atlantic', '(GMT-04:00) Atlantic Time (Canada)'),
(21, 'America/La_Paz', '(GMT-04:00) La Paz'),
(22, 'America/Santiago', '(GMT-04:00) Santiago'),
(23, 'Canada/Newfoundland', '(GMT-03:30) Newfoundland'),
(24, 'America/Buenos_Aires', '(GMT-03:00) Buenos Aires'),
(25, 'America/Godthab', '(GMT-03:00) Greenland'),
(26, 'Atlantic/Stanley', '(GMT-02:00) Stanley'),
(27, 'Atlantic/Azores', '(GMT-01:00) Azores'),
(28, 'Atlantic/Cape_Verde', '(GMT-01:00) Cape Verde Is.'),
(29, 'Africa/Casablanca', '(GMT) Casablanca'),
(30, 'Europe/Dublin', '(GMT) Dublin'),
(31, 'Europe/Lisbon', '(GMT) Lisbon'),
(32, 'Europe/London', '(GMT) London'),
(33, 'Africa/Monrovia', '(GMT) Monrovia'),
(34, 'Europe/Amsterdam', '(GMT+01:00) Amsterdam'),
(35, 'Europe/Belgrade', '(GMT+01:00) Belgrade'),
(36, 'Europe/Berlin', '(GMT+01:00) Berlin'),
(37, 'Europe/Bratislava', '(GMT+01:00) Bratislava'),
(38, 'Europe/Brussels', '(GMT+01:00) Brussels'),
(39, 'Europe/Budapest', '(GMT+01:00) Budapest'),
(40, 'Europe/Copenhagen', '(GMT+01:00) Copenhagen'),
(41, 'Europe/Ljubljana', '(GMT+01:00) Ljubljana'),
(42, 'Europe/Madrid', '(GMT+01:00) Madrid'),
(43, 'Europe/Paris', '(GMT+01:00) Paris'),
(44, 'Europe/Prague', '(GMT+01:00) Prague'),
(45, 'Europe/Rome', '(GMT+01:00) Rome'),
(46, 'Europe/Sarajevo', '(GMT+01:00) Sarajevo'),
(47, 'Europe/Skopje', '(GMT+01:00) Skopje'),
(48, 'Europe/Stockholm', '(GMT+01:00) Stockholm'),
(49, 'Europe/Vienna', '(GMT+01:00) Vienna'),
(50, 'Europe/Warsaw', '(GMT+01:00) Warsaw'),
(51, 'Europe/Zagreb', '(GMT+01:00) Zagreb'),
(52, 'Europe/Athens', '(GMT+02:00) Athens'),
(53, 'Europe/Bucharest', '(GMT+02:00) Bucharest'),
(54, 'Africa/Cairo', '(GMT+02:00) Cairo'),
(55, 'Africa/Harare', '(GMT+02:00) Harare'),
(56, 'Europe/Helsinki', '(GMT+02:00) Helsinki'),
(57, 'Europe/Istanbul', '(GMT+02:00) Istanbul'),
(58, 'Asia/Jerusalem', '(GMT+02:00) Jerusalem'),
(59, 'Europe/Kiev', '(GMT+02:00) Kyiv'),
(60, 'Europe/Minsk', '(GMT+02:00) Minsk'),
(61, 'Europe/Riga', '(GMT+02:00) Riga'),
(62, 'Europe/Sofia', '(GMT+02:00) Sofia'),
(63, 'Europe/Tallinn', '(GMT+02:00) Tallinn'),
(64, 'Europe/Vilnius', '(GMT+02:00) Vilnius'),
(65, 'Asia/Baghdad', '(GMT+03:00) Baghdad'),
(66, 'Asia/Kuwait', '(GMT+03:00) Kuwait'),
(67, 'Africa/Nairobi', '(GMT+03:00) Nairobi'),
(68, 'Asia/Riyadh', '(GMT+03:00) Riyadh'),
(69, 'Asia/Tehran', '(GMT+03:30) Tehran'),
(70, 'Europe/Moscow', '(GMT+04:00) Moscow'),
(71, 'Asia/Baku', '(GMT+04:00) Baku'),
(72, 'Europe/Volgograd', '(GMT+04:00) Volgograd'),
(73, 'Asia/Muscat', '(GMT+04:00) Muscat'),
(74, 'Asia/Tbilisi', '(GMT+04:00) Tbilisi'),
(75, 'Asia/Yerevan', '(GMT+04:00) Yerevan'),
(76, 'Asia/Kabul', '(GMT+04:30) Kabul'),
(77, 'Asia/Karachi', '(GMT+05:00) Karachi'),
(78, 'Asia/Tashkent', '(GMT+05:00) Tashkent'),
(79, 'Asia/Kolkata', '(GMT+05:30) Kolkata'),
(80, 'Asia/Kathmandu', '(GMT+05:45) Kathmandu'),
(81, 'Asia/Yekaterinburg', '(GMT+06:00) Ekaterinburg'),
(82, 'Asia/Almaty', '(GMT+06:00) Almaty'),
(83, 'Asia/Dhaka', '(GMT+06:00) Dhaka'),
(84, 'Asia/Novosibirsk', '(GMT+07:00) Novosibirsk'),
(85, 'Asia/Bangkok', '(GMT+07:00) Bangkok'),
(86, 'Asia/Ho_Chi_Minh', '(GMT+07.00) Ho Chi Minh'),
(87, 'Asia/Jakarta', '(GMT+07:00) Jakarta'),
(88, 'Asia/Krasnoyarsk', '(GMT+08:00) Krasnoyarsk'),
(89, 'Asia/Chongqing', '(GMT+08:00) Chongqing'),
(90, 'Asia/Hong_Kong', '(GMT+08:00) Hong Kong'),
(91, 'Asia/Kuala_Lumpur', '(GMT+08:00) Kuala Lumpur'),
(92, 'Australia/Perth', '(GMT+08:00) Perth'),
(93, 'Asia/Singapore', '(GMT+08:00) Singapore'),
(94, 'Asia/Taipei', '(GMT+08:00) Taipei'),
(95, 'Asia/Ulaanbaatar', '(GMT+08:00) Ulaan Bataar'),
(96, 'Asia/Urumqi', '(GMT+08:00) Urumqi'),
(97, 'Asia/Irkutsk', '(GMT+09:00) Irkutsk'),
(98, 'Asia/Seoul', '(GMT+09:00) Seoul'),
(99, 'Asia/Tokyo', '(GMT+09:00) Tokyo'),
(100, 'Australia/Adelaide', '(GMT+09:30) Adelaide'),
(101, 'Australia/Darwin', '(GMT+09:30) Darwin'),
(102, 'Asia/Yakutsk', '(GMT+10:00) Yakutsk'),
(103, 'Australia/Brisbane', '(GMT+10:00) Brisbane'),
(104, 'Australia/Canberra', '(GMT+10:00) Canberra'),
(105, 'Pacific/Guam', '(GMT+10:00) Guam'),
(106, 'Australia/Hobart', '(GMT+10:00) Hobart'),
(107, 'Australia/Melbourne', '(GMT+10:00) Melbourne'),
(108, 'Pacific/Port_Moresby', '(GMT+10:00) Port Moresby'),
(109, 'Australia/Sydney', '(GMT+10:00) Sydney'),
(110, 'Asia/Vladivostok', '(GMT+11:00) Vladivostok'),
(111, 'Asia/Magadan', '(GMT+12:00) Magadan'),
(112, 'Pacific/Auckland', '(GMT+12:00) Auckland'),
(113, 'Pacific/Fiji', '(GMT+12:00) Fiji');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `confirmation_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `registered` tinyint(1) NOT NULL DEFAULT 0,
  `confirmed` tinyint(1) NOT NULL DEFAULT 0,
  `notify_sent` tinyint(1) NOT NULL DEFAULT 1,
  `notify_viewed` tinyint(1) NOT NULL DEFAULT 0,
  `notify_paid` tinyint(1) NOT NULL DEFAULT 1,
  `public_id` int(10) unsigned DEFAULT NULL,
  `force_pdfjs` tinyint(1) NOT NULL DEFAULT 0,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `news_feed_id` int(10) unsigned DEFAULT NULL,
  `notify_approved` tinyint(1) NOT NULL DEFAULT 1,
  `failed_logins` smallint(6) DEFAULT NULL,
  `dark_mode` tinyint(1) DEFAULT 1,
  `referral_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oauth_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oauth_provider_id` int(10) unsigned DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 1,
  `bot_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `google_2fa_secret` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_2fa_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slack_webhook_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accepted_terms_version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accepted_terms_timestamp` timestamp NULL DEFAULT NULL,
  `accepted_terms_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `only_notify_owned` tinyint(1) DEFAULT 0,
  `permissions` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_account_id_public_id_unique` (`account_id`,`public_id`),
  UNIQUE KEY `users_oauth_user_id_oauth_provider_id_unique` (`oauth_user_id`,`oauth_provider_id`),
  KEY `users_account_id_index` (`account_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES
(1, 1, '2020-06-17 08:14:41', '2020-08-10 16:07:44', NULL, 'Alex', 'Ramos', '', 'alex@myarconnect.com', 'alex@myarconnect.com', '$2y$10$JVd1QXKug1u28kDbtNV9dOh.4LvublIye4JgY0GJWA/t60JAVWglm', NULL, 1, 1, 1, 1, 1, NULL, 0, 'npS8y4iswyIUIbOxjxOW6SULNFimDfF6VvenC9LyJvxg9Kg1bL1wp79lFf5w', NULL, 1, 0, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, '', '1.0.1', '2020-06-17 08:14:41', '104.58.208.199', 0, ''),
(2, 1, '2020-06-17 16:25:26', '2020-06-18 20:19:47', NULL, 'Rheina', 'Bato', NULL, 'rheina@myarconnect.com', 'rheina@myarconnect.com', '$2y$10$wEJeTka1Dw0ECZDDFFgGmOzyTAXGgB4qjaSHXLxBCuNXFHaRAwShO', NULL, 1, 1, 1, 0, 1, 1, 0, 'W61kfPPA5xXeo5kTBUe7WKqYLMOd7aV7ejE2KFLuQp2ynF0iKrdFZy4aC6eo', NULL, 1, 0, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '1.0.1', '2020-06-18 20:19:47', '110.54.232.83', 0, '["create_client","view_client","edit_client","create_credit","view_credit","edit_credit","create_expense","view_expense","edit_expense","create_invoice","view_invoice","edit_invoice","create_payment","view_payment","edit_payment","create_product","view_product","edit_product","create_project","view_project","edit_project","create_proposal","view_proposal","edit_proposal","create_quote","view_quote","edit_quote","create_reports","view_reports","edit_reports","create_task","view_task","edit_task","create_vendor","view_vendor","edit_vendor","create_recurring_invoice","view_recurring_invoice","edit_recurring_invoice","view_contact","edit_contact","create_contact"]'),
(3, 1, '2020-06-19 14:52:10', '2020-08-14 14:28:54', NULL, 'Sharly', 'Ponce', NULL, 'sharlymaineponce@yahoo.com', 'sharlymaineponce@yahoo.com', '$2y$10$Jo1K/UjkU.rCcz1pc2lUR.DsegV/LrfHyzyhnjYE1lqUlvVQGGUqC', NULL, 1, 1, 1, 0, 1, 2, 0, 'DjEpYujiAtXLPF4BIlfWuu18zu01WlaVUnVm9DnnvuKCBHrynhFucX7YB4Ap', NULL, 1, 0, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '1.0.1', '2020-06-19 16:01:13', '110.54.193.61', 0, '{"0":"create_client","1":"view_client","2":"edit_client","18":"create_project","19":"view_project","20":"edit_project","30":"create_task","31":"view_task","32":"edit_task","39":"view_contact","40":"edit_contact","41":"create_contact"}'),
(4, 1, '2020-06-19 14:53:44', '2020-06-23 16:33:49', NULL, 'Eubert', 'Lumangtad', NULL, 'eukriz12421@gmail.com', 'eukriz12421@gmail.com', '$2y$10$JV5qH0BXuSeYp/UKH6vaLe2WnWX4Bn18u4kLEZNU/g2MXFhH/6.iy', NULL, 1, 1, 1, 0, 1, 3, 0, 'NwBUjHHqDmG2H5x5GEYW64lvPUQoaK3TJ9lfn9uUzoBT9AntSgK5qwej7acc', NULL, 1, 0, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '1.0.1', '2020-06-19 15:32:00', '180.190.198.29', 0, '{"1":"view_client","18":"create_project","19":"view_project","20":"edit_project","30":"create_task","31":"view_task","39":"view_contact"}'),
(5, 1, '2020-06-23 15:39:22', '2020-06-23 16:32:55', '2020-06-23 16:32:55', 'Anne', 'Pek', NULL, 'rheinabato@gmail.com', 'rheinabato@gmail.com', '$2y$10$i6mXyOlXGP3301o3Fad7GejMw05FBXVnIsFvV57V.3hspDtwIjANK', NULL, 1, 1, 1, 0, 1, 4, 0, 'pUV9XSGfEprnoD74i64c1DrHg1ByIYwrFdmKsRdZwKrlqJ0gRhwChoq9lT9h', NULL, 1, 0, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '1.0.1', '2020-06-23 15:42:26', '110.54.234.28', 0, '{"1":"view_client","19":"view_project","20":"edit_project","30":"create_task","31":"view_task","32":"edit_task","39":"view_contact"}'),
(6, 1, '2020-07-11 01:54:39', '2020-07-22 15:53:10', '2020-07-22 15:53:10', 'Sarah', 'Gallardo', NULL, 'sarahtoretto04@gmail.com', 'sarahtoretto04@gmail.com', 'c7bzgemkfw8455zhzu6mkbjmyx1k3obg', NULL, 1, 1, 1, 0, 1, 5, 0, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '{"1":"view_client","2":"edit_client","18":"create_project","19":"view_project","20":"edit_project","30":"create_task","31":"view_task","32":"edit_task","39":"view_contact","40":"edit_contact"}'),
(7, 1, '2020-07-24 13:02:44', '2020-07-24 13:45:42', NULL, 'Linneth', 'Agbuya', NULL, 'linneth02211228@gmail.com', 'linneth02211228@gmail.com', '$2y$10$3P0LZh2rMQYP1M5/zp0fA.kW9phOj4/A3dYmOCnToaKKEyNqla5Z6', NULL, 1, 1, 1, 0, 1, 6, 0, 'AszgHc6NU0R1ogcIhYR5DRe60AJ6MuINMvYUzM2XEzaEwVxsN2wM8ch6jQXc', NULL, 1, 0, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '1.0.1', '2020-07-24 13:45:42', '175.176.21.70', 0, '{"0":"create_client","1":"view_client","2":"edit_client","18":"create_project","19":"view_project","20":"edit_project","30":"create_task","31":"view_task","32":"edit_task","39":"view_contact","40":"edit_contact","41":"create_contact"}');

-- --------------------------------------------------------

--
-- Table structure for table `user_accounts`
--

CREATE TABLE `user_accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id1` int(10) unsigned DEFAULT NULL,
  `user_id2` int(10) unsigned DEFAULT NULL,
  `user_id3` int(10) unsigned DEFAULT NULL,
  `user_id4` int(10) unsigned DEFAULT NULL,
  `user_id5` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_accounts_user_id1_index` (`user_id1`),
  KEY `user_accounts_user_id2_index` (`user_id2`),
  KEY `user_accounts_user_id3_index` (`user_id3`),
  KEY `user_accounts_user_id4_index` (`user_id4`),
  KEY `user_accounts_user_id5_index` (`user_id5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `postal_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` int(10) unsigned DEFAULT NULL,
  `work_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `private_notes` text COLLATE utf8_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `public_id` int(11) NOT NULL DEFAULT 0,
  `vat_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_value1` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_value2` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vendors_account_id_foreign` (`account_id`),
  KEY `vendors_user_id_foreign` (`user_id`),
  KEY `vendors_country_id_foreign` (`country_id`),
  KEY `vendors_currency_id_foreign` (`currency_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `vendor_contacts`
--

CREATE TABLE `vendor_contacts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `vendor_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `public_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vendor_contacts_account_id_public_id_unique` (`account_id`,`public_id`),
  KEY `vendor_contacts_user_id_foreign` (`user_id`),
  KEY `vendor_contacts_vendor_id_index` (`vendor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Constraints for table `accounts`
--
ALTER TABLE `accounts`
  ADD CONSTRAINT `accounts_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `accounts_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `accounts_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `accounts_date_format_id_foreign` FOREIGN KEY (`date_format_id`) REFERENCES `date_formats` (`id`),
  ADD CONSTRAINT `accounts_datetime_format_id_foreign` FOREIGN KEY (`datetime_format_id`) REFERENCES `datetime_formats` (`id`),
  ADD CONSTRAINT `accounts_industry_id_foreign` FOREIGN KEY (`industry_id`) REFERENCES `industries` (`id`),
  ADD CONSTRAINT `accounts_invoice_design_id_foreign` FOREIGN KEY (`invoice_design_id`) REFERENCES `invoice_designs` (`id`),
  ADD CONSTRAINT `accounts_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
  ADD CONSTRAINT `accounts_size_id_foreign` FOREIGN KEY (`size_id`) REFERENCES `sizes` (`id`),
  ADD CONSTRAINT `accounts_timezone_id_foreign` FOREIGN KEY (`timezone_id`) REFERENCES `timezones` (`id`);

--
-- Constraints for table `account_email_settings`
--
ALTER TABLE `account_email_settings`
  ADD CONSTRAINT `account_email_settings_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_gateways`
--
ALTER TABLE `account_gateways`
  ADD CONSTRAINT `account_gateways_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_gateways_gateway_id_foreign` FOREIGN KEY (`gateway_id`) REFERENCES `gateways` (`id`),
  ADD CONSTRAINT `account_gateways_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_gateway_settings`
--
ALTER TABLE `account_gateway_settings`
  ADD CONSTRAINT `account_gateway_settings_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_gateway_settings_gateway_type_id_foreign` FOREIGN KEY (`gateway_type_id`) REFERENCES `gateway_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_gateway_settings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_gateway_tokens`
--
ALTER TABLE `account_gateway_tokens`
  ADD CONSTRAINT `account_gateway_tokens_account_gateway_id_foreign` FOREIGN KEY (`account_gateway_id`) REFERENCES `account_gateways` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_gateway_tokens_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_gateway_tokens_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_gateway_tokens_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_gateway_tokens_default_payment_method_id_foreign` FOREIGN KEY (`default_payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_tokens`
--
ALTER TABLE `account_tokens`
  ADD CONSTRAINT `account_tokens_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `activities`
--
ALTER TABLE `activities`
  ADD CONSTRAINT `activities_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `activities_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bank_accounts`
--
ALTER TABLE `bank_accounts`
  ADD CONSTRAINT `bank_accounts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bank_accounts_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`),
  ADD CONSTRAINT `bank_accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bank_subaccounts`
--
ALTER TABLE `bank_subaccounts`
  ADD CONSTRAINT `bank_subaccounts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bank_subaccounts_bank_account_id_foreign` FOREIGN KEY (`bank_account_id`) REFERENCES `bank_accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bank_subaccounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `clients`
--
ALTER TABLE `clients`
  ADD CONSTRAINT `clients_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `clients_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `clients_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `clients_industry_id_foreign` FOREIGN KEY (`industry_id`) REFERENCES `industries` (`id`),
  ADD CONSTRAINT `clients_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
  ADD CONSTRAINT `clients_shipping_country_id_foreign` FOREIGN KEY (`shipping_country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `clients_size_id_foreign` FOREIGN KEY (`size_id`) REFERENCES `sizes` (`id`),
  ADD CONSTRAINT `clients_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `contacts`
--
ALTER TABLE `contacts`
  ADD CONSTRAINT `contacts_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contacts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `credits`
--
ALTER TABLE `credits`
  ADD CONSTRAINT `credits_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `credits_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `credits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `documents`
--
ALTER TABLE `documents`
  ADD CONSTRAINT `documents_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `documents_expense_id_foreign` FOREIGN KEY (`expense_id`) REFERENCES `expenses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `documents_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `documents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `expenses`
--
ALTER TABLE `expenses`
  ADD CONSTRAINT `expenses_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_expense_category_id_foreign` FOREIGN KEY (`expense_category_id`) REFERENCES `expense_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_expense_currency_id_foreign` FOREIGN KEY (`expense_currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `expenses_invoice_currency_id_foreign` FOREIGN KEY (`invoice_currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `expenses_payment_type_id_foreign` FOREIGN KEY (`payment_type_id`) REFERENCES `payment_types` (`id`),
  ADD CONSTRAINT `expenses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `expense_categories`
--
ALTER TABLE `expense_categories`
  ADD CONSTRAINT `expense_categories_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expense_categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `gateways`
--
ALTER TABLE `gateways`
  ADD CONSTRAINT `gateways_payment_library_id_foreign` FOREIGN KEY (`payment_library_id`) REFERENCES `payment_libraries` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invitations`
--
ALTER TABLE `invitations`
  ADD CONSTRAINT `invitations_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invitations_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invitations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invoices_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invoices_invoice_design_id_foreign` FOREIGN KEY (`invoice_design_id`) REFERENCES `invoice_designs` (`id`),
  ADD CONSTRAINT `invoices_invoice_status_id_foreign` FOREIGN KEY (`invoice_status_id`) REFERENCES `invoice_statuses` (`id`),
  ADD CONSTRAINT `invoices_recurring_invoice_id_foreign` FOREIGN KEY (`recurring_invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invoices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoice_items`
--
ALTER TABLE `invoice_items`
  ADD CONSTRAINT `invoice_items_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invoice_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invoice_items_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `licenses`
--
ALTER TABLE `licenses`
  ADD CONSTRAINT `licenses_affiliate_id_foreign` FOREIGN KEY (`affiliate_id`) REFERENCES `affiliates` (`id`);

--
-- Constraints for table `lookup_accounts`
--
ALTER TABLE `lookup_accounts`
  ADD CONSTRAINT `lookup_accounts_lookup_company_id_foreign` FOREIGN KEY (`lookup_company_id`) REFERENCES `lookup_companies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lookup_account_tokens`
--
ALTER TABLE `lookup_account_tokens`
  ADD CONSTRAINT `lookup_tokens_lookup_account_id_foreign` FOREIGN KEY (`lookup_account_id`) REFERENCES `lookup_accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lookup_companies`
--
ALTER TABLE `lookup_companies`
  ADD CONSTRAINT `lookup_companies_db_server_id_foreign` FOREIGN KEY (`db_server_id`) REFERENCES `db_servers` (`id`);

--
-- Constraints for table `lookup_contacts`
--
ALTER TABLE `lookup_contacts`
  ADD CONSTRAINT `lookup_contacts_lookup_account_id_foreign` FOREIGN KEY (`lookup_account_id`) REFERENCES `lookup_accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lookup_invitations`
--
ALTER TABLE `lookup_invitations`
  ADD CONSTRAINT `lookup_invitations_lookup_account_id_foreign` FOREIGN KEY (`lookup_account_id`) REFERENCES `lookup_accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lookup_proposal_invitations`
--
ALTER TABLE `lookup_proposal_invitations`
  ADD CONSTRAINT `lookup_proposal_invitations_lookup_account_id_foreign` FOREIGN KEY (`lookup_account_id`) REFERENCES `lookup_accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lookup_users`
--
ALTER TABLE `lookup_users`
  ADD CONSTRAINT `lookup_users_lookup_account_id_foreign` FOREIGN KEY (`lookup_account_id`) REFERENCES `lookup_accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_account_gateway_id_foreign` FOREIGN KEY (`account_gateway_id`) REFERENCES `account_gateways` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_payment_status_id_foreign` FOREIGN KEY (`payment_status_id`) REFERENCES `payment_statuses` (`id`),
  ADD CONSTRAINT `payments_payment_type_id_foreign` FOREIGN KEY (`payment_type_id`) REFERENCES `payment_types` (`id`),
  ADD CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD CONSTRAINT `payment_methods_account_gateway_token_id_foreign` FOREIGN KEY (`account_gateway_token_id`) REFERENCES `account_gateway_tokens` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payment_methods_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payment_methods_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payment_methods_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `payment_methods_payment_type_id_foreign` FOREIGN KEY (`payment_type_id`) REFERENCES `payment_types` (`id`),
  ADD CONSTRAINT `payment_methods_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_types`
--
ALTER TABLE `payment_types`
  ADD CONSTRAINT `payment_types_gateway_type_id_foreign` FOREIGN KEY (`gateway_type_id`) REFERENCES `gateway_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `projects_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `projects_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `projects_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `proposals`
--
ALTER TABLE `proposals`
  ADD CONSTRAINT `proposals_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposals_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposals_proposal_template_id_foreign` FOREIGN KEY (`proposal_template_id`) REFERENCES `proposal_templates` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `proposal_categories`
--
ALTER TABLE `proposal_categories`
  ADD CONSTRAINT `proposal_categories_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposal_categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `proposal_invitations`
--
ALTER TABLE `proposal_invitations`
  ADD CONSTRAINT `proposal_invitations_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposal_invitations_proposal_id_foreign` FOREIGN KEY (`proposal_id`) REFERENCES `proposals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposal_invitations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `proposal_snippets`
--
ALTER TABLE `proposal_snippets`
  ADD CONSTRAINT `proposal_snippets_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposal_snippets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `proposal_templates`
--
ALTER TABLE `proposal_templates`
  ADD CONSTRAINT `proposal_templates_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `proposal_templates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `recurring_expenses`
--
ALTER TABLE `recurring_expenses`
  ADD CONSTRAINT `recurring_expenses_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `recurring_expenses_expense_category_id_foreign` FOREIGN KEY (`expense_category_id`) REFERENCES `expense_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `recurring_expenses_expense_currency_id_foreign` FOREIGN KEY (`expense_currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `recurring_expenses_invoice_currency_id_foreign` FOREIGN KEY (`invoice_currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `recurring_expenses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `scheduled_reports`
--
ALTER TABLE `scheduled_reports`
  ADD CONSTRAINT `scheduled_reports_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `scheduled_reports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `security_codes`
--
ALTER TABLE `security_codes`
  ADD CONSTRAINT `security_codes_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `security_codes_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `security_codes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subscriptions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_task_status_id_foreign` FOREIGN KEY (`task_status_id`) REFERENCES `task_statuses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `task_statuses`
--
ALTER TABLE `task_statuses`
  ADD CONSTRAINT `task_statuses_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `task_statuses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tax_rates`
--
ALTER TABLE `tax_rates`
  ADD CONSTRAINT `tax_rates_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tax_rates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `vendors`
--
ALTER TABLE `vendors`
  ADD CONSTRAINT `vendors_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `vendors_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `vendors_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `vendors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `vendor_contacts`
--
ALTER TABLE `vendor_contacts`
  ADD CONSTRAINT `vendor_contacts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `vendor_contacts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `vendor_contacts_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

