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

START TRANSACTION;



--
-- Database: `omaralyomhost_chord`
--

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('link','file','video') NOT NULL DEFAULT 'link',
  `link` varchar(300) DEFAULT NULL,
  `video` varchar(300) DEFAULT NULL,
  `file` varchar(300) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `banners`
--

INSERT INTO `banners` (`id`, `status`, `link`, `video`, `file`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'file', 'https://www.youtube.com/embed/WhJU-XK0vB0', '/storages/videos/282811713107863.5f0228a54a809.mp4', '/storage/photos/shares/images/video.mp4', NULL, '2024-04-14 16:17:43', '2024-04-21 19:50:52');

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

--
-- Table structure for table `banner_descriptions`
--

CREATE TABLE `banner_descriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `banner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banner_descriptions`
--

INSERT INTO `banner_descriptions` (`id`, `name`, `banner_id`, `language_id`) VALUES
(19, 'GOOD VIBES IN ONE PLACE', 1, 1),
(20, 'GOOD VIBES IN ONE PLACE', 1, 2);

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

--
-- Table structure for table `block_dates`
--

CREATE TABLE `block_dates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `block_dates`
--

INSERT INTO `block_dates` (`id`, `date`) VALUES
(1, '2024-04-25'),
(2, '2024-04-30'),
(3, '2024-04-22'),
(4, '2024-04-26');

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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `count` int(11) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `carts`
--

INSERT INTO `carts` (`id`, `count`, `user_id`, `product_id`) VALUES
(1, 1, 12, '8f7abbb1'),
(4, 3, 14, '8f7abbb1'),
(5, 1, 2, '8f7abbb1'),
(7, 3, 19, '8f7abbb1'),
(9, 1, 18, '8f7abbb1'),
(11, 1, 20, '8f7abbb1'),
(13, 4, 23, '8f7abbb1'),
(14, 2, 15, '8f7abbb1'),
(15, 1, 1, '8f7abbb1'),
(16, 1, 29, '8f7abbb1');

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

--
-- Table structure for table `cobons`
--

CREATE TABLE `cobons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` text DEFAULT NULL,
  `discount_type` enum('percentage','value') NOT NULL DEFAULT 'value',
  `category_id` text DEFAULT NULL,
  `count_user` int(11) NOT NULL DEFAULT 1,
  `count` int(11) NOT NULL DEFAULT 1,
  `discount` double DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `cobons`
--

INSERT INTO `cobons` (`id`, `code`, `discount_type`, `category_id`, `count_user`, `count`, `discount`, `start_date`, `end_date`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'yom', 'percentage', NULL, 2, 22, 20, '2024-04-17', '2024-04-24', NULL, '2024-04-14 20:05:41', '2024-04-14 20:10:38'),
(2, 'er20', 'percentage', NULL, 20, 20, 10, '2024-04-22', '2024-04-27', NULL, '2024-04-22 13:00:56', '2024-04-22 13:00:56');

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

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

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

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(191) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `local` char(2) NOT NULL,
  `name` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'whether the language is active in the website or not, 1-> is active',
  `admin_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'whether the language is active in the dashboard or not, 1-> is active',
  `deleted_at` timestamp NULL 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 `languages`
--

INSERT INTO `languages` (`id`, `local`, `name`, `status`, `admin_status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'ar', 'Arabic', 1, 1, NULL, NULL, NULL),
(2, 'en', 'English', 1, 1, NULL, NULL, NULL);

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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, '2003_03_28_090214_create_languages_table', 1),
(2, '2014_10_12_000000_create_users_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2020_03_23_152956_create_modules_table', 1),
(6, '2020_03_24_152330_create_user_modules_table', 1),
(7, '2020_04_11_162749_create_pages_table', 1),
(8, '2020_04_15_174353_create_page_description_table', 1),
(9, '2020_05_18_084100_create_jobs_table', 1),
(10, '2020_05_18_103912_create_failed_jobs_table', 1),
(11, '2020_06_01_181915_create_setting_table', 1),
(12, '2020_06_06_155249_create_website_visitor_table', 1),
(13, '2024_03_12_163619_visitor_messages', 1),
(14, '2024_03_12_163629_visitor_message_replies', 1),
(15, '2024_04_14_141037_rooms', 1),
(16, '2024_04_14_141047_room_descriptions', 1),
(17, '2024_04_14_141808_banners', 1),
(18, '2024_04_14_141813_banner_descriptions', 1),
(19, '2024_04_14_143127_cobons', 1),
(20, '2024_04_14_151308_table_numbers', 1),
(21, '2024_04_14_151650_work_days', 1),
(22, '2024_04_14_151700_block_dates', 1),
(23, '2024_04_14_151721_sliders', 1),
(24, '2024_04_14_151725_slider_descriptions', 1),
(25, '2024_04_14_152437_orders', 1),
(26, '2024_04_14_152442_reservations', 1),
(27, '2024_04_14_155305_reservation_payments', 1),
(28, '2024_04_14_155312_order_payments', 1),
(29, '2024_04_14_155506_order_products', 1),
(30, '2024_04_14_155649_carts', 1);

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `path` varchar(50) NOT NULL,
  `meta` text DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `modules`
--

