-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 18, 2025 at 09:01 AM
-- Server version: 10.6.23-MariaDB
-- PHP Version: 8.4.13

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

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

--
-- Table structure for table `cabana_type`
--

CREATE TABLE `cabana_type` (
  `cabana_type_id` varchar(15) NOT NULL,
  `cabana_type_name` varchar(100) NOT NULL,
  `cabana_image` varchar(100) NOT NULL,
  `cabana_description` text NOT NULL,
  `cabana_price` decimal(10,2) NOT NULL,
  `event_id` int(11) NOT NULL,
  `display_order` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cabana_type`
--

INSERT INTO `cabana_type` (`cabana_type_id`, `cabana_type_name`, `cabana_image`, `cabana_description`, `cabana_price`, `event_id`, `display_order`) VALUES
('1', 'Manatee Villa', 'manatee', '<p>To clarify, think of this property as a 3-room luxury, all-inclusive hotel.</p><p><b>Each accommodation includes completely separate living quarters. Three (3)  separate private accommodations with private bedroom and bath, Ocean front villa living.</b></p><p>Details:  Each mansion includes a large common living room, washer/dryer, loft, pool and Jacuzzi, private pool, and patio with an oceanfront location — three separate, totally private living quarters. \n\nConcierge and butler services are included.\n\nNOTE: Each accommodation is sold separately. You are not expected to book all units unless you have more than one couple in your group.</p><ul>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Outdoor Kitchen</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">TVs in every bedroom</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">High-speed Wifi</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Full-service kitchen</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Kayaks, paddle boards, bicycles</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Infinity Pool</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Hot Tub</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Palapa with hammocks</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Beach games/pool toys</li>\n</ul>', 4250.00, 102, 1),
('10', 'Dolphin Bungalow', 'dolphin', '', 0.00, 102, 10),
('11', 'Pelican Bungalow', 'pelican', '', 0.00, 102, 11),
('2', 'Turtle Villa', 'turtle', '1 Bedroom/bath Villa, Patio, Oceanfront Pool – Sleeps 2 – $4,050/person/week', 4050.00, 102, 2),
('3', 'Seahorse Villa', 'seahorse', '<p>To clarify, think of this property as a 3-room luxury, all-inclusive hotel.</p><p><b>Each accommodation includes completely separate living quarters. Three (3)  separate private accommodations with private bedroom and bath, Ocean front villa living.</b></p><p>Details:  Each mansion includes a large common living room, washer/dryer, loft, pool and Jacuzzi, private pool, and patio with an oceanfront location — three separate, totally private living quarters. \n\nConcierge and butler services are included.\n\nNOTE: Each accommodation is sold separately. You are not expected to book all units unless you have more than one couple in your group.</p><ul>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Outdoor Kitchen</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">TVs in every bedroom</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">High-speed Wifi</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Full-service kitchen</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Kayaks, paddle boards, bicycles</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Infinity Pool</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Hot Tub</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Palapa with hammocks</li>\n<li data-asw-orgfontsize=\"18\" data-asw-modified=\"font-size\" style=\"font-size: 18px !important;\">Beach games/pool toys</li>\n</ul>', 4250.00, 102, 3),
('4', 'Hummingbird Apartment', 'hummingbird', '<p class=\"fw-bold\"><b>1 Private bedroom and bath apartment.</b></p>\n<p class=\"fw-bold\"><b>The apartment includes a private bedroom and bath shown above on the ground floor. A living room (upper image), patio and kitchen are adjacent to the living area on the ground floor.  Sleeps 2 in the ground floor bedroom – $3,850/person/week</b></p>\n', 3850.00, 102, 4),
('5', 'Crab, Stingray and Jellyfish Bungalow', '', 'Crab, Stingray, Jellifish', 3250.00, 102, 5),
('6', 'Marlin, Whale Shark Bungalow', '', 'Separate private bedrooms/private baths + living room – $29850/person/week', 4000.00, 102, 6),
('7', 'Coral, Seashell Bungalow', '', 'Separate private bedrooms/private baths +living room – $2,950/person/week,', 2950.00, 102, 7),
('8', 'Star Fish Bungalow', 'starfish', '', 0.00, 102, 8),
('9', 'Sand Dollar, Lobster Bungalow', '', '', 0.00, 102, 9);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cabana_type`
--
ALTER TABLE `cabana_type`
  ADD PRIMARY KEY (`cabana_type_id`,`event_id`) USING BTREE;
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 */;
