-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `castawaysres_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, 'booked', 1760721739, 102, 'b21b2b8e21b2dd58794d0f20e8df02b1', 1, 7),
('hummingbird', 'Hummingbird', '4', 3850.00, '', 0, 102, '', 0, 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, '', 0, 102, '', 0, 0),
('manatee2', 'Manatee 2', '1', 4250.00, 'booked', 1760377802, 102, '278ad3211059d05b425a152228a2670a', 1, 3),
('manatee3', 'Manatee 3', '1', 4250.00, '', 0, 102, '', 0, 0),
('marlin', 'Marlin', '6', 2950.00, '', 0, 102, '', 0, 0),
('pelican', 'Pelican', '11', 0.00, 'booked', 1760722060, 102, 'b21b2b8e21b2dd58794d0f20e8df02b1', 1, 9),
('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, 'booked', 1760721918, 102, 'b21b2b8e21b2dd58794d0f20e8df02b1', 1, 8),
('stingray', 'Stingray', '5', 3250.00, 'booked', 1759756387, 102, 'fu3r6pk80ue2l1oo7dmirl12k3', 1, 13),
('turtle', 'Turtle Villa', '2', 4050.00, 'booked', 1760377651, 102, '278ad3211059d05b425a152228a2670a', 1, 2),
('whaleshark', 'Whaleshark', '6', 4000.00, '', 0, 102, '', 0, 0);

--
-- Indexes for dumped tables
--

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

