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

START TRANSACTION;



--
-- Database: `chap8_db`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `admin_id` int(6) NOT NULL,
  `name` varchar(150) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`admin_id`, `name`, `email`, `password`) VALUES
(1, 'Haslina binti Hisham', 'haslinahisham@gmail.com', '$2y$10$IaWjHR.Qzs4JII.hd1bSAOAuhk7omkXUlPx9dkSIFNOI9SXUPduIq'),
(2, 'Ammar bin Muhammad Ali', 'ammar@yahoo.com', '$2y$10$DIHdLZmoc2p072ZhD.vDeeWTfDtAzWsB73nf4ZX.7GwFydKoVxapO'),
(3, 'Haslina Hisham', 'haslina_i@gapps.kptm.edu.my', '$2y$10$UXS6mGKrhVFQsiF/lywn4.s6IsD0RLphx65idoSxQasD3MNmlR.G.'),
(4, 'Harissa binti Hasbullah', 'irdina@gmail.com', '$2y$10$nDxdkPy14VQS4D2pOJtjF.hf6nDBSM2NGd9ngLs00fwLyfPCnmPk.'),
(5, 'Haslina Hisham', 'haslina@gmail.com', '$2y$10$vAmz0JQWfqTDSz44Qve7m.DApWBoqoHGPYN8BPeFtmc8h9KjuZP1u'),
(6, 'Haslina Hisham', 'haslinahisham_i@gmail.com', '$2y$10$43GOZFwdwSr38Fg5Qarw0Ofb0QSbKW2FwvKfIKZYBUOP7Q9FXxw2W'),
(7, 'Ammar bin Muhammad Ali', 'ammar@gmail.com', '$2y$10$QMf0VVql/U0k/NFK4jniTe1SoR8hArFGg3rOgLfd53yr4XP6fBdoC'),
(8, 'Haslina Hisham', 'haslinahshm@gmail.com', '$2y$10$COWAmKO7N5Bd0gOrvI6.cOrFqiS/vqggC93X/ARGANGEW9aT90dyK'),
(9, 'Admin', 'admin@gmail.com', '$2y$10$NKUAPjtrUDCqNcxxPeH5tu5jrS/v/TW5NtPzGZRdwt87R/5hoF4D.');

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

--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `booking_id` int(11) NOT NULL,
  `cust_name` varchar(150) NOT NULL,
  `cust_phone` varchar(12) NOT NULL,
  `package` varchar(100) NOT NULL,
  `date_event` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` (`booking_id`, `cust_name`, `cust_phone`, `package`, `date_event`) VALUES
(1, 'Haslina Hisham', '0195536393', 'Basic', '2025-10-11'),
(2, 'Siti Aishah binti Ahmad', '0195536393', 'Premium', '2025-09-23'),
(3, 'Nazim bin Othman', '0195536393', 'Standard', '2025-09-24'),
(4, 'Farahin binti Nor', '0195536393', 'Basic', '2025-09-24'),
(5, 'Muhsin bin Ahmad', '0195536393', 'Standard', '2025-09-19'),
(7, 'Siti Aishah binti Ahmad', '0195536393', 'Standard', '2025-09-30'),
(8, 'Nur Karmila binti Hamid', '0198216393', 'Premium', '2025-09-20'),
(9, 'Nur Karmila binti Hamid', '0195536393', 'Premium', '2025-09-20'),
(10, 'Haslina Hisham', '0195536393', 'Basic', '2025-09-27'),
(11, 'Nur Karmila binti Hamid', '0198216393', 'Standard', '2025-10-04'),
(12, 'Nur Karmila binti Hamid', '0195536393', 'Standard', '2025-09-18'),
(13, 'Ali bin Abu', '0198216393', 'Basic', '2025-09-27'),
(14, 'Farahin binti Nor', '0195536393', 'Basic', '2025-10-10');

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

--
-- Table structure for table `package_page`
--

CREATE TABLE `package_page` (
  `package_id` int(11) NOT NULL,
  `package_name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `price` decimal(10,0) NOT NULL,
  `image` varchar(150) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `package_page`
--

INSERT INTO `package_page` (`package_id`, `package_name`, `description`, `price`, `image`, `create_at`) VALUES
(4, 'Standard', 'This is Standard Package', 1000, '20250921-pelamin1.jpg', '2025-09-20 23:12:59'),
(5, 'Premium', 'This is Premium package', 8000, '20250921-20250921-basic.jpg', '2025-09-21 00:56:33'),
(6, 'Basic', 'Basic Package', 800, '20250921-Basic-conclusion.png', '2025-09-21 04:52:36'),
(7, 'Premium', 'Premium Package 1', 10000, '20250921-pelamin3.jpg', '2025-09-21 04:53:40');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`admin_id`);

--
-- Indexes for table `booking`
--
ALTER TABLE `booking`
  ADD PRIMARY KEY (`booking_id`);

--
-- Indexes for table `package_page`
--
ALTER TABLE `package_page`
  ADD PRIMARY KEY (`package_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `admin_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
  MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `package_page`
--
ALTER TABLE `package_page`
  MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

