-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

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

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `email` varchar(128) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `contact` (`id`, `name`, `email`, `mobile`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Satej Chauhan', 'satej2@gmail.com', '7208051018', '2023-11-17 12:45:32', NULL, NULL);

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

--
-- Table structure for table `downloads`
--

CREATE TABLE `downloads` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `d_name` varchar(128) NOT NULL,
  `d_url` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `downloads`
--

INSERT INTO `downloads` (`id`, `p_id`, `d_name`, `d_url`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'saleskit', 'https://frn.s3.ftvassets.in/saleskits/license/real-estate/ftv-residences-saleskit.pdf', 0, '2023-11-06 12:49:16', NULL, NULL),
(2, 1, 'lookbook', 'https://frn.s3.ftvassets.in/look-book/license/real-estate/ftv-residence-look-book.pdf', 0, '2023-11-06 12:49:16', NULL, NULL),
(3, 1, 'videobook', 'https://frn.s3.ftvassets.in/video-book/license/real-estate/ftv-residences-video-book.mp4', 0, '2023-11-06 12:49:16', NULL, NULL),
(4, 1, 'categories', 'https://frn.s3.ftvassets.in/other/categories/ftv-residences-categories.pdf', 0, '2023-11-06 12:49:16', NULL, NULL),
(5, 2, 'saleskit', 'https://frn.s3.ftvassets.in/saleskits/license/real-estate/ftv-villas-saleskit.pdf', 0, '2023-11-06 13:06:41', NULL, NULL),
(6, 2, 'lookbook', 'https://frn.s3.ftvassets.in/look-book/license/real-estate/ftv-villas-look-book.pdf', 0, '2023-11-06 13:06:41', NULL, NULL),
(7, 2, 'videobook', 'https://frn.s3.ftvassets.in/video-book/license/real-estate/ftv-villas-video-book.mp4', 0, '2023-11-06 13:06:41', NULL, NULL),
(8, 3, 'saleskit', 'https://frn.s3.ftvassets.in/saleskits/license/real-estate/ftv-furnished-apartments-saleskit.pdf', 0, '2023-11-06 13:18:46', NULL, NULL),
(9, 3, 'lookbook', '              https://frn.s3.ftvassets.in/look-book/license/real-estate/ftv-furnished-apartments-look-book.pdf\r\n', 0, '2023-11-06 13:18:46', NULL, NULL),
(10, 3, 'videobook', 'https://frn.s3.ftvassets.in/video-book/license/real-estate/ftv-furnished-apartments-video-book.mp4', 0, '2023-11-06 13:18:46', NULL, NULL);

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

--
-- Table structure for table `enquires`
--

CREATE TABLE `enquires` (
  `id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `email` varchar(100) NOT NULL,
  `contact` varchar(15) NOT NULL,
  `state` varchar(128) NOT NULL,
  `city` varchar(128) NOT NULL,
  `company` varchar(255) NOT NULL,
  `designation` varchar(128) NOT NULL,
  `website` text NOT NULL,
  `residences_options` text NOT NULL,
  `commercial_options` text NOT NULL,
  `hospitality_options` text NOT NULL,
  `investment` varchar(128) NOT NULL,
  `message` longtext NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `enquires`
--

INSERT INTO `enquires` (`id`, `name`, `email`, `contact`, `state`, `city`, `company`, `designation`, `website`, `residences_options`, `commercial_options`, `hospitality_options`, `investment`, `message`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'satej Chauhan', 'satej123@gmail.com', '8896653255', 'maharashtra', 'mumbai', 'ftv', 'Developer', 'https://test.com', 'test', 'No Data', 'No Data', '', 'Testing', '2023-11-09 09:19:33', NULL, NULL),
(2, 'satej Chauhan', 'satej123@gmail.com', '8896653255', 'maharashtra', 'mumbai', 'ftv', 'Developer', 'https://test.com', 'test', 'No Data', 'No Data', '', 'Testing', '2023-11-09 09:19:33', NULL, NULL),
(3, 'satej Chauhan', 'satej123@gmail.com', '8896653255', 'maharashtra', 'mumbai', 'ftv', 'Developer', 'https://test.com', 'test', 'No Data', 'No Data', '', 'Testing', '2023-11-09 09:19:33', NULL, NULL),
(4, 'Satej Chauhan', 'satej@gmail.com', '7208001018', 'Maharashtra', 'Mumbai', 'Fashiontv', 'Web Developer', 'https://fashiontv.in', 'residence', 'No Data', 'No Data', '', 'Testing Data', '2023-11-17 12:45:32', NULL, NULL),
(5, 'Satej Chauhan', 'satej@gmail.com', '7208001018', 'Maharashtra', 'Mumbai', 'Fashiontv', 'Web Developer', 'https://fashiontv.in', 'residence', 'No Data', 'No Data', '5', 'Testing Data', '2023-11-17 12:45:32', NULL, NULL);

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

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `img_url` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `features`
--

INSERT INTO `features` (`id`, `p_id`, `title`, `description`, `img_url`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Smart Home', 'F Residences make use of cutting-edge technology in all its properties. F Residences showcase a high degree of automation as we believe to be a step ahead of ordinary developers and estates and reflect an ultra-modern lifestyle with energy-efficient tools.', 'smart-home.jpg', 0, '2023-11-06 12:57:44', NULL, NULL),
(2, 1, 'Plush Location', 'The location of a luxurious residence is an imperative factor that separates the good from the magnificent. F Residences are located at the most prime locations across the nation and well connected to significant locales in the city with the promise of security and privacy to every resident.', 'plush-locations.jpg', 0, '2023-11-06 12:57:44', NULL, NULL),
(3, 1, 'World-class Amenities', 'F residences truly provide a splendid living experience with the presence of best-in-class amenities and top-notch services. These residential spaces feature varied amenities such as swimming pools, gymnasiums, clubhouses, tennis courts and gardens apart from the other facilities.', 'world-class-amenities.jpg', 0, '2023-11-06 12:57:44', NULL, NULL),
(4, 1, 'Capacious opment', 'Comfort being a paramount factor of F Residences, it enables you to avoid the clutter and hassles associated with the shortage of space. Well equipped with remarkable expansive spaces and mesmerising views, it gives you value for every cent of your bounty.', 'capacious-development.jpg', 0, '2023-11-06 12:57:44', NULL, NULL),
(5, 2, 'One-Of-A-Kind Architecture', 'FashionTV has a sense of suave in its own right and incorporates it well in the sophisticated designs of F Villas that showcase world-class elegance and beauty.', 'one-of-kind.jpg', 0, '2023-11-06 13:10:08', NULL, NULL),
(6, 2, 'Luxurious', 'F Villas provide an exceptional luxurious lifestyle without compromising on the views, calmness and tranquillity associated with an ideal hotel. One way F Villas distinguished themselves from low and mid-range chains is by carving out an architectural path of their own.', 'luxurious.jpg', 0, '2023-11-06 13:10:08', NULL, NULL),
(7, 2, 'Friendly And Cordial Staff', 'Whether you are pulling up to the entrance or walking into the lobby, every staff member of F Villa will happily welcome you and make you feel significant and make your stay at F Villa a great memory.', 'friendly-staff.jpg', 0, '2023-11-06 13:10:08', NULL, NULL),
(8, 2, 'Amenities', 'F Villas also have fitness and business centres, and a scenic pool and are widely recognised for providing top-quality cuisines to make the stay of its guests memorable.', 'amenities.jpg', 0, '2023-11-06 13:10:08', NULL, NULL),
(9, 3, 'NUMEROUS PERKS', 'A tower of luxury, a pinnacle of effort, get everything you need and want during your stay with golden furnishings, elegant designs and a modern enigmatic layout to your apartment, it’s always a thing less to do when you move in with us. <br>\r\nTo help you make the most of your stay and your time, FTV Furnished Apartments offer grocery and laundry services delivered directly to your apartment door.', 'numerous-perks.jpg', 0, '2023-11-06 13:23:24', NULL, NULL),
(10, 3, 'GOURMET KITCHENS', 'When you feel like staying in and just enjoying the company of your loved ones along with your favorite meals FTV Furnished Apartments provides you with your own gourmet kitchen.<br>It includes utensils and appliances and upon request you can send us a list of your favorite food items and delicacies and we’ll rack up the refrigerator with them upon your arrival.', 'gourmet-kitchen.jpg', 0, '2023-11-06 13:23:24', NULL, NULL),
(11, 3, 'FITNESS CENTRE', 'The moving process can be daunting so we recommend our fitness centres, saunas and even indoor pools to blow off steam on a regular basis.', 'fitness-center.jpg', 0, '2023-11-06 13:23:24', NULL, NULL),
(12, 3, 'VERSATILE FLOOR PLANS', 'Residences are available in a range of sizes and floor plans. Select from studios to 3 bedroom apartments with all the amenities of home.', 'floor-plans.jpg', 0, '2023-11-06 13:23:24', NULL, NULL),
(13, 3, 'HOUSEKEEPING', 'Our daily round the clock housekeeping service means all you have to do is wake up and be yourself, go with the flow and carry your day forward while we do the rest in its entirety. No dishes to clean , no bed to make, just a home to live in.', 'housekeeping.jpg', 0, '2023-11-06 13:23:24', NULL, NULL);

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

--
-- Table structure for table `header_urls`
--

CREATE TABLE `header_urls` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `headerimg1` varchar(128) NOT NULL,
  `headerimg2` varchar(128) NOT NULL,
  `headerimg3` varchar(128) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `header_urls`
--

INSERT INTO `header_urls` (`id`, `p_id`, `headerimg1`, `headerimg2`, `headerimg3`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'banner-1.jpg', 'banner-2.jpg', 'banner-3.jpg', 0, '2023-11-06 13:00:41', NULL, NULL),
(2, 2, 'banner-1.jpg', 'banner-2.jpg', 'banner-3.jpg', 0, '2023-11-06 13:10:54', NULL, NULL),
(3, 3, 'banner-1.jpg', 'banner-2.jpg', 'banner-3.jpg', 0, '2023-11-06 13:24:08', NULL, NULL);

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `img1` varchar(128) NOT NULL,
  `img2` varchar(128) NOT NULL,
  `img3` varchar(128) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `p_id`, `img1`, `img2`, `img3`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'prerequisite.jpg', 'bs-1.jpg', 'bs-2.jpg', 0, '2023-11-06 13:01:19', NULL, NULL),
(2, 2, 'prerequisite.jpg', 'bs-1.jpg', 'bs-2.jpg', 0, '2023-11-06 13:12:11', NULL, NULL),
(3, 3, 'prerequisite.jpg', 'bs-1.jpg', 'bs-2.jpg', 0, '2023-11-06 13:24:43', NULL, NULL);

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

--
-- Table structure for table `introduction`
--

CREATE TABLE `introduction` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `intro` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `introduction`
--

INSERT INTO `introduction` (`id`, `p_id`, `intro`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'The world\'s leading fashion and lifestyle media brand introduces F Residences, an impressive collection of sky-high homes with luxurious lifestyle amenities located in the most revered neighbourhood across the nation. With highly sophisticated designs and crafty interiors, this impeccable home is an amalgamation of meticulously crafted modern lines and a palette of rich materials that reflect a story of exceptional comfort and elegance.', 0, '2023-11-06 13:02:03', NULL, NULL),
(2, 1, 'The interior designs are encouraged by international architectures and trending decor styles that make these luxurious homes distinct and provide a living grandiosity experience. F Residences are now a must-see, must-have attraction globally, with the F logo shadow towering over its head. F Residences is bound to redefine the idea of living a royal lifestyle for the masses in the world and is the first choice for HNIs and millennials who wish to live an opulent lifestyle.', 0, '2023-11-06 13:02:03', NULL, NULL),
(3, 2, 'F Villas are the bell of the ball when it comes to luxurious stations or impromptu vacations. A creation of FashionTV, this new escapade is yet another milestone for the ever-growing empire of the world\'s largest fashion and lifestyle media brand.', 0, '2023-11-06 13:13:47', NULL, NULL),
(4, 2, 'When it\'s about experiencing top-notch luxury, the elite masses look towards FashionTV villas for its breathtaking ambience and out-of-the-box displays that give it the reputation for almost being a state-of-the-art architectural creation.', 0, '2023-11-06 13:13:47', NULL, NULL),
(5, 2, 'Every F Villa Venue comes with the best replicated International Style and extravagance. With opulent interiors, and local and international mouth-watering delicacies at regal in-house eateries combined with an assortment of unrivalled services, F Villas is bound to redefine grandeur in the hospitality industry.', 0, '2023-11-06 13:13:47', NULL, NULL),
(6, 3, 'Whether you’re working internationally, relocating or traveling with your family, F furnished apartments will bewitch you with space to spread out and provide you with plush amenities to upscale decor. Segregated sleeping, living and working areas along with gourmet kitchens and spacious floor plans to fitness centres, business centres and round the clock house keeping will be good enough to turn your head and once you walk into our palatial and futuristic designs you are bound to sign that contract.', 0, '2023-11-06 13:25:16', NULL, NULL);

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

--
-- Table structure for table `meta_content`
--

CREATE TABLE `meta_content` (
  `id` int(11) NOT NULL,
  `meta_source_name` varchar(100) NOT NULL,
  `meta_title` text NOT NULL,
  `meta_keyword` text NOT NULL,
  `meta_description` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0=Active, 1=inactive',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meta_content`
--

INSERT INTO `meta_content` (`id`, `meta_source_name`, `meta_title`, `meta_keyword`, `meta_description`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'residences', 'Curate and Explore Luxury Living with F-Residences', 'fully furnished flat, furnished apartments, fully furnished apartments, furnished accommodation, fully furnished home, fully furnished luxury apartments, buy fully furnished house\n', 'Discover the epitome of luxury living at F-Residences. Immerse yourself with unrivalled amenities, breathtaking views and exquisite designs. Explore More Today.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'villas', 'Now Home Has a New Address with FTV-Villas | Enrol', 'most luxurious house in India, modern house price in India, luxury house price in India, most luxurious house in india, modern house price in india, most luxurious house in India, buy luxury villa in india\r\n', 'Experience unparalleled opulence at F-Villas, the epitome of luxury mansions in India. Indulge in lavish living, and world-class amenities. Contact us today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'furnished-apartments', 'Enable Style and Comfort With FTV-Furnished Apartments', 'furnished flat, furnished studio, furnished studio apartments, pre-furnished apartments, luxury furnished apartments, corporate furnished apartments, fully furnished studio apartments, buy furnished apartments in india', 'Witness Luxury with FTV-furnished apartments. Indulge in sophisticated living with impeccable design, & a seamless blend of design & comfort. Call us today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'co-works', 'The Future of Co-Working Is Here with FTV Co-Works', 'co-work spaces, co-working spaces in India, best coworking spaces, coworking office spaces, coworking office spaces, best coworking companies in india, best coworking spaces in india, corporate coworking spaces', 'Curate the best corporate co-working space at FTV Co-Works. Boost productivity, network, and enjoy premium amenities in our community. Join us today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 'malls', 'Make Luxury Buying An Experience With FTV - Malls', 'malls in india, best mall in india, upcoming malls in india, luxury malls in India, largest shopping mall in india, cost to build a mall in india, Indian best shopping mall, real estate mall properties in india', 'Get ready for a retail revolution with a diverse range of brands. Experience the future of luxury shopping with upcoming FTV malls in India. Contact us today.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'outlet-malls', 'Outlet Malls In India With Fashion TV Real Estate', 'malls in india, best mall in india, upcoming malls in india, luxury malls in India, largest shopping mall in india, cost to build a mall in india, Indian best shopping mall, real estate mall properties in india, luxury malls in India', 'Discover the ultimate shopping experience at Fashion TV - Outlet Malls. Shop for fashion, electronics, and more at unbeatable prices. Join us now!\r\n', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'house', 'Discover a Variety of Privileges With Fashion TV’s F-House', 'cost of luxury house in india, luxury villas for sale in india, india\'s most luxurious house, luxury house cost in India, luxury house cost in India, luxury bungalow price in india', 'Experience the best of every dining option, right from cafe, bar, and lounge with F-House, Fashion TV’s more prestigious project. Join hands with us today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 'hotels', 'Experience Luxurious Stay & Hospitality at FTV-Hotels', 'luxury hotels, luxury hotels in India, beach luxury hotels, best hotels in India, luxury hotel room, most luxurious hotels, most luxurious hotel in india, build a luxury hotel in india, top luxury hotels in india', 'Immerse yourself in opulence breathtaking views, and impeccable service through the most exotic hotels in India with FTV Hotels. Call us today to know more!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 'resorts', 'Explore Luxurious Resort Stays in India with FTV-Resorts', 'luxury resort in india, luxury resorts, best resorts in india, luxury beach resort, resorts in india, best beach resorts in india, top resorts in india, best luxury resorts in india, most luxurious resorts in india', 'Experience a blissful retreat with a perfect blend of serenity and indulgence with FTV Resorts. Discover exclusive resorts in India by signing up with us today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 'business-deck', 'Create New Business Spaces With FTV-Business Deck', 'commercial real estate, luxury real estate, luxury homes for sale, residential real estate, buy commercial property, top real estate websites, luxury houses for sale, buying property, best company pitch decks', 'Unlock growth opportunities and maximize productivity at our FTV Business Decks, which offers the best business spaces in India. Give us a call today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 'lifestyle-bay', 'Create a Luxurious Lifestyle Space in India with FTV Real Estate', 'lifestyle living real estate, luxury life real estate, real living lifestyle properties, real estate lifestyle properties, luxury lifestyle property, lifestyles property, lifestyle real estate services', 'Uncover the best each mall has to give, with an exclusive aisle with FTV Lifestyle Bay, giving you the best fashion and lifestyle experience. Sign up today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 'projects', 'Discover Our Luxurious Real Estate Projects | FTV Real Estate', 'buy a house in India, buy property in India, get a real estate license, luxury properties, luxury properties, type of real estate, luxury properties for sale, luxury homes in India', 'Discover the exquisite properties of FTV Real Estate. Immerse the versatility & beauty of our projects. Visit our website to explore our lavish properties.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 'michel-adam', 'Meet the Founder & the Chairman of Fashion TV - Michel Adams', 'real estate sites in India, best property websites in India, best real estate websites in India, get a real estate license, house for sale in India, best real estate companies, real estate opportunities, residential properties, types of real estate agents', 'Walk through the life journey of the founder & the chairman of Fashion TV, Mr. Michel Adam, with us. Explore our website to know more about him. ', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 'kashiff-khan', 'Our Managing Director of Fashion TV India - Mr. Kashiff Khan', 'ftv bar franchise India, real estate license in india, top real estate companies in india, buy a property, most luxurious house in india, fully furnished flat, co work spaces, luxury malls in india, luxury hotels in india', 'Mr. Kashiff Khan is the managing director of Fashion TV. He is also known as an expert author, writing & start-up specialist. Visit us to know him better. ', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 'fashiontv', 'World\'s Renowned Fashion & Luxurious Channel | Fashion TV ', 'real estate license in India, property websites in India, real estate companies in India, luxury homes in India, real estate sites in India, best property websites in India, top real estate companies in India,', 'Fashion TV is a whole realm where fashion & glamour meets. In India, we are collaborating with entrepreneurs to launch multiple business opportunities. Call us today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 'faq', 'Answers to All Your Real Estate Related Queries with FTV', 'real estate sites in India, best property websites in India, best real estate websites in India, get a real estate license, house for sale in India, best real estate companies, real estate opportunities, residential properties, types of real estate agents', 'Find solutions to all real estate-related queries on FTV Real Estate\'s FAQ page. Discover valuable insights into real estate opportunities. Contact us today!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 'contact-us', 'Contact Us for All of Your Real Estate Assistance', 'ftv bar franchise India, real estate license in india, top real estate companies in india, buy a property, most luxurious house in india, fully furnished flat, co work spaces, luxury malls in india, luxury hotels in india', 'Let us help you to find the best license that fits your expertise with our assistance. In case of any queries or want to sign up? Call us!', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 'brand-value-enhancer', 'Learn Possibilities of Recognition with FTV Value Enhancer', 'buy property in India, best real estate companies, buy house in India, most luxurious house in India, luxury villa price in India, fully furnished flat, fully furnished apartments, furnished suites', 'Know the tricks of the trade when you develop an FTV outlet within the mall. Curate experiences that enhance the value of the mall. Know more about us today.', 0, '2023-06-08 16:56:22', NULL, NULL),
(21, 'privacy-policy', 'Read the Privacy Policies of Fashion TV India', 'best property websites in India, top real estate companies in India, real estate license in India, real estate companies in India, luxury homes in India, real estate sites in india, residential properties', 'Read the privacy policies of Fashion TV India, which were effective as of Nov 2019. Learn how we collect, use & disclose our user\'s personal information.', 0, '2023-06-08 16:58:07', NULL, NULL),
(22, 'terms-and-conditions', 'Terms & Conditions for Fashion TV India', 'real estate license in India, property websites in India, real estate companies in India, luxury homes in India, real estate sites in India, best property websites in India, top real estate companies in India,', 'Read the terms & conditions of Fashion TV India, which indicate the rules & regulations which need to be followed by the user while using our platform.', 0, '2023-06-09 16:44:50', NULL, NULL),
(23, 'blogs', 'Insights For Real Estate Enthusiasts With FTV Real Estate', 'best real estate companies, buy a property, buy property in India, get a real estate license, real estate opportunities, residential properties, luxury properties, real estate license in india', 'Get expert insights, tips & trends on buying and licensing a property. Explore our captivating real estate stories of Fashion TV Real Estate. Call us today!', 0, '2023-06-13 15:15:29', NULL, NULL);

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL,
  `email` varchar(128) NOT NULL,
  `unsubscribed` int(11) NOT NULL DEFAULT 0 COMMENT '0=Subscribe,1=unsubscribe',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0 COMMENT '0=Active,1=Inactive',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `name`, `slug`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'F Residences', 'residences', 0, '2023-11-06 12:44:17', NULL, NULL),
(2, 'F Villas', 'villas', 0, '2023-11-06 12:45:32', NULL, NULL),
(3, 'F Furnished Apartments', 'furnished-apartments', 0, '2023-11-06 12:45:32', NULL, NULL);

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

--
-- Table structure for table `philosophy`
--

CREATE TABLE `philosophy` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `philosophy_type` varchar(128) NOT NULL,
  `p_info` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `philosophy`
--

INSERT INTO `philosophy` (`id`, `p_id`, `philosophy_type`, `p_info`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'vision', 'To bring India to par with international luxury residential standards, reproducing architectural designs, the lifestyle and amenities and giving impeccable value for money.', 0, '2023-11-06 13:03:24', NULL, NULL),
(2, 1, 'mission', 'To create an uber-rich residential experience in the long run that brings stability and panache and makes a statement when you divulge your residence. ', 0, '2023-11-06 13:03:24', NULL, NULL),
(3, 1, 'aim', 'To create India’s most fashionable and luxurious residential brand that establishes itself as a benchmark in the Luxurious Real Estate Segment.', 0, '2023-11-06 13:03:24', NULL, NULL),
(4, 2, 'vision', 'To transform India into a leading destination for all types of staycation experiences and bring the luxury residences industry of India to par with international standards.', 0, '2023-11-06 13:14:47', NULL, NULL),
(5, 2, 'mission', 'To create a marvellous luxury residences experience that oozes luxury and sophistication in every inch of its design.', 0, '2023-11-06 13:14:47', NULL, NULL),
(6, 2, 'aim', 'To establish FTV luxury residencies with India\'s most fashionable luxury and lifestyle brand and set a new benchmark in the hospitality Industry.', 0, '2023-11-06 13:14:47', NULL, NULL),
(7, 3, 'vision', 'To bring India at par with the International Real Estate Industry standards by transforming the country into a leading destination for top notch apartments that adapts to the needs of every type of customer.', 0, '2023-11-06 13:26:31', NULL, NULL),
(8, 3, 'mission', 'To create a living experience that compiles luxury, sophistication and the feeling of a home all in a single package giving its guests unforgettable memories.', 0, '2023-11-06 13:26:31', NULL, NULL),
(9, 3, 'aim', 'To create India’s most fashionable Real Estate Brand that starts to establish itself as a benchmark in the Housing Industry.', 0, '2023-11-06 13:26:31', NULL, NULL);

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `poster` varchar(128) NOT NULL,
  `desktop` varchar(128) NOT NULL,
  `mobile` varchar(128) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `p_id`, `poster`, `desktop`, `mobile`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'residences-poster.jpg', 'residences-desk.mp4', 'residences-mob.mp4', 0, '2023-11-06 13:04:13', NULL, NULL),
(2, 2, 'villa-poster.png', 'Real-estate-7.mp4', 'Real-estate-mob-7.mp4', 0, '2023-11-06 13:17:10', NULL, NULL),
(3, 3, 'f-apartment-poster.png', 'furnished-desk.mp4', 'furnished-mob.mp4', 0, '2023-11-06 13:27:04', NULL, NULL);

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

--
-- Indexes for table `downloads`
--
ALTER TABLE `downloads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dk_key` (`p_id`);

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

--
-- Indexes for table `features`
--
ALTER TABLE `features`
  ADD PRIMARY KEY (`id`),
  ADD KEY `f_key` (`p_id`);

--
-- Indexes for table `header_urls`
--
ALTER TABLE `header_urls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hk_key` (`p_id`);

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `m_key` (`p_id`);

--
-- Indexes for table `introduction`
--
ALTER TABLE `introduction`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ik_fk` (`p_id`);

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

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

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

--
-- Indexes for table `philosophy`
--
ALTER TABLE `philosophy`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pk_key` (`p_id`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vk_key` (`p_id`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `downloads`
--
ALTER TABLE `downloads`
  ADD CONSTRAINT `dk_key` FOREIGN KEY (`p_id`) REFERENCES `pages` (`id`);

--
-- Constraints for table `features`
--
ALTER TABLE `features`
  ADD CONSTRAINT `f_key` FOREIGN KEY (`p_id`) REFERENCES `pages` (`id`);

--
-- Constraints for table `header_urls`
--
ALTER TABLE `header_urls`
  ADD CONSTRAINT `hk_key` FOREIGN KEY (`p_id`) REFERENCES `pages` (`id`);

--
-- Constraints for table `images`
--
ALTER TABLE `images`
  ADD CONSTRAINT `m_key` FOREIGN KEY (`p_id`) REFERENCES `pages` (`id`);

--
-- Constraints for table `introduction`
--
ALTER TABLE `introduction`
  ADD CONSTRAINT `ik_fk` FOREIGN KEY (`p_id`) REFERENCES `pages` (`id`);

--
-- Constraints for table `philosophy`
--
ALTER TABLE `philosophy`
  ADD CONSTRAINT `pk_key` FOREIGN KEY (`p_id`) REFERENCES `pages` (`id`);

--
-- Constraints for table `videos`
--
ALTER TABLE `videos`
  ADD CONSTRAINT `vk_key` FOREIGN KEY (`p_id`) REFERENCES `pages` (`id`);
COMMIT;

