-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 14, 2026 at 05:00 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 7.2.31

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: `magnetech`
--

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

--
-- Table structure for table `about_content`
--

CREATE TABLE `about_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) NOT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `paragraph_1` text DEFAULT NULL,
  `paragraph_2` text DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `about_content`
--

INSERT INTO `about_content` (`id`, `section_key`, `heading`, `paragraph_1`, `paragraph_2`, `image_path`, `updated_at`) VALUES
(1, 'about_us', 'WHO WE ARE', 'Magnetech Elevators, an ISO 9001 :2015 certified company, has been established in the year 2001 in Ambattur, Chennai, which is a modern and professional elevators company with integration of designs, development, production, installation and maintenance. We take pride in introducing ourselves as Magnetech Elevators Pvt Ltd, a company dedicated itself to create innovations and Professional lifts in todays hi-tech world. We are Manufacturers of Passenger lift, Goods Lift, Dumbwaiter Lift, and Hospital Lift at Ambattur Industrial Estate Chennai. With global and local optimal combination, we can offer solutions of vertical and horizontal passenger transportation for customers. As a whole manufacturing, research and development, sales, maintenance services in one company, we will continue the industrial spirit and make all-round cooperation with customers for our innovative technology, good solutions of outstanding building and commercial passenger flow and high-quality products.', 'We whole heartedly provide the domestic and overseas users with the safe, superior, reliable, comfortable elevators, the satisfactory after-sale services. With a distribution of sales and service network spread all over the country, we are able to make a swift reaction and offer an all-round service, making placing order easily and Lift Sales and maintenance conveniently. We will take every customers expectation into consideration, and afford you the best service. In order to produce better products, we continuously improve skills and enhance high credit in order to satisfy our customer. Never giving up, we would like to go forward together with you, creating a bright tomorrow in the field of lift. There is a saying, To get the work well done, the tools must be sharpened first. Magnetech Elevators has well awarded of the deep meaning of this saying, we have invested and are going to continuously invest in all necessary equipments and facilities to maintain and enhance our production efficiency and product quality.', 'about_1786622146.jpg', '2026-08-13 12:01:15');

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `banner_id` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `img_uploaded` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `contact_info`
--

CREATE TABLE `contact_info` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) NOT NULL DEFAULT 'contact_us',
  `address` text DEFAULT NULL,
  `telephone` varchar(50) DEFAULT NULL,
  `mobile_1` varchar(50) DEFAULT NULL,
  `mobile_2` varchar(50) DEFAULT NULL,
  `email_1` varchar(100) DEFAULT NULL,
  `email_2` varchar(100) DEFAULT NULL,
  `opening_hours` varchar(255) DEFAULT NULL,
  `whatsapp_1` varchar(50) DEFAULT NULL,
  `whatsapp_2` varchar(50) DEFAULT NULL,
  `facebook_url` varchar(255) DEFAULT NULL,
  `instagram_url` varchar(255) DEFAULT NULL,
  `pinterest_url` varchar(255) DEFAULT NULL,
  `youtube_url` varchar(255) DEFAULT NULL,
  `google_map_iframe` longtext DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact_info`
--

