INSERT INTO `tblsessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('d1fd6251776c54c9d9a39f2ad3e17647bf092859', '64.225.76.151', 1741370878, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313337303837383b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('d27da3e101f36f89ec01a2646ebb4dbca1282d2f', '59.132.61.98', 1741201200, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230313230303b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d2cc8aeab4884fdc6b424eaa3a0303267cdd821d', '210.87.64.40', 1743040313, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333034303331333b5f707265765f75726c7c733a34333a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f73657474696e6773223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b),
('d33e6fa635461246fc9871b5443ceafd6cd6b33c', '175.107.212.77', 1742821409, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323832313338393b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b),
('d36598a15e8f15da8318d7859fc7d1e91ef5e93a', '91.84.87.137', 1741374171, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313337343137313b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d3a59355ec5a4cdc632005f404707f0d9882dd42', '159.65.202.209', 1741423632, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313432333633323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d3dec96b2f2ccdf07deebeb67cf1c04d1619dd8f', '167.94.138.36', 1741794125, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313739343132343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d3e4a9d0a72480c53e4015b9d1b506bb36c3a4a7', '24.199.104.108', 1743936604, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333933363630343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d48142afaeb34031334556ee1a273d974c4a44db', '37.120.233.28', 1741200756, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303735363b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d49c1911843f4d54041e33532172581dd9399c31', '167.94.145.102', 1745246856, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734353234363835363b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d4d137fdf94d11db99ddfd9a65095a698044d0c1', '204.101.161.19', 1741297167, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239373133323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('d4df5b8082663021a94cb0ddf36c55c497ab768f', '91.84.87.137', 1741200678, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303637383b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d528fb7100084a330ca0fe5e56e82602f40c1bea', '210.87.64.56', 1744390473, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343339303435323b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2232223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b),
('d534ffb66f7cd2dda05e18da4daaffbcb344738b', '167.94.138.200', 1741293643, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239333634323b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('d56c3f1bd36057b372ee87c33017b1c759faf746', '167.94.138.200', 1741293627, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239333632363b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d587d85125375ab00dc8e39d92b8713687f880de', '175.107.212.77', 1741351424, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313335313432343b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f7374616666223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b),
('d5da317d137134c7a0ccc2b48a6b99275b7d56a6', '188.165.87.96', 1741291331, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239313333313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d77bcd9c46f8ce4629ae70d433875402ea6c409c', '34.243.49.17', 1744046385, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343034363338323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d79f59b2e0e972946743a8b166fcc32d270841c8', '164.90.203.37', 1741423133, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313432333133323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d7c6ecb08d40c0a5410ff3405c5144d118167bcf', '44.200.39.86', 1744153412, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343135333431323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d83472d249644d90f393e6ce371e0e12d8be48fe', '195.191.219.130', 1744138616, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343133383631363b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('d8581a76b5a583d5529e694eefe9a92c122006d0', '209.188.21.134', 1741239280, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313233393238303b),
('d8b9ebdffcf84a99b75fe406451463673c5ebba5', '58.251.94.154', 1741301941, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313330313934303b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d9257803e4c732f7ff7c3579bc91ef70d0386f02', '123.6.49.47', 1741303107, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313330333130363b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('d96061ec7cff695114dd569ee355d2acf0abc02f', '135.148.100.196', 1741877945, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313837373934353b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d99a78072c1bd1e063cad6d62921ed58e30e5304', '3.238.147.168', 1744153413, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343135333431333b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('d9ac3331904318a984e9118747a60111a51f1af7', '209.188.21.134', 1744279254, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343237393235333b),
('d9b5f6ef777f9f49618803c862d2e65a827de650', '142.93.35.248', 1742606880, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323630363837393b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('da06aa9ea301d981cb562826b903ff22d300c8e2', '85.237.194.64', 1741312374, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313331323336383b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('da9ed445877d313b068d70e9ddbe7ad9453328b5', '2.56.191.84', 1741287880, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238373837373b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('dab03543379ef761a996e181ecfdd29e81b5d9ce', '104.152.52.71', 1743178599, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333137383539383b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('dadb16345c06353edfcdb948c78927a40ed5ee5e', '147.185.132.91', 1742957813, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323935373831323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('db14d966952b58f091d4cbdd40e4fb28cadc27e7', '146.190.197.169', 1741200788, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303738383b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('db523fa908a6d8f8f75d9a45b202809041faf723', '209.188.21.134', 1743268914, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333236383931323b),
('db84cbc3df2a62da3d0c3efacbfca3d6438dda0b', '34.147.16.58', 1743648206, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333634383230343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('db874b9c6ebaa02e04cf895fcde0a40eb73e64f5', '209.188.21.134', 1743062800, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333036323739393b),
('dba9d1bbf9af0f21959ecd5569b5c2cc48fc3c95', '51.254.49.103', 1741298687, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239383638313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('dbe320c868b6b161605e44f654373e2b83a61507', '44.200.39.86', 1744153413, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343135333431333b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('dbf9c6fe0657b153d180f8456d56b4c719697d57', '210.87.64.63', 1741201195, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230313139353b5f707265765f75726c7c733a37313a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f666f726d732f77746c2f3662316563333430386434336138343432373531393562346235303365623435223b),
('dc5e78b7f15cbf3a20040201d843ebd176f887f6', '199.45.155.98', 1741250962, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313235303936323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('dcb588bb84a8652a6778d4a02920a1dae7baa32f', '5.253.115.8', 1741278870, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313237383837303b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('dd3fd2c42afdcc170994ca80099d077df8a51b02', '213.232.87.232', 1741287699, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238373639393b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('dd53152ba5b5913f1f3e3b135d3652e4cf50115c', '35.94.247.131', 1741203991, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230333939313b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ddaf66b76ae43674d9ed2d45f92de520428335b3', '205.210.31.56', 1744455434, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343435353433343b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('de055c22343fd839826b1f61315a5080e0783b6d', '91.84.87.137', 1741288304, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238383330343b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('deaec95adcb4ea2ca026df6954568264cdbeb47c', '209.188.21.134', 1744135095, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343133353039333b),
('e03516fcb6a8f5ff0a2f04545ed1e4358a934110', '119.155.195.168', 1741341899, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313334313839393b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b),
('e2d54a33fe466c960ca1333a4f32120b31f50426', '137.184.223.78', 1741532846, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313533323834363b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e2d5b67d7b978f3932aecdb822c4d7b9252be2d2', '198.235.24.133', 1744417801, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343431373830303b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e31f22ea63fdb37c8c66a91d54aa7ae36c646c31', '80.82.70.198', 1741348010, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313334383031303b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e396744a053ca9f138e07849e9cbfe0ad5372a96', '18.231.137.200', 1741259747, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313235393734343b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e3b93cc315c92b4eb657725b2934ec38c67634f4', '198.235.24.26', 1742719331, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323731393333313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('e3dc4a0cc000ad7115fc1bb160a4d5cc57b2eae5', '137.184.223.78', 1741532844, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313533323834343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('e410ae97a2a4464fe1014c035d3dd3086b2f8825', '5.9.48.126', 1741200645, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303634353b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e4a43c7ef12885b001d27d1f810bfb373d4b899b', '209.188.21.134', 1741235562, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313233353536323b),
('e4f8fddf2670899236b1038c4ed1183d06c204e7', '34.71.214.216', 1741275941, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313237353933393b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e5f1483e2a5a5fd6bf185705d23517603d07f47c', '54.71.187.124', 1741275958, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313237353935383b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e6031b1f5289b90f4f2de0788ebf7a8bd3abe0a7', '206.168.34.205', 1742558101, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323535383130313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e60836c89fcf28a3ca0b9232ee49e991102bd968', '172.111.15.144', 1741918654, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313931383635333b69735f6d6f62696c657c623a313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e69d9c5455f43b2c239faec8573a038d3d2b907f', '179.61.240.32', 1741284282, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238343238323b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e6a94f802170243bded31ae434168dbe7525a2e9', '119.155.195.168', 1741342302, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313334323330323b5f707265765f75726c7c733a34383a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f637573746f6d5f6669656c6473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b),
('e6de53c955613f7a214b8cc433478c91ea57e5c6', '136.0.100.237', 1741280492, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238303439313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('e6ee055862f2cae689aff2438c39cd3d88f18302', '131.153.165.117', 1745339861, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734353333393836313b),
('e7f8a8e218ea0f33323c54476d74882304520f9b', '206.168.34.218', 1741457304, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313435373330343b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('e7fded5da99ef4beeab50371b505edf72f485f4b', '209.188.21.134', 1742821133, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323832313133323b),
('e89b5e4ff79b0f7c7f9362bcf7ec1bdd0bf0b34d', '210.87.64.63', 1741218213, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313231383231333b5f707265765f75726c7c733a35333a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6170692f6170695f6d616e6167656d656e74223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b6c656164735f6b616e62616e5f766965777c733a353a2266616c7365223b),
('e929022da10a61081146356df0335d8261831610', '210.87.64.63', 1741215707, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313231353730373b5f707265765f75726c7c733a34323a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6d6f64756c6573223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b6c656164735f6b616e62616e5f766965777c733a353a2266616c7365223b6d6573736167652d737563636573737c733a32383a224d6f64756c652075706c6f61646564207375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31353a226d6573736167652d73756363657373223b733a333a226e6577223b7d),
('e9361481f5ea3d6e07f4b9ec047ef8a04c45e9ac', '59.132.61.224', 1741202560, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230323535393b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('e9edc3177652cbadb0846941092ef213549e3766', '175.107.212.77', 1742756311, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323735363331313b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b73657475702d6d656e752d6f70656e7c733a303a22223b6d6573736167652d737563636573737c733a32323a22546f74616c206c656164732064656c657465643a2035223b5f5f63695f766172737c613a313a7b733a31353a226d6573736167652d73756363657373223b733a333a226e6577223b7d),
('ea5bf1c42d5079a3f8b9a7d67fbd1ad0eb4bee0b', '209.188.21.134', 1742756815, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323735363831333b),
('eab373336cb72ebe6bd7104be31925cbb707a08e', '149.88.27.83', 1741215444, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313231353434343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('eb25886c5ef60fa3eaf5c1bdd74b8a9f64adb9ea', '195.191.219.130', 1744138614, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343133383631333b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('eb436115f9ac244e2be92b6f98d112e60cabfc01', '205.210.31.242', 1744676289, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343637363238383b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('eb6e084fe06e8b5c346a279839472bfdd86479ca', '205.210.31.142', 1742038729, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323033383732383b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('eb8410e01f006e7f764694709418b75c5f1a38ce', '23.27.145.23', 1741292941, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239323934303b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('eb98955fc876a2e095ff070d619f35cd77c63f0a', '210.87.64.40', 1743040748, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333034303631383b5f707265765f75726c7c733a33343a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b),
('ebab5e1b332c9f2c400415850d424f8f23962e6a', '66.70.240.179', 1741429490, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313432393439303b5f707265765f75726c7c733a35303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f6b6e6f776c656467652d626173652f736561726368223b),
('ebbed275bb2466a89d1238c6549f11e3960ad3e5', '209.188.21.134', 1742551286, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323535313238343b),
('ebde128b3b56ee2b6ba9ec87e26aba58c68dd689', '209.188.21.134', 1743307886, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333330373838353b),
('ebe712c182d043daebeb3584f7fbba16e854e8c2', '195.191.219.133', 1744673058, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343637333035383b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ec5436f39267fc65a18e52d782160bf35b41a0ac', '167.94.145.102', 1745246861, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734353234363836313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('ecb1fe5589f801bab4bc9e49c7ab44deaee67a0a', '172.111.15.48', 1741569376, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313536393337363b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ecd0ad9779a2310b514d053d20e97d2e42528aad', '59.132.250.59', 1741205390, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230353339303b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ed353394c862eeeb89acbb7537151b970da26435', '3.140.190.124', 1741586708, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313538363730373b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ed4840bd8f397eaef46237e22e0f90656b0672d5', '195.191.219.133', 1744574372, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343537343337313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('ee4fc226cb3fc6c2f3c87f0da6f1af776eff52e6', '64.23.153.150', 1741522632, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313532323633323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ee569b69eb0468f59ede698816896e28b06a7bc2', '198.235.24.67', 1741695620, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313639353631393b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ee661e7905339921a6f580954e86dd22f01ae41d', '209.188.21.134', 1743238293, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333233383239323b),
('ef3066175e260cdf9d6da9100a20e81f059269c7', '209.188.21.134', 1741236812, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313233363831303b),
('ef84b119ffc235f582afe09f075751ee667d3438', '205.210.31.22', 1742064282, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323036343238323b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f0e63af79f7976a437be27450393a0acf4ea5d77', '199.45.155.88', 1744551919, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343535313931393b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f0fc6a1a311d8de5d9341b685917a68ad738e70e', '5.62.21.143', 1741378986, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313337383938343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f152fad51db01a93882bf499824fd7be5c3423d4', '46.205.196.24', 1742866698, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323836363639373b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f18412d47c1f50ba71173da799d68f3101bf4b34', '172.111.15.113', 1742336237, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323333363233363b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f1cd5a70954f683d595ddda515eecbadef9ca68f', '157.245.70.112', 1741226878, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313232363837373b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f1ddd8aa2715d33fce99bab9e495db4c86e182cf', '175.107.212.77', 1742760276, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323736303237363b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b),
('f264da660513ce3ce8601c7e129cf5bdc05cf8dd', '91.84.87.137', 1741200679, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303637383b69735f6d6f62696c657c623a313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f2920426574add6c4ac2797d633ba5d0cc8a8ec2', '209.188.21.134', 1742657635, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323635373633343b),
('f332c79537e222b232287e714609a7f35bd2d769', '188.165.87.103', 1741291463, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239313436333b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f33627804032756a930e78199a6f2fa4e118adc8', '198.235.24.142', 1742695519, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323639353531383b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f33d8734e10460a58379fc3466113029963f41d9', '210.87.64.63', 1741203556, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230333535363b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b6c656164735f6b616e62616e5f766965777c733a353a2266616c7365223b),
('f344394f0370ea65483345d1d815fe8b564010ff', '205.210.31.81', 1744664495, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343636343439343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f34de629f39c8d139e376ee8eb48ebb9b97dfeaa', '119.155.195.168', 1741344382, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313334343338323b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b),
('f3d1a9cc5b3c0b68bcb483ff562a6bceff8e719a', '162.142.125.127', 1744118224, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343131383232343b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f3d8171ee77da10cb5d35729630d4c33ab3e1c09', '206.168.34.39', 1741884801, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313838343830313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f3de18aca3322ba67aa46eb1300f390f4a824268', '188.94.87.8', 1741279619, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313237393631393b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f407af0521038ef658099cddab12516543ddc92a', '91.84.87.137', 1741215536, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313231353533363b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f4783177a9f388426900f3b569f54d79e29ef263', '84.17.50.204', 1741200790, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303739303b5f707265765f75726c7c733a34333a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e223b),
('f47a0e033c7627e3b25640698dd576762adb9328', '114.181.36.16', 1741241176, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313234313137363b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f47ec44decc3c530894aeca71c411e8c4c8d5a24', '206.189.154.241', 1741232831, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313233323831343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a38323a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e2f7369746f2f77702d696e636c756465732f776c776d616e69666573742e786d6c223b),
('f4c5e5987f7e8caefde33a1e97e3a40cc8c10aa4', '23.27.145.94', 1741813395, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313831333339353b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f58dcbe1486b4d46c03d4e5d6f13979b1b5bedb4', '210.87.64.63', 1741201882, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230313838323b5f707265765f75726c7c733a34363a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c656164732f666f726d73223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b),
('f5afa52b25c8f9d28f061df0bd7dfcee9fb1ce16', '209.188.21.134', 1742952976, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323935323937363b),
('f61189ad0d222f17217b118480c58cadd27767f9', '210.87.64.63', 1741230492, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313233303439323b),
('f65d1a8f5e39cad6543449790341a2bbcd414f70', '175.107.212.77', 1742760836, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323736303833363b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b6d6573736167652d737563636573737c733a32323a22546f74616c206c656164732064656c657465643a2036223b5f5f63695f766172737c613a313a7b733a31353a226d6573736167652d73756363657373223b733a333a226e6577223b7d),
('f74eacb38e5ed4a6957853509eb6035b18d7e754', '206.168.34.205', 1742830882, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323833303838323b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f77ead5e2dbf5aabd74574e57e6c63f4c55b89f7', '23.27.145.222', 1741292824, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239323832333b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f7a9526a1486bfb88739e331d976927fe091413a', '172.111.15.130', 1741259882, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313235393838313b69735f6d6f62696c657c623a313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f8132c56a974f7cd35e6aa42461cf4afa5634e57', '23.27.145.94', 1741813394, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313831333339343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f8833825ca5b37532b0c4260949b77d1c45eab29', '50.19.167.206', 1741274867, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313237343836363b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('f884f9cfb5ede94ac31426b45e6840af4264cb35', '193.128.111.36', 1741280101, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238303130313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f971b1c4016a0b2d5f1d73149ec2f8925d468ee4', '210.87.64.40', 1743038691, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333033383639313b5f707265765f75726c7c733a34323a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f636c69656e7473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b),
('f9c6f7d20be04f0e6534aa86b8a2e1454ae82e54', '206.168.34.90', 1744366792, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343336363739323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('f9e9f07e93e9c8cd8e4da7a02974f700b8259663', '210.87.64.63', 1741202887, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230323838373b5f707265765f75726c7c733a35343a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f637573746f6d5f6669656c64732f6669656c64223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b),
('f9f44942660e154c18de8a485785382daafe19cb', '210.87.64.63', 1741226709, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313232363730393b),
('fa4dc47bb42a9d5ce008e3c5c77c8ffa8fbcb62b', '209.188.21.134', 1744695967, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343639353936373b),
('faf32a9112859676f4d9eb634ed1c9ce67568f49', '172.111.15.48', 1742667729, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323636373732393b69735f6d6f62696c657c623a313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('fb0822b9d46cc8db57fd25097910098de1251a38', '172.111.15.128', 1742167389, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323136373338393b69735f6d6f62696c657c623a313b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('fb1238407adc1f57d378d122cdaee85aa34eb312', '195.191.219.133', 1744664640, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343636343634303b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('fbc7d4d7fae4271834d629bae4840df3ea00b31a', '198.235.24.13', 1742751592, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323735313539313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('fbd10968a81d79571e76654d61c34cd8fb5ab853', '40.80.158.10', 1741211322, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313231313332313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('fc28090d16ebb071a76957b9ed362aa5cf4fc15a', '210.87.64.63', 1741229715, 0x[encoded data, 5006 characters]),
('fc69b6c9a82a2ee3145c3f56efd534fa0a7c8537', '199.45.155.88', 1744551938, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343535313933383b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('fc8854853ef3660fce5774038af2a0b3932ae581', '91.196.152.47', 1741291873, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239313837333b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('fcb687adb785e61eb3938913d5ac037ebd8797ce', '209.188.21.134', 1742822510, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323832323530393b),
('fd43e51db43878174cf173c603582d6937d877d6', '157.245.65.19', 1741284477, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238343437373b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('fd5887e0ed187714fdbca72edb16e2bb102de195', '195.191.219.132', 1745199114, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734353139393131343b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('fd71e155ab9e7ab4efca710f9cea0ed065dc2f04', '86.172.5.83', 1741200812, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303831323b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('fd97aaa229f9bfdeabb15d29701e141d64b34187', '210.87.64.63', 1741207929, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230373932393b5f707265765f75726c7c733a37313a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f666f726d732f77746c2f3662316563333430386434336138343432373531393562346235303365623435223b),
('fdfa416e7d06433e2cdd02330a683dffcbfcd95e', '210.87.64.63', 1741228158, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313232383135383b5f707265765f75726c7c733a37313a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f666f726d732f77746c2f3662316563333430386434336138343432373531393562346235303365623435223b),
('fe709d317d7c61126aeb1af7dde134a2fe1f5abc', '205.210.31.22', 1742064282, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323036343238323b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('fe7bbf8a27e05f16d056fbafb5dc78d313cba16f', '91.84.87.137', 1741228285, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313232383238353b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ff0279a84d114f8d8a669a0229587e44effd0574', '175.107.212.77', 1742757095, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323735373039353b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2231223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c623a313b),
('ff079a829bc8cc590daf83726dc1fe50a3f6f460', '205.169.39.187', 1741279615, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313237393630373b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('ff0c299f852026557a5de8fdeb666a96203f20b1', '149.13.14.252', 1741281476, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238313437363b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('ff302e162082758ea56d6b903f06dc52b58c8eaf', '206.168.34.223', 1743003170, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333030333137303b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('ff4967106cf4f25ee09f7de53e6b380b8dc9ecdd', '61.115.12.244', 1741204164, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230343136343b69735f6d6f62696c657c623a313b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ff524ebb1a68f876d28c172e75224d50ada2e63d', '185.156.172.172', 1741200756, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303735363b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ff55147965654014df7e9a02f2c34afeb2d9b16d', '176.100.243.133', 1741281058, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313238313035383b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('ff8af716da2f50866cbdf81bfeb5281cf7ee5c84', '205.169.39.4', 1741295810, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313239353830393b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b5f707265765f75726c7c733a34393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61757468656e7469636174696f6e2f6c6f67696e223b),
('ff99f4665238c4bf25e5a396bbc062893e8731c6', '39.53.208.179', 1742875036, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323837343833373b5f707265765f75726c7c733a34303a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f61646d696e2f6c65616473223b73746166665f757365725f69647c733a313a2232223b73746166665f6c6f676765645f696e7c623a313b73657475702d6d656e752d6f70656e7c733a303a22223b),
('fffd2febe03d3fb02e0ce4b53fc66e35d1a014c8', '86.172.5.83', 1741200777, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313230303737373b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b),
('ffffef19c855a5acd2824b99855c104af070efe5', '23.27.145.166', 1743801624, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734333830313632343b7265645f75726c7c733a32393a2268747470733a2f2f63726d2e656e67696e6562616e6b2e636f2e756b2f223b);

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

--
-- Table structure for table `tblshared_customer_files`
--

CREATE TABLE `tblshared_customer_files` (
  `file_id` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblspam_filters`
