-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 18, 2025 at 09:03 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 `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` int(11) NOT NULL DEFAULT 0,
  `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 '',
  `notify_email1` varchar(100) NOT NULL DEFAULT '',
  `notify_email2` varchar(100) NOT NULL DEFAULT '',
  `notify_email3` varchar(100) NOT NULL DEFAULT '',
  `notify_email4` varchar(100) NOT NULL DEFAULT '',
  `notify_email5` varchar(100) NOT NULL DEFAULT '',
  `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,
  `deposittype` varchar(30) NOT NULL,
  `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`, `other_deposit`, `deposit_min`, `other_deposit_min`, `meta_keywords`, `meta_description`, `activeuntil`, `successurl`, `notify_email1`, `notify_email2`, `notify_email3`, `notify_email4`, `notify_email5`, `event_type`, `eventcost`, `vat`, `cancelpolicy`, `minimumdiposit`, `tourdays`, `deposittype`, `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, '', 0, 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 – 10% </li>\r\n<li>2nd Deposit on or before November 3, 2025 – 30% </li>\r\n<li>3rd Deposit on or before January 30, 2026 – 30% – Cancellation – 100%</li>\r\n<li>Final Payment on or before March 20, 2026 -Final 30% – Cancellation – 100%</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<h3 class=\\\"red_box\\\">Cancellation Policy/Fees</h3>\r\n<ul>\r\n<li>Cancellation after October 31 – $250/person</li>\r\n<li>Cancellation – 50% of payments made to date up to December 21, 2025</li>\r\n<li>All payments after December 21, 2025 – Non-refundable</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n', '500', 0, '', 160.00, 0.00, 0.00, 0, 0, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `island_events`
--
ALTER TABLE `island_events`
  ADD PRIMARY KEY (`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=121;
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 */;
