-- 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', '

To clarify, think of this property as a 3-room luxury, all-inclusive hotel.

Each accommodation includes completely separate living quarters. Three (3) separate private accommodations with private bedroom and bath, Ocean front villa living.

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.

', 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', '

To clarify, think of this property as a 3-room luxury, all-inclusive hotel.

Each accommodation includes completely separate living quarters. Three (3) separate private accommodations with private bedroom and bath, Ocean front villa living.

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.

', 4250.00, 102, 3), ('4', 'Hummingbird Apartment', 'hummingbird', '

1 Private bedroom and bath apartment.

\n

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

\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 */;