INSERT INTO `modules` (`id`, `name`, `path`, `meta`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Users', 'users', '{\"module_name\":{\"ar\":\"\\u0627\\u0644\\u0645\\u0634\\u0631\\u0641\\u064a\\u0646\",\"en\":\"Users\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0645\\u0634\\u0631\\u0641 \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0645\\u0634\\u0631\\u0641\",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\",\"email\":\"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a\",\"phone\":\"\\u0631\\u0642\\u0645 \\u0627\\u0644\\u062c\\u0648\\u0627\\u0644\",\"photo\":\"\\u0635\\u0648\\u0631\\u0629 \\u0627\\u0644\\u0628\\u0631\\u0648\\u0641\\u0627\\u064a\\u0644\",\"password\":\"\\u0643\\u0644\\u0645\\u0629 \\u0627\\u0644\\u0645\\u0631\\u0648\\u0631\",\"password_confirmation\":\"\\u062a\\u0623\\u0643\\u064a\\u062f \\u0643\\u0644\\u0645\\u0629 \\u0627\\u0644\\u0645\\u0631\\u0648\\u0631\",\"modules\":\"\\u0627\\u0644\\u0645\\u0648\\u062f\\u064a\\u0648\\u0644\\u0627\\u062a\"},\"en\":{\"add_new\":\"Add New User\",\"edit\":\"Edit User\",\"name\":\"The name\",\"email\":\"The email\",\"phone\":\"The Phone\",\"photo\":\"The Photo\",\"password\":\"Password\",\"password_confirmation\":\"Password Confirmation\",\"modules\":\"Modules\"}}}', NULL, NULL, NULL),
(2, 'Members', 'members', '{\"module_name\":{\"ar\":\"\\u0627\\u0644\\u0645\\u0633\\u062a\\u062e\\u062f\\u0645\\u064a\\u0646\",\"en\":\"Members\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0645\\u0633\\u062a\\u062e\\u062f\\u0645 \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0645\\u0633\\u062a\\u062e\\u062f\\u0645\",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\",\"email\":\"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a\",\"phone\":\"\\u0631\\u0642\\u0645 \\u0627\\u0644\\u062c\\u0648\\u0627\\u0644\",\"photo\":\"\\u0635\\u0648\\u0631\\u0629 \\u0627\\u0644\\u0628\\u0631\\u0648\\u0641\\u0627\\u064a\\u0644\",\"password\":\"\\u0643\\u0644\\u0645\\u0629 \\u0627\\u0644\\u0645\\u0631\\u0648\\u0631\",\"password_confirmation\":\"\\u062a\\u0623\\u0643\\u064a\\u062f \\u0643\\u0644\\u0645\\u0629 \\u0627\\u0644\\u0645\\u0631\\u0648\\u0631\"},\"en\":{\"add_new\":\"Add New Member\",\"edit\":\"Edit Member\",\"name\":\"The name\",\"email\":\"The email\",\"phone\":\"The Phone\",\"photo\":\"The Photo\",\"password\":\"Password\",\"password_confirmation\":\"Password Confirmation\"}}}', NULL, NULL, NULL),
(3, 'Banners', 'banners', '{\"module_name\":{\"ar\":\"\\u0628\\u0627\\u0646\\u0631\",\"en\":\"Banners\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0628\\u0627\\u0646\\u0631  \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0628\\u0627\\u0646\\u0631   \",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Banner\",\"edit\":\"Edit Banner\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(4, 'Sliders', 'sliders', '{\"module_name\":{\"ar\":\"\\u0633\\u0644\\u0627\\u064a\\u062f\\u0631\",\"en\":\"Sliders\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0633\\u0644\\u0627\\u064a\\u062f\\u0631  \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0633\\u0644\\u0627\\u064a\\u062f\\u0631   \",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Slider\",\"edit\":\"Edit Slider\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(5, 'Rooms', 'rooms', '{\"module_name\":{\"ar\":\"\\u0627\\u0644\\u063a\\u0631\\u0641\",\"en\":\"Rooms\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u063a\\u0631\\u0641\\u0629  \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u063a\\u0631\\u0641\\u0629   \",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Room\",\"edit\":\"Edit Room\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(6, 'Categories', 'categories', '{\"module_name\":{\"ar\":\"\\u062a\\u0635\\u0646\\u064a\\u0641\\u0627\\u062a \\u0627\\u0644\\u0645\\u0646\\u064a\\u0648 \",\"en\":\"Categories\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u062a\\u0635\\u0646\\u064a\\u0641 \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u062a\\u0635\\u0646\\u064a\\u0641   \",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Category\",\"edit\":\"Edit Category\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(7, 'Products', 'products', '{\"module_name\":{\"ar\":\"\\u0627\\u0644\\u0648\\u062c\\u0628\\u0627\\u062a\",\"en\":\"Products\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0648\\u062c\\u0628\\u0629 \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0648\\u062c\\u0628\\u0629\",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Product\",\"edit\":\"Edit Product\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(8, 'Cobons', 'cobons', '{\"module_name\":{\"ar\":\"\\u0643\\u0648\\u0628\\u0648\\u0646\\u0627\\u062a \\u0627\\u0644\\u062e\\u0635\\u0645 \",\"en\":\"Cobons\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0643\\u0648\\u0628\\u0648\\u0646 \\u0627\\u0644\\u062e\\u0635\\u0645  \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0643\\u0648\\u0628\\u0648\\u0646 \\u0627\\u0644\\u062e\\u0635\\u0645   \",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Cobon\",\"edit\":\"Edit Cobons\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(9, 'Work Days', 'workdays', '{\"module_name\":{\"ar\":\"\\u0645\\u0648\\u0627\\u0639\\u064a\\u062f \\u0627\\u0644\\u0639\\u0645\\u0644 \",\"en\":\"Work Days\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0645\\u0648\\u0627\\u0639\\u064a\\u062f \\u0627\\u0644\\u0639\\u0645\\u0644  \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0645\\u0648\\u0627\\u0639\\u064a\\u062f \\u0627\\u0644\\u0639\\u0645\\u0644 \",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Work Day\",\"edit\":\"Edit Work Day\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(10, 'Table Numbers', 'tableNumbers', '{\"module_name\":{\"ar\":\"\\u0627\\u0631\\u0642\\u0627\\u0645 \\u0627\\u0644\\u0637\\u0627\\u0648\\u0644\\u0627\\u062a\",\"en\":\"Table Numbers\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0627\\u0631\\u0642\\u0627\\u0645 \\u0627\\u0644\\u0637\\u0627\\u0648\\u0644\\u0627\\u062a  \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644  \\u0627\\u0631\\u0642\\u0627\\u0645 \\u0627\\u0644\\u0637\\u0627\\u0648\\u0644\\u0627\\u062a\",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Table Number\",\"edit\":\"Edit Table Number\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(11, 'Orders', 'orders', '{\"module_name\":{\"ar\":\"\\u0637\\u0644\\u0628\\u0627\\u062a \\u0627\\u0644\\u0645\\u0646\\u064a\\u0648\",\"en\":\"Orders\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0627\\u0644\\u0637\\u0644\\u0628\\u0627\\u062a \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0637\\u0644\\u0628\\u0627\\u062a\",\"name\":\"\\u0627\\u0644\\u0627\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Order\",\"edit\":\"Show Order\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(12, 'Reservations', 'reservations', '{\"module_name\":{\"ar\":\" \\u0637\\u0644\\u0628\\u0627\\u062a \\u062d\\u062c\\u0632 \\u0627\\u0644\\u063a\\u0631\\u0641\",\"en\":\"Reservations\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0627\\u0644\\u0637\\u0644\\u0628\\u0627\\u062a \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0637\\u0644\\u0628\\u0627\\u062a\",\"name\":\"\\u0627\\u0644\\u0627\\u0633\\u0645\"},\"en\":{\"add_new\":\"Add New Reservation\",\"edit\":\"Show Reservation\",\"name\":\"The Name\"}}}', NULL, NULL, NULL),
(13, 'Pages', 'pages', '{\"module_name\":{\"ar\":\"\\u0627\\u0644\\u0635\\u0641\\u062d\\u0627\\u062a\",\"en\":\"Pages\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0635\\u0641\\u062d\\u0629 \\u062c\\u062f\\u064a\\u062f\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0635\\u0641\\u062d\\u0629\",\"image\":\"\\u0627\\u0644\\u0635\\u0648\\u0631\\u0629\",\"title\":\"\\u0627\\u0644\\u0639\\u0646\\u0648\\u0627\\u0646\",\"slug\":\"The URL Slug\",\"keywords\":\"\\u0643\\u0644\\u0645\\u0627\\u062a \\u062a\\u0646\\u0634\\u064a\\u0637 \\u0645\\u062d\\u0631\\u0643 \\u0627\\u0644\\u0628\\u062d\\u062b\",\"meta_description\":\"\\u0627\\u0644\\u0643\\u0644\\u0645\\u0627\\u062a \\u0627\\u0644\\u0648\\u0635\\u0641\\u064a\\u0629\",\"description\":\"\\u0627\\u0644\\u0648\\u0635\\u0641\"},\"en\":{\"add_new\":\"Add New Page\",\"edit\":\"Edit Page\",\"image\":\"The Image\",\"title\":\"The Title\",\"slug\":\"The Slug\",\"meta_description\":\"The Meta Description\",\"keywords\":\"The Keywords\",\"description\":\"The Description\"}}}', NULL, NULL, NULL),
(14, 'Visitor Messages', 'visitorMessages', '{\"module_name\":{\"ar\":\"\\u0631\\u0633\\u0627\\u0626\\u0644 \\u0627\\u0644\\u0632\\u0648\\u0627\\u0631\",\"en\":\"Visitor Messages\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0631\\u062f \\u062c\\u062f\\u064a\\u062f\",\"name\":\"\\u0627\\u0644\\u0625\\u0633\\u0645\",\"visitor_email\":\"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a \\u0644\\u0644\\u0632\\u0627\\u0626\\u0631\",\"email\":\"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a\",\"subject\":\"\\u0645\\u0648\\u0636\\u0648\\u0639 \\u0627\\u0644\\u0631\\u0633\\u0627\\u0644\\u0629\",\"message\":\"\\u0645\\u062d\\u062a\\u0648\\u0649 \\u0627\\u0644\\u0631\\u0633\\u0627\\u0644\\u0629\",\"reply\":\"\\u0627\\u0644\\u0631\\u062f \\u0639\\u0644\\u0649 \\u0627\\u0644\\u0631\\u0633\\u0627\\u0644\\u0629\",\"send_to\":\"\\u0625\\u0631\\u0633\\u0627\\u0644 \\u0625\\u0644\\u0649\"},\"en\":{\"add_new\":\"Reply New Message\",\"name\":\"The name\",\"visitor_email\":\"The email\",\"subject\":\"Subject of message\",\"message\":\"The message\",\"reply\":\"The message\",\"send_to\":\"Send to\"}}}', NULL, NULL, NULL),
(15, 'Settings', 'settings', '{\"module_name\":{\"ar\":\"\\u0627\\u0644\\u0625\\u0639\\u062f\\u0627\\u062f\\u062a\",\"en\":\"Settings\"},\"fields\":{\"ar\":{\"add_new\":\"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0623\\u0639\\u062f\\u0627\\u062f\\u062a\",\"edit\":\"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0627\\u0644\\u0625\\u0639\\u062f\\u0627\\u062f\\u062a\",\"website_disable\":\"\\u062a\\u0639\\u0637\\u064a\\u0644 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639\",\"dashboard_disable\":\"\\u062a\\u0639\\u0637\\u064a\\u0644 \\u0644\\u0648\\u062d\\u0629 \\u0627\\u0644\\u062a\\u062d\\u0643\\u0645\",\"website_name\":\"\\u0627\\u0633\\u0645 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639\",\"Keywords\":\"\\u0627\\u0644\\u0643\\u0644\\u0645\\u0627\\u062a \\u0627\\u0644\\u062f\\u0644\\u064a\\u0644\\u064a\\u0629\",\"meta_description\":\"\\u0627\\u0644\\u0643\\u0644\\u0645\\u0627\\u062a \\u0627\\u0644\\u0648\\u0635\\u0641\\u064a\\u0629\",\"site_email\":\"\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639\",\"site_address\":\"\\u0639\\u0646\\u0648\\u0627\\u0646 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639\",\"site_phone\":\"\\u062c\\u0648\\u0627\\u0644 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639\",\"mail_driver\":\"Mail Driver(SMTP)\",\"mail_host\":\"Mail Host (smtp.example.com)\",\"mail_port\":\"Mail Port (2525)\",\"mail_username\":\"Mail Username(username@example.cm)\",\"mail_password\":\"Mail password\",\"mail_encryption\":\"Mail Encryption(tls)\",\"mail_from_address\":\"Mail From address(info@example.com)\",\"mail_from_name\":\"Mail From Name(Example)\",\"website_logo\":\"\\u0644\\u0648\\u062c\\u0648 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639\"},\"en\":{\"add_new\":\"Add Settings\",\"edit\":\"Edit Settings\",\"website_disable\":\"Website Disabled\",\"dashboard_disable\":\"Dashboard Disabled\",\"website_name\":\"Website Name\",\"Keywords\":\"Keywords\",\"meta_description\":\"Meta Description\",\"site_email\":\"Website Email\",\"site_address\":\"Website Address\",\"site_phone\":\"Website Phone\",\"mail_driver\":\"Mail Driver(SMTP)\",\"mail_host\":\"Mail Host (smtp.example.com)\",\"mail_port\":\"Mail Port (2525)\",\"mail_username\":\"Mail Username(username@example.cm)\",\"mail_password\":\"Mail password\",\"mail_encryption\":\"Mail Encryption(tls)\",\"mail_from_address\":\"Mail From address(info@example.com)\",\"mail_from_name\":\"Mail From Name(Example)\",\"website_logo\":\"Website Logo\"}}}', NULL, NULL, NULL);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `token` text DEFAULT NULL,
  `status` enum('pickup','table','room') NOT NULL DEFAULT 'pickup',
  `date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `length_time` double DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `room_id` bigint(20) UNSIGNED DEFAULT NULL,
  `table_number_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reservation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `orders`
--

INSERT INTO `orders` (`id`, `token`, `status`, `date`, `start_time`, `end_time`, `length_time`, `user_id`, `room_id`, `table_number_id`, `reservation_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(5, '$2y$10$lmkbnTYvIqsRsPiBFMbRe.MOTH99LP1Zt1XGD7YdI4hIVE8Q8vCc6', 'pickup', NULL, NULL, NULL, 1, 1, NULL, 4, NULL, '2024-04-19 21:48:40', '2024-04-19 21:48:40', '2024-04-19 21:48:40'),
(6, '$2y$10$jJteTANe5n.WAPtlSsGWZuR/lcCAdPaTefh5FKLDDFWF.o.RZQA56', 'table', '2024-04-20', NULL, NULL, 1, 1, NULL, 4, NULL, NULL, '2024-04-19 21:49:33', '2024-04-19 21:50:01'),
(7, '$2y$10$N1tgmts4w9HgDXKo6XbhRu9S6W4VEXQqp4luBPV/wh6QAAqiySTJq', 'room', '2024-04-20', NULL, NULL, 1, 1, 2, NULL, 18, NULL, '2024-04-20 00:31:37', '2024-04-20 00:32:45'),
(8, '$2y$10$3sUl3/NJPvOrkAglvcDScu/2S8LlEWFSKtuzhQDO7U8u/UwPiLnPa', 'table', '2024-04-23', NULL, NULL, 1, 1, NULL, 4, NULL, NULL, '2024-04-20 00:35:22', '2024-04-20 02:29:55'),
(9, '$2y$10$BQBeBSXhuGZ/d.5LVDL41ONqT.1d/E3qf54BnrjbxDCE6V6pPgmES', 'room', NULL, NULL, NULL, 1, 1, 2, NULL, 28, '2024-04-20 02:41:39', '2024-04-20 02:41:39', '2024-04-20 02:41:39'),
(10, '$2y$10$uoEILwR4EAq47ed2c40kpuJt3qQA3nys4fTCfBYs/Pvq9.4zRxIOS', 'room', NULL, NULL, NULL, 1, 1, 2, NULL, 28, '2024-04-20 02:41:48', '2024-04-20 02:41:48', '2024-04-20 02:41:48'),
(11, '$2y$10$/Z0tJ3A9UIerFHuto0JVee8AXQBo8OKeSiQ7NRDkzsgFo7d4Fvxai', 'room', '2024-04-22', NULL, NULL, 1, 1, 2, NULL, 28, NULL, '2024-04-20 02:41:57', '2024-04-20 02:42:19'),
(12, '$2y$10$BZarQ.NuJrUT6R6t4eMIL.8FkCOvKjWrjdC3.sjRihpAOtQf9eaGW', 'room', NULL, NULL, NULL, 1, 1, 2, NULL, 29, '2024-04-20 02:43:22', '2024-04-20 02:43:22', '2024-04-20 02:43:22'),
(13, '$2y$10$Hjm91enuyb8Ll1e6TZiUMOPDD.wwduhthEWEdMCXB/zmbGWRKRABC', 'room', NULL, NULL, NULL, 1, 1, 2, NULL, 29, '2024-04-20 02:43:44', '2024-04-20 02:43:44', '2024-04-20 02:43:44'),
(14, '$2y$10$TVgsrHf.E7Kit2WNuQ0eeOiA5IuI6pBgI1ta4WPJApKktCwbZ0Djm', 'room', NULL, NULL, NULL, 1, 1, 2, NULL, 30, '2024-04-20 02:46:19', '2024-04-20 02:46:19', '2024-04-20 02:46:19'),
(15, '$2y$10$YQ3HFK3WaUOfczYyUySXtesOV3RFC/8CH0DfYmEQNdIUNAFk51jXO', 'room', '2024-04-25', NULL, NULL, 1, 1, 2, NULL, 31, NULL, '2024-04-20 02:46:54', '2024-04-20 02:47:15'),
(16, '$2y$10$OFK1l6ecvPhu.ZpmW0A/4u34r.kPlVlRwnq6EyRKXZQWVL2K0.Vq6', 'pickup', '2024-04-20', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-20 03:52:56', '2024-04-20 03:52:56', '2024-04-20 03:52:56'),
(17, '$2y$10$bLsTPntHLDFsBjz8/wkVa.5Eg7XUVIUygLWYoABU47Wqt2ucsE75W', 'pickup', '2024-04-20', NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, '2024-04-20 03:53:02', '2024-04-20 03:53:24'),
(18, '$2y$10$hZLbw9ImBiXTgH/miw7GmOXT8HQFt4z3LsDPlQ/CRebSGCjDL8aSe', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:25:03', '2024-04-21 21:25:03', '2024-04-21 21:25:03'),
(19, '$2y$10$UUP9pZmc2dFCRqlNfSMbTejl.TxZe2vDgyybprzoxO3xVuQjvFF0a', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:25:05', '2024-04-21 21:25:05', '2024-04-21 21:25:05'),
(20, '$2y$10$Bf4rTsgfguKf4rueAdPxNe/xMxd3fuFuR6VSxW5VuHvcPw0gsa8Ni', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:25:22', '2024-04-21 21:25:22', '2024-04-21 21:25:22'),
(21, '$2y$10$j3Fe9clIecH31FTE8bl/f.C./hClfoX1dpmtIy4i9751P0aVxDssa', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:26:30', '2024-04-21 21:26:30', '2024-04-21 21:26:30'),
(22, '$2y$10$3fNlT842U8hnOHX2IO0cHuA7QQhPrEvsVRkeHy05Myse3ovvSmNuS', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:26:59', '2024-04-21 21:26:59', '2024-04-21 21:26:59'),
(23, '$2y$10$SV0b8huUk.UwvLj336idyeulWrJWCTA/tZyoJwbFqbJY6DnoEN7Ii', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:27:14', '2024-04-21 21:27:14', '2024-04-21 21:27:14'),
(24, '$2y$10$GuB.WiQBjWrZxxK32oW6oe3lLHX/4RowGFH2h2zGf1kuSOjrkqCku', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:30:35', '2024-04-21 21:30:35', '2024-04-21 21:30:35'),
(25, '$2y$10$sZX8LoeNBKvgnxAKXK6pkujq29MrBJzShnc7nI5E5YRBeqyPRWbeW', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-21 21:33:14', '2024-04-21 21:33:14', '2024-04-21 21:33:14'),
(26, '$2y$10$262M3Ndnmac7bP0tfqR5muJhk3QHcmE3gYvkf.c84.dFhC0LgWeHm', 'pickup', '2024-04-22', NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, '2024-04-21 21:34:40', '2024-04-21 21:35:10'),
(27, '$2y$10$H2oki/It.g47Qx7QGSTHTuzp4Dc.7e/vqqQIj8lV0KalA93iTQJ..', 'pickup', '2024-04-22', NULL, NULL, 1, 18, NULL, NULL, NULL, '2024-04-22 13:01:14', '2024-04-22 13:01:14', '2024-04-22 13:01:14'),
(28, '$2y$10$cfHRccK2x7/9CWtup0kiFOrz97NC.9HRyxP5qDVjt2duIl69zZnRm', 'table', '2024-04-22', NULL, NULL, 1, 18, NULL, 4, NULL, NULL, '2024-04-22 13:11:52', '2024-04-22 13:12:36'),
(29, '$2y$10$P9DFlIiwh50uwAzpjlh7B.d67buJAqJWOmedAlxAN5RkusNxCq8QK', 'pickup', '2024-04-22', NULL, NULL, 1, 19, NULL, NULL, NULL, '2024-04-22 13:29:43', '2024-04-22 13:29:43', '2024-04-22 13:29:43'),
(30, '$2y$10$CHmbXMY/iBuADoCo6QOUL.LJamHIxSUws.4GP84zINJ4GCzK5olAq', 'pickup', '2024-04-22', NULL, NULL, 1, 15, NULL, NULL, NULL, NULL, '2024-04-22 14:04:07', '2024-04-22 14:04:40'),
(31, '$2y$10$CTspF6TCJh9JFvyNRac3ou2L1bxyhnbxihM/yACJe77C/JF5P/CqO', 'table', '2024-04-24', NULL, NULL, 1, 23, NULL, 10, NULL, '2024-04-24 13:51:27', '2024-04-24 13:51:27', '2024-04-24 13:51:27'),
(32, '$2y$10$eeTZT.XLl6ObKMNoqYLYfufuLkPhVlCkVjrWeGisSrPsvkL5NgDQq', 'table', '2024-04-24', NULL, NULL, 1, 23, NULL, 8, NULL, '2024-04-24 13:51:57', '2024-04-24 13:51:57', '2024-04-24 13:51:57'),
(33, '$2y$10$PoEfPAG4Wvb2DPSdTpAfPOvkMLvSe2Je.JvQO8sffl2euLyuo0cSy', 'table', '2024-04-24', NULL, NULL, 1, 23, NULL, 8, NULL, '2024-04-24 13:53:04', '2024-04-24 13:53:04', '2024-04-24 13:53:04'),
(34, '$2y$10$7ZzN60P4cm8Ja1o7iIHFSu9.xevV5/seueegbdJ3LG1nFSK3qlShm', 'pickup', '2024-04-28', NULL, NULL, 1, 1, NULL, NULL, NULL, '2024-04-28 10:21:22', '2024-04-28 10:21:22', '2024-04-28 10:21:22'),
(35, '$2y$10$jluMPrRSJRqZvgTqL23se.NjX6ji0RLu5XnCM/911Y5w0pfRGoia6', 'table', '2024-04-28', NULL, NULL, 1, 1, NULL, 7, NULL, '2024-04-28 10:21:47', '2024-04-28 10:21:47', '2024-04-28 10:21:47'),
(36, '$2y$10$KCgm2cgN8bR9m0gJURKc5.GYz6VV3uG33P/9T5obzhuY4gbNYjfyi', 'table', '2024-04-28', NULL, NULL, 1, 23, NULL, 9, NULL, '2024-04-28 14:11:01', '2024-04-28 14:11:01', '2024-04-28 14:11:01'),
(37, '$2y$10$/xNZ/n88sP4RprKUE3Vlie0RDkbcq3LnrpmvZRllakDgQ0a1Y38rK', 'table', '2024-04-28', NULL, NULL, 1, 23, NULL, 9, NULL, '2024-04-28 14:11:49', '2024-04-28 14:11:49', '2024-04-28 14:11:49'),
(38, '$2y$10$nSgocI7/vUKeqFpYvP04wOALS2npBM60t.EQdV8o.y8i/8.V09Cbi', 'table', '2024-04-28', NULL, NULL, 1, 29, NULL, 4, NULL, '2024-04-28 14:59:43', '2024-04-28 14:59:43', '2024-04-28 14:59:43');

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

--
-- Table structure for table `order_payments`
--

CREATE TABLE `order_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payment_id` text DEFAULT NULL,
  `payment_log` text DEFAULT NULL,
  `total_products` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `tax_val` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `cobon_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_payments`
--

INSERT INTO `order_payments` (`id`, `payment_id`, `payment_log`, `total_products`, `discount`, `tax`, `tax_val`, `total`, `cobon_id`, `order_id`) VALUES
(5, NULL, NULL, 70, 0, 7, 10, 77, NULL, 5),
(6, '3790451', '{\"InvoiceId\":3790451,\"InvoiceReference\":\"2024000536\",\"CreatedDate\":\"April 19, 2024\",\"ExpireDate\":\"May 19, 2024\",\"InvoiceValue\":6.234,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"19/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411020299169\",\"TrackId\":\"19-04-2024_1983839\",\"TransactionId\":\"299169\",\"PaymentId\":\"07073790451198383974\",\"AuthorizationId\":\"299169\",\"OrderId\":\"3790451\",\"InvoiceItems\":[{\"ProductName\":\" web.order \",\"UnitPrice\":\"6.234\",\"Quantity\":\"1\",\"ExtendedAmount\":\"6.234\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"77.000\",\"TransationValue\":\"6.234\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"6.240\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$jJteTANe5n.WAPtlSsGWZuR/lcCAdPaTefh5FKLDDFWF.o.RZQA56&failed_url=http://localhost:8888/chord/public/en/cart&lang=en\",\"InvoiceDisplayValue\":\"77.000 SR\"}', 70, 0, 7, 10, 77, 1, 6),
(7, '3790538', '{\"InvoiceId\":3790538,\"InvoiceReference\":\"2024000538\",\"CreatedDate\":\"April 20, 2024\",\"ExpireDate\":\"May 20, 2024\",\"InvoiceValue\":3.805,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"20/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411023300229\",\"TrackId\":\"20-04-2024_1983904\",\"TransactionId\":\"300229\",\"PaymentId\":\"07073790538198390474\",\"AuthorizationId\":\"300229\",\"OrderId\":\"3790538\",\"InvoiceItems\":[{\"ProductName\":\" web.order \",\"UnitPrice\":\"3.805\",\"Quantity\":\"1\",\"ExtendedAmount\":\"3.805\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"47.000\",\"TransationValue\":\"3.805\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"3.810\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$N1tgmts4w9HgDXKo6XbhRu9S6W4VEXQqp4luBPV/wh6QAAqiySTJq&failed_url=http://localhost:8888/chord/public/en/cart&lang=en\",\"InvoiceDisplayValue\":\"47.000 SR\"}', 28, 0, 4.3, 10, 47.3, NULL, 7),
(8, '3790539', '{\"InvoiceId\":3790539,\"InvoiceReference\":\"2024000539\",\"CreatedDate\":\"April 20, 2024\",\"ExpireDate\":\"May 20, 2024\",\"InvoiceValue\":1.214,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"20/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411101293980\",\"TrackId\":\"20-04-2024_1983936\",\"TransactionId\":\"293980\",\"PaymentId\":\"07073790539198393674\",\"AuthorizationId\":\"293980\",\"OrderId\":\"3790539\",\"InvoiceItems\":[{\"ProductName\":\" web.order \",\"UnitPrice\":\"1.214\",\"Quantity\":\"1\",\"ExtendedAmount\":\"1.214\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"15.000\",\"TransationValue\":\"1.214\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"1.220\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$3sUl3/NJPvOrkAglvcDScu/2S8LlEWFSKtuzhQDO7U8u/UwPiLnPa&failed_url=http://localhost:8888/chord/public/en/cart&lang=en\",\"InvoiceDisplayValue\":\"15.000 SR\"}', 14, 0, 1.4, 10, 15.4, NULL, 8),
(9, NULL, NULL, 14, 0, 2.9, 10, 31.9, NULL, 9),
(10, NULL, NULL, 14, 0, 2.9, 10, 31.9, NULL, 10),
(11, '3790754', '{\"InvoiceId\":3790754,\"InvoiceReference\":\"2024000543\",\"CreatedDate\":\"April 20, 2024\",\"ExpireDate\":\"May 20, 2024\",\"InvoiceValue\":2.510,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"20/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411101296070\",\"TrackId\":\"20-04-2024_1983942\",\"TransactionId\":\"296070\",\"PaymentId\":\"07073790754198394274\",\"AuthorizationId\":\"296070\",\"OrderId\":\"3790754\",\"InvoiceItems\":[{\"ProductName\":\" web.order \",\"UnitPrice\":\"2.510\",\"Quantity\":\"1\",\"ExtendedAmount\":\"2.510\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"31.000\",\"TransationValue\":\"2.510\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"2.510\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$/Z0tJ3A9UIerFHuto0JVee8AXQBo8OKeSiQ7NRDkzsgFo7d4Fvxai&failed_url=http://localhost:8888/chord/public/en/cart&lang=en\",\"InvoiceDisplayValue\":\"31.000 SR\"}', 14, 0, 2.9, 10, 31.9, NULL, 11),
(12, NULL, NULL, 14, 0, 4.4, 10, 48.4, NULL, 12),
(13, NULL, NULL, 14, 0, 4.4, 10, 48.4, NULL, 13),
(14, NULL, NULL, 14, 0, 4.4, 10, 48.4, NULL, 14),
(15, '3790775', '{\"InvoiceId\":3790775,\"InvoiceReference\":\"2024000547\",\"CreatedDate\":\"April 20, 2024\",\"ExpireDate\":\"May 20, 2024\",\"InvoiceValue\":5.182,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"20/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411101297160\",\"TrackId\":\"20-04-2024_1983946\",\"TransactionId\":\"297160\",\"PaymentId\":\"07073790775198394675\",\"AuthorizationId\":\"297160\",\"OrderId\":\"3790775\",\"InvoiceItems\":[{\"ProductName\":\" web.order \",\"UnitPrice\":\"5.182\",\"Quantity\":\"1\",\"ExtendedAmount\":\"5.182\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"64.000\",\"TransationValue\":\"5.182\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"5.190\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$YQ3HFK3WaUOfczYyUySXtesOV3RFC/8CH0DfYmEQNdIUNAFk51jXO&failed_url=http://localhost:8888/chord/public/en/cart&lang=en\",\"InvoiceDisplayValue\":\"64.000 SR\"}', 14, 0, 5.9, 10, 64.9, NULL, 15),
(16, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 16),
(17, '3791144', '{\"InvoiceId\":3791144,\"InvoiceReference\":\"2024000549\",\"CreatedDate\":\"April 20, 2024\",\"ExpireDate\":\"May 20, 2024\",\"InvoiceValue\":1.214,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"20/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411102298170\",\"TrackId\":\"20-04-2024_1983977\",\"TransactionId\":\"298170\",\"PaymentId\":\"07073791144198397774\",\"AuthorizationId\":\"298170\",\"OrderId\":\"3791144\",\"InvoiceItems\":[{\"ProductName\":\" web.order \",\"UnitPrice\":\"1.214\",\"Quantity\":\"1\",\"ExtendedAmount\":\"1.214\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"15.000\",\"TransationValue\":\"1.214\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"1.220\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$bLsTPntHLDFsBjz8/wkVa.5Eg7XUVIUygLWYoABU47Wqt2ucsE75W&failed_url=http://localhost:8888/chord/public/en/cart&lang=en\",\"InvoiceDisplayValue\":\"15.000 SR\"}', 14, 0, 1.4, 10, 15.4, NULL, 17),
(18, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 18),
(19, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 19),
(20, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 20),
(21, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 21),
(22, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 22),
(23, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 23),
(24, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 24),
(25, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 25),
(26, '3799680', '{\"InvoiceId\":3799680,\"InvoiceReference\":\"2024000560\",\"CreatedDate\":\"April 22, 2024\",\"ExpireDate\":\"May 22, 2024\",\"InvoiceValue\":3.724,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"22/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411221301327\",\"TrackId\":\"22-04-2024_1985899\",\"TransactionId\":\"301327\",\"PaymentId\":\"07073799680198589976\",\"AuthorizationId\":\"301327\",\"OrderId\":\"3799680\",\"InvoiceItems\":[{\"ProductName\":\" Order \",\"UnitPrice\":\"3.724\",\"Quantity\":\"1\",\"ExtendedAmount\":\"3.724\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"46.000\",\"TransationValue\":\"3.724\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"3.730\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$262M3Ndnmac7bP0tfqR5muJhk3QHcmE3gYvkf.c84.dFhC0LgWeHm&failed_url=https://chord.omar.alyomhost.org/cart&lang=en\",\"InvoiceDisplayValue\":\"46.000 SR\"}', 42, 0, 4.2, 10, 46.2, NULL, 26),
(27, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 27),
(28, '3804211', '{\"InvoiceId\":3804211,\"InvoiceReference\":\"2024000567\",\"CreatedDate\":\"April 22, 2024\",\"ExpireDate\":\"May 22, 2024\",\"InvoiceValue\":1.214,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965581524763\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"22/04/2024\",\"PaymentGateway\":\"VISA/MASTER\",\"ReferenceId\":\"411313239026\",\"TrackId\":\"22-04-2024_1987165\",\"TransactionId\":\"239026\",\"PaymentId\":\"07073804211198716572\",\"AuthorizationId\":\"160580\",\"OrderId\":\"3804211\",\"InvoiceItems\":[{\"ProductName\":\" الطلب \",\"UnitPrice\":\"1.214\",\"Quantity\":\"1\",\"ExtendedAmount\":\"1.214\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"KD\",\"PaidCurrencyValue\":\"1.220\",\"TransationValue\":\"1.214\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"1.220\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$cfHRccK2x7/9CWtup0kiFOrz97NC.9HRyxP5qDVjt2duIl69zZnRm&failed_url=https://chord.omar.alyomhost.org/ar/cart&lang=ar\",\"InvoiceDisplayValue\":\"15.000 SR\"}', 14, 0, 1.4, 10, 15.4, NULL, 28),
(29, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 29),
(30, '3804538', '{\"InvoiceId\":3804538,\"InvoiceReference\":\"2024000570\",\"CreatedDate\":\"April 22, 2024\",\"ExpireDate\":\"May 22, 2024\",\"InvoiceValue\":1.214,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965581524713\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"22/04/2024\",\"PaymentGateway\":\"VISA/MASTER\",\"ReferenceId\":\"411314231641\",\"TrackId\":\"22-04-2024_1987320\",\"TransactionId\":\"231641\",\"PaymentId\":\"07073804538198732073\",\"AuthorizationId\":\"596840\",\"OrderId\":\"3804538\",\"InvoiceItems\":[{\"ProductName\":\" Order \",\"UnitPrice\":\"1.214\",\"Quantity\":\"1\",\"ExtendedAmount\":\"1.214\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"KD\",\"PaidCurrencyValue\":\"1.220\",\"TransationValue\":\"1.214\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"1.220\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$CHmbXMY/iBuADoCo6QOUL.LJamHIxSUws.4GP84zINJ4GCzK5olAq&failed_url=https://chord.omar.alyomhost.org/cart&lang=en\",\"InvoiceDisplayValue\":\"15.000 SR\"}', 14, 0, 1.4, 10, 15.4, NULL, 30),
(31, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 31),
(32, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 32),
(33, NULL, NULL, 42, 0, 4.2, 10, 46.2, NULL, 33),
(34, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 34),
(35, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 35),
(36, NULL, NULL, 56, 0, 5.6, 10, 61.6, NULL, 36),
(37, NULL, NULL, 56, 0, 5.6, 10, 61.6, NULL, 37),
(38, NULL, NULL, 14, 0, 1.4, 10, 15.4, NULL, 38);

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

--
-- Table structure for table `order_products`
--

CREATE TABLE `order_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `count` int(11) DEFAULT NULL,
  `product_cost` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_products`
--

INSERT INTO `order_products` (`id`, `count`, `product_cost`, `total`, `order_id`, `product_id`) VALUES
(7, 5, 14, 70, 5, '8f7abbb1'),
(8, 5, 14, 70, 6, '8f7abbb1'),
(9, 2, 14, 28, 7, '8f7abbb1'),
(10, 1, 14, 14, 8, '8f7abbb1'),
(11, 1, 14, 14, 9, '8f7abbb1'),
(12, 1, 14, 14, 10, '8f7abbb1'),
(13, 1, 14, 14, 11, '8f7abbb1'),
(14, 1, 14, 14, 12, '8f7abbb1'),
(15, 1, 14, 14, 13, '8f7abbb1'),
(16, 1, 14, 14, 14, '8f7abbb1'),
(17, 1, 14, 14, 15, '8f7abbb1'),
(18, 1, 14, 14, 16, '8f7abbb1'),
(19, 1, 14, 14, 17, '8f7abbb1'),
(20, 3, 14, 42, 18, '8f7abbb1'),
(21, 3, 14, 42, 19, '8f7abbb1'),
(22, 3, 14, 42, 20, '8f7abbb1'),
(23, 3, 14, 42, 21, '8f7abbb1'),
(24, 3, 14, 42, 22, '8f7abbb1'),
(25, 3, 14, 42, 23, '8f7abbb1'),
(26, 3, 14, 42, 24, '8f7abbb1'),
(27, 3, 14, 42, 25, '8f7abbb1'),
(28, 3, 14, 42, 26, '8f7abbb1'),
(29, 1, 14, 14, 27, '8f7abbb1'),
(30, 1, 14, 14, 28, '8f7abbb1'),
(31, 1, 14, 14, 29, '8f7abbb1'),
(32, 1, 14, 14, 30, '8f7abbb1'),
(33, 1, 14, 14, 31, '8f7abbb1'),
(34, 1, 14, 14, 32, '8f7abbb1'),
(35, 3, 14, 42, 33, '8f7abbb1'),
(36, 1, 14, 14, 34, '8f7abbb1'),
(37, 1, 14, 14, 35, '8f7abbb1'),
(38, 4, 14, 56, 36, '8f7abbb1'),
(39, 4, 14, 56, 37, '8f7abbb1'),
(40, 1, 14, 14, 38, '8f7abbb1');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(200) DEFAULT NULL,
  `number` double DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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 `pages`
--

INSERT INTO `pages` (`id`, `image`, `number`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '/storage/photos/shares/images/room6.jpg', NULL, 1, NULL, NULL, '2024-04-21 20:36:37'),
(2, '/storage/photos/shares/images/room5.jpg', NULL, 1, NULL, NULL, '2024-04-21 20:37:02'),
(3, '/storage/photos/shares/images/room4.jpg', NULL, 1, NULL, NULL, '2024-04-21 20:37:44'),
(4, '/storage/photos/shares/images/room3.jpg', NULL, 1, NULL, NULL, '2024-04-21 20:38:43'),
(5, '/storage/photos/shares/images/head_bg1.jpg', NULL, 1, NULL, NULL, '2024-04-21 20:39:10'),
(6, '/storage/photos/shares/images/ab2.jpg', NULL, 1, NULL, NULL, '2024-04-21 20:43:22'),
(7, 'user.jpg', NULL, 1, NULL, NULL, NULL),
(8, '/storage/photos/shares/images/room5.jpg', NULL, 1, NULL, NULL, '2024-04-21 20:44:02'),
(9, '/storage/photos/shares/images/logo_light.png', NULL, 1, NULL, NULL, '2024-04-21 21:21:51');

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

--
-- Table structure for table `page_descriptions`
--

CREATE TABLE `page_descriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(500) DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `keywords` varchar(250) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `page_id` bigint(20) UNSIGNED DEFAULT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_descriptions`
--

INSERT INTO `page_descriptions` (`id`, `title`, `slug`, `meta_description`, `keywords`, `description`, `page_id`, `language_id`) VALUES
(43, 'GOOD VIBES IN ONE PLACE', NULL, NULL, NULL, NULL, 9, 1),
(44, 'GOOD VIBES IN ONE PLACE', NULL, NULL, NULL, NULL, 9, 2),
(59, 'نصنع مساحة صغيرة وحميمة وجذابة لتناول وجبة لا تُنسى', NULL, NULL, NULL, 'يؤدي التحويل إلى عملاء ثم تحويل هؤلاء العملاء إلى معجبين مخلصين بعلامتك التجارية من خلال الاستفادة من أتمتة الجيل التالي والذكاء الاصطناعي. نعم، يمكن حقًا تشغيله آليًا، ولا، أنت لا تحلم.', 7, 1),
(60, 'We make a small, intimate, and inviting space for an unforgettable meal', NULL, NULL, NULL, 'Convert leads into customers and then turn those customers into loyal fans of your brand by leveraging next-generation automation and AI. Yes, it really can be automated, and no, you’re not dreaming.', 7, 2),
(61, 'مهمتنا', NULL, NULL, NULL, 'وجبة مصممة لاستكشافها وتجربتها في الوقت الحالي', 6, 1),
(62, 'OUR MISSION', NULL, NULL, NULL, 'A meal designed to be explored and experienced in the moment', 6, 2),
(63, 'قصتنا', NULL, NULL, NULL, 'نحن لسنا مجرد مطعم. نحن تجربة ثقافية', 8, 1),
(64, 'OUR STORY', NULL, NULL, NULL, 'We’re not just a restaurant. We’re a cultural experience', 8, 2),
(67, 'مع اصدقائك', NULL, NULL, NULL, 'هل يمكنك حقًا معرفة أصدقائك قبل أن تسمعهم يغنون ؟', 4, 1),
(68, 'WITH YOUR FRIENDS', NULL, NULL, NULL, 'Can you really know your friends before you\'ve heard them sing? Can you really know your friends before you\'ve heard them sing?\r\nCan you really know your friends before you\'ve heard them sing?Can you really know your friends before you\'ve heard them sing? Can you really know your friends before you\'ve heard them sing?\r\nCan you really know your friends before you\'ve heard them sing?', 4, 2),
(69, 'مع عائلتك', NULL, NULL, NULL, 'لا، الكاريوكي ليس فقط لأطفالك! الغناء والضحك والاستمتاع: ما الذي يمكن أن يكون أكثر بين الأجيال ؟', 3, 1),
(70, 'WITH YOUR FAMILY', NULL, NULL, NULL, 'No, karaoke is not just for your children! Singing, laughing, having fun: what could be more intergenerational?', 3, 2),
(71, 'تكوين صداقات جديدة', NULL, NULL, NULL, 'دع أصدقاءك الذين سيتزوجون قريبًا يستمتعون بأمسية خاصة مع أقرب وأعز أصدقائهم.', 2, 1),
(72, 'MAKE NEW FRIENDS', NULL, NULL, NULL, 'Let your soon-to-be-married friends enjoy a special evening with their nearest and dearest.', 2, 2),
(73, 'مع زملائك', NULL, NULL, NULL, 'هل تريد إنشاء بعض الذكريات الممتعة مع موظفيك خارج غرفة الاجتماعات ؟', 1, 1),
(74, 'WITH YOUR WITH YOUR COLLEAGUES', NULL, NULL, NULL, 'Do you want to create some fun memories with your employees outside of a meeting room?', 1, 2),
(75, 'أطلق العنان لنجمك الداخلي على الوتر', NULL, NULL, NULL, NULL, 5, 1),
(76, 'UNLEASH YOUR INNER SUPERSTAR AT THE CHORD', NULL, NULL, NULL, NULL, 5, 2);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `phone_codes`
--

CREATE TABLE `phone_codes` (
  `id` int(11) NOT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `code` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `phone_codes`
--

INSERT INTO `phone_codes` (`id`, `phone`, `code`, `created_at`, `updated_at`) VALUES
(1, '432432423', '12345', '2024-04-18 00:18:00', '2024-04-18 00:18:00'),
(2, '432432423', '12345', '2024-04-18 00:18:46', '2024-04-18 00:18:46'),
(3, '4684616', '12345', '2024-04-18 00:26:53', '2024-04-18 00:26:53'),
(4, '4684616', '12345', '2024-04-18 00:28:59', '2024-04-18 00:28:59'),
(5, '4684616', '12345', '2024-04-18 00:32:07', '2024-04-18 00:32:07'),
(6, '4684616', '12345', '2024-04-18 00:32:16', '2024-04-18 00:32:16'),
(7, '423423', '12345', '2024-04-21 14:18:59', '2024-04-21 14:18:59'),
(8, '423423', '12345', '2024-04-21 14:20:26', '2024-04-21 14:20:26'),
(9, '7567567', '12345', '2024-04-21 14:24:22', '2024-04-21 14:24:22'),
(10, '876876', '12345', '2024-04-21 14:24:47', '2024-04-21 14:24:47'),
(11, '0000223', '12345', '2024-04-21 14:25:56', '2024-04-21 14:25:56'),
(12, '0000223', '12345', '2024-04-21 14:27:29', '2024-04-21 14:27:29'),
(13, '0523456789', '12345', '2024-04-22 00:36:50', '2024-04-22 00:36:50'),
(14, '0521221852', '12345', '2024-04-22 00:38:03', '2024-04-22 00:38:03'),
(15, '0521221852', '12345', '2024-04-22 00:38:05', '2024-04-22 00:38:05'),
(16, '966501231241', '12345', '2024-04-22 07:32:47', '2024-04-22 07:32:47'),
(17, '581524713', '12345', '2024-04-22 09:49:39', '2024-04-22 09:49:39'),
(18, '0500000010', '12345', '2024-04-22 09:51:48', '2024-04-22 09:51:48'),
(19, '581524713', '12345', '2024-04-22 09:54:20', '2024-04-22 09:54:20'),
(20, '581524713', '12345', '2024-04-22 09:54:27', '2024-04-22 09:54:27'),
(21, '581524632', '12345', '2024-04-22 11:01:46', '2024-04-22 11:01:46'),
(22, '581524632', '12345', '2024-04-22 11:04:03', '2024-04-22 11:04:03'),
(23, '581524713', '12345', '2024-04-22 11:06:12', '2024-04-22 11:06:12'),
(24, '581524736', '12345', '2024-04-22 11:15:10', '2024-04-22 11:15:10'),
(25, '581524763', '12345', '2024-04-22 11:50:06', '2024-04-22 11:50:06'),
(26, '581524763', '12345', '2024-04-22 11:50:16', '2024-04-22 11:50:16'),
(27, '581524788', '12345', '2024-04-22 13:23:39', '2024-04-22 13:23:39'),
(28, '581524788', '12345', '2024-04-22 13:27:29', '2024-04-22 13:27:29'),
(29, '581524796', '12345', '2024-04-22 13:37:52', '2024-04-22 13:37:52'),
(30, '581524713', '12345', '2024-04-22 14:02:42', '2024-04-22 14:02:42'),
(31, '966587578578', '12345', '2024-04-23 09:41:42', '2024-04-23 09:41:42'),
(32, '506123456', '12345', '2024-04-23 09:50:07', '2024-04-23 09:50:07'),
(33, '581524713', '12345', '2024-04-23 10:25:29', '2024-04-23 10:25:29'),
(34, '581524632', '12345', '2024-04-23 14:41:10', '2024-04-23 14:41:10'),
(35, '966543605073', '12345', '2024-04-24 08:57:44', '2024-04-24 08:57:44'),
(36, '966543605073', '12345', '2024-04-24 09:02:37', '2024-04-24 09:02:37'),
(37, '966543605073', '12345', '2024-04-24 11:20:41', '2024-04-24 11:20:41'),
(38, '966543605073', '12345', '2024-04-24 11:28:09', '2024-04-24 11:28:09'),
(39, '966543605050', '12345', '2024-04-24 11:29:08', '2024-04-24 11:29:08'),
(40, '966543605083', '12345', '2024-04-24 11:29:38', '2024-04-24 11:29:38'),
(41, '966543605083', '12345', '2024-04-24 11:29:48', '2024-04-24 11:29:48'),
(42, '966543605083', '12345', '2024-04-24 11:29:48', '2024-04-24 11:29:48'),
(43, '966543605083', '12345', '2024-04-24 11:29:52', '2024-04-24 11:29:52'),
(44, '966543605083', '12345', '2024-04-24 12:05:22', '2024-04-24 12:05:22'),
(45, '966543605083', '12345', '2024-04-24 12:05:41', '2024-04-24 12:05:41'),
(46, '966543605073', '12345', '2024-04-24 12:27:45', '2024-04-24 12:27:45'),
(47, '966543605073', '12345', '2024-04-24 13:47:36', '2024-04-24 13:47:36'),
(48, '966543605073', '12345', '2024-04-24 13:47:50', '2024-04-24 13:47:50'),
(49, '966543605073', '12345', '2024-04-24 13:50:15', '2024-04-24 13:50:15'),
(50, '581524632', '12345', '2024-04-25 09:14:11', '2024-04-25 09:14:11'),
(51, '581524713', '12345', '2024-04-25 09:20:43', '2024-04-25 09:20:43'),
(52, '581524713', '12345', '2024-04-25 09:29:04', '2024-04-25 09:29:04'),
(53, '581524713', '12345', '2024-04-25 09:29:19', '2024-04-25 09:29:19'),
(54, '502134565', '12345', '2024-04-28 10:29:36', '2024-04-28 10:29:36'),
(55, '502134565', '12345', '2024-04-28 10:29:43', '2024-04-28 10:29:43'),
(56, '502134565', '12345', '2024-04-28 10:32:17', '2024-04-28 10:32:17'),
(57, '502134565', '12345', '2024-04-28 10:33:11', '2024-04-28 10:33:11'),
(58, '502134565', '12345', '2024-04-28 10:33:11', '2024-04-28 10:33:11'),
(59, '502134565', '12345', '2024-04-28 10:33:11', '2024-04-28 10:33:11'),
(60, '502134565', '12345', '2024-04-28 10:33:12', '2024-04-28 10:33:12'),
(61, '502134565', '12345', '2024-04-28 10:33:12', '2024-04-28 10:33:12'),
(62, '502134565', '12345', '2024-04-28 10:33:31', '2024-04-28 10:33:31'),
(63, '581523620', '12345', '2024-04-28 11:02:57', '2024-04-28 11:02:57'),
(64, '581523620', '12345', '2024-04-28 11:10:04', '2024-04-28 11:10:04'),
(65, '581523620', '12345', '2024-04-28 11:10:21', '2024-04-28 11:10:21'),
(66, '966543605073', '12345', '2024-04-28 12:15:38', '2024-04-28 12:15:38'),
(67, '966543605073', '12345', '2024-04-28 12:17:23', '2024-04-28 12:17:23'),
(68, '966543605073', '12345', '2024-04-28 12:17:30', '2024-04-28 12:17:30'),
(69, '966543605073', '12345', '2024-04-28 12:17:50', '2024-04-28 12:17:50'),
(70, '966543605073', '12345', '2024-04-28 12:17:56', '2024-04-28 12:17:56'),
(71, '501234567', '12345', '2024-04-28 12:33:48', '2024-04-28 12:33:48'),
(72, '966543605073', '12345', '2024-04-28 13:34:40', '2024-04-28 13:34:40'),
(73, '966543605073', '12345', '2024-04-28 13:36:07', '2024-04-28 13:36:07'),
(74, '966543605073', '12345', '2024-04-28 13:37:20', '2024-04-28 13:37:20'),
(75, '966501231234', '12345', '2024-04-28 14:20:43', '2024-04-28 14:20:43'),
(76, '508745632', '12345', '2024-04-28 14:58:51', '2024-04-28 14:58:51'),
(77, '966501231232', '12345', '2024-04-28 15:01:35', '2024-04-28 15:01:35'),
(78, '966512345612', '12345', '2024-04-28 15:04:43', '2024-04-28 15:04:43'),
(79, '5012341231', '12345', '2024-04-28 15:14:15', '2024-04-28 15:14:15');

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

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

CREATE TABLE `reservations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `token` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `length_time` double DEFAULT NULL,
  `count_members` int(11) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `room_id` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `reservations`
--

INSERT INTO `reservations` (`id`, `token`, `date`, `start_time`, `end_time`, `length_time`, `count_members`, `user_id`, `room_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(13, '$2y$10$V0Muu6sHJwo8/FHNZBNWmuKzqtav34f1rJVc0RjUeg/8pbYPaNOTO', '2024-04-19', '02:00:00', '04:00:00', 1, 6, 1, 4, NULL, '2024-04-18 18:37:06', '2024-04-18 18:37:34'),
(14, '$2y$10$HE35ZS5xZOF9FokYMl/fw.lc0QrN7BNBboPoeAfUcWGCQUmH7RJ/.', '2024-04-19', '10:00:00', '12:00:00', 1, 5, 1, 4, NULL, '2024-04-18 20:06:02', '2024-04-18 20:06:02'),
(15, '$2y$10$Z2.ts2zCxn0d1AsMVRFZE.F64K7bIu8UxOBGuv1yu5Kz1AdyKj2km', '2024-04-19', '06:00:00', '10:00:00', 4, 3, 1, 4, '2024-04-19 21:07:51', '2024-04-19 21:07:51', '2024-04-19 21:07:51'),
(16, '$2y$10$6nafn7CoMTOJ9iUbnsCGZOxw6V0/q2gqUfP/Rg7KICRZuidR.PdyG', '2024-04-20', '17:00:00', '18:00:00', 1, 3, 1, 4, '2024-04-19 23:59:47', '2024-04-19 23:59:47', '2024-04-19 23:59:47'),
(17, '$2y$10$hrxTObmtUBHPyic7VlKXD.eDTbO8zwCr28jARzYQYzZdcsI1EaEXi', '2024-04-20', '03:00:00', '04:00:00', 1, 3, 1, 2, '2024-04-20 00:09:17', '2024-04-20 00:09:17', '2024-04-20 00:09:17'),
(18, '$2y$10$L7nmsZEGAqUl5rEvBuva8.4IO1odlL9iM6lec4TJnoLkBk1rxtFYu', '2024-04-20', '02:00:00', '03:00:00', 1, 3, 1, 2, NULL, '2024-04-20 00:31:29', '2024-04-20 00:31:29'),
(19, '$2y$10$/H9YAEp3h9Bfb55Fu/M0BOq2aWTuZDfnK3NcfTdRia8uoAOtrXcvO', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:30:46', '2024-04-20 02:30:46', '2024-04-20 02:30:46'),
(20, '$2y$10$al6zRWA2Nga6vHQQoJmcz.y3nH1fSzTtJ11zBsnvoY6w9UgyGqnue', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:30:57', '2024-04-20 02:30:57', '2024-04-20 02:30:57'),
(21, '$2y$10$kpLEm6TfkJ5HPiFNJGjQx.FpEqDySipHKuu8IDhagKnkrCpojtwya', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:32:55', '2024-04-20 02:32:55', '2024-04-20 02:32:55'),
(22, '$2y$10$GBJTWP0Ge2D/s2U5y5k6Lu3wgg8kg7.qullt4OiQWxk21YwBbzpra', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:33:15', '2024-04-20 02:33:15', '2024-04-20 02:33:15'),
(23, '$2y$10$O6ohuhAKIeSHisim52tilO4NNaJj7g6K1t9.w5OGvT0oDIlVSOlOi', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:33:57', '2024-04-20 02:33:57', '2024-04-20 02:33:57'),
(24, '$2y$10$9mwRw2/1pWie29D.R8vOO.6vhRfr0gAMSDa23QecUV3.S68aywqqy', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:34:35', '2024-04-20 02:34:35', '2024-04-20 02:34:35'),
(25, '$2y$10$gyx.fWtWQPlf3D/n9HQIJuc8.38sYW7VwXYyJ.HKUZw/FuAjM93GS', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:34:52', '2024-04-20 02:34:52', '2024-04-20 02:34:52'),
(26, '$2y$10$5esrCFp5rKaiVXPmkesS9OC4q/ncHvF3JeKe0TOUBepprU0ro/HkK', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, '2024-04-20 02:35:33', '2024-04-20 02:35:33', '2024-04-20 02:35:33'),
(27, '$2y$10$WP5xV/DjhLj.6WH3j3cFDOWb7AiWnh/ehVPNUfzNpHlSO0nBBFfJe', '2024-04-20', '05:00:00', '08:00:00', 3, 3, 1, 2, NULL, '2024-04-20 02:36:31', '2024-04-20 02:36:53'),
(28, '$2y$10$cDd6rYgNlYd1Tg70sgY/puOwKfC5/C4cyznaXZN2cmrTfAI.6n6hi', '2024-04-26', '02:00:00', '03:00:00', 1, 3, 1, 2, NULL, '2024-04-20 02:40:20', '2024-04-20 02:42:19'),
(29, '$2y$10$Tvr1Y8lMvejrqtzCyTse1.0YVdF4Nb7/K0YkT4q.ZtmrisUwS4kLq', '2024-04-22', '06:00:00', '08:00:00', 2, 3, 1, 2, '2024-04-20 02:43:08', '2024-04-20 02:43:08', '2024-04-20 02:43:08'),
(30, '$2y$10$XHhYRsvg9VEMk4zaCm57zO/IQXbJwtjGPfAaRE/7N6ZVROFeKaeyK', '2024-04-22', '04:00:00', '06:00:00', 2, 3, 1, 2, '2024-04-20 02:44:33', '2024-04-20 02:44:33', '2024-04-20 02:44:33'),
(31, '$2y$10$V05miVqVxFP5HEPPKuh9.OnJ6M7THZYAti/jzNFkV4n9MQ/q/RpBm', '2024-04-22', '08:00:00', '11:00:00', 3, 3, 1, 2, NULL, '2024-04-20 02:46:49', '2024-04-20 02:47:15'),
(32, '$2y$10$.ojqT44iMHsb8DyUhw1aI.iwc9JTQcBCxrzgtScxVIenVbrtFl45e', '2024-04-26', '03:00:00', '04:00:00', 1, 3, 1, 2, '2024-04-21 13:58:15', '2024-04-21 13:58:15', '2024-04-21 13:58:15'),
(33, '$2y$10$NsoFbWgkKNVcizEQonF38OUiTgayatwCebXvOKWx4SYeatb6lO5Bq', '2024-04-26', '03:00:00', '04:00:00', 1, 3, 1, 3, NULL, '2024-04-21 21:19:19', '2024-04-21 21:20:20'),
(34, '$2y$10$zCKtWovdPveWQq/w.3baTOvf3Nfu5VVCTQ46h0v4uV.XGqwYy5EsS', '2024-04-23', '02:00:00', '03:00:00', 1, 3, 18, 2, '2024-04-22 12:17:50', '2024-04-22 12:17:50', '2024-04-22 12:17:50'),
(35, '$2y$10$7jWJ1m8XfbUTvTmi5Pj76.USJ6MCQkGQAdCgoAMYIpm4ztgi.1qIO', '2024-04-23', '02:00:00', '03:00:00', 1, 3, 18, 2, NULL, '2024-04-22 12:18:01', '2024-04-22 12:18:46'),
(36, '$2y$10$eS8rMilDgxOaIaq9TJxb0ODFXJtcU/V/xKxeHyhpYVm1DlGgEl4Ei', '2024-04-23', '02:00:00', '03:00:00', 1, 3, 18, 2, '2024-04-22 12:18:02', '2024-04-22 12:18:02', '2024-04-22 12:18:02'),
(37, '$2y$10$f1m7mBhSwhaZrSlMuvuHZev6MuMQeP4BvDSD6zOIrrsfjnTNIwqxi', '2024-04-29', '03:00:00', '04:00:00', 1, 3, 19, 2, '2024-04-22 13:37:21', '2024-04-22 13:37:21', '2024-04-22 13:37:21'),
(38, '$2y$10$QoJTlUnDApa/o58/jjfS2ONN0ELX4lGzDY1OEkS9bN5Wa/sllwSua', '2024-04-29', '13:00:00', '14:00:00', 1, 3, 23, 2, '2024-04-24 13:23:49', '2024-04-24 13:23:49', '2024-04-24 13:23:49'),
(39, '$2y$10$GbtHHdP7NpEDq78X8c4xpONXUFYlYUxmLpzzMFZLDSmWYPdaHJ6Y6', '2024-04-29', '06:00:00', '07:00:00', 1, 3, 23, 3, '2024-04-24 13:39:01', '2024-04-24 13:39:01', '2024-04-24 13:39:01'),
(40, '$2y$10$/g1.tEviwEARZhVPuIyxUu3YX7UVORYIN0DPINmXtZBAp44IJSw9O', '2024-04-29', '11:00:00', '12:00:00', 1, 3, 23, 2, '2024-04-24 13:41:01', '2024-04-24 13:41:01', '2024-04-24 13:41:01'),
(41, '$2y$10$x7IchWLiHMUAqTJJ9/P9uOS1zK2nx4mQcCgpoLXjKLG4lOenEZWta', '2024-04-29', '04:00:00', '05:00:00', 1, 3, 23, 2, '2024-04-24 13:42:04', '2024-04-24 13:42:04', '2024-04-24 13:42:04'),
(42, '$2y$10$zYPscwZ3FE2KA6BAbVYq0OSbJj11oQZYuCWygNfmLikfWyKKtUzxW', '2024-04-29', '03:00:00', '04:00:00', 1, 3, 15, 2, '2024-04-25 09:21:42', '2024-04-25 09:21:42', '2024-04-25 09:21:42'),
(43, '$2y$10$BGOWQuga8UVDsZUvMJ.dU.ljdtYnGlRHceTjIeEeHjc9A81jw5uQO', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:11', '2024-04-28 13:58:11', '2024-04-28 13:58:11'),
(44, '$2y$10$H4YGosovJEMByYkiYJQUW.8OkaYGMU9zVQ5WdWBnwL9QCmyfhRgoC', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:15', '2024-04-28 13:58:15', '2024-04-28 13:58:15'),
(45, '$2y$10$96jqIG3CbC3cKqkC5CBNDekgCFStGpV1BG0cyw7OaaPz8HfDLRIqi', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:16', '2024-04-28 13:58:16', '2024-04-28 13:58:16'),
(46, '$2y$10$X2IxIX38tqQRN5KQ.ziNveduqzHV18l1c2qg7zOJ7p/9uJA0CDCdG', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:16', '2024-04-28 13:58:16', '2024-04-28 13:58:16'),
(47, '$2y$10$g9xZz010U0qdk8r.ouSLUuH4ntUExDsQoi.YmscRBQaY4R6K.fklK', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:17', '2024-04-28 13:58:17', '2024-04-28 13:58:17'),
(48, '$2y$10$GuqseIaOwTELOa.DwZ1ZeOA9E3G6s6Tu.pvbFHaY1NPVDRTH5HgJu', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:17', '2024-04-28 13:58:17', '2024-04-28 13:58:17'),
(49, '$2y$10$HD0bQbzWUGCnz56SNOoAFenb7FqnGNFE6nBNdp5jjC.OLdRiZRe1a', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:18', '2024-04-28 13:58:18', '2024-04-28 13:58:18'),
(50, '$2y$10$PC42bNB20uOT1jh1y8o6C.Dg3vzcLjTd/EkFNLMNIPswZIp0Gwc3a', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:18', '2024-04-28 13:58:18', '2024-04-28 13:58:18'),
(51, '$2y$10$2g1JrLbO5SwRBZ7SApcTlO0KShYAuioQzE7YWzCiwUtj.eNu2gGvS', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:18', '2024-04-28 13:58:18', '2024-04-28 13:58:18'),
(52, '$2y$10$o/6lZz2fH8LpGUYAJWC8fO9J1b5Hr62K5WIPL9.dH6jJkqlsbZLR.', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:19', '2024-04-28 13:58:19', '2024-04-28 13:58:19'),
(53, '$2y$10$jGf8g3uDr4l3uxy8Qzmsd.rcRbCaJ5uqi1xM8fojZC6wbnVO6dfD6', '2024-04-29', '06:00:00', '08:00:00', 2, 3, 23, 4, '2024-04-28 13:58:19', '2024-04-28 13:58:19', '2024-04-28 13:58:19'),
(54, '$2y$10$4OP9JnuoGavLetUYnLF.0.C2Fb1r3boyHhRC07SyRWm/vb6uq2wxS', '2024-04-29', '08:00:00', '10:00:00', 2, 3, 23, 2, '2024-04-28 13:59:32', '2024-04-28 13:59:32', '2024-04-28 13:59:32'),
(55, '$2y$10$j0tdu9FK5V370H0MV9uLqOtcUxgg0/dLBfsp9BddI8BbAIsGVEl.K', '2024-04-29', '03:00:00', '04:00:00', 1, 3, 28, 2, '2024-04-28 14:21:57', '2024-04-28 14:21:57', '2024-04-28 14:21:57'),
(56, '$2y$10$eVddMLDCPFFMslTI83MLBuAPwywduVBD9r4GWpyHwmoGVaDgaOZP.', '2024-04-29', '03:00:00', '04:00:00', 1, 3, 28, 2, '2024-04-28 14:22:08', '2024-04-28 14:22:08', '2024-04-28 14:22:08'),
(57, '$2y$10$qrMVOqJGW9SL6Oy0KzYYeesxoi54S4J6y1ozDZFKqSogfEplg4imy', '2024-04-29', '02:00:00', '03:00:00', 1, 3, 28, 3, '2024-04-28 14:22:44', '2024-04-28 14:22:44', '2024-04-28 14:22:44'),
(58, '$2y$10$vEcZPo7tMUw2lhLPV1mYX.9Z3diwf9YYi7/mY7mnaad6Au8ajMILG', '2024-04-29', '04:00:00', '05:00:00', 1, 3, 28, 2, '2024-04-28 14:22:54', '2024-04-28 14:22:54', '2024-04-28 14:22:54'),
(59, '$2y$10$CvAmkB18spIk2r.yGfsjUeHWLaHkrmTIFtgfIzdaISRhb76SSeDVu', '2024-04-29', '02:00:00', '03:00:00', 1, 3, 28, 2, '2024-04-28 14:24:25', '2024-04-28 14:24:25', '2024-04-28 14:24:25'),
(60, '$2y$10$kzCd3SsRwZPGvxMOE5H9aeQXLt66oKJ4viu8FpQ1cH5o4d4wEX.wu', '2024-04-29', '10:00:00', '11:00:00', 1, 3, 28, 4, '2024-04-28 14:24:36', '2024-04-28 14:24:36', '2024-04-28 14:24:36'),
(61, '$2y$10$97NOHzdehViN0T2pKZekcu5kdtSADXaPycjhaGr1ZubUUKt8RFMUy', '2024-04-29', '05:00:00', '06:00:00', 1, 3, 29, 2, '2024-04-28 15:00:53', '2024-04-28 15:00:53', '2024-04-28 15:00:53'),
(62, '$2y$10$1kipDzHiY4gmoW6Be6uigOTpTTgiZarSpq3wf0oiIuiHD.cWolQlu', '2024-04-29', '14:00:00', '16:00:00', 2, 4, 30, 2, '2024-04-28 15:02:19', '2024-04-28 15:02:19', '2024-04-28 15:02:19'),
(63, '$2y$10$.kllZ5pLQ4c0Wk1ObRouVOUtcN22v8IoBQ4fXqHH4gZhDKqr8ZTkO', '2024-04-29', '16:00:00', '18:00:00', 2, 4, 30, 4, '2024-04-28 15:02:30', '2024-04-28 15:02:30', '2024-04-28 15:02:30'),
(64, '$2y$10$5KS1F92gPs3R0toGsXTM0umsAIioGUy.GlemqDAd6vioIA8neiN6.', '2024-04-28', '15:00:00', '16:00:00', 1, 8, 30, 5, '2024-04-28 15:03:33', '2024-04-28 15:03:33', '2024-04-28 15:03:33'),
(65, '$2y$10$Shao9VR2BKZW3qKqH5o/..PghJwocmbkY4Yx9qy444fwEiLHVvj2O', '2024-04-29', '12:00:00', '14:00:00', 2, 5, 31, 4, '2024-04-28 15:05:26', '2024-04-28 15:05:26', '2024-04-28 15:05:26'),
(66, '$2y$10$bsf49SP9ha1HnL5RgKWkDuxZxkk8Jo4WjMOyhiaczcs4gkthx/4Hm', '2024-04-29', '14:00:00', '16:00:00', 2, 5, 31, 2, '2024-04-28 15:07:55', '2024-04-28 15:07:55', '2024-04-28 15:07:55'),
(67, '$2y$10$sU/5n2OYYTnDZKoE.xf84elfhFWxaQd7jXk8jjhXALhOFI665Fcbi', '2024-04-29', '12:00:00', '14:00:00', 2, 5, 31, 2, '2024-04-28 15:11:20', '2024-04-28 15:11:20', '2024-04-28 15:11:20'),
(68, '$2y$10$ROUYxgWrFnLuL4cixgbuWeOVoZso06gqpy0jU9zNDCx20srnU7h.2', '2024-04-29', '12:00:00', '14:00:00', 2, 5, 31, 2, '2024-04-28 15:12:02', '2024-04-28 15:12:02', '2024-04-28 15:12:02'),
(69, '$2y$10$3/H.oqYjOIvBDlogmv56LOeao76NAc.CJucgthNhMENtK1Cr69pcu', '2024-04-29', '12:00:00', '14:00:00', 2, 5, 31, 2, '2024-04-28 15:12:56', '2024-04-28 15:12:56', '2024-04-28 15:12:56'),
(70, '$2y$10$IBcH1NVYUWY1AhBATsm4mOwiQuJW6MyOpLnXNPXJF8u7Z/OhhENZq', '2024-04-29', '08:00:00', '09:00:00', 1, 3, 32, 2, NULL, '2024-04-28 15:14:50', '2024-04-28 15:16:11');

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

--
-- Table structure for table `reservation_payments`
--

CREATE TABLE `reservation_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payment_id` text DEFAULT NULL,
  `payment_log` text DEFAULT NULL,
  `room_cost` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `cobon_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reservation_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reservation_payments`
--

INSERT INTO `reservation_payments` (`id`, `payment_id`, `payment_log`, `room_cost`, `discount`, `tax`, `total`, `cobon_id`, `reservation_id`) VALUES
(13, '3785373', '{\"InvoiceId\":3785373,\"InvoiceReference\":\"2024000498\",\"CreatedDate\":\"April 18, 2024\",\"ExpireDate\":\"May 18, 2024\",\"InvoiceValue\":2.429,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"18/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"410917291927\",\"TrackId\":\"18-04-2024_1982731\",\"TransactionId\":\"291927\",\"PaymentId\":\"07073785373198273173\",\"AuthorizationId\":\"291927\",\"OrderId\":\"3785373\",\"InvoiceItems\":[{\"ProductName\":\" web.reservation \",\"UnitPrice\":\"2.429\",\"Quantity\":\"1\",\"ExtendedAmount\":\"2.429\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"30.000\",\"TransationValue\":\"2.429\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"2.430\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$V0Muu6sHJwo8/FHNZBNWmuKzqtav34f1rJVc0RjUeg/8pbYPaNOTO&failed_url=http://localhost:8888/chord/public/en/reservation/continue?date=2024-04-18&capacity=6&duration=1&paymentId=07073785332198271673&Id=07073785332198271673&paymentId=07073785347198272274&Id=07073785347198272274&lang=en\",\"InvoiceDisplayValue\":\"30.000 SR\"}', 5, NULL, NULL, 30, NULL, 13),
(14, '3785373', '{\"InvoiceId\":3785373,\"InvoiceReference\":\"2024000498\",\"CreatedDate\":\"April 18, 2024\",\"ExpireDate\":\"May 18, 2024\",\"InvoiceValue\":2.429,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"18/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"410917291927\",\"TrackId\":\"18-04-2024_1982731\",\"TransactionId\":\"291927\",\"PaymentId\":\"07073785373198273173\",\"AuthorizationId\":\"291927\",\"OrderId\":\"3785373\",\"InvoiceItems\":[{\"ProductName\":\" web.reservation \",\"UnitPrice\":\"2.429\",\"Quantity\":\"1\",\"ExtendedAmount\":\"2.429\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"30.000\",\"TransationValue\":\"2.429\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"2.430\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$V0Muu6sHJwo8/FHNZBNWmuKzqtav34f1rJVc0RjUeg/8pbYPaNOTO&failed_url=http://localhost:8888/chord/public/en/reservation/continue?date=2024-04-18&capacity=6&duration=1&paymentId=07073785332198271673&Id=07073785332198271673&paymentId=07073785347198272274&Id=07073785347198272274&lang=en\",\"InvoiceDisplayValue\":\"30.000 SR\"}', 5, NULL, NULL, 25, NULL, 14),
(15, NULL, NULL, 5, NULL, NULL, 60, NULL, 15),
(16, NULL, NULL, 5, NULL, NULL, 15, NULL, 16),
(17, NULL, NULL, 5, NULL, NULL, 15, NULL, 17),
(18, NULL, NULL, 5, NULL, NULL, 15, NULL, 18),
(19, NULL, NULL, 5, NULL, NULL, 45, NULL, 19),
(20, NULL, NULL, 5, NULL, NULL, 45, NULL, 20),
(21, NULL, NULL, 5, NULL, NULL, 45, NULL, 21),
(22, NULL, NULL, 5, NULL, NULL, 45, NULL, 22),
(23, NULL, NULL, 5, NULL, NULL, 45, NULL, 23),
(24, NULL, NULL, 5, NULL, NULL, 45, NULL, 24),
(25, NULL, NULL, 5, NULL, NULL, 45, NULL, 25),
(26, NULL, NULL, 5, NULL, NULL, 45, NULL, 26),
(27, '3790736', '{\"InvoiceId\":3790736,\"InvoiceReference\":\"2024000540\",\"CreatedDate\":\"April 20, 2024\",\"ExpireDate\":\"May 20, 2024\",\"InvoiceValue\":3.643,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"20/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411101295050\",\"TrackId\":\"20-04-2024_1983940\",\"TransactionId\":\"295050\",\"PaymentId\":\"07073790736198394074\",\"AuthorizationId\":\"295050\",\"OrderId\":\"3790736\",\"InvoiceItems\":[{\"ProductName\":\" web.reservation \",\"UnitPrice\":\"3.643\",\"Quantity\":\"1\",\"ExtendedAmount\":\"3.643\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"45.000\",\"TransationValue\":\"3.643\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"3.650\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$WP5xV/DjhLj.6WH3j3cFDOWb7AiWnh/ehVPNUfzNpHlSO0nBBFfJe&failed_url=http://localhost:8888/chord/public/en/reservation/continue?date=2024-04-20&capacity=3&duration=3&lang=en\",\"InvoiceDisplayValue\":\"45.000 SR\"}', 5, NULL, NULL, 45, NULL, 27),
(28, NULL, NULL, 5, NULL, NULL, 15, NULL, 28),
(29, NULL, NULL, 5, NULL, NULL, 30, NULL, 29),
(30, NULL, NULL, 5, NULL, NULL, 30, NULL, 30),
(31, NULL, NULL, 5, NULL, NULL, 45, NULL, 31),
(32, NULL, NULL, 5, NULL, NULL, 15, NULL, 32),
(33, '3799623', '{\"InvoiceId\":3799623,\"InvoiceReference\":\"2024000551\",\"CreatedDate\":\"April 22, 2024\",\"ExpireDate\":\"May 22, 2024\",\"InvoiceValue\":13.359,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965123\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"22/04/2024\",\"PaymentGateway\":\"MADA\",\"ReferenceId\":\"411221297167\",\"TrackId\":\"22-04-2024_1985861\",\"TransactionId\":\"297167\",\"PaymentId\":\"07073799623198586174\",\"AuthorizationId\":\"297167\",\"OrderId\":\"3799623\",\"InvoiceItems\":[{\"ProductName\":\" Reservation Room \",\"UnitPrice\":\"13.359\",\"Quantity\":\"1\",\"ExtendedAmount\":\"13.359\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"SR\",\"PaidCurrencyValue\":\"165.000\",\"TransationValue\":\"13.359\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"13.360\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$NsoFbWgkKNVcizEQonF38OUiTgayatwCebXvOKWx4SYeatb6lO5Bq&failed_url=https://chord.omar.alyomhost.org/reservation/continue?date=2024-04-26&capacity=3&duration=1&lang=en\",\"InvoiceDisplayValue\":\"165.000 SR\"}', 55, NULL, NULL, 165, NULL, 33),
(34, NULL, NULL, 5, NULL, NULL, 15, NULL, 34),
(35, '3803918', '{\"InvoiceId\":3803918,\"InvoiceReference\":\"2024000564\",\"CreatedDate\":\"April 22, 2024\",\"ExpireDate\":\"May 22, 2024\",\"InvoiceValue\":1.214,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+965581524763\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"22/04/2024\",\"PaymentGateway\":\"VISA/MASTER\",\"ReferenceId\":\"411312235883\",\"TrackId\":\"22-04-2024_1987004\",\"TransactionId\":\"235883\",\"PaymentId\":\"07073803918198700473\",\"AuthorizationId\":\"610300\",\"OrderId\":\"3803918\",\"InvoiceItems\":[{\"ProductName\":\" حجز الغرفة \",\"UnitPrice\":\"1.214\",\"Quantity\":\"1\",\"ExtendedAmount\":\"1.214\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"KD\",\"PaidCurrencyValue\":\"1.220\",\"TransationValue\":\"1.214\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"1.220\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$7jWJ1m8XfbUTvTmi5Pj76.USJ6MCQkGQAdCgoAMYIpm4ztgi.1qIO&failed_url=https://chord.omar.alyomhost.org/ar/reservation/continue?capacity=3&date=2024-04-23&duration=1&lang=ar\",\"InvoiceDisplayValue\":\"15.000 SR\"}', 5, NULL, NULL, 15, NULL, 35),
(36, NULL, NULL, 5, NULL, NULL, 15, NULL, 36),
(37, NULL, NULL, 5, NULL, NULL, 15, NULL, 37),
(38, NULL, NULL, 5, NULL, NULL, 15, NULL, 38),
(39, NULL, NULL, 55, NULL, NULL, 165, NULL, 39),
(40, NULL, NULL, 5, NULL, NULL, 15, NULL, 40),
(41, NULL, NULL, 5, NULL, NULL, 15, NULL, 41),
(42, NULL, NULL, 5, NULL, NULL, 15, NULL, 42),
(43, NULL, NULL, 5, NULL, NULL, 30, NULL, 43),
(44, NULL, NULL, 5, NULL, NULL, 30, NULL, 44),
(45, NULL, NULL, 5, NULL, NULL, 30, NULL, 45),
(46, NULL, NULL, 5, NULL, NULL, 30, NULL, 46),
(47, NULL, NULL, 5, NULL, NULL, 30, NULL, 47),
(48, NULL, NULL, 5, NULL, NULL, 30, NULL, 48),
(49, NULL, NULL, 5, NULL, NULL, 30, NULL, 49),
(50, NULL, NULL, 5, NULL, NULL, 30, NULL, 50),
(51, NULL, NULL, 5, NULL, NULL, 30, NULL, 51),
(52, NULL, NULL, 5, NULL, NULL, 30, NULL, 52),
(53, NULL, NULL, 5, NULL, NULL, 30, NULL, 53),
(54, NULL, NULL, 5, NULL, NULL, 30, NULL, 54),
(55, NULL, NULL, 5, NULL, NULL, 15, NULL, 55),
(56, NULL, NULL, 5, NULL, NULL, 15, NULL, 56),
(57, NULL, NULL, 55, NULL, NULL, 165, NULL, 57),
(58, NULL, NULL, 5, NULL, NULL, 15, NULL, 58),
(59, NULL, NULL, 5, NULL, NULL, 15, NULL, 59),
(60, NULL, NULL, 5, NULL, NULL, 15, NULL, 60),
(61, NULL, NULL, 5, NULL, NULL, 15, NULL, 61),
(62, NULL, NULL, 5, NULL, NULL, 40, NULL, 62),
(63, NULL, NULL, 5, NULL, NULL, 40, NULL, 63),
(64, NULL, NULL, 6000, NULL, NULL, 48000, NULL, 64),
(65, NULL, NULL, 5, NULL, NULL, 50, NULL, 65),
(66, NULL, NULL, 5, NULL, NULL, 50, NULL, 66),
(67, NULL, NULL, 5, NULL, NULL, 50, NULL, 67),
(68, NULL, NULL, 5, NULL, NULL, 50, NULL, 68),
(69, NULL, NULL, 5, NULL, NULL, 50, NULL, 69),
(70, '3839820', '{\"InvoiceId\":3839820,\"InvoiceReference\":\"2024000590\",\"CreatedDate\":\"April 28, 2024\",\"ExpireDate\":\"May 28, 2024\",\"InvoiceValue\":1.214,\"Comments\":\"\",\"CustomerName\":\"Chord\",\"CustomerMobile\":\"+9655012341231\",\"CustomerEmail\":\"info@cms.com\",\"TransactionDate\":\"28/04/2024\",\"PaymentGateway\":\"KNET\",\"ReferenceId\":\"411910000928\",\"TrackId\":\"28-04-2024_1995360\",\"TransactionId\":\"411910001641948\",\"PaymentId\":\"100411910000012997\",\"AuthorizationId\":\"B82877\",\"OrderId\":\"3839820\",\"InvoiceItems\":[{\"ProductName\":\" Reservation Room \",\"UnitPrice\":\"1.214\",\"Quantity\":\"1\",\"ExtendedAmount\":\"1.214\"}],\"TransactionStatus\":2,\"Error\":null,\"PaidCurrency\":\"KD\",\"PaidCurrencyValue\":\"1.220\",\"TransationValue\":\"1.214\",\"CustomerServiceCharge\":\"0.000\",\"DueValue\":\"1.220\",\"Currency\":\"KD\",\"ApiCustomFileds\":\"token=$2y$10$IBcH1NVYUWY1AhBATsm4mOwiQuJW6MyOpLnXNPXJF8u7Z/OhhENZq&failed_url=https://chord.omar.alyomhost.org/en/reservation/continue?date=2024-04-29&capacity=3&duration=1&lang=en\",\"InvoiceDisplayValue\":\"15.000 SR\"}', 5, NULL, NULL, 15, NULL, 70);

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `room_id` int(11) DEFAULT NULL,
  `start_count` int(11) DEFAULT NULL,
  `end_count` int(11) DEFAULT NULL,
  `cost` double DEFAULT NULL,
  `status_min` enum('true','false') NOT NULL DEFAULT 'false',
  `min_count` int(11) DEFAULT NULL,
  `external_image` varchar(300) DEFAULT NULL,
  `internal_image` varchar(300) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `rooms`
--

INSERT INTO `rooms` (`id`, `room_id`, `start_count`, `end_count`, `cost`, `status_min`, `min_count`, `external_image`, `internal_image`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 4234, 10, 35, 55, 'false', NULL, '/storage/photos/shares/images/rooms/2.jpg', '/storage/photos/shares/images/rooms/3.jpg', NULL, '2024-04-14 20:47:33', '2024-04-22 11:58:47'),
(2, 423423, 3, 44, 5, 'true', 3, '/storage/photos/shares/images/rooms/4.jpg', '/storage/photos/shares/images/rooms/4.jpg', NULL, '2024-04-14 20:49:00', '2024-04-22 11:58:47'),
(3, 423, 1, 3, 55, 'false', NULL, '/storage/photos/shares/images/ab1.jpg', '/storage/photos/shares/images/foot.jpg', NULL, '2024-04-14 20:47:33', '2024-04-22 11:58:47'),
(4, 42342, 3, 44, 5, 'true', 5, '/storage/photos/shares/images/room1.jpg', '/storage/photos/shares/images/room2.jpg', NULL, '2024-04-14 20:49:00', '2024-04-21 19:55:44'),
(5, 25552525, 6, 9, 6000, 'true', 3, '/storage/photos/shares/60db757a5207ef83cc9f6109_RFH_Browns_Hotel-sm.jpg', '/storage/photos/shares/download__1_.jpeg', NULL, '2024-04-22 12:05:51', '2024-04-22 12:05:51'),
(6, 3521, 10, 13, 70, 'true', 7, '/storage/photos/shares/60db757a5207ef83cc9f6109_RFH_Browns_Hotel-sm.jpg', NULL, NULL, '2024-04-23 00:00:57', '2024-04-23 00:04:51');

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

--
-- Table structure for table `room_descriptions`
--

CREATE TABLE `room_descriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `room_id` bigint(20) UNSIGNED DEFAULT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `room_descriptions`
--

INSERT INTO `room_descriptions` (`id`, `name`, `description`, `room_id`, `language_id`) VALUES
(15, 'BASIC ROOM', 'BASIC ROOM', 4, 1),
(16, 'BASIC ROOM', 'BASIC ROOM', 4, 2),
(17, 'Deluxe Room', 'Deluxe Room', 3, 1),
(18, 'Deluxe Room', 'Deluxe Room', 3, 2),
(19, 'Basic Room 2', 'Basic Room 2', 2, 1),
(20, 'Basic Room 2', 'Basic Room 2', 2, 2),
(21, 'Deluxe Room 2', 'Deluxe Room 2', 1, 1),
(22, 'Deluxe Room 2', 'Deluxe Room 2', 1, 2),
(25, 'غرفة ديلوكس', 'أن تكــون الشـركـة نموذجاً مرجعياً متميزاً في التطوير العقاري ذات حلول محورية ، محليـاً وإقليمياً ، وأن تحافظ على الريادة والأصالة وتسبق طموحات عملائها في مستوى خدماتها ، وإرضاء مساهميها ، ورقي مجتمعها وتنميته.', 5, 1),
(26, 'deluxe room', 'To be a distinct reference model in real estate development with pivotal solutions, locally and regionally, and to maintain leadership and authenticity and precede the aspirations of its clients in the level of its services, satisfy its shareholders, and advance and develop its community.', 5, 2),
(31, 'حجز الغرف – [من 12 ظهرا – 12 مساءا]', 'أفضل غرفة يمكن أن يحصل عليها أي شخص', 6, 1),
(32, 'Room reservations – [12 AM – 12 PM]', 'The best Room anyone can have', 6, 2);

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(100) NOT NULL,
  `value` text 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 `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'website_name', 'Chord', '2024-04-14 15:17:54', NULL),
(2, 'keywords', 'Zb9a52e5Kn6rYf3P', '2024-04-14 15:17:54', NULL),
(3, 'meta_description', 'VDJ8XOK0O3hXFKTn', '2024-04-14 15:17:54', NULL),
(4, 'site_email', 'info@cms.com', '2024-04-14 15:17:54', NULL),
(5, 'site_address_ar', '1xHIeCjqacYH8c3n', '2024-04-14 15:17:54', NULL),
(6, 'site_phone', '123456789', '2024-04-14 15:17:54', NULL),
(7, 'mail_driver', 'smtp', '2024-04-14 15:17:54', NULL),
(8, 'mail_host', 'smtp.mailtrap.io', '2024-04-14 15:17:54', NULL),
(9, 'mail_port', '2525', '2024-04-14 15:17:54', NULL),
(10, 'mail_username', '759b99df94f0be', '2024-04-14 15:17:54', NULL),
(11, 'mail_password', 'e4c5c123acd614', '2024-04-14 15:17:54', NULL),
(12, 'mail_encryption', 'tls', '2024-04-14 15:17:54', NULL),
(13, 'mail_from_address', 'info@cms.com', '2024-04-14 15:17:54', NULL),
(14, 'mail_from_name', 'CMS', '2024-04-14 15:17:54', NULL),
(15, 'website_logo', 'logo.png', '2024-04-14 15:17:54', NULL),
(16, 'website_disable', '0', '2024-04-14 15:17:54', NULL),
(17, 'dashboard_disable', '0', '2024-04-14 15:17:54', NULL),
(18, 'tax', '10', NULL, NULL),
(19, 'pickup_hours', '1', NULL, NULL),
(20, 'instagram', 'https://instagram.com', NULL, NULL),
(21, 'tiktok', 'https://tiktok.com', NULL, NULL),
(22, 'whatsapp', '123456789', '2024-04-14 15:17:54', NULL),
(23, 'opining_time', '\r\n                        <p> Opening hours </p>\r\n                        <h6> Daily From 12pm to 12am except </h6>\r\n                        <h6> Friday From 1Pm-12am </h6>', '2024-04-14 15:17:54', NULL),
(24, 'site_address_en', '1xHIeCjqacYH8c3n', '2024-04-14 15:17:54', NULL),
(25, 'facebook', 'https://facebook.com', NULL, NULL);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(300) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '/storage/photos/shares/images/room5.jpg', NULL, '2024-04-14 16:34:01', '2024-04-21 20:46:55'),
(2, '/storage/photos/shares/images/room4.jpg', NULL, '2024-04-21 20:47:16', '2024-04-21 20:47:16'),
(3, '/storage/photos/shares/images/room3.jpg', NULL, '2024-04-21 20:47:36', '2024-04-21 20:47:36'),
(4, '/storage/photos/shares/images/room2.jpg', NULL, '2024-04-21 20:47:54', '2024-04-21 20:47:54'),
(5, '/storage/photos/shares/images/room1.jpg', NULL, '2024-04-21 20:48:14', '2024-04-21 20:48:14'),
(6, '/storage/photos/shares/images/room6.jpg', NULL, '2024-04-21 20:48:29', '2024-04-21 20:48:29'),
(7, '/storage/photos/shares/60db757a5207ef83cc9f6109_RFH_Browns_Hotel-sm.jpg', NULL, '2024-04-22 12:50:08', '2024-04-22 12:50:08');

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

--
-- Table structure for table `slider_descriptions`
--

CREATE TABLE `slider_descriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `slider_id` bigint(20) UNSIGNED DEFAULT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slider_descriptions`
--

INSERT INTO `slider_descriptions` (`id`, `name`, `slider_id`, `language_id`) VALUES
(5, 'test', 1, 1),
(6, 'test', 1, 2),
(7, 'test1', 2, 1),
(8, 'test1', 2, 2),
(9, 'test2', 3, 1),
(10, 'test2', 3, 2),
(11, 'test3', 4, 1),
(12, 'test3', 4, 2),
(13, 'test4', 5, 1),
(14, 'test4', 5, 2),
(15, 'test5', 6, 1),
(16, 'test5', 6, 2),
(17, 'امير الغانم', 7, 1),
(18, 'امير الغانم', 7, 2);

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

--
-- Table structure for table `table_numbers`
--

CREATE TABLE `table_numbers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` text DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `table_numbers`
--

INSERT INTO `table_numbers` (`id`, `number`, `deleted_at`, `created_at`, `updated_at`) VALUES
(2, 'Table 3', NULL, '2024-04-14 19:39:33', '2024-04-22 22:26:42'),
(3, 'Table 2', NULL, '2024-04-14 19:39:33', '2024-04-22 22:26:32'),
(4, 'Table 1', NULL, '2024-04-14 19:39:33', '2024-04-22 22:26:17'),
(5, 'Table 4', NULL, '2024-04-22 22:26:49', '2024-04-22 22:26:49'),
(6, 'Table 5', NULL, '2024-04-22 22:26:56', '2024-04-22 22:26:56'),
(7, 'Table 6', NULL, '2024-04-22 22:27:07', '2024-04-22 22:27:07'),
(8, 'Table 7', NULL, '2024-04-22 22:27:15', '2024-04-22 22:27:15'),
(9, 'Table 8', NULL, '2024-04-22 22:27:21', '2024-04-22 22:27:21'),
(10, 'Table 9', NULL, '2024-04-22 22:27:28', '2024-04-22 22:27:28');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(300) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `phone` varchar(14) DEFAULT NULL,
  `photo` varchar(300) NOT NULL DEFAULT 'user.png',
  `admin_token` varchar(1000) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `role` enum('super_admin','admin','sub_admin','user') NOT NULL DEFAULT 'admin',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `photo`, `admin_token`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Super Admin', 'super@admin.com', '123', 'user.png', NULL, '2024-04-14 15:17:54', '$2y$10$4LSIx.B7UhrTI1PWqesTtehrarR7ho9wZY8cwhkzzkWd0ryUA4paS', 'super_admin', 'lEqamuQF6StSUNIWSromklGlgXklj0VQpLmtetqTBflmwHIHAxAiQFrTYK8V', NULL, NULL, NULL),
(2, 'Admin', 'admin@admin.com', '000000000', 'logo.png', NULL, '2024-04-14 15:17:54', '$2y$10$LWb/W2aitocfFLo1gf.ZWOIjfKkptuMg4JxwDIcbSYx2PeXQkrAs2', 'admin', 'oMzpof5WDrWyxX04CgvuY9qBaZymEnmqWbm72mcNesVb0zOYJ4PH3DfdffOb', NULL, '2024-04-21 20:50:10', NULL),
(3, 'Sub Admin', 'sub@admin.com', NULL, 'user.png', NULL, '2024-04-14 15:17:54', '$2y$10$K6WuzxYdX5XbDeIPmk58ReJ.4b0KaJy03pJM6Ff5rklyABjsdQ.5.', 'sub_admin', 'wtlpHZCHB3', NULL, NULL, NULL),
(4, NULL, NULL, '123123123', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-14 15:42:59', '2024-04-14 15:42:59', NULL),
(7, NULL, NULL, '432432423', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-18 00:26:01', '2024-04-18 00:26:01', NULL),
(8, NULL, NULL, '4684616', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-18 00:27:04', '2024-04-18 00:27:04', NULL),
(9, NULL, NULL, '423423', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-21 14:21:58', '2024-04-21 14:21:58', NULL),
(10, NULL, NULL, '7567567', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-21 14:24:26', '2024-04-21 14:24:26', NULL),
(11, NULL, NULL, '876876', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-21 14:25:04', '2024-04-21 14:25:04', NULL),
(12, NULL, NULL, '0000223', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-21 14:27:35', '2024-04-21 14:27:35', NULL),
(13, NULL, NULL, '0523456789', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 00:37:39', '2024-04-22 00:37:39', NULL),
(14, NULL, NULL, '966501231241', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 07:32:55', '2024-04-22 07:32:55', NULL),
(15, NULL, NULL, '581524713', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 09:50:25', '2024-04-22 09:50:25', NULL),
(16, NULL, NULL, '0500000010', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 09:51:58', '2024-04-22 09:51:58', NULL),
(17, NULL, NULL, '581524736', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 11:15:15', '2024-04-22 11:15:15', NULL),
(18, NULL, NULL, '581524763', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 11:50:21', '2024-04-22 11:50:22', NULL),
(19, NULL, NULL, '581524788', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 13:23:48', '2024-04-22 13:23:48', NULL),
(20, NULL, NULL, '581524796', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-22 13:59:11', '2024-04-22 13:59:11', NULL),
(21, NULL, NULL, '966587578578', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-23 09:41:48', '2024-04-23 09:41:48', NULL),
(22, NULL, NULL, '506123456', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-23 09:50:11', '2024-04-23 09:50:11', NULL),
(23, NULL, NULL, '966543605073', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-24 08:57:52', '2024-04-24 08:57:52', NULL),
(24, NULL, NULL, '502134565', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 10:36:54', '2024-04-28 10:36:54', NULL),
(25, NULL, NULL, '581523620', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 11:07:48', '2024-04-28 11:07:48', NULL),
(26, 'Abdullah Thabet', 'abdullahr999@gmail.com', '543605073', 'logo.png', NULL, NULL, '$2y$10$Tqf3wTB2ldxJgRjdeZNQe.jQmS.Sqp3hMEdUCckhXSyszGSffExLO', 'admin', NULL, '2024-04-28 11:27:11', '2024-04-28 11:27:11', NULL),
(27, NULL, NULL, '501234567', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 12:33:52', '2024-04-28 12:33:52', NULL),
(28, NULL, NULL, '966501231234', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 14:21:06', '2024-04-28 14:21:06', NULL),
(29, NULL, NULL, '508745632', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 14:58:58', '2024-04-28 14:58:58', NULL),
(30, NULL, NULL, '966501231232', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 15:01:39', '2024-04-28 15:01:39', NULL),
(31, NULL, NULL, '966512345612', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 15:04:50', '2024-04-28 15:04:50', NULL),
(32, NULL, NULL, '5012341231', 'user.png', NULL, NULL, NULL, 'user', NULL, '2024-04-28 15:14:19', '2024-04-28 15:14:19', NULL);

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

--
-- Table structure for table `user_modules`
--

CREATE TABLE `user_modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `module_id` bigint(20) UNSIGNED 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 `user_modules`
--

INSERT INTO `user_modules` (`id`, `user_id`, `module_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL),
(2, 1, 2, NULL, NULL),
(3, 1, 3, NULL, NULL),
(4, 1, 4, NULL, NULL),
(5, 1, 5, NULL, NULL),
(6, 1, 6, NULL, NULL),
(7, 1, 7, NULL, NULL),
(8, 1, 8, NULL, NULL),
(9, 1, 9, NULL, NULL),
(10, 1, 10, NULL, NULL),
(11, 1, 11, NULL, NULL),
(12, 1, 12, NULL, NULL),
(13, 1, 13, NULL, NULL),
(14, 1, 14, NULL, NULL),
(15, 1, 15, NULL, NULL),
(16, 2, 1, NULL, NULL),
(17, 2, 2, NULL, NULL),
(18, 2, 3, NULL, NULL),
(19, 2, 4, NULL, NULL),
(20, 2, 5, NULL, NULL),
(21, 2, 6, NULL, NULL),
(22, 2, 7, NULL, NULL),
(23, 2, 8, NULL, NULL),
(24, 2, 9, NULL, NULL),
(25, 2, 10, NULL, NULL),
(26, 2, 11, NULL, NULL),
(27, 2, 12, NULL, NULL),
(28, 2, 13, NULL, NULL),
(29, 2, 14, NULL, NULL),
(30, 2, 15, NULL, NULL),
(31, 26, 1, NULL, NULL),
(32, 26, 2, NULL, NULL),
(33, 26, 3, NULL, NULL),
(34, 26, 4, NULL, NULL),
(35, 26, 5, NULL, NULL),
(36, 26, 6, NULL, NULL),
(37, 26, 7, NULL, NULL),
(38, 26, 8, NULL, NULL),
(39, 26, 9, NULL, NULL),
(40, 26, 10, NULL, NULL),
(41, 26, 11, NULL, NULL),
(42, 26, 12, NULL, NULL),
(43, 26, 13, NULL, NULL),
(44, 26, 14, NULL, NULL),
(45, 26, 15, NULL, NULL);

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

--
-- Table structure for table `visitor_messages`
--

CREATE TABLE `visitor_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `subject` text DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `reply` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `visitor_messages`
--

INSERT INTO `visitor_messages` (`id`, `name`, `email`, `phone`, `subject`, `message`, `read`, `reply`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'data', 'data259@data.com', NULL, 'dasd', 'dasdas', 0, 0, NULL, '2024-04-17 04:55:25', '2024-04-17 04:55:25'),
(2, 'data', 'data2259@data.com', NULL, 'data', 'data', 0, 0, NULL, '2024-04-17 05:01:27', '2024-04-17 05:01:27'),
(3, 'Ahmed Ali Radwan Ahmed Ali', 'ahmed@gmial.com', NULL, 'my name', 'thank you very much', 1, 0, NULL, '2024-04-22 09:43:08', '2024-04-22 22:44:55'),
(4, 'Moataz', 'moataz@gmail.com', NULL, 'complain', 'hey there', 1, 0, NULL, '2024-04-22 22:46:15', '2024-04-22 22:46:27');

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

--
-- Table structure for table `visitor_message_replies`
--

CREATE TABLE `visitor_message_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reply` text DEFAULT NULL,
  `visitor_email` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `visitor_message_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `website_visitors`
--

CREATE TABLE `website_visitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(45) 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 `website_visitors`
--

INSERT INTO `website_visitors` (`id`, `ip`, `created_at`, `updated_at`) VALUES
(55, '197.35.205.228', '2024-04-22 00:36:31', '2024-04-22 00:36:31'),
(56, '51.81.46.212', '2024-04-22 01:30:05', '2024-04-22 01:30:05'),
(57, '128.90.61.190', '2024-04-22 02:21:37', '2024-04-22 02:21:37'),
(58, '31.6.10.68', '2024-04-22 02:21:37', '2024-04-22 02:21:37'),
(59, '161.35.246.138', '2024-04-22 02:21:38', '2024-04-22 02:21:38'),
(60, '185.232.22.209', '2024-04-22 02:21:38', '2024-04-22 02:21:38'),
(61, '23.83.184.137', '2024-04-22 02:21:39', '2024-04-22 02:21:39'),
(62, '197.35.205.104', '2024-04-22 07:05:00', '2024-04-22 07:05:00'),
(63, '44.206.243.3', '2024-04-22 08:01:42', '2024-04-22 08:01:42'),
(64, '197.35.205.104', '2024-04-22 08:58:29', '2024-04-22 08:58:29'),
(65, '197.63.45.106', '2024-04-22 09:41:19', '2024-04-22 09:41:19'),
(66, '67.202.59.161', '2024-04-22 10:57:22', '2024-04-22 10:57:22'),
(67, '54.86.65.32', '2024-04-22 10:58:24', '2024-04-22 10:58:24'),
(68, '34.201.5.172', '2024-04-22 11:04:03', '2024-04-22 11:04:03'),
(69, '149.154.161.252', '2024-04-22 11:43:42', '2024-04-22 11:43:42'),
(70, '197.35.205.104', '2024-04-22 11:43:46', '2024-04-22 11:43:46'),
(71, '197.35.205.104', '2024-04-22 12:03:42', '2024-04-22 12:03:42'),
(72, '149.154.161.251', '2024-04-22 12:12:19', '2024-04-22 12:12:19'),
(73, '3.239.182.136', '2024-04-22 12:16:41', '2024-04-22 12:16:41'),
(74, '3.239.182.136', '2024-04-22 12:16:41', '2024-04-22 12:16:41'),
(75, '18.209.248.88', '2024-04-22 12:30:19', '2024-04-22 12:30:19'),
(76, '54.86.65.32', '2024-04-22 12:36:08', '2024-04-22 12:36:08'),
(77, '149.154.161.252', '2024-04-22 12:52:04', '2024-04-22 12:52:04'),
(78, '149.154.161.204', '2024-04-22 12:54:48', '2024-04-22 12:54:48'),
(79, '197.63.45.106', '2024-04-22 12:55:48', '2024-04-22 12:55:48'),
(80, '54.165.104.187', '2024-04-22 12:59:29', '2024-04-22 12:59:29'),
(81, '54.165.104.187', '2024-04-22 12:59:30', '2024-04-22 12:59:30'),
(82, '3.92.81.188', '2024-04-22 13:03:41', '2024-04-22 13:03:41'),
(83, '3.92.81.188', '2024-04-22 13:03:42', '2024-04-22 13:03:42'),
(84, '149.154.161.252', '2024-04-22 13:18:31', '2024-04-22 13:18:31'),
(85, '197.35.205.104', '2024-04-22 13:20:41', '2024-04-22 13:20:41'),
(86, '197.35.205.104', '2024-04-22 13:22:53', '2024-04-22 13:22:53'),
(87, '104.166.80.147', '2024-04-22 22:06:55', '2024-04-22 22:06:55'),
(88, '104.166.80.49', '2024-04-22 22:07:30', '2024-04-22 22:07:30'),
(89, '156.197.51.69', '2024-04-22 22:20:10', '2024-04-22 22:20:10'),
(90, '68.183.207.226', '2024-04-23 01:22:38', '2024-04-23 01:22:38'),
(91, '68.183.207.226', '2024-04-23 01:22:38', '2024-04-23 01:22:38'),
(92, '65.154.226.171', '2024-04-23 05:37:14', '2024-04-23 05:37:14'),
(93, '156.197.26.202', '2024-04-23 09:38:17', '2024-04-23 09:38:17'),
(94, '156.197.41.98', '2024-04-23 09:46:52', '2024-04-23 09:46:52'),
(95, '156.197.26.202', '2024-04-23 10:24:52', '2024-04-23 10:24:52'),
(96, '54.88.116.243', '2024-04-23 10:46:03', '2024-04-23 10:46:03'),
(97, '156.197.26.202', '2024-04-23 11:55:20', '2024-04-23 11:55:20'),
(98, '54.226.81.146', '2024-04-23 13:39:39', '2024-04-23 13:39:39'),
(99, '197.63.186.194', '2024-04-23 13:40:19', '2024-04-23 13:40:19'),
(100, '197.63.186.194', '2024-04-23 13:40:22', '2024-04-23 13:40:22'),
(101, '44.222.228.90', '2024-04-23 14:33:53', '2024-04-23 14:33:53'),
(102, '3.238.121.148', '2024-04-23 14:41:10', '2024-04-23 14:41:10'),
(103, '44.220.132.231', '2024-04-23 14:41:10', '2024-04-23 14:41:10'),
(104, '54.158.14.135', '2024-04-23 14:41:10', '2024-04-23 14:41:10'),
(105, '206.189.137.162', '2024-04-23 14:57:28', '2024-04-23 14:57:28'),
(106, '206.189.137.162', '2024-04-23 14:57:29', '2024-04-23 14:57:29'),
(107, '64.23.129.114', '2024-04-23 19:02:29', '2024-04-23 19:02:29'),
(108, '64.23.129.114', '2024-04-23 19:02:29', '2024-04-23 19:02:29'),
(109, '104.166.80.190', '2024-04-23 22:02:10', '2024-04-23 22:02:10'),
(110, '104.166.80.92', '2024-04-23 22:03:26', '2024-04-23 22:03:26'),
(111, '35.192.73.84', '2024-04-23 23:26:59', '2024-04-23 23:26:59'),
(112, '145.82.195.87', '2024-04-24 08:05:45', '2024-04-24 08:05:45'),
(113, '145.82.195.87', '2024-04-24 09:25:55', '2024-04-24 09:25:55'),
(114, '145.82.195.87', '2024-04-24 09:26:37', '2024-04-24 09:26:37'),
(115, '197.35.227.40', '2024-04-24 14:30:02', '2024-04-24 14:30:02'),
(116, '104.166.80.5', '2024-04-24 21:54:02', '2024-04-24 21:54:02'),
(117, '104.166.80.4', '2024-04-24 21:56:22', '2024-04-24 21:56:22'),
(118, '145.82.195.87', '2024-04-25 05:38:55', '2024-04-25 05:38:55'),
(119, '34.204.166.183', '2024-04-25 09:14:11', '2024-04-25 09:14:11'),
(120, '44.222.228.90', '2024-04-25 09:14:11', '2024-04-25 09:14:11'),
(121, '44.212.12.183', '2024-04-25 09:14:11', '2024-04-25 09:14:11'),
(122, '156.197.19.210', '2024-04-25 09:20:13', '2024-04-25 09:20:13'),
(123, '3.227.232.103', '2024-04-25 09:23:40', '2024-04-25 09:23:40'),
(124, '34.207.65.165', '2024-04-25 09:24:11', '2024-04-25 09:24:11'),
(125, '149.154.161.216', '2024-04-25 09:27:34', '2024-04-25 09:27:34'),
(126, '156.197.19.210', '2024-04-25 09:27:41', '2024-04-25 09:27:41'),
(127, '197.35.201.195', '2024-04-25 14:57:36', '2024-04-25 14:57:36'),
(128, '197.35.201.195', '2024-04-25 14:58:58', '2024-04-25 14:58:58'),
(129, '209.97.130.21', '2024-04-25 19:39:25', '2024-04-25 19:39:25'),
(130, '209.97.130.21', '2024-04-25 19:39:25', '2024-04-25 19:39:25'),
(131, '104.166.80.55', '2024-04-25 21:58:14', '2024-04-25 21:58:14'),
(132, '104.166.80.38', '2024-04-25 21:59:17', '2024-04-25 21:59:17'),
(133, '104.166.80.141', '2024-04-26 22:12:10', '2024-04-26 22:12:10'),
(134, '104.166.80.254', '2024-04-26 22:12:37', '2024-04-26 22:12:37'),
(135, '104.166.80.194', '2024-04-27 22:10:35', '2024-04-27 22:10:35'),
(136, '104.166.80.198', '2024-04-27 22:13:15', '2024-04-27 22:13:15'),
(137, '197.35.195.14', '2024-04-28 10:20:23', '2024-04-28 10:20:23'),
(138, '141.164.149.212', '2024-04-28 11:26:25', '2024-04-28 11:26:25'),
(139, '141.164.149.212', '2024-04-28 12:08:18', '2024-04-28 12:08:18'),
(140, '197.35.203.74', '2024-04-28 12:34:54', '2024-04-28 12:34:54'),
(141, '197.63.23.201', '2024-04-28 12:36:38', '2024-04-28 12:36:38'),
(142, '197.35.195.14', '2024-04-28 14:58:33', '2024-04-28 14:58:33'),
(143, '156.197.9.121', '2024-04-28 15:00:27', '2024-04-28 15:00:27'),
(144, '197.63.23.201', '2024-04-28 16:41:24', '2024-04-28 16:41:24'),
(145, '104.166.80.64', '2024-04-28 22:07:19', '2024-04-28 22:07:19'),
(146, '104.166.80.92', '2024-04-28 22:10:19', '2024-04-28 22:10:19'),
(147, '141.164.149.212', '2024-04-29 05:01:37', '2024-04-29 05:01:37'),
(148, '141.164.149.212', '2024-04-29 07:20:11', '2024-04-29 07:20:11');

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

--
-- Table structure for table `work_days`
--

CREATE TABLE `work_days` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `day` enum('Saturday','Sunday','Monday','Tuesday','Wednesday','Thursday','Friday') NOT NULL DEFAULT 'Saturday',
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `work_days`
--

INSERT INTO `work_days` (`id`, `day`, `start_time`, `end_time`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Saturday', '02:39:57', '23:39:57', NULL, NULL, NULL),
(2, 'Sunday', '13:39:57', '23:39:57', NULL, NULL, NULL),
(3, 'Monday', '02:39:57', '23:39:57', NULL, NULL, NULL),
(4, 'Tuesday', '02:39:57', '23:39:57', NULL, NULL, NULL),
(5, 'Wednesday', '02:39:57', '23:39:57', NULL, NULL, NULL),
(6, 'Thursday', '02:39:57', '23:39:57', NULL, NULL, NULL),
(7, 'Friday', '13:00:57', '23:59:57', NULL, NULL, '2024-04-22 23:00:25');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `banner_descriptions`
--
ALTER TABLE `banner_descriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `banner_descriptions_language_id_foreign` (`language_id`),
  ADD KEY `banner_descriptions_banner_id_language_id_index` (`banner_id`,`language_id`);

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

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_user_id_index` (`user_id`);

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

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `languages_local_unique` (`local`),
  ADD KEY `languages_status_index` (`status`),
  ADD KEY `languages_admin_status_index` (`admin_status`);

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_room_id_foreign` (`room_id`),
  ADD KEY `orders_table_number_id_foreign` (`table_number_id`),
  ADD KEY `orders_user_id_table_number_id_room_id_index` (`user_id`,`table_number_id`,`room_id`),
  ADD KEY `orders_reservation_id_foreign` (`reservation_id`);

--
-- Indexes for table `order_payments`
--
ALTER TABLE `order_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_payments_cobon_id_foreign` (`cobon_id`),
  ADD KEY `order_payments_order_id_cobon_id_index` (`order_id`,`cobon_id`);

--
-- Indexes for table `order_products`
--
ALTER TABLE `order_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_descriptions_order_id_index` (`order_id`);

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

--
-- Indexes for table `page_descriptions`
--
ALTER TABLE `page_descriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `page_descriptions_language_id_foreign` (`language_id`),
  ADD KEY `page_descriptions_page_id_language_id_index` (`page_id`,`language_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

--
-- Indexes for table `reservations`
--
ALTER TABLE `reservations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reservations_room_id_foreign` (`room_id`),
  ADD KEY `reservations_user_id_room_id_index` (`user_id`,`room_id`);

--
-- Indexes for table `reservation_payments`
--
ALTER TABLE `reservation_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reservation_payments_cobon_id_foreign` (`cobon_id`),
  ADD KEY `reservation_payments_reservation_id_cobon_id_index` (`reservation_id`,`cobon_id`);

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

--
-- Indexes for table `room_descriptions`
--
ALTER TABLE `room_descriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `room_descriptions_language_id_foreign` (`language_id`),
  ADD KEY `room_descriptions_room_id_language_id_index` (`room_id`,`language_id`);

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

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

--
-- Indexes for table `slider_descriptions`
--
ALTER TABLE `slider_descriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slider_descriptions_language_id_foreign` (`language_id`),
  ADD KEY `slider_descriptions_slider_id_language_id_index` (`slider_id`,`language_id`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `users_phone_unique` (`phone`);

--
-- Indexes for table `user_modules`
--
ALTER TABLE `user_modules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_modules_module_id_foreign` (`module_id`),
  ADD KEY `user_modules_user_id_module_id_index` (`user_id`,`module_id`);

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

--
-- Indexes for table `visitor_message_replies`
--
ALTER TABLE `visitor_message_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visitor_message_replies_user_id_visitor_message_id_index` (`user_id`,`visitor_message_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `banner_descriptions`
--
ALTER TABLE `banner_descriptions`
  ADD CONSTRAINT `banner_descriptions_banner_id_foreign` FOREIGN KEY (`banner_id`) REFERENCES `banners` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `banner_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `reservations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orders_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orders_table_number_id_foreign` FOREIGN KEY (`table_number_id`) REFERENCES `table_numbers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_payments`
--
ALTER TABLE `order_payments`
  ADD CONSTRAINT `order_payments_cobon_id_foreign` FOREIGN KEY (`cobon_id`) REFERENCES `cobons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_products`
--
ALTER TABLE `order_products`
  ADD CONSTRAINT `order_descriptions_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `page_descriptions`
--
ALTER TABLE `page_descriptions`
  ADD CONSTRAINT `page_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `page_descriptions_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `reservations`
--
ALTER TABLE `reservations`
  ADD CONSTRAINT `reservations_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `reservations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `reservation_payments`
--
ALTER TABLE `reservation_payments`
  ADD CONSTRAINT `reservation_payments_cobon_id_foreign` FOREIGN KEY (`cobon_id`) REFERENCES `cobons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `reservation_payments_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `reservations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `room_descriptions`
--
ALTER TABLE `room_descriptions`
  ADD CONSTRAINT `room_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `room_descriptions_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `slider_descriptions`
--
ALTER TABLE `slider_descriptions`
  ADD CONSTRAINT `slider_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `slider_descriptions_slider_id_foreign` FOREIGN KEY (`slider_id`) REFERENCES `sliders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_modules`
--
ALTER TABLE `user_modules`
  ADD CONSTRAINT `user_modules_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_modules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

