-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 22, 2021 at 08:33 PM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.2.16

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

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

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `estate_id` int(20) NOT NULL,
  `estate_name` varchar(100) NOT NULL,
  `estate_image` varchar(200) NOT NULL,
  `estate_category` varchar(30) NOT NULL,
  `estate_tag` varchar(30) NOT NULL,
  `estate_price` varchar(20) NOT NULL,
  `date_added` date NOT NULL,
  `estate_desc` varchar(500) NOT NULL,
  `estate_location` varchar(120) NOT NULL,
  `estate_status` varchar(10) NOT NULL,
  `estate_type` varchar(20) NOT NULL,
  `estate_sqft` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `properties`
--

INSERT INTO `properties` (`estate_id`, `estate_name`, `estate_image`, `estate_category`, `estate_tag`, `estate_price`, `date_added`, `estate_desc`, `estate_location`, `estate_status`, `estate_type`, `estate_sqft`) VALUES
(1, 'DLF The Magnolias', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'listing', 'residential', '0', '2018-07-02', '4 BHK + SW on Higher Floor', 'Sector – 42,Golf Course Road, Gurgaon', '1', 'Apartment', '5875'),
(2, 'Sunteck Signature Island', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'projects', 'residential', 'Rs 40 Cr.', '2018-06-02', '4BHK with International standard interiors + 4 Full Bath', 'Bandra Kurla Complex', 'ready-to-m', 'Mumbai', '5875'),
(3, 'Freehold Bungalow In Safdarjung Enclave', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'listing', 'residential', '0', '2018-07-02', '4 Floors with Basement & Stilt', 'Safdarjung Enclave', '1', 'bungalow', '3000'),
(4, 'Emaar The Palm Springs', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'listing', 'residential', '', '2018-06-02', '4 BHK Luxury Apartments', 'Golf Course Road, DLF Phase V, Sector 53, Gurugram', '1', 'apartment', '3800'),
(5, 'THE VILAS', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'listing', 'residential', '0', '2018-06-02', '5 BHK Independent Villa', 'DLF Phase II, Gurugram', '1', 'villa', '6700'),
(6, 'Vipul Tatvam Villa', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'listing', 'residential', '0', '2018-06-02', '5BHK with International standard interiors + 5 Full Bath', 'Sector - 48, Sohna Road, Gurugram', '1', 'Apartment', '7650'),
(7, 'DLF The Aralias', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'listing', 'residential', '0', '2018-06-02', '4BHK + 4 Full Bath', 'Sector - 42, DLF Golf Links Gurugram', '1', 'apartment', '5850'),
(8, 'DLF Ultima', 'https://freedesignfile.com/upload/2016/10/luxury-houses-with-yellow-light-in-modern-villa-at-night-03-HD-picture.jpg', 'projects', 'residential', 'Rs 1.6 Cr-2.6 Cr Onw', '2018-06-02', '5 BHK Villa', 'DLF Garden City, Sector - 81, Gurugram', '1', 'villa', '5850');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `properties`
--
ALTER TABLE `properties`
  ADD PRIMARY KEY (`estate_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `properties`
--
ALTER TABLE `properties`
  MODIFY `estate_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
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 */;
