-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 17, 2022 at 05:05 AM
-- Server version: 10.3.36-MariaDB-log
-- PHP Version: 7.4.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `crmdemo_webhook`
--

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

--
-- Table structure for table `bookdata`
--

CREATE TABLE `bookdata` (
  `id` int(11) NOT NULL,
  `event` varchar(64) NOT NULL,
  `property_code` varchar(64) NOT NULL,
  `property_name` varchar(256) NOT NULL,
  `checked_in` time(6) NOT NULL,
  `checked_out` time(6) NOT NULL,
  `first_name` varchar(128) NOT NULL,
  `last_name` varchar(128) NOT NULL,
  `email` varchar(64) NOT NULL,
  `estimated_arrival` time(6) NOT NULL,
  `estimated_departure` time(6) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `cancelled` bit(6) NOT NULL,
  `booking_date` date NOT NULL,
  `is_paid` bit(6) NOT NULL,
  `reference_num` varchar(32) NOT NULL,
  `currency_code` varchar(32) NOT NULL,
  `booking_channel` varchar(32) NOT NULL,
  `paid_amount` varchar(32) NOT NULL,
  `num_days` varchar(32) NOT NULL,
  `room_type_id` varchar(36) NOT NULL,
  `rateplanid` varchar(64) NOT NULL,
  `rate_plan` varchar(64) NOT NULL,
  `room_type` varchar(128) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bookdata`
--

INSERT INTO `bookdata` (`id`, `event`, `property_code`, `property_name`, `checked_in`, `checked_out`, `first_name`, `last_name`, `email`, `estimated_arrival`, `estimated_departure`, `start_date`, `end_date`, `cancelled`, `booking_date`, `is_paid`, `reference_num`, `currency_code`, `booking_channel`, `paid_amount`, `num_days`, `room_type_id`, `rateplanid`, `rate_plan`, `room_type`, `created_at`) VALUES
(1, 'reservation.new', 'XWO320', 'Demo Account', '00:00:00.000000', '00:00:00.000000', 'Jitendra', 'Dadhaniya', 'conscor@gmail.com', '00:00:00.000000', '00:00:00.000000', '2022-09-20', '2022-09-20', b'000000', '2022-09-16', b'000000', '634207776346', '', 'COCOTEL Direct', '0', '0', 'v0xku', '5f4889f0c635cb2982a1c70e', 'Non-Refundable', 'One Queen Bed', '2022-09-17 08:55:29'),
(2, 'reservation.new', 'XWO320', 'Demo Account', '00:00:00.000000', '00:00:00.000000', 'Rutvi', 'Patel', 'conscor@gmail.com', '00:00:00.000000', '00:00:00.000000', '2022-09-20', '2022-09-20', b'000000', '2022-09-16', b'000000', '634207776346', '', 'COCOTEL Direct', '0', '0', 'v0xku', '5f4889f0c635cb2982a1c70e', 'Non-Refundable', 'One Queen Bed', '2022-09-17 08:55:29'),
(3, 'reservation.new', 'XWO320', 'Demo Account', '00:00:00.000000', '00:00:00.000000', 'Dhara', 'Patel', 'dhara@gmail.com', '00:00:00.000000', '00:00:00.000000', '2022-09-20', '2022-09-20', b'000000', '2022-09-16', b'000000', '634207776346', '', 'COCOTEL Direct', '0', '0', 'v0xku', '5f4889f0c635cb2982a1c70e', 'Non-Refundable', 'One Queen Bed', '2022-09-17 08:55:29'),
(4, 'reservation.new', 'XWO320', 'Demo Account', '00:00:00.000000', '00:00:00.000000', 'Bhumi', 'Patel', 'bhumi@gmail.com', '00:00:00.000000', '00:00:00.000000', '2022-09-20', '2022-09-20', b'000000', '2022-09-16', b'000000', '634207776346', '', 'COCOTEL Direct', '0', '0', 'v0xku', '5f4889f0c635cb2982a1c70e', 'Non-Refundable', 'One Queen Bed', '2022-09-17 08:55:29'),
(5, 'reservation.new', 'XWO320', 'Demo Account', '00:00:00.000000', '00:00:00.000000', 'Nidhi', 'Patel', 'nishi@gmail.com', '00:00:00.000000', '00:00:00.000000', '2022-09-20', '2022-09-20', b'000000', '2022-09-16', b'000000', '634207776346', '', 'COCOTEL Direct', '0', '0', 'v0xku', '5f4889f0c635cb2982a1c70e', 'Non-Refundable', 'One Queen Bed', '2022-09-17 08:55:29'),
(6, 'reservation.new', 'XXP300', 'Miami Heat Beach Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'CHERRY', 'ROMERO', '', '00:00:00.000000', '00:00:00.000000', '2022-09-17', '2022-09-18', b'000000', '2022-09-17', b'000000', '456946617633', 'PHP', 'Direct', '0', '1', '', '', '', '', '2022-09-17 08:55:29'),
(7, 'reservation.new', 'XXP300', 'Miami Heat Beach Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'Wileen Alexandra', 'Nacu', '', '00:00:00.000000', '00:00:00.000000', '2022-09-18', '2022-09-19', b'000000', '2022-09-17', b'000000', '288250988637', 'PHP', 'MIAMI HEAT Direct', '0', '1', '', '', '', '', '2022-09-17 08:55:29'),
(8, 'reservation.new', 'XXP300', 'Miami Heat Beach Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'NOEL', 'BALAJADIA', '', '00:00:00.000000', '00:00:00.000000', '2022-09-23', '2022-09-25', b'000000', '2022-09-17', b'000000', '886346238979', 'PHP', 'Direct', '0', '2', '', '', '', '', '2022-09-17 08:55:29'),
(9, 'reservation.new', 'XXP300', 'Miami Heat Beach Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'NOEL', 'BALAJADIA', '', '00:00:00.000000', '00:00:00.000000', '2022-09-23', '2022-09-24', b'000000', '2022-09-17', b'000000', '537100861062', 'PHP', 'Direct', '0', '1', '', '', '', '', '2022-09-17 08:55:29'),
(10, 'reservation.new', 'XQE794', 'RSAM Beach Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'Rosemarie', 'Christy Manicad', '', '00:00:00.000000', '00:00:00.000000', '2022-09-24', '2022-09-25', b'000000', '2022-09-17', b'000000', '403307707667', 'PHP', 'CTrip', '0.00', '1', '', '', '', '', '2022-09-17 08:55:29'),
(11, 'reservation.new', 'XQE794', 'RSAM Beach Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'Rosemarie', 'Christy Manicad', '', '00:00:00.000000', '00:00:00.000000', '2022-09-24', '2022-09-25', b'000000', '2022-09-17', b'000000', '501157580132', 'PHP', 'CTrip', '0.00', '1', '', '', '', '', '2022-09-17 08:55:29'),
(12, 'reservation.change', 'XXP300', 'Miami Heat Beach Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'NOEL', 'BALAJADIA', '', '00:00:00.000000', '00:00:00.000000', '2022-09-23', '2022-09-25', b'000000', '2022-09-17', b'000000', '537100861062', 'PHP', 'Direct', '0', '2', '', '', '', '', '2022-09-17 08:55:29'),
(13, 'reservation.new', 'XIS556', 'El Pueblo De Hermano Resort by Cocotel', '00:00:00.000000', '00:00:00.000000', 'Sophia', 'Galang', '', '00:00:00.000000', '00:00:00.000000', '2022-09-17', '2022-09-18', b'000000', '2022-09-17', b'000000', '705430250206', 'PHP', 'CTrip', '0.00', '1', '', '', '', '', '2022-09-17 08:55:29'),
(14, 'reservation.new', 'XWO320', 'Demo Account', '00:00:00.000000', '00:00:00.000000', 'Pinal', 'Patel', 'pinal@gmail.com', '00:00:00.000000', '00:00:00.000000', '2022-09-20', '2022-09-20', b'000000', '2022-09-16', b'000000', '634207776346', '', 'COCOTEL Direct', '0', '0', 'v0xku', '5f4889f0c635cb2982a1c70e', 'Non-Refundable', 'One Queen Bed', '2022-09-17 08:55:29');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bookdata`
--
ALTER TABLE `bookdata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
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 */;