INSERT INTO `contact_info` (`id`, `section_key`, `address`, `telephone`, `mobile_1`, `mobile_2`, `email_1`, `email_2`, `opening_hours`, `whatsapp_1`, `whatsapp_2`, `facebook_url`, `instagram_url`, `pinterest_url`, `youtube_url`, `google_map_iframe`, `updated_at`) VALUES
(1, 'contact_us', 'No: D27, 1st Street, Ambattur Industrial Estate South, Chennai- 600 058', '044-26250201', '+91-72990 12340', '+91-93807 31790', 'sales.magnetech@gmail.com', 'service.magnetech@gmail.com', 'Mon - Sat 09:00am To 07:00pm | Sunday: Off', '+91-7092457487', '+91-6381361322', 'https://www.facebook.com/people/Magnetech-Elevators-pvt-Ltd-Chennai/100064002161298/', 'https://www.instagram.com/magnetechelevatorspvt/', 'https://in.pinterest.com/salesmagnetech/', 'https://www.youtube.com/channel/UCyvT9e2C_ihvuhSSoBUGApg', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3911.2805627917246!2d80.1591947!3d13.100377100000001!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3a5263d02772c261%3A0x1acb4735749593c4!2sMAGNETECH%20ELEVATORS%20Pvt.%20Ltd.!5e1!3m2!1sen!2sin!4v1786625590150!5m2!1sen!2sin\" width=\"100%\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"strict-origin-when-cross-origin\"></iframe>', '2026-08-13 13:16:30');

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

--
-- Table structure for table `gallery_images`
--

CREATE TABLE `gallery_images` (
  `id` int(11) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery_images`
--

INSERT INTO `gallery_images` (`id`, `image_path`, `caption`, `display_order`, `created_at`) VALUES
(1, '1786685941_988.jpg', 'AVR (Jaswanth Nagar)', 0, '2026-08-14 05:39:01'),
(2, '1786685941_262.jpg', 'AVR (Jaswanth Nagar)', 0, '2026-08-14 05:39:01'),
(3, '1786685941_834.jpg', 'AVR (Jaswanth Nagar)', 0, '2026-08-14 05:39:01'),
(4, '1786685978_921.jpg', 'Mr. Mani Kundrathur', 0, '2026-08-14 05:39:38'),
(5, '1786685978_134.jpg', 'Mr. Mani Kundrathur', 0, '2026-08-14 05:39:38'),
(6, '1786685978_858.jpg', 'Mr. Mani Kundrathur', 0, '2026-08-14 05:39:38'),
(7, '1786686015_843.jpg', 'GS Hi Tech Gym', 0, '2026-08-14 05:40:15'),
(8, '1786686015_739.jpg', 'GS Hi Tech Gym', 0, '2026-08-14 05:40:15'),
(9, '1786686015_714.jpg', 'GS Hi Tech Gym', 0, '2026-08-14 05:40:15'),
(10, '1786686015_585.jpg', 'GS Hi Tech Gym', 0, '2026-08-14 05:40:15'),
(11, '1786686056_834.jpg', 'VMR Aishwariyam Mahal, Kundrathur', 0, '2026-08-14 05:40:56'),
(12, '1786686056_940.jpg', 'VMR Aishwariyam Mahal, Kundrathur', 0, '2026-08-14 05:40:56'),
(13, '1786686104_911.jpg', 'Mr. Gnanashekaran Keelkatalai', 0, '2026-08-14 05:41:44'),
(14, '1786686104_608.jpg', 'Mr. Gnanashekaran Keelkatalai', 0, '2026-08-14 05:41:44'),
(15, '1786686130_650.jpg', 'CS Hospital Maduravoyal', 0, '2026-08-14 05:42:10'),
(16, '1786686130_745.jpg', 'CS Hospital Maduravoyal', 0, '2026-08-14 05:42:10'),
(17, '1786686161_476.jpg', 'Muthu Hospital Perambur', 0, '2026-08-14 05:42:41'),
(18, '1786686161_418.jpg', 'Muthu Hospital Perambur', 0, '2026-08-14 05:42:41'),
(19, '1786686189_426.jpg', 'Mrs. Rajeswari', 0, '2026-08-14 05:43:09'),
(20, '1786686189_177.jpg', 'Mrs. Rajeswari', 0, '2026-08-14 05:43:09'),
(21, '1786686189_368.jpg', 'Mrs. Rajeswari', 0, '2026-08-14 05:43:09'),
(22, '1786686240_726.jpg', 'Shri Hari Foundation', 0, '2026-08-14 05:44:00'),
(23, '1786686240_319.jpg', 'Shri Hari Foundation', 0, '2026-08-14 05:44:00'),
(24, '1786686240_853.jpg', 'Shri Hari Foundation', 0, '2026-08-14 05:44:00'),
(25, '1786686284_642.jpg', 'Mr. Thirumoorthy', 0, '2026-08-14 05:44:44'),
(26, '1786686284_359.jpg', 'Mr. Thirumoorthy', 0, '2026-08-14 05:44:44'),
(27, '1786686284_677.jpg', 'Mr. Thirumoorthy', 0, '2026-08-14 05:44:44'),
(28, '1786686324_485.jpg', 'Murugan Hospital Kilpauk Garden', 0, '2026-08-14 05:45:24'),
(29, '1786686324_608.jpg', 'Murugan Hospital Kilpauk Garden', 0, '2026-08-14 05:45:24'),
(30, '1786686324_261.jpg', 'Murugan Hospital Kilpauk Garden', 0, '2026-08-14 05:45:24'),
(31, '1786686358_729.jpg', 'Rahavi Homes Velachery', 0, '2026-08-14 05:45:58'),
(32, '1786686358_146.jpg', 'Rahavi Homes Velachery', 0, '2026-08-14 05:45:58'),
(33, '1786686358_450.jpg', 'Rahavi Homes Velachery', 0, '2026-08-14 05:45:58'),
(34, '1786686406_805.jpg', 'Sai Primus Life Biotech Pvt Ltd Pondichery', 0, '2026-08-14 05:46:46'),
(35, '1786686406_712.jpg', 'Sai Primus Life Biotech Pvt Ltd Pondichery', 0, '2026-08-14 05:46:46'),
(36, '1786686406_571.jpg', 'Sai Primus Life Biotech Pvt Ltd Pondichery', 0, '2026-08-14 05:46:46'),
(37, '1786686471_833.jpg', 'Vishaka Homes', 0, '2026-08-14 05:47:51'),
(38, '1786686471_375.jpg', 'Vishaka Homes', 0, '2026-08-14 05:47:51'),
(39, '1786686471_117.jpg', 'Vishaka Homes', 0, '2026-08-14 05:47:51'),
(40, '1786686555_646.jpg', 'Vanaja Hospital Redhills', 0, '2026-08-14 05:49:15'),
(41, '1786686555_890.jpg', 'Vanaja Hospital Redhills', 0, '2026-08-14 05:49:15'),
(42, '1786686555_684.jpg', 'Vanaja Hospital Redhills', 0, '2026-08-14 05:49:15'),
(43, '1786686601_257.jpg', 'Pitha Hardwares', 0, '2026-08-14 05:50:01'),
(44, '1786686601_447.jpg', 'Pitha Hardwares', 0, '2026-08-14 05:50:01'),
(45, '1786686601_606.jpg', 'Pitha Hardwares', 0, '2026-08-14 05:50:01'),
(46, '1786686636_869.jpg', 'Sai Laxmi Builders Jafferkhanpet', 0, '2026-08-14 05:50:36'),
(47, '1786686636_524.jpg', 'Sai Laxmi Builders Jafferkhanpet', 0, '2026-08-14 05:50:36'),
(48, '1786686636_135.jpg', 'Sai Laxmi Builders Jafferkhanpet', 0, '2026-08-14 05:50:36'),
(49, '1786686671_220.jpg', 'Tender Cuts (Velachery)', 0, '2026-08-14 05:51:11'),
(50, '1786686671_159.jpg', 'Tender Cuts (Velachery)', 0, '2026-08-14 05:51:11'),
(51, '1786686671_553.jpg', 'Tender Cuts (Velachery)', 0, '2026-08-14 05:51:11');

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

--
-- Table structure for table `goods_lift_content`
--

CREATE TABLE `goods_lift_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'goods_lift',
  `main_image` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `goods_lift_content`
--

INSERT INTO `goods_lift_content` (`id`, `section_key`, `main_image`, `note`, `updated_at`) VALUES
(1, 'goods_lift', 'goods_1786689367.jpg', 'Note:- All dimensions in mille meters', '2026-08-14 06:36:07');

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

--
-- Table structure for table `goods_lift_dimensions`
--

CREATE TABLE `goods_lift_dimensions` (
  `id` int(11) NOT NULL,
  `loading_kg` varchar(50) DEFAULT NULL,
  `car_w` varchar(50) DEFAULT NULL,
  `car_d` varchar(50) DEFAULT NULL,
  `well_w` varchar(50) DEFAULT NULL,
  `well_d` varchar(50) DEFAULT NULL,
  `entrance` varchar(50) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `goods_lift_dimensions`
--

INSERT INTO `goods_lift_dimensions` (`id`, `loading_kg`, `car_w`, `car_d`, `well_w`, `well_d`, `entrance`, `display_order`) VALUES
(1, '500', '1100', '1200', '1900', '1500', '1100', 1),
(2, '1000', '1400', '1800', '2300', '2100', '1400', 2),
(3, '1500', '1700', '2000', '2600', '2300', '1700', 3),
(4, '2000', '1700', '2500', '2600', '2800', '1700', 4),
(5, '2500', '2000', '2500', '2900', '2800', '2000', 5),
(6, '3000', '2000', '3000', '2900', '3300', '2000', 6),
(7, '4000', '2500', '3000', '3400', '3300', '2500', 7),
(8, '5000', '2500', '3600', '3400', '3900', '2500', 8);

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

--
-- Table structure for table `goods_lift_tab_images`
--

CREATE TABLE `goods_lift_tab_images` (
  `id` int(11) NOT NULL,
  `tab_key` varchar(50) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` enum('standard','optional') DEFAULT 'standard',
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `goods_lift_tab_images`
--

INSERT INTO `goods_lift_tab_images` (`id`, `tab_key`, `image_path`, `caption`, `type`, `display_order`, `created_at`) VALUES
(1, 'cabin_colors', '1786688554_925.png', 'Blue', 'standard', 0, '2026-08-14 06:22:34'),
(2, 'cabin_colors', '1786688554_692.jpg', 'Gray', 'standard', 0, '2026-08-14 06:22:34'),
(3, 'cabin_colors', '1786688554_457.jpg', 'Ivory', 'standard', 0, '2026-08-14 06:22:34'),
(4, 'cabin_colors', '1786688554_599.png', 'Golden yellow', 'standard', 0, '2026-08-14 06:22:34'),
(5, 'cabin_colors', '1786688665_765.jpg', 'Siemens Gray', 'optional', 0, '2026-08-14 06:24:25'),
(6, 'cabin_colors', '1786688665_878.jpg', 'VIP Blue', 'optional', 0, '2026-08-14 06:24:25'),
(7, 'cabin_colors', '1786688665_174.jpg', 'Wooden Brown', 'optional', 0, '2026-08-14 06:24:25'),
(8, 'cabin_colors', '1786688665_533.jpg', 'SS Mirror', 'optional', 0, '2026-08-14 06:24:25'),
(9, 'cabin_colors', '1786688665_271.jpg', 'SS Hairline', 'optional', 0, '2026-08-14 06:24:25'),
(10, 'cabin_fan', '1786688862_275.jpg', '', 'standard', 0, '2026-08-14 06:27:42'),
(11, 'cabin_fan', '1786688862_212.jpg', '', 'optional', 0, '2026-08-14 06:27:42'),
(12, 'cabin_fan', '1786688862_278.jpg', '', 'optional', 0, '2026-08-14 06:27:42'),
(13, 'light', '1786688914_889.png', '', 'standard', 0, '2026-08-14 06:28:34'),
(14, 'light', '1786688914_453.jpg', 'Square Light', 'optional', 0, '2026-08-14 06:28:34'),
(15, 'light', '1786688914_899.jpg', 'Spot Light', 'optional', 0, '2026-08-14 06:28:34'),
(16, 'hand_rail', '1786688973_749.jpg', 'SS Hand Rail', 'standard', 0, '2026-08-14 06:29:33'),
(17, 'hand_rail', '1786688973_331.png', 'MS Hand Rail', 'standard', 0, '2026-08-14 06:29:33');

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

--
-- Table structure for table `home_about`
--

CREATE TABLE `home_about` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_about',
  `image_path` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_about`
--

INSERT INTO `home_about` (`id`, `section_key`, `image_path`, `description`, `updated_at`) VALUES
(1, 'home_about', 'about_1786707376.jpg', 'Magnetech Elevators Pvt Ltd® has been established in 2001 in Ambattur, Chennai. Magnetech Elevators is a modern and Professional elevator company with integration of design. development, production, installation and maintenance. Magnetech Elevators adopts manufacturing of Passenger Lift, Goods Lift. Hospital Lift, Dumbwaiter Lift, Food Lift. We have obtained a certificate of ISO 9001-2015 quality Management certification. Magnetech Elevators supplies different kinds of products with high quality at a reasonable price. We stick to the principle of \"Quality First, Service First, Safety First, with continuous improvement and innovation to meet the customers\" for the management and Zero defects, Zero Complaints as the quality objective.', '2026-08-14 11:36:16');

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

--
-- Table structure for table `home_banner_slides`
--

CREATE TABLE `home_banner_slides` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_banner',
  `image_path` varchar(255) DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_banner_slides`
--

INSERT INTO `home_banner_slides` (`id`, `section_key`, `image_path`, `heading`, `description`, `display_order`, `updated_at`) VALUES
(1, 'home_banner', 'banner_1786713902_317.jpg', 'Safety Instruction', 'Know your destination. Push elevator call button for the direction you want to go.', 1, '2026-08-14 13:25:02'),
(2, 'home_banner', 'banner_1786713902_149.jpg', 'Safety Instruction', 'Hold children and pets firmly', 2, '2026-08-14 13:25:02'),
(3, 'home_banner', 'banner_1786713902_590.jpg', 'Safety Instruction', 'Stay calm if you find yourself stuck in an elevator. Use the elevator\'s alarm button or emergency contact button to get help.', 3, '2026-08-14 13:25:02'),
(4, 'home_banner', 'banner_1786713902_535.jpg', 'Safety Instruction', 'Stay in a stuck elevator – Don\'t attempt to pry open the doors. \"The inside of an elevator is the safest place to be while the elevator is stopped,\" EESF states. Stay quiet and wait for safety instructions', 4, '2026-08-14 13:25:02'),
(5, 'home_banner', 'banner_1786713902_129.jpg', 'Safety Instruction', 'Use stair case in case of fire', 5, '2026-08-14 13:25:02'),
(6, 'home_banner', 'banner_1786713902_853.jpg', 'Safety Instruction', 'Don\'t engage in horseplay, rest on or push someone against a door', 6, '2026-08-14 13:25:02');

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

--
-- Table structure for table `home_choose`
--

CREATE TABLE `home_choose` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_choose',
  `title` varchar(255) DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `video_image` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_choose`
--

INSERT INTO `home_choose` (`id`, `section_key`, `title`, `heading`, `video_image`, `updated_at`) VALUES
(1, 'home_choose', 'WHY CHOOSE', 'So here are a few reasons why our valued customers choose us.', 'choose_1786708266.jpg', '2026-08-14 11:51:06');

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

--
-- Table structure for table `home_choose_blocks`
--

CREATE TABLE `home_choose_blocks` (
  `id` int(11) NOT NULL,
  `choose_id` int(11) DEFAULT NULL,
  `icon_number` varchar(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_choose_blocks`
--

INSERT INTO `home_choose_blocks` (`id`, `choose_id`, `icon_number`, `title`, `description`, `display_order`) VALUES
(1, 1, '01', 'Clean Design', 'Our product is user-friendly and is a blend of creativity, innovation and proficiency.', 1),
(2, 1, '02', 'Unbelievable options', 'Passengers convenience and comfort top our priority list.', 2),
(3, 1, '03', 'Affordable Prize', 'Reliability and afford ability are us. We design in accordance with your requirement to keep you moving safely yet sturdily.', 3),
(4, 1, '04', '24/7 Friendly Support', 'We take pride in our amicable team who earnestly deem in client satisfaction and delight.', 4);

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

--
-- Table structure for table `home_clients`
--

CREATE TABLE `home_clients` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_clients',
  `title` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_clients`
--

INSERT INTO `home_clients` (`id`, `section_key`, `title`, `updated_at`) VALUES
(1, 'home_clients', 'Our Client\'s', '2026-08-14 12:48:41');

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

--
-- Table structure for table `home_client_logos`
--

CREATE TABLE `home_client_logos` (
  `id` int(11) NOT NULL,
  `clients_id` int(11) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_client_logos`
--

INSERT INTO `home_client_logos` (`id`, `clients_id`, `image_path`, `link`, `display_order`) VALUES
(23, 1, 'client_1786711783_416.png', '#', 0),
(24, 1, 'client_1786711783_765.png', '#', 0),
(25, 1, 'client_1786711783_158.png', '#', 0),
(26, 1, 'client_1786711783_227.png', '#', 0),
(27, 1, 'client_1786711783_461.png', '#', 0),
(28, 1, 'client_1786711783_702.png', '#', 0),
(29, 1, 'client_1786711783_503.png', '#', 0),
(30, 1, 'client_1786711794_571.png', '#', 0),
(31, 1, 'client_1786711794_572.png', '#', 0),
(32, 1, 'client_1786711794_516.png', '#', 0),
(33, 1, 'client_1786711794_420.png', '#', 0);

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

--
-- Table structure for table `home_lifts`
--

CREATE TABLE `home_lifts` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_lifts',
  `title` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_lifts`
--

INSERT INTO `home_lifts` (`id`, `section_key`, `title`, `updated_at`) VALUES
(1, 'home_lifts', 'Lifts', '2026-08-14 12:12:12');

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

--
-- Table structure for table `home_lift_cards`
--

CREATE TABLE `home_lift_cards` (
  `id` int(11) NOT NULL,
  `lifts_id` int(11) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_lift_cards`
--

INSERT INTO `home_lift_cards` (`id`, `lifts_id`, `image_path`, `title`, `link`, `display_order`) VALUES
(1, 1, 'lift_1786709805_726.jpg', 'Machine Room', 'machine-room', 1),
(2, 1, 'lift_1786709805_607.jpg', 'Machine Room Less', 'machine-room-less', 2),
(3, 1, 'lift_1786709805_449.jpg', 'Passenger', 'passenger', 3),
(4, 1, 'lift_1786709805_325.jpg', 'Goods', 'goods', 4),
(5, 1, 'lift_1786709805_363.jpg', 'Dumb Waiter', 'dumb-waiter', 5),
(6, 1, 'lift_1786709805_849.jpg', 'Hospital', 'hospital', 6),
(7, 1, 'lift_1786709805_703.jpg', 'Hydraulic', 'hydraulic', 7);

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

--
-- Table structure for table `home_services`
--

CREATE TABLE `home_services` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_services',
  `title` varchar(255) DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_services`
--

INSERT INTO `home_services` (`id`, `section_key`, `title`, `heading`, `updated_at`) VALUES
(1, 'home_services', 'OUR SERVICES', 'We offer many services to progress!', '2026-08-14 11:55:09');

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

--
-- Table structure for table `home_service_cards`
--

CREATE TABLE `home_service_cards` (
  `id` int(11) NOT NULL,
  `services_id` int(11) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_service_cards`
--

INSERT INTO `home_service_cards` (`id`, `services_id`, `image_path`, `title`, `link`, `display_order`) VALUES
(1, 1, 'service_1786713048_707.jpg', 'New Lifts Installation', 'services.html', 1),
(2, 1, 'service_1786713048_371.jpg', 'Safety And Quality', 'services.html', 2),
(3, 1, 'service_1786713048_535.jpg', 'Maintenance', 'services.html', 3),
(4, 1, 'service_1786713048_580.jpg', 'Training and Engineering Support', 'services.html', 4);

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

--
-- Table structure for table `home_stats`
--

CREATE TABLE `home_stats` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_stats',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_stats`
--

INSERT INTO `home_stats` (`id`, `section_key`, `updated_at`) VALUES
(1, 'home_stats', '2026-08-14 12:04:33');

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

--
-- Table structure for table `home_stats_items`
--

CREATE TABLE `home_stats_items` (
  `id` int(11) NOT NULL,
  `stats_id` int(11) DEFAULT NULL,
  `icon_class` varchar(100) DEFAULT NULL,
  `count_number` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_stats_items`
--

INSERT INTO `home_stats_items` (`id`, `stats_id`, `icon_class`, `count_number`, `title`, `display_order`) VALUES
(1, 1, 'flaticon-badge', '400', 'Completed Projects', 1),
(2, 1, 'flaticon-team', '500', 'Clients', 2),
(3, 1, 'flaticon-user-1', '100', 'Experience Workers', 3),
(4, 1, 'flaticon-soccer-cup', '200', 'Total Awards', 4);

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

--
-- Table structure for table `home_testimonials`
--

CREATE TABLE `home_testimonials` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'home_testimonials',
  `title` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_testimonials`
--

INSERT INTO `home_testimonials` (`id`, `section_key`, `title`, `updated_at`) VALUES
(1, 'home_testimonials', 'Client\'s Reviews', '2026-08-14 12:32:34');

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

--
-- Table structure for table `home_testimonial_items`
--

CREATE TABLE `home_testimonial_items` (
  `id` int(11) NOT NULL,
  `testimonial_id` int(11) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `client_name` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_testimonial_items`
--

INSERT INTO `home_testimonial_items` (`id`, `testimonial_id`, `image_path`, `content`, `client_name`, `display_order`) VALUES
(1, 1, 'testimonial_1786712856_534.png', 'Magnetech Elavators, after long search we are luckly got to know. Excellent, professional approach, identifying and resolving lift issues and timely service by team headed by Mr.Prakasam really to be appreciated. Sure we will recommend for others, sure I trust we will get the same kind of service upcoming years. Good luck team...', 'Srini MD', 1),
(2, 1, 'testimonial_1786712856_668.png', 'Good service. Timely support and nice staff. Very responsive. Keep up the good work.', 'Ramkumar Dakshinamoorthy', 2),
(3, 1, 'testimonial_1786712856_346.png', 'Customer centric service, professional engineers to attend the repairs. They take care of our Lift. Overall good service and response.', 'Kalai Selvan', 3),
(4, 1, 'testimonial_1786712856_180.png', 'Best service quality, timely service', 'Dhinesh Kumar', 4),
(5, 1, 'testimonial_1786712856_804.png', 'Excellent and on-time service by the team. Handed over the lift to us as they promised.', 'Raj Anand', 5),
(6, 1, 'testimonial_1786712856_403.png', 'Good quality. Great service. Only company with its own manufacturing facility in Ambattur.', 'Muthu Raman', 6),
(7, 1, 'testimonial_1786712856_565.png', 'Good service timely super', 'Sundar Aaron', 7),
(8, 1, 'testimonial_1786712856_470.png', 'Good customer handling and service at reasonable rates.', 'RPS Prakash', 8),
(9, 1, 'testimonial_1786712856_797.png', 'Good service quick response', 'Santhakumar K', 9),
(10, 1, 'testimonial_1786712856_730.png', 'Most beautiful design comfortable service', 'Sasi Kumar', 10);

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

--
-- Table structure for table `hospital_lift_content`
--

CREATE TABLE `hospital_lift_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'hospital_lift',
  `main_image` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hospital_lift_content`
--

INSERT INTO `hospital_lift_content` (`id`, `section_key`, `main_image`, `note`, `updated_at`) VALUES
(1, 'hospital_lift', 'hospital_1786698628.png', 'Note:- All dimensions in mille meters', '2026-08-14 09:10:28');

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

--
-- Table structure for table `hospital_lift_dimensions`
--

CREATE TABLE `hospital_lift_dimensions` (
  `id` int(11) NOT NULL,
  `person` varchar(50) DEFAULT NULL,
  `load_kg` varchar(50) DEFAULT NULL,
  `car_w` varchar(50) DEFAULT NULL,
  `car_d` varchar(50) DEFAULT NULL,
  `well_w` varchar(50) DEFAULT NULL,
  `well_d` varchar(50) DEFAULT NULL,
  `entrance` varchar(50) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hospital_lift_dimensions`
--

INSERT INTO `hospital_lift_dimensions` (`id`, `person`, `load_kg`, `car_w`, `car_d`, `well_w`, `well_d`, `entrance`, `display_order`) VALUES
(1, '15', '1020', '1000', '2400', '1800', '3000', '800', 1),
(2, '20', '1360', '1300', '2400', '2200', '3000', '1200', 2),
(3, '26', '1768', '1600', '2400', '2400', '3000', '1200', 3);

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

--
-- Table structure for table `hospital_lift_tab_images`
--

CREATE TABLE `hospital_lift_tab_images` (
  `id` int(11) NOT NULL,
  `tab_key` varchar(50) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` enum('standard','optional') DEFAULT 'standard',
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hospital_lift_tab_images`
--

INSERT INTO `hospital_lift_tab_images` (`id`, `tab_key`, `image_path`, `caption`, `type`, `display_order`, `created_at`) VALUES
(1, 'cabin_colors', '1786698659_307.png', 'Blue', 'standard', 0, '2026-08-14 09:10:59'),
(2, 'cabin_colors', '1786698659_618.jpg', 'Gray', 'standard', 0, '2026-08-14 09:10:59'),
(3, 'cabin_colors', '1786698659_982.jpg', 'Ivory', 'standard', 0, '2026-08-14 09:10:59'),
(4, 'cabin_colors', '1786698659_274.png', 'Golden yellow', 'standard', 0, '2026-08-14 09:10:59'),
(5, 'cabin_colors', '1786698699_364.jpg', 'Siemens Gray', 'optional', 0, '2026-08-14 09:11:39'),
(6, 'cabin_colors', '1786698699_969.jpg', 'VIP Blue', 'optional', 0, '2026-08-14 09:11:39'),
(7, 'cabin_colors', '1786698699_412.jpg', 'Wooden Brown', 'optional', 0, '2026-08-14 09:11:39'),
(8, 'cabin_colors', '1786698699_887.jpg', 'SS Mirror', 'optional', 0, '2026-08-14 09:11:39'),
(9, 'cabin_colors', '1786698699_111.jpg', 'SS Hairline', 'optional', 0, '2026-08-14 09:11:39'),
(10, 'cabin_fan', '1786698786_910.jpg', NULL, 'standard', 0, '2026-08-14 09:13:06'),
(11, 'cabin_fan', '1786698786_452.jpg', '', 'optional', 0, '2026-08-14 09:13:06'),
(12, 'cabin_fan', '1786698786_585.jpg', '', 'optional', 0, '2026-08-14 09:13:06'),
(13, 'light', '1786698820_992.png', NULL, 'standard', 0, '2026-08-14 09:13:40'),
(14, 'light', '1786698820_562.jpg', 'Square Light', 'optional', 0, '2026-08-14 09:13:40'),
(15, 'light', '1786698820_639.jpg', 'Spot Light', 'optional', 0, '2026-08-14 09:13:40'),
(16, 'hand_rail', '1786698864_699.jpg', 'SS Hand Rail', 'standard', 0, '2026-08-14 09:14:24'),
(17, 'hand_rail', '1786698864_193.png', 'MS Hand Rail', 'standard', 0, '2026-08-14 09:14:24');

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

--
-- Table structure for table `hydraulic_lift_content`
--

CREATE TABLE `hydraulic_lift_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'hydraulic_lift',
  `main_image` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `door_open_size` varchar(255) DEFAULT NULL,
  `shaft_size` varchar(255) DEFAULT NULL,
  `car_size` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hydraulic_lift_content`
--

INSERT INTO `hydraulic_lift_content` (`id`, `section_key`, `main_image`, `description`, `door_open_size`, `shaft_size`, `car_size`, `updated_at`) VALUES
(1, 'hydraulic_lift', 'hydraulic_1786701536.jpg', 'Hydraulic elevators are elevators which are powered by a piston that travels inside a cylinder. An electric motor pumps hydraulic oil into the cylinder to move the piston. The piston smoothly lifts the elevator cab. Electrical valves control the release of the oil for a gentle descent', '600 – 1500 MM', '1000 W * 1500 D (Min.) – 2000 W * 2400 D (Max.)', '850 W * 900 D (Min.) – 1800 W * 1800 D (Max.)', '2026-08-14 09:58:56');

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

--
-- Table structure for table `hydraulic_lift_tab_images`
--

CREATE TABLE `hydraulic_lift_tab_images` (
  `id` int(11) NOT NULL,
  `tab_key` varchar(50) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` enum('standard','optional') DEFAULT 'standard',
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hydraulic_lift_tab_images`
--

INSERT INTO `hydraulic_lift_tab_images` (`id`, `tab_key`, `image_path`, `caption`, `type`, `display_order`, `created_at`) VALUES
(1, 'cabin_colors', '1786701597_404.png', NULL, 'standard', 0, '2026-08-14 09:59:57'),
(2, 'cabin_colors', '1786701597_919.jpg', NULL, 'standard', 0, '2026-08-14 09:59:57'),
(3, 'cabin_colors', '1786701597_586.jpg', NULL, 'standard', 0, '2026-08-14 09:59:57'),
(4, 'cabin_colors', '1786701597_300.png', NULL, 'standard', 0, '2026-08-14 09:59:57'),
(5, 'cabin_colors', '1786701645_538.jpg', 'Siemens Gray', 'optional', 0, '2026-08-14 10:00:45'),
(6, 'cabin_colors', '1786701645_674.jpg', 'VIP Blue', 'optional', 0, '2026-08-14 10:00:45'),
(7, 'cabin_colors', '1786701645_385.jpg', 'Wooden Brown', 'optional', 0, '2026-08-14 10:00:45'),
(8, 'cabin_colors', '1786701645_531.jpg', 'SS Mirror', 'optional', 0, '2026-08-14 10:00:45'),
(9, 'cabin_colors', '1786701645_751.jpg', 'SS Hairline', 'optional', 0, '2026-08-14 10:00:45'),
(10, 'fall_celings', '1786701797_343.jpg', NULL, 'standard', 0, '2026-08-14 10:03:17'),
(11, 'fall_celings', '1786701797_986.jpg', '', 'optional', 0, '2026-08-14 10:03:17'),
(12, 'fall_celings', '1786701797_865.jpg', '', 'optional', 0, '2026-08-14 10:03:17'),
(13, 'fall_celings', '1786701797_976.jpg', '', 'optional', 0, '2026-08-14 10:03:17'),
(14, 'fall_celings', '1786701797_443.jpg', '', 'optional', 0, '2026-08-14 10:03:17'),
(15, 'flooring', '1786701869_983.jpg', NULL, 'standard', 0, '2026-08-14 10:04:29'),
(16, 'flooring', '1786701869_435.jpg', NULL, 'standard', 0, '2026-08-14 10:04:29'),
(17, 'flooring', '1786701869_311.jpg', '', 'optional', 0, '2026-08-14 10:04:29'),
(18, 'flooring', '1786701869_524.jpg', '', 'optional', 0, '2026-08-14 10:04:29'),
(19, 'flooring', '1786701869_242.jpg', '', 'optional', 0, '2026-08-14 10:04:29'),
(20, 'flooring', '1786701869_290.jpg', '', 'optional', 0, '2026-08-14 10:04:29'),
(21, 'cabin_fan', '1786701995_110.jpg', NULL, 'standard', 0, '2026-08-14 10:06:35'),
(22, 'cabin_fan', '1786701995_395.jpg', '', 'optional', 0, '2026-08-14 10:06:35'),
(23, 'cabin_fan', '1786701995_841.jpg', '', 'optional', 0, '2026-08-14 10:06:35'),
(24, 'light', '1786702052_217.png', NULL, 'standard', 0, '2026-08-14 10:07:32'),
(25, 'light', '1786702052_840.jpg', 'Square Light', 'optional', 0, '2026-08-14 10:07:32'),
(26, 'light', '1786702052_280.jpg', 'Spot Light', 'optional', 0, '2026-08-14 10:07:32'),
(27, 'cop_lop', '1786702106_955.png', NULL, 'standard', 0, '2026-08-14 10:08:26'),
(28, 'cop_lop', '1786702106_390.jpg', '', 'optional', 0, '2026-08-14 10:08:26'),
(29, 'cop_lop', '1786702106_489.jpg', '', 'optional', 0, '2026-08-14 10:08:26'),
(30, 'hand_rail', '1786702165_450.jpg', 'SS Hand Rail', 'standard', 0, '2026-08-14 10:09:25'),
(31, 'hand_rail', '1786702165_845.png', 'MS Hand Rail', 'standard', 0, '2026-08-14 10:09:25'),
(32, 'display', '1786702196_711.jpg', NULL, 'standard', 0, '2026-08-14 10:09:56'),
(33, 'display', '1786702196_226.jpg', NULL, 'standard', 0, '2026-08-14 10:09:56'),
(34, 'display', '1786702196_365.png', 'LCD Display', 'optional', 0, '2026-08-14 10:09:56'),
(35, 'manual_door', '1786702239_390.jpg', 'Manual Telescopic (Sliding) Door', 'standard', 0, '2026-08-14 10:10:39'),
(36, 'manual_door', '1786702239_380.png', 'Manual Swing Door', 'standard', 0, '2026-08-14 10:10:39'),
(37, 'manual_door', '1786702239_684.jpg', 'Manual IFG Door', 'standard', 0, '2026-08-14 10:10:39'),
(38, 'manual_door', '1786702239_675.jpg', 'Manual Collapsible Door', 'standard', 0, '2026-08-14 10:10:39'),
(39, 'automatic_door', '1786702285_390.jpg', 'Automatic Center Opening Glass Door', 'standard', 0, '2026-08-14 10:11:25'),
(40, 'automatic_door', '1786702285_590.jpg', 'Automatic Center Opening of Vision Door', 'standard', 0, '2026-08-14 10:11:25'),
(41, 'automatic_door', '1786702285_293.jpg', 'Automatic side opening telescopic door', 'standard', 0, '2026-08-14 10:11:25'),
(42, 'automatic_door', '1786702285_870.jpg', 'Automatic side opening telescopic Glass door', 'standard', 0, '2026-08-14 10:11:25'),
(43, 'ss_cabin', '1786702345_869.jpg', NULL, 'standard', 0, '2026-08-14 10:12:25'),
(44, 'ss_cabin', '1786702345_143.jpg', NULL, 'standard', 0, '2026-08-14 10:12:25'),
(45, 'ss_cabin', '1786702345_658.jpg', NULL, 'standard', 0, '2026-08-14 10:12:25'),
(46, 'ss_cabin', '1786702345_100.jpg', NULL, 'standard', 0, '2026-08-14 10:12:25'),
(47, 'ms_cabin', '1786702377_196.jpg', NULL, 'standard', 0, '2026-08-14 10:12:57'),
(48, 'ms_cabin', '1786702377_367.jpg', NULL, 'standard', 0, '2026-08-14 10:12:57'),
(49, 'ms_cabin', '1786702377_453.jpg', NULL, 'standard', 0, '2026-08-14 10:12:57'),
(50, 'ms_cabin', '1786702377_684.jpg', NULL, 'standard', 0, '2026-08-14 10:12:57');

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

--
-- Table structure for table `lift_content`
--

CREATE TABLE `lift_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'lift_details',
  `main_image` varchar(255) DEFAULT NULL,
  `capacity` varchar(255) DEFAULT NULL,
  `drive` text DEFAULT NULL,
  `speed` varchar(255) DEFAULT NULL,
  `max_floors` varchar(255) DEFAULT NULL,
  `max_travel_height` varchar(255) DEFAULT NULL,
  `door_type` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lift_content`
--

INSERT INTO `lift_content` (`id`, `section_key`, `main_image`, `capacity`, `drive`, `speed`, `max_floors`, `max_travel_height`, `door_type`, `updated_at`) VALUES
(1, 'lift_details', 'main_1786632986.jpg', '4 to 30 Passenger', 'Close Loop Selective Collective Controller with VVVF Drive and ARD<br>Open Loop Down Collective Controller with VVVF Drive and ARD', '0.6,0.63 m/s & 1 m/s', '20 Floors', '60mts', 'Automatic centre opening door<br>Automatic side opening telescopic door<br>Manually operated swing door<br>Manually operated telescopic sliding door<br>Semi Automatic side telescopic sliding door', '2026-08-13 14:56:26');

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

--
-- Table structure for table `lift_tab_images`
--

CREATE TABLE `lift_tab_images` (
  `id` int(11) NOT NULL,
  `tab_key` varchar(50) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` enum('standard','optional') DEFAULT 'standard',
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lift_tab_images`
--

INSERT INTO `lift_tab_images` (`id`, `tab_key`, `image_path`, `caption`, `type`, `display_order`, `created_at`) VALUES
(1, 'cabin_colors', '1786633018_888.png', NULL, 'standard', 0, '2026-08-13 14:56:58'),
(2, 'cabin_colors', '1786633018_657.jpg', NULL, 'standard', 0, '2026-08-13 14:56:58'),
(3, 'cabin_colors', '1786633018_540.jpg', NULL, 'standard', 0, '2026-08-13 14:56:58'),
(4, 'cabin_colors', '1786633018_660.png', NULL, 'standard', 0, '2026-08-13 14:56:58'),
(5, 'cabin_colors', '1786633058_228.jpg', '', 'optional', 0, '2026-08-13 14:57:38'),
(6, 'cabin_colors', '1786633058_618.jpg', '', 'optional', 0, '2026-08-13 14:57:38'),
(7, 'cabin_colors', '1786633058_940.jpg', '', 'optional', 0, '2026-08-13 14:57:38'),
(8, 'cabin_colors', '1786633058_213.jpg', '', 'optional', 0, '2026-08-13 14:57:38'),
(9, 'cabin_colors', '1786633058_447.jpg', '', 'optional', 0, '2026-08-13 14:57:38'),
(10, 'fall_celings', '1786633131_337.jpg', '', 'standard', 0, '2026-08-13 14:58:51'),
(11, 'fall_celings', '1786633155_743.jpg', '', 'optional', 0, '2026-08-13 14:59:15'),
(12, 'fall_celings', '1786633155_161.jpg', '', 'optional', 0, '2026-08-13 14:59:15'),
(13, 'fall_celings', '1786633155_125.jpg', '', 'optional', 0, '2026-08-13 14:59:15'),
(14, 'fall_celings', '1786633155_544.jpg', '', 'optional', 0, '2026-08-13 14:59:15'),
(15, 'flooring', '1786633206_539.jpg', 'Button type rubber Mat', 'standard', 0, '2026-08-13 15:00:06'),
(16, 'flooring', '1786633206_446.jpg', 'Marble type rubber Mat', 'standard', 0, '2026-08-13 15:00:06'),
(17, 'flooring', '1786633253_932.jpg', '', 'optional', 0, '2026-08-13 15:00:53'),
(18, 'flooring', '1786633253_420.jpg', '', 'optional', 0, '2026-08-13 15:00:53'),
(19, 'flooring', '1786633253_103.jpg', '', 'optional', 0, '2026-08-13 15:00:53'),
(20, 'flooring', '1786633253_775.jpg', '', 'optional', 0, '2026-08-13 15:00:53'),
(21, 'cabin_fan', '1786633295_363.jpg', '', 'standard', 0, '2026-08-13 15:01:35'),
(22, 'cabin_fan', '1786633318_766.jpg', '', 'optional', 0, '2026-08-13 15:01:58'),
(23, 'cabin_fan', '1786633318_616.jpg', '', 'optional', 0, '2026-08-13 15:01:58'),
(24, 'light', '1786633842_656.png', NULL, 'standard', 0, '2026-08-13 15:10:42'),
(25, 'light', '1786633842_941.jpg', '', 'optional', 0, '2026-08-13 15:10:42'),
(26, 'light', '1786633842_750.jpg', '', 'optional', 0, '2026-08-13 15:10:42'),
(27, 'cop_lop', '1786633887_535.png', NULL, 'standard', 0, '2026-08-13 15:11:27'),
(28, 'cop_lop', '1786633905_606.jpg', '', 'optional', 0, '2026-08-13 15:11:45'),
(29, 'cop_lop', '1786633905_738.jpg', '', 'optional', 0, '2026-08-13 15:11:45'),
(30, 'hand_rail', '1786633958_850.jpg', 'SS Hand Rail', 'standard', 0, '2026-08-13 15:12:38'),
(31, 'hand_rail', '1786633958_514.png', 'MS Hand Rail', 'standard', 0, '2026-08-13 15:12:38'),
(32, 'display', '1786634008_798.jpg', NULL, 'standard', 0, '2026-08-13 15:13:28'),
(33, 'display', '1786634008_398.jpg', NULL, 'standard', 0, '2026-08-13 15:13:28'),
(34, 'display', '1786634029_670.png', 'LCD Display', 'optional', 0, '2026-08-13 15:13:49'),
(35, 'manual_door', '1786635661_952.jpg', 'Manual Telescopic (Sliding) Door', 'standard', 0, '2026-08-13 15:41:01'),
(36, 'manual_door', '1786635661_159.png', 'Manual Swing Door', 'standard', 0, '2026-08-13 15:41:01'),
(37, 'manual_door', '1786635661_927.jpg', 'Manual IFG Door', 'standard', 0, '2026-08-13 15:41:01'),
(38, 'manual_door', '1786635661_630.jpg', 'Manual Collapsible Door', 'standard', 0, '2026-08-13 15:41:01'),
(39, 'automatic_door', '1786635727_823.jpg', 'Automatic Center Opening Glass Door', 'standard', 0, '2026-08-13 15:42:07'),
(40, 'automatic_door', '1786635727_392.jpg', 'Automatic Center Opening of Vision Door', 'standard', 0, '2026-08-13 15:42:07'),
(41, 'automatic_door', '1786635727_208.jpg', 'Automatic side opening telescopic door', 'standard', 0, '2026-08-13 15:42:07'),
(42, 'automatic_door', '1786635727_458.jpg', 'Automatic side opening telescopic Glass door', 'standard', 0, '2026-08-13 15:42:07'),
(43, 'ss_cabin', '1786635800_939.jpg', NULL, 'standard', 0, '2026-08-13 15:43:20'),
(44, 'ss_cabin', '1786635800_655.jpg', NULL, 'standard', 0, '2026-08-13 15:43:20'),
(45, 'ss_cabin', '1786635800_883.jpg', NULL, 'standard', 0, '2026-08-13 15:43:20'),
(46, 'ss_cabin', '1786635800_221.jpg', NULL, 'standard', 0, '2026-08-13 15:43:20'),
(47, 'ms_cabin', '1786635832_133.jpg', NULL, 'standard', 0, '2026-08-13 15:43:52'),
(48, 'ms_cabin', '1786635832_964.jpg', NULL, 'standard', 0, '2026-08-13 15:43:52'),
(49, 'ms_cabin', '1786635832_518.jpg', NULL, 'standard', 0, '2026-08-13 15:43:52'),
(50, 'ms_cabin', '1786635832_163.jpg', NULL, 'standard', 0, '2026-08-13 15:43:52');

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

--
-- Table structure for table `manufacturing_images`
--

CREATE TABLE `manufacturing_images` (
  `id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `sub_section_id` int(11) DEFAULT 0,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `manufacturing_images`
--

INSERT INTO `manufacturing_images` (`id`, `section_id`, `sub_section_id`, `image_path`, `caption`, `display_order`, `created_at`) VALUES
(1, 11, 11, '1786628135_260.jpg', NULL, 0, '2026-08-13 13:35:35'),
(2, 11, 11, '1786628135_956.jpg', NULL, 0, '2026-08-13 13:35:35'),
(3, 11, 11, '1786628135_920.jpg', NULL, 0, '2026-08-13 13:35:35'),
(4, 11, 11, '1786628135_300.jpg', NULL, 0, '2026-08-13 13:35:35'),
(5, 11, 11, '1786628135_818.jpg', NULL, 0, '2026-08-13 13:35:35'),
(6, 11, 11, '1786628135_985.jpg', NULL, 0, '2026-08-13 13:35:35'),
(7, 11, 11, '1786628135_521.jpg', NULL, 0, '2026-08-13 13:35:35'),
(8, 11, 11, '1786628135_896.jpg', NULL, 0, '2026-08-13 13:35:35'),
(9, 12, 12, '1786628193_367.jpg', NULL, 0, '2026-08-13 13:36:33'),
(10, 12, 12, '1786628193_980.jpg', NULL, 0, '2026-08-13 13:36:33'),
(11, 12, 12, '1786628193_759.jpg', NULL, 0, '2026-08-13 13:36:33'),
(12, 12, 12, '1786628193_720.jpg', NULL, 0, '2026-08-13 13:36:33'),
(13, 13, 13, '1786628228_119.jpg', NULL, 0, '2026-08-13 13:37:08'),
(14, 13, 13, '1786628228_852.jpg', NULL, 0, '2026-08-13 13:37:08'),
(15, 13, 13, '1786628228_736.jpg', NULL, 0, '2026-08-13 13:37:08'),
(16, 14, 14, '1786628248_135.jpg', NULL, 0, '2026-08-13 13:37:28'),
(17, 15, 15, '1786628321_371.jpg', NULL, 0, '2026-08-13 13:38:41'),
(18, 16, 16, '1786628346_415.jpg', NULL, 0, '2026-08-13 13:39:06'),
(19, 16, 16, '1786628357_477.jpg', NULL, 0, '2026-08-13 13:39:17'),
(20, 2, 0, '1786628388_808.jpg', NULL, 0, '2026-08-13 13:39:48'),
(21, 3, 0, '1786628420_260.jpg', NULL, 0, '2026-08-13 13:40:20'),
(22, 3, 0, '1786628420_776.jpg', NULL, 0, '2026-08-13 13:40:20'),
(23, 3, 0, '1786628420_557.jpg', NULL, 0, '2026-08-13 13:40:20'),
(24, 4, 0, '1786628452_552.jpg', NULL, 0, '2026-08-13 13:40:52'),
(25, 4, 0, '1786628459_513.jpg', NULL, 0, '2026-08-13 13:40:59'),
(26, 5, 0, '1786628480_902.jpg', NULL, 0, '2026-08-13 13:41:20'),
(27, 5, 0, '1786628480_877.jpg', NULL, 0, '2026-08-13 13:41:20'),
(28, 17, 17, '1786628512_540.jpg', 'Traction Sling', 0, '2026-08-13 13:41:52'),
(29, 17, 17, '1786628512_277.jpg', 'MRL Sing Top Roping', 0, '2026-08-13 13:41:52'),
(30, 17, 17, '1786628512_979.jpg', 'MRL Sling Set Bottom Roping', 0, '2026-08-13 13:41:52'),
(31, 7, 0, '1786628576_436.jpg', NULL, 0, '2026-08-13 13:42:56'),
(32, 7, 0, '1786628576_399.jpg', NULL, 0, '2026-08-13 13:42:56'),
(33, 20, 20, '1786628604_103.jpg', 'SS - Side Opening', 0, '2026-08-13 13:43:24'),
(34, 20, 20, '1786628604_694.png', 'SS - Center Opening', 0, '2026-08-13 13:43:24'),
(35, 21, 21, '1786628665_280.png', 'SS - Side Opening', 0, '2026-08-13 13:44:25'),
(36, 21, 21, '1786628665_444.jpg', 'SS - Center Opening', 0, '2026-08-13 13:44:25'),
(37, 22, 22, '1786628764_695.jpg', 'MS –Swing Door', 0, '2026-08-13 13:46:04'),
(38, 22, 22, '1786628764_603.jpg', 'MS –Swing Door', 0, '2026-08-13 13:46:04'),
(39, 22, 22, '1786628817_708.png', 'SS –Swing Door', 0, '2026-08-13 13:46:57'),
(40, 22, 22, '1786628817_725.jpg', 'SS –Swing Door', 0, '2026-08-13 13:46:57'),
(41, 23, 23, '1786628894_387.jpg', 'MS – Manual Sliding Door Set', 0, '2026-08-13 13:48:14'),
(42, 23, 23, '1786628894_785.jpg', 'MS – Manual Sliding Door Set', 0, '2026-08-13 13:48:14'),
(43, 23, 23, '1786628895_524.jpg', 'SS – Manual Sliding Door Set', 0, '2026-08-13 13:48:15'),
(45, 24, 24, '1786629035_526.jpg', NULL, 0, '2026-08-13 13:50:35'),
(46, 24, 24, '1786629035_148.jpg', NULL, 0, '2026-08-13 13:50:35'),
(47, 24, 24, '1786629035_839.jpg', NULL, 0, '2026-08-13 13:50:35'),
(48, 25, 25, '1786629086_822.png', NULL, 0, '2026-08-13 13:51:26'),
(49, 25, 25, '1786629086_231.jpg', NULL, 0, '2026-08-13 13:51:26'),
(50, 26, 26, '1786629120_382.jpg', NULL, 0, '2026-08-13 13:52:00'),
(51, 26, 26, '1786629120_617.jpg', NULL, 0, '2026-08-13 13:52:00');

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

--
-- Table structure for table `manufacturing_sections`
--

CREATE TABLE `manufacturing_sections` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `parent_id` int(11) DEFAULT 0,
  `display_order` int(11) DEFAULT 0,
  `is_tab` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `manufacturing_sections`
--

INSERT INTO `manufacturing_sections` (`id`, `section_key`, `title`, `parent_id`, `display_order`, `is_tab`, `created_at`, `updated_at`) VALUES
(1, 'brackets', 'Brackets', 0, 1, 1, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(2, 'guide_clip', 'Guide Clip', 0, 2, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(3, 'divetor_wheel', 'Divetor Wheel', 0, 3, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(4, 'safety_block', 'Safety Block', 0, 4, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(5, 'buffer_spring', 'Buffer Spring', 0, 5, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(6, 'sling_set', 'Sling Set', 0, 6, 1, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(7, 'filler_weight', 'Filler Weight', 0, 7, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(8, 'auto_door_set', 'Auto Door Set', 0, 8, 1, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(9, 'manual_door_set', 'Manual Door Set', 0, 9, 1, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(10, 'glass_door_set', 'Glass Door Set', 0, 10, 1, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(11, 'car_base', 'Car Base & Clit Brackets', 1, 1, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(12, 'cwt_base', 'CWT Base & Clit Brackets', 1, 2, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(13, 'entrance_brackets', 'Entrance Brackets Top & Bottom', 1, 3, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(14, 'combination_brackets', 'Combination Brackets', 1, 4, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(15, 'limit_switch_bracket', 'Limit Switch Bracket', 1, 5, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(16, 'read_switch_bracket', 'Read Switch Bracket', 1, 6, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(17, 'car_sling', 'Car Sling', 6, 1, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(18, 'cwt_sling', 'CWT Sling', 6, 2, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(19, 'hydraulic_sling', 'Hydraulic Sling', 6, 3, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(20, 'ms_entrance', 'MS Entrance & Door Set', 8, 1, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(21, 'ss_entrance', 'SS Entrance & Door Set', 8, 2, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(22, 'manual_swing', 'Swing Door Set', 9, 1, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(23, 'manual_sliding', 'Sliding Door Set', 9, 2, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(24, 'manual_ifg', 'IFG & Collapsible Door Set', 9, 3, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(25, 'glass_full', 'Full', 10, 1, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10'),
(26, 'glass_half', 'Half', 10, 2, 0, '2026-08-13 13:29:10', '2026-08-13 13:29:10');

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

--
-- Table structure for table `mrl_lift_content`
--

CREATE TABLE `mrl_lift_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'mrl_lift',
  `main_image` varchar(255) DEFAULT NULL,
  `capacity` varchar(255) DEFAULT NULL,
  `drive` text DEFAULT NULL,
  `speed` varchar(255) DEFAULT NULL,
  `max_floors` varchar(255) DEFAULT NULL,
  `max_travel_height` varchar(255) DEFAULT NULL,
  `door_type` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mrl_lift_content`
--

INSERT INTO `mrl_lift_content` (`id`, `section_key`, `main_image`, `capacity`, `drive`, `speed`, `max_floors`, `max_travel_height`, `door_type`, `updated_at`) VALUES
(1, 'mrl_lift', 'mrl_1786695717.jpg', '4,8,10,15,& 20 Passenger', 'Close Loop Selective Collective Controller with VVVF Drive', '1.0,1.5,1.75 & 2 m/s', '15 Floors', '40mts', 'Automatic centre opening door<br>Automatic side opening telescopic door<br>Manually operated swing door<br>Manually operated telescopic sliding door<br>Semi Automatic side telescopic sliding door', '2026-08-14 08:21:57');

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

--
-- Table structure for table `mrl_lift_tab_images`
--

CREATE TABLE `mrl_lift_tab_images` (
  `id` int(11) NOT NULL,
  `tab_key` varchar(50) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` enum('standard','optional') DEFAULT 'standard',
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mrl_lift_tab_images`
--

INSERT INTO `mrl_lift_tab_images` (`id`, `tab_key`, `image_path`, `caption`, `type`, `display_order`, `created_at`) VALUES
(1, 'cabin_colors', '1786695752_706.png', 'Blue', 'standard', 0, '2026-08-14 08:22:32'),
(2, 'cabin_colors', '1786695752_891.jpg', 'Gray', 'standard', 0, '2026-08-14 08:22:32'),
(3, 'cabin_colors', '1786695752_129.jpg', 'Ivory', 'standard', 0, '2026-08-14 08:22:32'),
(4, 'cabin_colors', '1786695752_677.png', 'Golden yellow', 'standard', 0, '2026-08-14 08:22:32'),
(5, 'cabin_colors', '1786695825_354.jpg', NULL, 'standard', 0, '2026-08-14 08:23:45'),
(6, 'cabin_colors', '1786695825_101.jpg', 'VIP Blue', 'optional', 0, '2026-08-14 08:23:45'),
(7, 'cabin_colors', '1786695825_724.jpg', 'Wooden Brown', 'optional', 0, '2026-08-14 08:23:45'),
(8, 'cabin_colors', '1786695825_960.jpg', 'SS Mirror', 'optional', 0, '2026-08-14 08:23:45'),
(9, 'cabin_colors', '1786695825_711.jpg', 'SS Hairline', 'optional', 0, '2026-08-14 08:23:45'),
(10, 'fall_celings', '1786696109_994.jpg', NULL, 'standard', 0, '2026-08-14 08:28:29'),
(11, 'fall_celings', '1786696130_327.jpg', '', 'optional', 0, '2026-08-14 08:28:50'),
(12, 'fall_celings', '1786696130_376.jpg', '', 'optional', 0, '2026-08-14 08:28:50'),
(13, 'fall_celings', '1786696131_830.jpg', '', 'optional', 0, '2026-08-14 08:28:51'),
(14, 'fall_celings', '1786696131_780.jpg', '', 'optional', 0, '2026-08-14 08:28:51'),
(15, 'flooring', '1786696196_947.jpg', NULL, 'standard', 0, '2026-08-14 08:29:56'),
(16, 'flooring', '1786696196_939.jpg', NULL, 'standard', 0, '2026-08-14 08:29:56'),
(17, 'flooring', '1786696224_868.jpg', '', 'optional', 0, '2026-08-14 08:30:24'),
(18, 'flooring', '1786696224_605.jpg', '', 'optional', 0, '2026-08-14 08:30:24'),
(19, 'flooring', '1786696224_460.jpg', '', 'optional', 0, '2026-08-14 08:30:24'),
(20, 'flooring', '1786696224_302.jpg', '', 'optional', 0, '2026-08-14 08:30:24'),
(21, 'cabin_fan', '1786696287_664.jpg', NULL, 'standard', 0, '2026-08-14 08:31:27'),
(22, 'cabin_fan', '1786696305_447.jpg', '', 'optional', 0, '2026-08-14 08:31:45'),
(23, 'cabin_fan', '1786696305_105.jpg', '', 'optional', 0, '2026-08-14 08:31:45'),
(24, 'light', '1786696364_578.png', NULL, 'standard', 0, '2026-08-14 08:32:44'),
(25, 'light', '1786696364_681.jpg', 'Square Light', 'optional', 0, '2026-08-14 08:32:44'),
(26, 'light', '1786696364_607.jpg', 'Spot Light', 'optional', 0, '2026-08-14 08:32:44'),
(27, 'cop_lop', '1786696433_784.png', NULL, 'standard', 0, '2026-08-14 08:33:53'),
(28, 'cop_lop', '1786696433_362.jpg', '', 'optional', 0, '2026-08-14 08:33:53'),
(29, 'cop_lop', '1786696433_140.jpg', '', 'optional', 0, '2026-08-14 08:33:53'),
(30, 'hand_rail', '1786696500_673.jpg', NULL, 'standard', 0, '2026-08-14 08:35:00'),
(31, 'hand_rail', '1786696500_854.png', NULL, 'standard', 0, '2026-08-14 08:35:00'),
(32, 'display', '1786696524_781.jpg', NULL, 'standard', 0, '2026-08-14 08:35:24'),
(33, 'display', '1786696524_279.jpg', NULL, 'standard', 0, '2026-08-14 08:35:24'),
(34, 'display', '1786696524_554.png', 'LCD Display', 'optional', 0, '2026-08-14 08:35:24'),
(35, 'manual_door', '1786696578_683.jpg', 'Manual Telescopic (Sliding) Door', 'standard', 0, '2026-08-14 08:36:18'),
(36, 'manual_door', '1786696578_510.png', 'Manual Swing Door', 'standard', 0, '2026-08-14 08:36:18'),
(37, 'manual_door', '1786696578_666.jpg', 'Manual IFG Door', 'standard', 0, '2026-08-14 08:36:18'),
(38, 'manual_door', '1786696578_110.jpg', 'Manual Collapsible Door', 'standard', 0, '2026-08-14 08:36:18'),
(39, 'automatic_door', '1786696787_556.jpg', 'Automatic Center Opening Glass Door', 'standard', 0, '2026-08-14 08:39:47'),
(40, 'automatic_door', '1786696787_943.jpg', 'Automatic Center Opening of Vision Door', 'standard', 0, '2026-08-14 08:39:47'),
(41, 'automatic_door', '1786696787_923.jpg', 'Automatic side opening telescopic door', 'standard', 0, '2026-08-14 08:39:47'),
(42, 'automatic_door', '1786696787_767.jpg', 'Automatic side opening telescopic Glass door', 'standard', 0, '2026-08-14 08:39:47'),
(43, 'ss_cabin', '1786696884_483.jpg', NULL, 'standard', 0, '2026-08-14 08:41:24'),
(44, 'ss_cabin', '1786696884_192.jpg', NULL, 'standard', 0, '2026-08-14 08:41:24'),
(45, 'ss_cabin', '1786696884_796.jpg', NULL, 'standard', 0, '2026-08-14 08:41:24'),
(46, 'ss_cabin', '1786696884_666.jpg', NULL, 'standard', 0, '2026-08-14 08:41:24'),
(47, 'ms_cabin', '1786696921_845.jpg', NULL, 'standard', 0, '2026-08-14 08:42:01'),
(48, 'ms_cabin', '1786696921_961.jpg', NULL, 'standard', 0, '2026-08-14 08:42:01'),
(49, 'ms_cabin', '1786696921_380.jpg', NULL, 'standard', 0, '2026-08-14 08:42:01'),
(50, 'ms_cabin', '1786696921_277.jpg', NULL, 'standard', 0, '2026-08-14 08:42:01');

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

--
-- Table structure for table `passenger_lift_content`
--

CREATE TABLE `passenger_lift_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'passenger_lift',
  `main_image` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `passenger_lift_content`
--

INSERT INTO `passenger_lift_content` (`id`, `section_key`, `main_image`, `note`, `updated_at`) VALUES
(1, 'passenger_lift', 'passenger_1786697275.jpg', 'Note:- All dimensions in mille meters', '2026-08-14 08:47:55');

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

--
-- Table structure for table `passenger_lift_dimensions`
--

CREATE TABLE `passenger_lift_dimensions` (
  `id` int(11) NOT NULL,
  `person` varchar(50) DEFAULT NULL,
  `load_kg` varchar(50) DEFAULT NULL,
  `car_w` varchar(50) DEFAULT NULL,
  `car_d` varchar(50) DEFAULT NULL,
  `well_w` varchar(50) DEFAULT NULL,
  `well_d` varchar(50) DEFAULT NULL,
  `entrance` varchar(50) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `passenger_lift_dimensions`
--

INSERT INTO `passenger_lift_dimensions` (`id`, `person`, `load_kg`, `car_w`, `car_d`, `well_w`, `well_d`, `entrance`, `display_order`) VALUES
(1, '4', '272', '1100', '700', '1900', '1300', '700', 1),
(2, '6', '408', '1100', '1000', '1900', '1700', '700', 2),
(3, '8', '544', '1300', '1100', '1900', '1900', '800', 3),
(4, '10', '680', '1300', '1350', '1900', '2100', '800', 4),
(5, '13', '884', '2000', '1100', '2500', '1900', '900', 5),
(6, '16', '1088', '2000', '1300', '2500', '2100', '1000', 6);

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

--
-- Table structure for table `passenger_lift_tab_images`
--

CREATE TABLE `passenger_lift_tab_images` (
  `id` int(11) NOT NULL,
  `tab_key` varchar(50) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` enum('standard','optional') DEFAULT 'standard',
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `passenger_lift_tab_images`
--

INSERT INTO `passenger_lift_tab_images` (`id`, `tab_key`, `image_path`, `caption`, `type`, `display_order`, `created_at`) VALUES
(1, 'cabin_colors', '1786697262_465.png', 'Blue', 'standard', 0, '2026-08-14 08:47:42'),
(2, 'cabin_colors', '1786697262_121.jpg', 'Gray', 'standard', 0, '2026-08-14 08:47:42'),
(3, 'cabin_colors', '1786697262_962.jpg', 'Ivory', 'standard', 0, '2026-08-14 08:47:42'),
(4, 'cabin_colors', '1786697262_257.png', 'Golden yellow', 'standard', 0, '2026-08-14 08:47:42'),
(5, 'cabin_colors', '1786697324_186.jpg', 'Siemens Gray', 'optional', 0, '2026-08-14 08:48:44'),
(6, 'cabin_colors', '1786697324_682.jpg', 'VIP Blue', 'optional', 0, '2026-08-14 08:48:44'),
(7, 'cabin_colors', '1786697324_983.jpg', 'Wooden Brown', 'optional', 0, '2026-08-14 08:48:44'),
(8, 'cabin_colors', '1786697324_305.jpg', 'SS Mirror', 'optional', 0, '2026-08-14 08:48:44'),
(9, 'cabin_colors', '1786697324_218.jpg', 'SS Hairline', 'optional', 0, '2026-08-14 08:48:44'),
(10, 'fall_celings', '1786697424_261.jpg', '', 'standard', 0, '2026-08-14 08:50:24'),
(11, 'fall_celings', '1786697446_740.jpg', '', 'optional', 0, '2026-08-14 08:50:46'),
(12, 'fall_celings', '1786697446_422.jpg', '', 'optional', 0, '2026-08-14 08:50:46'),
(13, 'fall_celings', '1786697446_403.jpg', '', 'optional', 0, '2026-08-14 08:50:46'),
(14, 'fall_celings', '1786697446_149.jpg', '', 'optional', 0, '2026-08-14 08:50:46'),
(15, 'flooring', '1786697489_872.jpg', 'Button type rubber Mat', 'standard', 0, '2026-08-14 08:51:29'),
(16, 'flooring', '1786697489_164.jpg', 'Marble type rubber Mat', 'standard', 0, '2026-08-14 08:51:29'),
(17, 'flooring', '1786697530_927.jpg', '', 'optional', 0, '2026-08-14 08:52:10'),
(18, 'flooring', '1786697530_379.jpg', '', 'optional', 0, '2026-08-14 08:52:10'),
(19, 'flooring', '1786697530_714.jpg', '', 'optional', 0, '2026-08-14 08:52:10'),
(20, 'flooring', '1786697530_902.jpg', '', 'optional', 0, '2026-08-14 08:52:10'),
(21, 'cabin_fan', '1786697571_975.jpg', NULL, 'standard', 0, '2026-08-14 08:52:51'),
(22, 'cabin_fan', '1786697571_725.jpg', '', 'optional', 0, '2026-08-14 08:52:51'),
(23, 'cabin_fan', '1786697571_113.jpg', '', 'optional', 0, '2026-08-14 08:52:51'),
(24, 'light', '1786697650_926.png', '', 'standard', 0, '2026-08-14 08:54:10'),
(25, 'light', '1786697650_260.jpg', 'Square Light', 'optional', 0, '2026-08-14 08:54:10'),
(26, 'light', '1786697650_760.jpg', 'Spot Light', 'optional', 0, '2026-08-14 08:54:10'),
(27, 'cop_lop', '1786697691_737.png', '', 'standard', 0, '2026-08-14 08:54:51'),
(28, 'cop_lop', '1786697691_207.jpg', '', 'optional', 0, '2026-08-14 08:54:51'),
(29, 'cop_lop', '1786697692_481.jpg', '', 'optional', 0, '2026-08-14 08:54:52'),
(30, 'hand_rail', '1786697728_982.jpg', 'SS Hand Rail', 'standard', 0, '2026-08-14 08:55:28'),
(31, 'hand_rail', '1786697728_247.png', 'MS Hand Rail', 'standard', 0, '2026-08-14 08:55:28'),
(32, 'display', '1786697762_236.jpg', NULL, 'standard', 0, '2026-08-14 08:56:02'),
(33, 'display', '1786697762_717.jpg', NULL, 'standard', 0, '2026-08-14 08:56:02'),
(34, 'display', '1786697762_246.png', 'LCD Display', 'optional', 0, '2026-08-14 08:56:02'),
(35, 'manual_door', '1786697811_846.jpg', 'Manual Telescopic (Sliding) Door', 'standard', 0, '2026-08-14 08:56:51'),
(36, 'manual_door', '1786697811_870.png', 'Manual Swing Door', 'standard', 0, '2026-08-14 08:56:51'),
(37, 'manual_door', '1786697811_459.jpg', 'Manual IFG Door', 'standard', 0, '2026-08-14 08:56:51'),
(38, 'manual_door', '1786697811_930.jpg', 'Manual Collapsible Door', 'standard', 0, '2026-08-14 08:56:51'),
(39, 'automatic_door', '1786697898_849.jpg', 'Automatic Center Opening Glass Door', 'standard', 0, '2026-08-14 08:58:18'),
(40, 'automatic_door', '1786697898_985.jpg', 'Automatic Center Opening of Vision Door', 'standard', 0, '2026-08-14 08:58:18'),
(41, 'automatic_door', '1786697898_866.jpg', 'Automatic side opening telescopic door', 'standard', 0, '2026-08-14 08:58:18'),
(42, 'automatic_door', '1786697898_737.jpg', 'Automatic side opening telescopic Glass door', 'standard', 0, '2026-08-14 08:58:18'),
(43, 'ss_cabin', '1786697984_100.jpg', NULL, 'standard', 0, '2026-08-14 08:59:44'),
(44, 'ss_cabin', '1786697985_497.jpg', NULL, 'standard', 0, '2026-08-14 08:59:45'),
(45, 'ss_cabin', '1786697985_260.jpg', NULL, 'standard', 0, '2026-08-14 08:59:45'),
(46, 'ss_cabin', '1786697985_860.jpg', NULL, 'standard', 0, '2026-08-14 08:59:45'),
(47, 'ms_cabin', '1786698011_185.jpg', NULL, 'standard', 0, '2026-08-14 09:00:11'),
(48, 'ms_cabin', '1786698011_508.jpg', NULL, 'standard', 0, '2026-08-14 09:00:11'),
(49, 'ms_cabin', '1786698011_620.jpg', NULL, 'standard', 0, '2026-08-14 09:00:11'),
(50, 'ms_cabin', '1786698011_930.jpg', NULL, 'standard', 0, '2026-08-14 09:00:11');

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

--
-- Table structure for table `services_sections`
--

CREATE TABLE `services_sections` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `list_items` text DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services_sections`
--

INSERT INTO `services_sections` (`id`, `section_key`, `title`, `content`, `list_items`, `image_path`, `display_order`, `updated_at`) VALUES
(1, 'new_lift_installation', 'New Lift Installation', '<p>Our company possesses specialization in successfully carrying out the installation of elevators for new and existing buildings at a cost-effective price by maintaining all necessary international safety standards. We use the Technology for a strategic approach to focus on adding value to the field of management.</p>', 'Inbuilt Stabilizer,Automatic Low Volt Adjusting Mode ( Up To 330V),Inverter Based ARD With Battery Preventer ( Increase Battery Life Time),Automatic Sleep Mode Timer With Frequency Converter For Power Saving Up To 40%,3 Level Safety Circuit Provided To Prevent The Over Travel,High Level Accuracy Program For Smooth & Jerk Free Stopping', 'new_lift_installation_1786623543.jpg', 1, '2026-08-13 12:30:35'),
(2, 'safety_and_quality', 'Safety and Quality', '<p>Our Quality Assurance Department thoroughly inspects equipment at each installation stage as well as before commissioning to ensure compliance with high quality assurance standards.</p>', '', 'safety_and_quality_1786623561.jpg', 2, '2026-08-13 12:19:21'),
(3, 'lift_maintenance', 'Lift Maintenance', '<p>With vast industrial expertise and affluent knowledge of this arena, we are readily instrumental in providing world class Maintenance Service. As per the detailed desires of our clients, these presented services are broadly cherished. In addition to this, these could be altered as per the varying desires of our clients.</p><p>Our maintenance staff will visit lift/s, strictly once in a month for servicing and technicians will attend the breakdown calls. Our lift Engineers will visit and inspect the lift/s once in a six months for safe and smooth operation of lift\'s.</p><p>In the light of the above information we cordially invite you to enjoy our services than any one you have experienced in the past or present.</p>', '', 'lift_maintenance_1786625301.jpg', 3, '2026-08-13 12:48:21'),
(4, 'training_and_support', 'Training and Engineering Support', '<p>Our in-house and global training programs conducted locally provide its engineers with the latest skill and technology in installation, Quality Assurance and maintenance. Special diagnostic tools and maintenance tools developed by Magnetech elevators enhance the level of safety and performance. These massive training and engineering support system is realizing global class excellent quality services.</p>', '', 'training_and_support_1786623617.png', 4, '2026-08-13 12:20:17');

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

--
-- Table structure for table `service_lift_content`
--

CREATE TABLE `service_lift_content` (
  `id` int(11) NOT NULL,
  `section_key` varchar(50) DEFAULT 'service_lift',
  `main_image` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_lift_content`
--

INSERT INTO `service_lift_content` (`id`, `section_key`, `main_image`, `note`, `updated_at`) VALUES
(1, 'service_lift', 'service_1786698252.jpg', 'Note:- All dimensions in mille meters', '2026-08-14 09:04:12');

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

--
-- Table structure for table `service_lift_dimensions`
--

CREATE TABLE `service_lift_dimensions` (
  `id` int(11) NOT NULL,
  `load_kg` varchar(50) DEFAULT NULL,
  `opening_w` varchar(50) DEFAULT NULL,
  `car_w` varchar(50) DEFAULT NULL,
  `car_d` varchar(50) DEFAULT NULL,
  `well_w` varchar(50) DEFAULT NULL,
  `well_d` varchar(50) DEFAULT NULL,
  `entrance` varchar(50) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_lift_dimensions`
--

INSERT INTO `service_lift_dimensions` (`id`, `load_kg`, `opening_w`, `car_w`, `car_d`, `well_w`, `well_d`, `entrance`, `display_order`) VALUES
(1, '100', '700', '700', '800', '1200', '900', '700', 1),
(2, '150', '800', '800', '900', '1300', '1000', '800', 2),
(3, '200', '900', '900', '1000', '1400', '1100', '900', 3),
(4, '250', '1000', '1000', '1200', '1500', '1200', '1000', 4);

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

--
-- Table structure for table `service_lift_tab_images`
--

CREATE TABLE `service_lift_tab_images` (
  `id` int(11) NOT NULL,
  `tab_key` varchar(50) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` enum('standard','optional') DEFAULT 'standard',
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_lift_tab_images`
--

INSERT INTO `service_lift_tab_images` (`id`, `tab_key`, `image_path`, `caption`, `type`, `display_order`, `created_at`) VALUES
(1, 'cabin_colors', '1786698269_319.png', 'Blue', 'standard', 0, '2026-08-14 09:04:29'),
(2, 'cabin_colors', '1786698269_628.jpg', 'Gray', 'standard', 0, '2026-08-14 09:04:29'),
(3, 'cabin_colors', '1786698269_358.jpg', 'Ivory', 'standard', 0, '2026-08-14 09:04:29'),
(4, 'cabin_colors', '1786698269_749.png', 'Golden yellow', 'standard', 0, '2026-08-14 09:04:29'),
(5, 'cabin_colors', '1786698305_751.jpg', 'Siemens Gray', 'optional', 0, '2026-08-14 09:05:05'),
(6, 'cabin_colors', '1786698305_888.jpg', 'VIP Blue', 'optional', 0, '2026-08-14 09:05:05'),
(7, 'cabin_colors', '1786698305_403.jpg', 'Wooden Brown', 'optional', 0, '2026-08-14 09:05:05'),
(8, 'cabin_colors', '1786698305_465.jpg', 'SS Mirror', 'optional', 0, '2026-08-14 09:05:05'),
(9, 'cabin_colors', '1786698305_219.jpg', 'SS Hairline', 'optional', 0, '2026-08-14 09:05:05'),
(10, 'cabin_fan', '1786698372_381.jpg', NULL, 'standard', 0, '2026-08-14 09:06:12'),
(11, 'cabin_fan', '1786698372_639.jpg', '', 'optional', 0, '2026-08-14 09:06:12'),
(12, 'cabin_fan', '1786698372_232.jpg', '', 'optional', 0, '2026-08-14 09:06:12'),
(13, 'light', '1786698402_329.png', NULL, 'standard', 0, '2026-08-14 09:06:42'),
(14, 'light', '1786698402_653.jpg', 'Square Light', 'optional', 0, '2026-08-14 09:06:42'),
(15, 'light', '1786698402_559.jpg', 'Spot Light', 'optional', 0, '2026-08-14 09:06:42');

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int(11) NOT NULL,
  `staff_id` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `pwd` varchar(100) NOT NULL,
  `api_key` varchar(100) NOT NULL,
  `active_status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `staff_id`, `name`, `email`, `pwd`, `api_key`, `active_status`) VALUES
(1, 'S001', 'admin', 'admin@email.com', '5v169bGuD2X0', 'SZ0CKrmAPHtXnU3wzDhPsUyjvj83HUQ6', 0);

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

--
-- Table structure for table `video_gallery`
--

CREATE TABLE `video_gallery` (
  `id` int(11) NOT NULL,
  `thumbnail_path` varchar(255) NOT NULL,
  `video_url` varchar(500) NOT NULL,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `video_gallery`
--

INSERT INTO `video_gallery` (`id`, `thumbnail_path`, `video_url`, `display_order`, `created_at`) VALUES
(1, '1786687881_749.jpg', 'https://www.youtube.com/watch?v=O3l8CUN2nkA', 0, '2026-08-14 06:11:21'),
(2, '1786687889_735.jpg', 'https://www.youtube.com/watch?v=rfarcZXYrqA&', 0, '2026-08-14 06:11:29'),
(3, '1786687929_423.jpg', 'https://www.youtube.com/watch?v=VFOqVPdLMac', 0, '2026-08-14 06:12:09');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_content`
--
ALTER TABLE `about_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `section_key` (`section_key`);

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

--
-- Indexes for table `contact_info`
--
ALTER TABLE `contact_info`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `section_key` (`section_key`);

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

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

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

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

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

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

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

--
-- Indexes for table `home_choose_blocks`
--
ALTER TABLE `home_choose_blocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `choose_id` (`choose_id`);

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

--
-- Indexes for table `home_client_logos`
--
ALTER TABLE `home_client_logos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clients_id` (`clients_id`);

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

--
-- Indexes for table `home_lift_cards`
--
ALTER TABLE `home_lift_cards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lifts_id` (`lifts_id`);

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

--
-- Indexes for table `home_service_cards`
--
ALTER TABLE `home_service_cards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_id` (`services_id`);

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

--
-- Indexes for table `home_stats_items`
--
ALTER TABLE `home_stats_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stats_id` (`stats_id`);

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

--
-- Indexes for table `home_testimonial_items`
--
ALTER TABLE `home_testimonial_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `testimonial_id` (`testimonial_id`);

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

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

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

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

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

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

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

--
-- Indexes for table `manufacturing_images`
--
ALTER TABLE `manufacturing_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `section_id` (`section_id`);

--
-- Indexes for table `manufacturing_sections`
--
ALTER TABLE `manufacturing_sections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `section_key` (`section_key`);

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

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

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

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

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

--
-- Indexes for table `services_sections`
--
ALTER TABLE `services_sections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `section_key` (`section_key`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `home_choose_blocks`
--
ALTER TABLE `home_choose_blocks`
  ADD CONSTRAINT `home_choose_blocks_ibfk_1` FOREIGN KEY (`choose_id`) REFERENCES `home_choose` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `home_client_logos`
--
ALTER TABLE `home_client_logos`
  ADD CONSTRAINT `home_client_logos_ibfk_1` FOREIGN KEY (`clients_id`) REFERENCES `home_clients` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `home_lift_cards`
--
ALTER TABLE `home_lift_cards`
  ADD CONSTRAINT `home_lift_cards_ibfk_1` FOREIGN KEY (`lifts_id`) REFERENCES `home_lifts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `home_service_cards`
--
ALTER TABLE `home_service_cards`
  ADD CONSTRAINT `home_service_cards_ibfk_1` FOREIGN KEY (`services_id`) REFERENCES `home_services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `home_stats_items`
--
ALTER TABLE `home_stats_items`
  ADD CONSTRAINT `home_stats_items_ibfk_1` FOREIGN KEY (`stats_id`) REFERENCES `home_stats` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `home_testimonial_items`
--
ALTER TABLE `home_testimonial_items`
  ADD CONSTRAINT `home_testimonial_items_ibfk_1` FOREIGN KEY (`testimonial_id`) REFERENCES `home_testimonials` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `manufacturing_images`
--
ALTER TABLE `manufacturing_images`
  ADD CONSTRAINT `manufacturing_images_ibfk_1` FOREIGN KEY (`section_id`) REFERENCES `manufacturing_sections` (`id`) ON DELETE CASCADE;
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 */;