-- Table structure for table `tbltwocheckout_log`
--

CREATE TABLE `tbltwocheckout_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(64) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `amount` varchar(25) NOT NULL,
  `created_at` datetime NOT NULL,
  `attempt_reference` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  CONSTRAINT `tbltwocheckout_log_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `tblinvoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbltwocheckout_log`
--


--
-- Table structure for table `tbluser_auto_login`
--

CREATE TABLE `tbluser_auto_login` (
  `key_id` char(32) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_agent` varchar(150) NOT NULL,
  `last_ip` varchar(40) NOT NULL,
  `last_login` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `staff` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbluser_auto_login`
--

INSERT INTO `tbluser_auto_login` VALUES ('9e48b4eb71d0122cf5f2363839d26fbd',2,'Mozilla/5.0 (Linux; Android 7.0; Nexus 6P Build/NBD90X) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.68 Mobile Safari/537.36','120.151.37.150','2016-11-03 09:35:05',1),('9fcbcf319fcd747dcefaaa07a1feed47',2,'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/M4B30X) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.85 Mobile Safari/537.36','120.151.37.150','2016-11-14 05:41:26',1),('d5a4c6b39bd4c1fdd0add54f2b1fb8e4',2,'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.71 Safari/537.36','120.151.37.150','2016-11-15 05:00:37',1),('f896ec7041d6fc808d1a27b02decfcaa',2,'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.71 Safari/537.36','120.151.37.150','2016-11-15 06:04:03',1),('7a860915f64cf2e9eb2d6835c1ae5c99',2,'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/M4B30X) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.85 Mobile Safari/537.36','49.199.118.155','2016-11-18 00:29:55',1),('791a2f5e332c5ff4dee310166c26e501',2,'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/M4B30X) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36','49.185.235.25','2017-01-05 01:03:07',1),('0512121409a443d239ddfe15967971b0',2,'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36','120.151.37.150','2017-01-05 01:07:26',1),('70a34cb79038142aeb92610da95b0514',2,'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36','120.151.37.150','2017-01-09 18:08:31',1),('e36841d0b858846547f219a69f455431',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36','103.226.160.202','2017-01-19 03:03:34',1),('4bd13013c8bdee4e5bc61358d4c7e3e2',2,'Mozilla/5.0 (Linux; Android 7.1.1; Nexus 5X Build/NMF26Q) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36','49.185.181.34','2017-01-23 00:53:37',1),('01a4f03477f29bb00f3054490a7c22b9',2,'Mozilla/5.0 (Linux; Android 7.1.1; Nexus 5X Build/N6F26Q) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Mobile Safari/537.36','202.161.76.200','2017-03-14 07:29:30',1),('f125c78584b249137dc36fa3fe941f01',2,'Mozilla/5.0 (Linux; Android 7.0; SM-P585Y Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.111 Safari/537.36','211.28.141.125','2017-12-29 21:50:16',1),('0189d4ea6ce0598ac1088b93a54f4e21',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.91 Safari/537.36','211.28.141.125','2017-09-20 06:58:14',1),('b1c62eb1f3b390efdee1a7fc0b321ac0',2,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36','211.28.141.125','2017-09-23 02:52:24',1),('dc2f036a8b186f760a633fb74e90b133',2,'Mozilla/5.0 (Linux; Android 7.0; MHA-L29 Build/HUAWEIMHA-L29) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.111 Mobile Safari/537.36','49.199.233.21','2018-01-18 09:27:59',1),('2ad4ce7801b40b167729997ae730e2c2',4,'Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.0 Mobile/15E148 Safari/604.1','1.136.105.12','2018-09-18 09:54:40',1),('403b250258b07df509df4f279ed09d60',4,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36','211.28.215.75','2018-10-20 23:21:00',1),('7f7b84885950b400150234b2f6ec37d9',2,'Mozilla/5.0 (Linux; Android 9; LYA-L29) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.105 Mobile Safari/537.36','49.183.57.172','2019-02-19 04:31:20',1),('dba9011a88b511b496eddc368b2dbcce',3,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36','49.199.226.56','2019-07-16 19:59:13',1),('ecd02cab37eb23a36543ccd981687779',66,'Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1','49.183.148.92','2019-11-19 23:56:30',0),('5ceaefa12d6dfb81c134a78ed7b28a48',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36','123.208.196.92','2020-02-28 10:29:27',1),('479beafef36f3e61f160e8bbc50099fc',2,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36','123.208.208.234','2020-07-05 03:37:55',1),('45bfd88c4e552cb2cdb4176957f082d9',2,'Mozilla/5.0 (Linux; Android 10; LYA-L29) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Mobile Safari/537.36','123.208.208.234','2020-07-16 09:40:06',1),('4dd068ca918ce18e3800254f579b0cca',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36','123.208.208.234','2020-07-16 10:40:00',1),('39a24e7bb4aa6ce9eb9c82b1bcdcbc84',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.193 Safari/537.36','123.208.208.234','2020-11-15 03:42:15',1),('a64b71cc7f03a45bccb0d89671ccf546',2,'Mozilla/5.0 (Linux; Android 10; SM-N986B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Mobile Safari/537.36','1.152.109.20','2021-01-17 21:36:02',1),('e680600d954713ae162515214aaf7885',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.192 Safari/537.36','123.208.208.234','2021-03-03 18:13:54',1),('8d5caa439082ca762ec58da4c1ace3e8',2,'Mozilla/5.0 (Linux; Android 11; SM-N986B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.105 Mobile Safari/537.36','2001:8004:2741:afeb:2660:9ca:5ffc:5bd6','2021-03-29 01:54:14',1),('c4ffef87873320f97b3ce18517803e2e',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36','123.208.208.234','2021-06-28 08:40:43',1),('ca4e41fd41d63d86385d348440688075',2,'Mozilla/5.0 (Linux; Android 11; LE2120) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.120 Mobile Safari/537.36','1.136.110.136','2021-07-18 23:52:50',1),('72574622f35641dce644ced8ed462ddc',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36','123.208.208.234','2021-08-01 05:39:02',1),('d5c3195d3975fcdda797ad08712c2033',2,'Mozilla/5.0 (Linux; Android 11; LE2120) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.104 Mobile Safari/537.36','1.145.163.58','2021-12-20 22:55:03',1),('e6c48b67d2a82fc787e9a6cfa4b9a685',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36','123.208.208.234','2022-04-03 05:50:54',1),('6991caf369d7ac13850cfa5e473f8785',2,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36','123.208.208.234','2022-05-23 11:27:18',1),('bb05ab7d9859ed8e2f0af8dccebd6404',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36','144.138.52.145','2022-07-22 04:07:24',1),('5bda802ba5baf0cdd06ec88d072783c2',4,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36','144.138.52.145','2022-10-12 10:09:28',1),('d863738f8fab2274a96b3e6440f1ea24',2,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','49.185.147.201','2023-02-02 08:09:59',1),('2009f6bc8f3732bd70b1843439080071',4,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36','49.185.71.81','2023-03-07 01:19:20',1),('c4cf69ecd3bac999a459f6ee9d299cf7',1,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36','2406:2d40:4128:8f10:9415:7829:f6f2:5922','2023-05-21 07:29:34',0),('7e713641e12c443c495c34d2c16746ce',2,'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36','2001:8004:1243:1fe5:98ee:b2ff:fe31:e274','2023-06-13 03:41:33',1),('998f9c97e3d842d2db93fd52d8bbb6c5',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36','2406:2d40:4128:8f10::6ef','2023-07-09 04:07:19',1),('e0ef00643624349ce1721e16e6f2d184',2,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36','206.83.122.172','2023-07-23 06:40:02',1),('53b28736db3abd102025cb2801ea840e',2,'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/119.0.6045.109 Mobile/15E148 Safari/604.1','65.181.14.220','2023-11-07 09:39:32',1),('c7bdf997433558bee5b11849a3928567',4,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','65.181.15.79','2024-03-19 02:42:55',1),('9b22ccd7c2bb887a34fb4a9a5c890931',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','2406:2d40:4128:8f10:d581:27c7:228a:470e','2024-04-09 08:43:27',1),('6ccb0785abb6fe602a08618bb2732e34',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','65.181.14.231','2025-01-12 05:00:23',1),('23717503c371ecba5d75a923d9585620',2,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','116.91.213.115','2025-07-03 08:34:55',1),('2039129b985948b041c467126824e0b3',2,'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36','116.91.213.115','2025-07-03 08:45:35',1),('7cfb8690a6b6772172e0e1b12d351d86',2,'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Mobile Safari/537.36','116.91.213.228','2025-12-15 19:02:16',1);

--
-- Table structure for table `tbluser_meta`
--

CREATE TABLE `tbluser_meta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `client_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `contact_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL,
  PRIMARY KEY (`umeta_id`)
) ENGINE=InnoDB AUTO_INCREMENT=192 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbluser_meta`
--

INSERT INTO `tbluser_meta` VALUES (1,1,0,0,'dashboard_widgets_order',NULL),(2,1,0,0,'dashboard_widgets_visibility',NULL),(3,2,0,0,'dashboard_widgets_order',NULL),(4,2,0,0,'dashboard_widgets_visibility',NULL),(5,3,0,0,'dashboard_widgets_order',NULL),(6,3,0,0,'dashboard_widgets_visibility',NULL),(8,0,0,9,'consent_key','3c9472f81cd743d364499ac14dafa2cc-936859ddd36c9db104498f7419c62dae'),(9,0,0,23,'consent_key','0470b25bfe413cf67c7aa4e5bf708c4d-4c0d868a1c9dd78ca932a52b03975209'),(10,0,0,26,'consent_key','ac982239aee7f7bba3da847bf08e04ff-cb686844bf2e9021bb184728ca01798c'),(11,0,0,42,'consent_key','9f8e219b86303b0efb2e5f3fa6578c95-cf6bd9bd9750c504a9c88513715a5e5b'),(12,0,0,43,'consent_key','8dd6b147e787799ac511b4298d76fe42-74c5d13281eb73d4ec3641be6155df1d'),(13,0,0,44,'consent_key','b192041b6fba1fda0f3994a076ac3c42-c9e4b09d6ebe022378fe9a59d3f58dbb'),(14,0,0,45,'consent_key','a429de2f1fdc887fec8e242c156d8c7a-658bb396548c8ba7c02d0db1685ea168'),(15,0,0,37,'consent_key','1af451769cffac4393bd1cb05fb1003b-706ad9fdae4a45febba51a4f7b1f747c'),(16,0,0,6,'consent_key','1336124290f456b809298eb776530880-840684975360bc2d9bce7e6607a0f996'),(17,0,0,46,'consent_key','3d530d7accccacd4285402381f134f88-32963e102424fcd1f2c5aae8a454101d'),(18,0,0,47,'consent_key','a1aab3553869eb6dd3ab16b5ee52b964-8fa94fc3509be24fa86edd4a62c65c61'),(19,0,0,48,'consent_key','fba0487ded2b5003f5e432d191150588-4f85971c3734e3fe7604998481c58ef8'),(20,0,0,49,'consent_key','764a4b7f1686706b84588fd85a19b82e-9c7757c4e715adcc137a2f0cc986e3e3'),(21,0,0,50,'consent_key','63ee4823dbc6c05cb5dacf276ac6207c-6e1802f3a292c8d81c168f91f4ba668b'),(22,0,0,51,'consent_key','af3524923e26e60a8728916a89672c5e-4f3f8f2fea4cc734a5c04601dbb3569e'),(23,0,0,52,'consent_key','e84729e6fc9b564c12daaaf9cffb4c49-4090588bdf4cf085a2e6ba463b985c8d'),(24,0,0,53,'consent_key','459d290af5dbb7914bec493e50b15e7d-2bd4fac22b5538b2084707e5526b60e6'),(25,0,0,54,'consent_key','b718f15110e9bcdfb459b8708508ca8e-f23e19e756da29b80834097cb5b15c8f'),(26,0,0,55,'consent_key','81be572dec1c7aac017ae2e7fbb5d5b3-aa999c566569f148128e41ef735b8819'),(27,0,0,56,'consent_key','2a22e82a798284c6dccb5b18f1c3d645-31dba6db348d7ea88e565b6933d2b0f4'),(28,0,0,58,'consent_key','88538267edb66b15d37901d803b8a7a5-1c05d8ca527eade2275717e9e45a5415'),(29,0,0,57,'consent_key','2693ffcdd1d1c6e338b509fc426abfab-0f39bd1ac701f01e35db1f68708dafee'),(30,0,0,59,'consent_key','435ac1d6aa22d464adb4af45c7d166ae-0e959737ff5eecc98a7f06ee9cdb5ce7'),(31,0,0,60,'consent_key','b47ead8887084b5be6c90e575c8de420-2beb0873a10100ec7c30be4d294ec39d'),(32,0,0,1,'consent_key','2f0cd9c6fdbd62c68be95de957e5bd7d-97a25071b73851f7e9ee17f81562daa2'),(33,0,0,61,'consent_key','17948e200e4428546a27213f1b48a3c8-648586f22fa43ee044fb0d97aad0fd28'),(34,0,0,62,'consent_key','2560414802b54ead05e5d8bacee7b4d9-5050d27a403b6062a943f99f45d9c2e6'),(35,2,0,0,'recent_searches','[\"momar\",\"tot\",\"finance\",\"admin\",\"3.\"]'),(36,0,0,63,'consent_key','57ea0542c34896be8b778b9e3f5d6d74-5fb8afabec091ace7168b5d515983308'),(37,0,0,64,'consent_key','48b0245c5ac16a1109363bac16e75dba-27eee90769b084060aac6b1f3cd92df7'),(38,0,0,65,'consent_key','13db95d6541bd757de7c1edc1e30a603-a3609debfe2291f941ee21c9ee0444e4'),(39,0,0,66,'consent_key','38e5691f3201906f311d9b28fe8ea8d4-15dc73e6bc1ff3d367e27f6635888229'),(40,0,0,14,'consent_key','e4e90bfde76ed67cae3caf0f15bacac6-87482510b08dcba9f076d9fccf3cee71'),(41,0,0,67,'consent_key','3fe8801165ff8e74b2f3d658c70f7465-37df229ccb7e27cc1c77b374a01b8663'),(42,0,0,68,'consent_key','5f2ff77e10ddd73d9d23aacdb52aa2c0-d3a3a22425f6a2f53fe0721fadb23248'),(43,3,0,0,'recent_searches','[\"veeken\"]'),(44,0,0,69,'consent_key','8152aad8b3a8aec037e9d52402c1120e-a4fb4062007c1fb3f0e72312b1d1c541'),(45,0,0,70,'consent_key','7857beb1e2495eb70c55e05fa8c89b0a-f70a3f117b39fce66e9ae60a74f5d6a8'),(46,0,0,71,'consent_key','ab4ca5ffe0af92cb83d388b33d67714c-5664a20065b928d3cce51154c86d94ab'),(47,0,0,72,'consent_key','fa032f70f228ef2cc42213a3db1224ad-4f76ff32c9f39a968f06af2c20489a3c'),(48,0,0,73,'consent_key','8e7b0cbda86b255f00065d786b9f26ec-059dc34989ee18abf050cb89f56b2618'),(49,0,0,74,'consent_key','9060a3f8480a0392d9538e00fb78fa25-d414c66556f26bf043a564984bddfa00'),(50,0,0,75,'consent_key','40f01088b294204d6e29d89c07b7b3a4-5b8278ba43075ffec97d4bb8e0a6f23d'),(51,0,0,76,'consent_key','319eca99612ab58d1fb97fdcbe05d487-1d8a7591dc1a4d656dcd100c040662ee'),(52,0,0,77,'consent_key','36024113de2d3d08db8b78566d4556a9-a16b49a650cb38803f8173ff29c2fbf0'),(53,0,0,78,'consent_key','e9991c2e969b29f115a774051e37a14a-5622aee9752e581cbc9d1cfc88acd865'),(54,0,0,79,'consent_key','d55b7b3ce4896d0b7ae74d051812f8e6-ca63382d3bb30bece5134d23cbe3ba86'),(55,0,0,39,'consent_key','49a0f27863e951debc7440cacf111a17-309a3f4eccb8964b28f1ecb0a4121b69'),(56,0,0,80,'consent_key','a6f7904d73998e5163081a6300523915-d3c80eb671c96e442cd1e408e30ab9e0'),(57,0,0,81,'consent_key','d06f32824e214bcb23efd9d91d60a1fa-28c69b550677636f6384a5b4a3ce944f'),(58,0,0,82,'consent_key','1c590a166239fc5b57e9dc64a9ddb3f2-068eb14063130c97822feee58591e99a'),(59,0,0,83,'consent_key','d36c6d6e82891b56828ee8871efd56f7-c3794e6d2d1f182b193cf6414c561760'),(60,0,0,84,'consent_key','0881a5cde6bde39a99db905ee244c0b2-2ba683c0359692ff33d73b69be56e2ba'),(61,0,0,85,'consent_key','dfadce1b79cd0c8caad51f8e3c68f2cc-853a2831e5998c749a490619d7ec0409'),(62,0,0,86,'consent_key','b83c424b072b486226d7f4399834a56a-60dae82dda3a3cdc7619d23524e1efea'),(63,0,0,87,'consent_key','2a5772c592339471123f1f46a67ad52e-e10c127bc4dfa1b3a0afe41d87c75c12'),(64,0,0,88,'consent_key','48e8440d904608d4a383c6c56a12d63a-5d4275f610dbe0ab56e3b327bd24238c'),(65,0,0,89,'consent_key','e9a0c4608a1429a59196cace2b5b0b59-fd8f9cfbcc926b2992c29f434b321903'),(66,0,0,91,'consent_key','e39e614adf3fbca2aa0f8a32bb512931-ebedeab28d5af0aa9f482c3a9c08de9b'),(67,0,0,92,'consent_key','53d91f70992be07fdf2b16b139f28309-b1aadc94b85e2c1ed9267d5ce24205bd'),(68,0,0,90,'consent_key','42718d2fd8351ef80732f38d86d00cff-0f00fa07e59508059214ef2b13163395'),(69,0,0,93,'consent_key','b29e6364234dcfd1b5804e358a7210ee-291cce5e137664c94355c39bf1ab4f37'),(70,0,0,94,'consent_key','e6fc287ae565f9bedea24535624e9af5-8345910f67e78ab8dd953fd23736d772'),(71,0,0,24,'consent_key','d38b3d11bb1d51576cfa14446cdf35f8-b243608b9b8064ab3e9c25b92ae70d5d'),(72,0,0,95,'consent_key','9e3ee4500efd07ee56d65a5888518b3f-d54fd977ea45d0767d6e7d6efb02894d'),(73,0,0,96,'consent_key','ea21d5ffdd2a2b431b4c01195a51254b-a53ed369cfede4fe022d7a0c894bfe19'),(74,0,0,97,'consent_key','ecbabfd2d4d117986739d3ad25766ad9-e9047bcf13c7111fd4f1b83257a9372c'),(75,0,0,98,'consent_key','5d58737eefea654f9a29d35c9cbbc112-39fd0a3c4fcaaf4061e7a4769f6e0da1'),(77,0,0,100,'consent_key','cefa487409f65ced41b2c2456628d674-6560e886e521a77da9de8c0274c46872'),(78,0,0,101,'consent_key','a2d06585dd0834a2b3e57b95cfaf43d7-714df90ce2bab2d5a17cdbacc12b0fc2'),(79,0,0,102,'consent_key','5b68bf639751c1d48af9f7479fe6b922-68bf4ee3ffaf8c62c1f310b3d96df93d'),(80,0,0,103,'consent_key','f9d73231e144d05e6985c10c6aff622f-17279101c9e2ea7be929b8bb3f3061f9'),(81,0,0,104,'consent_key','92177069021147e8d109de272a31bbde-891b9a733c4eaa6d41634c6febf363b2'),(82,0,0,12,'consent_key','85114913baf8c7de4770320f6cd5f8cf-0ed3cdb480328d10930a16396b86fc36'),(83,0,0,105,'consent_key','40abf61ed078c3ed892f90bfeeb959ec-d6f745258d7fa46649e030f5ec55059a'),(84,0,0,106,'consent_key','cfffb79a902227b84f2a02b216575c1f-e23c7a191576f3a04426d8c970888c17'),(85,0,0,108,'consent_key','bf6ebfb1c86cf62b8e726fac06236f89-83c29461d2d74c65d6495f6f4a8ce2a6'),(86,0,0,109,'consent_key','30d0cd78d9deb3c00acc677bb93b81a5-446cce67e9a53fd0d60b21e61dc51272'),(87,0,0,110,'consent_key','1246916daf694ca957be67dba824b27d-8b89cbd61e08d0af542a4c584cf0bd7b'),(88,0,0,111,'consent_key','4be23fc7ddaab4865dccf9cf3062fd56-4b60645d0d9d61d6081593ee1afe77a8'),(89,0,0,107,'consent_key','8282cb96d448fc9d5245f7c53b4c401a-d6ad76a64ef6162cb37ccc9deb729ac3'),(90,0,0,112,'consent_key','46cd02ac1a6f30e4000d44fd47b5e199-b9635c59ff65f4631b65bc6303494c08'),(91,0,0,16,'consent_key','59ad01aa3c9b50844f593a53508a8739-439ccb5a96cab47234059ebc29e7eaaa'),(92,0,0,113,'consent_key','cf732789572482aa3ec12fe573b94497-5d6cab6a5ea40fd841d9c0fc8b0dbc77'),(93,0,0,114,'consent_key','22e911c188a98f5cfb35f7201197e559-4f568719bcf78609e0312306a6bdf717'),(94,0,0,115,'consent_key','7eb436b2d34f09b34c1ded885272d6a7-6f2d47d1c240ea518a80515a9f29ff5a'),(95,0,0,116,'consent_key','a6953297c402182d445e7c95ead46495-39682b71e94271f853b5db0691693346'),(96,0,0,117,'consent_key','dc55c8a2c8db45f28503763fea0944d2-cfd9f740d0dc3c6f08d2367317215d9f'),(97,0,0,118,'consent_key','636c6b6997b2086a6f3561a4d273dec4-bfc3a9ad24d2f1a7c8508deeffb42016'),(98,0,0,119,'consent_key','79ae21fda3bb378d36db9f03c05a5eca-76a21ee85807be71b88564d1897d446f'),(99,0,0,120,'consent_key','d765bc2e5d04bab69eb1608aa4f4b019-520fa4e689415bd835c5946244b437b9'),(100,0,0,121,'consent_key','c24b409c6f7f05d8a5007208c8e80d2e-d4e9582a05398b16adbc468892b2b415'),(101,0,0,122,'consent_key','5e48066e1160adda16b2a607c6952264-81a37b96d37bf51f9a3a606b876875c8'),(102,0,0,123,'consent_key','b61c9db2a48a5bdf8ed727729ecaa939-4a34785be9df4d30972b08488fc33871'),(103,0,0,124,'consent_key','1b76f1b4fb873cbff9209dd5fdc90396-1b483c07d6741514269ee2351f46d5b0'),(104,0,0,125,'consent_key','98d1e404ec7b59840d0e3e22eda75e02-fb48dfe9094d9a9bdaf23b270141c829'),(105,0,0,126,'consent_key','03c7621d6e3c10cf013090f6a4e60927-c978b05c430a556a6fe6767ce304c775'),(106,0,0,127,'consent_key','763dad504243f3fa16d4174f9a4d2569-7f56d9e643091fe567a5ae77099720d4'),(107,0,0,128,'consent_key','381da7fd281aac53fbae9e8cb51cd6b1-e0e37a1d92ff6aab1a880715f57d7ece'),(108,0,0,129,'consent_key','677ee6ac807bf7afe1c46e6ab29f93cb-fb7de973097c96d852fb2efd130aedbd'),(109,0,0,130,'consent_key','b2c2d939ce25a377c58275da2a7c7704-1a21feb22dfe0ffb5ba94d37815ec6df'),(110,0,0,131,'consent_key','7cb2ffeeb7f58b8ef3592cc4daa94611-17233e70c623593cd9b27cb6e501990d'),(112,0,0,133,'consent_key','494b1eb981eaa72708f9364babfd2a65-ffd8d13b1cbef196d19db06da5638a3d'),(113,0,0,134,'consent_key','a7d4506c7fbc1b572c16deda74853cb7-20806859721d31195801884020508bc2'),(114,4,0,0,'recent_searches','[\"Keyton\",\"mt\",\"2963\",\"296\",\"Kangan\"]'),(115,0,0,137,'consent_key','c107055ed14db217964d4ae3f1d21be1-bd28b5d2486cac8d5571c23df1210603'),(116,0,0,136,'consent_key','ba444f776a9937fcfcd844dcf98d2617-8b4e87d64303993c3082cf606dda4054'),(117,0,0,135,'consent_key','4a5a7d00c25d2ae5a4f9b5c2d93ef142-b7596c1cb9f32876f9c61269072ffff2'),(119,0,0,140,'consent_key','ca354ce18483cbd958e902b5ad6edcae-07a097988b2fc29f43940d325fe2944e'),(120,0,0,141,'consent_key','f2c6e7ac471b42133ba75cc6b991abd6-6e9a04bbfa0957b4bd96f7bdf7c1e25a'),(121,0,0,142,'consent_key','03e3c6b19c4a8c3bd990bfc3e15acd33-26de41bebfbdb9f34fed019836cfd917'),(122,0,0,143,'consent_key','2dde780a153deceee87590c3f5317abb-42bc6abbd71b8b6f73a10ad092ec9c20'),(123,0,0,145,'consent_key','a4bf5e6cec17a4637f6d9b8477bab621-06e66b010d03419c7ea8ed9ebdb931b4'),(124,0,0,146,'consent_key','099a1d6953990bad8ef7887b88d34323-6a9578e2068a13818bb3333c2fe3a957'),(125,0,0,147,'consent_key','600834895bdbd2283adb9a00966fe15f-bc7df640547f6107373d825a0ac72bf7'),(126,0,0,148,'consent_key','0e9653ecb9600c29f81e31459f6b627f-e6e7b0f34e556a7120109adf763d90f6'),(127,0,0,144,'consent_key','c5be7e1e3ba3afacddb8fa0cf5443f68-4a23b7f1eb011c10f7a8943685c127e6'),(128,0,0,150,'consent_key','e1fdc30f5120560a2294067bda2d2458-15b5d6d93e7264ef65dd4d3843563286'),(129,0,0,151,'consent_key','77e4fa65c7b3038893938cbb7ea9aa9f-7f993f01a9be67edbfc1954abe886e46'),(130,0,0,149,'consent_key','d6fe3a8e99b16eb8899e82ae72c2d28a-42c54bdbff134386e71e20fab03bd7ca'),(131,0,0,152,'consent_key','7ac498b4c3ee646850a031c2523b3cf0-bb1fdc921b6fc9a8e8feddbdee3e8be4'),(132,0,0,154,'consent_key','46d3bdcd20575d0c157541900c06520a-45e0d58114c5825493bbfa3684f1ebbd'),(133,0,0,153,'consent_key','1cd605fa614200201204f77b90027218-0bd58f688b8c7e3f1af11abd0a29fefd'),(134,0,0,155,'consent_key','95a549e471816bf665d39bf82e7a26c5-da6b5ae01475efa80d68a7875dceba53'),(135,0,0,156,'consent_key','135752f403e7ae56ee8931336ebb703e-824db1a5a7580f558378c3b3394134b9'),(136,0,0,157,'consent_key','56b962262faaf08635475dca7f33f4b9-66f0f94ec3664d8b5f4d1eeb5a3e2155'),(137,0,0,158,'consent_key','501d55e0b1d960697ebd22db254a06fd-e885df78c98b69f5d5299aa844b85e7a'),(138,0,0,159,'consent_key','460164612b16dceee68396e1565f3d39-444f74ca527ff20f28709fdf420b91ee'),(139,0,0,160,'consent_key','3857c1e44f059809e4dbdb097c216585-b8a3c3749b98eccfa241b85d8860760f'),(140,0,0,161,'consent_key','db72f3e4ec1ca7fb9093abeeaab7ccce-d732cecf86eb809dcd403099633a0e7c'),(141,0,0,162,'consent_key','b7fa83ef5dc1a601a7d8e9c39c1edb44-9afc326c403ff2ada3adc7c17181c2d7'),(142,0,0,163,'consent_key','74be4fcc948f0dc12475aed8de0773cf-7a4f0aa15d277674b26c532ab08fba4c'),(143,0,0,164,'consent_key','514539cfdbd726478348e8b458481294-4fcdea23517a2a8a6836ec3f83d23b4e'),(144,0,0,165,'consent_key','9c7de6c664b3317280ba231b4288238e-3595485b08d642f3062dd664b44ed44d'),(145,0,0,166,'consent_key','b272849f814baa70a3a50077fc19bd71-3dd4d57a67f756b891a698519895e7bc'),(146,0,0,167,'consent_key','be62f74217523ec3536acb256397afdd-3d5b2a5a8052aacd20ac42019541a10d'),(147,0,0,168,'consent_key','e4dd84bbf1c9c2f4f9b2408fc53ffc5f-caf97f14d7426f957055ab308ae85038'),(148,0,0,169,'consent_key','2c5eb8a16685228ec6acf1b521dc45c2-575f43614ee0e6d8946dd657a4e4ee9f'),(149,0,0,171,'consent_key','bbd8f4949943e421beec511636b53158-ae718d7673df1db983bee3bce66a77d0'),(150,0,0,172,'consent_key','edd4347231f19b72e9351e6b69dcd5ec-1236037121acc3204e2944b1510a2b1b'),(151,0,0,173,'consent_key','8972b25c17e688a2be2cbebff017242a-6b0eda06d8c8e6dc733150423e06fc7a'),(152,0,0,170,'consent_key','63cbbbb033abb34acb42465f95702070-7077e33863aed221d8c366d2a4b160f6'),(153,0,0,174,'consent_key','a247130125809c0569bcaf7eb59d318a-cd39bc7b9d70fcd0d25bc98921f600f9'),(154,0,0,175,'consent_key','7eb507f9d056a4614216fe72e44f0633-5172373d6161e7360fe332d1f6062c83'),(155,0,0,176,'consent_key','3c92e94401237d9d13553cf77794ed93-a41b86d138d10d0821441a39c72961a7'),(156,0,0,177,'consent_key','4099118eef68f5bc1b8749feedfb273c-02da8c1ed54697d04acb5a1c96ef4830'),(157,0,0,178,'consent_key','9f27d0075b1cb0c2f62f96c0341b5fb3-dcd418ea92a346c422dacd5342200e16'),(158,0,0,180,'consent_key','3baa2490d648909019335e5490f91add-be75fba4a7dfced3217878e4b8939082'),(159,0,0,181,'consent_key','b3607e5ecec21affbff08a9d3d3138b5-4bfcf3360f189bb2a5f08d73ffb4a1d5'),(160,0,0,182,'consent_key','44888429ecba64972deb3d125a22c0da-04a995536b4efdef00856cfbb15fb38e'),(161,0,0,179,'consent_key','eaea8507dc3d0163956659e3e75c1d92-6790221da1afac6b37b285b60ff71907'),(162,0,0,183,'consent_key','67ad951c7a955ba31cfd9bcdf9b35825-17f68faf25ff9ae8aa4d8c7cf257e4e8'),(163,0,0,184,'consent_key','26defed0d9ab57af3cdd092d202da1a0-4dac5f1d97ec2b9d639990c03577b1b5'),(164,0,0,185,'consent_key','587c4e2fa9487f203985edc71232b2d8-f97afedf5d13b26d50b5cf45316879d3'),(165,0,0,186,'consent_key','2752d7df8d5bf428f9e1501a54cce3f3-564165e1ad11372ed7a6f97529509fb6'),(166,0,0,187,'consent_key','92fd5fd3b55021c34c6ad54c7d1467fe-5db7ab3c5fab87ca6da1110c18403c06'),(167,0,0,188,'consent_key','e9e2c613ef7ec233275004d10f8aed14-fcd87df01e9fa0d5c59d8e4730e95fa8'),(168,0,0,189,'consent_key','8bc941dd59ed9558e4625fcbbab58df9-a3d7e578bfd1ca18733e16533df1715b'),(169,0,0,191,'consent_key','8c683d4d37182c34661a4cf1f3797ffd-ab598329227d839f540f995b0ae36bba'),(170,0,0,192,'consent_key','a4f000895ccb747a860413a67d06feeb-fbef7523f4737f20c51b034a96916afa'),(171,0,0,193,'consent_key','780e0244aba422a4f5d8eb3823fee66c-14d6ae7ee820d061a416981284b2f424'),(172,0,0,190,'consent_key','a5143e2049b9bc205e743b04e20cd284-d0dfefe812df4ab226c029f862a48958'),(173,0,0,194,'consent_key','f23979d48aa25b602d7a55d654704fa8-541c217e5717dcb8ab9f36ebbf41d006'),(174,0,0,195,'consent_key','fdd9fde9348c0d6d0818d3576f125699-6b328ea7bc7f48ac6fdbf850c085d120'),(175,0,0,196,'consent_key','a7eefe53d5a0d322c54d714f123abae6-f02ce698e589df5e246e8f2685378418'),(176,0,0,197,'consent_key','d777e6cb7af256a8903ba01c5ca44acb-52c1e314781f50dbf831a5ae679451f2'),(177,0,0,198,'consent_key','12e87cd24c99c928c4306589070da2b0-a9ea38627a3cecb319f679b38439045a'),(178,0,0,199,'consent_key','682d2a62104ecb484dbda3a60738b9ab-1140e0cc7c2af800d060ae3f9910225f'),(179,0,0,200,'consent_key','ee0e59f537e503d5fe5491f250ea2ce7-c097ddb0533abd5b0e04f36c9807373d'),(180,0,0,455,'consent_key','a9560a79fe6168af8c5db8097a8c7a0a-1a9a03270e5db729a659a9b51566a957'),(181,0,0,456,'consent_key','ac490ec68f0fdfc9bb0498e6c683c1f6-cce7133448e4e6a717a7e797233dd936'),(182,0,0,457,'consent_key','212b413814c288ef1600abdb701b89a7-0b07b23ad9bd3b54b3c86411d85c5cbe'),(183,0,0,458,'consent_key','07195f51cd27cb455e8acab23d90fd03-40bb5e5debf9e5d78f43cfaca77493f7'),(184,0,0,459,'consent_key','ce76c27167ae7d1a2ff11357a452dd24-e0c89309b0602fe5f7b412ff84efdf10'),(185,0,0,460,'consent_key','90311f877718d41bf499fe8fb967db04-12e66a06e96c9992eda9309b64d6a75c'),(186,0,0,461,'consent_key','24def1c352300cf02453ab7da9700033-1d98b21d250cd3ea9ac37db8815634bc'),(187,0,0,462,'consent_key','c4b1326d71fb1e301e4ee4b83e914fb8-b1d154fe3a40b9e798eb43f6a38e2dbb'),(188,0,0,464,'consent_key','449ea2b000a852c0d51d9d3f34d4a1c0-70802081ae85ececa8047a5b63df44b6'),(189,0,0,465,'consent_key','89424ffa58351643ddd3eb2264398c8c-7b3bb5b23cc4234516bd3f405e8d3595'),(190,0,0,466,'consent_key','c7fdf10820231cd19178a6faa3eedf2e-25da3a7152944513deda62ac41d00b88'),(191,0,0,467,'consent_key','466c0c4a6da8dad946d6f64be029816e-e3debb3b28920de93f7826e8e617a923');

--
-- Table structure for table `tblvault`
--

CREATE TABLE `tblvault` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `server_address` varchar(400) NOT NULL,
  `port` int(11) DEFAULT NULL,
  `username` varchar(300) NOT NULL,
  `password` text NOT NULL,
  `description` text DEFAULT NULL,
  `creator` int(11) NOT NULL,
  `creator_name` varchar(100) DEFAULT NULL,
  `visibility` tinyint(1) NOT NULL DEFAULT 1,
  `share_in_projects` tinyint(1) NOT NULL DEFAULT 0,
  `last_updated` datetime DEFAULT NULL,
  `last_updated_from` varchar(100) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblvault`
--


--
-- Table structure for table `tblviews_tracking`
--

CREATE TABLE `tblviews_tracking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(40) NOT NULL,
  `date` datetime NOT NULL,
  `view_ip` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=527 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblviews_tracking`
--

INSERT INTO `tblviews_tracking` VALUES (1,1,'invoice','2016-10-16 14:20:57','120.151.37.150'),(2,2,'invoice','2016-10-19 12:01:21','203.45.44.132'),(3,3,'invoice','2016-11-03 20:25:18','120.151.37.150'),(4,3,'invoice','2016-11-03 22:22:06','54.196.113.237'),(5,3,'invoice','2016-11-04 18:23:52','54.158.61.238'),(6,5,'invoice','2016-11-10 11:27:29','1.152.96.42'),(7,5,'invoice','2016-11-10 12:45:41','1.152.96.42'),(8,5,'invoice','2016-11-13 18:09:39','110.142.151.97'),(9,1,'estimate','2016-11-14 09:01:10','122.111.4.9'),(10,6,'invoice','2016-11-14 09:03:13','122.111.4.9'),(11,2,'estimate','2016-11-15 10:34:44','103.226.160.202'),(12,5,'invoice','2016-11-17 15:21:22','54.87.16.118'),(13,5,'invoice','2016-11-17 16:43:28','54.212.53.179'),(14,5,'invoice','2016-11-23 15:53:20','70.39.157.197'),(15,4,'invoice','2016-11-23 21:14:38','1.136.96.217'),(16,4,'invoice','2016-11-24 10:01:02','1.136.96.200'),(17,5,'invoice','2016-11-25 11:57:46','54.226.66.79'),(18,5,'invoice','2016-11-25 17:03:57','54.234.126.110'),(19,4,'invoice','2016-11-27 09:10:58','1.136.97.82'),(20,4,'invoice','2016-11-27 10:33:41','1.136.96.121'),(21,6,'invoice','2016-11-28 08:41:57','122.111.4.16'),(22,5,'invoice','2016-11-28 11:01:38','52.13.91.61'),(23,6,'invoice','2016-12-14 15:25:52','122.111.2.136'),(24,6,'invoice','2016-12-31 08:14:20','124.188.132.110'),(25,3,'estimate','2017-01-23 12:01:32','103.226.160.202'),(26,19,'invoice','2017-02-23 16:32:42','49.177.68.152'),(27,24,'invoice','2017-04-11 10:11:17','101.167.101.192'),(28,24,'invoice','2017-04-11 12:20:36','101.167.101.192'),(29,7,'estimate','2017-05-04 15:57:54','1.152.96.156'),(30,35,'invoice','2017-06-18 20:30:31','110.140.120.161'),(31,35,'invoice','2017-06-19 06:54:15','110.140.120.161'),(32,33,'invoice','2017-06-26 09:16:31','103.226.160.202'),(33,39,'invoice','2017-07-30 15:01:25','122.107.136.108'),(34,41,'invoice','2017-07-30 18:09:41','52.13.156.158'),(35,39,'invoice','2017-07-31 07:17:58','49.199.206.176'),(36,39,'invoice','2017-07-31 14:21:27','118.127.103.150'),(37,36,'invoice','2017-08-07 09:46:30','202.93.152.4'),(38,44,'invoice','2017-08-31 08:46:59','122.107.158.126'),(39,44,'invoice','2017-09-03 18:32:48','122.107.158.126'),(40,13,'estimate','2017-11-20 14:21:16','1.152.105.179'),(41,16,'estimate','2017-11-29 17:42:58','121.208.182.10'),(42,59,'invoice','2017-11-29 17:43:19','121.208.182.10'),(43,58,'invoice','2017-11-29 18:37:59','120.21.147.226'),(44,59,'invoice','2017-11-29 22:40:34','121.208.182.10'),(45,61,'invoice','2017-11-30 14:43:47','49.185.242.152'),(46,61,'invoice','2017-12-01 00:09:02','114.198.34.163'),(47,66,'invoice','2017-12-14 07:43:01','101.181.32.250'),(48,17,'estimate','2017-12-30 09:17:38','49.185.234.170'),(49,153,'invoice','2018-05-29 12:52:41','49.184.152.5'),(50,153,'invoice','2018-05-29 20:39:19','175.32.230.253'),(51,157,'invoice','2018-06-04 19:10:39','58.179.188.131'),(52,159,'invoice','2018-06-06 11:08:57','180.150.121.168'),(53,159,'invoice','2018-06-07 07:41:28','180.150.121.168'),(54,170,'invoice','2018-07-31 07:21:54','1.129.104.184'),(55,171,'invoice','2018-08-13 14:23:08','1.152.109.39'),(56,64,'invoice','2018-08-21 14:02:48','207.46.13.123'),(57,19,'estimate','2018-11-21 20:23:33','2001:8003:5c68:3e00:e4c1:63d4:9ff8:908f'),(58,19,'estimate','2018-11-26 20:00:01','2001:8003:5c68:3e00:d060:35e9:46d8:17b'),(59,19,'estimate','2018-11-27 16:06:49','2001:8003:5c68:3e00:60ad:4ff4:18d0:11f2'),(60,19,'estimate','2018-11-28 10:22:20','2001:8003:5c68:3e00:2951:558f:73bc:72af'),(61,8,'estimate','2019-01-16 20:39:30','203.220.168.157'),(62,20,'estimate','2019-02-19 15:40:05','1.152.104.100'),(63,192,'invoice','2019-03-06 09:49:42','120.18.220.41'),(64,228,'invoice','2019-05-19 22:33:49','2001:8003:d1cf:b800:3ce5:562d:ff2:404f'),(65,28,'estimate','2019-07-14 21:02:17','4.53.111.68'),(66,46,'invoice','2019-07-16 12:31:11','49.199.226.56'),(67,242,'invoice','2019-08-19 20:49:51','66.102.8.40'),(68,241,'invoice','2019-08-20 11:57:29','120.21.238.130'),(69,246,'invoice','2019-08-30 16:33:46','2001:8003:4ef2:7300:9c10:5216:3bd9:88f6'),(70,262,'invoice','2019-11-20 20:03:15','49.199.3.53'),(71,262,'invoice','2019-11-22 13:24:27','49.199.245.24'),(72,262,'invoice','2019-11-22 15:48:02','49.199.3.53'),(73,264,'invoice','2019-11-26 12:41:19','115.124.35.198'),(74,34,'estimate','2019-11-28 11:27:16','49.185.0.85'),(75,269,'invoice','2019-12-12 21:36:56','115.124.35.119'),(76,269,'invoice','2019-12-21 12:04:37','115.124.35.129'),(77,269,'invoice','2019-12-21 14:24:06','1.152.108.21'),(78,271,'invoice','2019-12-23 07:41:55','61.68.110.91'),(79,263,'invoice','2020-01-20 07:34:29','40.94.240.53'),(80,267,'invoice','2020-02-07 08:13:50','40.77.167.123'),(81,35,'estimate','2020-02-10 14:01:05','202.45.119.27'),(82,283,'invoice','2020-02-20 21:16:40','66.102.8.6'),(83,280,'invoice','2020-03-08 21:08:05','66.102.8.8'),(84,298,'invoice','2020-03-27 13:49:33','49.199.133.142'),(85,298,'invoice','2020-03-27 17:03:36','60.241.161.58'),(86,298,'invoice','2020-04-01 08:31:38','60.241.161.58'),(87,237,'invoice','2020-05-05 14:18:20','60.240.208.47'),(88,41,'estimate','2020-05-12 15:15:26','110.140.133.253'),(89,308,'invoice','2020-05-25 10:19:20','2001:8003:d824:f801:385b:f664:85e9:945c'),(90,316,'invoice','2020-06-22 07:58:14','66.102.8.52'),(91,313,'invoice','2020-07-01 06:57:53','175.32.209.148'),(92,320,'invoice','2020-07-04 07:41:55','123.208.208.234'),(93,320,'invoice','2020-07-04 09:29:44','123.208.208.234'),(94,322,'invoice','2020-07-04 12:45:26','49.199.141.157'),(95,318,'invoice','2020-07-04 16:09:20','66.102.8.50'),(96,313,'invoice','2020-07-05 18:52:58','175.32.209.148'),(97,326,'invoice','2020-07-10 08:13:35','194.223.4.228'),(98,318,'invoice','2020-07-12 17:45:58','123.208.208.234'),(99,326,'invoice','2020-07-21 14:33:37','66.102.8.159'),(100,331,'invoice','2020-07-24 11:10:22','175.33.248.77'),(101,332,'invoice','2020-07-25 09:33:46','1.152.104.33'),(102,332,'invoice','2020-07-25 18:04:31','60.224.88.2'),(103,332,'invoice','2020-07-25 20:46:06','66.102.8.159'),(104,332,'invoice','2020-07-26 13:09:04','1.136.111.17'),(105,332,'invoice','2020-07-27 12:48:27','60.224.88.2'),(106,335,'invoice','2020-07-29 21:54:27','14.201.53.178'),(107,335,'invoice','2020-07-29 23:08:02','14.201.53.178'),(108,332,'invoice','2020-07-30 17:19:13','60.224.88.2'),(109,335,'invoice','2020-07-31 20:07:51','1.136.107.151'),(110,47,'estimate','2020-08-10 07:43:09','2001:8003:7113:f900:6423:66bb:a61e:6900'),(111,340,'invoice','2020-08-10 07:43:35','2001:8003:7113:f900:6423:66bb:a61e:6900'),(112,323,'invoice','2020-08-10 16:00:24','66.102.8.156'),(113,50,'estimate','2020-09-25 10:16:44','49.199.23.182'),(114,51,'estimate','2020-09-25 10:19:01','49.199.23.182'),(115,344,'invoice','2020-09-29 09:59:38','2001:8003:421f:3201:f0f4:3baa:74c3:c423'),(116,343,'invoice','2020-10-01 05:08:54','34.221.141.40'),(117,343,'invoice','2020-10-01 08:01:27','141.168.87.80'),(118,53,'estimate','2020-10-14 10:56:55','119.18.19.249'),(119,358,'invoice','2020-10-14 11:16:04','119.18.19.249'),(120,357,'invoice','2020-10-14 14:35:17','120.21.158.152'),(121,358,'invoice','2020-10-14 17:17:31','119.18.19.249'),(122,357,'invoice','2020-10-14 18:33:28','2001:8003:d4d1:4501:484b:c83f:f8d6:2e23'),(123,357,'invoice','2020-10-14 22:01:59','2001:8003:d4d1:4501:484b:c83f:f8d6:2e23'),(124,357,'invoice','2020-10-16 07:36:19','2001:8003:d4d1:4501:e582:96e6:6ca:72d9'),(125,357,'invoice','2020-10-17 08:48:59','203.5.76.197'),(126,359,'invoice','2020-10-17 08:50:50','203.5.76.199'),(127,343,'invoice','2020-10-28 12:14:55','34.222.13.120'),(128,364,'invoice','2020-10-31 07:31:42','49.199.138.234'),(129,343,'invoice','2020-10-31 09:47:53','2001:8003:d16e:5600:d875:2974:5fbd:1ddb'),(130,57,'estimate','2020-11-04 08:11:43','45.141.142.28'),(131,369,'invoice','2020-11-13 12:53:26','45.141.142.205'),(132,370,'invoice','2020-11-17 20:27:35','110.32.39.157'),(133,369,'invoice','2020-11-18 07:48:14','45.141.142.15'),(134,371,'invoice','2020-11-20 07:01:10','175.32.40.17'),(135,372,'invoice','2020-11-20 08:19:53','203.220.207.133'),(136,58,'estimate','2020-11-27 09:25:55','137.147.207.75'),(137,374,'invoice','2020-11-27 09:26:20','137.147.207.75'),(138,58,'estimate','2020-11-27 22:01:06','137.147.207.75'),(139,373,'invoice','2020-12-14 21:03:51','49.199.118.45'),(140,394,'invoice','2021-02-05 05:22:29','20.46.108.116'),(141,395,'invoice','2021-02-14 19:27:33','50.31.240.167'),(142,58,'estimate','2021-02-16 10:46:29','121.220.37.254'),(143,58,'estimate','2021-02-17 09:23:54','121.220.37.254'),(144,399,'invoice','2021-03-11 11:38:12','103.217.167.109'),(145,401,'invoice','2021-04-09 16:49:08','50.31.255.133'),(146,401,'invoice','2021-04-12 08:15:48','50.31.240.167'),(147,401,'invoice','2021-04-12 10:44:02','50.31.240.181'),(148,404,'invoice','2021-04-25 09:09:45','20.37.20.245'),(149,380,'invoice','2021-04-25 09:12:17','20.38.186.153'),(150,371,'invoice','2021-05-25 20:46:14','175.33.34.81'),(151,405,'invoice','2021-06-04 04:45:44','20.46.108.52'),(152,70,'estimate','2021-06-28 18:54:59','119.17.57.114'),(153,69,'estimate','2021-06-28 18:55:17','119.17.57.114'),(154,410,'invoice','2021-07-14 13:31:10','13.112.15.116'),(155,444,'invoice','2021-10-10 17:00:16','49.184.45.102'),(156,371,'invoice','2021-10-22 17:00:13','175.32.224.39'),(157,91,'estimate','2021-10-27 15:53:23','2001:8003:480b:b01:903f:dd97:7295:cc2b'),(158,454,'invoice','2021-10-27 15:53:31','2001:8003:480b:b01:903f:dd97:7295:cc2b'),(159,91,'estimate','2021-11-03 16:26:35','220.244.136.199'),(160,93,'estimate','2021-11-08 11:43:45','123.243.137.84'),(161,456,'invoice','2021-11-11 17:05:43','103.77.232.102'),(162,455,'invoice','2021-11-16 14:07:04','2001:8003:48ff:6600:59df:abe8:b45b:586f'),(163,454,'invoice','2021-11-19 20:05:33','2001:8003:480b:b01:1131:3e85:849d:a287'),(164,454,'invoice','2021-11-26 08:14:29','1.136.108.132'),(165,454,'invoice','2021-11-26 18:58:51','1.152.109.107'),(166,461,'invoice','2021-12-02 09:03:15','149.167.142.14'),(167,400,'invoice','2022-02-03 12:53:30','49.185.7.15'),(168,493,'invoice','2022-02-14 11:22:29','208.124.110.68'),(169,475,'invoice','2022-02-21 09:59:53','2001:8003:5157:2101:1813:7e79:c0cb:da07'),(170,508,'invoice','2022-03-10 15:19:40','202.80.73.5'),(171,508,'invoice','2022-03-11 15:48:03','2001:8004:4600:9dc3:5cc3:25f6:2f63:aa13'),(172,522,'invoice','2022-03-21 14:41:34','114.72.71.230'),(173,522,'invoice','2022-03-21 17:52:32','114.72.71.230'),(174,522,'invoice','2022-03-25 07:11:03','114.72.71.230'),(175,522,'invoice','2022-03-29 20:05:28','114.72.71.230'),(176,522,'invoice','2022-03-31 14:26:30','149.167.142.95'),(177,561,'invoice','2022-05-26 15:05:26','175.39.15.161'),(178,564,'invoice','2022-06-01 13:23:42','122.150.114.227'),(179,566,'invoice','2022-06-07 10:43:58','144.138.52.145'),(180,585,'invoice','2022-07-17 19:31:50','2001:8004:1240:56df:194c:5f0e:182a:1e3b'),(181,585,'invoice','2022-07-24 09:13:20','119.17.138.83'),(182,585,'invoice','2022-07-24 23:02:06','119.17.138.83'),(183,584,'invoice','2022-09-09 10:20:52','120.153.145.219'),(184,562,'invoice','2022-09-28 10:09:22','175.38.40.50'),(185,628,'invoice','2022-10-12 21:14:36','144.138.52.145'),(186,629,'invoice','2022-10-12 21:16:26','144.138.52.145'),(187,630,'invoice','2022-10-12 21:19:29','144.138.52.145'),(188,629,'invoice','2022-10-14 18:29:54','35.87.168.29'),(189,639,'invoice','2022-11-07 13:18:24','173.44.117.68'),(190,642,'invoice','2022-11-13 04:08:10','161.43.219.164'),(191,647,'invoice','2022-11-29 12:45:50','49.185.89.94'),(192,647,'invoice','2022-11-29 19:35:08','175.38.172.100'),(193,662,'invoice','2022-12-19 06:52:55','220.245.191.190'),(194,689,'invoice','2023-01-30 13:32:12','103.227.64.16'),(195,700,'invoice','2023-02-04 07:49:27','2001:8004:27e2:14c4:a81a:dc1a:5ccc:b1cf'),(196,705,'invoice','2023-02-16 12:39:29','103.227.64.16'),(197,706,'invoice','2023-02-16 13:32:57','131.242.32.6'),(198,722,'invoice','2023-03-05 12:35:41','27.33.94.182'),(199,723,'invoice','2023-03-05 15:23:58','49.184.202.154'),(200,702,'invoice','2023-03-12 12:19:03','49.198.67.98'),(201,702,'invoice','2023-03-12 20:36:07','153.107.192.133'),(202,732,'invoice','2023-04-21 08:55:53','20.190.103.11'),(203,707,'invoice','2023-04-28 07:52:38','2a01:111:f403:7004::100'),(204,774,'invoice','2023-05-18 10:28:44','2a01:111:f403:7004::100'),(205,769,'invoice','2023-06-08 12:00:15','2001:8004:4502:9620:b87a:aeff:fe52:82c8'),(206,800,'invoice','2023-06-19 10:45:58','34.150.223.83'),(207,802,'invoice','2023-06-21 10:07:00','203.5.76.196'),(208,810,'invoice','2023-06-28 06:33:43','62.232.200.131'),(209,114,'estimate','2023-07-06 21:10:03','2a01:111:f403:7005::100'),(210,820,'invoice','2023-07-06 21:12:09','220.245.14.26'),(211,820,'invoice','2023-07-06 22:22:35','220.245.14.26'),(212,820,'invoice','2023-07-07 08:08:13','220.245.14.26'),(213,820,'invoice','2023-07-07 09:16:34','220.245.14.26'),(214,820,'invoice','2023-07-07 10:39:52','120.21.238.19'),(215,820,'invoice','2023-07-07 13:16:11','120.21.238.19'),(216,820,'invoice','2023-07-07 14:57:30','220.245.14.26'),(217,820,'invoice','2023-07-07 16:49:08','220.245.14.26'),(218,820,'invoice','2023-07-08 00:07:03','220.245.14.26'),(219,820,'invoice','2023-07-08 14:22:10','120.21.238.19'),(220,820,'invoice','2023-07-08 18:22:21','120.21.238.19'),(221,820,'invoice','2023-07-08 22:48:55','120.21.238.19'),(222,820,'invoice','2023-07-09 10:08:21','120.21.238.19'),(223,820,'invoice','2023-07-09 11:58:51','220.245.14.26'),(224,820,'invoice','2023-07-09 14:10:33','220.245.14.26'),(225,808,'invoice','2023-07-09 15:42:39','175.36.111.178'),(226,820,'invoice','2023-07-09 15:56:19','119.18.30.128'),(227,831,'invoice','2023-07-29 14:04:37','2001:8004:4503:3338:a17d:c384:7db9:b3f9'),(228,834,'invoice','2023-07-31 17:27:44','2a01:111:f403:704b::100'),(229,851,'invoice','2023-08-13 16:32:57','13.53.72.152'),(230,844,'invoice','2023-08-15 13:08:34','2a01:111:f403:7004::100'),(231,847,'invoice','2023-08-15 15:15:43','202.7.205.132'),(232,844,'invoice','2023-08-15 23:41:43','202.7.205.133'),(233,850,'invoice','2023-08-16 06:28:19','2a01:111:f403:7139::5'),(234,844,'invoice','2023-08-16 09:34:01','2a01:111:f403:7060::5'),(235,850,'invoice','2023-08-16 09:56:01','2a01:111:f403:7004::100'),(236,844,'invoice','2023-08-16 12:34:05','2a01:111:f403:7139::5'),(237,850,'invoice','2023-08-16 12:34:42','52.102.13.37'),(238,852,'invoice','2023-08-28 17:31:50','2a01:111:f403:7061::5'),(239,116,'estimate','2023-08-30 12:24:09','2a01:111:f403:7060::5'),(240,857,'invoice','2023-08-30 18:54:03','203.219.219.71'),(241,857,'invoice','2023-08-31 05:17:53','202.7.205.134'),(242,116,'estimate','2023-09-04 09:38:43','139.218.20.6'),(243,842,'invoice','2023-09-26 09:15:57','123.51.76.178'),(244,892,'invoice','2023-10-05 21:53:30','175.36.111.178'),(245,892,'invoice','2023-10-06 00:36:29','220.244.136.134'),(246,892,'invoice','2023-10-06 08:38:19','175.36.111.178'),(247,121,'estimate','2023-10-06 14:56:08','89.184.204.41'),(248,120,'estimate','2023-10-06 14:56:09','212.70.7.31'),(249,120,'estimate','2023-10-08 21:22:41','121.45.112.29'),(250,120,'estimate','2023-10-09 11:03:06','185.225.104.18'),(251,121,'estimate','2023-10-09 12:41:50','185.223.58.151'),(252,121,'estimate','2023-10-09 14:14:35','121.45.112.29'),(253,120,'estimate','2023-10-09 14:22:16','121.45.112.29'),(254,895,'invoice','2023-10-11 14:33:54','2a01:111:f403:7139::5'),(255,118,'estimate','2023-10-23 10:08:55','2001:8004:27f0:1034:9071:cf3c:ff4a:d0b8'),(256,895,'invoice','2023-10-23 14:22:51','2a01:111:f403:7060::5'),(257,118,'estimate','2023-10-23 14:31:27','2001:8004:27f0:1034:9071:cf3c:ff4a:d0b8'),(258,895,'invoice','2023-10-23 20:55:03','2001:8004:27f0:1034:9071:cf3c:ff4a:d0b8'),(259,885,'invoice','2023-10-26 10:49:15','20.70.38.176'),(260,897,'invoice','2023-11-01 07:23:46','125.253.110.96'),(261,119,'estimate','2023-11-13 08:13:48','2001:8004:4610:7845:35a3:9a5d:5cf9:e47a'),(262,113,'estimate','2023-11-28 13:10:07','2a01:111:f403:7138::5'),(263,112,'estimate','2023-11-28 13:10:34','2a01:111:f403:7138::5'),(264,912,'invoice','2023-12-04 08:57:09','2a01:111:f403:7005::100'),(265,126,'estimate','2023-12-10 20:51:36','2001:8003:d961:d801:7024:b171:ad2c:1771'),(266,925,'invoice','2023-12-10 20:51:56','2001:8003:d961:d801:7024:b171:ad2c:1771'),(267,912,'invoice','2023-12-11 12:37:53','2a01:111:f403:7061::5'),(268,126,'estimate','2023-12-14 07:20:13','2001:8003:d961:d801:3d89:ed43:bac2:7b26'),(269,126,'estimate','2023-12-14 09:05:32','34.151.104.68'),(270,911,'invoice','2024-01-11 13:31:41','2a01:111:f403:7138::5'),(271,127,'estimate','2024-01-16 17:45:10','2001:ac8:84:3001:4b54:e892:8359:e7dd'),(272,128,'estimate','2024-01-16 17:47:54','2001:ac8:84:3001:4b54:e892:8359:e7dd'),(273,128,'estimate','2024-01-17 15:49:39','2001:ac8:84:3001:4b54:e892:8359:e7dd'),(274,129,'estimate','2024-01-22 15:32:22','2001:ac8:84:2001:f8d4:5b38:808c:4b61'),(275,129,'estimate','2024-01-23 00:54:22','220.244.136.196'),(276,129,'estimate','2024-01-23 14:36:55','2001:ac8:84:3001:4b54:e892:8359:e7dd'),(277,951,'invoice','2024-01-29 11:42:49','2a01:111:f403:7061::5'),(278,951,'invoice','2024-02-05 12:00:04','2a01:111:f403:7139::5'),(279,956,'invoice','2024-02-05 12:39:52','2a01:111:f403:7061::5'),(280,951,'invoice','2024-02-06 09:59:12','2a01:111:f403:7005::100'),(281,129,'estimate','2024-02-07 14:23:14','2001:ac8:84:3001:4b54:e892:8359:e7dd'),(282,129,'estimate','2024-02-08 16:05:47','2001:ac8:84:6001:b96c:c312:2943:d3a5'),(283,129,'estimate','2024-02-08 17:50:01','139.218.20.6'),(284,129,'estimate','2024-02-08 18:50:42','2001:ac8:84:6001:b96c:c312:2943:d3a5'),(285,966,'invoice','2024-02-12 11:49:58','49.183.12.164'),(286,966,'invoice','2024-02-15 08:57:09','49.199.84.72'),(287,131,'estimate','2024-02-16 07:47:34','2a09:bac2:3de:1d7::2f:53'),(288,976,'invoice','2024-02-16 07:47:38','2a09:bac2:3de:1d7::2f:53'),(289,131,'estimate','2024-02-16 08:56:49','172.225.156.149'),(290,959,'invoice','2024-02-20 01:03:36','203.13.161.68'),(291,936,'invoice','2024-02-20 14:55:55','146.112.163.35'),(292,133,'estimate','2024-02-21 21:16:07','52.10.69.113'),(293,133,'estimate','2024-02-22 17:09:25','35.87.51.212'),(294,134,'estimate','2024-02-22 20:44:34','52.10.69.113'),(295,980,'invoice','2024-02-28 07:28:39','35.87.81.153'),(296,980,'invoice','2024-03-01 13:34:33','35.163.125.176'),(297,980,'invoice','2024-03-01 13:34:33','34.220.196.19'),(298,959,'invoice','2024-03-01 17:23:03','220.244.136.132'),(299,976,'invoice','2024-03-01 19:52:42','101.188.42.197'),(300,129,'estimate','2024-03-05 13:29:49','2001:ac8:84:3001:4b54:e892:8359:e7dd'),(301,132,'estimate','2024-03-06 18:15:20','2001:8004:1500:36f2:919f:70a0:16df:6bc7'),(302,132,'estimate','2024-03-22 15:38:23','2001:8004:15a0:1d81:a176:5a20:bbf6:b20a'),(303,980,'invoice','2024-03-24 17:10:53','18.236.125.3'),(304,980,'invoice','2024-03-25 09:56:23','54.245.212.103'),(305,137,'estimate','2024-03-25 13:30:22','65.181.12.210'),(306,139,'estimate','2024-03-28 12:53:58','121.200.29.208'),(307,1017,'invoice','2024-03-28 12:54:01','121.200.29.208'),(308,139,'estimate','2024-03-29 01:32:22','141.168.13.197'),(309,1017,'invoice','2024-03-30 16:57:05','54.184.149.75'),(310,141,'estimate','2024-04-02 11:47:01','59.100.246.126'),(311,142,'estimate','2024-04-02 16:40:22','59.100.246.126'),(312,141,'estimate','2024-04-02 16:44:56','59.100.246.126'),(313,142,'estimate','2024-04-03 05:32:26','220.244.136.197'),(314,141,'estimate','2024-04-03 13:57:40','138.217.110.90'),(315,1018,'invoice','2024-04-03 13:58:08','138.217.110.90'),(316,141,'estimate','2024-04-03 20:18:32','14.202.119.155'),(317,132,'estimate','2024-04-04 16:19:45','2001:8004:15a0:47f5:4977:7279:f555:f882'),(318,132,'estimate','2024-04-04 23:26:49','2a01:111:f403:7138::5'),(319,1023,'invoice','2024-04-04 23:27:14','49.199.51.183'),(320,142,'estimate','2024-04-08 12:38:33','110.145.152.74'),(321,1025,'invoice','2024-04-08 12:38:42','110.145.152.74'),(322,142,'estimate','2024-04-09 03:24:17','203.219.196.68'),(323,137,'estimate','2024-04-09 07:47:18','120.151.1.26'),(324,1026,'invoice','2024-04-09 07:47:22','120.151.1.26'),(325,142,'estimate','2024-04-09 08:45:32','59.100.246.126'),(326,1023,'invoice','2024-04-10 15:23:37','2001:8004:1520:2783:404f:ffc:e680:a430'),(327,1018,'invoice','2024-04-10 15:38:06','138.217.110.90'),(328,142,'estimate','2024-04-10 20:32:01','220.245.162.3'),(329,149,'estimate','2024-04-12 09:37:19','2001:8003:480f:100:2469:2c3e:3e1e:261a'),(330,1029,'invoice','2024-04-12 09:37:36','2001:8003:480f:100:2469:2c3e:3e1e:261a'),(331,132,'estimate','2024-04-12 12:49:13','2a01:111:f403:7061::5'),(332,147,'estimate','2024-04-12 14:32:28','1.152.23.206'),(333,1030,'invoice','2024-04-12 14:33:41','1.152.23.206'),(334,1027,'invoice','2024-04-17 14:08:18','20.11.232.32'),(335,1028,'invoice','2024-04-17 14:13:57','20.92.77.202'),(336,1031,'invoice','2024-04-25 13:01:01','209.222.82.62'),(337,1046,'invoice','2024-05-02 14:14:01','34.83.221.62'),(338,1047,'invoice','2024-05-02 14:18:54','34.105.37.64'),(339,1048,'invoice','2024-05-02 17:40:32','34.105.37.64'),(340,1049,'invoice','2024-05-02 17:41:09','34.105.37.64'),(341,1047,'invoice','2024-05-02 17:41:19','34.95.185.149'),(342,1046,'invoice','2024-05-02 17:42:02','35.225.82.182'),(343,1046,'invoice','2024-05-03 00:16:12','35.245.188.175'),(344,1047,'invoice','2024-05-03 00:19:40','34.86.239.201'),(345,1048,'invoice','2024-05-03 00:20:27','34.105.37.64'),(346,1049,'invoice','2024-05-03 00:21:02','34.83.221.62'),(347,1044,'invoice','2024-05-04 15:10:57','216.183.212.10'),(348,156,'estimate','2024-05-08 06:53:13','58.179.159.172'),(349,155,'estimate','2024-05-08 08:17:29','202.47.121.100'),(350,132,'estimate','2024-05-08 12:36:56','2001:8004:1580:766:45b0:f7e0:f97:2ba1'),(351,1046,'invoice','2024-05-08 14:20:32','34.145.227.243'),(352,158,'estimate','2024-05-08 15:54:30','1.136.24.103'),(353,158,'estimate','2024-05-08 19:17:56','203.26.235.14'),(354,158,'estimate','2024-05-09 19:41:59','2001:8004:4650:419c:d439:318f:4dbe:4e45'),(355,157,'estimate','2024-05-10 10:49:43','58.179.159.172'),(356,1050,'invoice','2024-05-10 10:50:01','58.179.159.172'),(357,158,'estimate','2024-05-10 11:16:19','203.26.235.14'),(358,1051,'invoice','2024-05-10 11:18:35','203.26.235.14'),(359,158,'estimate','2024-05-11 14:53:59','14.203.59.47'),(360,159,'estimate','2024-05-12 12:20:13','2406:2d40:4128:8f10:19ec:4a99:36f:c117'),(361,1053,'invoice','2024-05-12 12:20:37','2406:2d40:4128:8f10:19ec:4a99:36f:c117'),(362,160,'estimate','2024-05-12 13:26:29','122.150.1.6'),(363,162,'estimate','2024-05-12 20:05:52','2402:b801:2861:bb00:bc9f:aca7:8c70:be3b'),(364,162,'estimate','2024-05-12 21:17:24','220.244.136.4'),(365,164,'estimate','2024-05-13 19:37:51','2406:2d40:4128:8f10:19ec:4a99:36f:c117'),(366,1057,'invoice','2024-05-13 19:38:06','2406:2d40:4128:8f10:19ec:4a99:36f:c117'),(367,165,'estimate','2024-05-14 16:01:02','203.12.12.129'),(368,1058,'invoice','2024-05-14 16:03:43','203.12.12.129'),(369,166,'estimate','2024-05-14 17:36:51','203.12.12.129'),(370,1059,'invoice','2024-05-14 17:37:09','203.12.12.129'),(371,165,'estimate','2024-05-14 18:32:34','203.153.17.36'),(372,166,'estimate','2024-05-14 22:21:06','139.218.20.4'),(373,166,'estimate','2024-05-15 15:56:51','45.132.225.207'),(374,166,'estimate','2024-05-16 12:31:46','203.12.12.129'),(375,168,'estimate','2024-05-20 05:08:06','2a09:bac2:af7a:1250::1d3:45'),(376,168,'estimate','2024-05-20 07:58:24','2a09:bac2:3de:1d7::2f:52'),(377,169,'estimate','2024-05-20 07:58:46','2a09:bac2:3de:1d7::2f:52'),(378,1060,'invoice','2024-05-20 08:46:34','121.200.4.176'),(379,168,'estimate','2024-05-20 11:24:39','121.200.4.176'),(380,174,'estimate','2024-05-20 12:00:38','49.183.20.219'),(381,1061,'invoice','2024-05-20 12:01:58','49.183.20.219'),(382,166,'estimate','2024-05-21 11:21:58','203.12.12.129'),(383,1060,'invoice','2024-05-21 16:33:02','2a09:bac2:3d9:1d7::2f:62'),(384,1061,'invoice','2024-05-21 21:30:09','220.244.33.121'),(385,1061,'invoice','2024-05-22 08:02:17','49.183.13.121'),(386,1051,'invoice','2024-05-22 15:44:56','192.83.237.2'),(387,176,'estimate','2024-05-22 20:00:37','2406:da1c:73b:8802:aaa:581a:56cd:eed7'),(388,1060,'invoice','2024-05-23 08:37:40','35.83.252.79'),(389,176,'estimate','2024-05-23 12:33:39','2406:da1c:73b:8802:4e25:c85d:ecdd:1ea7'),(390,176,'estimate','2024-05-23 19:13:45','2001:8003:4a14:a300:71eb:a799:19cb:cff'),(391,1061,'invoice','2024-05-23 20:26:28','180.150.2.132'),(392,1061,'invoice','2024-05-24 11:07:06','49.184.12.207'),(393,132,'estimate','2024-05-24 12:50:41','2001:8004:1500:722:1db4:b153:9f12:7222'),(394,162,'estimate','2024-05-28 18:58:55','2402:b801:2861:bb00:7549:58a:8da2:2391'),(395,162,'estimate','2024-05-28 20:39:46','203.219.196.68'),(396,178,'estimate','2024-05-29 17:43:48','103.39.136.65'),(397,178,'estimate','2024-05-29 21:56:05','103.39.136.65'),(398,170,'estimate','2024-05-30 13:14:55','121.200.5.149'),(399,178,'estimate','2024-05-30 16:51:49','2407:e400:9033:de01:2404:d61e:80d0:5dd'),(400,1070,'invoice','2024-05-30 16:52:48','2407:e400:9033:de01:2404:d61e:80d0:5dd'),(401,1061,'invoice','2024-06-02 14:43:17','14.200.234.124'),(402,1072,'invoice','2024-06-02 15:20:24','203.222.134.253'),(403,180,'estimate','2024-06-03 16:02:48','220.233.4.56'),(404,1073,'invoice','2024-06-03 16:05:55','220.233.4.56'),(405,182,'estimate','2024-06-04 05:29:35','121.200.5.149'),(406,1073,'invoice','2024-06-04 12:51:01','2406:3400:317:a310:7ce5:1270:5725:6767'),(407,170,'estimate','2024-06-05 16:25:00','121.200.5.97'),(408,182,'estimate','2024-06-05 16:25:14','121.200.5.97'),(409,1074,'invoice','2024-06-05 16:35:50','121.200.5.97'),(410,176,'estimate','2024-06-10 10:20:56','2406:da1c:73b:8803:62eb:ae82:782c:aeff'),(411,168,'estimate','2024-06-12 14:49:33','2a09:bac2:6731:1250::1d3:64'),(412,183,'estimate','2024-06-13 15:48:48','123.243.12.52'),(413,1076,'invoice','2024-06-13 15:52:25','123.243.12.52'),(414,1073,'invoice','2024-06-14 05:57:05','2406:3400:317:a310:7ce5:1270:5725:6767'),(415,1072,'invoice','2024-07-08 08:58:13','58.179.159.172'),(416,185,'estimate','2024-07-08 09:22:24','2a09:bac2:3df:1d7::2f:9a'),(417,170,'estimate','2024-07-08 14:38:47','121.200.5.97'),(418,185,'estimate','2024-07-08 16:05:17','121.200.4.176'),(419,1085,'invoice','2024-07-08 16:05:51','121.200.4.176'),(420,925,'invoice','2024-07-12 13:23:42','34.151.104.68'),(421,186,'estimate','2024-07-15 06:52:26','37.120.233.27'),(422,185,'estimate','2024-07-16 10:06:11','121.200.4.176'),(423,1060,'invoice','2024-07-16 10:06:32','121.200.4.176'),(424,169,'estimate','2024-07-16 10:06:43','121.200.4.176'),(425,162,'estimate','2024-07-21 15:56:15','180.222.1.129'),(426,162,'estimate','2024-07-22 16:42:32','49.183.13.255'),(427,191,'estimate','2024-07-26 07:50:49','2001:8004:1d61:5f86:88fc:7639:377b:219f'),(428,1105,'invoice','2024-07-26 08:49:29','2001:8004:1d60:36e0:3836:8ca1:c7e1:1c7'),(429,191,'estimate','2024-07-26 08:53:54','2001:8004:1d60:36e0:3836:8ca1:c7e1:1c7'),(430,166,'estimate','2024-07-26 12:36:05','203.12.12.129'),(431,191,'estimate','2024-07-26 15:28:05','2001:8003:d415:9000:85a7:568:a5b7:a726'),(432,1070,'invoice','2024-07-28 10:46:27','49.185.67.113'),(433,192,'estimate','2024-07-28 16:32:03','35.89.217.73'),(434,193,'estimate','2024-07-28 16:32:17','35.89.217.73'),(435,193,'estimate','2024-07-29 10:06:13','54.188.192.104'),(436,192,'estimate','2024-07-29 10:06:29','54.186.44.253'),(437,194,'estimate','2024-07-30 13:29:55','49.185.95.228'),(438,1109,'invoice','2024-07-31 11:55:38','117.53.138.85'),(439,191,'estimate','2024-08-02 07:38:06','2001:8003:d415:9000:4def:80be:2acc:3f85'),(440,162,'estimate','2024-08-02 17:03:34','2402:b801:2861:bb00:c5c1:9b49:374e:b5b4'),(441,162,'estimate','2024-08-02 23:47:58','180.222.1.129'),(442,1105,'invoice','2024-08-08 21:06:40','2001:8003:d415:9000:a4ae:4135:2936:6c07'),(443,1105,'invoice','2024-08-09 13:20:11','2001:8003:d415:9000:f924:481e:f787:b311'),(444,191,'estimate','2024-08-09 13:38:22','2001:8003:d415:9000:f924:481e:f787:b311'),(445,976,'invoice','2024-08-09 15:12:26','172.225.156.148'),(446,1105,'invoice','2024-08-11 17:00:51','35.161.40.14'),(447,162,'estimate','2024-08-27 09:21:04','2402:b801:2861:bb00:115a:a693:3b5a:3833'),(448,1122,'invoice','2024-08-27 09:21:28','2402:b801:2861:bb00:115a:a693:3b5a:3833'),(449,199,'estimate','2024-08-27 13:42:16','121.200.4.228'),(451,1060,'invoice','2024-08-28 08:34:25','2a09:bac2:3de:1d7::2f:96'),(452,199,'estimate','2024-10-06 14:22:34','121.200.4.6'),(453,1023,'invoice','2024-10-29 21:32:14','2a01:111:f403:7004::100'),(454,1023,'invoice','2024-11-07 19:00:12','52.143.97.249'),(455,1066,'invoice','2024-11-12 15:33:45','20.70.99.197'),(456,191,'estimate','2025-02-01 13:13:32','2403:5813:1ca7:0:e503:63dd:2727:7add'),(457,170,'estimate','2025-02-12 10:39:31','121.200.4.5'),(458,199,'estimate','2025-02-12 10:40:23','121.200.4.5'),(459,168,'estimate','2025-02-17 14:40:32','2a09:bac3:61c3:28::4:302'),(460,169,'estimate','2025-04-05 09:56:52','2a09:bac2:779d:1246::1d2:24'),(461,185,'estimate','2025-04-05 09:57:07','2a09:bac2:779d:1246::1d2:24'),(462,169,'estimate','2025-04-07 10:47:24','2a09:bac2:66c7:1250::1d3:b'),(463,1140,'invoice','2025-05-19 06:06:28','103.227.66.196'),(464,166,'estimate','2025-07-02 10:00:33','203.12.12.129'),(465,1155,'invoice','2025-07-11 13:40:26','2a01:111:f403:7060::5'),(466,1153,'invoice','2025-07-11 13:41:04','2a01:111:f403:7138::5'),(467,1152,'invoice','2025-07-11 13:41:22','2a01:111:f403:7138::5'),(468,1156,'invoice','2025-07-11 13:41:39','2a01:111:f403:7005::100'),(469,1154,'invoice','2025-07-11 13:41:54','2a01:111:f403:7005::100'),(470,1157,'invoice','2025-07-11 13:43:09','2a01:111:f403:7005::100'),(471,1158,'invoice','2025-07-11 13:43:22','2a01:111:f403:7060::5'),(472,1162,'invoice','2025-07-11 13:47:29','2a01:111:f403:7004::100'),(473,1150,'invoice','2025-07-11 13:50:47','2a01:111:f403:7060::5'),(474,203,'estimate','2025-07-13 09:23:17','103.227.66.196'),(475,1076,'invoice','2025-07-14 14:40:34','60.240.146.118'),(476,206,'estimate','2025-07-14 16:17:21','2a09:bac2:3de:24f0::3ae:6a'),(477,1163,'invoice','2025-07-14 16:18:41','2a09:bac2:3de:24f0::3ae:6a'),(478,1092,'invoice','2025-07-14 17:21:04','60.240.146.118'),(479,1092,'invoice','2025-07-14 19:53:26','60.240.146.118'),(480,208,'estimate','2025-07-15 06:40:05','180.150.38.6'),(481,1076,'invoice','2025-07-15 10:50:19','60.240.146.118'),(482,1076,'invoice','2025-07-16 13:54:14','60.240.146.118'),(483,1152,'invoice','2025-07-16 15:25:05','203.153.17.38'),(484,207,'estimate','2025-07-16 16:00:08','147.161.212.199'),(485,1076,'invoice','2025-07-17 13:46:15','60.240.146.118'),(486,207,'estimate','2025-07-24 10:16:08','103.51.113.95'),(487,210,'estimate','2025-08-04 14:23:15','2403:5812:db89:0:c142:7870:cc4d:229b'),(488,1167,'invoice','2025-08-04 14:24:51','2403:5812:db89:0:c142:7870:cc4d:229b'),(489,1167,'invoice','2025-08-09 22:16:47','2403:5812:db89:0:98a6:310a:6059:ed87'),(490,212,'estimate','2025-08-21 12:15:05','155.117.39.60'),(491,212,'estimate','2025-08-21 14:21:23','155.117.37.140'),(492,212,'estimate','2025-08-22 13:15:44','2.57.249.21'),(493,212,'estimate','2025-08-26 11:41:40','155.117.35.172'),(494,212,'estimate','2025-08-26 11:41:40','155.117.33.191'),(495,212,'estimate','2025-08-26 11:41:40','62.241.61.57'),(496,213,'estimate','2025-09-10 09:41:12','2a01:111:f403:7060::5'),(497,213,'estimate','2025-09-16 09:27:30','2a01:111:f403:7004::100'),(498,1189,'invoice','2025-09-16 09:28:05','2403:5815:9012:0:64c1:d72a:a91a:adce'),(499,1195,'invoice','2025-09-30 22:30:41','220.245.218.108'),(500,213,'estimate','2025-10-05 18:34:05','122.150.1.6'),(501,213,'estimate','2025-10-06 09:12:11','141.168.12.68'),(502,214,'estimate','2025-10-10 00:07:36','2406:2d40:69e1:4700:942f:3d0a:f6a8:6cfd'),(503,1204,'invoice','2025-10-10 00:08:07','2406:2d40:69e1:4700:942f:3d0a:f6a8:6cfd'),(504,215,'estimate','2025-10-14 14:23:53','2403:5815:9012:0:fd45:a641:22e:6aa3'),(505,216,'estimate','2025-10-18 15:00:05','144.139.237.104'),(506,1207,'invoice','2025-10-18 15:00:43','144.139.237.104'),(507,1206,'invoice','2025-10-23 09:55:42','2001:8004:52e0:3f17:348f:cbaa:5bd2:3fc4'),(508,1206,'invoice','2025-10-23 10:56:04','2403:5815:9012:0:b87b:5f86:9534:e0e7'),(509,217,'estimate','2025-10-25 06:54:51','2a00:63c1:10:29::2'),(510,217,'estimate','2025-10-25 06:54:51','2604:a880:0:202a::6ba9:c000'),(511,218,'estimate','2025-10-25 06:54:57','43.245.155.49'),(512,218,'estimate','2025-11-05 20:51:08','116.91.213.246'),(513,1209,'invoice','2025-11-05 21:06:03','2001:8003:5475:f700:2d94:895a:90d2:96c6'),(514,1215,'invoice','2025-11-12 08:37:19','122.150.1.5'),(515,218,'estimate','2025-11-25 16:49:04','2001:8004:6b41:52d5:e14f:1956:1568:292d'),(516,218,'estimate','2025-11-25 22:03:23','2001:8003:464c:7b00:2d57:1e4c:5c7b:b86b'),(517,1209,'invoice','2025-11-25 22:03:23','2a01:111:f403:7005::100'),(518,212,'estimate','2026-01-12 11:10:27','155.117.35.168'),(519,212,'estimate','2026-01-20 09:59:42','185.254.107.164'),(520,212,'estimate','2026-01-20 14:57:45','155.117.39.210'),(521,222,'estimate','2026-02-02 16:19:52','2403:4800:39b2:3700:9406:5127:a9b:967c'),(522,1280,'invoice','2026-02-02 16:32:59','2403:4800:39b2:3700:9406:5127:a9b:967c'),(523,228,'estimate','2026-02-14 11:31:49','115.70.83.50'),(524,218,'estimate','2026-02-14 12:10:40','2001:8004:6fd0:6e29:6124:8044:b25e:d22c'),(525,1280,'invoice','2026-02-16 16:47:50','66.249.83.132'),(526,228,'estimate','2026-02-17 10:08:36','203.219.219.133');

--
-- Table structure for table `tblware_body_type`
--

CREATE TABLE `tblware_body_type` (
  `body_type_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `body_code` varchar(100) DEFAULT NULL,
  `body_name` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  PRIMARY KEY (`body_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblware_body_type`
--


--
-- Table structure for table `tblware_color`
--

CREATE TABLE `tblware_color` (
  `color_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `color_code` varchar(100) DEFAULT NULL,
  `color_name` varchar(100) DEFAULT NULL,
  `color_hex` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  PRIMARY KEY (`color_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblware_color`
--


--
-- Table structure for table `tblware_commodity_type`
--

CREATE TABLE `tblware_commodity_type` (
  `commodity_type_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `commondity_code` varchar(100) DEFAULT NULL,
  `commondity_name` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  PRIMARY KEY (`commodity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblware_commodity_type`
--


--
-- Table structure for table `tblware_size_type`
--

CREATE TABLE `tblware_size_type` (
  `size_type_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `size_code` varchar(100) DEFAULT NULL,
  `size_name` text DEFAULT NULL,
  `size_symbol` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  PRIMARY KEY (`size_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblware_size_type`
--


--
-- Table structure for table `tblware_style_type`
--

CREATE TABLE `tblware_style_type` (
  `style_type_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `style_code` varchar(100) DEFAULT NULL,
  `style_barcode` text DEFAULT NULL,
  `style_name` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  PRIMARY KEY (`style_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblware_style_type`
--


--
-- Table structure for table `tblware_unit_type`
--

CREATE TABLE `tblware_unit_type` (
  `unit_type_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `unit_code` varchar(100) DEFAULT NULL,
  `unit_name` text DEFAULT NULL,
  `unit_symbol` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  PRIMARY KEY (`unit_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblware_unit_type`
--


--
-- Table structure for table `tblwarehouse`
--

CREATE TABLE `tblwarehouse` (
  `warehouse_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `warehouse_code` varchar(100) DEFAULT NULL,
  `warehouse_name` text DEFAULT NULL,
  `warehouse_address` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `state` text DEFAULT NULL,
  `zip_code` text DEFAULT NULL,
  `country` text DEFAULT NULL,
  PRIMARY KEY (`warehouse_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwarehouse`
--


--
-- Table structure for table `tblweb_to_lead`
--

CREATE TABLE `tblweb_to_lead` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `form_key` varchar(32) NOT NULL,
  `lead_source` int(11) NOT NULL,
  `lead_status` int(11) NOT NULL,
  `notify_lead_imported` int(11) NOT NULL DEFAULT 1,
  `notify_type` varchar(20) DEFAULT NULL,
  `notify_ids` mediumtext DEFAULT NULL,
  `responsible` int(11) NOT NULL DEFAULT 0,
  `name` varchar(400) NOT NULL,
  `form_data` mediumtext DEFAULT NULL,
  `recaptcha` int(11) NOT NULL DEFAULT 0,
  `submit_btn_name` varchar(40) DEFAULT NULL,
  `submit_btn_text_color` varchar(10) DEFAULT '#ffffff',
  `submit_btn_bg_color` varchar(10) DEFAULT '#84c529',
  `success_submit_msg` text DEFAULT NULL,
  `submit_action` int(2) DEFAULT 0,
  `lead_name_prefix` varchar(255) DEFAULT NULL,
  `submit_redirect_url` mediumtext DEFAULT NULL,
  `language` varchar(40) DEFAULT NULL,
  `allow_duplicate` int(11) NOT NULL DEFAULT 1,
  `mark_public` int(11) NOT NULL DEFAULT 0,
  `track_duplicate_field` varchar(20) DEFAULT NULL,
  `track_duplicate_field_and` varchar(20) DEFAULT NULL,
  `create_task_on_duplicate` int(11) NOT NULL DEFAULT 0,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblweb_to_lead`
--


--
-- Table structure for table `tblwh_activity_log`
--

CREATE TABLE `tblwh_activity_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `staffid` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblwh_activity_log`
--


--
-- Table structure for table `tblwh_approval_details`
--

CREATE TABLE `tblwh_approval_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `staffid` varchar(45) DEFAULT NULL,
  `approve` varchar(45) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `approve_action` varchar(255) DEFAULT NULL,
  `reject_action` varchar(255) DEFAULT NULL,
  `approve_value` varchar(255) DEFAULT NULL,
  `reject_value` varchar(255) DEFAULT NULL,
  `staff_approve` int(11) DEFAULT NULL,
  `action` varchar(45) DEFAULT NULL,
  `sender` int(11) DEFAULT NULL,
  `date_send` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblwh_approval_details`
--


--
-- Table structure for table `tblwh_approval_setting`
--

CREATE TABLE `tblwh_approval_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `related` varchar(255) NOT NULL,
  `setting` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblwh_approval_setting`
--


--
-- Table structure for table `tblwh_brand`
--

CREATE TABLE `tblwh_brand` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_brand`
--


--
-- Table structure for table `tblwh_custom_fields`
--

CREATE TABLE `tblwh_custom_fields` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `custom_fields_id` int(11) DEFAULT NULL,
  `warehouse_id` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_custom_fields`
--


--
-- Table structure for table `tblwh_goods_delivery_activity_log`
--

CREATE TABLE `tblwh_goods_delivery_activity_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `rel_id` int(11) DEFAULT NULL,
  `rel_type` varchar(100) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `additional_data` text DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `staffid` int(11) DEFAULT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_goods_delivery_activity_log`
--


--
-- Table structure for table `tblwh_inventory_serial_numbers`
--

CREATE TABLE `tblwh_inventory_serial_numbers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commodity_id` int(11) NOT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `inventory_manage_id` int(11) DEFAULT NULL,
  `serial_number` varchar(255) DEFAULT NULL,
  `is_used` varchar(20) DEFAULT 'no',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_inventory_serial_numbers`
--


--
-- Table structure for table `tblwh_loss_adjustment`
--

CREATE TABLE `tblwh_loss_adjustment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(15) DEFAULT NULL,
  `addfrom` int(11) DEFAULT NULL,
  `reason` longtext DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `date_create` date NOT NULL,
  `status` int(11) NOT NULL,
  `warehouses` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_loss_adjustment`
--


--
-- Table structure for table `tblwh_loss_adjustment_detail`
--

CREATE TABLE `tblwh_loss_adjustment_detail` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `items` int(11) DEFAULT NULL,
  `unit` int(11) DEFAULT NULL,
  `current_number` int(15) DEFAULT NULL,
  `updates_number` int(15) DEFAULT NULL,
  `loss_adjustment` int(11) DEFAULT NULL,
  `expiry_date` text DEFAULT NULL,
  `lot_number` text DEFAULT NULL,
  `commodity_name` text DEFAULT NULL,
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_loss_adjustment_detail`
--


--
-- Table structure for table `tblwh_model`
--

CREATE TABLE `tblwh_model` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  `brand_id` int(11) NOT NULL,
  PRIMARY KEY (`id`,`brand_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_model`
--


--
-- Table structure for table `tblwh_omni_shipments`
--

CREATE TABLE `tblwh_omni_shipments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cart_id` int(11) DEFAULT NULL,
  `shipment_number` varchar(100) DEFAULT NULL,
  `planned_shipping_date` datetime DEFAULT NULL,
  `shipment_status` varchar(50) DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `goods_delivery_id` int(11) DEFAULT NULL,
  `shipment_hash` varchar(32) DEFAULT NULL,
  `order_id` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_omni_shipments`
--


--
-- Table structure for table `tblwh_order_return_details`
--

CREATE TABLE `tblwh_order_return_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_return_id` int(11) NOT NULL,
  `rel_type_detail_id` int(11) DEFAULT NULL,
  `commodity_code` int(11) DEFAULT NULL,
  `commodity_name` text DEFAULT NULL,
  `quantity` decimal(15,2) DEFAULT 0.00,
  `unit_id` int(11) DEFAULT NULL,
  `unit_price` decimal(15,2) DEFAULT 0.00,
  `sub_total` decimal(15,2) DEFAULT 0.00,
  `tax_id` text DEFAULT NULL,
  `tax_rate` text DEFAULT NULL,
  `tax_name` text DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT 0.00,
  `discount` decimal(15,2) DEFAULT 0.00,
  `discount_total` decimal(15,2) DEFAULT 0.00,
  `total_after_discount` decimal(15,2) DEFAULT 0.00,
  `reason_return` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_order_return_details`
--


--
-- Table structure for table `tblwh_order_returns`
--

CREATE TABLE `tblwh_order_returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rel_id` int(11) DEFAULT NULL,
  `rel_type` varchar(50) NOT NULL COMMENT 'manual, sales_return_order, purchasing_return_order',
  `return_type` varchar(50) DEFAULT NULL COMMENT 'manual, partially, fully',
  `company_id` int(11) DEFAULT NULL,
  `company_name` varchar(500) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phonenumber` varchar(20) DEFAULT NULL,
  `order_number` varchar(500) DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `number_of_item` decimal(15,2) DEFAULT 0.00,
  `order_total` decimal(15,2) DEFAULT 0.00,
  `order_return_number` varchar(200) DEFAULT NULL,
  `order_return_name` varchar(500) DEFAULT NULL,
  `fee_return_order` decimal(15,2) DEFAULT 0.00,
  `refund_loyaty_point` int(11) DEFAULT 0,
  `subtotal` decimal(15,2) DEFAULT 0.00,
  `total_amount` decimal(15,2) DEFAULT 0.00,
  `discount_total` decimal(15,2) DEFAULT 0.00,
  `additional_discount` decimal(15,2) DEFAULT 0.00,
  `adjustment_amount` decimal(15,2) DEFAULT 0.00,
  `total_after_discount` decimal(15,2) DEFAULT 0.00,
  `return_policies_information` text DEFAULT NULL,
  `admin_note` text DEFAULT NULL,
  `approval` int(11) DEFAULT 0,
  `datecreated` datetime DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `currency` int(11) DEFAULT NULL,
  `receipt_delivery_id` int(1) DEFAULT 0,
  `return_reason` longtext DEFAULT NULL,
  `status` varchar(30) DEFAULT 'draft',
  `receipt_delivery_type` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_order_returns`
--


--
-- Table structure for table `tblwh_order_returns_refunds`
--

CREATE TABLE `tblwh_order_returns_refunds` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_return_id` int(11) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `refunded_on` date DEFAULT NULL,
  `payment_mode` varchar(40) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_order_returns_refunds`
--


--
-- Table structure for table `tblwh_packing_list_details`
--

CREATE TABLE `tblwh_packing_list_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `packing_list_id` int(11) NOT NULL,
  `delivery_detail_id` int(11) DEFAULT NULL,
  `commodity_code` int(11) DEFAULT NULL,
  `commodity_name` text DEFAULT NULL,
  `quantity` decimal(15,2) DEFAULT 0.00,
  `unit_id` int(11) DEFAULT NULL,
  `unit_price` decimal(15,2) DEFAULT 0.00,
  `sub_total` decimal(15,2) DEFAULT 0.00,
  `tax_id` text DEFAULT NULL,
  `tax_rate` text DEFAULT NULL,
  `tax_name` text DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT 0.00,
  `discount` decimal(15,2) DEFAULT 0.00,
  `discount_total` decimal(15,2) DEFAULT 0.00,
  `total_after_discount` decimal(15,2) DEFAULT 0.00,
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_packing_list_details`
--


--
-- Table structure for table `tblwh_packing_lists`
--

CREATE TABLE `tblwh_packing_lists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `delivery_note_id` int(11) DEFAULT NULL,
  `packing_list_number` varchar(100) DEFAULT NULL,
  `packing_list_name` varchar(200) DEFAULT NULL,
  `width` decimal(15,2) DEFAULT 0.00,
  `height` decimal(15,2) DEFAULT 0.00,
  `lenght` decimal(15,2) DEFAULT 0.00,
  `weight` decimal(15,2) DEFAULT 0.00,
  `volume` decimal(15,2) DEFAULT 0.00,
  `clientid` int(11) DEFAULT NULL,
  `subtotal` decimal(15,2) DEFAULT 0.00,
  `total_amount` decimal(15,2) DEFAULT 0.00,
  `discount_total` decimal(15,2) DEFAULT 0.00,
  `additional_discount` decimal(15,2) DEFAULT 0.00,
  `total_after_discount` decimal(15,2) DEFAULT 0.00,
  `billing_street` varchar(200) DEFAULT NULL,
  `billing_city` varchar(100) DEFAULT NULL,
  `billing_state` varchar(100) DEFAULT NULL,
  `billing_zip` varchar(100) DEFAULT NULL,
  `billing_country` int(11) DEFAULT NULL,
  `shipping_street` varchar(200) DEFAULT NULL,
  `shipping_city` varchar(100) DEFAULT NULL,
  `shipping_state` varchar(100) DEFAULT NULL,
  `shipping_zip` varchar(100) DEFAULT NULL,
  `shipping_country` int(11) DEFAULT NULL,
  `client_note` text DEFAULT NULL,
  `admin_note` text DEFAULT NULL,
  `approval` int(11) DEFAULT 0,
  `datecreated` datetime DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `type_of_packing_list` varchar(100) DEFAULT 'total',
  `delivery_status` varchar(100) DEFAULT 'wh_ready_to_deliver',
  `shipping_fee` decimal(15,2) DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_packing_lists`
--


--
-- Table structure for table `tblwh_series`
--

CREATE TABLE `tblwh_series` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  `model_id` int(11) NOT NULL,
  PRIMARY KEY (`id`,`model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_series`
--


--
-- Table structure for table `tblwh_sub_group`
--

CREATE TABLE `tblwh_sub_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sub_group_code` varchar(100) DEFAULT NULL,
  `sub_group_name` text DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwh_sub_group`
--


--
-- Table structure for table `tblwoocommerce_customers`
--

CREATE TABLE `tblwoocommerce_customers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `woo_customer_id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `email` varchar(190) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `role` varchar(50) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `avatar_url` text DEFAULT NULL,
  `store_id` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwoocommerce_customers`
--


--
-- Table structure for table `tblwoocommerce_orders`
--

CREATE TABLE `tblwoocommerce_orders` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `order_number` varchar(50) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `address` text DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `date_created` date DEFAULT NULL,
  `date_modified` date DEFAULT NULL,
  `total` varchar(30) DEFAULT NULL,
  `invoice_id` int(30) DEFAULT NULL,
  `store_id` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwoocommerce_orders`
--

INSERT INTO `tblwoocommerce_orders` VALUES (1,27692,'27692',1,'45 Phillip RD, Woori Yallock, VIC, AU','0424661413','completed','AUD','2019-07-29','2019-07-29','3.30',NULL,1),(2,27689,'27689',1,'45 Phillip RD, Woori Yallock, VIC, AU','0424661413','completed','AUD','2019-07-29','2019-07-29','3.30',NULL,1),(3,27686,'27686',1,'45 Phillip RD, Woori Yallock, VIC, AU','0424661413','completed','AUD','2019-07-29','2019-07-29','3.30',NULL,1),(4,27682,'27682',0,'6 Lara way campbellfield, Campbellfield, VIC, AU','0415595025','failed','AUD','2019-07-29','2019-07-29','14967.77',NULL,1),(5,34294,'34294',12,'8 Catherine place, Croydon Hills, VIC, AU','0400519305','completed','AUD','2020-04-27','2020-06-10','1732.06',NULL,1),(6,34091,'34091',4,'45 Phillip Road, Woori Yallock, VIC, AU','424661413','cancelled','AUD','2020-04-20','2020-04-28','2984.19',NULL,1),(7,33959,'33959',4,'45 Phillip Road, Woori Yallock, VIC, AU','424661413','cancelled','AUD','2020-04-17','2020-04-17','2984.19',NULL,1),(8,33958,'33958',4,'45 Phillip Road, Woori Yallock, VIC, AU','424661413','cancelled','AUD','2020-04-17','2020-04-17','2984.19',NULL,1),(9,33926,'33926',0,'21a Baker Street, Lilydale, VIC, AU','0424661413','cancelled','AUD','2020-04-09','2020-04-09','132.00',NULL,1),(10,33879,'33879',0,'21A Baker Street, Lilydale, VIC, AU','0422748068','completed','AUD','2020-04-05','2020-04-08','3.30',NULL,1),(11,33878,'33878',0,'45 Phillip Road, Woori Yalloc, VIC, AU','+44424661413','completed','AUD','2020-04-05','2020-04-08','3.30',NULL,1),(12,33877,'33877',0,'45 Phillip Road, Woori Yalloc, VIC, AU','+44424661413','completed','AUD','2020-04-05','2020-04-08','3.30',NULL,1),(13,34823,'34823',14,'433 Dorset Road, Croydon, VIC, AU','0388204003','completed','AUD','2020-06-16','2020-06-16','3.00',NULL,1),(14,34822,'34822',14,'433 Dorset Road, Croydon, VIC, AU','0388204003','completed','AUD','2020-06-16','2020-06-16','3.00',NULL,1);

--
-- Table structure for table `tblwoocommerce_products`
--

CREATE TABLE `tblwoocommerce_products` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `itemid` int(11) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `permalink` varchar(500) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `sku` varchar(50) DEFAULT NULL,
  `price` varchar(20) DEFAULT NULL,
  `sales` varchar(20) DEFAULT NULL,
  `picture` text DEFAULT NULL,
  `category` text DEFAULT NULL,
  `date_created` date DEFAULT NULL,
  `date_modified` date DEFAULT NULL,
  `store_id` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwoocommerce_products`
--

INSERT INTO `tblwoocommerce_products` VALUES (1,31067,NULL,'','https://www.veekenplumbing.com.au/?post_type=product&p=31067','simple','draft','','','0','','[{\"id\":235,\"name\":\"Uncategorised\",\"slug\":\"uncategorised\"}]',NULL,NULL,1),(2,27685,NULL,'test','https://www.veekenplumbing.com.au/?post_type=product&p=27685','simple','draft','','3','3','','[{\"id\":235,\"name\":\"Uncategorised\",\"slug\":\"uncategorised\"}]','2019-07-29',NULL,1),(3,27042,NULL,'Installation 13-14.7kW Split System Cassette Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-13-14-7kw-split-system-cassette-air-conditioning-reverse-cycle/','simple','publish','','','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(4,27041,NULL,'Installation 11-12.7kW Split System Cassette Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-11-12-7kw-split-system-cassette-air-conditioning-reverse-cycle/','simple','publish','','','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(5,27040,NULL,'Installation 8.9-10.5kW Split System Cassette Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-8-9-10-5kw-split-system-cassette-air-conditioning-reverse-cycle/','simple','publish','','','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(6,27039,NULL,'Installation <8kW Split System Cassette Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation/','simple','publish','','','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(7,27038,NULL,'Installation Back to Back 9-10kW Split System Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-back-to-back-9-10kw-split-system-air-conditioning-reverse-cycle/','simple','publish','','1598.21','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(8,27037,NULL,'Installation Back to Back 8-8.9kW Split System Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-back-to-back-8-8-9kw-split-system-air-conditioning-reverse-cycle/','simple','publish','','1444.77','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(9,27036,NULL,'Installation Back to Back 6.9-7.9kW Split System Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-back-to-back-6-9-7-9kw-split-system-air-conditioning-reverse-cycle/','simple','publish','','1155.46','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(10,27035,NULL,'Installation Back to Back 5.9-6.7kW Split System Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-back-to-back-5-9-6-7kw-split-system-air-conditioning-reverse-cycle/','simple','publish','','1078.21','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(11,27034,NULL,'Installation Back to Back 4-5.7kW Split System Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-back-to-back-4-5-7kw-split-system-air-conditioning-reverse-cycle/','simple','publish','','967.45','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(12,27033,NULL,'Installation Back to Back 1-3.7kW Split System Air Conditioning Reverse Cycle','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/installation-back-to-back-1-3-7kw-split-system-air-conditioning-reverse-cycle/','simple','publish','','889.55','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/AirConditionerRepairs-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":200,\"name\":\"Installation\",\"slug\":\"installation\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(13,27032,NULL,'14kW Mitsubishi Heavy Industries Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/14kw-mitsubishi-heavy-industries-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','5238.71','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-cassette-set-fdt140avnxvf-14.0kw-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(14,27031,NULL,'12.5kW Mitsubishi Heavy Industries Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/12-5kw-mitsubishi-heavy-industries-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','4752.55','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-cassette-set-fdt125avnxvf-12.5kw-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(15,27030,NULL,'10kW Mitsubishi Heavy Industries Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/cassette/10kw-mitsubishi-heavy-industries-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','3862.31','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-cassette-set-fdt100avnvf-10.0kw-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"}]','2017-09-05',NULL,1),(16,27029,NULL,'7.1kW Mitsubishi Heavy Industries Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/7-1kw-mitsubishi-heavy-industries-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','3639.38','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-cassette-set-fdt71avnxvf-7.1kw-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(17,27028,NULL,'6.0kW Mitsubishi Heavy Industries Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/6-0kw-mitsubishi-heavy-industries-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','2638.31','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-cassette-set-fdt60zmxavf-6.0kw-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(18,27027,NULL,'9.2kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/9-2kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','2899.05','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-9.2kw-dxk32zma-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(19,27026,NULL,'8.0kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/8-0kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','2249.01','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-8.0kw-dxk28zma-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(20,27025,NULL,'7.1kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/7-1kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','1715.01','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-7.1kw-dxk24zma-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(21,27024,NULL,'6.3kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/6-3kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','1649.01','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-6.3kw-dxk21zma-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(22,27023,NULL,'5.0kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/5-0kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','1339.03','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-5.0kw-dxk18zma-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(23,27022,NULL,'3.5kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/3-5kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','1009.09','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-3.5kw-dxk12zma-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(24,27021,NULL,'2.5kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/2-5kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','855.03','1','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-2.5kw-dxk09zma-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(25,27020,NULL,'2kW Mitsubishi Heavy Industries Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/mitsubishi/mitsubishi-wall/2kw-mitsubishi-heavy-industries-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','766.65','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/mitsubishi-heavy-industries-mhi-whs-2.0kw-dxk06zm-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":195,\"name\":\"Mitsubishi\",\"slug\":\"mitsubishi\"},{\"id\":359,\"name\":\"mitsubishi wall\",\"slug\":\"mitsubishi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(26,27019,NULL,'12kW Hitachi Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/12kw-hitachi-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','5055.82','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/Hitachi-HITACHI-CASSETTE-INV-R410A-1PH-12.5KW-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(27,27018,NULL,'10kW Hitachi Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/10kw-hitachi-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','4523.59','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/Hitachi-HITACHI-CASSETTE-INV-R410A-1PH-10.0KW-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(28,27017,NULL,'7kW Hitachi Cassette Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/split-systems/7kw-hitachi-cassette-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','3778.56','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/Hitachi-HITACHI-CASSETTE-INV-R410A-1PH-7.1KW-1.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":194,\"name\":\"Cassette\",\"slug\":\"cassette\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"}]','2017-09-05',NULL,1),(29,27016,NULL,'8kW Hitachi Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/hitachi/hitachi-wall/8kw-hitachi-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','2034.37','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/hitachi-inverter-wall-split-1ph-2.5kw-indoor-outdoor.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":357,\"name\":\"Hitachi Wall\",\"slug\":\"hitachi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(30,27015,NULL,'7kW Hitachi Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/hitachi/hitachi-wall/7kw-hitachi-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','1645.39','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/hitachi-inverter-wall-split-1ph-2.5kw-indoor-outdoor.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":357,\"name\":\"Hitachi Wall\",\"slug\":\"hitachi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(31,27014,NULL,'6kW Hitachi Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/hitachi/hitachi-wall/6kw-hitachi-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','1447.27','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/hitachi-inverter-wall-split-1ph-2.5kw-indoor-outdoor.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":357,\"name\":\"Hitachi Wall\",\"slug\":\"hitachi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(32,27013,NULL,'5kW Split System Inverter Air Conditioner Reverse Cycle Hitachi','https://www.veekenplumbing.com.au/shop/air-conditioning/hitachi/hitachi-wall/5kw-split-system-inverter-air-conditioner-reverse-cycle-hitachi/','simple','publish','','1273.23','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/hitachi-inverter-wall-split-1ph-2.5kw-indoor-outdoor.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":357,\"name\":\"Hitachi Wall\",\"slug\":\"hitachi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(33,27012,NULL,'Aquamax 390 Stainless Steel Gas Storage Hot Water System','https://www.veekenplumbing.com.au/shop/hot-water-systems/gas-storage-hot-water/aquamax-390-stainless-steel-gas-storage-hot-water-system/','simple','publish','','1131.6','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/Aquamax390ss.png','[{\"id\":107,\"name\":\"Gas Storage Hot Water\",\"slug\":\"gas-storage-hot-water\"},{\"id\":98,\"name\":\"Hot Water Systems\",\"slug\":\"hot-water-systems\"}]','2017-09-05',NULL,1),(34,27011,NULL,'Thermann 135L Gas Storage Hot Hater System','https://www.veekenplumbing.com.au/shop/hot-water-systems/gas-storage-hot-water/thermann-135l-gas-storage-hot-hater-system/','simple','publish','','905.41','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/Thermann-gas-storage-hot-water.png','[{\"id\":107,\"name\":\"Gas Storage Hot Water\",\"slug\":\"gas-storage-hot-water\"},{\"id\":98,\"name\":\"Hot Water Systems\",\"slug\":\"hot-water-systems\"}]','2017-09-05',NULL,1),(35,27010,NULL,'Thermann Gas Continuous Flow 6 Star Hot Water System','https://www.veekenplumbing.com.au/shop/hot-water-systems/continuous-flow/thermann-gas-continuous-flow-6-star-hot-water-system/','simple','publish','','1132','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/Thermann-6-Star.png','[{\"id\":106,\"name\":\"Continuous Flow\",\"slug\":\"continuous-flow\"},{\"id\":98,\"name\":\"Hot Water Systems\",\"slug\":\"hot-water-systems\"}]','2017-09-05',NULL,1),(36,27009,NULL,'3.5kW Hitachi Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/hitachi/hitachi-wall/3-5kw-hitachi-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','925.82','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/hitachi-inverter-wall-split-1ph-2.5kw-indoor-outdoor.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":357,\"name\":\"Hitachi Wall\",\"slug\":\"hitachi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1),(37,27008,NULL,'2.5kW Hitachi Reverse Cycle Inverter Split System Air Conditioner','https://www.veekenplumbing.com.au/shop/air-conditioning/hitachi/hitachi-wall/2-5kw-hitachi-reverse-cycle-inverter-split-system-air-conditioner/','simple','publish','','773.63','0','https://www.veekenplumbing.com.au/wp-content/uploads/2017/09/hitachi-inverter-wall-split-1ph-2.5kw-indoor-outdoor.jpg','[{\"id\":78,\"name\":\"Air Conditioning\",\"slug\":\"air-conditioning\"},{\"id\":196,\"name\":\"Hitachi\",\"slug\":\"hitachi\"},{\"id\":357,\"name\":\"Hitachi Wall\",\"slug\":\"hitachi-wall\"},{\"id\":103,\"name\":\"Split Systems\",\"slug\":\"split-systems\"},{\"id\":207,\"name\":\"Wall Hung\",\"slug\":\"wall-hung\"}]','2017-09-05',NULL,1);

--
-- Table structure for table `tblwoocommerce_summary`
--

CREATE TABLE `tblwoocommerce_summary` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(5) DEFAULT NULL,
  `customers` text DEFAULT NULL,
  `orders` text DEFAULT NULL,
  `products` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwoocommerce_summary`
--

INSERT INTO `tblwoocommerce_summary` VALUES (1,1,'[{\"slug\":\"paying\",\"name\":\"Paying customer\",\"total\":2},{\"slug\":\"non_paying\",\"name\":\"Non-paying customer\",\"total\":8}]','[{\"slug\":\"pending\",\"name\":\"Pending payment\",\"total\":0},{\"slug\":\"processing\",\"name\":\"Processing\",\"total\":0},{\"slug\":\"transporting\",\"name\":\"Transporting\",\"total\":0},{\"slug\":\"ready-for-pickup\",\"name\":\"Ready for pickup\",\"total\":0},{\"slug\":\"on-hold\",\"name\":\"On hold\",\"total\":0},{\"slug\":\"completed\",\"name\":\"Completed\",\"total\":9},{\"slug\":\"cancelled\",\"name\":\"Cancelled\",\"total\":4},{\"slug\":\"refunded\",\"name\":\"Refunded\",\"total\":0},{\"slug\":\"failed\",\"name\":\"Failed\",\"total\":1}]','[{\"slug\":\"auction\",\"name\":\"Auction\",\"total\":0},{\"slug\":\"external\",\"name\":\"External\\/Affiliate product\",\"total\":0},{\"slug\":\"grouped\",\"name\":\"Grouped product\",\"total\":0},{\"slug\":\"simple\",\"name\":\"Simple product\",\"total\":46},{\"slug\":\"variable\",\"name\":\"Variable product\",\"total\":0}]');

--
-- Table structure for table `tblwork_shift`
--

CREATE TABLE `tblwork_shift` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shift_code` varchar(45) NOT NULL,
  `shift_name` varchar(200) NOT NULL,
  `shift_type` varchar(200) NOT NULL,
  `department` varchar(45) DEFAULT NULL,
  `position` varchar(45) DEFAULT NULL,
  `add_from` int(11) NOT NULL,
  `staff` text DEFAULT NULL,
  `date_create` date DEFAULT NULL,
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `shifts_detail` text NOT NULL,
  `type_shiftwork` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwork_shift`
--


--
-- Table structure for table `tblwork_shift_detail`
--

CREATE TABLE `tblwork_shift_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `shift_id` int(11) DEFAULT NULL,
  `work_shift_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwork_shift_detail`
--


--
-- Table structure for table `tblwork_shift_detail_day_name`
--

CREATE TABLE `tblwork_shift_detail_day_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) DEFAULT NULL,
  `day_name` varchar(45) DEFAULT NULL,
  `shift_id` int(11) DEFAULT NULL,
  `work_shift_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwork_shift_detail_day_name`
--


--
-- Table structure for table `tblwork_shift_detail_number_day`
--

CREATE TABLE `tblwork_shift_detail_number_day` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `shift_id` int(11) DEFAULT NULL,
  `work_shift_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tblwork_shift_detail_number_day`
--



