INSERT INTO `cars` (`id`, `year`, `make`, `model`) VALUES
(11082, 2023, 'BMW', '4 Series'),
(11083, 2023, 'BMW', '5 Series'),
(11084, 2023, 'BMW', '7 Series'),
(11085, 2023, 'BMW', '8 Series'),
(11086, 2023, 'BMW', 'i4'),
(11087, 2023, 'BMW', 'i7'),
(11088, 2023, 'BMW', 'iX'),
(11089, 2023, 'BMW', 'M3'),
(11090, 2023, 'BMW', 'M4'),
(11091, 2023, 'BMW', 'M5'),
(11092, 2023, 'BMW', 'M8'),
(11093, 2023, 'BMW', 'X1'),
(11094, 2023, 'BMW', 'X2'),
(11095, 2023, 'BMW', 'X3'),
(11096, 2023, 'BMW', 'X3 M'),
(11097, 2023, 'BMW', 'X4'),
(11098, 2023, 'BMW', 'X5'),
(11099, 2023, 'BMW', 'X5 M'),
(11100, 2023, 'BMW', 'X6'),
(11101, 2023, 'BMW', 'X7'),
(11102, 2023, 'Buick', 'Enclave'),
(11103, 2023, 'Buick', 'Encore'),
(11104, 2023, 'Buick', 'Encore GX'),
(11105, 2023, 'Buick', 'Envision'),
(11106, 2023, 'Cadillac', 'CT4'),
(11107, 2023, 'Cadillac', 'CT5'),
(11108, 2023, 'Cadillac', 'Escalade'),
(11109, 2023, 'Cadillac', 'Escalade ESV'),
(11110, 2023, 'Cadillac', 'LYRIQ'),
(11111, 2023, 'Cadillac', 'XT4'),
(11112, 2023, 'Cadillac', 'XT5'),
(11113, 2023, 'Cadillac', 'XT6'),
(11114, 2023, 'Chevrolet', 'Blazer'),
(11115, 2023, 'Chevrolet', 'Bolt EUV'),
(11116, 2023, 'Chevrolet', 'Bolt EV'),
(11117, 2023, 'Chevrolet', 'Camaro'),
(11118, 2023, 'Chevrolet', 'Colorado Crew Cab'),
(11119, 2023, 'Chevrolet', 'Corvette'),
(11120, 2023, 'Chevrolet', 'Equinox'),
(11121, 2023, 'Chevrolet', 'Express 2500 Cargo'),
(11122, 2023, 'Chevrolet', 'Express 3500 Cargo'),
(11123, 2023, 'Chevrolet', 'Malibu'),
(11124, 2023, 'Chevrolet', 'Silverado 1500 Crew Cab'),
(11125, 2023, 'Chevrolet', 'Silverado 1500 Regular Cab'),
(11126, 2023, 'Chevrolet', 'Silverado 2500 HD Crew Cab'),
(11127, 2023, 'Chevrolet', 'Silverado 2500 HD Double Cab'),
(11128, 2023, 'Chevrolet', 'Silverado 2500 HD Regular Cab'),
(11129, 2023, 'Chevrolet', 'Silverado 3500 HD Regular Cab'),
(11130, 2023, 'Chevrolet', 'Spark'),
(11131, 2023, 'Chevrolet', 'Suburban'),
(11132, 2023, 'Chevrolet', 'Tahoe'),
(11133, 2023, 'Chevrolet', 'Trailblazer'),
(11134, 2023, 'Chevrolet', 'Traverse'),
(11135, 2023, 'Chevrolet', 'Trax'),
(11136, 2023, 'Chrysler', '300'),
(11137, 2023, 'Chrysler', 'Pacifica'),
(11138, 2023, 'Chrysler', 'Pacifica Hybrid'),
(11139, 2023, 'Dodge', 'Challenger'),
(11140, 2023, 'Dodge', 'Charger'),
(11141, 2023, 'Dodge', 'Durango'),
(11142, 2023, 'Dodge', 'Hornet'),
(11143, 2023, 'Ford', 'Bronco'),
(11144, 2023, 'Ford', 'Bronco Sport'),
(11145, 2023, 'Ford', 'Edge'),
(11146, 2023, 'Ford', 'Escape'),
(11147, 2023, 'Ford', 'E-Transit 350 Cargo Van'),
(11148, 2023, 'Ford', 'Expedition'),
(11149, 2023, 'Ford', 'Expedition MAX'),
(11150, 2023, 'Ford', 'Explorer'),
(11151, 2023, 'Ford', 'F150 Lightning'),
(11152, 2023, 'Ford', 'F150 SuperCrew Cab'),
(11153, 2023, 'Ford', 'Maverick'),
(11154, 2023, 'Ford', 'Mustang'),
(11155, 2023, 'Ford', 'Mustang MACH-E'),
(11156, 2023, 'Ford', 'Ranger SuperCab'),
(11157, 2023, 'Ford', 'Ranger SuperCrew'),
(11158, 2023, 'Ford', 'Transit Connect Cargo Van'),
(11159, 2023, 'Ford', 'Transit Connect Passenger Wagon'),
(11160, 2023, 'Genesis', 'Electrified G80'),
(11161, 2023, 'Genesis', 'G70'),
(11162, 2023, 'Genesis', 'G80'),
(11163, 2023, 'Genesis', 'G90'),
(11164, 2023, 'Genesis', 'GV60'),
(11165, 2023, 'Genesis', 'GV70'),
(11166, 2023, 'Genesis', 'GV80'),
(11167, 2023, 'GMC', 'Acadia'),
(11168, 2023, 'GMC', 'Canyon Crew Cab'),
(11169, 2023, 'GMC', 'Hummer EV Pickup'),
(11170, 2023, 'GMC', 'Savana 2500 Cargo'),
(11171, 2023, 'GMC', 'Savana 2500 Passenger'),
(11172, 2023, 'GMC', 'Savana 3500 Cargo'),
(11173, 2023, 'GMC', 'Savana 3500 Passenger'),
(11174, 2023, 'GMC', 'Sierra 1500 Crew Cab'),
(11175, 2023, 'GMC', 'Sierra 1500 Double Cab'),
(11176, 2023, 'GMC', 'Sierra 1500 Regular Cab'),
(11177, 2023, 'GMC', 'Sierra 2500 HD Regular Cab'),
(11178, 2023, 'GMC', 'Sierra 3500 HD Regular Cab'),
(11179, 2023, 'GMC', 'Terrain'),
(11180, 2023, 'GMC', 'Yukon'),
(11181, 2023, 'GMC', 'Yukon XL'),
(11182, 2023, 'Honda', 'Accord'),
(11183, 2023, 'Honda', 'Civic'),
(11184, 2023, 'Honda', 'CR-V'),
(11185, 2023, 'Honda', 'HR-V'),
(11186, 2023, 'Honda', 'Insight'),
(11187, 2023, 'Honda', 'Odyssey'),
(11188, 2023, 'Honda', 'Passport'),
(11189, 2023, 'Honda', 'Pilot'),
(11190, 2023, 'Honda', 'Ridgeline'),
(11191, 2023, 'Hyundai', 'Elantra'),
(11192, 2023, 'Hyundai', 'Elantra Hybrid'),
(11193, 2023, 'Hyundai', 'IONIQ 5'),
(11194, 2023, 'Hyundai', 'Ioniq Hybrid'),
(11195, 2023, 'Hyundai', 'Kona'),
(11196, 2023, 'Hyundai', 'Kona Electric'),
(11197, 2023, 'Hyundai', 'Kona N'),
(11198, 2023, 'Hyundai', 'Palisade'),
(11199, 2023, 'Hyundai', 'Santa Cruz'),
(11200, 2023, 'Hyundai', 'Santa Fe'),
(11201, 2023, 'Hyundai', 'Santa Fe Plug-in Hybrid'),
(11202, 2023, 'Hyundai', 'Sonata'),
(11203, 2023, 'Hyundai', 'Sonata Hybrid'),
(11204, 2023, 'Hyundai', 'Tucson'),
(11205, 2023, 'Hyundai', 'Tucson Hybrid'),
(11206, 2023, 'Hyundai', 'Tucson Plug-in Hybrid'),
(11207, 2023, 'Hyundai', 'Venue'),
(11208, 2023, 'INFINITI', 'Q50'),
(11209, 2023, 'INFINITI', 'QX50'),
(11210, 2023, 'INFINITI', 'QX55'),
(11211, 2023, 'INFINITI', 'QX60'),
(11212, 2023, 'Jaguar', 'E-PACE'),
(11213, 2023, 'Jaguar', 'F-PACE'),
(11214, 2023, 'Jaguar', 'F-TYPE'),
(11215, 2023, 'Jaguar', 'I-PACE'),
(11216, 2023, 'Jaguar', 'XF'),
(11217, 2023, 'Jeep', 'Compass'),
(11218, 2023, 'Jeep', 'Gladiator'),
(11219, 2023, 'Jeep', 'Grand Cherokee'),
(11220, 2023, 'Jeep', 'Grand Cherokee 4xe'),
(11221, 2023, 'Jeep', 'Grand Cherokee L'),
(11222, 2023, 'Jeep', 'Grand Wagoneer'),
(11223, 2023, 'Jeep', 'Grand Wagoneer L'),
(11224, 2023, 'Jeep', 'Renegade'),
(11225, 2023, 'Jeep', 'Wagoneer'),
(11226, 2023, 'Jeep', 'Wagoneer L'),
(11227, 2023, 'Jeep', 'Wrangler'),
(11228, 2023, 'Jeep', 'Wrangler Unlimited'),
(11229, 2023, 'Jeep', 'Wrangler Unlimited 4xe'),
(11230, 2023, 'Kia', 'Carnival'),
(11231, 2023, 'Kia', 'EV6'),
(11232, 2023, 'Kia', 'Forte'),
(11233, 2023, 'Kia', 'K5'),
(11234, 2023, 'Kia', 'Niro'),
(11235, 2023, 'Kia', 'Niro EV'),
(11236, 2023, 'Kia', 'Niro Plug-in Hybrid'),
(11237, 2023, 'Kia', 'Rio'),
(11238, 2023, 'Kia', 'Seltos'),
(11239, 2023, 'Kia', 'Sorento'),
(11240, 2023, 'Kia', 'Sorento Hybrid'),
(11241, 2023, 'Kia', 'Sorento Plug-in Hybrid'),
(11242, 2023, 'Kia', 'Soul'),
(11243, 2023, 'Kia', 'Sportage'),
(11244, 2023, 'Kia', 'Sportage Hybrid'),
(11245, 2023, 'Kia', 'Sportage Plug-in Hybrid'),
(11246, 2023, 'Kia', 'Stinger'),
(11247, 2023, 'Kia', 'Telluride'),
(11248, 2023, 'Land Rover', 'Defender 110'),
(11249, 2023, 'Land Rover', 'Defender 130'),
(11250, 2023, 'Land Rover', 'Defender 90'),
(11251, 2023, 'Land Rover', 'Discovery'),
(11252, 2023, 'Land Rover', 'Discovery Sport'),
(11253, 2023, 'Land Rover', 'Range Rover'),
(11254, 2023, 'Land Rover', 'Range Rover Evoque'),
(11255, 2023, 'Land Rover', 'Range Rover Sport'),
(11256, 2023, 'Land Rover', 'Range Rover Velar'),
(11257, 2023, 'Lexus', 'ES'),
(11258, 2023, 'Lexus', 'GX'),
(11259, 2023, 'Lexus', 'IS'),
(11260, 2023, 'Lexus', 'LS'),
(11261, 2023, 'Lexus', 'LX'),
(11262, 2023, 'Lexus', 'NX'),
(11263, 2023, 'Lexus', 'RX'),
(11264, 2023, 'Lexus', 'RZ'),
(11265, 2023, 'Lexus', 'TX'),
(11266, 2023, 'Lexus', 'UX'),
(11267, 2023, 'Lincoln', 'Aviator'),
(11268, 2023, 'Lincoln', 'Corsair'),
(11269, 2023, 'Lincoln', 'Nautilus'),
(11270, 2023, 'Lincoln', 'Navigator'),
(11271, 2023, 'Lincoln', 'Navigator L'),
(11272, 2023, 'Maserati', 'Grecale'),
(11273, 2023, 'MAZDA', 'CX-30'),
(11274, 2023, 'MAZDA', 'CX-5'),
(11275, 2023, 'MAZDA', 'CX-50'),
(11276, 2023, 'MAZDA', 'CX-9'),
(11277, 2023, 'MAZDA', 'CX-90'),
(11278, 2023, 'MAZDA', 'MAZDA3'),
(11279, 2023, 'Mercedes-Benz', 'C-Class'),
(11280, 2023, 'Mercedes-Benz', 'E-Class'),
(11281, 2023, 'Mercedes-Benz', 'GLA'),
(11282, 2023, 'Mercedes-Benz', 'GLB'),
(11283, 2023, 'Mercedes-Benz', 'GLC'),
(11284, 2023, 'Mercedes-Benz', 'GLE'),
(11285, 2023, 'Mercedes-Benz', 'GLS'),
(11286, 2023, 'Mercedes-Benz', 'Mercedes-EQ EQB'),
(11287, 2023, 'Mercedes-Benz', 'Mercedes-EQ EQE'),
(11288, 2023, 'Mercedes-Benz', 'Mercedes-EQ EQE SUV'),
(11289, 2023, 'Mercedes-Benz', 'Mercedes-EQ EQS'),
(11290, 2023, 'Mercedes-Benz', 'Mercedes-EQ EQS SUV'),
(11291, 2023, 'MINI', 'Clubman'),
(11292, 2023, 'MINI', 'Convertible'),
(11293, 2023, 'MINI', 'Countryman'),
(11294, 2023, 'MINI', 'Hardtop 2 Door'),
(11295, 2023, 'MINI', 'Hardtop 4 Door'),
(11296, 2023, 'Mitsubishi', 'Eclipse Cross'),
(11297, 2023, 'Mitsubishi', 'Mirage'),
(11298, 2023, 'Mitsubishi', 'Mirage G4'),
(11299, 2023, 'Mitsubishi', 'Outlander'),
(11300, 2023, 'Mitsubishi', 'Outlander PHEV'),
(11301, 2023, 'Mitsubishi', 'Outlander Sport'),
(11302, 2023, 'Nissan', 'Altima'),
(11303, 2023, 'Nissan', 'Ariya'),
(11304, 2023, 'Nissan', 'Armada'),
(11305, 2023, 'Nissan', 'Frontier Crew Cab'),
(11306, 2023, 'Nissan', 'Frontier King Cab'),
(11307, 2023, 'Nissan', 'Kicks'),
(11308, 2023, 'Nissan', 'LEAF'),
(11309, 2023, 'Nissan', 'Maxima'),
(11310, 2023, 'Nissan', 'Murano'),
(11311, 2023, 'Nissan', 'Pathfinder'),
(11312, 2023, 'Nissan', 'Rogue'),
(11313, 2023, 'Nissan', 'Rogue Sport'),
(11314, 2023, 'Nissan', 'Sentra'),
(11315, 2023, 'Nissan', 'Titan Crew Cab'),
(11316, 2023, 'Nissan', 'Titan King Cab'),
(11317, 2023, 'Nissan', 'TITAN XD Crew Cab'),
(11318, 2023, 'Nissan', 'Versa'),
(11319, 2023, 'Nissan', 'Z'),
(11320, 2023, 'Polestar', '2'),
(11321, 2023, 'Polestar', '3'),
(11322, 2023, 'Porsche', '718 Spyder'),
(11323, 2023, 'Porsche', 'Cayenne'),
(11324, 2023, 'Porsche', 'Macan'),
(11325, 2023, 'Ram', '1500 Classic Crew Cab'),
(11326, 2023, 'Ram', '1500 Classic Quad Cab'),
(11327, 2023, 'Ram', '1500 Classic Regular Cab'),
(11328, 2023, 'Ram', '1500 Crew Cab'),
(11329, 2023, 'Ram', '1500 Quad Cab'),
(11330, 2023, 'Ram', 'ProMaster Cargo Van'),
(11331, 2023, 'Ram', 'ProMaster Window Van'),
(11332, 2023, 'Subaru', 'Ascent'),
(11333, 2023, 'Subaru', 'BRZ'),
(11334, 2023, 'Subaru', 'Crosstrek'),
(11335, 2023, 'Subaru', 'Forester'),
(11336, 2023, 'Subaru', 'Impreza'),
(11337, 2023, 'Subaru', 'Legacy'),
(11338, 2023, 'Subaru', 'Outback'),
(11339, 2023, 'Subaru', 'Solterra'),
(11340, 2023, 'Subaru', 'WRX'),
(11341, 2023, 'Tesla', 'Cybertruck'),
(11342, 2023, 'Tesla', 'Model 3'),
(11343, 2023, 'Tesla', 'Model S'),
(11344, 2023, 'Tesla', 'Model X'),
(11345, 2023, 'Tesla', 'Model Y'),
(11346, 2023, 'Toyota', '4Runner'),
(11347, 2023, 'Toyota', '86'),
(11348, 2023, 'Toyota', 'bZ4X'),
(11349, 2023, 'Toyota', 'Camry'),
(11350, 2023, 'Toyota', 'Camry Hybrid'),
(11351, 2023, 'Toyota', 'C-HR'),
(11352, 2023, 'Toyota', 'Corolla'),
(11353, 2023, 'Toyota', 'Corolla Cross'),
(11354, 2023, 'Toyota', 'Corolla Cross Hybrid'),
(11355, 2023, 'Toyota', 'Corolla Hatchback'),
(11356, 2023, 'Toyota', 'Corolla Hybrid'),
(11357, 2023, 'Toyota', 'Crown'),
(11358, 2023, 'Toyota', 'GR Supra'),
(11359, 2023, 'Toyota', 'GR86'),
(11360, 2023, 'Toyota', 'Highlander'),
(11361, 2023, 'Toyota', 'Highlander Hybrid'),
(11362, 2023, 'Toyota', 'Prius'),
(11363, 2023, 'Toyota', 'RAV4'),
(11364, 2023, 'Toyota', 'RAV4 Hybrid'),
(11365, 2023, 'Toyota', 'RAV4 Prime'),
(11366, 2023, 'Toyota', 'Sequoia'),
(11367, 2023, 'Toyota', 'Sienna'),
(11368, 2023, 'Toyota', 'Tacoma Access Cab'),
(11369, 2023, 'Toyota', 'Tundra CrewMax'),
(11370, 2023, 'Toyota', 'Venza'),
(11371, 2023, 'VinFast', 'VF 8'),
(11372, 2023, 'VinFast', 'VF 9'),
(11373, 2023, 'Volkswagen', 'Arteon'),
(11374, 2023, 'Volkswagen', 'Atlas'),
(11375, 2023, 'Volkswagen', 'Atlas Cross Sport'),
(11376, 2023, 'Volkswagen', 'Golf GTI'),
(11377, 2023, 'Volkswagen', 'Golf R'),
(11378, 2023, 'Volkswagen', 'ID.4'),
(11379, 2023, 'Volkswagen', 'Jetta'),
(11380, 2023, 'Volkswagen', 'Jetta GLI'),
(11381, 2023, 'Volkswagen', 'Taos'),
(11382, 2023, 'Volkswagen', 'Tiguan'),
(11383, 2023, 'Volvo', 'C40 Recharge'),
(11384, 2023, 'Volvo', 'S60'),
(11385, 2023, 'Volvo', 'S90'),
(11386, 2023, 'Volvo', 'V60'),
(11387, 2023, 'Volvo', 'V90'),
(11388, 2023, 'Volvo', 'XC40'),
(11389, 2023, 'Volvo', 'XC40 Recharge'),
(11390, 2023, 'Volvo', 'XC60'),
(11391, 2023, 'Volvo', 'XC90'),
(11392, 2024, 'Acura', 'Integra'),
(11393, 2024, 'Acura', 'MDX'),
(11394, 2024, 'Acura', 'RDX'),
(11395, 2024, 'Acura', 'TLX'),
(11396, 2024, 'Acura', 'ZDX'),
(11397, 2024, 'Alfa Romeo', 'Giulia'),
(11398, 2024, 'Alfa Romeo', 'Stelvio'),
(11399, 2024, 'Alfa Romeo', 'Tonale'),
(11400, 2024, 'Aston Martin', 'DBX'),
(11401, 2024, 'Audi', 'A3'),
(11402, 2024, 'Audi', 'A4'),
(11403, 2024, 'Audi', 'A4 allroad'),
(11404, 2024, 'Audi', 'A5'),
(11405, 2024, 'Audi', 'A6'),
(11406, 2024, 'Audi', 'A6 allroad'),
(11407, 2024, 'Audi', 'A7'),
(11408, 2024, 'Audi', 'A8'),
(11409, 2024, 'Audi', 'e-tron GT'),
(11410, 2024, 'Audi', 'Q3'),
(11411, 2024, 'Audi', 'Q4 e-tron'),
(11412, 2024, 'Audi', 'Q4 Sportback e-tron'),
(11413, 2024, 'Audi', 'Q5'),
(11414, 2024, 'Audi', 'Q5 Sportback'),
(11415, 2024, 'Audi', 'Q7'),
(11416, 2024, 'Audi', 'Q8'),
(11417, 2024, 'Audi', 'Q8 e-tron'),
(11418, 2024, 'Audi', 'Q8 Sportback e-tron'),
(11419, 2024, 'Audi', 'RS 3'),
(11420, 2024, 'Audi', 'RS 5'),
(11421, 2024, 'Audi', 'RS 6'),
(11422, 2024, 'Audi', 'RS 7'),
(11423, 2024, 'Audi', 'RS e-tron GT'),
(11424, 2024, 'Audi', 'RS Q8'),
(11425, 2024, 'Audi', 'S3'),
(11426, 2024, 'Audi', 'S4'),
(11427, 2024, 'Audi', 'S5'),
(11428, 2024, 'Audi', 'S6'),
(11429, 2024, 'Audi', 'S7'),
(11430, 2024, 'Audi', 'S8'),
(11431, 2024, 'Audi', 'SQ5'),
(11432, 2024, 'Audi', 'SQ5 Sportback'),
(11433, 2024, 'Audi', 'SQ7'),
(11434, 2024, 'Audi', 'SQ8'),
(11435, 2024, 'Audi', 'SQ8 e-tron'),
(11436, 2024, 'Audi', 'SQ8 Sportback e-tron'),
(11437, 2024, 'BMW', '2 Series'),
(11438, 2024, 'BMW', '3 Series'),
(11439, 2024, 'BMW', '4 Series'),
(11440, 2024, 'BMW', '5 Series'),
(11441, 2024, 'BMW', '7 Series'),
(11442, 2024, 'BMW', '8 Series'),
(11443, 2024, 'BMW', 'i4'),
(11444, 2024, 'BMW', 'i5'),
(11445, 2024, 'BMW', 'i7'),
(11446, 2024, 'BMW', 'iX'),
(11447, 2024, 'BMW', 'M2'),
(11448, 2024, 'BMW', 'M3'),
(11449, 2024, 'BMW', 'M4'),
(11450, 2024, 'BMW', 'M8'),
(11451, 2024, 'BMW', 'X1'),
(11452, 2024, 'BMW', 'X2'),
(11453, 2024, 'BMW', 'X3'),
(11454, 2024, 'BMW', 'X3 M'),
(11455, 2024, 'BMW', 'X4'),
(11456, 2024, 'BMW', 'X4 M'),
(11457, 2024, 'BMW', 'X5'),
(11458, 2024, 'BMW', 'X5 M'),
(11459, 2024, 'BMW', 'X6'),
(11460, 2024, 'BMW', 'X6 M'),
(11461, 2024, 'BMW', 'X7'),
(11462, 2024, 'BMW', 'XM'),
(11463, 2024, 'BMW', 'Z4'),
(11464, 2024, 'Buick', 'Enclave'),
(11465, 2024, 'Buick', 'Encore GX'),
(11466, 2024, 'Buick', 'Envision'),
(11467, 2024, 'Buick', 'Envista'),
(11468, 2024, 'Cadillac', 'Celestiq'),
(11469, 2024, 'Cadillac', 'CT4'),
(11470, 2024, 'Cadillac', 'CT5'),
(11471, 2024, 'Cadillac', 'Escalade'),
(11472, 2024, 'Cadillac', 'Escalade ESV'),
(11473, 2024, 'Cadillac', 'LYRIQ'),
(11474, 2024, 'Cadillac', 'XT4'),
(11475, 2024, 'Cadillac', 'XT5'),
(11476, 2024, 'Cadillac', 'XT6'),
(11477, 2024, 'Chevrolet', 'Blazer'),
(11478, 2024, 'Chevrolet', 'Blazer EV'),
(11479, 2024, 'Chevrolet', 'Camaro'),
(11480, 2024, 'Chevrolet', 'Colorado Crew Cab'),
(11481, 2024, 'Chevrolet', 'Corvette'),
(11482, 2024, 'Chevrolet', 'Equinox'),
(11483, 2024, 'Chevrolet', 'Equinox EV'),
(11484, 2024, 'Chevrolet', 'Express 2500 Cargo'),
(11485, 2024, 'Chevrolet', 'Express 2500 Passenger'),
(11486, 2024, 'Chevrolet', 'Express 3500 Cargo'),
(11487, 2024, 'Chevrolet', 'Express 3500 Passenger'),
(11488, 2024, 'Chevrolet', 'Malibu'),
(11489, 2024, 'Chevrolet', 'Silverado 1500 Crew Cab'),
(11490, 2024, 'Chevrolet', 'Silverado 1500 Double Cab'),
(11491, 2024, 'Chevrolet', 'Silverado 1500 Regular Cab'),
(11492, 2024, 'Chevrolet', 'Silverado 2500 HD Crew Cab'),
(11493, 2024, 'Chevrolet', 'Silverado 2500 HD Double Cab'),
(11494, 2024, 'Chevrolet', 'Silverado 2500 HD Regular Cab'),
(11495, 2024, 'Chevrolet', 'Silverado 3500 HD Crew Cab'),
(11496, 2024, 'Chevrolet', 'Silverado 3500 HD Double Cab'),
(11497, 2024, 'Chevrolet', 'Silverado 3500 HD Regular Cab'),
(11498, 2024, 'Chevrolet', 'Suburban'),
(11499, 2024, 'Chevrolet', 'Tahoe'),
(11500, 2024, 'Chevrolet', 'Trailblazer'),
(11501, 2024, 'Chevrolet', 'Traverse'),
(11502, 2024, 'Chevrolet', 'Traverse Limited'),
(11503, 2024, 'Chevrolet', 'Trax'),
(11504, 2024, 'Chrysler', 'Pacifica'),
(11505, 2024, 'Chrysler', 'Pacifica Hybrid'),
(11506, 2024, 'Dodge', 'Durango'),
(11507, 2024, 'Dodge', 'Hornet'),
(11508, 2024, 'FIAT', '500e'),
(11509, 2024, 'Fisker', 'Ocean'),
(11510, 2024, 'Ford', 'Bronco'),
(11511, 2024, 'Ford', 'Bronco Sport'),
(11512, 2024, 'Ford', 'E-Transit 350 Cargo Van'),
(11513, 2024, 'Ford', 'Edge'),
(11514, 2024, 'Ford', 'Escape'),
(11515, 2024, 'Ford', 'Escape Plug-in Hybrid'),
(11516, 2024, 'Ford', 'Expedition'),
(11517, 2024, 'Ford', 'Expedition MAX'),
(11518, 2024, 'Ford', 'Explorer'),
(11519, 2024, 'Ford', 'F150 Lightning'),
(11520, 2024, 'Ford', 'F150 Regular Cab'),
(11521, 2024, 'Ford', 'F150 Super Cab'),
(11522, 2024, 'Ford', 'F150 SuperCrew Cab'),
(11523, 2024, 'Ford', 'F250 Super Duty Crew Cab'),
(11524, 2024, 'Ford', 'F250 Super Duty Regular Cab'),
(11525, 2024, 'Ford', 'F250 Super Duty Super Cab'),
(11526, 2024, 'Ford', 'F350 Super Duty Crew Cab'),
(11527, 2024, 'Ford', 'F350 Super Duty Regular Cab'),
(11528, 2024, 'Ford', 'F350 Super Duty Super Cab'),
(11529, 2024, 'Ford', 'F450 Super Duty Crew Cab'),
(11530, 2024, 'Ford', 'F450 Super Duty Regular Cab'),
(11531, 2024, 'Ford', 'Maverick'),
(11532, 2024, 'Ford', 'Mustang'),
(11533, 2024, 'Ford', 'Mustang MACH-E'),
(11534, 2024, 'Ford', 'Ranger SuperCrew'),
(11535, 2024, 'Ford', 'Transit 150 Cargo Van'),
(11536, 2024, 'Ford', 'Transit 250 Cargo Van'),
(11537, 2024, 'Ford', 'Transit 350 Cargo Van'),
(11538, 2024, 'Ford', 'Transit 350 HD Cargo Van'),
(11539, 2024, 'Ford', 'Transit 350 Passenger Van'),
(11540, 2024, 'Genesis', 'Electrified G80'),
(11541, 2024, 'Genesis', 'Electrified GV70'),
(11542, 2024, 'Genesis', 'G70'),
(11543, 2024, 'Genesis', 'G80'),
(11544, 2024, 'Genesis', 'G90'),
(11545, 2024, 'Genesis', 'GV60'),
(11546, 2024, 'Genesis', 'GV70'),
(11547, 2024, 'Genesis', 'GV80'),
(11548, 2024, 'GMC', 'Acadia'),
(11549, 2024, 'GMC', 'Canyon Crew Cab'),
(11550, 2024, 'GMC', 'HUMMER EV Pickup'),
(11551, 2024, 'GMC', 'HUMMER EV SUV'),
(11552, 2024, 'GMC', 'Savana 2500 Cargo'),
(11553, 2024, 'GMC', 'Savana 2500 Passenger'),
(11554, 2024, 'GMC', 'Savana 3500 Cargo'),
(11555, 2024, 'GMC', 'Savana 3500 Passenger'),
(11556, 2024, 'GMC', 'Sierra 1500 Crew Cab'),
(11557, 2024, 'GMC', 'Sierra 1500 Double Cab'),
(11558, 2024, 'GMC', 'Sierra 1500 Regular Cab'),
(11559, 2024, 'GMC', 'Sierra 2500 HD Crew Cab'),
(11560, 2024, 'GMC', 'Sierra 2500 HD Double Cab'),
(11561, 2024, 'GMC', 'Sierra 2500 HD Regular Cab'),
(11562, 2024, 'GMC', 'Sierra 3500 HD Crew Cab'),
(11563, 2024, 'GMC', 'Sierra 3500 HD Double Cab'),
(11564, 2024, 'GMC', 'Sierra 3500 HD Regular Cab'),
(11565, 2024, 'GMC', 'Sierra EV'),
(11566, 2024, 'GMC', 'Terrain'),
(11567, 2024, 'GMC', 'Yukon'),
(11568, 2024, 'GMC', 'Yukon XL'),
(11569, 2024, 'Honda', 'Accord'),
(11570, 2024, 'Honda', 'Accord Hybrid'),
(11571, 2024, 'Honda', 'Civic'),
(11572, 2024, 'Honda', 'Civic Type R'),
(11573, 2024, 'Honda', 'CR-V'),
(11574, 2024, 'Honda', 'CR-V Hybrid'),
(11575, 2024, 'Honda', 'HR-V'),
(11576, 2024, 'Honda', 'Odyssey'),
(11577, 2024, 'Honda', 'Passport'),
(11578, 2024, 'Honda', 'Pilot'),
(11579, 2024, 'Honda', 'Prologue'),
(11580, 2024, 'Honda', 'Ridgeline'),
(11581, 2024, 'Hyundai', 'Elantra'),
(11582, 2024, 'Hyundai', 'Elantra Hybrid'),
(11583, 2024, 'Hyundai', 'IONIQ 5'),
(11584, 2024, 'Hyundai', 'IONIQ 6'),
(11585, 2024, 'Hyundai', 'IONIQ 7'),
(11586, 2024, 'Hyundai', 'Kona'),
(11587, 2024, 'Hyundai', 'Kona Electric'),
(11588, 2024, 'Hyundai', 'NEXO'),
(11589, 2024, 'Hyundai', 'Palisade'),
(11590, 2024, 'Hyundai', 'Santa Cruz'),
(11591, 2024, 'Hyundai', 'Santa Fe'),
(11592, 2024, 'Hyundai', 'Santa Fe Hybrid'),
(11593, 2024, 'Hyundai', 'Sonata'),
(11594, 2024, 'Hyundai', 'Sonata Hybrid'),
(11595, 2024, 'Hyundai', 'Tucson'),
(11596, 2024, 'Hyundai', 'Tucson Hybrid'),
(11597, 2024, 'Hyundai', 'Tucson Plug-in Hybrid'),
(11598, 2024, 'Hyundai', 'Venue'),
(11599, 2024, 'INFINITI', 'Q50'),
(11600, 2024, 'INFINITI', 'QX50'),
(11601, 2024, 'INFINITI', 'QX55'),
(11602, 2024, 'INFINITI', 'QX60'),
(11603, 2024, 'INFINITI', 'QX80'),
(11604, 2024, 'Jaguar', 'E-PACE'),
(11605, 2024, 'Jaguar', 'F-PACE'),
(11606, 2024, 'Jaguar', 'F-TYPE'),
(11607, 2024, 'Jaguar', 'I-PACE'),
(11608, 2024, 'Jaguar', 'XF'),
(11609, 2024, 'Jeep', 'Compass'),
(11610, 2024, 'Jeep', 'Gladiator'),
(11611, 2024, 'Jeep', 'Grand Cherokee'),
(11612, 2024, 'Jeep', 'Grand Cherokee 4xe'),
(11613, 2024, 'Jeep', 'Grand Cherokee L'),
(11614, 2024, 'Jeep', 'Grand Wagoneer'),
(11615, 2024, 'Jeep', 'Grand Wagoneer L'),
(11616, 2024, 'Jeep', 'Recon'),
(11617, 2024, 'Jeep', 'Wagoneer'),
(11618, 2024, 'Jeep', 'Wagoneer L'),
(11619, 2024, 'Jeep', 'Wrangler'),
(11620, 2024, 'Jeep', 'Wrangler 2 Door'),
(11621, 2024, 'Jeep', 'Wrangler 4 Door'),
(11622, 2024, 'Jeep', 'Wrangler 4xe'),
(11623, 2024, 'Kia', 'Carnival'),
(11624, 2024, 'Kia', 'EV6'),
(11625, 2024, 'Kia', 'EV9'),
(11626, 2024, 'Kia', 'Forte'),
(11627, 2024, 'Kia', 'K5'),
(11628, 2024, 'Kia', 'Niro'),
(11629, 2024, 'Kia', 'Niro EV'),
(11630, 2024, 'Kia', 'Niro Plug-in Hybrid'),
(11631, 2024, 'Kia', 'Seltos'),
(11632, 2024, 'Kia', 'Sorento'),
(11633, 2024, 'Kia', 'Sorento Hybrid'),
(11634, 2024, 'Kia', 'Sorento Plug-in Hybrid'),
(11635, 2024, 'Kia', 'Soul'),
(11636, 2024, 'Kia', 'Sportage'),
(11637, 2024, 'Kia', 'Sportage Hybrid'),
(11638, 2024, 'Kia', 'Sportage Plug-in Hybrid'),
(11639, 2024, 'Kia', 'Telluride'),
(11640, 2024, 'Land Rover', 'Defender 110'),
(11641, 2024, 'Land Rover', 'Defender 130'),
(11642, 2024, 'Land Rover', 'Defender 90'),
(11643, 2024, 'Land Rover', 'Discovery'),
(11644, 2024, 'Land Rover', 'Discovery Sport'),
(11645, 2024, 'Land Rover', 'Range Rover'),
(11646, 2024, 'Land Rover', 'Range Rover Evoque'),
(11647, 2024, 'Land Rover', 'Range Rover Sport'),
(11648, 2024, 'Land Rover', 'Range Rover Velar'),
(11649, 2024, 'Lexus', 'ES'),
(11650, 2024, 'Lexus', 'GX'),
(11651, 2024, 'Lexus', 'IS'),
(11652, 2024, 'Lexus', 'LC'),
(11653, 2024, 'Lexus', 'LS'),
(11654, 2024, 'Lexus', 'LX'),
(11655, 2024, 'Lexus', 'NX'),
(11656, 2024, 'Lexus', 'RC'),
(11657, 2024, 'Lexus', 'RX'),
(11658, 2024, 'Lexus', 'RZ'),
(11659, 2024, 'Lexus', 'TX'),
(11660, 2024, 'Lexus', 'UX'),
(11661, 2024, 'Lincoln', 'Aviator'),
(11662, 2024, 'Lincoln', 'Corsair'),
(11663, 2024, 'Lincoln', 'Nautilus'),
(11664, 2024, 'Lincoln', 'Navigator'),
(11665, 2024, 'Lincoln', 'Navigator L'),
(11666, 2024, 'Lucid', 'Air'),
(11667, 2024, 'Maserati', 'Ghibli'),
(11668, 2024, 'Maserati', 'GranTurismo'),
(11669, 2024, 'Maserati', 'Grecale'),
(11670, 2024, 'Maserati', 'Levante'),
(11671, 2024, 'Maserati', 'Quattroporte'),
(11672, 2024, 'MAZDA', 'CX-30'),
(11673, 2024, 'MAZDA', 'CX-5'),
(11674, 2024, 'MAZDA', 'CX-50'),
(11675, 2024, 'MAZDA', 'CX-70'),
(11676, 2024, 'MAZDA', 'CX-90'),
(11677, 2024, 'MAZDA', 'CX-90 PHEV'),
(11678, 2024, 'MAZDA', 'MAZDA3'),
(11679, 2024, 'MAZDA', 'MX-5 Miata'),
(11680, 2024, 'Mercedes-Benz', 'C-Class'),
(11681, 2024, 'Mercedes-Benz', 'CLA'),
(11682, 2024, 'Mercedes-Benz', 'CLE'),
(11683, 2024, 'Mercedes-Benz', 'E-Class'),
(11684, 2024, 'Mercedes-Benz', 'eSprinter'),
(11685, 2024, 'Mercedes-Benz', 'G-Class'),
(11686, 2024, 'Mercedes-Benz', 'GLA'),
(11687, 2024, 'Mercedes-Benz', 'GLB'),
(11688, 2024, 'Mercedes-Benz', 'GLC'),
(11689, 2024, 'Mercedes-Benz', 'GLC Coupe'),
(11690, 2024, 'Mercedes-Benz', 'GLE'),
(11691, 2024, 'Mercedes-Benz', 'GLS'),
(11692, 2024, 'Mercedes-Benz', 'Mercedes-AMG CLA'),
(11693, 2024, 'Mercedes-Benz', 'Mercedes-AMG EQE'),
(11694, 2024, 'Mercedes-Benz', 'Mercedes-AMG EQE SUV'),
(11695, 2024, 'Mercedes-Benz', 'Mercedes-AMG EQS'),
(11696, 2024, 'Mercedes-Benz', 'Mercedes-AMG G-Class'),
(11697, 2024, 'Mercedes-Benz', 'Mercedes-AMG GLA'),
(11698, 2024, 'Mercedes-Benz', 'Mercedes-AMG GLB'),
(11699, 2024, 'Mercedes-Benz', 'Mercedes-AMG GLE'),
(11700, 2024, 'Mercedes-Benz', 'Mercedes-AMG GLE Coupe'),
(11701, 2024, 'Mercedes-Benz', 'Mercedes-AMG GT'),
(11702, 2024, 'Mercedes-Benz', 'Mercedes-EQ EQB'),
(11703, 2024, 'Mercedes-Benz', 'Mercedes-EQ EQE'),
(11704, 2024, 'Mercedes-Benz', 'Mercedes-EQ EQE SUV'),
(11705, 2024, 'Mercedes-Benz', 'Mercedes-EQ EQS'),
(11706, 2024, 'Mercedes-Benz', 'Mercedes-EQ EQS SUV'),
(11707, 2024, 'Mercedes-Benz', 'Mercedes-Maybach EQS SUV'),
(11708, 2024, 'Mercedes-Benz', 'Mercedes-Maybach GLS'),
(11709, 2024, 'Mercedes-Benz', 'Mercedes-Maybach S-Class'),
(11710, 2024, 'Mercedes-Benz', 'S-Class'),
(11711, 2024, 'Mercedes-Benz', 'Sprinter 2500 Cargo'),
(11712, 2024, 'Mercedes-Benz', 'Sprinter 2500 Crew'),
(11713, 2024, 'Mercedes-Benz', 'Sprinter 2500 Passenger'),
(11714, 2024, 'Mercedes-Benz', 'Sprinter 3500 Cargo'),
(11715, 2024, 'Mercedes-Benz', 'Sprinter 3500 XD Cargo'),
(11716, 2024, 'Mercedes-Benz', 'Sprinter 4500 Cargo'),
(11717, 2024, 'MINI', 'Clubman'),
(11718, 2024, 'MINI', 'Convertible'),
(11719, 2024, 'MINI', 'Countryman'),
(11720, 2024, 'MINI', 'Hardtop 2 Door'),
(11721, 2024, 'MINI', 'Hardtop 4 Door'),
(11722, 2024, 'Mitsubishi', 'Eclipse Cross'),
(11723, 2024, 'Mitsubishi', 'Mirage'),
(11724, 2024, 'Mitsubishi', 'Mirage G4'),
(11725, 2024, 'Mitsubishi', 'Outlander'),
(11726, 2024, 'Mitsubishi', 'Outlander PHEV'),
(11727, 2024, 'Mitsubishi', 'Outlander Sport'),
(11728, 2024, 'Nissan', 'Altima'),
(11729, 2024, 'Nissan', 'Armada'),
(11730, 2024, 'Nissan', 'Frontier Crew Cab'),
(11731, 2024, 'Nissan', 'Frontier King Cab'),
(11732, 2024, 'Nissan', 'GT-R'),
(11733, 2024, 'Nissan', 'Kicks'),
(11734, 2024, 'Nissan', 'LEAF'),
(11735, 2024, 'Nissan', 'Murano'),
(11736, 2024, 'Nissan', 'Pathfinder'),
(11737, 2024, 'Nissan', 'Rogue'),
(11738, 2024, 'Nissan', 'Sentra'),
(11739, 2024, 'Nissan', 'Titan Crew Cab'),
(11740, 2024, 'Nissan', 'Titan King Cab'),
(11741, 2024, 'Nissan', 'TITAN XD Crew Cab'),
(11742, 2024, 'Nissan', 'Versa'),
(11743, 2024, 'Nissan', 'Z'),
(11744, 2024, 'Polestar', '2'),
(11745, 2024, 'Polestar', '3'),
(11746, 2024, 'Polestar', '4'),
(11747, 2024, 'Polestar', '5'),
(11748, 2024, 'Porsche', '718 Boxster'),
(11749, 2024, 'Porsche', '718 Cayman'),
(11750, 2024, 'Porsche', '718 Spyder'),
(11751, 2024, 'Porsche', '911'),
(11752, 2024, 'Porsche', 'Cayenne'),
(11753, 2024, 'Porsche', 'Cayenne Coupe'),
(11754, 2024, 'Porsche', 'Macan'),
(11755, 2024, 'Porsche', 'Panamera'),
(11756, 2024, 'Porsche', 'Taycan'),
(11757, 2024, 'Porsche', 'Taycan Cross Turismo'),
(11758, 2024, 'Porsche', 'Taycan Sport Turismo'),
(11759, 2024, 'Ram', '1500 Crew Cab'),
(11760, 2024, 'Ram', '1500 Quad Cab'),
(11761, 2024, 'Ram', '2500 Crew Cab'),
(11762, 2024, 'Ram', '2500 Mega Cab'),
(11763, 2024, 'Ram', '2500 Regular Cab'),
(11764, 2024, 'Ram', '3500 Crew Cab'),
(11765, 2024, 'Ram', '3500 Mega Cab'),
(11766, 2024, 'Ram', '3500 Regular Cab'),
(11767, 2024, 'Ram', 'ProMaster Cargo Van'),
(11768, 2024, 'Ram', 'ProMaster Window Van'),
(11769, 2024, 'Rivian', 'R1S'),
(11770, 2024, 'Rivian', 'R1T'),
(11771, 2024, 'Subaru', 'Ascent'),
(11772, 2024, 'Subaru', 'BRZ'),
(11773, 2024, 'Subaru', 'Crosstrek'),
(11774, 2024, 'Subaru', 'Forester'),
(11775, 2024, 'Subaru', 'Impreza'),
(11776, 2024, 'Subaru', 'Legacy'),
(11777, 2024, 'Subaru', 'Outback'),
(11778, 2024, 'Subaru', 'WRX'),
(11779, 2024, 'Tesla', 'Cybertruck'),
(11780, 2024, 'Tesla', 'Model 3'),
(11781, 2024, 'Tesla', 'Model S'),
(11782, 2024, 'Tesla', 'Model X'),
(11783, 2024, 'Tesla', 'Model Y'),
(11784, 2024, 'Toyota', '4Runner'),
(11785, 2024, 'Toyota', 'Camry'),
(11786, 2024, 'Toyota', 'Camry Hybrid'),
(11787, 2024, 'Toyota', 'Corolla'),
(11788, 2024, 'Toyota', 'Corolla Cross'),
(11789, 2024, 'Toyota', 'Corolla Cross Hybrid'),
(11790, 2024, 'Toyota', 'Corolla Hatchback'),
(11791, 2024, 'Toyota', 'Corolla Hybrid'),
(11792, 2024, 'Toyota', 'Crown'),
(11793, 2024, 'Toyota', 'GR Corolla'),
(11794, 2024, 'Toyota', 'GR Supra'),
(11795, 2024, 'Toyota', 'GR86'),
(11796, 2024, 'Toyota', 'Grand Highlander'),
(11797, 2024, 'Toyota', 'Grand Highlander Hybrid'),
(11798, 2024, 'Toyota', 'Highlander'),
(11799, 2024, 'Toyota', 'Highlander Hybrid'),
(11800, 2024, 'Toyota', 'Land Cruiser'),
(11801, 2024, 'Toyota', 'Mirai'),
(11802, 2024, 'Toyota', 'Prius'),
(11803, 2024, 'Toyota', 'Prius Prime'),
(11804, 2024, 'Toyota', 'RAV4'),
(11805, 2024, 'Toyota', 'RAV4 Hybrid'),
(11806, 2024, 'Toyota', 'RAV4 Prime'),
(11807, 2024, 'Toyota', 'Sequoia'),
(11808, 2024, 'Toyota', 'Sienna'),
(11809, 2024, 'Toyota', 'Tacoma Double Cab'),
(11810, 2024, 'Toyota', 'Tacoma XtraCab'),
(11811, 2024, 'Toyota', 'Tundra CrewMax'),
(11812, 2024, 'Toyota', 'Tundra Double Cab'),
(11813, 2024, 'Toyota', 'Tundra Hybrid CrewMax'),
(11814, 2024, 'Toyota', 'Venza'),
(11815, 2024, 'VinFast', 'VF 6'),
(11816, 2024, 'VinFast', 'VF 7'),
(11817, 2024, 'VinFast', 'VF 8'),
(11818, 2024, 'Volkswagen', 'Atlas'),
(11819, 2024, 'Volkswagen', 'Atlas Cross Sport'),
(11820, 2024, 'Volkswagen', 'Golf GTI'),
(11821, 2024, 'Volkswagen', 'Golf R'),
(11822, 2024, 'Volkswagen', 'Jetta'),
(11823, 2024, 'Volkswagen', 'Jetta GLI'),
(11824, 2024, 'Volkswagen', 'Taos'),
(11825, 2024, 'Volkswagen', 'Tiguan'),
(11826, 2024, 'Volvo', 'C40 Recharge'),
(11827, 2024, 'Volvo', 'S60'),
(11828, 2024, 'Volvo', 'S90'),
(11829, 2024, 'Volvo', 'V60'),
(11830, 2024, 'Volvo', 'V90'),
(11831, 2024, 'Volvo', 'XC40'),
(11832, 2024, 'Volvo', 'XC40 Recharge'),
(11833, 2024, 'Volvo', 'XC60'),
(11834, 2024, 'Volvo', 'XC90'),
(11835, 2025, 'Audi', 'Q6 e-tron'),
(11836, 2025, 'Cadillac', 'CT5'),
(11837, 2025, 'Cadillac', 'Escalade IQ'),
(11838, 2025, 'Cadillac', 'OPTIQ'),
(11839, 2025, 'Chevrolet', 'Silverado EV'),
(11840, 2025, 'Chevrolet', 'Suburban'),
(11841, 2025, 'Chevrolet', 'Tahoe'),
(11842, 2025, 'Dodge', 'Charger'),
(11843, 2025, 'Fisker', 'Alaska'),
(11844, 2025, 'Genesis', 'G80'),
(11845, 2025, 'Genesis', 'GV80'),
(11846, 2025, 'Genesis', 'GV80 Coupe'),
(11847, 2025, 'GMC', 'Yukon'),
(11848, 2025, 'Kia', 'Carnival'),
(11849, 2025, 'Lexus', 'UX'),
(11850, 2025, 'Lucid', 'Gravity'),
(11851, 2025, 'MINI', 'Countryman'),
(11852, 2025, 'MINI', 'Hardtop 2 Door'),
(11853, 2025, 'Ram', '1500 Crew Cab'),
(11854, 2025, 'Ram', '1500 Ramcharger'),
(11855, 2025, 'Ram', '1500 REV'),
(11856, 2025, 'Subaru', 'Forester'),
(11857, 2025, 'Toyota', 'Camry'),
(11858, 2025, 'Toyota', 'Crown Signia'),
(11859, 2025, 'Volkswagen', 'ID.7'),
(11860, 2025, 'Volkswagen', 'ID.Buzz'),
(11861, 2025, 'Volvo', 'EX30'),
(11862, 2025, 'Volvo', 'EX90');

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

