-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 12, 2025 at 11:26 AM
-- Server version: 8.0.13
-- PHP Version: 8.3.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `laravel_Liverwire`
--

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

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

CREATE TABLE `rooms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `room_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('Normal','Suite','VIP Room','') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_operational` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  `is_occupied` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`id`, `room_name`, `floor`, `type`, `is_operational`, `is_occupied`, `created_at`, `updated_at`) VALUES
(1, 'G01', 'ground', 'VIP Room', 'no', 'no', NULL, '2021-03-19 02:32:07'),
(2, 'G02', 'ground', 'VIP Room', 'yes', 'no', NULL, '2025-03-31 19:24:09'),
(3, 'G03', 'ground', 'VIP Room', 'yes', 'no', NULL, '2025-03-31 19:24:09'),
(4, 'G04', 'ground', 'VIP Room', 'yes', 'no', NULL, '2020-03-06 00:35:32'),
(5, 'G05', 'ground', 'Normal', 'yes', 'no', NULL, NULL),
(6, 'G06', 'ground', 'Normal', 'yes', 'no', NULL, '2025-04-10 18:19:10'),
(7, 'G07', 'ground', 'Normal', 'yes', 'no', NULL, '2025-04-10 18:19:10'),
(8, 'G08', 'ground', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:35:11'),
(9, 'F01', 'first', 'Suite', 'yes', 'no', NULL, '2019-05-11 22:35:37'),
(10, 'F02', 'first', 'Suite', 'yes', 'no', NULL, '2019-05-10 22:51:01'),
(11, 'FO3', 'first', 'Suite', 'yes', 'no', NULL, '2019-12-20 05:33:31'),
(12, 'F04', 'first', 'Suite', 'yes', 'no', NULL, '2019-12-20 05:33:07'),
(13, 'F05', 'first', 'VIP Room', 'yes', 'no', NULL, '2019-12-20 05:32:26'),
(14, 'F06', 'first', 'VIP Room', 'yes', 'no', NULL, '2019-12-20 05:32:28'),
(15, 'F07', 'first', 'Normal', 'yes', 'no', NULL, '2025-03-24 13:15:54'),
(16, 'F08', 'first', 'Normal', 'yes', 'no', NULL, NULL),
(17, 'F09', 'first', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:32:12'),
(18, 'F10', 'first', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:32:44'),
(19, 'F11', 'first', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:32:40'),
(20, 'F12', 'first', 'Normal', 'yes', 'no', NULL, NULL),
(21, 'S01', 'second', 'Normal', 'yes', 'no', NULL, '2025-03-11 12:43:41'),
(22, 'S02', 'second', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:32:09'),
(23, 'S03', 'second', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:32:19'),
(24, 'S04', 'second', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:33:56'),
(25, 'S05', 'second', 'Normal', 'yes', 'no', NULL, '2025-04-01 07:24:10'),
(26, 'S06', 'second', 'Normal', 'yes', 'no', NULL, '2019-12-20 06:55:50'),
(27, 'S07', 'second', 'Normal', 'yes', 'no', NULL, '2025-04-01 07:24:10'),
(28, 'T01', 'third', 'Normal', 'yes', 'no', NULL, '2019-05-10 23:07:21'),
(29, 'T02', 'third', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:32:08'),
(30, 'T03', 'third', 'Normal', 'yes', 'no', NULL, NULL),
(31, 'T04', 'third', 'Normal', 'yes', 'no', NULL, NULL),
(32, 'T05', 'third', 'Normal', 'yes', 'no', NULL, '2019-05-10 23:02:17'),
(33, 'T06', 'third', 'Normal', 'yes', 'no', NULL, '2019-12-20 05:32:21'),
(34, 'T07', 'third', 'Normal', 'yes', 'no', NULL, '2019-05-11 22:33:02'),
(35, 'T08', 'third', 'Normal', 'yes', 'no', NULL, '2019-07-16 01:09:04'),
(36, 'T09', 'third', 'Normal', 'yes', 'no', NULL, '2019-07-11 23:30:34'),
(37, 'T10', 'third', 'Normal', 'yes', 'no', NULL, '2019-07-16 00:59:54');


--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