--

CREATE TABLE `tblspam_filters` (
  `id` int(11) NOT NULL,
  `type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rel_type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblstaff_departments`
--

CREATE TABLE `tblstaff_departments` (
  `staffdepartmentid` int(11) NOT NULL,
  `staffid` int(11) NOT NULL,
  `departmentid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblstaff_permissions`
--

CREATE TABLE `tblstaff_permissions` (
  `staff_id` int(11) NOT NULL,
  `feature` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `capability` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblstaff_permissions`
--

INSERT INTO `tblstaff_permissions` (`staff_id`, `feature`, `capability`) VALUES
(2, 'reports', 'view'),
(2, 'reports', 'view-timesheets'),
(2, 'staff', 'view'),
(2, 'staff', 'create'),
(2, 'staff', 'edit'),
(2, 'staff', 'delete'),
(2, 'leads', 'view'),
(2, 'leads', 'delete');

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

--
-- Table structure for table `tblsubscriptions`
--

CREATE TABLE `tblsubscriptions` (
  `id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `description_in_item` tinyint(1) NOT NULL DEFAULT '0',
  `clientid` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `terms` mediumtext COLLATE utf8mb4_unicode_ci,
  `currency` int(11) NOT NULL,
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `stripe_tax_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_id_2` int(11) NOT NULL DEFAULT '0',
  `stripe_tax_id_2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stripe_plan_id` mediumtext COLLATE utf8mb4_unicode_ci,
  `stripe_subscription_id` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `next_billing_cycle` bigint(20) DEFAULT NULL,
  `ends_at` bigint(20) DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT '1',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `created_from` int(11) NOT NULL,
  `date_subscribed` datetime DEFAULT NULL,
  `in_test_environment` int(11) DEFAULT NULL,
  `last_sent_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltaggables`
--

CREATE TABLE `tbltaggables` (
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_id` int(11) NOT NULL,
  `tag_order` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltags`
--

CREATE TABLE `tbltags` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltasks`
--

CREATE TABLE `tbltasks` (
  `id` int(11) NOT NULL,
  `name` longtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `priority` int(11) DEFAULT NULL,
  `dateadded` datetime NOT NULL,
  `startdate` date NOT NULL,
  `duedate` date DEFAULT NULL,
  `datefinished` datetime DEFAULT NULL,
  `addedfrom` int(11) NOT NULL,
  `is_added_from_contact` tinyint(1) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repeat_every` int(11) DEFAULT NULL,
  `recurring` int(11) NOT NULL DEFAULT '0',
  `is_recurring_from` int(11) DEFAULT NULL,
  `cycles` int(11) NOT NULL DEFAULT '0',
  `total_cycles` int(11) NOT NULL DEFAULT '0',
  `custom_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `last_recurring_date` date DEFAULT NULL,
  `rel_id` int(11) DEFAULT NULL,
  `rel_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `billable` tinyint(1) NOT NULL DEFAULT '0',
  `billed` tinyint(1) NOT NULL DEFAULT '0',
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `hourly_rate` decimal(15,2) NOT NULL DEFAULT '0.00',
  `milestone` int(11) DEFAULT '0',
  `kanban_order` int(11) DEFAULT '1',
  `milestone_order` int(11) NOT NULL DEFAULT '0',
  `visible_to_client` tinyint(1) NOT NULL DEFAULT '0',
  `deadline_notified` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltaskstimers`
--

CREATE TABLE `tbltaskstimers` (
  `id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `start_time` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_time` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_id` int(11) NOT NULL,
  `hourly_rate` decimal(15,2) NOT NULL DEFAULT '0.00',
  `note` mediumtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltasks_checklist_templates`
--

CREATE TABLE `tbltasks_checklist_templates` (
  `id` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltask_assigned`
--

CREATE TABLE `tbltask_assigned` (
  `id` int(11) NOT NULL,
  `staffid` int(11) NOT NULL,
  `taskid` int(11) NOT NULL,
  `assigned_from` int(11) NOT NULL DEFAULT '0',
  `is_assigned_from_contact` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltask_checklist_items`
--

CREATE TABLE `tbltask_checklist_items` (
  `id` int(11) NOT NULL,
  `taskid` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `finished` int(11) NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  `addedfrom` int(11) NOT NULL,
  `finished_from` int(11) DEFAULT '0',
  `list_order` int(11) NOT NULL DEFAULT '0',
  `assigned` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltask_comments`
--

CREATE TABLE `tbltask_comments` (
  `id` int(11) NOT NULL,
  `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `taskid` int(11) NOT NULL,
  `staffid` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL DEFAULT '0',
  `file_id` int(11) NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltask_followers`
--

CREATE TABLE `tbltask_followers` (
  `id` int(11) NOT NULL,
  `staffid` int(11) NOT NULL,
  `taskid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltaxes`
--

CREATE TABLE `tbltaxes` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taxrate` decimal(15,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltemplates`
--

CREATE TABLE `tbltemplates` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `addedfrom` int(11) NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltickets`
--

CREATE TABLE `tbltickets` (
  `ticketid` int(11) NOT NULL,
  `adminreplying` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL,
  `contactid` int(11) NOT NULL DEFAULT '0',
  `merged_ticket_id` int(11) DEFAULT NULL,
  `email` mediumtext COLLATE utf8mb4_unicode_ci,
  `name` mediumtext COLLATE utf8mb4_unicode_ci,
  `department` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `service` int(11) DEFAULT NULL,
  `ticketkey` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext COLLATE utf8mb4_unicode_ci,
  `admin` int(11) DEFAULT NULL,
  `date` datetime NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `lastreply` datetime DEFAULT NULL,
  `clientread` int(11) NOT NULL DEFAULT '0',
  `adminread` int(11) NOT NULL DEFAULT '0',
  `assigned` int(11) NOT NULL DEFAULT '0',
  `staff_id_replying` int(11) DEFAULT NULL,
  `cc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltickets_pipe_log`
--

CREATE TABLE `tbltickets_pipe_log` (
  `id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `email_to` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltickets_predefined_replies`
--

CREATE TABLE `tbltickets_predefined_replies` (
  `id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltickets_priorities`
--

CREATE TABLE `tbltickets_priorities` (
  `priorityid` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltickets_priorities`
--

INSERT INTO `tbltickets_priorities` (`priorityid`, `name`) VALUES
(1, 'Low'),
(2, 'Medium'),
(3, 'High');

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

--
-- Table structure for table `tbltickets_status`
--

CREATE TABLE `tbltickets_status` (
  `ticketstatusid` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isdefault` int(11) NOT NULL DEFAULT '0',
  `statuscolor` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statusorder` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltickets_status`
--

INSERT INTO `tbltickets_status` (`ticketstatusid`, `name`, `isdefault`, `statuscolor`, `statusorder`) VALUES
(1, 'Open', 1, '#ff2d42', 1),
(2, 'In progress', 1, '#22c55e', 2),
(3, 'Answered', 1, '#2563eb', 3),
(4, 'On Hold', 1, '#64748b', 4),
(5, 'Closed', 1, '#03a9f4', 5);

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

--
-- Table structure for table `tblticket_attachments`
--

CREATE TABLE `tblticket_attachments` (
  `id` int(11) NOT NULL,
  `ticketid` int(11) NOT NULL,
  `replyid` int(11) DEFAULT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filetype` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateadded` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblticket_replies`
--

CREATE TABLE `tblticket_replies` (
  `id` int(11) NOT NULL,
  `ticketid` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `contactid` int(11) NOT NULL DEFAULT '0',
  `name` mediumtext COLLATE utf8mb4_unicode_ci,
  `email` mediumtext COLLATE utf8mb4_unicode_ci,
  `date` datetime NOT NULL,
  `message` mediumtext COLLATE utf8mb4_unicode_ci,
  `attachment` int(11) DEFAULT NULL,
  `admin` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltodos`
--

CREATE TABLE `tbltodos` (
  `todoid` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `staffid` int(11) NOT NULL,
  `dateadded` datetime NOT NULL,
  `finished` tinyint(1) NOT NULL,
  `datefinished` datetime DEFAULT NULL,
  `item_order` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltracked_mails`
--

CREATE TABLE `tbltracked_mails` (
  `id` int(11) NOT NULL,
  `uid` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `opened` tinyint(1) NOT NULL DEFAULT '0',
  `date_opened` datetime DEFAULT NULL,
  `subject` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltwocheckout_log`
--

CREATE TABLE `tbltwocheckout_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `amount` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `attempt_reference` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbluser_api_permissions`
--

CREATE TABLE `tbluser_api_permissions` (
  `api_id` int(11) NOT NULL,
  `feature` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `capability` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbluser_api_permissions`
--

INSERT INTO `tbluser_api_permissions` (`api_id`, `feature`, `capability`) VALUES
(1, 'leads', 'get'),
(1, 'leads', 'search_get'),
(1, 'leads', 'post'),
(1, 'leads', 'delete'),
(1, 'leads', 'put');

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

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

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

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

INSERT INTO `tbluser_auto_login` (`key_id`, `user_id`, `user_agent`, `last_ip`, `last_login`, `staff`) VALUES
('2f4975b6f3542f2b4763cbd2e64cc90e', 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36 Edg/133.0.0.0', '210.87.64.63', '2025-03-05 18:48:42', 1);

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

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

CREATE TABLE `tbluser_meta` (
  `umeta_id` bigint(20) UNSIGNED NOT NULL,
  `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(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `tbluser_meta` (`umeta_id`, `staff_id`, `client_id`, `contact_id`, `meta_key`, `meta_value`) VALUES
(1, 1, 0, 0, 'recent_searches', '[\"webh\"]'),
(2, 1, 0, 0, 'dashboard_widgets_order', 'a:8:{s:6:\"top-12\";a:1:{i:0;s:16:\"widget-top_stats\";}s:13:\"middle-left-6\";a:0:{}s:14:\"middle-right-6\";a:0:{}s:6:\"left-8\";a:7:{i:0;s:23:\"widget-finance_overview\";i:1;s:16:\"widget-user_data\";i:2;s:22:\"widget-upcoming_events\";i:3;s:15:\"widget-calendar\";i:4;s:21:\"widget-payments_chart\";i:5;s:25:\"widget-contracts_expiring\";i:6;s:21:\"widget-tickets_report\";}s:7:\"right-4\";a:5:{i:0;s:12:\"widget-todos\";i:1;s:18:\"widget-leads_chart\";i:2;s:21:\"widget-projects_chart\";i:3;s:20:\"widget-tickets_chart\";i:4;s:24:\"widget-projects_activity\";}s:13:\"bottom-left-4\";a:0:{}s:15:\"bottom-middle-4\";a:0:{}s:14:\"bottom-right-4\";a:0:{}}');

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

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

CREATE TABLE `tblvault` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `server_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` int(11) DEFAULT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `creator` int(11) NOT NULL,
  `creator_name` varchar(100) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `tblviews_tracking` (
  `id` int(11) NOT NULL,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `view_ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblwallet`
--

CREATE TABLE `tblwallet` (
  `id` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL,
  `balance` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tblwallet_transaction`
--

CREATE TABLE `tblwallet_transaction` (
  `id` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `mode` enum('debit','credit','log') NOT NULL,
  `tag` varchar(255) NOT NULL,
  `description` text,
  `ref_id` varchar(255) DEFAULT NULL,
  `invoice_id` varchar(255) DEFAULT NULL,
  `metadata` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tblwebhooks_debug_log`
--

CREATE TABLE `tblwebhooks_debug_log` (
  `id` int(11) NOT NULL,
  `webhook_action_name` varchar(200) NOT NULL,
  `request_url` text NOT NULL,
  `webhook_for` varchar(50) NOT NULL,
  `webhook_action` text NOT NULL,
  `request_method` varchar(100) NOT NULL,
  `request_format` varchar(20) NOT NULL,
  `request_header` text NOT NULL,
  `request_body` text NOT NULL,
  `response_code` varchar(4) NOT NULL,
  `response_data` text NOT NULL,
  `recorded_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tblwebhooks_master`
--

CREATE TABLE `tblwebhooks_master` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `webhook_for` varchar(50) NOT NULL,
  `webhook_action` text NOT NULL,
  `request_url` text NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `request_method` varchar(100) NOT NULL,
  `request_format` varchar(20) NOT NULL,
  `request_header` text NOT NULL,
  `request_body` text NOT NULL,
  `debug_mode` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `tblweb_to_lead` (
  `id` int(11) NOT NULL,
  `form_key` varchar(32) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_ids` longtext COLLATE utf8mb4_unicode_ci,
  `responsible` int(11) NOT NULL DEFAULT '0',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_data` longtext COLLATE utf8mb4_unicode_ci,
  `recaptcha` int(11) NOT NULL DEFAULT '0',
  `submit_btn_name` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submit_btn_text_color` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '#ffffff',
  `submit_btn_bg_color` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '#84c529',
  `success_submit_msg` mediumtext COLLATE utf8mb4_unicode_ci,
  `submit_action` int(11) DEFAULT '0',
  `lead_name_prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submit_redirect_url` longtext COLLATE utf8mb4_unicode_ci,
  `language` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `allow_duplicate` int(11) NOT NULL DEFAULT '1',
  `mark_public` int(11) NOT NULL DEFAULT '0',
  `track_duplicate_field` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `track_duplicate_field_and` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_task_on_duplicate` int(11) NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cars`
--
ALTER TABLE `cars`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblactivity_log`
--
ALTER TABLE `tblactivity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `staffid` (`staffid`);

--
-- Indexes for table `tblannouncements`
--
ALTER TABLE `tblannouncements`
  ADD PRIMARY KEY (`announcementid`);

--
-- Indexes for table `tblclients`
--
ALTER TABLE `tblclients`
  ADD PRIMARY KEY (`userid`),
  ADD KEY `country` (`country`),
  ADD KEY `leadid` (`leadid`),
  ADD KEY `company` (`company`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `tblconsents`
--
ALTER TABLE `tblconsents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purpose_id` (`purpose_id`),
  ADD KEY `contact_id` (`contact_id`),
  ADD KEY `lead_id` (`lead_id`);

--
-- Indexes for table `tblconsent_purposes`
--
ALTER TABLE `tblconsent_purposes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcontacts`
--
ALTER TABLE `tblcontacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `firstname` (`firstname`),
  ADD KEY `lastname` (`lastname`),
  ADD KEY `email` (`email`),
  ADD KEY `is_primary` (`is_primary`);

--
-- Indexes for table `tblcontact_permissions`
--
ALTER TABLE `tblcontact_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcontracts`
--
ALTER TABLE `tblcontracts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `client` (`client`),
  ADD KEY `contract_type` (`contract_type`);

--
-- Indexes for table `tblcontracts_types`
--
ALTER TABLE `tblcontracts_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcontract_comments`
--
ALTER TABLE `tblcontract_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcontract_renewals`
--
ALTER TABLE `tblcontract_renewals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcountries`
--
ALTER TABLE `tblcountries`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `tblcreditnotes`
--
ALTER TABLE `tblcreditnotes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `currency` (`currency`),
  ADD KEY `clientid` (`clientid`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `formatted_number` (`formatted_number`);

--
-- Indexes for table `tblcreditnote_refunds`
--
ALTER TABLE `tblcreditnote_refunds`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcredits`
--
ALTER TABLE `tblcredits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcurrencies`
--
ALTER TABLE `tblcurrencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcustomers_groups`
--
ALTER TABLE `tblcustomers_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `tblcustomer_admins`
--
ALTER TABLE `tblcustomer_admins`
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `staff_id` (`staff_id`);

--
-- Indexes for table `tblcustomer_groups`
--
ALTER TABLE `tblcustomer_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groupid` (`groupid`),
  ADD KEY `customer_id` (`customer_id`);

--
-- Indexes for table `tblcustomfields`
--
ALTER TABLE `tblcustomfields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblcustomfieldsvalues`
--
ALTER TABLE `tblcustomfieldsvalues`
  ADD PRIMARY KEY (`id`),
  ADD KEY `relid` (`relid`),
  ADD KEY `fieldto` (`fieldto`),
  ADD KEY `fieldid` (`fieldid`);

--
-- Indexes for table `tbldepartments`
--
ALTER TABLE `tbldepartments`
  ADD PRIMARY KEY (`departmentid`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `tbldismissed_announcements`
--
ALTER TABLE `tbldismissed_announcements`
  ADD PRIMARY KEY (`dismissedannouncementid`),
  ADD KEY `announcementid` (`announcementid`),
  ADD KEY `staff` (`staff`),
  ADD KEY `userid` (`userid`);

--
-- Indexes for table `tblemailtemplates`
--
ALTER TABLE `tblemailtemplates`
  ADD PRIMARY KEY (`emailtemplateid`);

--
-- Indexes for table `tblestimates`
--
ALTER TABLE `tblestimates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clientid` (`clientid`),
  ADD KEY `currency` (`currency`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `sale_agent` (`sale_agent`),
  ADD KEY `status` (`status`),
  ADD KEY `formatted_number` (`formatted_number`);

--
-- Indexes for table `tblestimate_requests`
--
ALTER TABLE `tblestimate_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblestimate_request_forms`
--
ALTER TABLE `tblestimate_request_forms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblestimate_request_status`
--
ALTER TABLE `tblestimate_request_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblevents`
--
ALTER TABLE `tblevents`
  ADD PRIMARY KEY (`eventid`);

--
-- Indexes for table `tblexpenses`
--
ALTER TABLE `tblexpenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clientid` (`clientid`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `category` (`category`),
  ADD KEY `currency` (`currency`);

--
-- Indexes for table `tblexpenses_categories`
--
ALTER TABLE `tblexpenses_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblfiles`
--
ALTER TABLE `tblfiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_id` (`rel_id`),
  ADD KEY `rel_type` (`rel_type`);

--
-- Indexes for table `tblfilters`
--
ALTER TABLE `tblfilters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblfilter_defaults`
--
ALTER TABLE `tblfilter_defaults`
  ADD KEY `filter_id` (`filter_id`),
  ADD KEY `staff_id` (`staff_id`);

--
-- Indexes for table `tblform_questions`
--
ALTER TABLE `tblform_questions`
  ADD PRIMARY KEY (`questionid`);

--
-- Indexes for table `tblform_question_box`
--
ALTER TABLE `tblform_question_box`
  ADD PRIMARY KEY (`boxid`);

--
-- Indexes for table `tblform_question_box_description`
--
ALTER TABLE `tblform_question_box_description`
  ADD PRIMARY KEY (`questionboxdescriptionid`);

--
-- Indexes for table `tblform_results`
--
ALTER TABLE `tblform_results`
  ADD PRIMARY KEY (`resultid`);

--
-- Indexes for table `tblftp_accounts`
--
ALTER TABLE `tblftp_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblgdpr_requests`
--
ALTER TABLE `tblgdpr_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblhm_database`
--
ALTER TABLE `tblhm_database`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblhm_domains`
--
ALTER TABLE `tblhm_domains`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblib_customfield`
--
ALTER TABLE `tblib_customfield`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblib_customfield_value`
--
ALTER TABLE `tblib_customfield_value`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblib_invoices_built`
--
ALTER TABLE `tblib_invoices_built`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblib_templates`
--
ALTER TABLE `tblib_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblinvoicepaymentrecords`
--
ALTER TABLE `tblinvoicepaymentrecords`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoiceid` (`invoiceid`),
  ADD KEY `paymentmethod` (`paymentmethod`);

--
-- Indexes for table `tblinvoices`
--
ALTER TABLE `tblinvoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `currency` (`currency`),
  ADD KEY `clientid` (`clientid`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `sale_agent` (`sale_agent`),
  ADD KEY `total` (`total`),
  ADD KEY `status` (`status`),
  ADD KEY `formatted_number` (`formatted_number`);

--
-- Indexes for table `tblitemable`
--
ALTER TABLE `tblitemable`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_id` (`rel_id`),
  ADD KEY `rel_type` (`rel_type`),
  ADD KEY `qty` (`qty`),
  ADD KEY `rate` (`rate`);

--
-- Indexes for table `tblitems`
--
ALTER TABLE `tblitems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tax` (`tax`),
  ADD KEY `tax2` (`tax2`),
  ADD KEY `group_id` (`group_id`);

--
-- Indexes for table `tblitems_groups`
--
ALTER TABLE `tblitems_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblitem_tax`
--
ALTER TABLE `tblitem_tax`
  ADD PRIMARY KEY (`id`),
  ADD KEY `itemid` (`itemid`),
  ADD KEY `rel_id` (`rel_id`);

--
-- Indexes for table `tblknowedge_base_article_feedback`
--
ALTER TABLE `tblknowedge_base_article_feedback`
  ADD PRIMARY KEY (`articleanswerid`);

--
-- Indexes for table `tblknowledge_base`
--
ALTER TABLE `tblknowledge_base`
  ADD PRIMARY KEY (`articleid`);

--
-- Indexes for table `tblknowledge_base_groups`
--
ALTER TABLE `tblknowledge_base_groups`
  ADD PRIMARY KEY (`groupid`);

--
-- Indexes for table `tblleads_sources`
--
ALTER TABLE `tblleads_sources`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `tblleads_status`
--
ALTER TABLE `tblleads_status`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `tbllead_activity_log`
--
ALTER TABLE `tbllead_activity_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbllead_integration_emails`
--
ALTER TABLE `tbllead_integration_emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblmail_queue`
--
ALTER TABLE `tblmail_queue`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblmilestones`
--
ALTER TABLE `tblmilestones`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblmodules`
--
ALTER TABLE `tblmodules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblnewsfeed_comment_likes`
--
ALTER TABLE `tblnewsfeed_comment_likes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblnewsfeed_posts`
--
ALTER TABLE `tblnewsfeed_posts`
  ADD PRIMARY KEY (`postid`);

--
-- Indexes for table `tblnewsfeed_post_comments`
--
ALTER TABLE `tblnewsfeed_post_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblnewsfeed_post_likes`
--
ALTER TABLE `tblnewsfeed_post_likes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblnotes`
--
ALTER TABLE `tblnotes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_id` (`rel_id`),
  ADD KEY `rel_type` (`rel_type`);

--
-- Indexes for table `tblnotifications`
--
ALTER TABLE `tblnotifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbloptions`
--
ALTER TABLE `tbloptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `tblpayment_attempts`
--
ALTER TABLE `tblpayment_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblpayment_modes`
--
ALTER TABLE `tblpayment_modes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblpinned_projects`
--
ALTER TABLE `tblpinned_projects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `tblprojectdiscussioncomments`
--
ALTER TABLE `tblprojectdiscussioncomments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblprojectdiscussions`
--
ALTER TABLE `tblprojectdiscussions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblprojects`
--
ALTER TABLE `tblprojects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clientid` (`clientid`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `tblproject_activity`
--
ALTER TABLE `tblproject_activity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblproject_files`
--
ALTER TABLE `tblproject_files`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblproject_members`
--
ALTER TABLE `tblproject_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `staff_id` (`staff_id`);

--
-- Indexes for table `tblproject_notes`
--
ALTER TABLE `tblproject_notes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblproject_settings`
--
ALTER TABLE `tblproject_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `tblproposals`
--
ALTER TABLE `tblproposals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `tblproposal_comments`
--
ALTER TABLE `tblproposal_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblrelated_items`
--
ALTER TABLE `tblrelated_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblreminders`
--
ALTER TABLE `tblreminders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_id` (`rel_id`),
  ADD KEY `rel_type` (`rel_type`),
  ADD KEY `staff` (`staff`);

--
-- Indexes for table `tblroles`
--
ALTER TABLE `tblroles`
  ADD PRIMARY KEY (`roleid`);

--
-- Indexes for table `tblsales_activity`
--
ALTER TABLE `tblsales_activity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblscheduled_emails`
--
ALTER TABLE `tblscheduled_emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblscheduled_webhooks`
--
ALTER TABLE `tblscheduled_webhooks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblservices`
--
ALTER TABLE `tblservices`
  ADD PRIMARY KEY (`serviceid`);

--
-- Indexes for table `tblsessions`
--
ALTER TABLE `tblsessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `tblspam_filters`
--
ALTER TABLE `tblspam_filters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblstaff_departments`
--
ALTER TABLE `tblstaff_departments`
  ADD PRIMARY KEY (`staffdepartmentid`);

--
-- Indexes for table `tblsubscriptions`
--
ALTER TABLE `tblsubscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clientid` (`clientid`),
  ADD KEY `currency` (`currency`),
  ADD KEY `tax_id` (`tax_id`);

--
-- Indexes for table `tbltaggables`
--
ALTER TABLE `tbltaggables`
  ADD KEY `rel_id` (`rel_id`),
  ADD KEY `rel_type` (`rel_type`),
  ADD KEY `tag_id` (`tag_id`);

--
-- Indexes for table `tbltags`
--
ALTER TABLE `tbltags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `tbltasks`
--
ALTER TABLE `tbltasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_id` (`rel_id`),
  ADD KEY `rel_type` (`rel_type`),
  ADD KEY `milestone` (`milestone`),
  ADD KEY `kanban_order` (`kanban_order`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `tbltaskstimers`
--
ALTER TABLE `tbltaskstimers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `task_id` (`task_id`),
  ADD KEY `staff_id` (`staff_id`);

--
-- Indexes for table `tbltasks_checklist_templates`
--
ALTER TABLE `tbltasks_checklist_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltask_assigned`
--
ALTER TABLE `tbltask_assigned`
  ADD PRIMARY KEY (`id`),
  ADD KEY `taskid` (`taskid`),
  ADD KEY `staffid` (`staffid`);

--
-- Indexes for table `tbltask_checklist_items`
--
ALTER TABLE `tbltask_checklist_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `taskid` (`taskid`);

--
-- Indexes for table `tbltask_comments`
--
ALTER TABLE `tbltask_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`),
  ADD KEY `taskid` (`taskid`);

--
-- Indexes for table `tbltask_followers`
--
ALTER TABLE `tbltask_followers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltaxes`
--
ALTER TABLE `tbltaxes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltemplates`
--
ALTER TABLE `tbltemplates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltickets`
--
ALTER TABLE `tbltickets`
  ADD PRIMARY KEY (`ticketid`),
  ADD KEY `service` (`service`),
  ADD KEY `department` (`department`),
  ADD KEY `status` (`status`),
  ADD KEY `userid` (`userid`),
  ADD KEY `priority` (`priority`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `contactid` (`contactid`);

--
-- Indexes for table `tbltickets_pipe_log`
--
ALTER TABLE `tbltickets_pipe_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltickets_predefined_replies`
--
ALTER TABLE `tbltickets_predefined_replies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltickets_priorities`
--
ALTER TABLE `tbltickets_priorities`
  ADD PRIMARY KEY (`priorityid`);

--
-- Indexes for table `tbltickets_status`
--
ALTER TABLE `tbltickets_status`
  ADD PRIMARY KEY (`ticketstatusid`);

--
-- Indexes for table `tblticket_attachments`
--
ALTER TABLE `tblticket_attachments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblticket_replies`
--
ALTER TABLE `tblticket_replies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltodos`
--
ALTER TABLE `tbltodos`
  ADD PRIMARY KEY (`todoid`);

--
-- Indexes for table `tbltracked_mails`
--
ALTER TABLE `tbltracked_mails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbltwocheckout_log`
--
ALTER TABLE `tbltwocheckout_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice_id` (`invoice_id`);

--
-- Indexes for table `tbluser_meta`
--
ALTER TABLE `tbluser_meta`
  ADD PRIMARY KEY (`umeta_id`);

--
-- Indexes for table `tblvault`
--
ALTER TABLE `tblvault`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblviews_tracking`
--
ALTER TABLE `tblviews_tracking`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblwallet`
--
ALTER TABLE `tblwallet`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_tbl_contact_id` (`contact_id`);

--
-- Indexes for table `tblwallet_transaction`
--
ALTER TABLE `tblwallet_transaction`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_tbl_ref_id` (`ref_id`),
  ADD KEY `fk_tbl_wallet_transactions_contact_id` (`contact_id`);

--
-- Indexes for table `tblwebhooks_debug_log`
--
ALTER TABLE `tblwebhooks_debug_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblwebhooks_master`
--
ALTER TABLE `tblwebhooks_master`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tblweb_to_lead`
--
ALTER TABLE `tblweb_to_lead`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cars`
--
ALTER TABLE `cars`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11863;

--
-- AUTO_INCREMENT for table `tblactivity_log`
--
ALTER TABLE `tblactivity_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=252;

--
-- AUTO_INCREMENT for table `tblannouncements`
--
ALTER TABLE `tblannouncements`
  MODIFY `announcementid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblclients`
--
ALTER TABLE `tblclients`
  MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblconsents`
--
ALTER TABLE `tblconsents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblconsent_purposes`
--
ALTER TABLE `tblconsent_purposes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcontacts`
--
ALTER TABLE `tblcontacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcontact_permissions`
--
ALTER TABLE `tblcontact_permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcontracts`
--
ALTER TABLE `tblcontracts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcontracts_types`
--
ALTER TABLE `tblcontracts_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcontract_comments`
--
ALTER TABLE `tblcontract_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcontract_renewals`
--
ALTER TABLE `tblcontract_renewals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcountries`
--
ALTER TABLE `tblcountries`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;

--
-- AUTO_INCREMENT for table `tblcreditnotes`
--
ALTER TABLE `tblcreditnotes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcreditnote_refunds`
--
ALTER TABLE `tblcreditnote_refunds`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcredits`
--
ALTER TABLE `tblcredits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcurrencies`
--
ALTER TABLE `tblcurrencies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tblcustomers_groups`
--
ALTER TABLE `tblcustomers_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcustomer_groups`
--
ALTER TABLE `tblcustomer_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblcustomfields`
--
ALTER TABLE `tblcustomfields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `tblcustomfieldsvalues`
--
ALTER TABLE `tblcustomfieldsvalues`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=281;

--
-- AUTO_INCREMENT for table `tbldepartments`
--
ALTER TABLE `tbldepartments`
  MODIFY `departmentid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbldismissed_announcements`
--
ALTER TABLE `tbldismissed_announcements`
  MODIFY `dismissedannouncementid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblemailtemplates`
--
ALTER TABLE `tblemailtemplates`
  MODIFY `emailtemplateid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2219;

--
-- AUTO_INCREMENT for table `tblestimates`
--
ALTER TABLE `tblestimates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblestimate_requests`
--
ALTER TABLE `tblestimate_requests`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblestimate_request_forms`
--
ALTER TABLE `tblestimate_request_forms`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblestimate_request_status`
--
ALTER TABLE `tblestimate_request_status`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tblevents`
--
ALTER TABLE `tblevents`
  MODIFY `eventid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblexpenses`
--
ALTER TABLE `tblexpenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblexpenses_categories`
--
ALTER TABLE `tblexpenses_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblfiles`
--
ALTER TABLE `tblfiles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblfilters`
--
ALTER TABLE `tblfilters`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblform_questions`
--
ALTER TABLE `tblform_questions`
  MODIFY `questionid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblform_question_box`
--
ALTER TABLE `tblform_question_box`
  MODIFY `boxid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblform_question_box_description`
--
ALTER TABLE `tblform_question_box_description`
  MODIFY `questionboxdescriptionid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblform_results`
--
ALTER TABLE `tblform_results`
  MODIFY `resultid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblftp_accounts`
--
ALTER TABLE `tblftp_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblgdpr_requests`
--
ALTER TABLE `tblgdpr_requests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblhm_database`
--
ALTER TABLE `tblhm_database`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblhm_domains`
--
ALTER TABLE `tblhm_domains`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblib_customfield`
--
ALTER TABLE `tblib_customfield`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblib_customfield_value`
--
ALTER TABLE `tblib_customfield_value`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblib_invoices_built`
--
ALTER TABLE `tblib_invoices_built`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblib_templates`
--
ALTER TABLE `tblib_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tblinvoicepaymentrecords`
--
ALTER TABLE `tblinvoicepaymentrecords`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblinvoices`
--
ALTER TABLE `tblinvoices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblitemable`
--
ALTER TABLE `tblitemable`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblitems`
--
ALTER TABLE `tblitems`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblitems_groups`
--
ALTER TABLE `tblitems_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblitem_tax`
--
ALTER TABLE `tblitem_tax`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblknowedge_base_article_feedback`
--
ALTER TABLE `tblknowedge_base_article_feedback`
  MODIFY `articleanswerid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblknowledge_base`
--
ALTER TABLE `tblknowledge_base`
  MODIFY `articleid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblknowledge_base_groups`
--
ALTER TABLE `tblknowledge_base_groups`
  MODIFY `groupid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblleads_sources`
--
ALTER TABLE `tblleads_sources`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tblleads_status`
--
ALTER TABLE `tblleads_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbllead_activity_log`
--
ALTER TABLE `tbllead_activity_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=162;

--
-- AUTO_INCREMENT for table `tbllead_integration_emails`
--
ALTER TABLE `tbllead_integration_emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblmail_queue`
--
ALTER TABLE `tblmail_queue`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblmilestones`
--
ALTER TABLE `tblmilestones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblmodules`
--
ALTER TABLE `tblmodules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tblnewsfeed_comment_likes`
--
ALTER TABLE `tblnewsfeed_comment_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblnewsfeed_posts`
--
ALTER TABLE `tblnewsfeed_posts`
  MODIFY `postid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblnewsfeed_post_comments`
--
ALTER TABLE `tblnewsfeed_post_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblnewsfeed_post_likes`
--
ALTER TABLE `tblnewsfeed_post_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblnotes`
--
ALTER TABLE `tblnotes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblnotifications`
--
ALTER TABLE `tblnotifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `tbloptions`
--
ALTER TABLE `tbloptions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=521;

--
-- AUTO_INCREMENT for table `tblpayment_attempts`
--
ALTER TABLE `tblpayment_attempts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblpayment_modes`
--
ALTER TABLE `tblpayment_modes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tblpinned_projects`
--
ALTER TABLE `tblpinned_projects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblprojectdiscussioncomments`
--
ALTER TABLE `tblprojectdiscussioncomments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblprojectdiscussions`
--
ALTER TABLE `tblprojectdiscussions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblprojects`
--
ALTER TABLE `tblprojects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblproject_activity`
--
ALTER TABLE `tblproject_activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblproject_files`
--
ALTER TABLE `tblproject_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblproject_members`
--
ALTER TABLE `tblproject_members`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblproject_notes`
--
ALTER TABLE `tblproject_notes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblproject_settings`
--
ALTER TABLE `tblproject_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblproposals`
--
ALTER TABLE `tblproposals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblproposal_comments`
--
ALTER TABLE `tblproposal_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblrelated_items`
--
ALTER TABLE `tblrelated_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblreminders`
--
ALTER TABLE `tblreminders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblroles`
--
ALTER TABLE `tblroles`
  MODIFY `roleid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tblsales_activity`
--
ALTER TABLE `tblsales_activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblscheduled_emails`
--
ALTER TABLE `tblscheduled_emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblscheduled_webhooks`
--
ALTER TABLE `tblscheduled_webhooks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblservices`
--
ALTER TABLE `tblservices`
  MODIFY `serviceid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblspam_filters`
--
ALTER TABLE `tblspam_filters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblstaff_departments`
--
ALTER TABLE `tblstaff_departments`
  MODIFY `staffdepartmentid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblsubscriptions`
--
ALTER TABLE `tblsubscriptions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltags`
--
ALTER TABLE `tbltags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltasks`
--
ALTER TABLE `tbltasks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltaskstimers`
--
ALTER TABLE `tbltaskstimers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltasks_checklist_templates`
--
ALTER TABLE `tbltasks_checklist_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltask_assigned`
--
ALTER TABLE `tbltask_assigned`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltask_checklist_items`
--
ALTER TABLE `tbltask_checklist_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltask_comments`
--
ALTER TABLE `tbltask_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltask_followers`
--
ALTER TABLE `tbltask_followers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltaxes`
--
ALTER TABLE `tbltaxes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltemplates`
--
ALTER TABLE `tbltemplates`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltickets`
--
ALTER TABLE `tbltickets`
  MODIFY `ticketid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltickets_pipe_log`
--
ALTER TABLE `tbltickets_pipe_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltickets_predefined_replies`
--
ALTER TABLE `tbltickets_predefined_replies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltickets_priorities`
--
ALTER TABLE `tbltickets_priorities`
  MODIFY `priorityid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbltickets_status`
--
ALTER TABLE `tbltickets_status`
  MODIFY `ticketstatusid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tblticket_attachments`
--
ALTER TABLE `tblticket_attachments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblticket_replies`
--
ALTER TABLE `tblticket_replies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltodos`
--
ALTER TABLE `tbltodos`
  MODIFY `todoid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltracked_mails`
--
ALTER TABLE `tbltracked_mails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbltwocheckout_log`
--
ALTER TABLE `tbltwocheckout_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbluser_meta`
--
ALTER TABLE `tbluser_meta`
  MODIFY `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tblvault`
--
ALTER TABLE `tblvault`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblviews_tracking`
--
ALTER TABLE `tblviews_tracking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblwallet`
--
ALTER TABLE `tblwallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblwallet_transaction`
--
ALTER TABLE `tblwallet_transaction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblwebhooks_debug_log`
--
ALTER TABLE `tblwebhooks_debug_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblwebhooks_master`
--
ALTER TABLE `tblwebhooks_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblweb_to_lead`
--
ALTER TABLE `tblweb_to_lead`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `tblfilter_defaults`
--
ALTER TABLE `tblfilter_defaults`
  ADD CONSTRAINT `tblfilter_defaults_ibfk_1` FOREIGN KEY (`filter_id`) REFERENCES `tblfilters` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tblfilter_defaults_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `tblstaff` (`staffid`) ON DELETE CASCADE;

--
-- Constraints for table `tbltwocheckout_log`
--
ALTER TABLE `tbltwocheckout_log`
  ADD CONSTRAINT `tbltwocheckout_log_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `tblinvoices` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tblwallet`
--
ALTER TABLE `tblwallet`
  ADD CONSTRAINT `fk_tbl_wallet_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `tblcontacts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tblwallet_transaction`
--
ALTER TABLE `tblwallet_transaction`
  ADD CONSTRAINT `fk_tbl_wallet_transactions_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `tblcontacts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

