Server : LiteSpeed System : Linux in-mum-web1112.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u451330669 ( 451330669) PHP Version : 8.2.27 Disable Function : NONE Directory : /home/u451330669/domains/thedeepenterprise.com/public_html/ |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Apr 26, 2025 at 05:24 AM -- Server version: 10.11.10-MariaDB-log -- PHP Version: 7.2.34 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: `u451330669_thedeepenterpr` -- -- -------------------------------------------------------- -- -- Table structure for table `about` -- CREATE TABLE `about` ( `id` int(11) NOT NULL, `about` text NOT NULL, `image` text NOT NULL, `short_desc` text NOT NULL, `description` text NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `about` -- INSERT INTO `about` (`id`, `about`, `image`, `short_desc`, `description`, `status`) VALUES (1, 'About Us', '414434096_Red Simple S Letter Brand Logo.jpg', '<p style=\"text-align: justify;\">At <strong>Deep Enterprise</strong>, we are committed to excellence in the field of plastic machinery manufacturing. Based in Vatva, Ahmedabad, we have established ourselves as a trusted name by consistently delivering high-performance machinery for the plastic extrusion industry.</p>\r\n\r\n<p style=\"text-align: justify;\">Founded by <strong>Mr. Dilip Prajapati</strong>, our company is built on a foundation of innovation, quality, and customer satisfaction. With years of experience and deep technical knowledge, we design and manufacture a wide range of precision-engineered machines including:</p>', '<ul>\r\n <li>\r\n <p>Haul-Off Machines</p>\r\n </li>\r\n <li>\r\n <p>Pipe Tube Cutter Machines</p>\r\n </li>\r\n <li>\r\n <p>Vacuum Calibration Tanks</p>\r\n </li>\r\n <li>\r\n <p>Spray Cooling Tanks</p>\r\n </li>\r\n <li>\r\n <p>Tilting Machines</p>\r\n </li>\r\n <li>\r\n <p>PVC Die Heads</p>\r\n </li>\r\n</ul>\r\n\r\n<p>Our focus is on developing reliable and efficient equipment that meets the evolving needs of our clients across India and beyond. Every machine we build reflects our commitment to durability, performance, and value.</p>\r\n\r\n<p>At Deep Enterprise, we don’t just build machines — we build trust.</p>', 1); -- -------------------------------------------------------- -- -- Table structure for table `admin_users` -- CREATE TABLE `admin_users` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `role` int(11) NOT NULL, `email` varchar(50) NOT NULL, `mobile` varchar(50) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admin_users` -- INSERT INTO `admin_users` (`id`, `username`, `password`, `role`, `email`, `mobile`, `status`) VALUES (1, 'thedeepenterprise', '81ff57f14e9c0671919184b8896f5fb3', 0, '', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `banner` -- CREATE TABLE `banner` ( `id` int(11) NOT NULL, `banner` text DEFAULT NULL, `image` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `banner` -- INSERT INTO `banner` (`id`, `banner`, `image`, `status`) VALUES (1, 'Deep Enterprise.', '946656038_banner4.png', 1), (4, 'Deep Enterprise', '479292521_fiest.jpg', 1); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL, `categories` varchar(255) NOT NULL, `image` text NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `categories`, `image`, `status`) VALUES (3, 'Product', '569300609_epoxy-flooring.jpg', 1); -- -------------------------------------------------------- -- -- Table structure for table `firstbanner` -- CREATE TABLE `firstbanner` ( `id` int(11) NOT NULL, `firstbanner` text NOT NULL, `image` text NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `firstbanner` -- INSERT INTO `firstbanner` (`id`, `firstbanner`, `image`, `status`) VALUES (1, 'Rainbow', '893234737_images (1).png', 1), (2, 'mirchi', '518245120_Miraj_Group_Logo.png', 1), (3, 'tngersoll', '485287318_Ingersoll-Rand-logo.png', 1), (4, 'cletza', '702069711_cletza-lifescience-logo.webp', 1), (5, 'barugard', '643194009_logo-min-min.jpg', 1), (6, 'micons', '982929699_images (4).png', 1); -- -------------------------------------------------------- -- -- Table structure for table `gallary` -- CREATE TABLE `gallary` ( `id` int(11) NOT NULL, `gallary` text NOT NULL, `image` text NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `gallary` -- INSERT INTO `gallary` (`id`, `gallary`, `image`, `status`) VALUES (9, 'Painting Service', '177341082_WhatsApp Image 2024-11-16 at 10.01.52 AM.jpeg', 1), (10, '', '882022041_WhatsApp Image 2024-11-16 at 10.04.06 AM (1).jpeg', 1), (11, '', '265907587_WhatsApp Image 2024-11-16 at 10.04.06 AM (2).jpeg', 1), (12, '', '548128175_WhatsApp Image 2024-11-16 at 10.04.06 AM.jpeg', 1), (13, '', '563199277_WhatsApp Image 2024-11-16 at 10.04.05 AM (1).jpeg', 1), (14, '', '909291669_WhatsApp Image 2024-11-16 at 10.04.05 AM.jpeg', 1); -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `id` int(11) NOT NULL, `categories_id` int(11) NOT NULL, `seller_id` int(11) NOT NULL, `sub_categories_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `mrp` float NOT NULL, `price` float NOT NULL, `qty` int(11) NOT NULL, `image` varchar(255) NOT NULL, `short_desc` varchar(2000) NOT NULL, `description` text NOT NULL, `best_seller` int(11) NOT NULL, `meta_title` varchar(2000) NOT NULL, `meta_desc` varchar(2000) NOT NULL, `meta_keyword` varchar(2000) NOT NULL, `added_by` int(11) NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `product` -- INSERT INTO `product` (`id`, `categories_id`, `seller_id`, `sub_categories_id`, `name`, `mrp`, `price`, `qty`, `image`, `short_desc`, `description`, `best_seller`, `meta_title`, `meta_desc`, `meta_keyword`, `added_by`, `status`) VALUES (1, 3, 0, 0, 'Pipe Socket Machine', 0, 0, 0, '731668284_13.jpg', '', '', 0, '', '', '', 0, 1), (2, 3, 0, 0, 'SWR Socket Machine', 0, 0, 0, '900557553_12.jpg', '', '', 0, '', '', '', 0, 1), (5, 3, 0, 0, 'Pvc Die Head', 0, 0, 0, '729643031_6.jpg', '', '', 0, '', '', '', 0, 1), (6, 3, 0, 0, 'Tilting Machine', 0, 0, 0, '222226137_5.jpg', '', '', 0, '', '', '', 0, 1), (7, 3, 0, 0, 'Spry Cooling Tank', 0, 0, 0, '435368314_7.jpg', '', '', 0, '', '', '', 0, 1), (8, 3, 0, 0, 'Vaccum Celebration Tank', 0, 0, 0, '543131656_Red Simple S Letter Brand Logo (1).jpg', '', '', 0, '', '', '', 0, 1), (9, 3, 0, 0, 'Pipe Tube Cutter Machine', 0, 0, 0, '804170603_9.jpg', '', '', 0, '', '', '', 0, 1), (10, 3, 0, 0, 'Haul Off machine', 0, 0, 0, '532024512_10.jpg', '', '', 0, '', '', '', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `product_images` -- CREATE TABLE `product_images` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `product_images` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `product_images` -- INSERT INTO `product_images` (`id`, `product_id`, `product_images`) VALUES (1, 21, '437000749_RMG-C0001_compressed_1597922195.jpg'), (8, 19, '699039219_pexels-jacp-3421636.jpg'), (9, 19, '524109163_pexels-alessandro-oliverio-611273-1472237.jpg'), (14, 13, '172387246_11.jpeg'), (15, 13, '173573363_2.jpg'), (16, 13, '691137357_13.jpeg'), (17, 13, '540735132_WhatsApp Image 2023-05-09 at 2.15.10 PM.jpeg'), (18, 10, '284109100_3.webp'), (19, 10, '873662805_8.webp'), (21, 15, '144380620_ST-03.jpg'), (22, 15, '448202484_ST -02.jpg'), (23, 14, '292377193_1.webp'), (24, 14, '808467906_3.webp'), (25, 11, '639107670_2.png'), (26, 11, '309644127_3.jpg'), (27, 19, '320428248_AnyConv.com__20240229_101427.jpg'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_users` -- ALTER TABLE `admin_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banner` -- ALTER TABLE `banner` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `firstbanner` -- ALTER TABLE `firstbanner` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallary` -- ALTER TABLE `gallary` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_users` -- ALTER TABLE `admin_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `banner` -- ALTER TABLE `banner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `firstbanner` -- ALTER TABLE `firstbanner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `gallary` -- ALTER TABLE `gallary` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2323; -- -- AUTO_INCREMENT for table `product_images` -- ALTER TABLE `product_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; 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 */;