-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 16, 2025 at 02:11 AM
-- Server version: 10.6.23-MariaDB
-- PHP Version: 8.4.11

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

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

--
-- Table structure for table `cabanas`
--

CREATE TABLE `cabanas` (
  `cabana_id` varchar(25) NOT NULL,
  `cabana_name` varchar(100) NOT NULL,
  `cabana_type` varchar(5) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `booked_status` varchar(20) NOT NULL,
  `booked_time` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `session_id` varchar(100) NOT NULL,
  `aff_id` int(11) NOT NULL,
  `registration_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cabanas`
--

INSERT INTO `cabanas` (`cabana_id`, `cabana_name`, `cabana_type`, `price`, `booked_status`, `booked_time`, `event_id`, `session_id`, `aff_id`, `registration_id`) VALUES
('coral1', 'Coral 1', '7', 2950.00, 'booked', 1759755745, 102, 'fu3r6pk80ue2l1oo7dmirl12k3', 1, 7),
('coral2', 'Coral 2', '7', 2950.00, '', 0, 102, '', 0, 0),
('crab', 'Crab', '5', 3250.00, '', 0, 102, '', 0, 0),
('dolphin', 'Dolphin', '10', 3250.00, '', 0, 102, '', 0, 0),
('hummingbird', 'Hummingbird', '4', 3850.00, 'tmp_booked', 1760592417, 102, 'k0lnc749bnd1598g9l1f7i940l', 1, 0),
('jellyfish1', 'Jellyfish 1', '5', 2850.00, 'booked', 1759974621, 102, '058fbaqrdu986etv14vkr1hpbd', 1, 1),
('jellyfish2', 'Jellyfish 2', '5', 2850.00, '', 0, 102, '', 0, 0),
('lobster', 'Lobster', '9', 3250.00, '', 0, 102, '', 0, 0),
('manatee1', 'Manatee 1', '1', 4250.00, 'booked', 1760588366, 102, 'k0lnc749bnd1598g9l1f7i940l', 1, 5),
('manatee2', 'Manatee 2', '1', 4250.00, 'booked', 1760581464, 102, 'ifrdnlhdgadtbdceoc47sml4me', 1, 4),
('manatee3', 'Manatee 3', '1', 4250.00, 'booked', 1760588991, 102, 'k0lnc749bnd1598g9l1f7i940l', 1, 1),
('marlin', 'Marlin', '6', 2950.00, '', 0, 102, '', 0, 0),
('pelican', 'Pelican', '11', 0.00, '', 0, 102, '', 0, 0),
('sand-dollar1', 'Sand Dollar 1', '9', 2950.00, '', 0, 102, '', 0, 0),
('sand-dollar2', 'Sand Dollar 2', '9', 2950.00, '', 0, 102, '', 0, 0),
('seahorse1', 'Seahorse 1', '3', 4250.00, '', 0, 102, '', 0, 0),
('seahorse2', 'Seahorse 2', '3', 4250.00, '', 0, 102, '', 0, 0),
('seahorse3', 'Seahorse 3', '3', 4250.00, '', 0, 102, '', 0, 0),
('seashell', 'Seashell', '7', 2950.00, '', 0, 102, '', 0, 0),
('starfish', 'Starfish', '8', 3250.00, '', 0, 102, '', 0, 0),
('stingray', 'Stingray', '5', 3250.00, 'booked', 1759756387, 102, 'fu3r6pk80ue2l1oo7dmirl12k3', 1, 13),
('turtle', 'Turtle Villa', '2', 4050.00, 'booked', 1760455555, 102, 'irmnvs9tilus6vk8k3ocsb0eo0', 1, 2),
('whaleshark', 'Whaleshark', '6', 4000.00, '', 0, 102, '', 0, 0);

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

--
-- 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);

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

--
-- Table structure for table `island_events`
--

