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

START TRANSACTION;



--
-- Database: `icm_hotel`
--

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

--
-- Table structure for table `tbl_event`
--

CREATE TABLE `tbl_event` (
  `id` int NOT NULL,
  `nama_event` varchar(200) NOT NULL,
  `mulai` date NOT NULL,
  `selesai` date NOT NULL,
  `content` text NOT NULL,
  `venue` text NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_event`
--

INSERT INTO `tbl_event` (`id`, `nama_event`, `mulai`, `selesai`, `content`, `venue`, `status`, `created_at`, `updated_at`) VALUES
(1, 'PITHUGI 2025', '2025-02-08', '2025-02-11', '<p>PITHUGI 2025</p>', 'Hotel Tentrem Semarang', 1, '2025-01-20 01:09:31', '0000-00-00 00:00:00'),
(2, 'IsCOD 2025', '2025-05-02', '2025-02-04', '<p>IsCOD 2025</p>', 'Sheraton Grand Jakarta Gandaria', 1, '2025-01-20 01:25:15', '0000-00-00 00:00:00');

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

--
-- Table structure for table `tbl_hotel`
--

CREATE TABLE `tbl_hotel` (
  `id` int NOT NULL,
  `userID` int NOT NULL,
  `nama_hotel` varchar(100) NOT NULL,
  `slug_hotel` text NOT NULL,
  `bintang` int NOT NULL,
  `alamat` text NOT NULL,
  `telp` varchar(30) NOT NULL,
  `content` text NOT NULL,
  `nama_bank` varchar(50) NOT NULL,
  `nama_rekening` varchar(100) NOT NULL,
  `nomor_rekening` varchar(30) NOT NULL,
  `status` int NOT NULL,
  `nama_prov` varchar(100) NOT NULL,
  `nama_kota` varchar(100) NOT NULL,
  `thumbnail` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_hotel`
--

INSERT INTO `tbl_hotel` (`id`, `userID`, `nama_hotel`, `slug_hotel`, `bintang`, `alamat`, `telp`, `content`, `nama_bank`, `nama_rekening`, `nomor_rekening`, `status`, `nama_prov`, `nama_kota`, `thumbnail`, `created_at`, `updated_at`) VALUES
(1, 1, 'Hotel Sahid Jakarta Utara', 'hotel-sahid-jakarta-utara', 3, 'Jln unta no.411 D Kelurahan Tumpas Kec Unaaha Kab.Konawe', '085291819148', '', '', '', '', 0, 'DKI Jakarta', 'DKI Jakarta', 'hotel-1.jpg', '2025-01-20 07:29:15', '0000-00-00 00:00:00'),
(2, 2, 'Hotel Claro Jakarta', 'hotel-claro-jakarta', 5, 'PONDOK INDAH OFFICE TOWER 3, 18TH FLOOR SUITE 1801,  JL. Sultan Iskandar Muda Kav. V-TA', '082188293232', '<p>Hotel Claro Jakarta</p>', '', '', '', 0, 'DKI Jakarta', 'DKI Jakarta', 'hotel-2.jpg', '2025-01-20 10:12:04', '0000-00-00 00:00:00'),
(3, 3, 'Hotel Same Grand Jakarta', '', 5, 'Jalan Tunggal No.2 Dekat Perempatan Pasar Panjang', '081253063217', '<p>Hotel Same Grand Jakarta</p>', '', '', '', 0, 'DKI Jakarta', 'DKI Jakarta', 'hotel-3.jpg', '2025-01-21 07:33:24', '0000-00-00 00:00:00');

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

--
-- Table structure for table `tbl_hotel_detail`
--

CREATE TABLE `tbl_hotel_detail` (
  `id` int NOT NULL,
  `eventID` int NOT NULL,
  `hotelID` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_hotel_detail`
--

INSERT INTO `tbl_hotel_detail` (`id`, `eventID`, `hotelID`, `created_at`) VALUES
(1, 1, 1, '2025-01-20 07:29:15'),
(2, 2, 2, '2025-01-20 10:12:04'),
(3, 2, 3, '2025-01-21 07:33:24');

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

--
-- Table structure for table `tbl_kamar`
--

CREATE TABLE `tbl_kamar` (
  `id` int NOT NULL,
  `hotelID` int NOT NULL,
  `nama_kamar` varchar(40) NOT NULL,
  `harga` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_kamar`
--

INSERT INTO `tbl_kamar` (`id`, `hotelID`, `nama_kamar`, `harga`) VALUES
(1, 2, 'Deluxe', 1500000),
(2, 2, 'President Suite', 2500000),
(3, 2, 'Single Bed', 500000),
(4, 1, 'Deluxe', 750000),
(6, 3, 'Deluxe', 750000),
(7, 3, 'President Suite', 850000),
(8, 3, 'Single Bed', 1500000);

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

--
-- Table structure for table `tbl_permintaan`
--

CREATE TABLE `tbl_permintaan` (
  `id` int NOT NULL,
  `hotelID` int NOT NULL,
  `kamarID` int NOT NULL,
  `kuota` int NOT NULL,
  `mulai` date NOT NULL,
  `selesai` date NOT NULL,
  `status` int NOT NULL,
  `approve_by` varchar(30) NOT NULL,
  `approve_date` timestamp NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_permintaan`
--

INSERT INTO `tbl_permintaan` (`id`, `hotelID`, `kamarID`, `kuota`, `mulai`, `selesai`, `status`, `approve_by`, `approve_date`, `created_at`, `updated_at`) VALUES
(4, 1, 4, 10, '2025-01-20', '2025-01-23', 1, '', '0000-00-00 00:00:00', '2025-01-20 12:03:52', '0000-00-00 00:00:00'),
(5, 2, 1, 10, '2025-01-20', '2025-01-23', 1, '', '0000-00-00 00:00:00', '2025-01-20 12:04:09', '0000-00-00 00:00:00'),
(6, 2, 2, 10, '2025-01-20', '2025-01-23', 1, '', '0000-00-00 00:00:00', '2025-01-20 12:04:26', '0000-00-00 00:00:00'),
(7, 3, 6, 100, '2025-01-21', '2025-01-23', 1, '', '0000-00-00 00:00:00', '2025-01-21 07:34:30', '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_event`
--
ALTER TABLE `tbl_event`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_hotel`
--
ALTER TABLE `tbl_hotel`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_hotel_detail`
--
ALTER TABLE `tbl_hotel_detail`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_kamar`
--
ALTER TABLE `tbl_kamar`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_permintaan`
--
ALTER TABLE `tbl_permintaan`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

