-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 12, 2021 at 10:42 AM
-- Server version: 10.5.12-MariaDB-cll-lve
-- PHP Version: 7.3.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `wwwdhdreamhome_dhhome`
--

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

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

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`id`, `image`) VALUES
(1, 'photo1.jpeg'),
(2, 'photo2.jpeg'),
(3, 'photo3.jpeg');

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

--
-- Table structure for table `billing`
--

CREATE TABLE `billing` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `description` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `billing`
--

INSERT INTO `billing` (`id`, `title`, `image`, `description`) VALUES
(1, 'Cost Analyzation', '1604150961.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">A construction cost analysis is an analysis performed by a construction company or its workers to accurately identify where the company or project is using or spending its money and resources&nbsp; and whether or not this money is being well spent. Cost analysis in construction is even more important than in many other industries. The nature of construction projects and bidding for work makes understanding costs and margin critical to a sustainable business.</span>'),
(2, 'Preparation Of Bills', '1604151004.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">Bill of Quantities also referred to as BOQ, is a document formulated in the construction industry to specify materials, labors, and their cost. It serves as a communication tool between client, consultant &amp; the contractor. It is usually prepared by a cost consultant or a surveyor.</span><br>'),
(3, 'Estimation & Quantity Survey', '1604151067.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">An estimate is a calculation of the quantities of various items of work, and the expenses likely to be incurred there on. The total of these probable expenses to be incurred on the work is known as estimated cost of the work.Quantity Surveying means calculating the quantity of materials such as total volume of concrete, total weight of reinforcement bars, total area to be finished. Estimating deals with predicting the amount required for constructing such as cost of materials, labor costs etc.Quantity survey plays a vital role in estimation and construction of any relevant project.</span><br>');

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

--
-- Table structure for table `building`
--