--
-- Table structure for table `tblactivity_log`
--

CREATE TABLE `tblactivity_log` (
  `id` int(11) NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `staffid` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblactivity_log`
--

INSERT INTO `tblactivity_log` (`id`, `description`, `date`, `staffid`) VALUES
(64, 'New Lead Added [ID: 22]', '2025-03-06 05:45:53', NULL),
(65, 'New Lead Added [ID: 23]', '2025-03-06 05:47:16', NULL),
(66, 'New Lead Added [ID: 1]', '2025-03-06 13:20:02', NULL),
(67, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 119.155.195.168]', '2025-03-07 08:54:02', 'Engine Bank'),
(68, 'Lead Deleted [Deleted by: Engine Bank, ID: 1]', '2025-03-07 08:54:50', 'Engine Bank'),
(69, 'New Lead Added [ID: 2]', '2025-03-07 10:14:39', 'Engine Bank'),
(70, 'New Custom Field Added [Make]', '2025-03-07 10:19:59', 'Engine Bank'),
(71, 'Custom Field Updated [Date of first registration]', '2025-03-07 10:20:40', 'Engine Bank'),
(72, 'Custom Field Updated [Date of last V5C Issued]', '2025-03-07 10:21:09', 'Engine Bank'),
(73, 'Custom Field Updated [Cylinder Capacity]', '2025-03-07 10:21:25', 'Engine Bank'),
(74, 'Custom Field Updated [CO2 Emissions]', '2025-03-07 10:21:35', 'Engine Bank'),
(75, 'Custom Field Updated [Fuel Type]', '2025-03-07 10:21:48', 'Engine Bank'),
(76, 'Custom Field Updated [Transmission]', '2025-03-07 10:21:57', 'Engine Bank'),
(77, 'Custom Field Updated [Tax Status]', '2025-03-07 10:22:12', 'Engine Bank'),
(78, 'Custom Field Updated [Colour]', '2025-03-07 10:22:18', 'Engine Bank'),
(79, 'Custom Field Updated [Type Approval]', '2025-03-07 10:22:27', 'Engine Bank'),
(80, 'Custom Field Updated [Wheel Plan]', '2025-03-07 10:22:35', 'Engine Bank'),
(81, 'Custom Field Updated [Revenue Weight]', '2025-03-07 10:22:45', 'Engine Bank'),
(82, 'Custom Field Updated [Tax Details]', '2025-03-07 10:22:53', 'Engine Bank'),
(83, 'Custom Field Updated [MOT Details]', '2025-03-07 10:23:03', 'Engine Bank'),
(84, 'Custom Field Updated [Vin]', '2025-03-07 10:23:14', 'Engine Bank'),
(85, 'Custom Field Updated [Taxed]', '2025-03-07 10:23:21', 'Engine Bank'),
(86, 'Custom Field Updated [MOT]', '2025-03-07 10:23:29', 'Engine Bank'),
(87, 'New Custom Field Added [Make]', '2025-03-07 10:25:12', 'Engine Bank'),
(88, 'Custom Field Deleted [5]', '2025-03-07 10:25:31', 'Engine Bank'),
(89, 'Custom Field Updated [Make]', '2025-03-07 10:25:50', 'Engine Bank'),
(90, 'New Custom Field Added [Date of first registration]', '2025-03-07 10:26:19', 'Engine Bank'),
(91, 'New Custom Field Added [Date of last V5C Issued]', '2025-03-07 10:26:41', 'Engine Bank'),
(92, 'New Custom Field Added [Cylinder Capacity]', '2025-03-07 10:27:04', 'Engine Bank'),
(93, 'New Custom Field Added [CO2 Emissions]', '2025-03-07 10:27:18', 'Engine Bank'),
(94, 'New Custom Field Added [Fuel Type]', '2025-03-07 10:27:34', 'Engine Bank'),
(95, 'New Custom Field Added [Tax Details]', '2025-03-07 10:27:50', 'Engine Bank'),
(96, 'Custom Field Deleted [11]', '2025-03-07 10:28:38', 'Engine Bank'),
(97, 'New Custom Field Added [Transmission]', '2025-03-07 10:28:53', 'Engine Bank'),
(98, 'New Custom Field Added [Tax Status]', '2025-03-07 10:29:08', 'Engine Bank'),
(99, 'New Custom Field Added [Colour]', '2025-03-07 10:29:25', 'Engine Bank'),
(100, 'New Custom Field Added [Type Approval]', '2025-03-07 10:29:47', 'Engine Bank'),
(101, 'New Custom Field Added [Wheel Plan]', '2025-03-07 10:30:07', 'Engine Bank'),
(102, 'New Custom Field Added [Revenue Weight]', '2025-03-07 10:30:22', 'Engine Bank'),
(103, 'New Custom Field Added [Tax Details]', '2025-03-07 10:30:38', 'Engine Bank'),
(104, 'New Custom Field Added [MOT Details]', '2025-03-07 10:30:54', 'Engine Bank'),
(105, 'New Custom Field Added [VIN]', '2025-03-07 10:31:12', 'Engine Bank'),
(106, 'New Custom Field Added [Taxed]', '2025-03-07 10:31:30', 'Engine Bank'),
(107, 'New Custom Field Added [Taxed]', '2025-03-07 10:31:36', 'Engine Bank'),
(108, 'New Custom Field Added [MOT]', '2025-03-07 10:32:04', 'Engine Bank'),
(109, 'New Custom Field Added [DVLA Details]', '2025-03-07 10:36:42', 'Engine Bank'),
(110, 'Custom Field Status Changed [FieldID: 6 - Active: 0]', '2025-03-07 10:37:06', 'Engine Bank'),
(111, 'Custom Field Status Changed [FieldID: 7 - Active: 0]', '2025-03-07 10:37:06', 'Engine Bank'),
(112, 'Custom Field Status Changed [FieldID: 8 - Active: 0]', '2025-03-07 10:37:07', 'Engine Bank'),
(113, 'Custom Field Status Changed [FieldID: 9 - Active: 0]', '2025-03-07 10:37:08', 'Engine Bank'),
(114, 'Custom Field Status Changed [FieldID: 10 - Active: 0]', '2025-03-07 10:37:10', 'Engine Bank'),
(115, 'Custom Field Status Changed [FieldID: 12 - Active: 0]', '2025-03-07 10:37:10', 'Engine Bank'),
(116, 'Custom Field Status Changed [FieldID: 13 - Active: 0]', '2025-03-07 10:37:11', 'Engine Bank'),
(117, 'Custom Field Status Changed [FieldID: 14 - Active: 0]', '2025-03-07 10:37:12', 'Engine Bank'),
(118, 'Custom Field Status Changed [FieldID: 15 - Active: 0]', '2025-03-07 10:37:12', 'Engine Bank'),
(119, 'Custom Field Status Changed [FieldID: 16 - Active: 0]', '2025-03-07 10:37:13', 'Engine Bank'),
(120, 'Custom Field Status Changed [FieldID: 17 - Active: 0]', '2025-03-07 10:37:14', 'Engine Bank'),
(121, 'Custom Field Status Changed [FieldID: 18 - Active: 0]', '2025-03-07 10:37:14', 'Engine Bank'),
(122, 'Custom Field Status Changed [FieldID: 19 - Active: 0]', '2025-03-07 10:37:14', 'Engine Bank'),
(123, 'Custom Field Status Changed [FieldID: 20 - Active: 0]', '2025-03-07 10:37:15', 'Engine Bank'),
(124, 'Custom Field Status Changed [FieldID: 21 - Active: 0]', '2025-03-07 10:37:16', 'Engine Bank'),
(125, 'Custom Field Status Changed [FieldID: 22 - Active: 0]', '2025-03-07 10:37:16', 'Engine Bank'),
(126, 'Custom Field Status Changed [FieldID: 23 - Active: 0]', '2025-03-07 10:37:17', 'Engine Bank'),
(127, 'Custom Field Status Changed [FieldID: 4 - Active: 0]', '2025-03-07 10:37:43', 'Engine Bank'),
(128, 'New Lead Added [ID: 3]', '2025-03-07 11:10:52', NULL),
(129, 'Lead Deleted [Deleted by: Engine Bank, ID: 2]', '2025-03-07 11:12:04', 'Engine Bank'),
(130, 'Lead Updated [ID: 3]', '2025-03-07 11:12:56', 'Engine Bank'),
(131, 'New Lead Added [ID: 4]', '2025-03-07 11:22:33', NULL),
(132, 'New Lead Added [ID: 5]', '2025-03-07 11:23:26', NULL),
(133, 'Custom Field Deleted [6]', '2025-03-07 11:26:10', 'Engine Bank'),
(134, 'Custom Field Deleted [8]', '2025-03-07 11:26:14', 'Engine Bank'),
(135, 'Custom Field Deleted [9]', '2025-03-07 11:26:18', 'Engine Bank'),
(136, 'Custom Field Deleted [10]', '2025-03-07 11:26:21', 'Engine Bank'),
(137, 'Custom Field Deleted [12]', '2025-03-07 11:26:25', 'Engine Bank'),
(138, 'Custom Field Deleted [13]', '2025-03-07 11:26:31', 'Engine Bank'),
(139, 'Custom Field Deleted [7]', '2025-03-07 11:26:35', 'Engine Bank'),
(140, 'Custom Field Deleted [14]', '2025-03-07 11:26:40', 'Engine Bank'),
(141, 'Custom Field Deleted [16]', '2025-03-07 11:26:45', 'Engine Bank'),
(142, 'Custom Field Deleted [17]', '2025-03-07 11:26:49', 'Engine Bank'),
(143, 'Custom Field Deleted [20]', '2025-03-07 11:26:53', 'Engine Bank'),
(144, 'Custom Field Deleted [22]', '2025-03-07 11:26:57', 'Engine Bank'),
(145, 'Custom Field Deleted [4]', '2025-03-07 11:27:01', 'Engine Bank'),
(146, 'Custom Field Deleted [21]', '2025-03-07 11:27:05', 'Engine Bank'),
(147, 'Custom Field Deleted [23]', '2025-03-07 11:27:09', 'Engine Bank'),
(148, 'Custom Field Deleted [18]', '2025-03-07 11:27:13', 'Engine Bank'),
(149, 'Custom Field Deleted [15]', '2025-03-07 11:27:17', 'Engine Bank'),
(150, 'Custom Field Deleted [19]', '2025-03-07 11:27:22', 'Engine Bank'),
(151, 'Custom Field Updated [DVLA Details]', '2025-03-07 11:28:56', 'Engine Bank'),
(152, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 175.107.212.77]', '2025-03-07 11:48:40', 'Engine Bank'),
(153, 'Custom Field Updated [Car Year]', '2025-03-07 12:31:19', 'Engine Bank'),
(154, 'Custom Field Updated [Car Series]', '2025-03-07 12:31:22', 'Engine Bank'),
(155, 'Custom Field Updated [Car Model]', '2025-03-07 12:31:25', 'Engine Bank'),
(156, 'New Role Added [ID: 3.CEO]', '2025-03-07 12:39:04', 'Engine Bank'),
(157, 'New Staff Member Added [ID: 2, Aden Shah]', '2025-03-07 12:44:37', 'Engine Bank'),
(158, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 210.87.64.63]', '2025-03-07 17:56:00', 'Engine Bank'),
(159, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 175.107.212.77]', '2025-03-08 17:47:26', 'Engine Bank'),
(160, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 210.87.64.11]', '2025-03-12 19:45:23', 'Engine Bank'),
(161, 'New Lead Added [ID: 6]', '2025-03-12 23:55:25', NULL),
(162, 'New Lead Added [ID: 7]', '2025-03-13 00:00:10', NULL),
(163, 'New Lead Added [ID: 8]', '2025-03-13 06:53:47', NULL),
(164, 'New Lead Added [ID: 9]', '2025-03-21 10:01:25', NULL),
(165, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 210.87.64.24]', '2025-03-21 18:05:31', 'Engine Bank'),
(166, 'New Lead Added [ID: 10]', '2025-03-22 15:33:54', NULL),
(167, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 175.107.212.77]', '2025-03-23 18:43:27', 'Engine Bank'),
(168, 'Non Existing User Tried to Login [Email: developer@seopromarvel.com, Is Staff Member: No, IP: 175.107.212.77]', '2025-03-23 18:45:30', 'Engine Bank'),
(169, 'Non Existing User Tried to Login [Email: developer@seopromarvel.com, Is Staff Member: No, IP: 175.107.212.77]', '2025-03-23 18:52:12', 'Engine Bank'),
(170, 'Non Existing User Tried to Login [Email: developer@seopromarvel.com, Is Staff Member: No, IP: 175.107.212.77]', '2025-03-23 18:52:29', 'Engine Bank'),
(171, 'Non Existing User Tried to Login [Email: developer@seopromarvel.com, Is Staff Member: No, IP: 175.107.212.77]', '2025-03-23 18:54:21', 'Engine Bank'),
(172, 'Non Existing User Tried to Login [Email: developer@seopromarvel.com, Is Staff Member: No, IP: 175.107.212.77]', '2025-03-23 18:54:59', 'Engine Bank'),
(173, 'Lead Deleted [Deleted by: Engine Bank, ID: 9]', '2025-03-23 18:58:31', 'Engine Bank'),
(174, 'Lead Deleted [Deleted by: Engine Bank, ID: 6]', '2025-03-23 18:58:31', 'Engine Bank'),
(175, 'Lead Deleted [Deleted by: Engine Bank, ID: 5]', '2025-03-23 18:58:31', 'Engine Bank'),
(176, 'Lead Deleted [Deleted by: Engine Bank, ID: 4]', '2025-03-23 18:58:31', 'Engine Bank'),
(177, 'Lead Deleted [Deleted by: Engine Bank, ID: 3]', '2025-03-23 18:58:31', 'Engine Bank'),
(178, 'Staff Member Updated [ID: 2, Aden Shah]', '2025-03-23 19:01:10', 'Engine Bank'),
(179, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 175.107.212.77]', '2025-03-23 19:01:42', 'Aden Shah'),
(180, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 175.107.212.77]', '2025-03-23 19:03:21', 'Engine Bank'),
(181, 'Role Updated [ID: 3, Name: CEO]', '2025-03-23 19:03:45', 'Engine Bank'),
(182, 'New Lead Added [ID: 11]', '2025-03-23 19:06:53', NULL),
(183, 'New Custom Field Added [Message]', '2025-03-23 19:12:11', 'Engine Bank'),
(184, 'New Lead Added [ID: 12]', '2025-03-23 19:16:37', NULL),
(185, 'New Lead Added [ID: 13]', '2025-03-23 19:56:51', NULL),
(186, 'New Leads Source Added [SourceID: 4, Name: Engine Co.]', '2025-03-23 20:04:49', 'Engine Bank'),
(187, 'New Lead Added [ID: 14]', '2025-03-23 20:06:44', NULL),
(188, 'New Lead Added [ID: 15]', '2025-03-23 20:07:50', NULL),
(189, 'New Lead Added [ID: 16]', '2025-03-23 20:08:25', NULL),
(190, 'Lead Deleted [Deleted by: Engine Bank, ID: 16]', '2025-03-23 20:13:55', 'Engine Bank'),
(191, 'Lead Deleted [Deleted by: Engine Bank, ID: 15]', '2025-03-23 20:13:55', 'Engine Bank'),
(192, 'Lead Deleted [Deleted by: Engine Bank, ID: 14]', '2025-03-23 20:13:55', 'Engine Bank'),
(193, 'Lead Deleted [Deleted by: Engine Bank, ID: 13]', '2025-03-23 20:13:55', 'Engine Bank'),
(194, 'Lead Deleted [Deleted by: Engine Bank, ID: 12]', '2025-03-23 20:13:55', 'Engine Bank'),
(195, 'Lead Deleted [Deleted by: Engine Bank, ID: 11]', '2025-03-23 20:13:55', 'Engine Bank'),
(196, 'New Lead Added [ID: 17]', '2025-03-24 04:41:54', NULL),
(197, 'New Lead Added [ID: 18]', '2025-03-24 12:34:50', NULL),
(198, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 194.59.6.129]', '2025-03-24 12:57:32', 'Engine Bank'),
(199, 'New Lead Added [ID: 19]', '2025-03-24 12:58:52', NULL),
(200, 'Lead Marked as Junk [ID: 17]', '2025-03-24 13:00:59', 'Engine Bank'),
(201, 'New Lead Added [ID: 20]', '2025-03-24 13:21:49', NULL),
(202, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 210.87.64.40]', '2025-03-24 17:46:57', 'Aden Shah'),
(203, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 179.61.228.137]', '2025-03-24 17:49:20', 'Aden Shah'),
(204, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 39.53.208.179]', '2025-03-25 03:54:04', 'Aden Shah'),
(205, 'New Lead Added [ID: 21]', '2025-03-25 10:43:42', NULL),
(206, 'New Lead Added [ID: 22]', '2025-03-26 01:36:16', NULL),
(207, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 210.87.64.40]', '2025-03-26 02:18:22', 'Aden Shah'),
(208, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 210.87.64.40]', '2025-03-26 03:12:24', 'Engine Bank'),
(209, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 175.107.212.77]', '2025-03-26 04:36:55', 'Engine Bank'),
(210, 'New Leads Source Added [SourceID: 5, Name: Total Recon Engines]', '2025-03-26 04:38:16', 'Engine Bank'),
(211, 'New Lead Added [ID: 23]', '2025-03-26 05:13:30', NULL),
(212, 'New Lead Added [ID: 24]', '2025-03-26 17:39:12', NULL),
(213, 'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 210.87.64.40]', '2025-03-26 22:16:06', 'Engine Bank'),
(214, 'New Custom Field Added [Stripe SEPA Consumer Name]', '2025-03-26 22:21:45', 'Engine Bank'),
(215, 'New Custom Field Added [Stripe SEPA Consumer Email]', '2025-03-26 22:21:45', 'Engine Bank'),
(216, 'New Custom Field Added [Stripe SEPA Consumer IBAN]', '2025-03-26 22:21:45', 'Engine Bank'),
(217, 'New Lead Added [ID: 25]', '2025-03-27 08:06:39', NULL),
(218, 'New Lead Added [ID: 26]', '2025-03-28 07:07:37', NULL),
(219, 'New Lead Added [ID: 27]', '2025-03-28 08:10:09', NULL),
(220, 'New Lead Added [ID: 28]', '2025-03-29 08:51:32', NULL),
(221, 'New Lead Added [ID: 29]', '2025-03-29 17:21:53', NULL),
(222, 'New Lead Added [ID: 30]', '2025-03-29 21:08:37', NULL),
(223, 'New Lead Added [ID: 31]', '2025-03-30 05:11:25', NULL),
(224, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 210.87.64.59]', '2025-04-03 00:19:54', 'Aden Shah'),
(225, 'New Lead Added [ID: 32]', '2025-04-04 08:35:57', NULL),
(226, 'New Lead Added [ID: 33]', '2025-04-04 10:44:00', NULL),
(227, 'New Lead Added [ID: 34]', '2025-04-06 16:47:48', NULL),
(228, 'New Lead Added [ID: 35]', '2025-04-08 18:58:14', NULL),
(229, 'New Lead Added [ID: 36]', '2025-04-08 18:59:06', NULL),
(230, 'New Lead Added [ID: 37]', '2025-04-09 19:19:25', NULL),
(231, 'New Lead Added [ID: 38]', '2025-04-10 11:00:53', NULL),
(232, 'New Lead Added [ID: 39]', '2025-04-10 16:27:36', NULL),
(233, 'New Lead Added [ID: 40]', '2025-04-11 02:35:04', NULL),
(234, 'New Lead Added [ID: 41]', '2025-04-11 12:04:03', NULL),
(235, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 210.87.64.56]', '2025-04-11 17:30:30', 'Aden Shah'),
(236, 'New Lead Added [ID: 42]', '2025-04-11 18:31:11', NULL),
(237, 'New Lead Added [ID: 43]', '2025-04-11 21:31:53', NULL),
(238, 'New Lead Added [ID: 44]', '2025-04-12 12:13:02', NULL),
(239, 'New Lead Added [ID: 45]', '2025-04-14 01:37:21', NULL),
(240, 'User Successfully Logged In [User Id: 2, Is Staff Member: Yes, IP: 210.87.64.15]', '2025-04-14 20:52:12', 'Aden Shah'),
(241, 'New Lead Added [ID: 46]', '2025-04-15 06:46:07', NULL),
(242, 'New Lead Added [ID: 47]', '2025-04-15 07:32:56', NULL),
(243, 'New Lead Added [ID: 48]', '2025-04-16 06:19:35', NULL),
(244, 'New Lead Added [ID: 49]', '2025-04-16 15:17:13', NULL),
(245, 'New Lead Added [ID: 50]', '2025-04-18 15:45:34', NULL),
(246, 'New Lead Added [ID: 51]', '2025-04-19 07:17:45', NULL),
(247, 'New Lead Added [ID: 52]', '2025-04-19 11:21:36', NULL),
(248, 'New Lead Added [ID: 53]', '2025-04-19 14:27:39', NULL),
(249, 'New Lead Added [ID: 54]', '2025-04-20 09:53:07', NULL),
(250, 'New Lead Added [ID: 55]', '2025-04-22 17:09:03', NULL),
(251, 'New Lead Added [ID: 56]', '2025-04-22 17:37:41', NULL);

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

--
-- Table structure for table `tblannouncements`
--

CREATE TABLE `tblannouncements` (
  `announcementid` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext COLLATE utf8mb4_unicode_ci,
  `showtousers` int(11) NOT NULL,
  `showtostaff` int(11) NOT NULL,
  `showname` int(11) NOT NULL,
  `dateadded` datetime NOT NULL,
  `userid` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblclients`
--

CREATE TABLE `tblclients` (
  `userid` int(11) NOT NULL,
  `company` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vat` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phonenumber` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` int(11) NOT NULL DEFAULT '0',
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `active` int(11) NOT NULL DEFAULT '1',
  `leadid` int(11) DEFAULT NULL,
  `billing_street` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int(11) DEFAULT '0',
  `shipping_street` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int(11) DEFAULT '0',
  `longitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_language` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_currency` int(11) NOT NULL DEFAULT '0',
  `show_primary_contact` int(11) NOT NULL DEFAULT '0',
  `stripe_id` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_confirmed` int(11) NOT NULL DEFAULT '1',
  `addedfrom` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblconsents`
--

CREATE TABLE `tblconsents` (
  `id` int(11) NOT NULL,
  `action` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` int(11) NOT NULL DEFAULT '0',
  `lead_id` int(11) NOT NULL DEFAULT '0',
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `opt_in_purpose_description` mediumtext COLLATE utf8mb4_unicode_ci,
  `purpose_id` int(11) NOT NULL,
  `staff_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblconsent_purposes`
--

CREATE TABLE `tblconsent_purposes` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `date_created` datetime NOT NULL,
  `last_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcontacts`
--

CREATE TABLE `tblcontacts` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `is_primary` int(11) NOT NULL DEFAULT '1',
  `firstname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phonenumber` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_pass_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_pass_key_requested` datetime DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `email_verification_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verification_sent_at` datetime DEFAULT NULL,
  `last_ip` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_password_change` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `profile_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direction` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_emails` tinyint(1) NOT NULL DEFAULT '1',
  `estimate_emails` tinyint(1) NOT NULL DEFAULT '1',
  `credit_note_emails` tinyint(1) NOT NULL DEFAULT '1',
  `contract_emails` tinyint(1) NOT NULL DEFAULT '1',
  `task_emails` tinyint(1) NOT NULL DEFAULT '1',
  `project_emails` tinyint(1) NOT NULL DEFAULT '1',
  `ticket_emails` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcontact_permissions`
--

CREATE TABLE `tblcontact_permissions` (
  `id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcontracts`
--

CREATE TABLE `tblcontracts` (
  `id` int(11) NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client` int(11) NOT NULL,
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `contract_type` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `addedfrom` int(11) NOT NULL,
  `dateadded` datetime NOT NULL,
  `isexpirynotified` int(11) NOT NULL DEFAULT '0',
  `contract_value` decimal(15,2) DEFAULT NULL,
  `trash` tinyint(1) DEFAULT '0',
  `not_visible_to_client` tinyint(1) NOT NULL DEFAULT '0',
  `hash` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signed` tinyint(1) NOT NULL DEFAULT '0',
  `signature` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marked_as_signed` tinyint(1) NOT NULL DEFAULT '0',
  `acceptance_firstname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_lastname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_date` datetime DEFAULT NULL,
  `acceptance_ip` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_link` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_sent_at` datetime DEFAULT NULL,
  `contacts_sent_to` mediumtext COLLATE utf8mb4_unicode_ci,
  `last_sign_reminder_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcontracts_types`
--

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

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

--
-- Table structure for table `tblcontract_comments`
--

CREATE TABLE `tblcontract_comments` (
  `id` int(11) NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `contract_id` int(11) NOT NULL,
  `staffid` int(11) NOT NULL,
  `dateadded` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcontract_renewals`
--

CREATE TABLE `tblcontract_renewals` (
  `id` int(11) NOT NULL,
  `contractid` int(11) NOT NULL,
  `old_start_date` date NOT NULL,
  `new_start_date` date NOT NULL,
  `old_end_date` date DEFAULT NULL,
  `new_end_date` date DEFAULT NULL,
  `old_value` decimal(15,2) DEFAULT NULL,
  `new_value` decimal(15,2) DEFAULT NULL,
  `date_renewed` datetime NOT NULL,
  `renewed_by` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `renewed_by_staff_id` int(11) NOT NULL DEFAULT '0',
  `is_on_old_expiry_notified` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcountries`
--

CREATE TABLE `tblcountries` (
  `country_id` int(11) NOT NULL,
  `iso2` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `long_name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `iso3` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numcode` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `un_member` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `calling_code` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cctld` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblcountries`
--

INSERT INTO `tblcountries` (`country_id`, `iso2`, `short_name`, `long_name`, `iso3`, `numcode`, `un_member`, `calling_code`, `cctld`) VALUES
(1, 'AF', 'Afghanistan', 'Islamic Republic of Afghanistan', 'AFG', '004', 'yes', '93', '.af'),
(2, 'AX', 'Aland Islands', '&Aring;land Islands', 'ALA', '248', 'no', '358', '.ax'),
(3, 'AL', 'Albania', 'Republic of Albania', 'ALB', '008', 'yes', '355', '.al'),
(4, 'DZ', 'Algeria', 'People\'s Democratic Republic of Algeria', 'DZA', '012', 'yes', '213', '.dz'),
(5, 'AS', 'American Samoa', 'American Samoa', 'ASM', '016', 'no', '1+684', '.as'),
(6, 'AD', 'Andorra', 'Principality of Andorra', 'AND', '020', 'yes', '376', '.ad'),
(7, 'AO', 'Angola', 'Republic of Angola', 'AGO', '024', 'yes', '244', '.ao'),
(8, 'AI', 'Anguilla', 'Anguilla', 'AIA', '660', 'no', '1+264', '.ai'),
(9, 'AQ', 'Antarctica', 'Antarctica', 'ATA', '010', 'no', '672', '.aq'),
(10, 'AG', 'Antigua and Barbuda', 'Antigua and Barbuda', 'ATG', '028', 'yes', '1+268', '.ag'),
(11, 'AR', 'Argentina', 'Argentine Republic', 'ARG', '032', 'yes', '54', '.ar'),
(12, 'AM', 'Armenia', 'Republic of Armenia', 'ARM', '051', 'yes', '374', '.am'),
(13, 'AW', 'Aruba', 'Aruba', 'ABW', '533', 'no', '297', '.aw'),
(14, 'AU', 'Australia', 'Commonwealth of Australia', 'AUS', '036', 'yes', '61', '.au'),
(15, 'AT', 'Austria', 'Republic of Austria', 'AUT', '040', 'yes', '43', '.at'),
(16, 'AZ', 'Azerbaijan', 'Republic of Azerbaijan', 'AZE', '031', 'yes', '994', '.az'),
(17, 'BS', 'Bahamas', 'Commonwealth of The Bahamas', 'BHS', '044', 'yes', '1+242', '.bs'),
(18, 'BH', 'Bahrain', 'Kingdom of Bahrain', 'BHR', '048', 'yes', '973', '.bh'),
(19, 'BD', 'Bangladesh', 'People\'s Republic of Bangladesh', 'BGD', '050', 'yes', '880', '.bd'),
(20, 'BB', 'Barbados', 'Barbados', 'BRB', '052', 'yes', '1+246', '.bb'),
(21, 'BY', 'Belarus', 'Republic of Belarus', 'BLR', '112', 'yes', '375', '.by'),
(22, 'BE', 'Belgium', 'Kingdom of Belgium', 'BEL', '056', 'yes', '32', '.be'),
(23, 'BZ', 'Belize', 'Belize', 'BLZ', '084', 'yes', '501', '.bz'),
(24, 'BJ', 'Benin', 'Republic of Benin', 'BEN', '204', 'yes', '229', '.bj'),
(25, 'BM', 'Bermuda', 'Bermuda Islands', 'BMU', '060', 'no', '1+441', '.bm'),
(26, 'BT', 'Bhutan', 'Kingdom of Bhutan', 'BTN', '064', 'yes', '975', '.bt'),
(27, 'BO', 'Bolivia', 'Plurinational State of Bolivia', 'BOL', '068', 'yes', '591', '.bo'),
(28, 'BQ', 'Bonaire, Sint Eustatius and Saba', 'Bonaire, Sint Eustatius and Saba', 'BES', '535', 'no', '599', '.bq'),
(29, 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BIH', '070', 'yes', '387', '.ba'),
(30, 'BW', 'Botswana', 'Republic of Botswana', 'BWA', '072', 'yes', '267', '.bw'),
(31, 'BV', 'Bouvet Island', 'Bouvet Island', 'BVT', '074', 'no', 'NONE', '.bv'),
(32, 'BR', 'Brazil', 'Federative Republic of Brazil', 'BRA', '076', 'yes', '55', '.br'),
(33, 'IO', 'British Indian Ocean Territory', 'British Indian Ocean Territory', 'IOT', '086', 'no', '246', '.io'),
(34, 'BN', 'Brunei', 'Brunei Darussalam', 'BRN', '096', 'yes', '673', '.bn'),
(35, 'BG', 'Bulgaria', 'Republic of Bulgaria', 'BGR', '100', 'yes', '359', '.bg'),
(36, 'BF', 'Burkina Faso', 'Burkina Faso', 'BFA', '854', 'yes', '226', '.bf'),
(37, 'BI', 'Burundi', 'Republic of Burundi', 'BDI', '108', 'yes', '257', '.bi'),
(38, 'KH', 'Cambodia', 'Kingdom of Cambodia', 'KHM', '116', 'yes', '855', '.kh'),
(39, 'CM', 'Cameroon', 'Republic of Cameroon', 'CMR', '120', 'yes', '237', '.cm'),
(40, 'CA', 'Canada', 'Canada', 'CAN', '124', 'yes', '1', '.ca'),
(41, 'CV', 'Cape Verde', 'Republic of Cape Verde', 'CPV', '132', 'yes', '238', '.cv'),
(42, 'KY', 'Cayman Islands', 'The Cayman Islands', 'CYM', '136', 'no', '1+345', '.ky'),
(43, 'CF', 'Central African Republic', 'Central African Republic', 'CAF', '140', 'yes', '236', '.cf'),
(44, 'TD', 'Chad', 'Republic of Chad', 'TCD', '148', 'yes', '235', '.td'),
(45, 'CL', 'Chile', 'Republic of Chile', 'CHL', '152', 'yes', '56', '.cl'),
(46, 'CN', 'China', 'People\'s Republic of China', 'CHN', '156', 'yes', '86', '.cn'),
(47, 'CX', 'Christmas Island', 'Christmas Island', 'CXR', '162', 'no', '61', '.cx'),
(48, 'CC', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'CCK', '166', 'no', '61', '.cc'),
(49, 'CO', 'Colombia', 'Republic of Colombia', 'COL', '170', 'yes', '57', '.co'),
(50, 'KM', 'Comoros', 'Union of the Comoros', 'COM', '174', 'yes', '269', '.km'),
(51, 'CG', 'Congo', 'Republic of the Congo', 'COG', '178', 'yes', '242', '.cg'),
(52, 'CK', 'Cook Islands', 'Cook Islands', 'COK', '184', 'some', '682', '.ck'),
(53, 'CR', 'Costa Rica', 'Republic of Costa Rica', 'CRI', '188', 'yes', '506', '.cr'),
(54, 'CI', 'Cote d\'ivoire (Ivory Coast)', 'Republic of C&ocirc;te D\'Ivoire (Ivory Coast)', 'CIV', '384', 'yes', '225', '.ci'),
(55, 'HR', 'Croatia', 'Republic of Croatia', 'HRV', '191', 'yes', '385', '.hr'),
(56, 'CU', 'Cuba', 'Republic of Cuba', 'CUB', '192', 'yes', '53', '.cu'),
(57, 'CW', 'Curacao', 'Cura&ccedil;ao', 'CUW', '531', 'no', '599', '.cw'),
(58, 'CY', 'Cyprus', 'Republic of Cyprus', 'CYP', '196', 'yes', '357', '.cy'),
(59, 'CZ', 'Czech Republic', 'Czech Republic', 'CZE', '203', 'yes', '420', '.cz'),
(60, 'CD', 'Democratic Republic of the Congo', 'Democratic Republic of the Congo', 'COD', '180', 'yes', '243', '.cd'),
(61, 'DK', 'Denmark', 'Kingdom of Denmark', 'DNK', '208', 'yes', '45', '.dk'),
(62, 'DJ', 'Djibouti', 'Republic of Djibouti', 'DJI', '262', 'yes', '253', '.dj'),
(63, 'DM', 'Dominica', 'Commonwealth of Dominica', 'DMA', '212', 'yes', '1+767', '.dm'),
(64, 'DO', 'Dominican Republic', 'Dominican Republic', 'DOM', '214', 'yes', '1+809, 8', '.do'),
(65, 'EC', 'Ecuador', 'Republic of Ecuador', 'ECU', '218', 'yes', '593', '.ec'),
(66, 'EG', 'Egypt', 'Arab Republic of Egypt', 'EGY', '818', 'yes', '20', '.eg'),
(67, 'SV', 'El Salvador', 'Republic of El Salvador', 'SLV', '222', 'yes', '503', '.sv'),
(68, 'GQ', 'Equatorial Guinea', 'Republic of Equatorial Guinea', 'GNQ', '226', 'yes', '240', '.gq'),
(69, 'ER', 'Eritrea', 'State of Eritrea', 'ERI', '232', 'yes', '291', '.er'),
(70, 'EE', 'Estonia', 'Republic of Estonia', 'EST', '233', 'yes', '372', '.ee'),
(71, 'ET', 'Ethiopia', 'Federal Democratic Republic of Ethiopia', 'ETH', '231', 'yes', '251', '.et'),
(72, 'FK', 'Falkland Islands (Malvinas)', 'The Falkland Islands (Malvinas)', 'FLK', '238', 'no', '500', '.fk'),
(73, 'FO', 'Faroe Islands', 'The Faroe Islands', 'FRO', '234', 'no', '298', '.fo'),
(74, 'FJ', 'Fiji', 'Republic of Fiji', 'FJI', '242', 'yes', '679', '.fj'),
(75, 'FI', 'Finland', 'Republic of Finland', 'FIN', '246', 'yes', '358', '.fi'),
(76, 'FR', 'France', 'French Republic', 'FRA', '250', 'yes', '33', '.fr'),
(77, 'GF', 'French Guiana', 'French Guiana', 'GUF', '254', 'no', '594', '.gf'),
(78, 'PF', 'French Polynesia', 'French Polynesia', 'PYF', '258', 'no', '689', '.pf'),
(79, 'TF', 'French Southern Territories', 'French Southern Territories', 'ATF', '260', 'no', NULL, '.tf'),
(80, 'GA', 'Gabon', 'Gabonese Republic', 'GAB', '266', 'yes', '241', '.ga'),
(81, 'GM', 'Gambia', 'Republic of The Gambia', 'GMB', '270', 'yes', '220', '.gm'),
(82, 'GE', 'Georgia', 'Georgia', 'GEO', '268', 'yes', '995', '.ge'),
(83, 'DE', 'Germany', 'Federal Republic of Germany', 'DEU', '276', 'yes', '49', '.de'),
(84, 'GH', 'Ghana', 'Republic of Ghana', 'GHA', '288', 'yes', '233', '.gh'),
(85, 'GI', 'Gibraltar', 'Gibraltar', 'GIB', '292', 'no', '350', '.gi'),
(86, 'GR', 'Greece', 'Hellenic Republic', 'GRC', '300', 'yes', '30', '.gr'),
(87, 'GL', 'Greenland', 'Greenland', 'GRL', '304', 'no', '299', '.gl'),
(88, 'GD', 'Grenada', 'Grenada', 'GRD', '308', 'yes', '1+473', '.gd'),
(89, 'GP', 'Guadaloupe', 'Guadeloupe', 'GLP', '312', 'no', '590', '.gp'),
(90, 'GU', 'Guam', 'Guam', 'GUM', '316', 'no', '1+671', '.gu'),
(91, 'GT', 'Guatemala', 'Republic of Guatemala', 'GTM', '320', 'yes', '502', '.gt'),
(92, 'GG', 'Guernsey', 'Guernsey', 'GGY', '831', 'no', '44', '.gg'),
(93, 'GN', 'Guinea', 'Republic of Guinea', 'GIN', '324', 'yes', '224', '.gn'),
(94, 'GW', 'Guinea-Bissau', 'Republic of Guinea-Bissau', 'GNB', '624', 'yes', '245', '.gw'),
(95, 'GY', 'Guyana', 'Co-operative Republic of Guyana', 'GUY', '328', 'yes', '592', '.gy'),
(96, 'HT', 'Haiti', 'Republic of Haiti', 'HTI', '332', 'yes', '509', '.ht'),
(97, 'HM', 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands', 'HMD', '334', 'no', 'NONE', '.hm'),
(98, 'HN', 'Honduras', 'Republic of Honduras', 'HND', '340', 'yes', '504', '.hn'),
(99, 'HK', 'Hong Kong', 'Hong Kong', 'HKG', '344', 'no', '852', '.hk'),
(100, 'HU', 'Hungary', 'Hungary', 'HUN', '348', 'yes', '36', '.hu'),
(101, 'IS', 'Iceland', 'Republic of Iceland', 'ISL', '352', 'yes', '354', '.is'),
(102, 'IN', 'India', 'Republic of India', 'IND', '356', 'yes', '91', '.in'),
(103, 'ID', 'Indonesia', 'Republic of Indonesia', 'IDN', '360', 'yes', '62', '.id'),
(104, 'IR', 'Iran', 'Islamic Republic of Iran', 'IRN', '364', 'yes', '98', '.ir'),
(105, 'IQ', 'Iraq', 'Republic of Iraq', 'IRQ', '368', 'yes', '964', '.iq'),
(106, 'IE', 'Ireland', 'Ireland', 'IRL', '372', 'yes', '353', '.ie'),
(107, 'IM', 'Isle of Man', 'Isle of Man', 'IMN', '833', 'no', '44', '.im'),
(108, 'IL', 'Israel', 'State of Israel', 'ISR', '376', 'yes', '972', '.il'),
(109, 'IT', 'Italy', 'Italian Republic', 'ITA', '380', 'yes', '39', '.jm'),
(110, 'JM', 'Jamaica', 'Jamaica', 'JAM', '388', 'yes', '1+876', '.jm'),
(111, 'JP', 'Japan', 'Japan', 'JPN', '392', 'yes', '81', '.jp'),
(112, 'JE', 'Jersey', 'The Bailiwick of Jersey', 'JEY', '832', 'no', '44', '.je'),
(113, 'JO', 'Jordan', 'Hashemite Kingdom of Jordan', 'JOR', '400', 'yes', '962', '.jo'),
(114, 'KZ', 'Kazakhstan', 'Republic of Kazakhstan', 'KAZ', '398', 'yes', '7', '.kz'),
(115, 'KE', 'Kenya', 'Republic of Kenya', 'KEN', '404', 'yes', '254', '.ke'),
(116, 'KI', 'Kiribati', 'Republic of Kiribati', 'KIR', '296', 'yes', '686', '.ki'),
(117, 'XK', 'Kosovo', 'Republic of Kosovo', '---', '---', 'some', '381', ''),
(118, 'KW', 'Kuwait', 'State of Kuwait', 'KWT', '414', 'yes', '965', '.kw'),
(119, 'KG', 'Kyrgyzstan', 'Kyrgyz Republic', 'KGZ', '417', 'yes', '996', '.kg'),
(120, 'LA', 'Laos', 'Lao People\'s Democratic Republic', 'LAO', '418', 'yes', '856', '.la'),
(121, 'LV', 'Latvia', 'Republic of Latvia', 'LVA', '428', 'yes', '371', '.lv'),
(122, 'LB', 'Lebanon', 'Republic of Lebanon', 'LBN', '422', 'yes', '961', '.lb'),
(123, 'LS', 'Lesotho', 'Kingdom of Lesotho', 'LSO', '426', 'yes', '266', '.ls'),
(124, 'LR', 'Liberia', 'Republic of Liberia', 'LBR', '430', 'yes', '231', '.lr'),
(125, 'LY', 'Libya', 'Libya', 'LBY', '434', 'yes', '218', '.ly'),
(126, 'LI', 'Liechtenstein', 'Principality of Liechtenstein', 'LIE', '438', 'yes', '423', '.li'),
(127, 'LT', 'Lithuania', 'Republic of Lithuania', 'LTU', '440', 'yes', '370', '.lt'),
(128, 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'LUX', '442', 'yes', '352', '.lu'),
(129, 'MO', 'Macao', 'The Macao Special Administrative Region', 'MAC', '446', 'no', '853', '.mo'),
(130, 'MK', 'North Macedonia', 'Republic of North Macedonia', 'MKD', '807', 'yes', '389', '.mk'),
(131, 'MG', 'Madagascar', 'Republic of Madagascar', 'MDG', '450', 'yes', '261', '.mg'),
(132, 'MW', 'Malawi', 'Republic of Malawi', 'MWI', '454', 'yes', '265', '.mw'),
(133, 'MY', 'Malaysia', 'Malaysia', 'MYS', '458', 'yes', '60', '.my'),
(134, 'MV', 'Maldives', 'Republic of Maldives', 'MDV', '462', 'yes', '960', '.mv'),
(135, 'ML', 'Mali', 'Republic of Mali', 'MLI', '466', 'yes', '223', '.ml'),
(136, 'MT', 'Malta', 'Republic of Malta', 'MLT', '470', 'yes', '356', '.mt'),
(137, 'MH', 'Marshall Islands', 'Republic of the Marshall Islands', 'MHL', '584', 'yes', '692', '.mh'),
(138, 'MQ', 'Martinique', 'Martinique', 'MTQ', '474', 'no', '596', '.mq'),
(139, 'MR', 'Mauritania', 'Islamic Republic of Mauritania', 'MRT', '478', 'yes', '222', '.mr'),
(140, 'MU', 'Mauritius', 'Republic of Mauritius', 'MUS', '480', 'yes', '230', '.mu'),
(141, 'YT', 'Mayotte', 'Mayotte', 'MYT', '175', 'no', '262', '.yt'),
(142, 'MX', 'Mexico', 'United Mexican States', 'MEX', '484', 'yes', '52', '.mx'),
(143, 'FM', 'Micronesia', 'Federated States of Micronesia', 'FSM', '583', 'yes', '691', '.fm'),
(144, 'MD', 'Moldava', 'Republic of Moldova', 'MDA', '498', 'yes', '373', '.md'),
(145, 'MC', 'Monaco', 'Principality of Monaco', 'MCO', '492', 'yes', '377', '.mc'),
(146, 'MN', 'Mongolia', 'Mongolia', 'MNG', '496', 'yes', '976', '.mn'),
(147, 'ME', 'Montenegro', 'Montenegro', 'MNE', '499', 'yes', '382', '.me'),
(148, 'MS', 'Montserrat', 'Montserrat', 'MSR', '500', 'no', '1+664', '.ms'),
(149, 'MA', 'Morocco', 'Kingdom of Morocco', 'MAR', '504', 'yes', '212', '.ma'),
(150, 'MZ', 'Mozambique', 'Republic of Mozambique', 'MOZ', '508', 'yes', '258', '.mz'),
(151, 'MM', 'Myanmar (Burma)', 'Republic of the Union of Myanmar', 'MMR', '104', 'yes', '95', '.mm'),
(152, 'NA', 'Namibia', 'Republic of Namibia', 'NAM', '516', 'yes', '264', '.na'),
(153, 'NR', 'Nauru', 'Republic of Nauru', 'NRU', '520', 'yes', '674', '.nr'),
(154, 'NP', 'Nepal', 'Federal Democratic Republic of Nepal', 'NPL', '524', 'yes', '977', '.np'),
(155, 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'NLD', '528', 'yes', '31', '.nl'),
(156, 'NC', 'New Caledonia', 'New Caledonia', 'NCL', '540', 'no', '687', '.nc'),
(157, 'NZ', 'New Zealand', 'New Zealand', 'NZL', '554', 'yes', '64', '.nz'),
(158, 'NI', 'Nicaragua', 'Republic of Nicaragua', 'NIC', '558', 'yes', '505', '.ni'),
(159, 'NE', 'Niger', 'Republic of Niger', 'NER', '562', 'yes', '227', '.ne'),
(160, 'NG', 'Nigeria', 'Federal Republic of Nigeria', 'NGA', '566', 'yes', '234', '.ng'),
(161, 'NU', 'Niue', 'Niue', 'NIU', '570', 'some', '683', '.nu'),
(162, 'NF', 'Norfolk Island', 'Norfolk Island', 'NFK', '574', 'no', '672', '.nf'),
(163, 'KP', 'North Korea', 'Democratic People\'s Republic of Korea', 'PRK', '408', 'yes', '850', '.kp'),
(164, 'MP', 'Northern Mariana Islands', 'Northern Mariana Islands', 'MNP', '580', 'no', '1+670', '.mp'),
(165, 'NO', 'Norway', 'Kingdom of Norway', 'NOR', '578', 'yes', '47', '.no'),
(166, 'OM', 'Oman', 'Sultanate of Oman', 'OMN', '512', 'yes', '968', '.om'),
(167, 'PK', 'Pakistan', 'Islamic Republic of Pakistan', 'PAK', '586', 'yes', '92', '.pk'),
(168, 'PW', 'Palau', 'Republic of Palau', 'PLW', '585', 'yes', '680', '.pw'),
(169, 'PS', 'Palestine', 'State of Palestine (or Occupied Palestinian Territory)', 'PSE', '275', 'some', '970', '.ps'),
(170, 'PA', 'Panama', 'Republic of Panama', 'PAN', '591', 'yes', '507', '.pa'),
(171, 'PG', 'Papua New Guinea', 'Independent State of Papua New Guinea', 'PNG', '598', 'yes', '675', '.pg'),
(172, 'PY', 'Paraguay', 'Republic of Paraguay', 'PRY', '600', 'yes', '595', '.py'),
(173, 'PE', 'Peru', 'Republic of Peru', 'PER', '604', 'yes', '51', '.pe'),
(174, 'PH', 'Philippines', 'Republic of the Philippines', 'PHL', '608', 'yes', '63', '.ph'),
(175, 'PN', 'Pitcairn', 'Pitcairn', 'PCN', '612', 'no', 'NONE', '.pn'),
(176, 'PL', 'Poland', 'Republic of Poland', 'POL', '616', 'yes', '48', '.pl'),
(177, 'PT', 'Portugal', 'Portuguese Republic', 'PRT', '620', 'yes', '351', '.pt'),
(178, 'PR', 'Puerto Rico', 'Commonwealth of Puerto Rico', 'PRI', '630', 'no', '1+939', '.pr'),
(179, 'QA', 'Qatar', 'State of Qatar', 'QAT', '634', 'yes', '974', '.qa'),
(180, 'RE', 'Reunion', 'R&eacute;union', 'REU', '638', 'no', '262', '.re'),
(181, 'RO', 'Romania', 'Romania', 'ROU', '642', 'yes', '40', '.ro'),
(182, 'RU', 'Russia', 'Russian Federation', 'RUS', '643', 'yes', '7', '.ru'),
(183, 'RW', 'Rwanda', 'Republic of Rwanda', 'RWA', '646', 'yes', '250', '.rw'),
(184, 'BL', 'Saint Barthelemy', 'Saint Barth&eacute;lemy', 'BLM', '652', 'no', '590', '.bl'),
(185, 'SH', 'Saint Helena', 'Saint Helena, Ascension and Tristan da Cunha', 'SHN', '654', 'no', '290', '.sh'),
(186, 'KN', 'Saint Kitts and Nevis', 'Federation of Saint Christopher and Nevis', 'KNA', '659', 'yes', '1+869', '.kn'),
(187, 'LC', 'Saint Lucia', 'Saint Lucia', 'LCA', '662', 'yes', '1+758', '.lc'),
(188, 'MF', 'Saint Martin', 'Saint Martin', 'MAF', '663', 'no', '590', '.mf'),
(189, 'PM', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'SPM', '666', 'no', '508', '.pm'),
(190, 'VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'VCT', '670', 'yes', '1+784', '.vc'),
(191, 'WS', 'Samoa', 'Independent State of Samoa', 'WSM', '882', 'yes', '685', '.ws'),
(192, 'SM', 'San Marino', 'Republic of San Marino', 'SMR', '674', 'yes', '378', '.sm'),
(193, 'ST', 'Sao Tome and Principe', 'Democratic Republic of S&atilde;o Tom&eacute; and Pr&iacute;ncipe', 'STP', '678', 'yes', '239', '.st'),
(194, 'SA', 'Saudi Arabia', 'Kingdom of Saudi Arabia', 'SAU', '682', 'yes', '966', '.sa'),
(195, 'SN', 'Senegal', 'Republic of Senegal', 'SEN', '686', 'yes', '221', '.sn'),
(196, 'RS', 'Serbia', 'Republic of Serbia', 'SRB', '688', 'yes', '381', '.rs'),
(197, 'SC', 'Seychelles', 'Republic of Seychelles', 'SYC', '690', 'yes', '248', '.sc'),
(198, 'SL', 'Sierra Leone', 'Republic of Sierra Leone', 'SLE', '694', 'yes', '232', '.sl'),
(199, 'SG', 'Singapore', 'Republic of Singapore', 'SGP', '702', 'yes', '65', '.sg'),
(200, 'SX', 'Sint Maarten', 'Sint Maarten', 'SXM', '534', 'no', '1+721', '.sx'),
(201, 'SK', 'Slovakia', 'Slovak Republic', 'SVK', '703', 'yes', '421', '.sk'),
(202, 'SI', 'Slovenia', 'Republic of Slovenia', 'SVN', '705', 'yes', '386', '.si'),
(203, 'SB', 'Solomon Islands', 'Solomon Islands', 'SLB', '090', 'yes', '677', '.sb'),
(204, 'SO', 'Somalia', 'Somali Republic', 'SOM', '706', 'yes', '252', '.so'),
(205, 'ZA', 'South Africa', 'Republic of South Africa', 'ZAF', '710', 'yes', '27', '.za'),
(206, 'GS', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'SGS', '239', 'no', '500', '.gs'),
(207, 'KR', 'South Korea', 'Republic of Korea', 'KOR', '410', 'yes', '82', '.kr'),
(208, 'SS', 'South Sudan', 'Republic of South Sudan', 'SSD', '728', 'yes', '211', '.ss'),
(209, 'ES', 'Spain', 'Kingdom of Spain', 'ESP', '724', 'yes', '34', '.es'),
(210, 'LK', 'Sri Lanka', 'Democratic Socialist Republic of Sri Lanka', 'LKA', '144', 'yes', '94', '.lk'),
(211, 'SD', 'Sudan', 'Republic of the Sudan', 'SDN', '729', 'yes', '249', '.sd'),
(212, 'SR', 'Suriname', 'Republic of Suriname', 'SUR', '740', 'yes', '597', '.sr'),
(213, 'SJ', 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', 'SJM', '744', 'no', '47', '.sj'),
(214, 'SZ', 'Swaziland', 'Kingdom of Swaziland', 'SWZ', '748', 'yes', '268', '.sz'),
(215, 'SE', 'Sweden', 'Kingdom of Sweden', 'SWE', '752', 'yes', '46', '.se'),
(216, 'CH', 'Switzerland', 'Swiss Confederation', 'CHE', '756', 'yes', '41', '.ch'),
(217, 'SY', 'Syria', 'Syrian Arab Republic', 'SYR', '760', 'yes', '963', '.sy'),
(218, 'TW', 'Taiwan', 'Republic of China (Taiwan)', 'TWN', '158', 'former', '886', '.tw'),
(219, 'TJ', 'Tajikistan', 'Republic of Tajikistan', 'TJK', '762', 'yes', '992', '.tj'),
(220, 'TZ', 'Tanzania', 'United Republic of Tanzania', 'TZA', '834', 'yes', '255', '.tz'),
(221, 'TH', 'Thailand', 'Kingdom of Thailand', 'THA', '764', 'yes', '66', '.th'),
(222, 'TL', 'Timor-Leste (East Timor)', 'Democratic Republic of Timor-Leste', 'TLS', '626', 'yes', '670', '.tl'),
(223, 'TG', 'Togo', 'Togolese Republic', 'TGO', '768', 'yes', '228', '.tg'),
(224, 'TK', 'Tokelau', 'Tokelau', 'TKL', '772', 'no', '690', '.tk'),
(225, 'TO', 'Tonga', 'Kingdom of Tonga', 'TON', '776', 'yes', '676', '.to'),
(226, 'TT', 'Trinidad and Tobago', 'Republic of Trinidad and Tobago', 'TTO', '780', 'yes', '1+868', '.tt'),
(227, 'TN', 'Tunisia', 'Republic of Tunisia', 'TUN', '788', 'yes', '216', '.tn'),
(228, 'TR', 'Turkey', 'Republic of Turkey', 'TUR', '792', 'yes', '90', '.tr'),
(229, 'TM', 'Turkmenistan', 'Turkmenistan', 'TKM', '795', 'yes', '993', '.tm'),
(230, 'TC', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'TCA', '796', 'no', '1+649', '.tc'),
(231, 'TV', 'Tuvalu', 'Tuvalu', 'TUV', '798', 'yes', '688', '.tv'),
(232, 'UG', 'Uganda', 'Republic of Uganda', 'UGA', '800', 'yes', '256', '.ug'),
(233, 'UA', 'Ukraine', 'Ukraine', 'UKR', '804', 'yes', '380', '.ua'),
(234, 'AE', 'United Arab Emirates', 'United Arab Emirates', 'ARE', '784', 'yes', '971', '.ae'),
(235, 'GB', 'United Kingdom', 'United Kingdom of Great Britain and Nothern Ireland', 'GBR', '826', 'yes', '44', '.uk'),
(236, 'US', 'United States', 'United States of America', 'USA', '840', 'yes', '1', '.us'),
(237, 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'UMI', '581', 'no', 'NONE', 'NONE'),
(238, 'UY', 'Uruguay', 'Eastern Republic of Uruguay', 'URY', '858', 'yes', '598', '.uy'),
(239, 'UZ', 'Uzbekistan', 'Republic of Uzbekistan', 'UZB', '860', 'yes', '998', '.uz'),
(240, 'VU', 'Vanuatu', 'Republic of Vanuatu', 'VUT', '548', 'yes', '678', '.vu'),
(241, 'VA', 'Vatican City', 'State of the Vatican City', 'VAT', '336', 'no', '39', '.va'),
(242, 'VE', 'Venezuela', 'Bolivarian Republic of Venezuela', 'VEN', '862', 'yes', '58', '.ve'),
(243, 'VN', 'Vietnam', 'Socialist Republic of Vietnam', 'VNM', '704', 'yes', '84', '.vn'),
(244, 'VG', 'Virgin Islands, British', 'British Virgin Islands', 'VGB', '092', 'no', '1+284', '.vg'),
(245, 'VI', 'Virgin Islands, US', 'Virgin Islands of the United States', 'VIR', '850', 'no', '1+340', '.vi'),
(246, 'WF', 'Wallis and Futuna', 'Wallis and Futuna', 'WLF', '876', 'no', '681', '.wf'),
(247, 'EH', 'Western Sahara', 'Western Sahara', 'ESH', '732', 'no', '212', '.eh'),
(248, 'YE', 'Yemen', 'Republic of Yemen', 'YEM', '887', 'yes', '967', '.ye'),
(249, 'ZM', 'Zambia', 'Republic of Zambia', 'ZMB', '894', 'yes', '260', '.zm'),
(250, 'ZW', 'Zimbabwe', 'Republic of Zimbabwe', 'ZWE', '716', 'yes', '263', '.zw');

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

--
-- Table structure for table `tblcreditnotes`
--

CREATE TABLE `tblcreditnotes` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `deleted_customer_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` int(11) NOT NULL,
  `prefix` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_format` int(11) NOT NULL DEFAULT '1',
  `formatted_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `adminnote` mediumtext COLLATE utf8mb4_unicode_ci,
  `terms` mediumtext COLLATE utf8mb4_unicode_ci,
  `clientnote` mediumtext COLLATE utf8mb4_unicode_ci,
  `currency` int(11) NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `total_tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `addedfrom` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `discount_percent` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `discount_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_street` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int(11) DEFAULT NULL,
  `shipping_street` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int(11) DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_credit_note` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int(11) NOT NULL DEFAULT '1',
  `reference_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcreditnote_refunds`
--

CREATE TABLE `tblcreditnote_refunds` (
  `id` int(11) NOT NULL,
  `credit_note_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `refunded_on` date NOT NULL,
  `payment_mode` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` mediumtext COLLATE utf8mb4_unicode_ci,
  `amount` decimal(15,2) NOT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcredits`
--

CREATE TABLE `tblcredits` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `credit_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `date_applied` datetime NOT NULL,
  `amount` decimal(15,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcurrencies`
--

CREATE TABLE `tblcurrencies` (
  `id` int(11) NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `decimal_separator` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thousand_separator` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placement` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isdefault` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblcurrencies`
--

INSERT INTO `tblcurrencies` (`id`, `symbol`, `name`, `decimal_separator`, `thousand_separator`, `placement`, `isdefault`) VALUES
(1, '$', 'USD', '.', ',', 'before', 1),
(2, '€', 'EUR', ',', '.', 'before', 0);

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

--
-- Table structure for table `tblcustomers_groups`
--

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

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

--
-- Table structure for table `tblcustomer_admins`
--

CREATE TABLE `tblcustomer_admins` (
  `staff_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `date_assigned` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcustomer_groups`
--

CREATE TABLE `tblcustomer_groups` (
  `id` int(11) NOT NULL,
  `groupid` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblcustomfields`
--

CREATE TABLE `tblcustomfields` (
  `id` int(11) NOT NULL,
  `fieldto` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` longtext COLLATE utf8mb4_unicode_ci,
  `display_inline` tinyint(1) NOT NULL DEFAULT '0',
  `field_order` int(11) DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '1',
  `show_on_pdf` int(11) NOT NULL DEFAULT '0',
  `show_on_ticket_form` tinyint(1) NOT NULL DEFAULT '0',
  `only_admin` tinyint(1) NOT NULL DEFAULT '0',
  `show_on_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_on_client_portal` int(11) NOT NULL DEFAULT '0',
  `disalow_client_to_edit` int(11) NOT NULL DEFAULT '0',
  `bs_column` int(11) NOT NULL DEFAULT '12',
  `default_value` mediumtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblcustomfields`
--

INSERT INTO `tblcustomfields` (`id`, `fieldto`, `name`, `slug`, `required`, `type`, `options`, `display_inline`, `field_order`, `active`, `show_on_pdf`, `show_on_ticket_form`, `only_admin`, `show_on_table`, `show_on_client_portal`, `disalow_client_to_edit`, `bs_column`, `default_value`) VALUES
(1, 'leads', 'Car Series', 'leads_car_series', 1, 'input', '', 0, 1, 1, 0, 0, 0, 0, 0, 0, 4, ''),
(2, 'leads', 'Car Model', 'leads_car_model', 1, 'input', '', 0, 2, 1, 0, 0, 0, 0, 0, 0, 12, ''),
(3, 'leads', 'Car Year', 'leads_car_year', 1, 'input', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, ''),
(24, 'leads', 'DVLA Details', 'leads_dvla_details', 0, 'input', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, ''),
(25, 'leads', 'Message', 'leads_message', 0, 'textarea', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, ''),
(26, 'contacts', 'Stripe SEPA Consumer Name', 'contacts_stripe_sepa_consumer_name', 0, 'input', NULL, 0, 0, 1, 0, 0, 0, 0, 1, 0, 6, NULL),
(27, 'contacts', 'Stripe SEPA Consumer Email', 'contacts_stripe_sepa_consumer_email', 0, 'input', NULL, 0, 0, 1, 0, 0, 0, 0, 1, 0, 6, NULL),
(28, 'contacts', 'Stripe SEPA Consumer IBAN', 'contacts_stripe_sepa_consumer_iban', 0, 'input', NULL, 0, 0, 1, 0, 0, 0, 0, 1, 0, 6, NULL);

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

--
-- Table structure for table `tblcustomfieldsvalues`
--

CREATE TABLE `tblcustomfieldsvalues` (
  `id` int(11) NOT NULL,
  `relid` int(11) NOT NULL,
  `fieldid` int(11) NOT NULL,
  `fieldto` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblcustomfieldsvalues`
--

INSERT INTO `tblcustomfieldsvalues` (`id`, `relid`, `fieldid`, `fieldto`, `value`) VALUES
(17, 10, 1, 'leads', '1 Series'),
(18, 10, 2, 'leads', '125d'),
(19, 10, 3, 'leads', '2015'),
(33, 22, 1, 'leads', 'Series Undefined'),
(34, 22, 2, 'leads', 'Model Undefined'),
(35, 22, 3, 'leads', 'Year Undefined'),
(36, 23, 1, 'leads', 'Audi'),
(37, 23, 2, 'leads', 'TT'),
(38, 23, 3, 'leads', '2000'),
(61, 7, 1, 'leads', 'Series Undefined'),
(62, 7, 2, 'leads', 'Model Undefined'),
(63, 7, 3, 'leads', 'Year Undefined'),
(64, 7, 24, 'leads', '{\"message\":\"API key or VRM invalid\",\"error\":1,\"licence_plate\":\"A\"}'),
(65, 8, 1, 'leads', 'Series Undefined'),
(66, 8, 2, 'leads', 'Model Undefined'),
(67, 8, 3, 'leads', 'Year Undefined'),
(68, 8, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"3 SERIES\",\"dateOfFirstRegistration\":\"1 JULY 2003\",\"dateOfLastV5CIssued\":\"10 JUNE 2024\",\"yearOfManufacture\":\"2001\",\"cylinderCapacity\":\"2979cc\",\"co2Emissions\":\"229 g/km\",\"fuelType\":\"PETROL\",\"transmission\":\"MANUAL\",\"taxStatus\":\"Taxed\",\"colour\":\"BLUE\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 JUNE 2025\",\"motDetails\":\"21 NOVEMBER 2025\",\"vin\":\"WBABSS2040EH86305\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"B6cus\"}'),
(70, 10, 24, 'leads', 'Undefined'),
(94, 17, 1, 'leads', 'Series Undefined'),
(95, 17, 2, 'leads', 'Model Undefined'),
(96, 17, 3, 'leads', 'Year Undefined'),
(97, 17, 24, 'leads', 'Undefined'),
(98, 17, 25, 'leads', 'Tegs:'),
(99, 18, 1, 'leads', 'Series Undefined'),
(100, 18, 2, 'leads', 'Model Undefined'),
(101, 18, 3, 'leads', 'Year Undefined'),
(102, 18, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"225\",\"dateOfFirstRegistration\":\"1 OCTOBER 2017\",\"dateOfLastV5CIssued\":\"5 NOVEMBER 2021\",\"yearOfManufacture\":\"2017\",\"cylinderCapacity\":\"1995cc\",\"co2Emissions\":\"128 g/km\",\"fuelType\":\"DIESEL\",\"transmission\":\"AUTOMATIC\",\"taxStatus\":\"Taxed\",\"colour\":\"WHITE\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 NOVEMBER 2025\",\"motDetails\":\"7 DECEMBER 2025\",\"vin\":\"WBA2N92090VC31736\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"YJ67XZC\"}'),
(103, 18, 25, 'leads', 'Undefined'),
(104, 19, 1, 'leads', 'Series Undefined'),
(105, 19, 2, 'leads', 'Model Undefined'),
(106, 19, 3, 'leads', 'Year Undefined'),
(107, 19, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"225\",\"dateOfFirstRegistration\":\"1 OCTOBER 2017\",\"dateOfLastV5CIssued\":\"5 NOVEMBER 2021\",\"yearOfManufacture\":\"2017\",\"cylinderCapacity\":\"1995cc\",\"co2Emissions\":\"128 g/km\",\"fuelType\":\"DIESEL\",\"transmission\":\"AUTOMATIC\",\"taxStatus\":\"Taxed\",\"colour\":\"WHITE\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 NOVEMBER 2025\",\"motDetails\":\"7 DECEMBER 2025\",\"vin\":\"WBA2N92090VC31736\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"YJ67XZC\"}'),
(108, 19, 25, 'leads', 'Undefined'),
(109, 20, 1, 'leads', 'Series Undefined'),
(110, 20, 2, 'leads', 'Model Undefined'),
(111, 20, 3, 'leads', 'Year Undefined'),
(112, 20, 24, 'leads', 'Undefined'),
(113, 21, 1, 'leads', 'Series Undefined'),
(114, 21, 2, 'leads', 'Model Undefined'),
(115, 21, 3, 'leads', 'Year Undefined'),
(116, 21, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"3 SERIES\",\"dateOfFirstRegistration\":\"1 JUNE 2010\",\"dateOfLastV5CIssued\":\"28 OCTOBER 2023\",\"yearOfManufacture\":\"2010\",\"cylinderCapacity\":\"1995cc\",\"co2Emissions\":\"147 g/km\",\"fuelType\":\"PETROL\",\"transmission\":\"MANUAL\",\"taxStatus\":\"SORN\",\"colour\":\"GREY\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"\",\"motDetails\":\"26 SEPTEMBER 2024\",\"vin\":\"WBAUS32010A684994\",\"taxed\":false,\"mot\":false,\"licence_plate\":\"Gl10omu\"}'),
(117, 21, 25, 'leads', 'Undefined'),
(118, 22, 24, 'leads', 'Undefined'),
(119, 22, 25, 'leads', 'Expand Your Business Visibility – Get Listed in Our Services Platform Now!<br />\r\n<br />\r\nHi,<br />\r\n<br />\r\nLooking to expand your audience? Our Services Directory is the perfect tool to boost your business’s visibility and reach clients searching for your expertise.<br />\r\n<br />\r\nWhether you’re a online strategist, ranking specialist, or app developer, we look forward to listing your business!<br />\r\n<br />\r\nSign up now and start benefiting from greater reach and targeted clients.<br />\r\n<br />\r\nGet started here: https://tinyurl.com/ycx5h5ew<br />\r\nBest regards,<br />\r\nAndrew<br />\r\n<br />\r\nAre you outside of the multimedia photography technology or advertising sector? It’s easy to opt out at the following URL: https://gotunsubscribed.com/?info=bmwreconengines.co.uk'),
(120, 23, 24, 'leads', 'Undefined'),
(121, 23, 25, 'leads', 'Undefined'),
(122, 24, 1, 'leads', 'BMW'),
(123, 24, 2, 'leads', 'BMW'),
(124, 24, 3, 'leads', '1991'),
(125, 24, 24, 'leads', 'Undefined'),
(126, 24, 25, 'leads', 'Undefined'),
(127, 25, 1, 'leads', 'Series Undefined'),
(128, 25, 2, 'leads', 'Model Undefined'),
(129, 25, 3, 'leads', 'Year Undefined'),
(130, 25, 24, 'leads', 'Undefined'),
(131, 25, 25, 'leads', 'Good Morning <br />\r\n<br />\r\nI wanted to reach out and let you know about our new dog harness. It\'s really easy to put on and take off - in just 2 seconds - and it\'s personalized for each dog. <br />\r\nPlus, we offer a lifetime warranty so you can be sure your pet is always safe and stylish.<br />\r\n<br />\r\nWe\'ve had a lot of success with it so far and I think your dog would love it. <br />\r\n<br />\r\nGet yours today with 50% OFF: https://caredogbest.com<br />\r\n<br />\r\nFREE Shipping - TODAY ONLY! <br />\r\n<br />\r\nThanks for your time, <br />\r\n<br />\r\nShayne'),
(132, 26, 1, 'leads', 'Series Undefined'),
(133, 26, 2, 'leads', 'Model Undefined'),
(134, 26, 3, 'leads', 'Year Undefined'),
(135, 26, 24, 'leads', 'Undefined'),
(136, 26, 25, 'leads', 'Hey Totalreconengines,<br />\r\n<br />\r\nImagine launching a product and selling out in 48 hours—without spending a fortune on ads. Sounds like a dream, right?<br />\r\n<br />\r\nThat’s exactly what happened to EcoStride, a sustainable sneaker brand. Instead of relying only on ads, they used a press release to get featured on Yahoo Finance, Google News, and 150+ media sites.<br />\r\n<br />\r\n✅ 11,400+ visitors in 5 days<br />\r\n✅ 300+ sales before ads even started<br />\r\n✅ 100% free organic traffic from media coverage<br />\r\n<br />\r\nAnd the best part? Writing a press release used to be time-consuming and difficult, but now EIN Presswire’s AI Press Release Generator makes it fast and effortless.<br />\r\n<br />\r\nJust enter your details, let AI craft a professional press release, and distribute it to top-tier media instantly.<br />\r\n<br />\r\nLaunch your next product the smart way.<br />\r\n<br />\r\nTry It Today: https://marketersmentor.com/sold-out-product-launch.php?refer=totalreconengines.co.uk&real=yes<br />\r\n<br />\r\nTo your success,<br />\r\nLouie<br />\r\n<br />\r\n<br />\r\nUnsubscribe: <br />\r\nhttps://marketersmentor.com/unsubscribe.php?d=totalreconengines.co.uk&real=yes'),
(137, 27, 1, 'leads', 'Series Undefined'),
(138, 27, 2, 'leads', 'Model Undefined'),
(139, 27, 3, 'leads', 'Year Undefined'),
(140, 27, 24, 'leads', 'Undefined'),
(141, 27, 25, 'leads', 'Hey Engineco,<br />\r\n<br />\r\nImagine launching a product and selling out in 48 hours—without spending a fortune on ads. Sounds like a dream, right?<br />\r\n<br />\r\nThat’s exactly what happened to EcoStride, a sustainable sneaker brand. Instead of relying only on ads, they used a press release to get featured on Yahoo Finance, Google News, and 150+ media sites.<br />\r\n<br />\r\n✅ 11,400+ visitors in 5 days<br />\r\n✅ 300+ sales before ads even started<br />\r\n✅ 100% free organic traffic from media coverage<br />\r\n<br />\r\nAnd the best part? Writing a press release used to be time-consuming and difficult, but now EIN Presswire’s AI Press Release Generator makes it fast and effortless.<br />\r\n<br />\r\nJust enter your details, let AI craft a professional press release, and distribute it to top-tier media instantly.<br />\r\n<br />\r\nLaunch your next product the smart way.<br />\r\n<br />\r\nTry It Today: https://marketersmentor.com/sold-out-product-launch.php?refer=engineco.co.uk&real=yes<br />\r\n<br />\r\nTo your success,<br />\r\nWilson<br />\r\n<br />\r\n<br />\r\nUnsubscribe: <br />\r\nhttps://marketersmentor.com/unsubscribe.php?d=engineco.co.uk&real=yes'),
(142, 28, 1, 'leads', 'BMW'),
(143, 28, 2, 'leads', 'BMW'),
(144, 28, 3, 'leads', '1998'),
(145, 28, 24, 'leads', 'Undefined'),
(146, 28, 25, 'leads', 'Undefined'),
(147, 29, 1, 'leads', 'Series Undefined'),
(148, 29, 2, 'leads', 'Model Undefined'),
(149, 29, 3, 'leads', 'Year Undefined'),
(150, 29, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"218\",\"dateOfFirstRegistration\":\"1 NOVEMBER 2016\",\"dateOfLastV5CIssued\":\"11 OCTOBER 2019\",\"yearOfManufacture\":\"2016\",\"cylinderCapacity\":\"1499cc\",\"co2Emissions\":\"123 g/km\",\"fuelType\":\"PETROL\",\"transmission\":\"MANUAL\",\"taxStatus\":\"Taxed\",\"colour\":\"BLACK\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 OCTOBER 2025\",\"motDetails\":\"29 NOVEMBER 2025\",\"vin\":\"WBA2D320705B43185\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"Mw66zra\"}'),
(151, 29, 25, 'leads', 'Undefined'),
(152, 30, 1, 'leads', 'BMW'),
(153, 30, 2, 'leads', 'BMW'),
(154, 30, 3, 'leads', '1990'),
(155, 30, 24, 'leads', 'Undefined'),
(156, 30, 25, 'leads', 'Undefined'),
(157, 31, 1, 'leads', 'BMW'),
(158, 31, 2, 'leads', 'BMW'),
(159, 31, 3, 'leads', '1982'),
(160, 31, 24, 'leads', 'Undefined'),
(161, 31, 25, 'leads', 'Undefined'),
(162, 32, 1, 'leads', 'Series Undefined'),
(163, 32, 2, 'leads', 'Model Undefined'),
(164, 32, 3, 'leads', 'Year Undefined'),
(165, 32, 24, 'leads', 'Undefined'),
(166, 32, 25, 'leads', 'Hi there, <br />\r\n <br />\r\nI understand that many find it challenging to grasp that search engine optimization takes patience and a strategic ongoing investment. <br />\r\n <br />\r\nUnfortunately, very few site owners have the willingness to witness the progressive yet business-changing results that can transform their online presence. <br />\r\n <br />\r\nWith constant search engine updates, a reliable, ongoing optimization plan is critical for achieving a positive ROI. <br />\r\n <br />\r\nIf you agree this as the most effective strategy, give us a try! <br />\r\n <br />\r\nExplore Our Monthly SEO Services <br />\r\nhttps://www.digital-x-press.com/unbeatable-seo/ <br />\r\n <br />\r\nContact Us on Live Support <br />\r\nhttps://www.digital-x-press.com/whatsapp-us/ <br />\r\n <br />\r\nWe offer unbeatable results for your marketing budget, and you will appreciate choosing us as your digital agency. <br />\r\n <br />\r\nBest regards, <br />\r\nDigital X SEO Experts <br />\r\nPhone/WhatsApp: +1 (844) 754-1148'),
(167, 33, 1, 'leads', 'Series Undefined'),
(168, 33, 2, 'leads', 'Model Undefined'),
(169, 33, 3, 'leads', 'Year Undefined'),
(170, 33, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"640\",\"dateOfFirstRegistration\":\"1 DECEMBER 2014\",\"dateOfLastV5CIssued\":\"29 NOVEMBER 2023\",\"yearOfManufacture\":\"2014\",\"cylinderCapacity\":\"2993cc\",\"co2Emissions\":\"149 g/km\",\"fuelType\":\"DIESEL\",\"transmission\":\"AUTOMATIC\",\"taxStatus\":\"Taxed\",\"colour\":\"BLACK\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 NOVEMBER 2025\",\"motDetails\":\"16 OCTOBER 2025\",\"vin\":\"WBA6A62090D103561\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"ek64szn\"}'),
(171, 33, 25, 'leads', 'Undefined'),
(172, 34, 1, 'leads', 'Series Undefined'),
(173, 34, 2, 'leads', 'Model Undefined'),
(174, 34, 3, 'leads', 'Year Undefined'),
(175, 34, 24, 'leads', 'Undefined'),
(176, 34, 25, 'leads', 'not working  <br />\r\n_________________ <br />\r\ncricket-2025'),
(177, 35, 1, 'leads', 'Series Undefined'),
(178, 35, 2, 'leads', 'Model Undefined'),
(179, 35, 3, 'leads', 'Year Undefined'),
(180, 35, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"640\",\"dateOfFirstRegistration\":\"1 DECEMBER 2014\",\"dateOfLastV5CIssued\":\"29 NOVEMBER 2023\",\"yearOfManufacture\":\"2014\",\"cylinderCapacity\":\"2993cc\",\"co2Emissions\":\"149 g/km\",\"fuelType\":\"DIESEL\",\"transmission\":\"AUTOMATIC\",\"taxStatus\":\"Taxed\",\"colour\":\"BLACK\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 NOVEMBER 2025\",\"motDetails\":\"16 OCTOBER 2025\",\"vin\":\"WBA6A62090D103561\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"ek64szn\"}'),
(181, 35, 25, 'leads', 'Undefined'),
(182, 36, 1, 'leads', '4 Series'),
(183, 36, 2, 'leads', '420d Gran Coupe'),
(184, 36, 3, 'leads', '2014'),
(185, 36, 24, 'leads', 'Undefined'),
(186, 36, 25, 'leads', 'Undefined'),
(187, 37, 1, 'leads', 'Series Undefined'),
(188, 37, 2, 'leads', 'Model Undefined'),
(189, 37, 3, 'leads', 'Year Undefined'),
(190, 37, 24, 'leads', 'Undefined'),
(191, 38, 1, 'leads', 'Series Undefined'),
(192, 38, 2, 'leads', 'Model Undefined'),
(193, 38, 3, 'leads', 'Year Undefined'),
(194, 38, 24, 'leads', 'Undefined'),
(195, 39, 1, 'leads', 'Series Undefined'),
(196, 39, 2, 'leads', 'Model Undefined'),
(197, 39, 3, 'leads', 'Year Undefined'),
(198, 39, 24, 'leads', 'Undefined'),
(199, 39, 25, 'leads', 'Hello engineco.co.uk,<br />\r\n<br />\r\nStruggling with low website traffic and difficulty generating quality leads?<br />\r\n<br />\r\nIf you\'d like to hear more about how our services and solutions can help, feel free to ask.<br />\r\n<br />\r\nWell wishes,<br />\r\nLucy Gordon | Digital Marketing Manager<br />\r\n<br />\r\n<br />\r\n<br />\r\nNote: - If you’re not Interested in our Services, send us  \"opt-out\"'),
(200, 40, 1, 'leads', 'BMW'),
(201, 40, 2, 'leads', 'BMW'),
(202, 40, 3, 'leads', '1987'),
(203, 40, 24, 'leads', 'Undefined'),
(204, 40, 25, 'leads', 'Undefined'),
(205, 41, 1, 'leads', 'Series Undefined'),
(206, 41, 2, 'leads', 'Model Undefined'),
(207, 41, 3, 'leads', 'Year Undefined'),
(208, 41, 24, 'leads', 'Undefined'),
(209, 41, 25, 'leads', 'Hi, <br />\r\n <br />\r\nThis is Mike from Monkey Digital, <br />\r\nI am getting in touch regarding a great opportunity. <br />\r\n <br />\r\nHow would you like to place our banners on your platform and link back via your personalized affiliate link towards high-demand services from our platform? <br />\r\n <br />\r\nThis way, you receive a 35% residual income, month after month from any transactions that generate from your site. <br />\r\n <br />\r\nThink about it, everyone benefit from SEO, so this is a massive opportunity. <br />\r\n <br />\r\nWe already have thousands of affiliates and our payments are paid out monthly. <br />\r\nLast month, we reached a significant amount in affiliate earnings to our promoters. <br />\r\n <br />\r\nIf this sounds good, kindly chat with us here: <br />\r\nhttps://monkeydigital.co/affiliates-whatsapp/ <br />\r\n <br />\r\nOr register today: <br />\r\nhttps://www.monkeydigital.co/join-our-affiliate-program/ <br />\r\n <br />\r\nBest Regards, <br />\r\nMike Elias Maes<br />\r\n <br />\r\nPhone/whatsapp: +1 (775) 314-7914'),
(210, 42, 1, 'leads', 'Series Undefined'),
(211, 42, 2, 'leads', 'Model Undefined'),
(212, 42, 3, 'leads', 'Year Undefined'),
(213, 42, 24, 'leads', '{\"make\":\"KIA\",\"model\":\"SEDONA\",\"dateOfFirstRegistration\":\"1 APRIL 2008\",\"dateOfLastV5CIssued\":\"25 MAY 2021\",\"yearOfManufacture\":\"2008\",\"cylinderCapacity\":\"2902cc\",\"co2Emissions\":\"237 g/km\",\"fuelType\":\"DIESEL\",\"transmission\":\"AUTOMATIC\",\"taxStatus\":\"Taxed\",\"colour\":\"BLACK\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"2920 kg\",\"taxDetails\":\"1 JULY 2025\",\"motDetails\":\"11 SEPTEMBER 2025\",\"vin\":\"KNEMB754386225075\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"Dx08kgn\"}'),
(214, 42, 25, 'leads', 'Undefined'),
(215, 43, 1, 'leads', 'Series Undefined'),
(216, 43, 2, 'leads', 'Model Undefined'),
(217, 43, 3, 'leads', 'Year Undefined'),
(218, 43, 24, 'leads', 'Undefined'),
(219, 43, 25, 'leads', 'Hi,<br />\r\nWe’re really interested in building a long-term business relationship with a company like yours. Could you please share your offerings and prices? Let’s connect on WhatsApp: +48 731 721 863'),
(220, 44, 1, 'leads', 'Series Undefined'),
(221, 44, 2, 'leads', 'Model Undefined'),
(222, 44, 3, 'leads', 'Year Undefined'),
(223, 44, 24, 'leads', 'Undefined'),
(224, 44, 25, 'leads', 'Hi there,<br />\r\n<br />\r\nWe run a YouTube growth service, which increases your number of subscribers both safely and practically.<br />\r\n<br />\r\n- We guarantee to gain you 700-1500+ subscribers per month.<br />\r\n- People subscribe because they are interested in your channel/videos, increasing likes, comments and interaction.<br />\r\n- All actions are made manually by our team. We do not use any \'bots\'.<br />\r\n- Channel Creation: If you haven\'t started your YouTube journey yet, we can create a professional channel for you as part of your initial order.<br />\r\n<br />\r\nThe price is just $60 (USD) per month, and we can start immediately.<br />\r\n<br />\r\nIf you have any questions, let me know, and we can discuss further.<br />\r\n<br />\r\nKind Regards,<br />\r\nFelicity'),
(225, 45, 1, 'leads', 'Series Undefined'),
(226, 45, 2, 'leads', 'Model Undefined'),
(227, 45, 3, 'leads', 'Year Undefined'),
(228, 45, 24, 'leads', 'Undefined'),
(229, 46, 1, 'leads', '1 Series'),
(230, 46, 2, 'leads', '130i'),
(231, 46, 3, 'leads', '2015'),
(232, 46, 24, 'leads', 'Undefined'),
(233, 46, 25, 'leads', 'Undefined'),
(234, 47, 1, 'leads', 'Series Undefined'),
(235, 47, 2, 'leads', 'Model Undefined'),
(236, 47, 3, 'leads', 'Year Undefined'),
(237, 47, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"5 SERIES\",\"dateOfFirstRegistration\":\"1 MARCH 2017\",\"dateOfLastV5CIssued\":\"29 AUGUST 2024\",\"yearOfManufacture\":\"2017\",\"cylinderCapacity\":\"2993cc\",\"co2Emissions\":\"124 g/km\",\"fuelType\":\"DIESEL\",\"transmission\":\"AUTOMATIC\",\"taxStatus\":\"Taxed\",\"colour\":\"GREY\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 SEPTEMBER 2025\",\"motDetails\":\"17 JUNE 2025\",\"vin\":\"WBAJC92080G471959\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"NX17MFU\"}'),
(238, 47, 25, 'leads', 'Undefined'),
(239, 48, 1, 'leads', '1 Series'),
(240, 48, 2, 'leads', '116i'),
(241, 48, 3, 'leads', '2012'),
(242, 48, 24, 'leads', 'Undefined'),
(243, 48, 25, 'leads', 'Undefined'),
(244, 49, 1, 'leads', 'Series Undefined'),
(245, 49, 2, 'leads', 'Model Undefined'),
(246, 49, 3, 'leads', 'Year Undefined'),
(247, 49, 24, 'leads', 'Undefined'),
(248, 50, 1, 'leads', 'Series Undefined'),
(249, 50, 2, 'leads', 'Model Undefined'),
(250, 50, 3, 'leads', 'Year Undefined'),
(251, 50, 24, 'leads', '{\"make\":\"BMW\",\"model\":\"5 SERIES\",\"dateOfFirstRegistration\":\"1 MARCH 2017\",\"dateOfLastV5CIssued\":\"29 AUGUST 2024\",\"yearOfManufacture\":\"2017\",\"cylinderCapacity\":\"2993cc\",\"co2Emissions\":\"124 g/km\",\"fuelType\":\"DIESEL\",\"transmission\":\"AUTOMATIC\",\"taxStatus\":\"Taxed\",\"colour\":\"GREY\",\"typeApproval\":\"M1\",\"wheelPlan\":\"2 AXLE RIGID BODY\",\"revenueWeight\":\"Not available\",\"taxDetails\":\"1 SEPTEMBER 2025\",\"motDetails\":\"17 JUNE 2025\",\"vin\":\"WBAJC92080G471959\",\"taxed\":true,\"mot\":true,\"licence_plate\":\"NX17MFU\"}'),
(252, 50, 25, 'leads', 'Undefined'),
(253, 51, 1, 'leads', '4 Series'),
(254, 51, 2, 'leads', '420d Gran Coupe'),
(255, 51, 3, 'leads', '2017'),
(256, 51, 24, 'leads', 'Undefined'),
(257, 51, 25, 'leads', 'Undefined'),
(258, 52, 1, 'leads', 'Series Undefined'),
(259, 52, 2, 'leads', 'Model Undefined'),
(260, 52, 3, 'leads', 'Year Undefined'),
(261, 52, 24, 'leads', 'Undefined'),
(262, 53, 1, 'leads', 'Series Undefined'),
(263, 53, 2, 'leads', 'Model Undefined'),
(264, 53, 3, 'leads', 'Year Undefined'),
(265, 53, 24, 'leads', 'Undefined'),
(266, 54, 1, 'leads', 'BMW'),
(267, 54, 2, 'leads', 'BMW'),
(268, 54, 3, 'leads', '1982'),
(269, 54, 24, 'leads', 'Undefined'),
(270, 54, 25, 'leads', 'Undefined'),
(271, 55, 1, 'leads', '3 Series'),
(272, 55, 2, 'leads', '325i'),
(273, 55, 3, 'leads', '2004'),
(274, 55, 24, 'leads', 'Undefined'),
(275, 55, 25, 'leads', 'Undefined'),
(276, 56, 1, 'leads', 'Series Undefined'),
(277, 56, 2, 'leads', 'Model Undefined'),
(278, 56, 3, 'leads', 'Year Undefined'),
(279, 56, 24, 'leads', 'Undefined'),
(280, 56, 25, 'leads', 'Hi there!<br />\r\nWe’re interested in working with companies like yours for the long term. Could you send us your product list and prices? You can reach me on WhatsApp: +48 517 276 110');

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

--
-- Table structure for table `tbldepartments`
--

CREATE TABLE `tbldepartments` (
  `departmentid` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `imap_username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_from_header` tinyint(1) NOT NULL DEFAULT '0',
  `host` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` longtext COLLATE utf8mb4_unicode_ci,
  `encryption` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INBOX',
  `delete_after_import` int(11) NOT NULL DEFAULT '0',
  `calendar_id` longtext COLLATE utf8mb4_unicode_ci,
  `hidefromclient` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbldismissed_announcements`
--

CREATE TABLE `tbldismissed_announcements` (
  `dismissedannouncementid` int(11) NOT NULL,
  `announcementid` int(11) NOT NULL,
  `staff` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblemailtemplates`
--

CREATE TABLE `tblemailtemplates` (
  `emailtemplateid` int(11) NOT NULL,
  `type` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromname` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromemail` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plaintext` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;












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

--
-- Table structure for table `tblestimates`
--

CREATE TABLE `tblestimates` (
  `id` int(11) NOT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `datesend` datetime DEFAULT NULL,
  `clientid` int(11) NOT NULL,
  `deleted_customer_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `number` int(11) NOT NULL,
  `prefix` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_format` int(11) NOT NULL DEFAULT '0',
  `formatted_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hash` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `expirydate` date DEFAULT NULL,
  `currency` int(11) NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `total_tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `addedfrom` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `clientnote` mediumtext COLLATE utf8mb4_unicode_ci,
  `adminnote` mediumtext COLLATE utf8mb4_unicode_ci,
  `discount_percent` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `discount_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoiceid` int(11) DEFAULT NULL,
  `invoiced_date` datetime DEFAULT NULL,
  `terms` mediumtext COLLATE utf8mb4_unicode_ci,
  `reference_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sale_agent` int(11) NOT NULL DEFAULT '0',
  `billing_street` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int(11) DEFAULT NULL,
  `shipping_street` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int(11) DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_estimate` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int(11) NOT NULL DEFAULT '1',
  `pipeline_order` int(11) DEFAULT '1',
  `is_expiry_notified` int(11) NOT NULL DEFAULT '0',
  `acceptance_firstname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_lastname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_date` datetime DEFAULT NULL,
  `acceptance_ip` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_link` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblestimate_requests`
--

CREATE TABLE `tblestimate_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `submission` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_status_change` datetime DEFAULT NULL,
  `date_estimated` datetime DEFAULT NULL,
  `from_form_id` int(11) DEFAULT NULL,
  `assigned` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `default_language` int(11) NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblestimate_request_forms`
--

CREATE TABLE `tblestimate_request_forms` (
  `id` int(10) UNSIGNED NOT NULL,
  `form_key` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_data` longtext COLLATE utf8mb4_unicode_ci,
  `recaptcha` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `submit_btn_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submit_btn_bg_color` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '#84c529',
  `submit_btn_text_color` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '#ffffff',
  `success_submit_msg` mediumtext COLLATE utf8mb4_unicode_ci,
  `submit_action` int(11) DEFAULT '0',
  `submit_redirect_url` longtext COLLATE utf8mb4_unicode_ci,
  `language` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateadded` datetime DEFAULT NULL,
  `notify_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_ids` longtext COLLATE utf8mb4_unicode_ci,
  `responsible` int(11) DEFAULT NULL,
  `notify_request_submitted` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblestimate_request_status`
--

CREATE TABLE `tblestimate_request_status` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `statusorder` int(11) DEFAULT NULL,
  `color` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblestimate_request_status`
--

INSERT INTO `tblestimate_request_status` (`id`, `name`, `statusorder`, `color`, `flag`) VALUES
(1, 'Cancelled', 1, '#808080', 'cancelled'),
(2, 'Processing', 2, '#007bff', 'processing'),
(3, 'Completed', 3, '#28a745', 'completed');

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

--
-- Table structure for table `tblevents`
--

CREATE TABLE `tblevents` (
  `eventid` int(11) NOT NULL,
  `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `userid` int(11) NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `public` int(11) NOT NULL DEFAULT '0',
  `color` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isstartnotified` tinyint(1) NOT NULL DEFAULT '0',
  `reminder_before` int(11) NOT NULL DEFAULT '0',
  `reminder_before_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblexpenses`
--

CREATE TABLE `tblexpenses` (
  `id` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `currency` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `tax` int(11) DEFAULT NULL,
  `tax2` int(11) NOT NULL DEFAULT '0',
  `reference_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` mediumtext COLLATE utf8mb4_unicode_ci,
  `expense_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clientid` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `billable` int(11) DEFAULT '0',
  `invoiceid` int(11) DEFAULT NULL,
  `paymentmode` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `recurring_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repeat_every` int(11) DEFAULT NULL,
  `recurring` int(11) NOT NULL DEFAULT '0',
  `cycles` int(11) NOT NULL DEFAULT '0',
  `total_cycles` int(11) NOT NULL DEFAULT '0',
  `custom_recurring` int(11) NOT NULL DEFAULT '0',
  `last_recurring_date` date DEFAULT NULL,
  `create_invoice_billable` tinyint(1) DEFAULT NULL,
  `send_invoice_to_customer` tinyint(1) NOT NULL,
  `recurring_from` int(11) DEFAULT NULL,
  `dateadded` datetime NOT NULL,
  `addedfrom` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblexpenses_categories`
--

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

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

--
-- Table structure for table `tblfiles`
--

CREATE TABLE `tblfiles` (
  `id` int(11) NOT NULL,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filetype` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visible_to_customer` int(11) NOT NULL DEFAULT '0',
  `attachment_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external_link` mediumtext COLLATE utf8mb4_unicode_ci,
  `thumbnail_link` mediumtext COLLATE utf8mb4_unicode_ci COMMENT 'For external usage',
  `staffid` int(11) NOT NULL,
  `contact_id` int(11) DEFAULT '0',
  `task_comment_id` int(11) NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblfilters`
--

CREATE TABLE `tblfilters` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `builder` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `staff_id` int(10) UNSIGNED NOT NULL,
  `identifier` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_shared` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblfilter_defaults`
--

CREATE TABLE `tblfilter_defaults` (
  `filter_id` int(10) UNSIGNED NOT NULL,
  `staff_id` int(11) NOT NULL,
  `identifier` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `view` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblform_questions`
--

CREATE TABLE `tblform_questions` (
  `questionid` int(11) NOT NULL,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `question_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblform_question_box`
--

CREATE TABLE `tblform_question_box` (
  `boxid` int(11) NOT NULL,
  `boxtype` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `questionid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblform_question_box_description`
--

CREATE TABLE `tblform_question_box_description` (
  `questionboxdescriptionid` int(11) NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `boxid` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `questionid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblform_results`
--

CREATE TABLE `tblform_results` (
  `resultid` int(11) NOT NULL,
  `boxid` int(11) NOT NULL,
  `boxdescriptionid` int(11) DEFAULT NULL,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `questionid` int(11) NOT NULL,
  `answer` mediumtext COLLATE utf8mb4_unicode_ci,
  `resultsetid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblftp_accounts`
--

CREATE TABLE `tblftp_accounts` (
  `id` int(11) NOT NULL,
  `hosting_id` int(11) DEFAULT NULL,
  `account_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hostname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `protocol` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ftp',
  `root_directory` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `description` text COLLATE utf8_unicode_ci,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblgdpr_requests`
--

CREATE TABLE `tblgdpr_requests` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL DEFAULT '0',
  `contact_id` int(11) NOT NULL DEFAULT '0',
  `lead_id` int(11) NOT NULL DEFAULT '0',
  `request_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `request_from` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblhm_database`
--

CREATE TABLE `tblhm_database` (
  `id` int(11) NOT NULL,
  `hosting_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `access_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `database_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `database_username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `database_password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enable',
  `description` text COLLATE utf8_unicode_ci,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblhm_domains`
--

CREATE TABLE `tblhm_domains` (
  `id` int(11) NOT NULL,
  `hosting_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ssl_active` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enable',
  `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `description` text COLLATE utf8_unicode_ci,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblib_customfield`
--

CREATE TABLE `tblib_customfield` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `label` text COLLATE utf8_unicode_ci,
  `formula` text COLLATE utf8_unicode_ci,
  `slug` text COLLATE utf8_unicode_ci,
  `type` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblib_customfield_value`
--

CREATE TABLE `tblib_customfield_value` (
  `id` int(11) NOT NULL,
  `customfield_id` int(11) NOT NULL,
  `template_id` int(11) DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblib_invoices_built`
--

CREATE TABLE `tblib_invoices_built` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `hash` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(55) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `updated_data` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblib_templates`
--

CREATE TABLE `tblib_templates` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `content` longtext COLLATE utf8_unicode_ci,
  `active` int(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_template` int(1) DEFAULT NULL,
  `setting` text COLLATE utf8_unicode_ci,
  `capture_image` longtext COLLATE utf8_unicode_ci,
  `capture_html` longtext COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tblib_templates`
--

INSERT INTO `tblib_templates` (`id`, `name`, `note`, `content`, `active`, `created_at`, `updated_at`, `created_by`, `file_name`, `default_template`, `setting`, `capture_image`, `capture_html`) VALUES
(1, 'Green Template', NULL, NULL, 1, '2022-03-26 16:34:12', '2022-03-26 16:34:12', 1, NULL, 1, '{\"name\":\"Green Template\",\"background_color\":\"#ffffff\",\"page_rotation\":\"portrait\",\"header\":{\"row_color\":\"#ffffff\",\"col_number\":\"4\",\"logo\":{\"active\":\"1\",\"show_on_column\":\"1\",\"text_align\":\"left\",\"width\":\"159\",\"height\":\"150\"},\"qrcode\":{\"active\":\"1\",\"show_on_column\":\"3\",\"text_align\":\"right\",\"width\":\"60\",\"height\":\"60\"},\"title\":{\"active\":\"1\",\"show_on_column\":\"2\",\"text_color\":\"#b0dd48\",\"font_size\":\"25\",\"font_style\":\"initial\",\"text_align\":\"right\"},\"invoice_infor\":{\"active\":\"1\",\"invoice_number\":\"1\",\"invoice_date\":\"1\",\"invoice_due_date\":\"1\",\"invoice_status\":\"1\",\"show_on_column\":\"4\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"left\"}},\"cf_header_invoice_field_available\":\"\",\"cf_header_invoice_field_name\":\"\",\"cf_header_invoice_field_label\":\"\",\"sender_receiver\":{\"row_color\":\"#ffffff\",\"col_number\":\"2\",\"sender_infor\":{\"active\":\"1\",\"show_on_column\":\"1\",\"column_color\":\"#ffffff\",\"name\":{\"active\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"17\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"phone\":{\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"email\":{\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"website\":{\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"street\":{\"active\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"city\":{\"active\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"state\":{\"active\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"zipcode\":{\"active\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"country\":{\"active\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"vat\":{\"active\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"sales_person\":{\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"}},\"receiver_infor\":{\"active\":\"1\",\"show_on_column\":\"2\",\"column_color\":\"#b0dd48\",\"name\":{\"active\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"17\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"phone\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"email\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"left\"},\"website\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"street\":{\"active\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"city\":{\"active\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"state\":{\"active\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"zipcode\":{\"active\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"12\",\"font_style\":\"unset\",\"text_align\":\"left\"},\"country\":{\"active\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"vat\":{\"active\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"billing_to\":{\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"shipping_to\":{\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"}}},\"cf_sender_field_available\":\"\",\"cf_sender_field_name\":\"\",\"cf_sender_field_label\":\"\",\"cf_receiver_field_available\":\"\",\"cf_receiver_field_name\":\"\",\"cf_receiver_field_label\":\"\",\"item_table\":{\"thead_color\":\"#b0dd48\",\"text_color\":\"#ffffff\",\"font_size\":\"14\",\"font_style\":\"italic\",\"text_align\":\"left\",\"striped_row\":{\"odd_row_color\":\"#6e82a8\",\"even_row_color\":\"#6e82a8\"},\"item_order\":{\"order_column\":\"1\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"left\"},\"item_name\":{\"active\":\"1\",\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"description\":{\"order_column\":\"3\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"quantity\":{\"active\":\"1\",\"order_column\":\"4\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"unit\":{\"active\":\"1\",\"order_column\":\"5\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"unit_price\":{\"active\":\"1\",\"order_column\":\"6\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"tax_rate\":{\"order_column\":\"7\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"tax_amount\":{\"order_column\":\"8\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"subtotal\":{\"active\":\"1\",\"order_column\":\"9\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"sku\":{\"active\":\"1\",\"order_column\":\"10\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"image\":{\"active\":\"1\",\"order_column\":\"1\",\"width\":\"80\",\"height\":\"80\"},\"barcode\":{\"order_column\":\"12\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"center\"}},\"cf_item_table_field_available\":\"\",\"cf_item_table_field_name\":\"\",\"cf_item_table_field_label\":\"\",\"cf_item_table_field_value\":\"\",\"add_expression_slug\":\"\",\"cf_item_table_field_formula\":\"\",\"invoice_total\":{\"row_color\":\"#b0dd48\",\"col_number\":\"3\",\"subtotal_label\":{\"active\":\"1\",\"label_content\":\"Sub total\",\"order_column\":\"2\",\"text_color\":\"#ffffff\",\"font_size\":\"16\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"subtotal_value\":{\"active\":\"1\",\"order_column\":\"3\",\"text_color\":\"#ffffff\",\"font_size\":\"16\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"taxes_label\":{\"label_content\":\"Taxes\",\"order_column\":\"3\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"italic\",\"text_align\":\"left\"},\"taxes_value\":{\"order_column\":\"4\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"total_tax_label\":{\"label_content\":\"Total tax\",\"order_column\":\"1\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"total_tax_value\":{\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"discount_label\":{\"label_content\":\"Discount\",\"order_column\":\"3\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"discount_value\":{\"order_column\":\"4\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"grand_total_label\":{\"active\":\"1\",\"label_content\":\"Grand total\",\"order_column\":\"2\",\"text_color\":\"#ffffff\",\"font_size\":\"16\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"grand_total_value\":{\"active\":\"1\",\"order_column\":\"3\",\"text_color\":\"#ffffff\",\"font_size\":\"16\",\"font_style\":\"initial\",\"text_align\":\"right\"},\"payment_amount_label\":{\"label_content\":\"\",\"order_column\":\"\",\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"payment_amount_value\":{\"order_column\":\"\",\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"}},\"cf_invoice_field_available\":\"\",\"cf_invoice_total_field_name\":\"\",\"cf_invoice_total_field_label\":\"\",\"cf_invoice_total_field_value\":\"\",\"cf_invoice_total_field_formula\":\"\",\"bottom_information\":{\"row_color\":\"#f6fbeb\",\"col_number\":\"2\",\"payment_method\":{\"label_content\":\"Cash On Delivery\",\"order_column\":\"2\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"bank_infor\":{\"label_content\":\"National Bank\",\"order_column\":\"2\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"signature\":{\"active\":\"1\",\"label_content\":\" \",\"order_column\":\"2\",\"width\":\"100\",\"height\":\"100\",\"text_align\":\"right\"},\"qrcode\":{\"active\":\"1\",\"label_content\":\" \",\"order_column\":\"1\",\"width\":\"109\",\"height\":\"109\",\"text_align\":\"left\"},\"messages\":{\"active\":\"1\",\"content\":\"Scan to view information\",\"order_column\":\"1\",\"text_color\":\"#b0dd48\",\"font_size\":\"10\",\"font_style\":\"unset\",\"text_align\":\"left\"},\"delivery_note\":{\"content\":\"Delivery note content\",\"order_column\":\"2\",\"text_color\":\"#b0dd48\",\"font_size\":\"11\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"client_note\":{\"content\":\"Client note content\",\"order_column\":\"2\",\"text_color\":\"#b0dd48\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"right\"}},\"cf_bottom_field_available\":\"\",\"cf_bottom_field_name\":\"\",\"cf_bottom_field_label\":\"\",\"footer\":{\"row_color\":\"#6e82a8\",\"col_number\":\"1\",\"term_condition\":{\"active\":\"1\",\"content\":\"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.\",\"order_column\":\"1\",\"text_color\":\"#ffffff\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"left\"}},\"cf_footer_field_available\":\"\",\"cf_footer_field_name\":\"\",\"cf_footer_field_label\":\"\",\"item_table|quantity\":\"2\",\"item_table|unit_price\":\"50\",\"item_table|tax_rate\":\"0\",\"item_table|tax_amount\":\"0\",\"item_table|subtotal\":\"100\",\"invoice_total|total_tax_value\":\"0\",\"invoice_total|subtotal_value\":\"100\",\"invoice_total|grand_total_value\":\"150\"}', '[encoded data, 231112 characters]', '');
INSERT INTO `tblib_templates` (`id`, `name`, `note`, `content`, `active`, `created_at`, `updated_at`, `created_by`, `file_name`, `default_template`, `setting`, `capture_image`, `capture_html`) VALUES
(2, 'Landcape Orange Invoice Template', NULL, NULL, 1, '2022-03-26 16:34:12', '2022-03-26 16:34:12', 1, NULL, 1, '{\"name\":\"Landcape Template\",\"background_color\":\"#ffffff\",\"page_rotation\":\"landcape\",\"header\":{\"row_color\":\"#ffffff\",\"col_number\":\"3\",\"logo\":{\"active\":\"1\",\"show_on_column\":\"1\",\"text_align\":\"left\",\"width\":\"390\",\"height\":\"256\"},\"qrcode\":{\"active\":\"1\",\"show_on_column\":\"3\",\"text_align\":\"right\",\"width\":\"60\",\"height\":\"60\"},\"title\":{\"active\":\"1\",\"show_on_column\":\"2\",\"text_color\":\"#eca82c\",\"font_size\":\"32\",\"font_style\":\"normal\",\"text_align\":\"center\"},\"invoice_infor\":{\"active\":\"1\",\"invoice_number\":\"1\",\"invoice_date\":\"1\",\"invoice_due_date\":\"1\",\"invoice_amount\":\"1\",\"invoice_status\":\"1\",\"show_on_column\":\"3\",\"text_color\":\"#15cf15\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"right\"}},\"cf_header_invoice_field_available\":\"\",\"cf_header_invoice_field_name\":\"\",\"cf_header_invoice_field_label\":\"\",\"sender_receiver\":{\"row_color\":\"#f5ead6\",\"col_number\":\"2\",\"sender_infor\":{\"active\":\"1\",\"show_on_column\":\"1\",\"column_color\":\"#f5ead6\",\"name\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"24\",\"font_style\":\"italic\",\"text_align\":\"left\"},\"phone\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"email\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"website\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"street\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"city\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"state\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"zipcode\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"country\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"vat\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"sales_person\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"}},\"receiver_infor\":{\"active\":\"1\",\"show_on_column\":\"2\",\"column_color\":\"#ffffff\",\"name\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"24\",\"font_style\":\"italic\",\"text_align\":\"left\"},\"phone\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"email\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"left\"},\"website\":{\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"street\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"city\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"state\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"zipcode\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"unset\",\"text_align\":\"left\"},\"country\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"vat\":{\"active\":\"1\",\"text_color\":\"#eca82c\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"billing_to\":{\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"shipping_to\":{\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"}}},\"cf_sender_field_available\":\"\",\"cf_sender_field_name\":\"\",\"cf_sender_field_label\":\"\",\"cf_receiver_field_available\":\"\",\"cf_receiver_field_name\":\"\",\"cf_receiver_field_label\":\"\",\"item_table\":{\"thead_color\":\"#eca82c\",\"text_color\":\"#ffffff\",\"font_size\":\"15\",\"font_style\":\"normal\",\"text_align\":\"left\",\"striped_row\":{\"active\":\"1\",\"odd_row_color\":\"#ffffff\",\"even_row_color\":\"#fcfaf6\"},\"item_order\":{\"active\":\"1\",\"order_column\":\"1\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"left\"},\"item_name\":{\"active\":\"1\",\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"description\":{\"active\":\"1\",\"order_column\":\"3\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"quantity\":{\"active\":\"1\",\"order_column\":\"4\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"italic\",\"text_align\":\"left\"},\"unit\":{\"active\":\"1\",\"order_column\":\"5\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"unit_price\":{\"active\":\"1\",\"order_column\":\"6\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"tax_rate\":{\"active\":\"1\",\"order_column\":\"7\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"tax_amount\":{\"active\":\"1\",\"order_column\":\"8\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"subtotal\":{\"active\":\"1\",\"order_column\":\"9\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"initial\",\"text_align\":\"left\"},\"sku\":{\"active\":\"1\",\"order_column\":\"10\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"image\":{\"active\":\"1\",\"order_column\":\"1\",\"width\":\"100\",\"height\":\"100\"},\"barcode\":{\"order_column\":\"12\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"center\"}},\"cf_item_table_field_available\":\"\",\"cf_item_table_field_name\":\"\",\"cf_item_table_field_label\":\"\",\"cf_item_table_field_value\":\"\",\"add_expression_slug\":\"\",\"cf_item_table_field_formula\":\"\",\"invoice_total\":{\"row_color\":\"#ffffff\",\"col_number\":\"4\",\"subtotal_label\":{\"active\":\"1\",\"label_content\":\"Subtotal\",\"order_column\":\"3\",\"text_color\":\"#eca82c\",\"font_size\":\"19\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"subtotal_value\":{\"active\":\"1\",\"order_column\":\"4\",\"text_color\":\"#eca82c\",\"font_size\":\"19\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"taxes_label\":{\"label_content\":\"Taxes\",\"order_column\":\"3\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"italic\",\"text_align\":\"left\"},\"taxes_value\":{\"order_column\":\"4\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"total_tax_label\":{\"label_content\":\"Total tax\",\"order_column\":\"1\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"total_tax_value\":{\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"discount_label\":{\"label_content\":\"Discount\",\"order_column\":\"3\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"discount_value\":{\"order_column\":\"4\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"grand_total_label\":{\"active\":\"1\",\"label_content\":\"Grand total\",\"order_column\":\"3\",\"text_color\":\"#eca82c\",\"font_size\":\"19\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"grand_total_value\":{\"active\":\"1\",\"order_column\":\"4\",\"text_color\":\"#eca82c\",\"font_size\":\"19\",\"font_style\":\"initial\",\"text_align\":\"right\"},\"payment_amount_label\":{\"label_content\":\"\",\"order_column\":\"\",\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"},\"payment_amount_value\":{\"order_column\":\"\",\"text_color\":\"#000000\",\"font_size\":\"13\",\"font_style\":\"normal\",\"text_align\":\"left\"}},\"cf_invoice_field_available\":\"\",\"cf_invoice_total_field_name\":\"\",\"cf_invoice_total_field_label\":\"\",\"cf_invoice_total_field_value\":\"\",\"cf_invoice_total_field_formula\":\"\",\"bottom_information\":{\"row_color\":\"#ffffff\",\"col_number\":\"2\",\"payment_method\":{\"label_content\":\"Payment Method: COD\",\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"bank_infor\":{\"label_content\":\"National Bank\",\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"right\"},\"signature\":{\"label_content\":\" \",\"order_column\":\"2\",\"width\":\"117\",\"height\":\"100\",\"text_align\":\"right\"},\"qrcode\":{\"label_content\":\" \",\"order_column\":\"1\",\"width\":\"100\",\"height\":\"100\",\"text_align\":\"left\"},\"messages\":{\"content\":\"Scan to view information\",\"order_column\":\"1\",\"text_color\":\"#000000\",\"font_size\":\"10\",\"font_style\":\"unset\",\"text_align\":\"left\"},\"delivery_note\":{\"content\":\"Delivery note content\",\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"11\",\"font_style\":\"oblique\",\"text_align\":\"right\"},\"client_note\":{\"content\":\"Client note content\",\"order_column\":\"2\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"normal\",\"text_align\":\"right\"}},\"cf_bottom_field_available\":\"\",\"cf_bottom_field_name\":\"\",\"cf_bottom_field_label\":\"\",\"footer\":{\"row_color\":\"#f5ead6\",\"col_number\":\"1\",\"term_condition\":{\"active\":\"1\",\"content\":\"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.\",\"order_column\":\"1\",\"text_color\":\"#000000\",\"font_size\":\"12\",\"font_style\":\"oblique\",\"text_align\":\"left\"}},\"cf_footer_field_available\":\"\",\"cf_footer_field_name\":\"\",\"cf_footer_field_label\":\"\",\"item_table|quantity\":\"2\",\"item_table|unit_price\":\"50\",\"item_table|tax_rate\":\"0\",\"item_table|tax_amount\":\"0\",\"item_table|subtotal\":\"100\",\"invoice_total|total_tax_value\":\"0\",\"invoice_total|subtotal_value\":\"100\",\"invoice_total|taxes_value\":\"0\",\"invoice_total|discount_value\":\"0\",\"invoice_total|grand_total_value\":\"150\"}', '[encoded data, 143444 characters]