-- 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 */;
