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

START TRANSACTION;



--
-- Database: `servicedemoweb_aot`
--

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_02_10_212709_create_pick_up_locations_table', 2),
(6, '2023_02_10_212907_create_reservations_table', 2),
(7, '2023_02_10_232947_create_settings_table', 2);

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

--
-- Table structure for table `pick_up_locations`
--

CREATE TABLE `pick_up_locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('address','airport','casino') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'address',
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pick_up_locations`
--

INSERT INTO `pick_up_locations` (`id`, `type`, `value`, `created_at`, `updated_at`) VALUES
(1, 'address', 'Address 1', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(2, 'address', 'Address 2', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(3, 'address', 'Address 3', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(4, 'airport', 'Airport 1', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(5, 'airport', 'Airport 2', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(6, 'airport', 'Airport 3', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(7, 'casino', 'Casino 1', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(8, 'casino', 'Casino 2', '2023-02-11 04:52:03', '2023-02-11 04:52:03'),
(9, 'casino', 'Casino 3', '2023-02-11 04:52:03', '2023-02-11 04:52:03');

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

--
-- Table structure for table `reservations`
--

CREATE TABLE `reservations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pick_up_date` date NOT NULL,
  `pick_up_time` time NOT NULL,
  `pick_up_location_id` int(11) NOT NULL,
  `travellers` int(11) NOT NULL,
  `seats` int(11) NOT NULL,
  `bags` int(11) NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reservations`
--

INSERT INTO `reservations` (`id`, `pick_up_date`, `pick_up_time`, `pick_up_location_id`, `travellers`, `seats`, `bags`, `first_name`, `last_name`, `email`, `phone_no`, `description`, `created_at`, `updated_at`) VALUES
(1, '2023-02-11', '04:50:00', 4, 1, 1, 1, 'Peter', 'Parker', 'parker@gmail.com', '03001234567', NULL, '2023-02-11 04:53:01', '2023-02-11 04:53:01'),
(2, '2023-02-12', '04:53:00', 3, 1, 1, 1, 'Peter', 'Parker', 'parker@gmail.com', '03001234567', NULL, '2023-02-11 04:55:41', '2023-02-11 04:55:41'),
(3, '2023-02-11', '02:26:00', 2, 1, 1, 1, 'john', 'william', 'johnwilliam@mailinator.com', '6612061287', NULL, '2023-02-11 05:26:47', '2023-02-11 05:26:47'),
(4, '2023-02-11', '04:27:00', 2, 1, 1, 1, 'Sara', 'Goodwin', 'vofemilew@mailinator.com', '12013827747', NULL, '2023-02-11 05:30:07', '2023-02-11 05:30:07');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `type`, `value`, `created_at`, `updated_at`) VALUES
(1, 'email', 'parker@mailinator.com', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `pick_up_locations`
--
ALTER TABLE `pick_up_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `reservations`
--
ALTER TABLE `reservations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

