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

START TRANSACTION;



--
-- Database: `pvh_pms`
--

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'system',
  `subject_id` bigint UNSIGNED DEFAULT NULL,
  `subject_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `properties` json DEFAULT NULL,
  `created_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `channel_configs`
--

CREATE TABLE `channel_configs` (
  `id` bigint UNSIGNED NOT NULL,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate_plan_id` bigint UNSIGNED DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `notes` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channel_configs`
--

INSERT INTO `channel_configs` (`id`, `source`, `rate_plan_id`, `active`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'Walk-in', NULL, 1, 'Direct walk-in guests; rack rate applies.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(2, 'Direct (Phone)', NULL, 1, 'Phone / email direct bookings.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(3, 'Website', 1, 1, 'Hotel website bookings; advance purchase rate.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(4, 'Booking.com', 1, 1, 'OTA — commission ~15%. Advance purchase rate.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(5, 'Agoda', 1, 1, 'OTA — commission ~12%. Advance purchase rate.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(6, 'Airbnb', NULL, 1, 'OTA — service fee model, no fixed commission.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(7, 'Expedia', 1, 1, 'OTA — commission ~15%. Advance purchase rate.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(8, 'Travel Agent', 4, 1, 'B2B travel agents; group rate applies.', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(9, 'Corporate', 5, 1, 'Contracted corporate accounts.', '2026-06-17 23:03:36', '2026-06-17 23:03:36');

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

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

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

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

--
-- Table structure for table `folio_charges`
--

CREATE TABLE `folio_charges` (
  `id` bigint UNSIGNED NOT NULL,
  `reservation_id` bigint UNSIGNED NOT NULL,
  `pos_transaction_id` bigint UNSIGNED DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `quantity` smallint UNSIGNED NOT NULL DEFAULT '1',
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'other',
  `charge_date` date NOT 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 `folio_charges`
--

INSERT INTO `folio_charges` (`id`, `reservation_id`, `pos_transaction_id`, `description`, `amount`, `quantity`, `category`, `charge_date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, NULL, 'Coffee (Hot)', '65.00', 2, 'food_beverage', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(2, 1, NULL, 'Breakfast Set A', '250.00', 2, 'food_beverage', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(3, 1, NULL, 'Bottled Water (500ml)', '25.00', 2, 'food_beverage', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(4, 1, NULL, 'Beer – San Miguel Pale', '85.00', 3, 'minibar', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(5, 1, NULL, 'Pringles Original', '120.00', 2, 'minibar', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(6, 1, NULL, 'Nuts & Crackers', '75.00', 1, 'minibar', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(7, 34, NULL, 'T-Shirt / Polo', '35.00', 4, 'laundry', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(8, 34, NULL, 'Pants / Jeans', '50.00', 2, 'laundry', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(9, 34, NULL, 'Dress / Blouse', '45.00', 2, 'laundry', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(10, 34, NULL, 'Underwear / Socks', '20.00', 3, 'laundry', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(11, 2, NULL, 'Lunch Set', '350.00', 1, 'food_beverage', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(12, 2, NULL, 'Rice (per serving)', '30.00', 2, 'food_beverage', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(13, 2, NULL, 'Orange Juice', '85.00', 1, 'food_beverage', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(14, 2, NULL, 'Softdrinks (Regular)', '45.00', 2, 'food_beverage', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(15, 2, NULL, 'Internet Day Pass', '100.00', 1, 'other', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(16, 2, NULL, 'Printing (per page)', '5.00', 8, 'other', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(17, 4, NULL, 'Dinner Set', '450.00', 2, 'food_beverage', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(18, 4, NULL, 'Rice (per serving)', '30.00', 3, 'food_beverage', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(19, 4, NULL, 'Hot Chocolate', '75.00', 2, 'food_beverage', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(20, 27, NULL, 'Filipino Breakfast Set', '280.00', 1, 'food_beverage', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(21, 27, NULL, 'Coffee (Hot)', '65.00', 2, 'food_beverage', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(22, 27, NULL, 'Toast & Butter', '75.00', 1, 'food_beverage', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(23, 27, NULL, 'Orange Juice', '85.00', 1, 'food_beverage', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(24, 28, NULL, 'Bedsheet Set', '120.00', 1, 'laundry', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(25, 28, NULL, 'T-Shirt / Polo', '35.00', 3, 'laundry', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(26, 28, NULL, 'Pants / Jeans', '50.00', 2, 'laundry', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(27, 29, NULL, 'Extra Pillow', '100.00', 2, 'other', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(28, 29, NULL, 'Extra Blanket', '150.00', 1, 'other', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(29, 29, NULL, 'Baby Cot', '300.00', 1, 'other', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(30, 30, NULL, 'Beer – San Miguel Light', '90.00', 2, 'minibar', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(31, 30, NULL, 'Pringles Original', '120.00', 1, 'minibar', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(32, 30, NULL, 'Snickers Bar', '55.00', 3, 'minibar', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(33, 30, NULL, 'Bottled Water (500ml)', '25.00', 4, 'food_beverage', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL);

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

--
-- Table structure for table `guests`
--

CREATE TABLE `guests` (
  `id` bigint UNSIGNED NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `nationality` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Filipino',
  `id_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Philippines',
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vip` tinyint(1) NOT NULL DEFAULT '0',
  `blacklisted` tinyint(1) NOT NULL DEFAULT '0',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guests`
--

INSERT INTO `guests` (`id`, `first_name`, `last_name`, `email`, `phone`, `date_of_birth`, `nationality`, `id_type`, `id_number`, `id_image`, `address`, `city`, `province`, `country`, `company`, `vip`, `blacklisted`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'Maria', 'Santos', 'maria.santos@gmail.com', '+63 917 123 4567', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(2, 'Juan', 'dela Cruz', 'jdelacruz@yahoo.com', '+63 918 234 5678', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(3, 'Anna', 'Reyes', 'anna.reyes@email.com', '+63 919 345 6789', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(4, 'Robert', 'Chen', 'rchen@business.ph', '+63 920 456 7890', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(5, 'Jennifer', 'Lim', 'jlim@corp.com', '+63 921 567 8901', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(6, 'Michael', 'Tan', 'mtan@gmail.com', '+63 922 678 9012', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(7, 'Patricia', 'Aquino', 'paquino@email.ph', '+63 923 789 0123', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(8, 'David', 'Wong', 'dwong@hk.com', '+852 9123 4567', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(9, 'Sarah', 'Magno', 'smagno@gmail.com', '+63 924 890 1234', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(10, 'Jose', 'Mercado', 'jose.mercado@corp.ph', '+63 925 901 2345', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(11, 'Luz', 'Bautista', 'luz.b@email.com', '+63 926 012 3456', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(12, 'Kristopher', 'Dela Rosa', 'kdelarosa@gmail.com', '+63 917 201 3344', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(13, 'Maribel', 'Flores', 'mflores@yahoo.com', '+63 918 302 4455', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(14, 'Ramon', 'Soriano', 'rsoriano@corp.ph', '+63 919 403 5566', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(15, 'Cynthia', 'Padua', 'cpadua@email.ph', '+63 920 504 6677', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(16, 'Bonifacio', 'Manalo', 'bmanalo@gmail.com', '+63 921 605 7788', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(17, 'Teresita', 'Buenaventura', 'tbuenaventura@yahoo.com', '+63 922 706 8899', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(18, 'Gerardo', 'Mateo', 'gmateo@email.com', '+63 923 807 9900', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(19, 'Eduardo', 'Castillo', 'ecastillo@gmail.com', '+63 924 908 1011', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(20, 'Lourdes', 'Macasaet', 'lmacasaet@yahoo.com', '+63 925 109 1122', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(21, 'Rolando', 'Navarro', 'rnavarro@corp.ph', '+63 926 210 2233', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(22, 'Yolanda', 'Alcantara', 'yalcantara@email.ph', '+63 917 311 3344', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(23, 'Hernando', 'Pascual', 'hpascual@gmail.com', '+63 918 412 4455', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(24, 'Florencia', 'Abad', 'fabad@email.com', '+63 919 513 5566', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(25, 'Danilo', 'Enriquez', 'denriquez@yahoo.com', '+63 920 614 6677', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(26, 'Natividad', 'Villanueva', 'nvillanueva@corp.ph', '+63 921 715 7788', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(27, 'Arturo', 'Sabado', 'asabado@gmail.com', '+63 922 816 8899', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(28, 'Concepcion', 'Batangan', 'cbatangan@yahoo.com', '+63 923 917 9900', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(29, 'Federico', 'Espiritu', 'fespiritu@email.ph', '+63 924 018 0011', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(30, 'Gloria', 'Ocampo', 'gocampo@gmail.com', '+63 925 119 1122', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(31, 'Honesto', 'Lacsamana', 'hlacsamana@corp.ph', '+63 926 220 2233', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(32, 'Imelda', 'Bernal', 'ibernal@email.com', '+63 917 321 3344', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(33, 'Jorge', 'Tiangco', 'jtiangco@yahoo.com', '+63 918 422 4455', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(34, 'Carmelita', 'Umali', 'cumali@gmail.com', '+63 919 523 5566', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(35, 'Nelson', 'Omamalin', 'nomamalin@email.ph', '+63 920 624 6677', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(36, 'Perla', 'Macaraeg', 'pmacaraeg@corp.ph', '+63 921 725 7788', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(37, 'Ricky', 'Simbahan', 'rsimbahan@gmail.com', '+63 922 826 8899', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(38, 'Annaliza', 'Cruz', 'acruz@yahoo.com', '+63 923 927 9900', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(39, 'Benito', 'Domingo', 'bdomingo@email.ph', '+63 924 028 0011', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(40, 'Carlo', 'Esteban', 'cesteban@gmail.com', '+63 925 129 1122', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(41, 'Dolores', 'Fernandez', 'dfernandez@corp.ph', '+63 926 230 2233', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(42, 'Ernesto', 'Garcia', 'egarcia@yahoo.com', '+63 917 331 3344', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(43, 'Felicitas', 'Hernandez', 'fhernandez@gmail.com', '+63 918 432 4455', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(44, 'Gilberto', 'Ignacio', 'gignacio@email.com', '+63 919 533 5566', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(45, 'Herminia', 'Javellana', 'hjavellana@yahoo.com', '+63 920 634 6677', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(46, 'Ireneo', 'Kintanar', 'ikintanar@corp.ph', '+63 921 735 7788', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(47, 'Josephina', 'Luna', 'jluna@gmail.com', '+63 922 836 8899', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(48, 'Kristina', 'Marasigan', 'kmarasigan@email.ph', '+63 923 937 9900', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(49, 'Lorenzo', 'Nacpil', 'lnacpil@yahoo.com', '+63 924 038 0011', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(50, 'Melinda', 'Ongpin', 'mongpin@corp.ph', '+63 925 139 1122', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(51, 'Narciso', 'Palma', 'npalma@gmail.com', '+63 926 240 2233', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(52, 'Ofelia', 'Quijano', 'oquijano@email.ph', '+63 917 341 3344', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(53, 'Perfecto', 'Reyes', 'preyes@yahoo.com', '+63 918 442 4455', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(54, 'Quirino', 'Santiago', 'qsantiago@corp.ph', '+63 919 543 5566', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(55, 'Rosalinda', 'Tolentino', 'rtolentino@gmail.com', '+63 920 644 6677', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(56, 'Serafin', 'Untalan', 'suntalan@email.ph', '+63 921 745 7788', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(57, 'Teodora', 'Velasco', 'tvelasco@yahoo.com', '+63 922 846 8899', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(58, 'Uldarico', 'Wenceslao', 'uwenceslao@gmail.com', '+63 923 947 9900', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(59, 'Virginia', 'Ybarra', 'vybarra@corp.ph', '+63 924 048 0011', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(60, 'Wilfredo', 'Zapanta', 'wzapanta@email.com', '+63 925 149 1122', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(61, 'Xenia', 'Aquino', 'xaquino@yahoo.com', '+63 926 250 2233', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(62, 'Yolanda', 'Bautista', 'ybautista@gmail.com', '+63 917 351 3344', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(63, 'Zenaida', 'Castillo', 'zcastillo@email.ph', '+63 918 452 4455', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(64, 'Alfredo', 'Dela Cruz', 'adelacruz@gmail.com', '+63 919 553 5566', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(65, 'Bernardo', 'Estrada', 'bestrada@yahoo.com', '+63 920 654 6677', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(66, 'Catalina', 'Ferrer', 'cferrer@corp.ph', '+63 921 755 7788', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(67, 'Domingo', 'Gonzalez', 'dgonzalez@gmail.com', '+63 922 856 8899', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(68, 'Esperanza', 'Herrero', 'eherrero@email.ph', '+63 923 957 9900', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(69, 'Faustino', 'Ibarra', 'fibarra@yahoo.com', '+63 924 058 0011', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(70, 'Gliceria', 'Jimenez', 'gjimenez@gmail.com', '+63 925 159 1122', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(71, 'Horacio', 'Kho', 'hkho@corp.ph', '+63 926 260 2233', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(72, 'Isidro', 'Legaspi', 'ilegaspi@email.com', '+63 917 361 3344', NULL, 'Filipino', NULL, NULL, NULL, NULL, NULL, NULL, 'Philippines', NULL, 0, 0, NULL, '2026-06-17 23:03:36', '2026-06-17 23:03:36');

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

--
-- Table structure for table `guest_reminders`
--

CREATE TABLE `guest_reminders` (
  `id` bigint UNSIGNED NOT NULL,
  `reservation_id` bigint UNSIGNED NOT NULL,
  `remind_at` datetime NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `completed_at` datetime 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 `jobs`
--

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

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `maintenance_requests`
--

CREATE TABLE `maintenance_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `room_no` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `reported_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resolved_at` timestamp NULL DEFAULT NULL,
  `resolution_notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenance_requests`
--

INSERT INTO `maintenance_requests` (`id`, `room_no`, `location`, `category`, `priority`, `description`, `status`, `reported_by`, `resolved_at`, `resolution_notes`, `created_at`, `updated_at`) VALUES
(1, '306', 'Room 306', 'structural', 'urgent', 'Ceiling plaster cracked and partially falling near bathroom entry. Debris on floor. Room removed from sale until repaired — do not assign to guests.', 'open', 'Management', NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(2, '412', 'Room 412', 'electrical', 'normal', 'Wall outlet near work desk not functioning. Tested with phone charger — no power. Other outlets in room work fine.', 'open', 'Housekeeping - Ana', NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(3, NULL, '2nd Floor Hallway', 'hvac', 'high', 'Central AC unit near the elevator is emitting an intermittent loud rattling noise. Multiple guests on Floor 2 have complained. Appears to worsen in the afternoon.', 'in_progress', 'Front Desk', NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(4, NULL, 'Pool Deck', 'structural', 'high', 'Handrail along the pool staircase is loose and wobbles. Safety risk for guests. Flagged by pool attendant during morning inspection.', 'open', 'Pool Attendant', NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(5, '313', 'Room 313', 'plumbing', 'low', 'Shower head pressure noticeably low compared to other rooms. Guest mentioned it during check-out.', 'resolved', 'Front Desk - Jessa', '2026-06-14 23:03:35', 'Cleaned shower head filter — mineral buildup removed. Pressure restored to normal.', '2026-06-17 23:03:35', '2026-06-17 23:03:35');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_06_14_064431_create_maintenance_requests_table', 1),
(5, '2026_06_14_100000_create_rooms_table', 1),
(6, '2026_06_14_110000_create_settings_table', 1),
(7, '2026_06_14_120000_create_reservations_table', 1),
(8, '2026_06_14_204245_create_reservation_payments_table', 1),
(9, '2026_06_14_230000_create_folio_charges_table', 1),
(10, '2026_06_14_250000_create_guests_table', 1),
(11, '2026_06_14_251000_add_guest_id_to_reservations_table', 1),
(12, '2026_06_14_260000_add_id_image_to_guests_table', 1),
(13, '2026_06_14_270000_create_pos_products_table', 1),
(14, '2026_06_14_271000_create_pos_transactions_table', 1),
(15, '2026_06_14_272000_create_pos_transaction_items_table', 1),
(16, '2026_06_14_280000_create_rate_plans_table', 1),
(17, '2026_06_14_281000_create_rate_plan_rates_table', 1),
(18, '2026_06_14_282000_add_rate_plan_id_to_reservations_table', 1),
(19, '2026_06_15_020208_create_channel_configs_table', 1),
(20, '2026_06_15_100000_create_roles_table', 1),
(21, '2026_06_15_100001_create_permissions_table', 1),
(22, '2026_06_15_100002_create_role_permission_table', 1),
(23, '2026_06_15_100003_update_users_table', 1),
(24, '2026_06_15_200000_create_website_contents_table', 1),
(25, '2026_06_15_200001_create_room_photos_table', 1),
(26, '2026_06_15_210000_add_pos_transaction_id_to_folio_charges', 1),
(27, '2026_06_15_212840_add_image_path_to_pos_products_table', 1),
(28, '2026_06_15_214307_create_shifts_table', 1),
(29, '2026_06_15_220000_create_newsletter_subscribers_table', 1),
(30, '2026_06_15_221906_add_tutorial_completed_at_to_users_table', 1),
(31, '2026_06_15_230000_create_activity_logs_table', 1),
(32, '2026_06_15_230001_create_reservation_groups_table', 1),
(33, '2026_06_15_230002_add_group_id_to_reservations_table', 1),
(34, '2026_06_15_240000_create_guest_reminders_table', 1),
(35, '2026_06_16_000001_add_soft_deletes_to_tables', 1);

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

--
-- Table structure for table `newsletter_subscribers`
--

CREATE TABLE `newsletter_subscribers` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `subscribed_at` timestamp NOT NULL,
  `unsubscribed_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 `pos_products`
--

CREATE TABLE `pos_products` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'other',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `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 `pos_products`
--

INSERT INTO `pos_products` (`id`, `name`, `description`, `image_path`, `price`, `category`, `active`, `created_at`, `updated_at`) VALUES
(1, 'Coffee (Hot)', NULL, NULL, '65.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(2, 'Hot Chocolate', NULL, NULL, '75.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(3, 'Orange Juice', NULL, NULL, '85.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(4, 'Bottled Water (500ml)', NULL, NULL, '25.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(5, 'Softdrinks (Regular)', NULL, NULL, '45.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(6, 'Breakfast Set A', NULL, NULL, '250.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(7, 'Filipino Breakfast Set', NULL, NULL, '280.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(8, 'Lunch Set', NULL, NULL, '350.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(9, 'Dinner Set', NULL, NULL, '450.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(10, 'Rice (per serving)', NULL, NULL, '30.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(11, 'Toast & Butter', NULL, NULL, '75.00', 'food_beverage', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(12, 'Beer – San Miguel Pale', NULL, NULL, '85.00', 'minibar', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(13, 'Beer – San Miguel Light', NULL, NULL, '90.00', 'minibar', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(14, 'Pringles Original', NULL, NULL, '120.00', 'minibar', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(15, 'Snickers Bar', NULL, NULL, '55.00', 'minibar', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(16, 'Nuts & Crackers', NULL, NULL, '75.00', 'minibar', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(17, 'T-Shirt / Polo', NULL, NULL, '35.00', 'laundry', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(18, 'Pants / Jeans', NULL, NULL, '50.00', 'laundry', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(19, 'Dress / Blouse', NULL, NULL, '45.00', 'laundry', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(20, 'Underwear / Socks', NULL, NULL, '20.00', 'laundry', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(21, 'Bedsheet Set', NULL, NULL, '120.00', 'laundry', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(22, 'Local Call (per call)', NULL, NULL, '15.00', 'telephone', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(23, 'Long Distance (per min)', NULL, NULL, '25.00', 'telephone', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(24, 'Extra Pillow', NULL, NULL, '100.00', 'other', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(25, 'Extra Blanket', NULL, NULL, '150.00', 'other', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(26, 'Baby Cot', NULL, NULL, '300.00', 'other', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(27, 'Internet Day Pass', NULL, NULL, '100.00', 'other', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(28, 'Printing (per page)', NULL, NULL, '5.00', 'other', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36');

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

--
-- Table structure for table `pos_transactions`
--

CREATE TABLE `pos_transactions` (
  `id` bigint UNSIGNED NOT NULL,
  `reservation_id` bigint UNSIGNED DEFAULT NULL,
  `cashier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Front Desk',
  `total` decimal(10,2) NOT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `transaction_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pos_transactions`
--

INSERT INTO `pos_transactions` (`id`, `reservation_id`, `cashier`, `total`, `payment_method`, `reference`, `notes`, `transaction_date`, `created_at`, `updated_at`) VALUES
(1, 1, 'Front Desk', '680.00', NULL, NULL, 'Room service — breakfast for 2', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(2, 1, 'Front Desk', '570.00', NULL, NULL, 'Minibar restock', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(3, 34, 'Front Desk', '390.00', NULL, NULL, 'Laundry batch #1', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(4, 2, 'Front Desk', '585.00', NULL, NULL, 'In-room lunch', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(5, 2, 'Front Desk', '140.00', NULL, NULL, NULL, '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(6, 4, 'Front Desk', '1140.00', NULL, NULL, 'Room service — dinner', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(7, 27, 'Front Desk', '570.00', NULL, NULL, 'Room service — breakfast', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(8, 28, 'Front Desk', '325.00', NULL, NULL, 'Laundry & bedsheet', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(9, 29, 'Front Desk', '650.00', NULL, NULL, 'Extra amenities', '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(10, 30, 'Front Desk', '565.00', NULL, NULL, NULL, '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(11, NULL, 'Front Desk', '395.00', 'Cash', NULL, NULL, '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(12, NULL, 'Front Desk', '440.00', 'GCash', 'GC-20260612-0041', NULL, '2026-06-12', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(13, NULL, 'Front Desk', '800.00', 'Cash', NULL, 'Walk-in breakfast — 2 guests', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(14, NULL, 'Front Desk', '535.00', 'Maya', 'MAYA-5512-8834', 'External laundry walk-in', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(15, NULL, 'Front Desk', '345.00', 'Cash', NULL, NULL, '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(16, NULL, 'Front Desk', '1860.00', 'Credit Card', 'CC-XXXX-5291', 'Corporate lunch — meeting group', '2026-06-13', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(17, NULL, 'Front Desk', '1080.00', 'GCash', 'GC-20260614-0019', NULL, '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(18, NULL, 'Front Desk', '1265.00', 'Cash', NULL, NULL, '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(19, NULL, 'Front Desk', '275.00', 'Debit Card', 'DBT-9872', 'Business center usage', '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(20, NULL, 'Front Desk', '455.00', 'Cash', NULL, NULL, '2026-06-14', '2026-06-17 23:03:36', '2026-06-17 23:03:36');

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

--
-- Table structure for table `pos_transaction_items`
--

CREATE TABLE `pos_transaction_items` (
  `id` bigint UNSIGNED NOT NULL,
  `pos_transaction_id` bigint UNSIGNED NOT NULL,
  `pos_product_id` bigint UNSIGNED DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `quantity` smallint UNSIGNED NOT NULL DEFAULT '1',
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'other',
  `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 `pos_transaction_items`
--

INSERT INTO `pos_transaction_items` (`id`, `pos_transaction_id`, `pos_product_id`, `description`, `unit_price`, `quantity`, `category`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Coffee (Hot)', '65.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(2, 1, 6, 'Breakfast Set A', '250.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(3, 1, 4, 'Bottled Water (500ml)', '25.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(4, 2, 12, 'Beer – San Miguel Pale', '85.00', 3, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(5, 2, 14, 'Pringles Original', '120.00', 2, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(6, 2, 16, 'Nuts & Crackers', '75.00', 1, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(7, 3, 17, 'T-Shirt / Polo', '35.00', 4, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(8, 3, 18, 'Pants / Jeans', '50.00', 2, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(9, 3, 19, 'Dress / Blouse', '45.00', 2, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(10, 3, 20, 'Underwear / Socks', '20.00', 3, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(11, 4, 8, 'Lunch Set', '350.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(12, 4, 10, 'Rice (per serving)', '30.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(13, 4, 3, 'Orange Juice', '85.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(14, 4, 5, 'Softdrinks (Regular)', '45.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(15, 5, 27, 'Internet Day Pass', '100.00', 1, 'other', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(16, 5, 28, 'Printing (per page)', '5.00', 8, 'other', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(17, 6, 9, 'Dinner Set', '450.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(18, 6, 10, 'Rice (per serving)', '30.00', 3, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(19, 6, 2, 'Hot Chocolate', '75.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(20, 7, 7, 'Filipino Breakfast Set', '280.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(21, 7, 1, 'Coffee (Hot)', '65.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(22, 7, 11, 'Toast & Butter', '75.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(23, 7, 3, 'Orange Juice', '85.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(24, 8, 21, 'Bedsheet Set', '120.00', 1, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(25, 8, 17, 'T-Shirt / Polo', '35.00', 3, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(26, 8, 18, 'Pants / Jeans', '50.00', 2, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(27, 9, 24, 'Extra Pillow', '100.00', 2, 'other', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(28, 9, 25, 'Extra Blanket', '150.00', 1, 'other', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(29, 9, 26, 'Baby Cot', '300.00', 1, 'other', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(30, 10, 13, 'Beer – San Miguel Light', '90.00', 2, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(31, 10, 14, 'Pringles Original', '120.00', 1, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(32, 10, 15, 'Snickers Bar', '55.00', 3, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(33, 10, 4, 'Bottled Water (500ml)', '25.00', 4, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(34, 11, 1, 'Coffee (Hot)', '65.00', 3, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(35, 11, 11, 'Toast & Butter', '75.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(36, 11, 4, 'Bottled Water (500ml)', '25.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(37, 12, 5, 'Softdrinks (Regular)', '45.00', 4, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(38, 12, 4, 'Bottled Water (500ml)', '25.00', 6, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(39, 12, 15, 'Snickers Bar', '55.00', 2, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(40, 13, 6, 'Breakfast Set A', '250.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(41, 13, 3, 'Orange Juice', '85.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(42, 13, 1, 'Coffee (Hot)', '65.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(43, 14, 17, 'T-Shirt / Polo', '35.00', 5, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(44, 14, 18, 'Pants / Jeans', '50.00', 3, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(45, 14, 19, 'Dress / Blouse', '45.00', 2, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(46, 14, 21, 'Bedsheet Set', '120.00', 1, 'laundry', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(47, 15, 2, 'Hot Chocolate', '75.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(48, 15, 14, 'Pringles Original', '120.00', 1, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(49, 15, 16, 'Nuts & Crackers', '75.00', 2, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(50, 16, 8, 'Lunch Set', '350.00', 4, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(51, 16, 10, 'Rice (per serving)', '30.00', 6, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(52, 16, 5, 'Softdrinks (Regular)', '45.00', 4, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(53, 16, 4, 'Bottled Water (500ml)', '25.00', 4, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(54, 17, 12, 'Beer – San Miguel Pale', '85.00', 6, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(55, 17, 13, 'Beer – San Miguel Light', '90.00', 3, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(56, 17, 16, 'Nuts & Crackers', '75.00', 4, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(57, 18, 9, 'Dinner Set', '450.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(58, 18, 10, 'Rice (per serving)', '30.00', 4, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(59, 18, 3, 'Orange Juice', '85.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(60, 18, 2, 'Hot Chocolate', '75.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(61, 19, 27, 'Internet Day Pass', '100.00', 2, 'other', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(62, 19, 28, 'Printing (per page)', '5.00', 15, 'other', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(63, 20, 2, 'Hot Chocolate', '75.00', 2, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(64, 20, 15, 'Snickers Bar', '55.00', 3, 'minibar', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(65, 20, 1, 'Coffee (Hot)', '65.00', 1, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(66, 20, 4, 'Bottled Water (500ml)', '25.00', 3, 'food_beverage', '2026-06-17 23:03:36', '2026-06-17 23:03:36');

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

--
-- Table structure for table `rate_plans`
--

CREATE TABLE `rate_plans` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('percent_off','amount_off','fixed') COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` decimal(8,2) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `min_nights` smallint UNSIGNED DEFAULT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_until` date DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `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 `rate_plans`
--

INSERT INTO `rate_plans` (`id`, `name`, `code`, `type`, `value`, `description`, `min_nights`, `valid_from`, `valid_until`, `active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Advance Purchase Rate', 'ARP', 'percent_off', '10.00', '10% discount for bookings made 7 or more days in advance.', NULL, NULL, NULL, 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(2, 'Long Stay Discount', 'LSD', 'percent_off', '15.00', '15% discount for stays of 7 nights or more.', 7, NULL, NULL, 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(3, 'Senior Citizen / PWD Rate', 'SCPWD', 'percent_off', '20.00', '20% mandatory discount for Senior Citizens and PWDs (RA 9994 / RA 7277).', NULL, NULL, NULL, 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(4, 'Group Rate', 'GRP', 'percent_off', '10.00', '10% discount for group bookings of 5 rooms or more.', NULL, NULL, NULL, 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(5, 'Corporate Rate', 'CORP', 'fixed', NULL, 'Contracted rates for corporate accounts and business travellers.', NULL, NULL, NULL, 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL),
(6, 'Government / DepEd Rate', 'GOV', 'fixed', NULL, 'Preferential rates for government employees and DepEd personnel.', NULL, NULL, NULL, 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36', NULL);

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

--
-- Table structure for table `rate_plan_rates`
--

CREATE TABLE `rate_plan_rates` (
  `id` bigint UNSIGNED NOT NULL,
  `rate_plan_id` bigint UNSIGNED NOT NULL,
  `room_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rate_plan_rates`
--

INSERT INTO `rate_plan_rates` (`id`, `rate_plan_id`, `room_type`, `rate`, `created_at`, `updated_at`) VALUES
(1, 5, 'Economy Twin', '599.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(2, 5, 'Economy Double', '599.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(3, 5, 'Ordinary Twin', '469.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(4, 5, 'Ordinary Double', '469.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(5, 5, 'Standard Twin', '729.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(6, 5, 'Standard Double', '729.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(7, 5, 'Junior Deluxe', '599.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(8, 5, 'Superior Deluxe', '729.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(9, 5, 'Deluxe Twin', '769.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(10, 5, 'Deluxe Double', '769.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(11, 5, 'Deluxe Trio', '1069.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(12, 5, 'Barkadahan', '1299.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(13, 5, 'Family Room', '1399.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(14, 5, 'Family Room 2', '1399.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(15, 5, 'Executive Suite', '1499.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(16, 6, 'Economy Twin', '559.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(17, 6, 'Economy Double', '559.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(18, 6, 'Ordinary Twin', '439.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(19, 6, 'Ordinary Double', '439.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(20, 6, 'Standard Twin', '679.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(21, 6, 'Standard Double', '679.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(22, 6, 'Junior Deluxe', '559.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(23, 6, 'Superior Deluxe', '679.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(24, 6, 'Deluxe Twin', '719.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(25, 6, 'Deluxe Double', '719.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(26, 6, 'Deluxe Trio', '999.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(27, 6, 'Barkadahan', '1199.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(28, 6, 'Family Room', '1319.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(29, 6, 'Family Room 2', '1319.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(30, 6, 'Executive Suite', '1399.00', '2026-06-17 23:03:36', '2026-06-17 23:03:36');

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

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

CREATE TABLE `reservations` (
  `id` bigint UNSIGNED NOT NULL,
  `group_id` bigint UNSIGNED DEFAULT NULL,
  `guest_id` bigint UNSIGNED DEFAULT NULL,
  `rate_plan_id` bigint UNSIGNED DEFAULT NULL,
  `booking_no` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guest_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guest_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guest_phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_no` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `room_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `check_in` date NOT NULL,
  `check_out` date NOT NULL,
  `nights` smallint UNSIGNED NOT NULL,
  `pax` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `rate` decimal(10,2) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `source` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `deposit_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `deposit_paid` tinyint(1) NOT NULL DEFAULT '0',
  `deposit_date` date DEFAULT NULL,
  `deposit_method` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deposit_reference` varchar(60) COLLATE utf8mb4_unicode_ci 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 `reservations`
--

INSERT INTO `reservations` (`id`, `group_id`, `guest_id`, `rate_plan_id`, `booking_no`, `guest_name`, `guest_email`, `guest_phone`, `room_no`, `room_type`, `check_in`, `check_out`, `nights`, `pax`, `rate`, `amount`, `status`, `source`, `notes`, `deposit_amount`, `deposit_paid`, `deposit_date`, `deposit_method`, `deposit_reference`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 1, NULL, '2026-06-000001', 'Maria Santos', 'maria.santos@gmail.com', '+63 917 123 4567', '101', 'Junior Deluxe', '2026-06-14', '2026-06-16', 2, 1, '699.00', '1398.00', 'confirmed', 'Walk-in', NULL, '700.00', 1, '2026-06-12', 'GCash', 'GC-20260612-001', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(2, NULL, 2, NULL, '2026-06-000002', 'Juan dela Cruz', 'jdelacruz@yahoo.com', '+63 918 234 5678', '105', 'Superior Deluxe', '2026-06-14', '2026-06-17', 3, 1, '849.00', '2547.00', 'checked_in', 'Booking.com', 'Early check-in requested', '1500.00', 1, '2026-06-10', 'Bank Transfer', 'BT-BDO-20260610-882', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(3, NULL, 3, NULL, '2026-06-000003', 'Anna Reyes', 'anna.reyes@email.com', '+63 919 345 6789', '312', 'Ordinary Twin', '2026-06-15', '2026-06-17', 2, 2, '549.00', '1098.00', 'pending', 'Agoda', 'Honeymoon setup requested', '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(4, NULL, 4, NULL, '2026-06-000004', 'Robert Chen', 'rchen@business.ph', '+63 920 456 7890', '108', 'Superior Deluxe', '2026-06-13', '2026-06-15', 2, 1, '849.00', '1698.00', 'checked_in', 'Direct', NULL, '1698.00', 1, '2026-06-13', 'Cash', 'OR-2026-0041', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(5, NULL, 5, NULL, '2026-06-000005', 'Jennifer Lim', 'jlim@corp.com', '+63 921 567 8901', '201', 'Deluxe Twin', '2026-06-15', '2026-06-18', 3, 2, '899.00', '2697.00', 'confirmed', 'Airbnb', NULL, '1500.00', 1, '2026-06-11', 'Maya', 'MY-20260611-4421', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(6, NULL, 6, NULL, '2026-06-000006', 'Michael Tan', 'mtan@gmail.com', '+63 922 678 9012', '402', 'Executive Suite', '2026-06-12', '2026-06-14', 2, 2, '1749.00', '3498.00', 'checked_out', 'Booking.com', 'Late checkout approved', '3498.00', 1, '2026-06-12', 'Credit Card', 'CC-VISA-20260612-7721', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(7, NULL, 7, NULL, '2026-06-000007', 'Patricia Aquino', 'paquino@email.ph', '+63 923 789 0123', '116', 'Junior Deluxe', '2026-06-16', '2026-06-17', 1, 1, '699.00', '699.00', 'confirmed', 'Walk-in', 'Senior citizen discount applied', '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(8, NULL, 8, NULL, '2026-06-000008', 'David Wong', 'dwong@hk.com', '+852 9123 4567', '302', 'Family Room 2', '2026-06-10', '2026-06-14', 4, 4, '1649.00', '6596.00', 'checked_out', 'Agoda', NULL, '6596.00', 1, '2026-06-10', 'Credit Card', 'CC-MC-20260610-3341', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(9, NULL, 9, NULL, '2026-06-000009', 'Sarah Magno', 'smagno@gmail.com', '+63 924 890 1234', '307', 'Deluxe Double', '2026-06-14', '2026-06-15', 1, 1, '899.00', '899.00', 'no_show', 'Direct', NULL, '899.00', 1, '2026-06-13', 'GCash', 'GC-20260613-991', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(10, NULL, 10, NULL, '2026-06-000010', 'Jose Mercado', 'jose.mercado@corp.ph', '+63 925 901 2345', '401', 'Deluxe Trio', '2026-06-15', '2026-06-20', 5, 3, '1249.00', '6245.00', 'confirmed', 'Direct', 'VIP guest — airport pickup required', '3000.00', 1, '2026-06-10', 'Bank Transfer', 'BT-BPI-20260610-5521', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(11, NULL, 11, NULL, '2026-06-000011', 'Luz Bautista', 'luz.b@email.com', '+63 926 012 3456', '103', 'Junior Deluxe', '2026-06-14', '2026-06-16', 2, 1, '699.00', '1398.00', 'cancelled', 'Booking.com', 'Cancelled by guest', '699.00', 1, '2026-06-08', 'GCash', 'GC-20260608-774', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(12, NULL, 12, NULL, '2026-06-000012', 'Kristopher Dela Rosa', 'kdelarosa@gmail.com', '+63 917 201 3344', '111', 'Superior Deluxe', '2026-06-11', '2026-06-13', 2, 2, '849.00', '1698.00', 'checked_out', 'Booking.com', NULL, '1698.00', 1, '2026-06-11', 'Credit Card', 'CC-VISA-20260611-1201', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(13, NULL, 13, NULL, '2026-06-000013', 'Maribel Flores', 'mflores@yahoo.com', '+63 918 302 4455', '113', 'Superior Deluxe', '2026-06-12', '2026-06-14', 2, 1, '849.00', '1698.00', 'checked_out', 'Direct', NULL, '1698.00', 1, '2026-06-12', 'GCash', 'GC-20260612-3312', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(14, NULL, 14, NULL, '2026-06-000014', 'Ramon Soriano', 'rsoriano@corp.ph', '+63 919 403 5566', '206', 'Standard Twin', '2026-06-12', '2026-06-14', 2, 2, '849.00', '1698.00', 'checked_out', 'Agoda', NULL, '1698.00', 1, '2026-06-12', 'Maya', 'MY-20260612-8821', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(15, NULL, 15, NULL, '2026-06-000015', 'Cynthia Padua', 'cpadua@email.ph', '+63 920 504 6677', '207', 'Economy Twin', '2026-06-11', '2026-06-13', 2, 2, '699.00', '1398.00', 'checked_out', 'Walk-in', NULL, '1398.00', 1, '2026-06-11', 'Cash', 'OR-2026-0038', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(16, NULL, 16, NULL, '2026-06-000016', 'Bonifacio Manalo', 'bmanalo@gmail.com', '+63 921 605 7788', '304', 'Deluxe Twin', '2026-06-13', '2026-06-14', 1, 2, '899.00', '899.00', 'checked_out', 'Walk-in', NULL, '899.00', 1, '2026-06-13', 'Cash', 'OR-2026-0039', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(17, NULL, 17, NULL, '2026-06-000017', 'Teresita Buenaventura', 'tbuenaventura@yahoo.com', '+63 922 706 8899', '403', 'Deluxe Twin', '2026-06-11', '2026-06-13', 2, 2, '899.00', '1798.00', 'checked_out', 'Booking.com', NULL, '1798.00', 1, '2026-06-11', 'Credit Card', 'CC-MC-20260611-4409', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(18, NULL, 18, NULL, '2026-06-000018', 'Gerardo Mateo', 'gmateo@email.com', '+63 923 807 9900', '408', 'Standard Double', '2026-06-12', '2026-06-14', 2, 2, '849.00', '1698.00', 'checked_out', 'Airbnb', NULL, '1698.00', 1, '2026-06-12', 'GCash', 'GC-20260612-5678', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(19, NULL, 19, NULL, '2026-06-000019', 'Eduardo Castillo', 'ecastillo@gmail.com', '+63 924 908 1011', '104', 'Junior Deluxe', '2026-06-05', '2026-06-08', 3, 1, '699.00', '2097.00', 'checked_out', 'Walk-in', NULL, '2097.00', 1, '2026-06-05', 'Cash', 'OR-2026-0029', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(20, NULL, 20, NULL, '2026-06-000020', 'Lourdes Macasaet', 'lmacasaet@yahoo.com', '+63 925 109 1122', '109', 'Superior Deluxe', '2026-06-03', '2026-06-07', 4, 1, '849.00', '3396.00', 'checked_out', 'Agoda', NULL, '3396.00', 1, '2026-06-03', 'Bank Transfer', 'BT-BDO-20260603-2201', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(21, NULL, 21, NULL, '2026-06-000021', 'Rolando Navarro', 'rnavarro@corp.ph', '+63 926 210 2233', '202', 'Economy Twin', '2026-06-02', '2026-06-05', 3, 2, '699.00', '2097.00', 'checked_out', 'Direct', NULL, '2097.00', 1, '2026-06-02', 'Maya', 'MY-20260602-1109', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(22, NULL, 22, NULL, '2026-06-000022', 'Yolanda Alcantara', 'yalcantara@email.ph', '+63 917 311 3344', '204', 'Economy Twin', '2026-06-01', '2026-06-04', 3, 2, '699.00', '2097.00', 'checked_out', 'Booking.com', NULL, '2097.00', 1, '2026-06-01', 'Credit Card', 'CC-VISA-20260601-0088', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(23, NULL, 23, NULL, '2026-06-000023', 'Hernando Pascual', 'hpascual@gmail.com', '+63 918 412 4455', '205', 'Economy Double', '2026-06-08', '2026-06-10', 2, 2, '699.00', '1398.00', 'checked_out', 'Walk-in', NULL, '1398.00', 1, '2026-06-08', 'Cash', 'OR-2026-0033', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(24, NULL, 24, NULL, '2026-06-000024', 'Florencia Abad', 'fabad@email.com', '+63 919 513 5566', '301', 'Deluxe Twin', '2026-06-05', '2026-06-09', 4, 2, '899.00', '3596.00', 'checked_out', 'Airbnb', NULL, '3596.00', 1, '2026-06-05', 'Bank Transfer', 'BT-BPI-20260605-3301', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(25, NULL, 25, NULL, '2026-06-000025', 'Danilo Enriquez', 'denriquez@yahoo.com', '+63 920 614 6677', '303', 'Deluxe Twin', '2026-06-07', '2026-06-11', 4, 2, '899.00', '3596.00', 'checked_out', 'Agoda', NULL, '3596.00', 1, '2026-06-07', 'GCash', 'GC-20260607-7734', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(26, NULL, 26, NULL, '2026-06-000026', 'Natividad Villanueva', 'nvillanueva@corp.ph', '+63 921 715 7788', '404', 'Standard Twin', '2026-06-06', '2026-06-10', 4, 2, '849.00', '3396.00', 'checked_out', 'Direct', NULL, '3396.00', 1, '2026-06-06', 'Credit Card', 'CC-MC-20260606-5519', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(27, NULL, 27, NULL, '2026-06-000027', 'Arturo Sabado', 'asabado@gmail.com', '+63 922 816 8899', '110', 'Superior Deluxe', '2026-06-13', '2026-06-16', 3, 2, '849.00', '2547.00', 'checked_in', 'Booking.com', NULL, '1000.00', 1, '2026-06-10', 'GCash', 'GC-20260610-2288', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(28, NULL, 28, NULL, '2026-06-000028', 'Concepcion Batangan', 'cbatangan@yahoo.com', '+63 923 917 9900', '112', 'Superior Deluxe', '2026-06-12', '2026-06-15', 3, 1, '849.00', '2547.00', 'checked_in', 'Agoda', NULL, '1500.00', 1, '2026-06-09', 'Maya', 'MY-20260609-6612', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(29, NULL, 29, NULL, '2026-06-000029', 'Federico Espiritu', 'fespiritu@email.ph', '+63 924 018 0011', '114', 'Superior Deluxe', '2026-06-13', '2026-06-17', 4, 2, '849.00', '3396.00', 'checked_in', 'Direct', 'Corporate rate — HR Dept of Gokongwei Group', '2000.00', 1, '2026-06-11', 'Bank Transfer', 'BT-BDO-20260611-9914', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(30, NULL, 30, NULL, '2026-06-000030', 'Gloria Ocampo', 'gocampo@gmail.com', '+63 925 119 1122', '203', 'Family Room', '2026-06-11', '2026-06-15', 4, 4, '1649.00', '6596.00', 'checked_in', 'Airbnb', 'Family reunion — extra rollaway requested', '3000.00', 1, '2026-06-08', 'Credit Card', 'CC-VISA-20260608-1133', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(31, NULL, 31, NULL, '2026-06-000031', 'Honesto Lacsamana', 'hlacsamana@corp.ph', '+63 926 220 2233', '315', 'Standard Twin', '2026-06-14', '2026-06-17', 3, 2, '849.00', '2547.00', 'checked_in', 'Walk-in', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(32, NULL, 32, NULL, '2026-06-000032', 'Imelda Bernal', 'ibernal@email.com', '+63 917 321 3344', '405', 'Deluxe Twin', '2026-06-13', '2026-06-16', 3, 2, '899.00', '2697.00', 'checked_in', 'Booking.com', NULL, '2697.00', 1, '2026-06-10', 'GCash', 'GC-20260610-4491', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(33, NULL, 33, NULL, '2026-06-000033', 'Jorge Tiangco', 'jtiangco@yahoo.com', '+63 918 422 4455', '407', 'Deluxe Twin', '2026-06-14', '2026-06-18', 4, 2, '899.00', '3596.00', 'checked_in', 'Agoda', NULL, '2000.00', 1, '2026-06-11', 'Maya', 'MY-20260611-8812', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(34, NULL, 34, NULL, '2026-06-000034', 'Carmelita Umali', 'cumali@gmail.com', '+63 919 523 5566', '102', 'Junior Deluxe', '2026-06-14', '2026-06-16', 2, 1, '699.00', '1398.00', 'confirmed', 'Direct', NULL, '700.00', 1, '2026-06-12', 'GCash', 'GC-20260612-7701', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(35, NULL, 35, NULL, '2026-06-000035', 'Nelson Omamalin', 'nomamalin@email.ph', '+63 920 624 6677', '208', 'Ordinary Twin', '2026-06-14', '2026-06-17', 3, 2, '549.00', '1647.00', 'confirmed', 'Agoda', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(36, NULL, 36, NULL, '2026-06-000036', 'Perla Macaraeg', 'pmacaraeg@corp.ph', '+63 921 725 7788', '305', 'Ordinary Twin', '2026-06-14', '2026-06-18', 4, 2, '549.00', '2196.00', 'confirmed', 'Booking.com', NULL, '1000.00', 1, '2026-06-11', 'Bank Transfer', 'BT-BPI-20260611-6630', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(37, NULL, 37, NULL, '2026-06-000037', 'Ricky Simbahan', 'rsimbahan@gmail.com', '+63 922 826 8899', '406', 'Deluxe Trio', '2026-06-14', '2026-06-15', 1, 3, '1249.00', '1249.00', 'confirmed', 'Walk-in', NULL, '1249.00', 1, '2026-06-13', 'Credit Card', 'CC-VISA-20260613-9911', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(38, NULL, 38, NULL, '2026-06-000038', 'Annaliza Cruz', 'acruz@yahoo.com', '+63 923 927 9900', '106', 'Superior Deluxe', '2026-06-15', '2026-06-18', 3, 2, '849.00', '2547.00', 'confirmed', 'Booking.com', NULL, '1500.00', 1, '2026-06-12', 'Maya', 'MY-20260612-1145', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(39, NULL, 39, NULL, '2026-06-000039', 'Benito Domingo', 'bdomingo@email.ph', '+63 924 028 0011', '115', 'Superior Deluxe', '2026-06-15', '2026-06-17', 2, 1, '849.00', '1698.00', 'pending', 'Agoda', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(40, NULL, 40, NULL, '2026-06-000040', 'Carlo Esteban', 'cesteban@gmail.com', '+63 925 129 1122', '117', 'Junior Deluxe', '2026-06-16', '2026-06-20', 4, 1, '699.00', '2796.00', 'confirmed', 'Direct', NULL, '1000.00', 1, '2026-06-13', 'GCash', 'GC-20260613-3301', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(41, NULL, 41, NULL, '2026-06-000041', 'Dolores Fernandez', 'dfernandez@corp.ph', '+63 926 230 2233', '202', 'Economy Twin', '2026-06-16', '2026-06-19', 3, 2, '699.00', '2097.00', 'confirmed', 'Airbnb', NULL, '1000.00', 1, '2026-06-13', 'Bank Transfer', 'BT-BDO-20260613-4482', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(42, NULL, 42, NULL, '2026-06-000042', 'Ernesto Garcia', 'egarcia@yahoo.com', '+63 917 331 3344', '204', 'Economy Twin', '2026-06-18', '2026-06-21', 3, 2, '699.00', '2097.00', 'pending', 'Booking.com', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(43, NULL, 43, NULL, '2026-06-000043', 'Felicitas Hernandez', 'fhernandez@gmail.com', '+63 918 432 4455', '209', 'Economy Twin', '2026-06-17', '2026-06-20', 3, 2, '699.00', '2097.00', 'confirmed', 'Agoda', NULL, '1000.00', 1, '2026-06-13', 'GCash', 'GC-20260613-5590', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(44, NULL, 44, NULL, '2026-06-000044', 'Gilberto Ignacio', 'gignacio@email.com', '+63 919 533 5566', '210', 'Economy Twin', '2026-06-16', '2026-06-18', 2, 2, '699.00', '1398.00', 'confirmed', 'Walk-in', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(45, NULL, 45, NULL, '2026-06-000045', 'Herminia Javellana', 'hjavellana@yahoo.com', '+63 920 634 6677', '309', 'Ordinary Twin', '2026-06-15', '2026-06-17', 2, 2, '549.00', '1098.00', 'confirmed', 'Walk-in', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(46, NULL, 46, NULL, '2026-06-000046', 'Ireneo Kintanar', 'ikintanar@corp.ph', '+63 921 735 7788', '311', 'Standard Twin', '2026-06-16', '2026-06-20', 4, 2, '849.00', '3396.00', 'pending', 'Booking.com', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(47, NULL, 47, NULL, '2026-06-000047', 'Josephina Luna', 'jluna@gmail.com', '+63 922 836 8899', '314', 'Standard Twin', '2026-06-18', '2026-06-22', 4, 2, '849.00', '3396.00', 'confirmed', 'Direct', NULL, '1700.00', 1, '2026-06-13', 'Maya', 'MY-20260613-2278', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(48, NULL, 48, NULL, '2026-06-000048', 'Kristina Marasigan', 'kmarasigan@email.ph', '+63 923 937 9900', '316', 'Ordinary Twin', '2026-06-17', '2026-06-21', 4, 2, '549.00', '2196.00', 'confirmed', 'Airbnb', NULL, '1000.00', 1, '2026-06-13', 'GCash', 'GC-20260613-8823', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(49, NULL, 49, NULL, '2026-06-000049', 'Lorenzo Nacpil', 'lnacpil@yahoo.com', '+63 924 038 0011', '402', 'Executive Suite', '2026-06-18', '2026-06-22', 4, 2, '1749.00', '6996.00', 'confirmed', 'Direct', 'Anniversary stay — turndown service requested', '3500.00', 1, '2026-06-12', 'Bank Transfer', 'BT-BPI-20260612-7701', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(50, NULL, 50, NULL, '2026-06-000050', 'Melinda Ongpin', 'mongpin@corp.ph', '+63 925 139 1122', '404', 'Standard Twin', '2026-06-19', '2026-06-23', 4, 2, '849.00', '3396.00', 'pending', 'Agoda', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(51, NULL, 51, NULL, '2026-06-000051', 'Narciso Palma', 'npalma@gmail.com', '+63 926 240 2233', '409', 'Standard Double', '2026-06-20', '2026-06-24', 4, 2, '849.00', '3396.00', 'confirmed', 'Booking.com', NULL, '1700.00', 1, '2026-06-13', 'Credit Card', 'CC-VISA-20260613-4412', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(52, NULL, 52, NULL, '2026-06-000052', 'Ofelia Quijano', 'oquijano@email.ph', '+63 917 341 3344', '107', 'Barkadahan', '2026-06-22', '2026-06-25', 3, 4, '1499.00', '4497.00', 'confirmed', 'Walk-in', 'Barkada group — 4 adults', '2000.00', 1, '2026-06-13', 'GCash', 'GC-20260613-6634', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(53, NULL, 53, NULL, '2026-06-000053', 'Perfecto Reyes', 'preyes@yahoo.com', '+63 918 442 4455', '310', 'Barkadahan', '2026-06-19', '2026-06-23', 4, 4, '1499.00', '5996.00', 'pending', 'Airbnb', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(54, NULL, 54, NULL, '2026-06-000054', 'Quirino Santiago', 'qsantiago@corp.ph', '+63 919 543 5566', '411', 'Standard Double', '2026-06-23', '2026-06-27', 4, 2, '849.00', '3396.00', 'confirmed', 'Direct', NULL, '1700.00', 1, '2026-06-13', 'Maya', 'MY-20260613-9956', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(55, NULL, 55, NULL, '2026-06-000055', 'Rosalinda Tolentino', 'rtolentino@gmail.com', '+63 920 644 6677', '212', 'Economy Double', '2026-06-25', '2026-06-28', 3, 2, '699.00', '2097.00', 'pending', 'Booking.com', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(56, NULL, 56, NULL, '2026-06-000056', 'Serafin Untalan', 'suntalan@email.ph', '+63 921 745 7788', '109', 'Superior Deluxe', '2026-07-03', '2026-07-07', 4, 1, '849.00', '3396.00', 'confirmed', 'Booking.com', NULL, '1700.00', 1, '2026-06-14', 'GCash', 'GC-20260614-1101', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(57, NULL, 57, NULL, '2026-06-000057', 'Teodora Velasco', 'tvelasco@yahoo.com', '+63 922 846 8899', '115', 'Superior Deluxe', '2026-07-08', '2026-07-12', 4, 2, '849.00', '3396.00', 'confirmed', 'Agoda', NULL, '1700.00', 1, '2026-06-14', 'Bank Transfer', 'BT-BDO-20260614-2202', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(58, NULL, 58, NULL, '2026-06-000058', 'Uldarico Wenceslao', 'uwenceslao@gmail.com', '+63 923 947 9900', '201', 'Deluxe Twin', '2026-07-05', '2026-07-09', 4, 2, '899.00', '3596.00', 'confirmed', 'Direct', NULL, '1800.00', 1, '2026-06-14', 'Credit Card', 'CC-VISA-20260614-3303', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(59, NULL, 59, NULL, '2026-06-000059', 'Virginia Ybarra', 'vybarra@corp.ph', '+63 924 048 0011', '302', 'Family Room 2', '2026-07-04', '2026-07-08', 4, 4, '1649.00', '6596.00', 'confirmed', 'Airbnb', 'Family with 2 children', '3300.00', 1, '2026-06-14', 'Bank Transfer', 'BT-BPI-20260614-4404', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(60, NULL, 60, NULL, '2026-06-000060', 'Wilfredo Zapanta', 'wzapanta@email.com', '+63 925 149 1122', '402', 'Executive Suite', '2026-07-06', '2026-07-10', 4, 2, '1749.00', '6996.00', 'confirmed', 'Direct', 'Corporate booking — Cebu Pacific executive', '3500.00', 1, '2026-06-14', 'Credit Card', 'CC-MC-20260614-5505', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(61, NULL, 61, NULL, '2026-06-000061', 'Xenia Aquino', 'xaquino@yahoo.com', '+63 926 250 2233', '203', 'Family Room', '2026-07-10', '2026-07-14', 4, 4, '1649.00', '6596.00', 'pending', 'Booking.com', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(62, NULL, 62, NULL, '2026-06-000062', 'Yolanda Bautista', 'ybautista@gmail.com', '+63 917 351 3344', '405', 'Deluxe Twin', '2026-07-05', '2026-07-08', 3, 2, '899.00', '2697.00', 'confirmed', 'Agoda', NULL, '1350.00', 1, '2026-06-14', 'GCash', 'GC-20260614-6606', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(63, NULL, 63, NULL, '2026-06-000063', 'Zenaida Castillo', 'zcastillo@email.ph', '+63 918 452 4455', '406', 'Deluxe Trio', '2026-07-09', '2026-07-12', 3, 3, '1249.00', '3747.00', 'confirmed', 'Walk-in', NULL, '1875.00', 1, '2026-06-14', 'Maya', 'MY-20260614-7707', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(64, NULL, 64, NULL, '2026-06-000064', 'Alfredo Dela Cruz', 'adelacruz@gmail.com', '+63 919 553 5566', '101', 'Junior Deluxe', '2026-08-02', '2026-08-06', 4, 1, '699.00', '2796.00', 'confirmed', 'Direct', NULL, '1400.00', 1, '2026-06-14', 'GCash', 'GC-20260614-8808', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(65, NULL, 65, NULL, '2026-06-000065', 'Bernardo Estrada', 'bestrada@yahoo.com', '+63 920 654 6677', '201', 'Deluxe Twin', '2026-08-08', '2026-08-12', 4, 2, '899.00', '3596.00', 'pending', 'Booking.com', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(66, NULL, 66, NULL, '2026-06-000066', 'Catalina Ferrer', 'cferrer@corp.ph', '+63 921 755 7788', '302', 'Family Room 2', '2026-08-05', '2026-08-09', 4, 4, '1649.00', '6596.00', 'confirmed', 'Agoda', NULL, '3300.00', 1, '2026-06-14', 'Bank Transfer', 'BT-BDO-20260614-9909', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(67, NULL, 67, NULL, '2026-06-000067', 'Domingo Gonzalez', 'dgonzalez@gmail.com', '+63 922 856 8899', '402', 'Executive Suite', '2026-08-08', '2026-08-12', 4, 2, '1749.00', '6996.00', 'confirmed', 'Direct', 'VIP return guest', '3500.00', 1, '2026-06-14', 'Credit Card', 'CC-VISA-20260614-0010', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(68, NULL, 68, NULL, '2026-06-000068', 'Esperanza Herrero', 'eherrero@email.ph', '+63 923 957 9900', '310', 'Barkadahan', '2026-08-10', '2026-08-14', 4, 4, '1499.00', '5996.00', 'pending', 'Airbnb', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(69, NULL, 69, NULL, '2026-06-000069', 'Faustino Ibarra', 'fibarra@yahoo.com', '+63 924 058 0011', '203', 'Family Room', '2026-08-15', '2026-08-19', 4, 4, '1649.00', '6596.00', 'confirmed', 'Direct', NULL, '3300.00', 1, '2026-06-14', 'Maya', 'MY-20260614-1111', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(70, NULL, 70, NULL, '2026-06-000070', 'Gliceria Jimenez', 'gjimenez@gmail.com', '+63 925 159 1122', '201', 'Deluxe Twin', '2026-09-05', '2026-09-09', 4, 2, '899.00', '3596.00', 'pending', 'Booking.com', NULL, '0.00', 0, NULL, NULL, NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(71, NULL, 71, NULL, '2026-06-000071', 'Horacio Kho', 'hkho@corp.ph', '+63 926 260 2233', '402', 'Executive Suite', '2026-09-06', '2026-09-10', 4, 2, '1749.00', '6996.00', 'confirmed', 'Direct', 'Anniversary booking — champagne setup', '3500.00', 1, '2026-06-14', 'Credit Card', 'CC-MC-20260614-2222', '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(72, NULL, 72, NULL, '2026-06-000072', 'Isidro Legaspi', 'ilegaspi@email.com', '+63 917 361 3344', '302', 'Family Room 2', '2026-09-04', '2026-09-08', 4, 4, '1649.00', '6596.00', 'confirmed', 'Airbnb', NULL, '3300.00', 1, '2026-06-14', 'Bank Transfer', 'BT-BPI-20260614-3333', '2026-06-17 23:03:35', '2026-06-17 23:03:36', NULL);

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

--
-- Table structure for table `reservation_groups`
--

CREATE TABLE `reservation_groups` (
  `id` bigint UNSIGNED NOT NULL,
  `group_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guest_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guest_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guest_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_in` date NOT NULL,
  `check_out` date NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `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;

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

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

CREATE TABLE `reservation_payments` (
  `id` bigint UNSIGNED NOT NULL,
  `reservation_id` bigint UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_date` date NOT NULL,
  `notes` varchar(255) COLLATE utf8mb4_unicode_ci 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 `reservation_payments`
--

INSERT INTO `reservation_payments` (`id`, `reservation_id`, `amount`, `method`, `reference`, `payment_date`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, '700.00', 'GCash', 'GC-20260612-001', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(2, 2, '1500.00', 'Bank Transfer', 'BT-BDO-20260610-882', '2026-06-10', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(3, 4, '1698.00', 'Cash', 'OR-2026-0041', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(4, 5, '1500.00', 'Maya', 'MY-20260611-4421', '2026-06-11', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(5, 6, '3498.00', 'Credit Card', 'CC-VISA-20260612-7721', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(6, 8, '6596.00', 'Credit Card', 'CC-MC-20260610-3341', '2026-06-10', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(7, 9, '899.00', 'GCash', 'GC-20260613-991', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(8, 10, '3000.00', 'Bank Transfer', 'BT-BPI-20260610-5521', '2026-06-10', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(9, 11, '699.00', 'GCash', 'GC-20260608-774', '2026-06-08', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(10, 12, '1698.00', 'Credit Card', 'CC-VISA-20260611-1201', '2026-06-11', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(11, 13, '1698.00', 'GCash', 'GC-20260612-3312', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(12, 14, '1698.00', 'Maya', 'MY-20260612-8821', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(13, 15, '1398.00', 'Cash', 'OR-2026-0038', '2026-06-11', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(14, 16, '899.00', 'Cash', 'OR-2026-0039', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(15, 17, '1798.00', 'Credit Card', 'CC-MC-20260611-4409', '2026-06-11', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(16, 18, '1698.00', 'GCash', 'GC-20260612-5678', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(17, 19, '2097.00', 'Cash', 'OR-2026-0029', '2026-06-05', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(18, 20, '3396.00', 'Bank Transfer', 'BT-BDO-20260603-2201', '2026-06-03', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(19, 21, '2097.00', 'Maya', 'MY-20260602-1109', '2026-06-02', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(20, 22, '2097.00', 'Credit Card', 'CC-VISA-20260601-0088', '2026-06-01', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(21, 23, '1398.00', 'Cash', 'OR-2026-0033', '2026-06-08', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(22, 24, '3596.00', 'Bank Transfer', 'BT-BPI-20260605-3301', '2026-06-05', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(23, 25, '3596.00', 'GCash', 'GC-20260607-7734', '2026-06-07', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(24, 26, '3396.00', 'Credit Card', 'CC-MC-20260606-5519', '2026-06-06', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(25, 27, '1000.00', 'GCash', 'GC-20260610-2288', '2026-06-10', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(26, 28, '1500.00', 'Maya', 'MY-20260609-6612', '2026-06-09', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(27, 29, '2000.00', 'Bank Transfer', 'BT-BDO-20260611-9914', '2026-06-11', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(28, 30, '3000.00', 'Credit Card', 'CC-VISA-20260608-1133', '2026-06-08', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(29, 32, '2697.00', 'GCash', 'GC-20260610-4491', '2026-06-10', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(30, 33, '2000.00', 'Maya', 'MY-20260611-8812', '2026-06-11', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(31, 34, '700.00', 'GCash', 'GC-20260612-7701', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(32, 36, '1000.00', 'Bank Transfer', 'BT-BPI-20260611-6630', '2026-06-11', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(33, 37, '1249.00', 'Credit Card', 'CC-VISA-20260613-9911', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(34, 38, '1500.00', 'Maya', 'MY-20260612-1145', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(35, 40, '1000.00', 'GCash', 'GC-20260613-3301', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(36, 41, '1000.00', 'Bank Transfer', 'BT-BDO-20260613-4482', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(37, 43, '1000.00', 'GCash', 'GC-20260613-5590', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(38, 47, '1700.00', 'Maya', 'MY-20260613-2278', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(39, 48, '1000.00', 'GCash', 'GC-20260613-8823', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(40, 49, '3500.00', 'Bank Transfer', 'BT-BPI-20260612-7701', '2026-06-12', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(41, 51, '1700.00', 'Credit Card', 'CC-VISA-20260613-4412', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(42, 52, '2000.00', 'GCash', 'GC-20260613-6634', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(43, 54, '1700.00', 'Maya', 'MY-20260613-9956', '2026-06-13', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(44, 56, '1700.00', 'GCash', 'GC-20260614-1101', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(45, 57, '1700.00', 'Bank Transfer', 'BT-BDO-20260614-2202', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(46, 58, '1800.00', 'Credit Card', 'CC-VISA-20260614-3303', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(47, 59, '3300.00', 'Bank Transfer', 'BT-BPI-20260614-4404', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(48, 60, '3500.00', 'Credit Card', 'CC-MC-20260614-5505', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(49, 62, '1350.00', 'GCash', 'GC-20260614-6606', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(50, 63, '1875.00', 'Maya', 'MY-20260614-7707', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(51, 64, '1400.00', 'GCash', 'GC-20260614-8808', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(52, 66, '3300.00', 'Bank Transfer', 'BT-BDO-20260614-9909', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(53, 67, '3500.00', 'Credit Card', 'CC-VISA-20260614-0010', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(54, 69, '3300.00', 'Maya', 'MY-20260614-1111', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(55, 71, '3500.00', 'Credit Card', 'CC-MC-20260614-2222', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL),
(56, 72, '3300.00', 'Bank Transfer', 'BT-BPI-20260614-3333', '2026-06-14', NULL, '2026-06-17 23:03:35', '2026-06-17 23:03:35', NULL);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `is_system`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'super_admin', 'Full unrestricted access to all features.', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(2, 'Manager', 'manager', 'All operational access except staff/role management.', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(3, 'Front Desk', 'front_desk', 'Reservations, check-in/out, guest profiles.', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(4, 'Housekeeping', 'housekeeping', 'Housekeeping tasks and room status updates.', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(5, 'Maintenance', 'maintenance', 'Work order creation and resolution.', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36'),
(6, 'Accountant', 'accountant', 'Reports, payments, and billing access.', 1, '2026-06-17 23:03:36', '2026-06-17 23:03:36');

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

--
-- Table structure for table `role_permission`
--

CREATE TABLE `role_permission` (
  `role_id` bigint UNSIGNED NOT NULL,
  `permission_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_permission`
--

INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(1, 2),
(2, 2),
(5, 2),
(1, 3),
(1, 4),
(2, 4),
(1, 5),
(2, 5),
(3, 5),
(6, 5),
(1, 6),
(2, 6),
(3, 6),
(1, 7),
(2, 7),
(3, 7),
(1, 8),
(2, 8),
(3, 8),
(1, 9),
(2, 9),
(3, 9),
(1, 10),
(2, 10),
(1, 11),
(2, 11),
(3, 11),
(6, 11),
(1, 12),
(2, 12),
(3, 12),
(1, 13),
(2, 13),
(3, 13),
(4, 13),
(1, 14),
(2, 14),
(4, 14),
(1, 15),
(2, 15),
(4, 15),
(5, 15),
(1, 16),
(2, 16),
(4, 16),
(5, 16),
(1, 17),
(2, 17),
(5, 17),
(1, 18),
(2, 18),
(1, 19),
(2, 19),
(1, 20),
(2, 20),
(1, 21),
(2, 21),
(1, 22),
(2, 22),
(3, 22),
(1, 23),
(2, 23),
(6, 23),
(1, 24),
(2, 24),
(6, 24),
(1, 25),
(2, 25),
(6, 25),
(1, 26),
(2, 26),
(3, 26),
(6, 26),
(1, 27),
(2, 27),
(3, 27),
(1, 28),
(2, 28),
(6, 28),
(1, 29),
(2, 29),
(6, 29),
(1, 30),
(2, 30),
(1, 31),
(2, 31),
(3, 31),
(6, 31),
(1, 32),
(2, 32),
(1, 33),
(2, 33),
(1, 34),
(2, 34),
(1, 35),
(1, 36),
(2, 36),
(1, 37),
(1, 38),
(2, 38),
(1, 39),
(2, 39),
(3, 39),
(4, 39),
(5, 39),
(6, 39),
(1, 40),
(2, 40),
(6, 40);

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

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

CREATE TABLE `rooms` (
  `id` bigint UNSIGNED NOT NULL,
  `no` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `floor` tinyint UNSIGNED NOT NULL,
  `wing` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `beds` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_pax` tinyint UNSIGNED NOT NULL DEFAULT '2',
  `rate` int UNSIGNED NOT NULL,
  `sqm` tinyint UNSIGNED NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `amenities` json 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`, `no`, `name`, `floor`, `wing`, `type`, `beds`, `max_pax`, `rate`, `sqm`, `status`, `notes`, `amenities`, `created_at`, `updated_at`) VALUES
(1, '101', 'Junior Deluxe', 1, 'A', 'Junior Deluxe', '1 Single Bed', 1, 699, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(2, '102', 'Junior Deluxe', 1, 'A', 'Junior Deluxe', '1 Single Bed', 1, 699, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(3, '103', 'Junior Deluxe', 1, 'A', 'Junior Deluxe', '1 Single Bed', 1, 699, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(4, '104', 'Junior Deluxe', 1, 'A', 'Junior Deluxe', '1 Single Bed', 1, 699, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(5, '105', 'Superior Deluxe', 1, 'A', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(6, '106', 'Superior Deluxe', 1, 'A', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(7, '107', 'Barkadahan', 1, 'A', 'Barkadahan', '2 Queen Beds', 4, 1499, 35, 'available', 'Group / barkada room', '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(8, '108', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(9, '109', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(10, '110', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(11, '111', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(12, '112', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(13, '113', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(14, '114', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(15, '115', 'Superior Deluxe', 1, 'B', 'Superior Deluxe', '1 Queen Bed', 2, 849, 20, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(16, '116', 'Junior Deluxe', 1, 'B', 'Junior Deluxe', '1 Single Bed', 1, 699, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(17, '117', 'Junior Deluxe', 1, 'B', 'Junior Deluxe', '1 Single Bed', 1, 699, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(18, '201', 'Deluxe Twin', 2, 'A', 'Deluxe Twin', '2 Single Beds', 2, 899, 22, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(19, '202', 'Economy Twin', 2, 'A', 'Economy Twin', '2 Single Beds', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(20, '203', 'Family Room', 2, 'A', 'Family Room', '2 Queen Beds', 4, 1649, 30, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(21, '204', 'Economy Twin', 2, 'A', 'Economy Twin', '2 Single Beds', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(22, '205', 'Economy Double', 2, 'A', 'Economy Double', '1 Queen Bed', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(23, '206', 'Standard Twin', 2, 'A', 'Standard Twin', '2 Single Beds', 2, 849, 18, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(24, '207', 'Economy Twin', 2, 'B', 'Economy Twin', '2 Single Beds', 2, 699, 16, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(25, '208', 'Ordinary Twin', 2, 'B', 'Ordinary Twin', '2 Single Beds', 2, 549, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(26, '209', 'Economy Twin', 2, 'B', 'Economy Twin', '2 Single Beds', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(27, '210', 'Economy Twin', 2, 'B', 'Economy Twin', '2 Single Beds', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(28, '211', 'Ordinary Double', 2, 'B', 'Ordinary Double', '1 Queen Bed', 2, 549, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(29, '212', 'Economy Double', 2, 'B', 'Economy Double', '1 Queen Bed', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(30, '213', 'Economy Junior', 2, 'B', 'Economy Junior', '1 Single Bed', 1, 0, 14, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(31, '214', 'Economy Double', 2, 'B', 'Economy Double', '1 Queen Bed', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(32, '301', 'Deluxe Twin', 3, 'A', 'Deluxe Twin', '2 Single Beds', 2, 899, 22, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(33, '302', 'Family Room 2', 3, 'A', 'Family Room 2', '2 Queen Beds', 4, 1649, 30, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(34, '303', 'Deluxe Twin', 3, 'A', 'Deluxe Twin', '2 Single Beds', 2, 899, 22, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(35, '304', 'Deluxe Twin', 3, 'A', 'Deluxe Twin', '2 Single Beds', 2, 899, 22, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(36, '305', 'Ordinary Twin', 3, 'A', 'Ordinary Twin', '2 Single Beds', 2, 549, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(37, '306', 'Ordinary Twin', 3, 'A', 'Ordinary Twin', '2 Single Beds', 2, 549, 16, 'out_of_order', 'Flagged — see management', '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(38, '307', 'Deluxe Double', 3, 'A', 'Deluxe Double', '1 Queen Bed', 2, 899, 22, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(39, '308', 'Deluxe Double', 3, 'A', 'Deluxe Double', '1 Queen Bed', 2, 899, 22, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(40, '309', 'Ordinary Twin', 3, 'B', 'Ordinary Twin', '2 Single Beds', 2, 549, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(41, '310', 'Barkadahan', 3, 'B', 'Barkadahan', '2 Queen Beds', 4, 1499, 35, 'available', 'Group / barkada room', '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(42, '311', 'Standard Twin', 3, 'B', 'Standard Twin', '2 Single Beds', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(43, '312', 'Ordinary Twin', 3, 'B', 'Ordinary Twin', '2 Single Beds', 2, 549, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(44, '313', 'Ordinary Twin', 3, 'B', 'Ordinary Twin', '2 Single Beds', 2, 549, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(45, '314', 'Standard Twin', 3, 'B', 'Standard Twin', '2 Single Beds', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(46, '315', 'Standard Twin', 3, 'B', 'Standard Twin', '2 Single Beds', 2, 849, 18, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(47, '316', 'Ordinary Twin', 3, 'B', 'Ordinary Twin', '2 Single Beds', 2, 549, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(48, '317', 'Standard Twin', 3, 'B', 'Standard Twin', '2 Single Beds', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(49, '318', 'Economy Double', 3, 'B', 'Economy Double', '1 Queen Bed', 2, 699, 16, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(50, '401', 'Deluxe Trio', 4, 'A', 'Deluxe Trio', '1 King + 1 Single', 3, 1249, 26, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(51, '402', 'Executive Suite', 4, 'A', 'Executive Suite', '1 King Bed', 4, 1749, 45, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(52, '403', 'Deluxe Twin', 4, 'A', 'Deluxe Twin', '2 Single Beds', 2, 899, 22, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(53, '404', 'Standard Twin', 4, 'A', 'Standard Twin', '2 Single Beds', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(54, '405', 'Deluxe Twin', 4, 'A', 'Deluxe Twin', '2 Single Beds', 2, 899, 22, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(55, '406', 'Deluxe Trio', 4, 'A', 'Deluxe Trio', '1 King + 1 Single', 3, 1249, 26, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(56, '407', 'Deluxe Twin', 4, 'A', 'Deluxe Twin', '2 Single Beds', 2, 899, 22, 'occupied', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(57, '408', 'Standard Double', 4, 'B', 'Standard Double', '1 Queen Bed', 2, 849, 18, 'dirty', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(58, '409', 'Standard Double', 4, 'B', 'Standard Double', '1 Queen Bed', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(59, '410', 'Standard Twin', 4, 'B', 'Standard Twin', '2 Single Beds', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(60, '411', 'Standard Double', 4, 'B', 'Standard Double', '1 Queen Bed', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(61, '412', 'Standard Double', 4, 'B', 'Standard Double', '1 Queen Bed', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(62, '413', 'Standard Double', 4, 'B', 'Standard Double', '1 Queen Bed', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35'),
(63, '414', 'Standard Double', 4, 'B', 'Standard Double', '1 Queen Bed', 2, 849, 18, 'available', NULL, '[\"Free Wi-Fi\", \"Air Conditioning\"]', '2026-06-17 23:03:35', '2026-06-17 23:03:35');

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

--
-- Table structure for table `room_photos`
--

CREATE TABLE `room_photos` (
  `id` bigint UNSIGNED NOT NULL,
  `room_no` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caption` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` smallint UNSIGNED NOT NULL DEFAULT '0',
  `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 `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('xDSxA41XphvjGfzRtOiEBJEkMmaAsn6cT2K1JYUz', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiI0ZEx6eFNqQmdVU3Rmb0Jta3E2b3d3bUtTS1VVUEFuMzZVbzBqbjgzIiwidXJsIjpbXSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL3B2aC1tYWluLnRlc3RcL2Rhc2hib2FyZCIsInJvdXRlIjoiZGFzaGJvYXJkIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjEsInBtc190b3VyX3Nob3duIjp0cnVlfQ==', 1781743921);

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

--
-- Table structure for table `shifts`
--

CREATE TABLE `shifts` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `shift_type` enum('morning','afternoon','night','custom') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'custom',
  `started_at` datetime NOT NULL,
  `ended_at` datetime DEFAULT NULL,
  `status` enum('open','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `opening_cash` decimal(10,2) DEFAULT NULL,
  `closing_cash` decimal(10,2) DEFAULT NULL,
  `handover_notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `channel_configs`
--
ALTER TABLE `channel_configs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `channel_configs_source_unique` (`source`);

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

--
-- Indexes for table `folio_charges`
--
ALTER TABLE `folio_charges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `folio_charges_reservation_id_index` (`reservation_id`),
  ADD KEY `folio_charges_pos_transaction_id_foreign` (`pos_transaction_id`);

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

--
-- Indexes for table `guest_reminders`
--
ALTER TABLE `guest_reminders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `guest_reminders_reservation_id_foreign` (`reservation_id`),
  ADD KEY `guest_reminders_created_by_foreign` (`created_by`);

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

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

--
-- Indexes for table `maintenance_requests`
--
ALTER TABLE `maintenance_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `maintenance_requests_room_no_index` (`room_no`);

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

--
-- Indexes for table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `newsletter_subscribers_email_unique` (`email`);

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

--
-- Indexes for table `pos_transactions`
--
ALTER TABLE `pos_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pos_transactions_reservation_id_index` (`reservation_id`);

--
-- Indexes for table `pos_transaction_items`
--
ALTER TABLE `pos_transaction_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pos_transaction_items_pos_transaction_id_index` (`pos_transaction_id`);

--
-- Indexes for table `rate_plans`
--
ALTER TABLE `rate_plans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rate_plans_code_unique` (`code`);

--
-- Indexes for table `rate_plan_rates`
--
ALTER TABLE `rate_plan_rates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rate_plan_rates_rate_plan_id_room_type_unique` (`rate_plan_id`,`room_type`),
  ADD KEY `rate_plan_rates_rate_plan_id_index` (`rate_plan_id`);

--
-- Indexes for table `reservations`
--
ALTER TABLE `reservations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reservations_booking_no_unique` (`booking_no`),
  ADD KEY `reservations_group_id_foreign` (`group_id`);

--
-- Indexes for table `reservation_groups`
--
ALTER TABLE `reservation_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reservation_groups_group_no_unique` (`group_no`);

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

--
-- Indexes for table `role_permission`
--
ALTER TABLE `role_permission`
  ADD PRIMARY KEY (`role_id`,`permission_id`),
  ADD KEY `role_permission_permission_id_foreign` (`permission_id`);

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rooms_no_unique` (`no`);

--
-- Indexes for table `room_photos`
--
ALTER TABLE `room_photos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `room_photos_room_no_foreign` (`room_no`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `channel_configs`
--
ALTER TABLE `channel_configs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT for table `folio_charges`
--
ALTER TABLE `folio_charges`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `guests`
--
ALTER TABLE `guests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `guest_reminders`
--
ALTER TABLE `guest_reminders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `maintenance_requests`
--
ALTER TABLE `maintenance_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pos_products`
--
ALTER TABLE `pos_products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `pos_transactions`
--
ALTER TABLE `pos_transactions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `pos_transaction_items`
--
ALTER TABLE `pos_transaction_items`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT for table `rate_plans`
--
ALTER TABLE `rate_plans`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `rate_plan_rates`
--
ALTER TABLE `rate_plan_rates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `reservations`
--
ALTER TABLE `reservations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `reservation_groups`
--
ALTER TABLE `reservation_groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reservation_payments`
--
ALTER TABLE `reservation_payments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `room_photos`
--
ALTER TABLE `room_photos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `shifts`
--
ALTER TABLE `shifts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `folio_charges`
--
ALTER TABLE `folio_charges`
  ADD CONSTRAINT `folio_charges_pos_transaction_id_foreign` FOREIGN KEY (`pos_transaction_id`) REFERENCES `pos_transactions` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `guest_reminders`
--
ALTER TABLE `guest_reminders`
  ADD CONSTRAINT `guest_reminders_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `guest_reminders_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `reservations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `reservations`
--
ALTER TABLE `reservations`
  ADD CONSTRAINT `reservations_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `reservation_groups` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `role_permission`
--
ALTER TABLE `role_permission`
  ADD CONSTRAINT `role_permission_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_permission_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `room_photos`
--
ALTER TABLE `room_photos`
  ADD CONSTRAINT `room_photos_room_no_foreign` FOREIGN KEY (`room_no`) REFERENCES `rooms` (`no`) ON DELETE CASCADE;

--
-- Constraints for table `shifts`
--
ALTER TABLE `shifts`
  ADD CONSTRAINT `shifts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