CREATE TABLE `island_events` (
  `id` int(11) NOT NULL,
  `eventtitle` varchar(255) NOT NULL DEFAULT '',
  `heading` text NOT NULL,
  `instruction` text NOT NULL,
  `eventstartdate` date NOT NULL DEFAULT '0000-00-00',
  `eventenddate` date NOT NULL DEFAULT '0000-00-00',
  `cus_field_1_name` varchar(255) NOT NULL DEFAULT '',
  `cus_field_2_name` varchar(255) NOT NULL DEFAULT '',
  `cus_field_3_name` varchar(255) NOT NULL DEFAULT '',
  `cus_field_1_req` int(11) NOT NULL DEFAULT 0,
  `cus_field_2_req` int(11) NOT NULL DEFAULT 0,
  `cus_field_3_req` int(11) NOT NULL DEFAULT 0,
  `imagefile` varchar(255) NOT NULL DEFAULT '',
  `deposit_amount` decimal(6,2) NOT NULL DEFAULT 0.00,
  `other_deposit` int(11) NOT NULL DEFAULT 0,
  `deposit_min` decimal(11,2) NOT NULL DEFAULT 0.00,
  `other_deposit_min` decimal(11,2) NOT NULL DEFAULT 0.00,
  `meta_keywords` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `activeuntil` date NOT NULL DEFAULT '0000-00-00',
  `successurl` varchar(255) NOT NULL DEFAULT '',
  `admin_email_1` varchar(100) NOT NULL,
  `admin_email_2` varchar(100) NOT NULL,
  `admin_email_3` varchar(100) NOT NULL,
  `admin_email_4` varchar(100) NOT NULL,
  `event_type` varchar(100) NOT NULL COMMENT 'package ID',
  `eventcost` decimal(11,2) NOT NULL,
  `vat` decimal(11,2) NOT NULL DEFAULT 0.00,
  `cancelpolicy` text NOT NULL,
  `minimumdiposit` varchar(100) NOT NULL,
  `tourdays` int(11) NOT NULL,
  `deposit_type` enum('AMOUNT','PERCENTAGE') NOT NULL DEFAULT 'AMOUNT',
  `transport_cost` double(7,2) NOT NULL,
  `transport_ground` decimal(5,2) NOT NULL,
  `transport_air` decimal(5,2) NOT NULL,
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `reminder_date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `island_events`
--

INSERT INTO `island_events` (`id`, `eventtitle`, `heading`, `instruction`, `eventstartdate`, `eventenddate`, `cus_field_1_name`, `cus_field_2_name`, `cus_field_3_name`, `cus_field_1_req`, `cus_field_2_req`, `cus_field_3_req`, `imagefile`, `deposit_amount`, `other_deposit`, `deposit_min`, `other_deposit_min`, `meta_keywords`, `meta_description`, `activeuntil`, `successurl`, `admin_email_1`, `admin_email_2`, `admin_email_3`, `admin_email_4`, `event_type`, `eventcost`, `vat`, `cancelpolicy`, `minimumdiposit`, `tourdays`, `deposit_type`, `transport_cost`, `transport_ground`, `transport_air`, `approved`, `created_by`, `reminder_date`) VALUES
(102, 'Belize Resort Takeover - Summer 2026', '<h1>Belize Resort Takeover - Summer 2026&nbsp;</h1>', '<h3>Welcome to Fantasies&nbsp;Island Vacations. Relax Unwind &amp; Smile</h3>\r\n<h2>Indulge in the fantasy you\\\'ve dreamed of, the warmth of the tropical sun , the coolness of the tropical island breeze. &nbsp;This is the five star island you have dream of where only you can set the limits of adventure. &nbsp;</h2>\r\n<p>We will supply the nightly themes to entice the evenings and five star cuisine to satisfy the soul.&nbsp;Let the drinks flow and the entertainment soar, it is time to celebrate a release from our everyday lives to the fantasy of be stranded on an island with up to 48 other like minded friends. Our Fantasies Island Takeovers will entice your evey sense.</p>\r\n<p>Fantasies Island Takeover Events are complete island takeovers for adult couples only (3 sums allowed). The Island is located just off the coast of Dangriga, Belize.</p>\r\n<p>The island rests on the second largest barrier reef in the world, so it is one of the best area in the world to scuba dive and go snorkeling. This is truly the paradise you have dreamed of. This 5 Star Resort offers luxurious accommodations and world class amenities. Indulge yourself with local meals and drinks.</p>\r\n<p>Explore the island or spend the day at the clothing optional beaches where turquoise water shimmers in the hot Belizean sun.</p>\r\n<p>&nbsp;</p>', '2026-06-13', '2026-06-20', '', '', '', 0, 0, 0, '', 500.00, 0, 0.00, 0.00, '', '', '0000-00-00', '', 'jennifer@castawaystravel.com', 'james@castawaystravel.com', '', '', '', 0.00, 0.00, '<p>Payment Plan</p>\r\n<ul>\r\n<li>Deposit by October 31, 2025 &ndash; 10%</li>\r\n<li>2nd Deposit on or before November 3, 2025 &ndash; 30%</li>\r\n<li>3rd Deposit on or before January 30, 2026 &ndash; 30% &ndash; Cancellation &ndash; 100%</li>\r\n<li>Final Payment on or before March 20, 2026 -Final 30% &ndash; Cancellation &ndash; 100%</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<h3 class=\"\\&quot;red_box\\&quot;\">Cancellation Policy/Fees</h3>\r\n<ul>\r\n<li>Cancellation after October 31 &ndash; $250/person</li>\r\n<li>Cancellation &ndash; 50% of payments made to date up to December 21, 2025</li>\r\n<li>All payments after December 21, 2025 &ndash; Non-refundable</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>', '500', 0, 'AMOUNT', 160.00, 0.00, 0.00, 0, 0, NULL);

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

--
-- Table structure for table `island_registrations`
--

CREATE TABLE `island_registrations` (
  `reg_id` bigint(20) NOT NULL,
  `event_id` int(11) NOT NULL DEFAULT 0,
  `traveler1` varchar(255) DEFAULT NULL,
  `traveler2` varchar(255) DEFAULT NULL,
  `bfname` varchar(50) NOT NULL DEFAULT '',
  `blname` varchar(50) NOT NULL DEFAULT '',
  `baddr1` varchar(100) NOT NULL DEFAULT '',
  `baddr2` varchar(100) NOT NULL DEFAULT '',
  `bcity` varchar(50) NOT NULL DEFAULT '',
  `bstate` varchar(50) NOT NULL DEFAULT '',
  `bzip` varchar(20) NOT NULL DEFAULT '',
  `bcountry` varchar(50) NOT NULL DEFAULT '',
  `phone` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `cctype` varchar(20) NOT NULL DEFAULT '',
  `cardnumber` varchar(255) NOT NULL DEFAULT '',
  `cvc` varchar(10) NOT NULL DEFAULT '',
  `cardexpiry` varchar(20) NOT NULL DEFAULT '',
  `policy_read` varchar(255) NOT NULL DEFAULT '',
  `cabana` varchar(50) NOT NULL DEFAULT '',
  `cabana_id` varchar(15) NOT NULL DEFAULT '',
  `comments` text NOT NULL,
  `regdate` datetime DEFAULT current_timestamp(),
  `aff_id` int(11) DEFAULT NULL,
  `transportation` varchar(10) NOT NULL,
  `transport_cost` decimal(5,2) NOT NULL,
  `total_amount` decimal(6,2) NOT NULL,
  `depositpercent` varchar(100) DEFAULT NULL,
  `depositamount` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cabanas`
--
ALTER TABLE `cabanas`
  ADD PRIMARY KEY (`cabana_id`,`event_id`) USING BTREE;

--
-- Indexes for table `cabana_type`
--
ALTER TABLE `cabana_type`
  ADD PRIMARY KEY (`cabana_type_id`,`event_id`) USING BTREE;

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

--
-- Indexes for table `island_registrations`
--
ALTER TABLE `island_registrations`
  ADD PRIMARY KEY (`reg_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `island_registrations`
--
ALTER TABLE `island_registrations`
  MODIFY `reg_id` bigint(20) NOT NULL AUTO_INCREMENT;
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 */;
