-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 22, 2026 at 01:46 PM -- Server version: 10.6.20-MariaDB-cll-lve -- PHP Version: 8.4.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `jaytrends_admin` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_manual` -- CREATE TABLE `tbl_manual` ( `id` tinyint(4) NOT NULL, `manual_name` varchar(255) NOT NULL, `manual_name_fr` varchar(255) NOT NULL, `manual_name_sp` varchar(255) NOT NULL, `upload` varchar(255) NOT NULL, `active` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tbl_manual` -- INSERT INTO `tbl_manual` (`id`, `manual_name`, `manual_name_fr`, `manual_name_sp`, `upload`, `active`) VALUES (12, '9107 Edge English', '', '', '4307_9107_English_Manual_2022.pdf', 0), (13, '9109 Edge English', '', '', '101_9109_English_Manual_-_2022_1_year.pdf', 0), (14, '9180 Oz English', '', '', '9342_9180_-_KLD4005_MANUAL_ETL_DEC2022_ENGL.pdf', 1), (15, '9185 Onyx English', '', '', '7946_9185_-_KLD7003SA_MANUAL_DEC2022_ENGL.pdf', 1), (17, '9248 Urban English', '', '', '9871_9248_English_Manual.pdf', 0), (18, '9250 -9251 Haven English', '', '', '7150_9250-9251_English_Manual_1_year_2022.pdf', 0), (19, '9295 Fabia English', '', '', '4021_9295_English_Manual_-_NOWindGlass_1_year.pdf', 0), (22, '9335 Tabletop English', '', '', '5245_9335-English_Instruction_Manual.pdf', 1), (61, 'Wind Guard A330/A310/Q400/B1900', '', '', '7453_WG_English_Manual_A310_A330_B1900_Q400.pdf', 1), (62, '', 'Wind Guard A330/A310/Q400/B1900', '', '6722_WG_French_Manual_A310_A330_B1900_Q400.pdf', 1), (64, '9795 Grange English', '', '', '3158_9795_English_Manual_2023.pdf', 1), (65, '', '9795 Grange Français', '', '1332_9795_French_Manual_2023.pdf', 1), (66, '', '', '9795 Grange Espanol', '1037_9795_Spanish_Manual_2023.pdf', 1), (70, '9510 Alpine English', '', '', '1739_9510_English_Manual_2023.pdf', 1), (71, '', '9510 Alpine Français', '', '3671_9510_French_Manual_2023.pdf', 1), (72, '', '', '9510 Alpine Espanol', '3691_9510_Spanish_Manual_2023.pdf', 1), (82, '8762 Woodland Bench English', '', '', '9351_8762_Woodland_Duo_Bench_Manual_EN.pdf', 1), (83, '', '8762 Banc Woodland Français', '', '8159_8762_Woodland_Duo_Bench_Manual_FR.pdf', 1), (84, '9581 Bolt English', '', '', '6816_9581-HF282301_IM_English_Manual_Bolt_Tabletop_Fire_Pit.pdf', 1), (85, '', '9581 Bolt Français', '', '3619_9581-HF282301_IM_French_Manual_Bolt_Tabletop_Fire_Pit.pdf', 1), (86, '9520, 9528 Euro English', '', '', '2985_9520-9528_IM_English_Euro_Fire_Pit.pdf', 1), (87, '', '9520, 9528 Euro Français', '', '9370_9520-9528_IM_French_Euro_Fire_Pit.pdf', 1), (88, '9158 Sterling English', '', '', '1678_9158_English_Manual.pdf', 1), (89, '', '9158 Sterling Français', '', '7486_9158_French_Manual.pdf', 1), (92, '9158 Sterling - English Wind Guard assembly', '', '', '1954_Wind_Guard_manual_for_item__9158_fr-en.pdf', 1), (93, '', '9158 Sterling - Ensemble pare-vent Français', '', '2871_Wind_Guard_manual_for_item__9158_fr-en.pdf', 1), (94, '', '9142-9145 Hearth -Ensemble pare-vent Français', '', '4574_Wind_Guard_manual_for_item__9142__9145_fr-en_v02.pdf', 1), (95, '9142-9145 Hearth - English Wind Guard assembly', '', '', '7323_Wind_Guard_manual_for_item__9142__9145_fr-en_v02.pdf', 1), (96, '9136 Terra English', '', '', '3980_9136_NS_English_Manual_2025_2_years_ol.pdf', 1), (97, '', '9136 Terra Français', '', '6530_9136_NS_French_Manual_2025_2_years_ol.pdf', 1), (98, '9147 Brava English', '', '', '3468_9147-FG_English_Manual_2025_no_battery_OL.pdf', 1), (99, '', '9147 Brava Français', '', '3083_9147-FG_French_Manual_2025_no_battery_OL.pdf', 0), (100, '', '', '9147 Brava Español', '804_9147-FG_Spanish_Manual_2025_no_battery_OL.pdf', 1), (101, '9521 Oak English', '', '', '7912_9521-FG_English_Manual_2025_no_battery.pdf', 1), (102, '', '9521 Oak Français', '', '2461_9521-FG_French_Manual_2025_no_battery.pdf', 1), (103, '', '', '9521 Oak Español', '5557_9521-FG_Spanish_Manual_2025_no_battery.pdf', 1), (104, '9515 Euro English', '', '', '7945_9515-FG_English_Manual_2025_no_battery_ol.pdf', 1), (105, '', '9515 Euro Français', '', '9505_9515-FG_French_Manual_2025_no_battery_ol.pdf', 1), (106, '', '', '9515 Euro Español', '1206_9515-FG_Spanish_Manual_2025_no_battery_ol.pdf', 1), (107, '9798-SET Nova Pit English', '', '', '2218_9798-SET-Nova_Fire_Pit_English_Manual-2025_no_battery.pdf', 1), (108, '', '9798-SET Nova Foyer Français', '', '3831_9798-SET-Nova_Fire_Pit_French_Manual-2025_no_battery.pdf', 1), (109, '', '', '9798-SET Nova fogata Español', '9534_9798-SET-Nova_Fire_Pit_Spanish_Manual-2025_no_battery.pdf', 1), (110, '9798-SET Nova Cover English', '', '', '5597_9798-SET_propane_tank_cover_English_Manual_2025.pdf', 1), (111, '', '9798-SET Nova couvercle Français', '', '9269_9798-SET_propane_tank_cover_French_Manual_2025.pdf', 1), (112, '', '', '9798-SET Nova Cubierta Español', '6819_9798-SET_propane_tank_cover_Spanish_Manual_2025.pdf', 1), (113, '9102 Boa English', '', '', '230_9102_English_Manual_2025.pdf', 1), (114, '', '9102 Boa Français', '', '3499_9102_French_Manual_2025.pdf', 1), (115, '', '', '9102 Boa Español', '5530_9102_Spanish_Manual_2025.pdf', 1), (116, '9103-9294 Serenity English', '', '', '7521_9103-9294_English_Manual_2025.pdf', 1), (117, '', '9103-9294 Serenity Français', '', '8400_9103-9294_French_Manual_2025.pdf', 1), (118, '', '', '9103-9294 Serenity Español', '1629_9103-9294_Spanish_Manual_2025.pdf', 1), (119, '9104-9718 Contemporary English', '', '', '3849_9104_9718_English_Manual_2025.pdf', 1), (120, '', '9104-9718 Contemporary Français', '', '9090_9104_9718__French_Manual_2025.pdf', 1), (121, '', '', '9104-9718 Contemporary Español', '9159_9104_9718__Spanish_Manual_2025.pdf', 1), (122, '9799 Pioneer English', '', '', '8713_9799_IM_English_Pioneer_Fire_Table_2025.pdf', 1), (123, '', '9799 Pioneer Français', '', '4904_9799_IM_French_Pioneer_Fire_Table_2025.pdf', 1), (124, '', '', '9799 Pioneer Español', '5747_9799_IM_Spanish_Pioneer_Fire_Table_2025.pdf', 1), (125, '9123-9124-9125 Oasis English', '', '', '4354_9123-9124-9125_English_Manual_2024.pdf', 1), (126, '', '9123-9124-9125 Oasis Français', '', '8386_9123-9124-9125_French_Manual_2024_NEW.pdf', 1), (127, '', '', '9123-9124-9125 Oasis Español', '5820_9123-9124-9125_Spanish_Manual_2024_NEW.pdf', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_manual` -- ALTER TABLE `tbl_manual` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_manual` -- ALTER TABLE `tbl_manual` MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;