CREATE TABLE `building` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `description` varchar(2000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `building`
--

INSERT INTO `building` (`id`, `title`, `image`, `description`) VALUES
(1, 'Swimming Pool Designing & Construction', '1604152336.png', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">Designing and installing a swimming pool requires specialist design to address: the building structure and mangement of the environment (taking into account shape, size, depth, tank, etc.) specific techniques (such as filtration, the circulation system&nbsp; pumps, inlets and outlets, pipe work, etc.</span>'),
(2, '2D & 3D Elevation', '1604152521.jpeg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">A 2D or 3D elevation is created from the elevation line properties and the selected objects in the building model. The elevation is linked to the building model.You can edit certain characteristics of the elevation to control its placement and appearance. You can also use a 2D section/elevation style to control the display of selected objects in a 2D elevation, and you can control the display of individual lines in a 2D elevation.</span><br>'),
(3, 'Panchayat municipality approval drawing', '1604152754.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">A set of permit drawings are just the basic drawings that comply with a building departments checklist to verify the building is allowed to be built on the property, and it also shows it will meet the most minimum standards of safety and energy efficiency. Other than that&nbsp; additional construction drawings are necessary to describe the construction details and materials to the builder.</span>'),
(4, 'Structural Drawing', '1604152884.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">A structural drawing a type of engineering drawing, is a plan or set of plans and details for how a building or other structure will be built. Structural drawings are generally prepared by registered professional engineers and based on information provided by architectural drawings. The structural drawings are primarily concerned with the load carrying members of a structure. They outline the size and types of materials to be used as well as the general demands for connections. They do not address architectural details like surface finishes partition walls or mechanical systems. The structural drawings communicate the design of the buildings structure to the building authority for review. Structural drawings are also included with a proposed buildings contract documents which guide contractors in detailing&nbsp; fabricating and installing parts of the structure[1]</span><br>');

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

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

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `phone` text NOT NULL,
  `message` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `title` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `gallery` (`id`, `image`, `title`) VALUES
(1, '0IMG-20201017-WA0124.jpg', 'Exterior'),
(2, '0IMG-20201017-WA0101.jpg', 'Exterior'),
(3, '0IMG-20201017-WA0098.jpg', 'Exterior'),
(4, '0IMG-20201017-WA0097.jpg', 'Exterior'),
(5, '0IMG-20201017-WA0119.jpg', 'Exterior'),
(6, '0IMG-20201017-WA0094.jpg', 'Exterior'),
(7, '0IMG-20201017-WA0090.jpg', 'Exterior'),
(8, '0IMG-20201017-WA0085.jpg', 'Exterior'),
(9, '0IMG-20201017-WA0084.jpg', 'Exterior'),
(10, '0IMG-20201017-WA0083.jpg', 'Exterior'),
(11, '0IMG-20201016-WA0013.jpg', 'Exterior'),
(12, '0WhatsApp Image 2020-10-16 at 8.57.39 AM.jpeg', 'Exterior'),
(13, '0WhatsApp Image 2020-10-16 at 8.57.41 AM.jpeg', 'Exterior'),
(14, '0WhatsApp Image 2020-10-16 at 8.57.32 AM (1).jpeg', 'Exterior'),
(15, '0WhatsApp Image 2020-10-16 at 8.57.32 AM.jpeg', 'Exterior'),
(16, '0WhatsApp Image 2020-10-16 at 8.57.33 AM (1).jpeg', 'Exterior'),
(17, '0IMG-20201016-WA0008.jpg', 'Exterior'),
(18, '0WhatsApp Image 2020-10-16 at 8.57.34 AM (1).jpeg', 'Exterior'),
(19, '0WhatsApp Image 2020-10-16 at 8.57.38 AM (1).jpeg', 'Exterior'),
(20, '0WhatsApp Image 2020-10-16 at 8.57.49 AM.jpeg', 'Exterior'),
(21, '0WhatsApp Image 2020-10-16 at 8.57.46 AM.jpeg', 'Interior'),
(22, '0WhatsApp Image 2020-10-16 at 8.57.49 AM (1).jpeg', 'Interior'),
(23, '0WhatsApp Image 2020-10-16 at 8.57.45 AM.jpeg', 'Interior'),
(24, '0WhatsApp Image 2020-10-16 at 8.57.43 AM.jpeg', 'Interior'),
(25, '0IMG-20201017-WA0125.jpg', 'Other'),
(26, '0IMG-20201017-WA0092.jpg', 'Other'),
(27, '0IMG-20201017-WA0117.jpg', 'Other'),
(28, '0IMG-20201017-WA0118.jpg', 'Other'),
(29, '0IMG-20201017-WA0108.jpg', 'Exterior'),
(32, '0WhatsApp Image 2021-11-05 at 11.33.27 AM.jpeg', 'Other'),
(33, '0WhatsApp Image 2021-11-05 at 11.33.28 AM.jpeg', 'Other'),
(34, '0WhatsApp Image 2021-11-05 at 11.33.28 AM (1).jpeg', 'Other'),
(35, '0WhatsApp Image 2021-11-05 at 11.33.29 AM.jpeg', 'Other'),
(36, '0WhatsApp Image 2021-11-05 at 11.33.29 AM (2).jpeg', 'Other');

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

--
-- Table structure for table `high`
--

CREATE TABLE `high` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(600) NOT NULL,
  `description` varchar(800) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `high`
--

INSERT INTO `high` (`id`, `title`, `image`, `description`) VALUES
(2, 'Our Completed Work', '1604416405.jpg', 'Our Completed Work'),
(3, 'Our Completed Work', '1604416431.jpg', 'Our Completed Work'),
(4, 'Villa Near Kottayam', '1604416535.png', 'Villa Near Kottayam'),
(5, 'Ongoing Project', '1604416629.jpg', 'Ongoing Project');

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` int(11) NOT NULL,
  `uname` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `uname`, `password`) VALUES
(1, 'admin', 'dream123');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `place` varchar(500) NOT NULL,
  `description` varchar(600) NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `image`, `place`, `description`, `date`) VALUES
(1, 'News About DH Dream Home', '1604140371.jpeg', 'Kottayam', 'News About DH Dream Home', '2020-10-22'),
(2, 'News About DH Dream Home', '1604140450.jpeg', 'Kottayam', 'News About DH Dream Home<br>', '2020-10-22'),
(3, 'News About DH Dream Home', '1604140492.jpeg', 'Kottayam', 'News About DH Dream Home<br>', '2020-10-30'),
(4, 'News About DH Dream Home', '1604140533.jpeg', 'Kottayam', 'News About DH Dream Home<br>', '2020-10-17'),
(6, 'News About D H Dream Home', '1606211109.jpg', 'Kottayam ', '<h5><b><font color=\"#0066cc\"><u style=\"\"><font face=\"arial\" style=\"\" size=\"3\">ONGOING PROJECT :-</font></u><br><font size=\"4\"><i style=\"\"><font face=\"times new roman\" style=\"\">Mr.Anilkumar and Mrs.Kochumol<br></font></i><font face=\"arial\" style=\"\">Site:-Nattakom<br></font><font face=\"arial\" style=\"\">Area=1121 Sqft</font></font></font></b></h5><div><div><b><font color=\"#0066cc\"><br></font></b><div><br></div></div></div>', '2020-08-21'),
(7, 'News About D H Dream Home', '1606213808.jpg', 'Kottayam ', '<h5 style=\"font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\"><font color=\"#0066cc\" style=\"\"><b><u style=\"\"><font face=\"arial\" size=\"3\" style=\"\">ONGOING PROJECT :-</font></u><br><font size=\"4\" style=\"\"><i style=\"\"><font face=\"times new roman\">Mr.Jesvin.J<br></font></i><font face=\"arial\" style=\"\">Site:-Pangada<br></font><font face=\"arial\" style=\"\">Area=1225 Sqft</font></font></b></font></h5>', '2020-09-18'),
(8, 'News About D H Dream Home', '1606214007.jpg', 'Kottayam ', '<h5 style=\"font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\"><b><font color=\"#0066cc\"><u><font face=\"arial\" size=\"3\">ONGOING PROJECT :-</font></u><br><font size=\"4\"><i><font face=\"times new roman\">Mrs.Leelamma Sebastian<br></font></i><font face=\"arial\">Site:-Kuravilangadu<br></font><font face=\"arial\">Area=2482 Sqft</font></font></font></b></h5>', '2020-08-17'),
(9, 'News About D H Dream Home', '1606214253.jpg', 'Kottayam ', '<h5 style=\"font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\"><b><font color=\"#cc0066\"><u style=\"\"><font face=\"arial\" size=\"3\" style=\"\">COMPLETED PROJECT :-</font></u><br><font size=\"4\" style=\"\"><i style=\"\"><font face=\"times new roman\">Mr.Charly Jacob<br></font></i><font face=\"arial\" style=\"\">Site:-Manganam<br></font><font face=\"arial\" style=\"\">Area=4315 Sqft</font></font></font></b></h5>', '2019-01-14'),
(10, 'News About D H Dream Home', '1606214435.jpg', 'Kottayam ', '<h5 style=\"font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\"><b><u style=\"color: rgb(0, 102, 204);\"><font face=\"arial\" size=\"3\">ONGOING PROJECT :-</font></u><br><font size=\"4\" style=\"\"><i style=\"\"><font face=\"times new roman\" style=\"\"><font color=\"#0066cc\">Mr.Thomas Joseph</font><br></font></i><font face=\"arial\" style=\"color: rgb(0, 102, 204);\">Site:-Pangada<br></font><font face=\"arial\" style=\"color: rgb(0, 102, 204);\">Area=2542 Sqft</font></font></b></h5>', '2020-08-17'),
(11, 'News About D H Dream Home', '1606300895.jpg', 'Areeparambu', '<h5 style=\"font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\"><font color=\"#0066cc\"><b><u style=\"\"><font face=\"arial\" size=\"3\" style=\"\">ONGOING PROJECT :-</font></u><br><font size=\"4\" style=\"\"><i style=\"\"><font face=\"times new roman\">Mr.T.V.Mathew<br></font></i><font face=\"arial\" style=\"\">Site:-Areeparambu<br></font><font face=\"arial\" style=\"\">Area=2624 Sqft</font></font></b></font></h5>', '2020-10-21'),
(12, 'News About D H Dream Home', '1610794593.JPG', 'Erumapetty', '<h5 open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\" style=\"font-family: \"><font color=\"#cc0066\"><b><u style=\"\"><font face=\"arial\" size=\"3\" style=\"\">COMPLETED PROJECT :-</font></u><br><font size=\"4\" style=\"\"><i style=\"\"><font face=\"times new roman\">Mr.A.V.Thomas<br></font></i><font face=\"arial\" style=\"\">Site:-Erumapetty<br></font><font face=\"arial\" style=\"\">Area=2140 Sqft</font></font></b></font></h5>', '2020-08-23'),
(13, 'News About D H Dream Home', '1611572725.JPG', 'Erumapetty', '<h5 open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\" style=\"font-family: \"><b><font color=\"#cc0066\"><u style=\"\"><font face=\"arial\" size=\"3\" style=\"\">COMPLETED PROJECT :-</font></u><br><font size=\"4\" style=\"\"><i style=\"\"><font face=\"times new roman\">Mr.A.V.Thomas<br></font></i><font face=\"arial\" style=\"\">Site:-Erumapetty<br></font><font face=\"arial\" style=\"\">Area=2140 Sqft</font></font></font></b></h5>', '2020-08-23'),
(14, 'News About D H Dream Home', '1611573112.JPG', 'Erumapetty', '<h5 open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\" style=\"font-family: \"><b><font color=\"#cc0066\"><u style=\"\"><font face=\"arial\" size=\"3\" style=\"\">COMPLETED PROJECT :-</font></u><br><font size=\"4\" style=\"\"><i style=\"\"><font face=\"times new roman\">Mr.A.V.Thomas<br></font></i><font face=\"arial\" style=\"\">Site:-Erumapetty<br></font><font face=\"arial\" style=\"\">Area=2140 Sqft</font></font></font></b></h5>', '2020-08-23'),
(16, 'News About D H Dream Home', '1612868782.JPG', 'Erumapetty', '<h5 open=\"\" sans\",=\"\" sans-serif;=\"\" color:=\"\" rgb(55,=\"\" 58,=\"\" 60);\"=\"\" style=\"font-family: \"><b><font color=\"#cc0066\"><u><font face=\"arial\" size=\"3\">COMPLETED PROJECT :-</font></u><br><font size=\"4\"><i><font face=\"times new roman\">Mr.A.V.Thomas<br></font></i><font face=\"arial\">Site:-Erumapetty<br></font><font face=\"arial\">Area=2140 Sqft</font></font></font></b></h5>', '2020-08-23');

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

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `project`
--

INSERT INTO `project` (`id`, `title`, `image`) VALUES
(0, 'Completed Projects', '0WhatsApp Image 2020-10-16 at 8.57.32 AM (1).jpeg'),
(0, 'Completed Projects', '0WhatsApp Image 2020-10-16 at 8.57.34 AM (1).jpeg'),
(0, 'Completed Projects', '0WhatsApp Image 2020-10-16 at 8.57.49 AM.jpeg'),
(0, 'Completed Projects', '0WhatsApp Image 2020-10-16 at 8.57.46 AM.jpeg'),
(0, 'Completed Projects', '0WhatsApp Image 2020-10-16 at 8.57.39 AM.jpeg'),
(0, 'Completed Projects', '0WhatsApp Image 2020-10-16 at 8.57.38 AM (1).jpeg'),
(0, 'Ongoing Projects', '0WhatsApp Image 2020-10-16 at 8.57.49 AM (1).jpeg'),
(0, 'Ongoing Projects', '0WhatsApp Image 2020-10-16 at 8.57.45 AM.jpeg'),
(0, 'Ongoing Projects', '0WhatsApp Image 2020-10-16 at 8.57.41 AM.jpeg'),
(0, 'Ongoing Projects', '0WhatsApp Image 2020-10-16 at 8.57.41 AM.jpeg'),
(0, 'Upcoming Projects', '0WhatsApp Image 2020-10-16 at 8.57.32 AM.jpeg'),
(0, 'Upcoming Projects', '0WhatsApp Image 2020-10-16 at 8.57.33 AM.jpeg');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `description` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `title`, `image`, `description`) VALUES
(4, 'COMPLETED PROJECTS', '1604148318.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">Our service is widely acknowledged for timely comletion and increased speed and efficiency.We have completed several successful projects with reputed companies and direct clients.The company today is the most reliable option when it comes to large and complex projects..</span><br>'),
(5, 'ONGOING PROJECTS', '1604148361.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">Archid Builders offers a unique combination of multi-disciplinary capabilities to execute technically complex projects with high quality engineering and construction skills.We have a proven track record in major project implementation across categories</span><br>'),
(7, 'UPCOMING PROJECTS', '1604148581.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">Our clients and partners have always benefited from resourcefulness of our people.Whether it is adopting new technologies,or using human intelligence,our clientsand partners have always benefited from the resourcefulness of our people</span><br>');

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

--
-- Table structure for table `quote`
--

CREATE TABLE `quote` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `phone` text NOT NULL,
  `selected` varchar(600) NOT NULL,
  `date` date NOT NULL,
  `message` varchar(600) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `servicea`
--

CREATE TABLE `servicea` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` varchar(700) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `description` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `title`, `image`, `description`) VALUES
(1, 'Home Renovation', '1604149439.jpg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">Archid Builders specializes in dealing with residential and commercial renovations and construction tasks.Team of professional contractors and interior designers are working dedicatedly on all projects.We are offering our customers well defined and managed construction and renovation services. Our team ensures that the renovation solutions delivered are economical as well as perfectly match up to the '),
(2, 'Residential & Commercial Building', '1604149616.jpeg', '<span style=\"color: rgb(119, 119, 119); font-size: 14px; background-color: rgb(255, 255, 255);\">We know very well what your dream home is like.It is not an easy thing to find everything combined in a single package. Only experts can do that and mundezhathu Builders are professional experts at designing your dream homes and interiorsOur rich industry experience has given us an edge over our competitors for executing Complete Interior Work Services. Team of professional interior designers are work');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
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 */;