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/jyotilingdurshan.com/public_html/ |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: May 28, 2025 at 05:39 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_jyotilingdursh` -- -- -------------------------------------------------------- -- -- 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', '712583528_About-us-banner.jpg', '<p style=\"text-align:justify\"><strong>Vistar Enterprise possesses expertise in Equipment manufacturing, Material Handling Equipment, Structural Fabrication & Filtration System of Water also. Vistar Enterprise has manufacturing facility based in Ahmedabad where it manufactures high quality/ certified pressure vessels, columns, heat exchangers and other process equipment.</strong></p>\r\n\r\n<p style=\"text-align:justify\"><strong>Our team is committed to delivering exceptional design and manufacturing services for process equipment, Structural fabrication, material handling equipment, Water Filtration System. With extensive industry experience and a strong focus on innovation, we strive to assist our clients in optimizing their operations and enhancing their profitability.</strong></p>', '<p style=\"text-align:justify\"><strong>Our organization is committed to a customer-centric philosophy. Our knowledgeable sales and technical teams collaborate closely with clients to comprehend their specific requirements and offer customized solutions. From the initial concept through to final delivery, we aim to surpass expectations and achieve outstanding results.</strong></p>\r\n\r\n<p style=\"text-align:justify\"><strong>We boast advanced production facilities, an extensive inventory of equipment, and a crew that is highly competent, driven, and adaptable. Since total customer satisfaction is our first priority, we constantly work to surpass our clients' expectations in terms of scheduling, production, quality control, and delivery dates.</strong></p>\r\n\r\n<hr />\r\n<p style=\"text-align:justify\"><span style=\"font-size:16px\"><strong>Facility of Manufacturing</strong></span></p>\r\n\r\n<p style=\"text-align:justify\"><span style=\"font-size:12px\"><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:rgb(81, 81, 81)\">The company has a well laid out plant, housing the complete range of machineries and tools required for the manufacture of quality products well with in committed delivery schedules. The facility has in-house Radiography Enclosure,and Paint Booth as well The company’s Machine Shop caters to the needs of Sub-Contract machining requirements of Valve Industries, Automobiles, Power Plants, Earth Moving Equipments, Forging Plants etc., apart from in-house machining requirements.</span></span></span><br />\r\n<strong>Machinery </strong></p>\r\n\r\n<div class=\"col-lg-6\" style=\"box-sizing: border-box; position: relative; width: 570px; min-height: 1px; padding-right: 15px; padding-left: 15px; flex: 0 0 50%; max-width: 50%; color: rgb(81, 81, 81); font-family: Yantramanav, sans-serif; font-size: 18px; letter-spacing: 0.6px;\">\r\n<div class=\"sub-about-img-left\" style=\"box-sizing: border-box;\">\r\n<ul>\r\n <li><span style=\"font-size:12px\">Plate Rolling & Bending</span></li>\r\n <li><span style=\"font-size:12px\"> Weld Edge Preparation</span></li>\r\n <li><span style=\"font-size:12px\"> Automatic welding machine</span></li>\r\n <li><span style=\"font-size:12px\">Tube expansion & Tube Welding machines</span></li>\r\n <li><span style=\"font-size:12px\">Lathe Machines</span></li>\r\n <li><span style=\"font-size:12px\">Hydraulic press</span></li>\r\n <li><span style=\"font-size:12px\">Drilling</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-lg-6\" style=\"box-sizing: border-box; position: relative; width: 570px; min-height: 1px; padding-right: 15px; padding-left: 15px; flex: 0 0 50%; max-width: 50%; color: rgb(81, 81, 81); font-family: Yantramanav, sans-serif; font-size: 18px; letter-spacing: 0.6px;\">\r\n<div class=\"sub-about-content-right sub-mf-content\" style=\"box-sizing: border-box;\">\r\n<ul>\r\n <li style=\"text-align: justify;\"><span style=\"font-size:12px\">CNC Drilling , Rubber Lining, Boring, Planing, Dishing, PWHT From approved sub-contractors</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n<hr />\r\n<p> </p>', 1), (1, 'About Us', '712583528_About-us-banner.jpg', '<p style=\"text-align:justify\"><strong>Vistar Enterprise possesses expertise in Equipment manufacturing, Material Handling Equipment, Structural Fabrication & Filtration System of Water also. Vistar Enterprise has manufacturing facility based in Ahmedabad where it manufactures high quality/ certified pressure vessels, columns, heat exchangers and other process equipment.</strong></p>\r\n\r\n<p style=\"text-align:justify\"><strong>Our team is committed to delivering exceptional design and manufacturing services for process equipment, Structural fabrication, material handling equipment, Water Filtration System. With extensive industry experience and a strong focus on innovation, we strive to assist our clients in optimizing their operations and enhancing their profitability.</strong></p>', '<p style=\"text-align:justify\"><strong>Our organization is committed to a customer-centric philosophy. Our knowledgeable sales and technical teams collaborate closely with clients to comprehend their specific requirements and offer customized solutions. From the initial concept through to final delivery, we aim to surpass expectations and achieve outstanding results.</strong></p>\r\n\r\n<p style=\"text-align:justify\"><strong>We boast advanced production facilities, an extensive inventory of equipment, and a crew that is highly competent, driven, and adaptable. Since total customer satisfaction is our first priority, we constantly work to surpass our clients' expectations in terms of scheduling, production, quality control, and delivery dates.</strong></p>\r\n\r\n<hr />\r\n<p style=\"text-align:justify\"><span style=\"font-size:16px\"><strong>Facility of Manufacturing</strong></span></p>\r\n\r\n<p style=\"text-align:justify\"><span style=\"font-size:12px\"><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:rgb(81, 81, 81)\">The company has a well laid out plant, housing the complete range of machineries and tools required for the manufacture of quality products well with in committed delivery schedules. The facility has in-house Radiography Enclosure,and Paint Booth as well The company’s Machine Shop caters to the needs of Sub-Contract machining requirements of Valve Industries, Automobiles, Power Plants, Earth Moving Equipments, Forging Plants etc., apart from in-house machining requirements.</span></span></span><br />\r\n<strong>Machinery </strong></p>\r\n\r\n<div class=\"col-lg-6\" style=\"box-sizing: border-box; position: relative; width: 570px; min-height: 1px; padding-right: 15px; padding-left: 15px; flex: 0 0 50%; max-width: 50%; color: rgb(81, 81, 81); font-family: Yantramanav, sans-serif; font-size: 18px; letter-spacing: 0.6px;\">\r\n<div class=\"sub-about-img-left\" style=\"box-sizing: border-box;\">\r\n<ul>\r\n <li><span style=\"font-size:12px\">Plate Rolling & Bending</span></li>\r\n <li><span style=\"font-size:12px\"> Weld Edge Preparation</span></li>\r\n <li><span style=\"font-size:12px\"> Automatic welding machine</span></li>\r\n <li><span style=\"font-size:12px\">Tube expansion & Tube Welding machines</span></li>\r\n <li><span style=\"font-size:12px\">Lathe Machines</span></li>\r\n <li><span style=\"font-size:12px\">Hydraulic press</span></li>\r\n <li><span style=\"font-size:12px\">Drilling</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-lg-6\" style=\"box-sizing: border-box; position: relative; width: 570px; min-height: 1px; padding-right: 15px; padding-left: 15px; flex: 0 0 50%; max-width: 50%; color: rgb(81, 81, 81); font-family: Yantramanav, sans-serif; font-size: 18px; letter-spacing: 0.6px;\">\r\n<div class=\"sub-about-content-right sub-mf-content\" style=\"box-sizing: border-box;\">\r\n<ul>\r\n <li style=\"text-align: justify;\"><span style=\"font-size:12px\">CNC Drilling , Rubber Lining, Boring, Planing, Dishing, PWHT From approved sub-contractors</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n<hr />\r\n<p> </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, 'jyotilingdurshan', 'c40346f41a3a938859196d30f42f8002', 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, 'Industrial Fabrication Service', '753152188_steel-fabrication-banner.jpg', 1), (2, 'Industrial Shed Installation Service', '648535695_337451_meenakshifabricators1554789952.jpeg', 1), (4, 'DESIGN - ENGINEERING - INNOVATION', '823984890_1.png', 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 (1, '12 Jyotirlingas', '367112345_Untitled design.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, 'hudco', '516165283_hudco20.jpg', 1), (2, 'adani', '560918745_download (1).png', 1), (4, 'Jindal Urban Waste Management LTD', '268807593_jindal_itf_logo (2).jpeg', 1), (5, 'PHOENIX DENTLE', '646840220_PHOENIX LOGO.png', 1), (6, 'ITER INDIA', '122027532_ITER INDIA LOGO.png', 1), (7, 'IPR LOGO', '915202060_IPR-Logo.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 (3, 'Mild Steel Pipe Laying', '920243039_20240327_113541.jpg', 1), (4, 'Ductile Iron Pipe Laying', '447096189_iron-pipe-fabrication-service.jpg', 1), (5, 'PIPING SKID', '380443427_11.png', 1), (6, 'PEB SHED', '679404863_2.jpg', 1), (7, 'PEB SHED 1', '232786087_sdsd.jpeg', 1), (8, 'PEB SHED', '725989621_asdasd.jpeg', 1); -- -------------------------------------------------------- -- -- Table structure for table `order_status` -- CREATE TABLE `order_status` ( `id` int(11) NOT NULL, `name` varchar(32) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `order_status` -- INSERT INTO `order_status` (`id`, `name`) VALUES (1, 'Done'); -- -------------------------------------------------------- -- -- 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, 1, 0, 0, 'Kedarnath Jyotirlinga', 0, 0, 0, '339206908_licensed-image.jfif', '<p>Badrinath Dham<br/>\nGangotri Dham <br/>\nYamnotri Dham <br/>\nHaridwar <br/>\nRishikesh</p>', '', 0, 'Extra', '', '', 0, 1), (2, 1, 0, 0, 'Kashi Vishwanath Jyotirlinga', 0, 0, 0, '612267797_the-divine-origin-of-kashi-vishwanath-jyotirlinga.jpg', '<h3>Ram Mandir<br />\r\nPrayagraj - Triveni Sangam Ganga Snan<br />\r\nLate Hanuman </h3>', '', 0, 'Extra', '', '', 0, 1), (3, 1, 0, 0, 'Omkareshwar Jyotirlinga', 0, 0, 0, '323564519_History-of-Omkareshwar-Temple.jpg', '', '', 0, '', '', '', 0, 1), (4, 1, 0, 0, 'Mahakaleshwar Jyotirlinga', 0, 0, 0, '487052387_Mahakal.png', '<h3> Ujjain Shri Kaal Bhairav Temple</h3>', '', 0, 'Extra', '', '', 0, 1), (5, 1, 0, 0, 'Vaidyanath Jyotirlinga', 0, 0, 0, '302892918_shivlinga baidyanath sharechat--87c4f4.jpeg', '', '', 0, '', '', '', 0, 1), (6, 1, 0, 0, 'Mallikarjuna Jyotirlinga', 0, 0, 0, '759219225_1515963880_Mallikarjuna-Jyotirlinga1.webp', '<h5><strong> Tirumala Tirupati Temple</strong></h5>', '', 0, 'Extra', '', '', 0, 1), (7, 1, 0, 0, 'Ramanathaswamy Jyotirlinga', 0, 0, 0, '294873051_ramanathaswamy_lingam.jpeg', '<h5><strong> Ram Sethu Bridge</strong></h5>', '', 0, 'Extra', '', '', 0, 1), (8, 1, 0, 0, 'Grishneshwar Jyotirlinga', 0, 0, 0, '848970215_Grishneswar-Jyotirlinga-Ellora.jpeg', '<h4><strong>Shani Shingnapur Temple</strong></h4>', '', 0, 'Extra', '', '', 0, 1), (9, 1, 0, 0, 'Bhimashankar Jyotirlinga', 0, 0, 0, '454077918_Sri-Bhimashankar-Temple-Jyotirlinga-Shiva-Temple-KhedPune-Maharashtra.jpg', '<h3><strong>Shirdi Sai Baba Temple</strong></h3>', '', 0, 'Extra', '', '', 0, 1), (10, 1, 0, 0, 'Trimbakeshwar Jyotirlinga', 0, 0, 0, '226400975_02 Trimbakeshwar Jyotirlinga Temple.jpg', '<h5><strong> Shree Siddhivinayak Ganapati Temple</strong></h5>', '', 0, 'Extra', '', '', 0, 1), (11, 1, 0, 0, 'Nageshwar Jyotirlinga', 0, 0, 0, '555268147_nageshwar-jyotirlinga.jpg', '<h5><strong> Bet Dwarka Temple</strong></h5>', '', 0, 'Extra', '', '', 0, 1), (12, 1, 0, 0, 'Somnath Jyotirlinga', 0, 0, 0, '388916800_Somnath-Temple-27.jpeg', '<h3>Dwarka <strong>Temple</strong></h3>', '', 0, 'Extra', '', '', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `sub_categories` -- CREATE TABLE `sub_categories` ( `id` int(11) NOT NULL, `categories_id` int(11) NOT NULL, `sub_categories` varchar(100) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `sub_categories` -- INSERT INTO `sub_categories` (`id`, `categories_id`, `sub_categories`, `status`) VALUES (1, 2, 'Brand', 1), (2, 2, 'Trouser', 1), (3, 1, 'Ashoplav', 1), (4, 5, 'Raymond', 1), (5, 5, 'Manyavar', 1), (6, 4, 'Sabyasachi', 1); -- -- 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 `order_status` -- ALTER TABLE `order_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_categories` -- ALTER TABLE `sub_categories` 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=2; -- -- AUTO_INCREMENT for table `firstbanner` -- ALTER TABLE `firstbanner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `gallary` -- ALTER TABLE `gallary` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `order_status` -- ALTER TABLE `order_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3335; -- -- AUTO_INCREMENT for table `sub_categories` -- ALTER TABLE `sub_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; 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 */;