-- http://www.phpmyadmin.net
--




--
-- Database: `mahesh`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE IF NOT EXISTS `about` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `detail` mediumtext NOT NULL,
  `images` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `title`, `detail`, `images`) VALUES
(1, 'ABOUT M.CON EQUIPMENT', '<p>Founded in the year of 2011, we M. Con Equipment, are a highly recognized organization of the industry involved in manufacturing, trading and supplier a broad assortment of best quality Industrial Spare Parts. In our commendable array of products we are offering Machine Spare Parts, Tower Crane Spare Parts, PVC Pipes, Planter Liners, Electrical Sensor, Electric PLC, Wire Rope, Sponge Balls etc. And we are a service provider of Concrete Pump Repairing Services. Our provided products are manufactured by taking only optimum quality components at an ultra-modern processing unit at our vendor end. These products are highly demanded by the customers for their best quality, longer service life and high performance. These offered products are used in various are like a electrical, automobile and construction industries.</p>\r\n\r\n<p>We are procuring these offered array from trusted vendors of the market. These vendors are designing the offered products to follow industry norms and standards. With the help and support of our vendors, we are able to deliver the offered products on time. We have a team of highly qualified and skilled professionals to handle our business related tasks.&nbsp;Under the constant supervision of our mentor Mr. Ratnesh Yadav, we have been able to achieve such a distinct position in this domain. Due to his motivation and valuable direction, we have attained a huge number of clients across the nation.</p>\r\n', '7047about-1.jpg');

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

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `head_address` varchar(100) NOT NULL,
  `phone1` varchar(100) NOT NULL,
  `phone2` varchar(100) NOT NULL,
  `email1` varchar(100) NOT NULL,
  `facebook` varchar(100) NOT NULL,
  `twitter` varchar(100) NOT NULL,
  `linkedin` varchar(100) NOT NULL,
  `instagram` varchar(100) NOT NULL,
  `maps` varchar(1000) NOT NULL,
  `about_content` varchar(9000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `head_address`, `phone1`, `phone2`, `email1`, `facebook`, `twitter`, `linkedin`, `instagram`, `maps`, `about_content`) VALUES
(1, 'G-7/161. Sector 16, Rohini , Delhi -110085', '9690391195', '8077521408', 'danish1234md.34@gmail.com', '#', '#', '#', '#', '<iframe src="https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d6996.069394094991!2d77.121682!3d28.748381!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x562ac0777250e1ea!2sRohini%20Sec%2016%20(Maharaja%20Aggarsen%20Dharam%20Sthal)!5e0!3m2!1sen!2sin!4v1634985000838!5m2!1sen!2sin" width="600" height="450" style="border:0;" allowfullscreen="" loading="lazy"></iframe>', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ''Content here, content here'', making it look like readable English.');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `images` varchar(1000) NOT NULL,
  `pid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `images`, `pid`) VALUES
(1, '7260b4.jpg', ''),
(3, '7121a2.jpg', '1'),
(4, '1364a3.jpg', '1'),
(5, '8643a4.jpg', '1'),
(6, '4883a5.jpg', '1'),
(11, '6102b3.jpg', '2'),
(12, '75904.jpg', '2'),
(15, '3892b1.jpg', '2'),
(16, '7839f5.jpg', '2'),
(17, '4132l1.jpg', '2'),
(18, '3127o1.jpg', '3'),
(19, '5070w1.jpg', '3'),
(20, '4257w2.jpg', '3'),
(21, '8534w3.jpg', '3'),
(22, '4625w6.jpg', '3');

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

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

CREATE TABLE IF NOT EXISTS `home_about` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `detail` varchar(10000) NOT NULL,
  `images` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

INSERT INTO `home_about` (`id`, `title`, `detail`, `images`) VALUES
(1, 'WELCOME TO DEZINE HOME .', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for<br />\r\n<br />\r\n&#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n', '87441.jpg');

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

--
-- Table structure for table `logo`
--

CREATE TABLE IF NOT EXISTS `logo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `images` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` (`id`, `images`) VALUES
(1, '3423logo.png');

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

--
-- Table structure for table `main_category`
--

CREATE TABLE IF NOT EXISTS `main_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(1000) NOT NULL,
  `seo` varchar(1000) NOT NULL,
  `images` varchar(1000) NOT NULL,
  `bgcolor` varchar(1000) NOT NULL,
  `status` int(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `main_category`
--

INSERT INTO `main_category` (`id`, `name`, `seo`, `images`, `bgcolor`, `status`) VALUES
(2, 'Living Room Design', 'living-room-design', '11181.jpg', '', 1),
(3, 'Wood Furniture', 'wood-furniture', '87453.jpg', '', 1),
(4, 'Interior  & exterior Design ', 'interior-exterior-design', '41976.jpg', '', 1),
(5, 'Modular Kitchen', 'modular-kitchen', '708815.jpg', '', 1),
(6, 'Designer Wardrobe', 'designer-wardrobe', '29908.jpg', '', 1),
(7, 'Led Wooden Panel', 'led-wooden-panel', '16839.jpg', '', 1),
(8, 'Bedroom & Drawing Room Interior', 'bedroom-drawing-room-interior', '19527.jpg', '', 1),
(9, 'Artifical Garden', 'artifical-garden', '570813.jpg', '', 1),
(10, 'Office & Home Renovation', 'office-home-renovation', '892814.jpg', '', 1),
(11, 'Designer Home Temple', 'designer-home-temple', '654210.jpg', '', 1),
(12, 'Wooden Work', 'wooden-work', '373911.jpg', '', 1),
(13, 'False Ceiling', 'false-ceiling', '854112.jpg', '', 1);

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

--
-- Table structure for table `mision`
--

CREATE TABLE IF NOT EXISTS `mision` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `detail` varchar(10000) NOT NULL,
  `images` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `mision`
--

INSERT INTO `mision` (`id`, `title`, `detail`, `images`) VALUES
(2, 'What We Do', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n', '45031.png'),
(3, 'Why Choose Us', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n', '30092.png'),
(5, 'Vission', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n', '99643.png');

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

--
-- Table structure for table `service`
--

CREATE TABLE IF NOT EXISTS `service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `seo` varchar(200) NOT NULL,
  `category` varchar(250) NOT NULL,
  `detail` varchar(10000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `name`, `seo`, `category`, `detail`) VALUES
(2, 'scascasc asc ', 'scascasc-asc', '2', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English.</p>\r\n'),
(3, 'safcasc', 'safcasc', '3', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English.</p>\r\n');

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

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(1000) NOT NULL,
  `subtitle` varchar(1000) NOT NULL,
  `images` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `title`, `subtitle`, `images`) VALUES
(5, 'Welcome To Dezine Home', 'Interior Designer', '9041image1.jpg'),
(9, 'Welcome To Dezine Home', 'Interior & Exterior Design', '3467image2.jpg'),
(10, 'Welcome To Dezine Home', 'Wallpaper', '9664image3.jpg'),
(11, 'Welcome To Dezine Home', 'Drawing room Interior', '3414image4.jpg'),
(12, 'Welcome To Dezine Home', 'Wooden Work', '5490image5.jpg');
