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

START TRANSACTION;



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

--
-- 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 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 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;

