-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 28, 2024 at 03:50 PM
-- Server version: 8.0.36
-- PHP Version: 8.1.27

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

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

--
-- Table structure for table `attractions`
--

CREATE TABLE `attractions` (
  `id` int NOT NULL,
  `title` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_general_ci,
  `image` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `url` text COLLATE utf8mb4_general_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `attractions`
--

INSERT INTO `attractions` (`id`, `title`, `description`, `image`, `url`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Honeymoon Beach', '&lt;p&gt;Honeymoon Beach is both convenient and out-of-the-way, a good choice for those who want to avoid the crowds at spots like Trunk Bay, but still, appreciate a few on-site amenities.&lt;/p&gt;\r\n', '87513544278506_Viator_Thinkstock_167293.jpg', '', 1, '2024-06-25 01:02:35', '2024-06-25 01:05:16'),
(2, 'Hawksnest Bay', '&lt;p&gt;One of the most beautiful and most convenient beaches on St John, Hawksnest Bay is a favorite for families with children and visitors coming from the ferry docks at Cruz Bay.&lt;/p&gt;\r\n', '96337071lo.jpg', '', 1, '2024-06-27 11:30:17', NULL),
(3, 'Trunk Bay', '&lt;p&gt;The U.S. Postal Service put it on a stamp, Cond&amp;eacute; Nast Traveler called it one of the top 10 beaches in the world, National Geographic declared it without equal: Trunk Bay.&lt;/p&gt;\r\n', '39201722TrunkBay.jpg', '', 1, '2024-06-27 11:30:54', NULL);

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

--
-- Table structure for table `contact_form`
--

CREATE TABLE `contact_form` (
  `id` int NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hear_us` text COLLATE utf8mb4_general_ci,
  `message` text COLLATE utf8mb4_general_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `icalurls`
--

CREATE TABLE `icalurls` (
  `id` int NOT NULL,
  `property_id` int DEFAULT NULL,
  `calurl` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `calid` int NOT NULL,
  `status` enum('Active','In-Active') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Active',
  `added_date` datetime NOT NULL,
  `updated_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `page_data`
--

CREATE TABLE `page_data` (
  `id` int NOT NULL,
  `image` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `heading` text COLLATE utf8mb4_general_ci,
  `description` text COLLATE utf8mb4_general_ci,
  `description_extra` text COLLATE utf8mb4_general_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `page_data`
--

INSERT INTO `page_data` (`id`, `image`, `heading`, `description`, `description_extra`, `created_at`, `updated_at`) VALUES
(1, 'Tammy-Donnelly-About.jpg', 'Tammy Donnelly', '&lt;p&gt;If you&amp;rsquo;ve ever vacationed in an exotic location and wished you could stay forever, you&amp;rsquo;re not alone. Although it might seem unattainable, owning a piece of the rock can be your reality.&lt;/p&gt;\r\n\r\n&lt;p&gt;St. John is rich with history and culture. One of the most attractive aspects of St. John is the Virgin Islands National Park, which Laurance Rockefeller helped to establish in 1956. Since then, the VINP on St. John has grown to 7,200 acres plus 5,600 underwater acres. This equates to approximately 80 percent of the island remaining untouched, including pristine white sand beaches.&lt;/p&gt;\r\n\r\n&lt;p&gt;Visitors are attracted to this small island from all walks of life and from every part of the globe. Visitors and residents alike enjoy hiking trails, swimming, surfing, snorkeling, scuba diving, and sailing, along with an array of other outdoor activities.&lt;/p&gt;\r\n', '&lt;p&gt;Regardless of your budget, the brokers and sales agents of 340 Real Estate Co. can show and sell all the properties that are on the MLS whether it be Commercial properties, Residential homes, Land, or Condos. We have an up to date comprehensive online database of all the properties for sale on the St John Board of Realtors MLS as well as a database of St John Real Estate Sales History, including MLS Homes, Land, and Condos sold on St John since 2009!&lt;/p&gt;\r\n\r\n&lt;p&gt;Whether it be for a week or a lifetime, contact us today and let us put our collective 50-plus years of real estate experience to work, helping you realize your dream of owning a piece of St John.&amp;rdquo;&lt;/p&gt;\r\n', NULL, '2024-06-27 03:35:26');

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

--
-- Table structure for table `propertyamenities`
--

CREATE TABLE `propertyamenities` (
  `id` int NOT NULL,
  `property_id` int DEFAULT NULL,
  `amenityname` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `amenities` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_general_ci,
  `multiple` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `added_date` datetime DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `propertyamenities`
--

INSERT INTO `propertyamenities` (`id`, `property_id`, `amenityname`, `amenities`, `description`, `multiple`, `status`, `added_date`, `updated_date`) VALUES
(1, NULL, 'House Rules', 'Check-in: 3:00 PM, Check-out: 10:00 AM, No parties/events, No smoking, No pets, Children allowed, Minimum age of primary renter: 25, Max guests: 6', NULL, 1, 1, '2024-06-27 11:11:06', NULL),
(2, NULL, 'Location Type', 'Ocean View. Water View', NULL, 1, 1, '2024-06-27 11:11:24', '2024-06-28 03:37:31'),
(3, NULL, 'Bedrooms', '4 Bedrooms, 8 Sleeps, 4 King Beds', NULL, 1, 1, '2024-06-27 11:11:42', '2024-06-28 03:38:01'),
(4, NULL, 'Bathrooms', '3 Bathrooms, 1 Half Bath', NULL, 1, 1, '2024-06-27 11:11:57', '2024-06-28 03:38:19'),
(5, NULL, 'Safety Features', 'Smoke detector, Fire extinguisher, Exterior lighting, First-aid kit, Deadbolt lock', NULL, 1, 1, '2024-06-27 11:12:22', '2024-06-28 03:38:37'),
(6, NULL, 'General', 'Air Conditioning, Satellite or Cable, Washer &amp; Dryer, Children Welcome, Internet Parking, Swimming pool, Linens Provided, Washing Machine, Clothes Dryer, Towels Provided, Wireless Internet, Hair Dryer, Paper Towels, Shampoo, Toilet Paper, Living Room', NULL, 1, 0, '2024-06-27 11:14:29', '2024-06-28 03:39:27'),
(7, NULL, 'Kitchen', 'Dishwasher, Refrigerator, Stove, Oven, Microwave, Grill, Coffee Maker, Toaster, Blender, Pantry Items, Dishes &amp; Utensils', NULL, 1, 1, '2024-06-27 11:15:31', '2024-06-28 03:41:21'),
(8, NULL, 'Dining', 'Dining Room, Dining Area, Dining Table (Seating for 6 people)', NULL, 1, 1, '2024-06-27 11:15:56', NULL),
(9, NULL, 'Entertainment', 'Television, Satellite / Cable', NULL, 1, 1, '2024-06-27 11:16:11', NULL),
(10, NULL, 'Outside', 'Outdoor furniture,Beach chairs,Beach towels,Water sports gear', NULL, 1, 1, '2024-06-27 11:16:44', '2024-06-28 02:57:36'),
(11, NULL, 'Pool / Spa', 'Private Pool,Outdoor Pool,Heated Pool,Swimming Pool\r\n', NULL, 1, 1, '2024-06-27 11:17:00', '2024-06-28 02:57:00'),
(12, NULL, 'Onsite Services', 'Massage, Private Chef, Concierge', NULL, 1, 1, '2024-06-27 11:17:18', NULL),
(14, NULL, 'Spaces', 'Balcony,Deck/patio,Dining area,Lawn/garden,Outdoor play area,Porch/veranda\r\n', NULL, 1, 1, '2024-06-28 02:54:16', NULL),
(15, NULL, 'Baby &amp; toddler', 'Games for kids,Toys,Books for kids,Dishes &amp; utensils for kids', NULL, 1, 1, '2024-06-28 02:58:25', '2024-06-28 02:59:10'),
(16, NULL, 'Laundry', 'Washing machine,Clothes dryer,Iron &amp; board', NULL, 1, 1, '2024-06-28 02:59:03', NULL),
(17, NULL, 'Parking', 'Parking Available ', NULL, 1, 1, '2024-06-28 02:59:41', NULL),
(18, NULL, 'Safety', 'Deadbolt lock,Fire extinguisher,Exterior lighting,Safe,Fenced pool', NULL, 1, 1, '2024-06-28 03:00:19', '2024-06-28 03:00:26'),
(19, NULL, 'Nearby Activities', 'Swimming, Water sports,Sailing, Water tubing, Water skiing, Snorkeling, Jet skiing, Boating, Paddle boating, Kayaking, Surfing,Windsurfing, Parasailing, Hiking, Mountain biking, Horseback riding, Health/beauty spa, Shopping, Duty free shops,Whale watching, Ecotourism, Wildlife viewing, Birdwatching, Fishing, Bay/sound, Marina, Gambling casinos', NULL, 1, 1, '2024-06-28 03:03:33', NULL);

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

--
-- Table structure for table `propertybookingdates`
--

CREATE TABLE `propertybookingdates` (
  `id` int NOT NULL,
  `property_id` int DEFAULT NULL,
  `startdate` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `enddate` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `type` mediumtext COLLATE utf8mb4_general_ci NOT NULL,
  `calid` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `added_date` date NOT NULL,
  `updated_date` datetime DEFAULT NULL,
  `status` enum('Active','In-Active') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `propertyenquires`
--

CREATE TABLE `propertyenquires` (
  `id` int NOT NULL,
  `property_id` int DEFAULT NULL,
  `checkin` date DEFAULT NULL,
  `checkout` date DEFAULT NULL,
  `adults` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_general_ci,
  `message` longtext COLLATE utf8mb4_general_ci,
  `added_date` datetime NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `propertyrates`
--

CREATE TABLE `propertyrates` (
  `id` int NOT NULL,
  `property_id` int DEFAULT NULL,
  `seasonname` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `fromdate` date NOT NULL,
  `todate` date NOT NULL,
  `minimumstay` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `minimumpersons` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nightly` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `weekend` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `weekly` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `added_date` datetime NOT NULL,
  `updated_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `propertyrates`
--

INSERT INTO `propertyrates` (`id`, `property_id`, `seasonname`, `fromdate`, `todate`, `minimumstay`, `minimumpersons`, `nightly`, `weekend`, `weekly`, `monthly`, `status`, `added_date`, `updated_date`) VALUES
(1, NULL, 'In Season', '2024-01-03', '2024-04-14', '7', '8', '140', '', '4200', '', 1, '2024-06-27 11:46:57', '2024-06-28 03:35:42'),
(2, NULL, 'Off Season', '2024-04-15', '2024-12-19', '7', '8', '150', '', '3150', '', 1, '2024-06-27 11:46:57', '2024-06-28 03:34:53'),
(3, NULL, 'Christmas And New Year’s', '2024-12-20', '2025-01-02', '7', '8', '170', '', '4900', '', 1, '2024-06-27 11:46:57', '2024-06-28 03:36:39');

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

--
-- Table structure for table `propertyreviews`
--

CREATE TABLE `propertyreviews` (
  `id` int NOT NULL,
  `property_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `staydate` date NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `star` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `added_date` datetime NOT NULL,
  `updated_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `propertyreviews`
--

INSERT INTO `propertyreviews` (`id`, `property_id`, `name`, `title`, `description`, `image`, `staydate`, `email`, `star`, `status`, `added_date`, `updated_date`) VALUES
(1, NULL, 'Sven T.', 'Best vacation ever', 'I love the island of St. John. We had not been back in about 10 years, and had never been in the Fish Bay area. We loved the house and staying on this side of the island. The view was amazing and peaceful, and the house was everything we needed. We would definitely stay again', NULL, '2024-04-22', '', 5, 1, '2024-06-27 11:22:16', NULL);

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

--
-- Table structure for table `propertytype`
--

CREATE TABLE `propertytype` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `added` datetime NOT NULL,
  `updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `propertytype`
--

INSERT INTO `propertytype` (`id`, `name`, `status`, `added`, `updated`) VALUES
(1, 'House', 1, '2024-06-24 00:00:00', '0000-00-00 00:00:00'),
(2, 'Condo', 1, '2020-09-02 00:00:00', '2024-06-24 00:00:00'),
(3, 'Apartment', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(4, 'Bungalow', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(5, 'Cabin', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(6, 'Cottage', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(7, 'Studio', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(8, 'Townhouse', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(9, 'Villa', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(10, 'Resort', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(11, 'Hotel', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(12, 'Guest house', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(13, 'Lodge', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(14, 'Chalet', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(15, 'Caravan', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(16, 'Estate', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(17, 'Farmhouse', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(18, 'Bed & breakfast', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(19, 'Country house', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(20, 'Boat', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(21, 'Barn', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(22, 'Houseboat', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(23, 'Yacht', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(24, 'Tower', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(25, 'Castle', 1, '2020-09-02 00:00:00', '0000-00-00 00:00:00'),
(26, 'Penthouse', 1, '2023-03-02 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `property_gallery_list`
--

CREATE TABLE `property_gallery_list` (
  `id` int NOT NULL,
  `property_id` int DEFAULT NULL,
  `image` text COLLATE utf8mb4_general_ci NOT NULL,
  `image_title` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `property_gallery_list`
--

INSERT INTO `property_gallery_list` (`id`, `property_id`, `image`, `image_title`, `created_at`, `updated_at`) VALUES
(1, NULL, 'fce853551a44e38c432f2d182fd1be89_image.jpg', NULL, '2024-06-28 03:32:38', NULL),
(2, NULL, '4d4edd08be4b00185cd1d71fc2dabe74_image.jpg', NULL, '2024-06-28 03:32:38', NULL),
(3, NULL, 'bb33ebb7ec7c78e100c4e315b529da33_image.jpg', NULL, '2024-06-28 03:32:38', NULL),
(4, NULL, 'a469d2e274a0cdea6a5f9491c0d8fad4_image.jpg', NULL, '2024-06-28 03:32:38', NULL),
(5, NULL, 'af16b98be61e760d4c5d67a6edd2ee48_image.jpg', NULL, '2024-06-28 03:32:38', NULL),
(6, NULL, 'f6bd560c632a7acd516e65d65e7315a9_image.jpg', NULL, '2024-06-28 03:32:38', NULL),
(7, NULL, 'b8a223bc58df74a37e30bbeb851d4d44_image.jpg', NULL, '2024-06-28 03:32:38', NULL),
(8, NULL, '71232e66a4ad787b0498d860c4c3c3a8_image.jpg', NULL, '2024-06-28 03:32:52', NULL),
(9, NULL, 'c50fcc96cae87be6de0c6662af0f4396_image.jpg', NULL, '2024-06-28 03:32:52', NULL),
(10, NULL, 'e559deea060f76aff45bbebd7ce2b9fb_image.jpg', NULL, '2024-06-28 03:32:52', NULL),
(11, NULL, 'e9a2da97f9a3c4dbb03ba72610755580_image.jpg', NULL, '2024-06-28 03:32:52', NULL),
(12, NULL, '3d5f911c69e11166925de208294888de_image.jpg', NULL, '2024-06-28 03:32:52', NULL),
(13, NULL, 'e39980386f286ae20bdc0919d65a58a4_image.jpg', NULL, '2024-06-28 03:33:04', NULL),
(14, NULL, '34ffc56133e794d709e8e326d9860c88_image.jpg', NULL, '2024-06-28 03:33:04', NULL),
(15, NULL, '85610d3ed3fc8e1fd154f5c22e6d88a6_image.jpg', NULL, '2024-06-28 03:33:04', NULL),
(16, NULL, 'cac6d8703dfafb4774081aeda8ca6978_image.jpg', NULL, '2024-06-28 03:33:04', NULL),
(17, NULL, '94be5fe8e67c700b434b717e23ba9f0c_image.jpg', NULL, '2024-06-28 03:33:04', NULL);

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

--
-- Table structure for table `property_list`
--

CREATE TABLE `property_list` (
  `id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` int NOT NULL,
  `slug` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price` int DEFAULT NULL,
  `video_id` text COLLATE utf8mb4_general_ci,
  `max_rooms` int DEFAULT NULL,
  `beds` int DEFAULT NULL,
  `is_avaliable` tinyint(1) NOT NULL DEFAULT '1',
  `guest` int DEFAULT NULL,
  `rules` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bath` int DEFAULT NULL,
  `min_stay` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `max_stay` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `smoking` tinyint(1) NOT NULL DEFAULT '1',
  `pets` tinyint(1) NOT NULL DEFAULT '1',
  `children` tinyint(1) NOT NULL DEFAULT '1',
  `events` tinyint(1) NOT NULL DEFAULT '1',
  `description` text COLLATE utf8mb4_general_ci,
  `address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `location_url` text COLLATE utf8mb4_general_ci,
  `zipcode` int DEFAULT NULL,
  `check_in_time` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `check_out_time` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `facebook_link` text COLLATE utf8mb4_general_ci,
  `twitter_link` text COLLATE utf8mb4_general_ci,
  `youtube_link` text COLLATE utf8mb4_general_ci,
  `instagram_link` text COLLATE utf8mb4_general_ci,
  `copyright_text` text COLLATE utf8mb4_general_ci,
  `rate_note` text COLLATE utf8mb4_general_ci,
  `admin_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cleaning_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `refundable_damage_deposit_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `damage_waiver_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pet_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extra_person_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tax` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `service_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `change_over` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pool_heating_fee` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `updated_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `property_list`
--

INSERT INTO `property_list` (`id`, `title`, `type`, `slug`, `area`, `price`, `video_id`, `max_rooms`, `beds`, `is_avaliable`, `guest`, `rules`, `bath`, `min_stay`, `max_stay`, `smoking`, `pets`, `children`, `events`, `description`, `address`, `location_url`, `zipcode`, `check_in_time`, `check_out_time`, `facebook_link`, `twitter_link`, `youtube_link`, `instagram_link`, `copyright_text`, `rate_note`, `admin_fee`, `cleaning_fee`, `refundable_damage_deposit_fee`, `damage_waiver_fee`, `pet_fee`, `extra_person_fee`, `tax`, `service_fee`, `change_over`, `pool_heating_fee`, `created_on`, `updated_on`) VALUES
(1, 'The Ocean View Villa', 9, NULL, NULL, NULL, '0h0LBi8AN5A', NULL, 4, 1, 8, NULL, 3, NULL, '7', 1, 1, 1, 1, '<p>Bordering National Park land this quiet end of the road location offers privacy yet only approximately 10 minutes to Cruz Bay. 2 bedrooms with AC are located on main level with 1.5 bathrooms, spacious great room and covered and uncovered deck to enjoy the view and breezes. The lower level has full AC with 2 bedroom / 2 bathrooms and full kitchen / dining living room. Flat ample parking for easy access to this home is a plus!</p>\r\n', NULL, NULL, NULL, '', '', '', '', '', '', '© 2024 oceanviewvillastjohn.com. All Rights Reserved.', '<p>Holiday rates. Dec. 19 through Jan. 3 &ndash; $6000.00/wk + 12.5% Tax</p>\r\n\r\n<p>Other Holiday Rates vary; please call for specific weeks.</p>\r\n', '', '', '', '', '', '', '13', '10', '', '', '2024-06-25 02:12:06', '2024-06-28 03:24:50');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int NOT NULL,
  `mail_from_name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_from` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_to_name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_to` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `mail_from_name`, `mail_from`, `mail_to_name`, `mail_to`, `updated_at`) VALUES
(1, 'southernexposurevillastjohn', '360realestateco@gmail.com', 'southernexposurevillastjohn', '360realestateco@gmail.com', '2024-06-28 12:12:29');

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

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

CREATE TABLE `slider` (
  `id` int NOT NULL,
  `title` varchar(250) COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `slider` (`id`, `title`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'The Ocean View Villa', '858464951-1.jpg', 1, '2024-06-28 03:32:05', NULL),
(2, 'The Ocean View Villa', '922489852-1.jpg', 1, '2024-06-28 03:32:13', NULL),
(3, 'The Ocean View Villa', '623092083-1.jpg', 1, '2024-06-28 03:32:19', NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `screen_name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `user_type` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `upload_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `screen_name`, `email`, `user_type`, `password`, `phone`, `upload_date`) VALUES
(1, 'mayank_gupta', 'Mayank Gupta', 'mg959180@gmail.com', 'admin', '$2y$10$Jo6BwVhtMKtpfnUTYt.ZKulZGU7pNBsUM3e8U7EUAMPUrX82OahlO', NULL, '2024-06-26 18:16:37');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attractions`
--
ALTER TABLE `attractions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `contact_form`
--
ALTER TABLE `contact_form`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `icalurls`
--
ALTER TABLE `icalurls`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `page_data`
--
ALTER TABLE `page_data`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `propertyamenities`
--
ALTER TABLE `propertyamenities`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `propertybookingdates`
--
ALTER TABLE `propertybookingdates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `propertyenquires`
--
ALTER TABLE `propertyenquires`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `propertyrates`
--
ALTER TABLE `propertyrates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `propertyreviews`
--
ALTER TABLE `propertyreviews`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `propertytype`
--
ALTER TABLE `propertytype`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `property_gallery_list`
--
ALTER TABLE `property_gallery_list`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `property_list`
--
ALTER TABLE `property_list`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;
