-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------



-- Dumping database structure for catering
CREATE DATABASE IF NOT EXISTS `catering` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `catering`;

-- Dumping structure for table catering.detail_pemesanan
CREATE TABLE IF NOT EXISTS `detail_pemesanan` (
  `id_detail_pemesanan` varchar(8) NOT NULL,
  `id_pemesanan` varchar(8) DEFAULT NULL,
  `id_menu` varchar(8) DEFAULT NULL,
  `jumlah` int NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `tanggal_pemesanan` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `alamat_pengiriman` text NOT NULL,
  `tanggal_pengiriman` date NOT NULL,
  `jam_pengiriman` time NOT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  PRIMARY KEY (`id_detail_pemesanan`),
  KEY `id_pemesanan` (`id_pemesanan`),
  KEY `id_menu` (`id_menu`),
  CONSTRAINT `detail_pemesanan_ibfk_1` FOREIGN KEY (`id_pemesanan`) REFERENCES `pemesanan` (`id_pemesanan`) ON DELETE CASCADE,
  CONSTRAINT `detail_pemesanan_ibfk_2` FOREIGN KEY (`id_menu`) REFERENCES `menu` (`id_menu`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table catering.detail_pemesanan: ~171 rows (approximately)
INSERT INTO `detail_pemesanan` (`id_detail_pemesanan`, `id_pemesanan`, `id_menu`, `jumlah`, `subtotal`, `tanggal_pemesanan`, `alamat_pengiriman`, `tanggal_pengiriman`, `jam_pengiriman`, `latitude`, `longitude`) VALUES
	('DP1', 'PSM1', 'MNU2', 12, 300000.00, '2025-03-11 14:08:15', 'Jakarat aja ', '2025-03-15', '14:11:00', NULL, NULL),
	('DP100', 'PSM47', 'MNU4', 10, 100000.00, '2025-10-10 23:40:24', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '08:40:00', NULL, NULL),
	('DP101', 'PSM48', 'MNU2', 15, 450000.00, '2025-10-10 23:41:14', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '17:44:00', NULL, NULL),
	('DP102', 'PSM49', 'MNU8', 10, 250000.00, '2025-10-10 23:42:04', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-15', '14:41:00', NULL, NULL),
	('DP103', 'PSM49', 'MNU5', 10, 120000.00, '2025-10-10 23:42:04', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-15', '14:41:00', NULL, NULL),
	('DP104', 'PSM50', 'MNU1', 20, 500000.00, '2025-10-10 23:42:48', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-15', '09:42:00', NULL, NULL),
	('DP105', 'PSM51', 'MNU4', 30, 300000.00, '2025-10-10 23:43:37', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '09:43:00', NULL, NULL),
	('DP106', 'PSM51', 'MNU5', 20, 240000.00, '2025-10-10 23:43:37', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '09:43:00', NULL, NULL),
	('DP107', 'PSM52', 'MNU2', 12, 360000.00, '2025-10-10 23:52:57', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '13:52:00', NULL, NULL),
	('DP108', 'PSM52', 'MNU3', 12, 300000.00, '2025-10-10 23:52:57', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '13:52:00', NULL, NULL),
	('DP109', 'PSM53', 'MNU9', 20, 500000.00, '2025-10-10 23:53:45', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '10:56:00', NULL, NULL),
	('DP11', 'PSM10', 'MNU1', 10, 250000.00, '2025-10-10 15:24:10', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-13', '11:00:00', NULL, NULL),
	('DP110', 'PSM54', 'MNU8', 10, 250000.00, '2025-10-10 23:54:34', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '06:00:00', NULL, NULL),
	('DP111', 'PSM54', 'MNU5', 18, 216000.00, '2025-10-10 23:54:34', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '06:00:00', NULL, NULL),
	('DP112', 'PSM55', 'MNU1', 12, 300000.00, '2025-10-11 15:46:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '17:46:00', NULL, NULL),
	('DP113', 'PSM56', 'MNU1', 12, 300000.00, '2025-10-12 21:52:46', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '08:52:00', NULL, NULL),
	('DP114', 'PSM56', 'MNU2', 10, 300000.00, '2025-10-12 21:52:46', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '08:52:00', NULL, NULL),
	('DP115', 'PSM57', 'MNU1', 10, 250000.00, '2025-10-12 22:01:10', 'Jl. Mawar No. 18, Metro Utara', '2025-10-15', '08:04:00', NULL, NULL),
	('DP116', 'PSM57', 'MNU5', 10, 120000.00, '2025-10-12 22:01:10', 'Jl. Mawar No. 18, Metro Utara', '2025-10-15', '08:04:00', NULL, NULL),
	('DP117', 'PSM58', 'MNU1', 100, 2500000.00, '2025-10-30 11:40:50', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-16', '11:43:00', NULL, NULL),
	('DP118', 'PSM59', 'MNU2', 10, 300000.00, '2025-10-30 17:40:39', 'Jl. Mawar No. 18, Metro Utara', '2025-11-01', '12:40:00', NULL, NULL),
	('DP119', 'PSM60', 'MNU3', 19, 475000.00, '2025-10-30 18:06:43', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-11-01', '18:06:00', NULL, NULL),
	('DP12', 'PSM10', 'MNU5', 10, 120000.00, '2025-10-10 15:24:10', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-13', '11:00:00', NULL, NULL),
	('DP120', 'PSM61', 'MNU1', 10, 250000.00, '2025-10-31 13:43:39', 'Rejomulyo, Metro, Lampung, Sumatra, 34123, Indonesia', '2025-10-31', '17:43:00', -5.15275200, 105.32036070),
	('DP121', 'PSM62', 'MNU2', 5, 150000.00, '2025-10-31 13:49:52', 'Tejo Sari, Metro, Lampung, Sumatra, 34112, Indonesia', '2025-10-31', '20:49:00', -5.13721670, 105.32173510),
	('DP122', 'PSM63', 'MNU1', 10, 250000.00, '2025-10-31 14:03:01', 'Tejo Sari, Metro, Lampung, Sumatra, 34123, Indonesia', '2025-10-31', '19:02:00', -5.13721670, 105.32173510),
	('DP123', 'PSM64', 'MNU3', 35, 875000.00, '2025-10-31 14:13:45', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-10-31', '19:13:00', -5.14226320, 105.32804489),
	('DP124', 'PSM65', 'MNU2', 10, 300000.00, '2025-10-31 14:36:34', 'RSU Muhammadiyah Metro, Jalan Soekarno-Hatta, Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2025-10-31', '17:29:00', -5.13524046, 105.29020786),
	('DP125', 'PSM66', 'MNU1', 50, 1250000.00, '2025-11-02 13:37:50', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2025-11-07', '07:00:00', -5.13510823, 105.30518532),
	('DP126', 'PSM67', 'MNU2', 20, 600000.00, '2025-11-02 13:54:38', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-11-07', '10:54:00', -5.14828410, 105.33187065),
	('DP127', 'PSM68', 'MNU3', 20, 500000.00, '2025-11-02 14:15:34', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-11-07', '14:15:00', -5.16476768, 105.31386922),
	('DP128', 'PSM69', 'MNU2', 10, 300000.00, '2025-11-06 16:58:08', 'Permukiman, Metro, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-08', '10:00:00', -5.14863522, 105.33203504),
	('DP129', 'PSM70', 'MNU2', 1, 30000.00, '2025-11-24 13:35:33', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-11-25', '07:35:00', -5.14383455, 105.32483859),
	('DP13', 'PSM10', 'MNU10', 10, 120000.00, '2025-10-10 15:24:10', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-13', '11:00:00', NULL, NULL),
	('DP130', 'PSM71', 'MNU8', 25, 625000.00, '2025-11-24 13:37:59', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2025-11-25', '07:00:00', -5.13645575, 105.30512430),
	('DP131', 'PSM72', 'MNU1', 10, 250000.00, '2025-11-24 13:40:03', 'Jalan Arjuna, Banjar Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2025-11-25', '09:39:00', -5.13012975, 105.33516491),
	('DP132', 'PSM73', 'MNU6', 10, 100000.00, '2025-11-24 20:52:31', 'Jalan Metro - Tanjung Kari, Permukiman 41 46, Banar Joyo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-28', '11:10:00', -5.13704057, 105.34229278),
	('DP133', 'PSM73', 'MNU9', 10, 250000.00, '2025-11-24 20:52:31', 'Jalan Metro - Tanjung Kari, Permukiman 41 46, Banar Joyo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-28', '11:10:00', -5.13704057, 105.34229278),
	('DP134', 'PSM74', 'MNU1', 10, 250000.00, '2025-11-25 08:14:51', 'Tejo Sari, Metro, Lampung, Sumatera, 34112, Indonesia', '2025-11-26', '12:14:00', -5.13442434, 105.32029152),
	('DP135', 'PSM75', 'MNU2', 1, 30000.00, '2025-11-26 22:19:23', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia', '2025-11-28', '08:25:00', -5.13024440, 105.35053253),
	('DP136', 'PSM75', 'MNU3', 1, 25000.00, '2025-11-26 22:19:23', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia', '2025-11-28', '08:25:00', -5.13024440, 105.35053253),
	('DP137', 'PSM76', 'MNU1', 1, 25000.00, '2025-11-26 22:22:06', 'Permukiman, Adi Warno, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-29', '09:26:00', -5.15024801, 105.34109115),
	('DP138', 'PSM77', 'MNU1', 1, 25000.00, '2025-12-26 21:39:50', 'Banjar Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2025-12-31', '08:41:00', -5.12619801, 105.34795761),
	('DP139', 'PSM78', 'MNU1', 10, 250000.00, '2025-12-26 22:18:12', 'Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2025-12-27', '08:20:00', -5.11701873, 105.32017708),
	('DP14', 'PSM11', 'MNU2', 6, 180000.00, '2025-10-10 15:43:37', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-14', '19:01:00', NULL, NULL),
	('DP140', 'PSM79', 'MNU2', 1, 30000.00, '2025-12-26 22:20:01', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-12-27', '09:19:00', -5.13460577, 105.34148287),
	('DP141', 'PSM80', 'MNU2', 1, 30000.00, '2025-12-26 22:21:01', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-12-27', '09:01:00', -5.15683181, 105.32122819),
	('DP142', 'PSM81', 'MNU1', 1, 25000.00, '2025-12-26 22:35:19', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia', '2025-12-27', '16:35:00', -5.12545712, 105.35774231),
	('DP143', 'PSM82', 'MNU2', 10, 300000.00, '2026-01-02 17:17:49', 'Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2026-01-03', '09:17:00', -5.13397510, 105.29494329),
	('DP144', 'PSM82', 'MNU6', 10, 100000.00, '2026-01-02 17:17:49', 'Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2026-01-03', '09:17:00', -5.13397510, 105.29494329),
	('DP145', 'PSM83', 'MNU1', 10, 250000.00, '2026-01-02 17:20:28', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-03', '09:02:00', -5.12491328, 105.32326773),
	('DP146', 'PSM83', 'MNU5', 10, 120000.00, '2026-01-02 17:20:28', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-03', '09:02:00', -5.12491328, 105.32326773),
	('DP147', 'PSM84', 'MNU8', 20, 500000.00, '2026-01-02 21:32:52', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '10:32:00', -5.13503164, 105.34332275),
	('DP148', 'PSM84', 'MNU5', 10, 120000.00, '2026-01-02 21:32:52', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '10:32:00', -5.13503164, 105.34332275),
	('DP149', 'PSM85', 'MNU3', 10, 250000.00, '2026-01-02 21:34:32', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-05', '09:43:00', -5.12237956, 105.32135009),
	('DP15', 'PSM11', 'MNU6', 5, 50000.00, '2025-10-10 15:43:37', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-14', '19:01:00', NULL, NULL),
	('DP150', 'PSM85', 'MNU6', 20, 200000.00, '2026-01-02 21:34:32', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-05', '09:43:00', -5.12237956, 105.32135009),
	('DP151', 'PSM86', 'MNU7', 20, 500000.00, '2026-01-02 21:36:21', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '11:36:00', -5.15486414, 105.31688690),
	('DP152', 'PSM86', 'MNU5', 10, 120000.00, '2026-01-02 21:36:21', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '11:36:00', -5.15486414, 105.31688690),
	('DP153', 'PSM87', 'MNU1', 20, 500000.00, '2026-01-02 21:42:46', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '12:00:00', -5.15349640, 105.30590057),
	('DP154', 'PSM88', 'MNU2', 12, 360000.00, '2026-01-04 13:58:20', 'Permukiman, Adi Warno, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-13', '18:58:00', -5.15107252, 105.34064864),
	('DP155', 'PSM89', 'MNU1', 6, 150000.00, '2026-01-05 16:39:25', 'Jalan Selagai, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-06', '07:40:00', -5.11875801, 105.31112255),
	('DP156', 'PSM89', 'MNU3', 5, 125000.00, '2026-01-05 16:39:25', 'Jalan Selagai, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-06', '07:40:00', -5.11875801, 105.31112255),
	('DP157', 'PSM90', 'MNU1', 12, 300000.00, '2026-01-05 16:42:17', 'Jalan Metro - Tanjung Kari, Batas pemukiman desa (sawah, kelurahan, desa), Banar Joyo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-06', '06:42:00', -5.13448814, 105.35077677),
	('DP158', 'PSM91', 'MNU2', 5, 150000.00, '2026-01-08 21:06:49', 'Iringmulyo, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-09', '07:06:00', -5.11704820, 105.32944761),
	('DP159', 'PSM91', 'MNU5', 5, 60000.00, '2026-01-08 21:06:49', 'Iringmulyo, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-09', '07:06:00', -5.11704820, 105.32944761),
	('DP16', 'PSM12', 'MNU3', 12, 300000.00, '2025-10-10 15:52:33', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-16', '15:55:00', NULL, NULL),
	('DP160', 'PSM92', 'MNU3', 10, 250000.00, '2026-01-08 21:09:18', 'Jalan Ahmad Yani, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-09', '07:28:00', -5.11773212, 105.31348292),
	('DP161', 'PSM92', 'MNU6', 20, 200000.00, '2026-01-08 21:09:18', 'Jalan Ahmad Yani, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-09', '07:28:00', -5.11773212, 105.31348292),
	('DP162', 'PSM93', 'MNU7', 10, 250000.00, '2026-01-08 21:11:10', 'Metro, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-09', '08:11:00', -5.15808233, 105.31914781),
	('DP163', 'PSM93', 'MNU4', 10, 100000.00, '2026-01-08 21:11:10', 'Metro, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-09', '08:11:00', -5.15808233, 105.31914781),
	('DP164', 'PSM94', 'MNU1', 20, 500000.00, '2026-01-08 21:13:13', 'Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2026-01-12', '13:13:00', -5.13653974, 105.29082337),
	('DP165', 'PSM95', 'MNU2', 10, 300000.00, '2026-01-22 13:34:14', 'Batas pemukiman desa (sawah, kelurahan, desa), Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia ', '2026-01-23', '17:34:00', -5.13722365, 105.35850162),
	('DP166', 'PSM96', 'MNU9', 5, 125000.00, '2026-01-24 07:39:57', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-26', '08:40:00', -5.14042820, 105.32647512),
	('DP167', 'PSM96', 'MNU6', 5, 50000.00, '2026-01-24 07:39:57', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-26', '08:40:00', -5.14042820, 105.32647512),
	('DP168', 'PSM97', 'MNU8', 10, 250000.00, '2026-01-24 07:43:50', 'Lampung Timur, Lampung, Sumatera, 34112, Indonesia ', '2026-01-26', '08:15:00', -5.13337559, 105.32879257),
	('DP169', 'PSM98', 'MNU7', 6, 150000.00, '2026-01-24 07:46:08', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-26', '08:50:00', -5.13504269, 105.30664810),
	('DP17', 'PSM12', 'MNU4', 10, 100000.00, '2025-10-10 15:52:33', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-16', '15:55:00', NULL, NULL),
	('DP170', 'PSM98', 'MNU5', 6, 72000.00, '2026-01-24 07:46:08', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-26', '08:50:00', -5.13504269, 105.30664810),
	('DP171', 'PSM99', 'MNU1', 10, 250000.00, '2026-01-24 23:46:37', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2026-01-26', '09:00:00', -5.12991331, 105.33956409),
	('DP172', 'PSM100', 'MNU2', 10, 300000.00, '2026-01-25 00:14:45', 'Banjar Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2026-01-28', '11:00:00', -5.11875801, 105.33240880),
	('DP173', 'PSM101', 'MNU4', 10, 100000.00, '2026-01-25 14:02:14', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-28', '18:02:00', -5.13927535, 105.29773282),
	('DP174', 'PSM101', 'MNU14', 10, 150000.00, '2026-01-25 14:02:14', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-28', '18:02:00', -5.13927535, 105.29773282),
	('DP175', 'PSM102', 'MNU1', 5, 125000.00, '2026-01-26 08:36:40', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-27', '11:36:00', -5.13537359, 105.34263610),
	('DP176', 'PSM103', 'MNU1', 10, 250000.00, '2026-02-10 16:32:28', 'Ganjar Agung, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-02-13', '18:32:00', -5.12178270, 105.29788381),
	('DP177', 'PSM103', 'MNU1', 10, 250000.00, '2026-02-10 10:31:35', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '09:29:00', NULL, NULL),
	('DP178', 'PSM103', 'MNU16', 10, 180000.00, '2026-02-10 10:32:51', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '09:29:00', NULL, NULL),
	('DP179', 'PSM103', 'MNU1', 10, 250000.00, '2026-02-10 10:32:51', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '09:29:00', NULL, NULL),
	('DP18', 'PSM12', 'MNU14', 10, 150000.00, '2025-10-10 15:52:33', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-16', '15:55:00', NULL, NULL),
	('DP180', 'PSM103', 'MNU17', 10, 150000.00, '2026-02-10 10:37:23', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-11', '17:40:00', NULL, NULL),
	('DP181', 'PSM104', 'MNU17', 10, 150000.00, '2026-02-10 10:40:18', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-10', '19:40:00', NULL, NULL),
	('DP182', 'PSM103', 'MNU17', 10, 150000.00, '2026-02-10 10:41:46', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '18:41:00', NULL, NULL),
	('DP183', 'PSM104', 'MNU17', 10, 150000.00, '2026-02-10 10:44:06', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-10', '18:44:00', NULL, NULL),
	('DP184', 'PSM105', 'MNU14', 10, 150000.00, '2026-02-10 10:48:04', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '20:47:00', NULL, NULL),
	('DP19', 'PSM13', 'MNU1', 30, 750000.00, '2025-10-10 15:59:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '19:02:00', NULL, NULL),
	('DP2', 'PSM1', 'MNU1', 13, 325000.00, '2025-03-11 14:08:15', 'Jakarat aja ', '2025-03-15', '14:11:00', NULL, NULL),
	('DP20', 'PSM13', 'MNU5', 30, 360000.00, '2025-10-10 15:59:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '19:02:00', NULL, NULL),
	('DP21', 'PSM13', 'MNU10', 30, 360000.00, '2025-10-10 15:59:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '19:02:00', NULL, NULL),
	('DP22', 'PSM14', 'MNU3', 6, 150000.00, '2025-10-10 16:00:30', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '20:00:00', NULL, NULL),
	('DP23', 'PSM14', 'MNU6', 7, 70000.00, '2025-10-10 16:00:30', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '20:00:00', NULL, NULL),
	('DP24', 'PSM15', 'MNU1', 7, 175000.00, '2025-10-10 16:49:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '19:52:00', NULL, NULL),
	('DP25', 'PSM15', 'MNU5', 7, 84000.00, '2025-10-10 16:49:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '19:52:00', NULL, NULL),
	('DP26', 'PSM15', 'MNU17', 7, 105000.00, '2025-10-10 16:49:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '19:52:00', NULL, NULL),
	('DP27', 'PSM16', 'MNU3', 12, 300000.00, '2025-10-10 16:51:19', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:54:00', NULL, NULL),
	('DP28', 'PSM16', 'MNU5', 12, 144000.00, '2025-10-10 16:51:19', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:54:00', NULL, NULL),
	('DP3', 'PSM2', 'MNU2', 1, 25000.00, '2025-03-11 14:11:27', 'Jakarta', '2025-12-12', '12:34:00', NULL, NULL),
	('DP30', 'PSM17', 'MNU1', 5, 125000.00, '2025-10-10 16:56:46', 'Jl. Melati No. 45, Metro Pusat', '2025-10-12', '16:58:00', NULL, NULL),
	('DP31', 'PSM17', 'MNU5', 5, 60000.00, '2025-10-10 16:56:46', 'Jl. Melati No. 45, Metro Pusat', '2025-10-12', '16:58:00', NULL, NULL),
	('DP32', 'PSM17', 'MNU10', 5, 60000.00, '2025-10-10 16:56:46', 'Jl. Melati No. 45, Metro Pusat', '2025-10-12', '16:58:00', NULL, NULL),
	('DP33', 'PSM18', 'MNU2', 12, 360000.00, '2025-10-10 17:09:07', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:08:00', NULL, NULL),
	('DP34', 'PSM18', 'MNU5', 19, 228000.00, '2025-10-10 17:09:07', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:08:00', NULL, NULL),
	('DP35', 'PSM19', 'MNU5', 20, 240000.00, '2025-10-10 22:38:05', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:00:00', NULL, NULL),
	('DP36', 'PSM19', 'MNU10', 20, 240000.00, '2025-10-10 22:38:05', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:00:00', NULL, NULL),
	('DP37', 'PSM20', 'MNU2', 10, 300000.00, '2025-10-10 22:40:34', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '08:40:00', NULL, NULL),
	('DP38', 'PSM20', 'MNU1', 10, 250000.00, '2025-10-10 22:40:34', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '08:40:00', NULL, NULL),
	('DP39', 'PSM20', 'MNU5', 10, 120000.00, '2025-10-10 22:40:35', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '08:40:00', NULL, NULL),
	('DP4', 'PSM3', 'MNU1', 20, 500000.00, '2025-03-12 12:01:02', 'bekasi', '2025-03-27', '18:00:00', NULL, NULL),
	('DP40', 'PSM21', 'MNU4', 12, 120000.00, '2025-10-10 22:42:06', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '15:42:00', NULL, NULL),
	('DP42', 'PSM21', 'MNU12', 20, 200000.00, '2025-10-10 22:42:06', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '15:42:00', NULL, NULL),
	('DP43', 'PSM22', 'MNU3', 20, 500000.00, '2025-10-10 22:45:37', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '18:46:00', NULL, NULL),
	('DP44', 'PSM22', 'MNU4', 10, 100000.00, '2025-10-10 22:45:37', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '18:46:00', NULL, NULL),
	('DP45', 'PSM23', 'MNU4', 20, 200000.00, '2025-10-10 22:51:38', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '11:54:00', NULL, NULL),
	('DP46', 'PSM23', 'MNU5', 20, 240000.00, '2025-10-10 22:51:38', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '11:54:00', NULL, NULL),
	('DP47', 'PSM23', 'MNU13', 20, 260000.00, '2025-10-10 22:51:38', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '11:54:00', NULL, NULL),
	('DP48', 'PSM24', 'MNU5', 10, 120000.00, '2025-10-10 22:52:51', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '07:52:00', NULL, NULL),
	('DP49', 'PSM24', 'MNU14', 10, 150000.00, '2025-10-10 22:52:51', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '07:52:00', NULL, NULL),
	('DP50', 'PSM25', 'MNU4', 20, 200000.00, '2025-10-10 22:55:23', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '22:55:00', NULL, NULL),
	('DP51', 'PSM25', 'MNU5', 20, 240000.00, '2025-10-10 22:55:23', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '22:55:00', NULL, NULL),
	('DP52', 'PSM26', 'MNU1', 12, 300000.00, '2025-10-10 22:56:22', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '18:57:00', NULL, NULL),
	('DP53', 'PSM26', 'MNU4', 13, 130000.00, '2025-10-10 22:56:22', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '18:57:00', NULL, NULL),
	('DP54', 'PSM26', 'MNU10', 6, 72000.00, '2025-10-10 22:56:22', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '18:57:00', NULL, NULL),
	('DP55', 'PSM27', 'MNU1', 30, 750000.00, '2025-10-10 22:57:35', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '05:00:00', NULL, NULL),
	('DP56', 'PSM27', 'MNU5', 30, 360000.00, '2025-10-10 22:57:35', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '05:00:00', NULL, NULL),
	('DP57', 'PSM27', 'MNU11', 30, 450000.00, '2025-10-10 22:57:35', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '05:00:00', NULL, NULL),
	('DP58', 'PSM28', 'MNU2', 16, 480000.00, '2025-10-10 22:58:48', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '14:00:00', NULL, NULL),
	('DP59', 'PSM28', 'MNU6', 16, 160000.00, '2025-10-10 22:58:48', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '14:00:00', NULL, NULL),
	('DP6', 'PSM5', 'MNU1', 1, 25000.00, '2025-03-12 13:25:45', 'Goden Sleman yk', '2025-03-12', '19:00:00', NULL, NULL),
	('DP60', 'PSM29', 'MNU1', 20, 500000.00, '2025-10-10 23:01:49', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-11', '06:01:00', NULL, NULL),
	('DP61', 'PSM29', 'MNU4', 10, 100000.00, '2025-10-10 23:01:49', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-11', '06:01:00', NULL, NULL),
	('DP62', 'PSM29', 'MNU11', 10, 150000.00, '2025-10-10 23:01:49', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-11', '06:01:00', NULL, NULL),
	('DP63', 'PSM30', 'MNU2', 10, 300000.00, '2025-10-10 23:12:24', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '11:12:00', NULL, NULL),
	('DP64', 'PSM30', 'MNU5', 20, 240000.00, '2025-10-10 23:12:24', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '11:12:00', NULL, NULL),
	('DP65', 'PSM30', 'MNU6', 10, 100000.00, '2025-10-10 23:12:24', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '11:12:00', NULL, NULL),
	('DP66', 'PSM31', 'MNU5', 29, 348000.00, '2025-10-10 23:13:17', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '08:13:00', NULL, NULL),
	('DP67', 'PSM31', 'MNU4', 29, 290000.00, '2025-10-10 23:13:17', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '08:13:00', NULL, NULL),
	('DP68', 'PSM32', 'MNU1', 20, 500000.00, '2025-10-10 23:14:25', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '16:14:00', NULL, NULL),
	('DP69', 'PSM32', 'MNU4', 20, 200000.00, '2025-10-10 23:14:25', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '16:14:00', NULL, NULL),
	('DP7', 'PSM6', 'MNU2', 10, 300000.00, '2025-04-25 20:39:33', 'Jalan Sidomuncul Jakarta Sletan ', '2025-05-12', '10:45:00', NULL, NULL),
	('DP70', 'PSM32', 'MNU11', 10, 150000.00, '2025-10-10 23:14:25', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '16:14:00', NULL, NULL),
	('DP71', 'PSM33', 'MNU10', 20, 240000.00, '2025-10-10 23:15:18', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '13:15:00', NULL, NULL),
	('DP72', 'PSM33', 'MNU4', 20, 200000.00, '2025-10-10 23:15:18', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '13:15:00', NULL, NULL),
	('DP73', 'PSM34', 'MNU6', 30, 300000.00, '2025-10-10 23:16:45', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '07:16:00', NULL, NULL),
	('DP74', 'PSM34', 'MNU11', 30, 450000.00, '2025-10-10 23:16:45', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '07:16:00', NULL, NULL),
	('DP75', 'PSM35', 'MNU1', 30, 750000.00, '2025-10-10 23:20:06', 'Jl. Srikandi No. 8, Metro Timur', '2025-10-13', '23:22:00', NULL, NULL),
	('DP76', 'PSM36', 'MNU1', 10, 250000.00, '2025-10-10 23:26:24', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '13:26:00', NULL, NULL),
	('DP77', 'PSM36', 'MNU5', 20, 240000.00, '2025-10-10 23:26:24', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '13:26:00', NULL, NULL),
	('DP78', 'PSM37', 'MNU7', 20, 500000.00, '2025-10-10 23:27:27', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '04:27:00', NULL, NULL),
	('DP79', 'PSM37', 'MNU4', 10, 100000.00, '2025-10-10 23:27:27', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '04:27:00', NULL, NULL),
	('DP8', 'PSM6', 'MNU6', 10, 100000.00, '2025-04-25 20:39:33', 'Jalan Sidomuncul Jakarta Sletan ', '2025-05-12', '10:45:00', NULL, NULL),
	('DP80', 'PSM37', 'MNU10', 10, 120000.00, '2025-10-10 23:27:27', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '04:27:00', NULL, NULL),
	('DP81', 'PSM38', 'MNU8', 20, 500000.00, '2025-10-10 23:28:45', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '16:28:00', NULL, NULL),
	('DP82', 'PSM38', 'MNU5', 10, 120000.00, '2025-10-10 23:28:45', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '16:28:00', NULL, NULL),
	('DP83', 'PSM39', 'MNU8', 15, 375000.00, '2025-10-10 23:29:52', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '10:29:00', NULL, NULL),
	('DP84', 'PSM39', 'MNU6', 15, 150000.00, '2025-10-10 23:29:52', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '10:29:00', NULL, NULL),
	('DP85', 'PSM39', 'MNU11', 15, 225000.00, '2025-10-10 23:29:52', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '10:29:00', NULL, NULL),
	('DP86', 'PSM40', 'MNU9', 20, 500000.00, '2025-10-10 23:30:55', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '19:30:00', NULL, NULL),
	('DP87', 'PSM40', 'MNU4', 20, 200000.00, '2025-10-10 23:30:55', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '19:30:00', NULL, NULL),
	('DP88', 'PSM41', 'MNU2', 10, 300000.00, '2025-10-10 23:31:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '07:31:00', NULL, NULL),
	('DP89', 'PSM41', 'MNU10', 10, 120000.00, '2025-10-10 23:31:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '07:31:00', NULL, NULL),
	('DP9', 'PSM7', 'MNU1', 1, 25000.00, '2025-05-10 21:37:46', 'Jlan JOgja karta ', '2025-05-15', '22:31:00', NULL, NULL),
	('DP90', 'PSM42', 'MNU3', 16, 400000.00, '2025-10-10 23:32:41', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '12:36:00', NULL, NULL),
	('DP91', 'PSM42', 'MNU7', 16, 400000.00, '2025-10-10 23:32:41', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '12:36:00', NULL, NULL),
	('DP92', 'PSM43', 'MNU2', 15, 450000.00, '2025-10-10 23:33:37', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:33:00', NULL, NULL),
	('DP93', 'PSM43', 'MNU8', 15, 375000.00, '2025-10-10 23:33:37', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:33:00', NULL, NULL),
	('DP94', 'PSM43', 'MNU5', 9, 108000.00, '2025-10-10 23:33:37', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:33:00', NULL, NULL),
	('DP95', 'PSM44', 'MNU7', 12, 300000.00, '2025-10-10 23:35:37', 'Jl. Gajah Mada No. 2, Metro Pusat', '2025-10-15', '10:35:00', NULL, NULL),
	('DP96', 'PSM44', 'MNU4', 12, 120000.00, '2025-10-10 23:35:37', 'Jl. Gajah Mada No. 2, Metro Pusat', '2025-10-15', '10:35:00', NULL, NULL),
	('DP97', 'PSM45', 'MNU8', 30, 750000.00, '2025-10-10 23:37:08', 'Jl. Gajah Mada No. 2, Metro Pusat', '2025-10-13', '17:37:00', NULL, NULL),
	('DP98', 'PSM46', 'MNU3', 20, 500000.00, '2025-10-10 23:39:37', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '11:39:00', NULL, NULL),
	('DP99', 'PSM47', 'MNU1', 20, 500000.00, '2025-10-10 23:40:24', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '08:40:00', NULL, NULL);

-- Dumping structure for table catering.kategori_menu
CREATE TABLE IF NOT EXISTS `kategori_menu` (
  `id_kategori` varchar(8) NOT NULL,
  `nama_kategori` varchar(25) NOT NULL,
  `deskripsi` text,
  PRIMARY KEY (`id_kategori`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table catering.kategori_menu: ~6 rows (approximately)
INSERT INTO `kategori_menu` (`id_kategori`, `nama_kategori`, `deskripsi`) VALUES
	('KAT1', 'Nasi Box', 'paket nasi boxx'),
	('KAT2', 'Snack Premium', 'Makanan ringan premium'),
	('KAT3', 'Tumpeng', 'Tumpeng keluarga'),
	('KAT5', 'Catering Sehat / Diet', 'Menu rendah kalori dan bergizi seimbang untuk program diet atau hidup sehat'),
	('KAT6', 'Minuman & Dessert', 'Aneka minuman segar dan pencuci mulut seperti jus, puding, dan es buah'),
	('KAT7', 'Katering Harian', 'Langganan makan siang/malam harian untuk karyawan atau rumah tangga');

-- Dumping structure for table catering.menu
CREATE TABLE IF NOT EXISTS `menu` (
  `id_menu` varchar(8) NOT NULL,
  `id_kategori` varchar(8) DEFAULT NULL,
  `nama_menu` varchar(25) NOT NULL,
  `deskripsi` text,
  `harga` decimal(10,2) NOT NULL,
  `gambar` varchar(100) NOT NULL DEFAULT 'default.jpg',
  PRIMARY KEY (`id_menu`),
  KEY `id_kategori` (`id_kategori`),
  CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`id_kategori`) REFERENCES `kategori_menu` (`id_kategori`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table catering.menu: ~17 rows (approximately)
INSERT INTO `menu` (`id_menu`, `id_kategori`, `nama_menu`, `deskripsi`, `harga`, `gambar`) VALUES
	('MNU1', 'KAT1', 'Paket 1', 'Nasi Ayam Bakar Dll', 25000.00, 'ayambakar.jpeg'),
	('MNU10', 'KAT6', 'Es Buah Segar', 'Campuran buah segar dengan sirup dan es batu', 12000.00, 'es buah.jpeg'),
	('MNU11', 'KAT6', 'Jus Alpukat', 'Jus alpukat kental dengan coklat leleh', 15000.00, 'alpukat.jpeg'),
	('MNU12', 'KAT6', 'Puding Coklat', 'Puding lembut dengan saus coklat manis', 10000.00, 'puding coklat.jpeg'),
	('MNU13', 'KAT6', 'Jus Mangga', 'Jus mangga manis dan segar tanpa tambahan gula', 13000.00, 'jus mangga.jpeg'),
	('MNU14', 'KAT6', 'Es Kopi Susu', 'Kopi dingin dengan susu kental manis', 15000.00, 'kopi susu.jpeg'),
	('MNU15', 'KAT6', 'Puding Vanilla', 'Puding rasa vanilla lembut dengan topping karamel', 10000.00, 'puding vanila.jpg'),
	('MNU16', 'KAT6', 'Cheesecake Mini', 'Potongan cheesecake lembut dengan saus strawberry', 18000.00, 'cheesecake.jpg'),
	('MNU17', 'KAT6', 'Brownies Coklat', 'Brownies panggang lembut dengan taburan kacang', 15000.00, 'brownies.jpg'),
	('MNU2', 'KAT1', 'Paket 2', 'Nasi Udang Balado', 30000.00, 'udangbalado.jpeg'),
	('MNU3', 'KAT1', 'Paket 3', 'Nasi Ikan Goreng', 25000.00, 'ikan.jpeg'),
	('MNU4', 'KAT2', 'Paket Snack 1', 'Kue tradisonal ', 10000.00, 'snak1.jpeg'),
	('MNU5', 'KAT2', 'Paket Snack 2', 'Kue Tradsisonal nikmat', 12000.00, 'snk2.jpeg'),
	('MNU6', 'KAT2', 'Paket Snack 3', 'Kue tradisonal  Basah', 10000.00, 'basah.jpeg'),
	('MNU7', 'KAT1', 'Paket 5', 'Nasi Ikan Balado, Sayur kacang , Sambal Lalapan', 25000.00, 'ikan balado.jpg'),
	('MNU8', 'KAT1', 'Paket 6', 'Nasi Ikan Kembung bakar, sayur asem dan Lalapan ', 25000.00, 'ikan bakar.jpg'),
	('MNU9', 'KAT1', 'Paket 7', 'Nasi Ayam Katsu , Salad sayur , Saos', 25000.00, 'ayam katsu.jpg');

-- Dumping structure for table catering.pembayaran
CREATE TABLE IF NOT EXISTS `pembayaran` (
  `id_pembayaran` varchar(8) NOT NULL,
  `id_pemesanan` varchar(8) DEFAULT NULL,
  `id_pelanggan` varchar(8) DEFAULT NULL,
  `bukti_pembayaran` varchar(200) DEFAULT NULL,
  `status_pembayaran` enum('lunas','belum lunas') NOT NULL,
  `metode_pembayaran` enum('midtrans','transfer','cash') DEFAULT NULL,
  PRIMARY KEY (`id_pembayaran`),
  KEY `id_pemesanan` (`id_pemesanan`),
  KEY `id_pelanggan` (`id_pelanggan`),
  CONSTRAINT `pembayaran_ibfk_1` FOREIGN KEY (`id_pemesanan`) REFERENCES `pemesanan` (`id_pemesanan`) ON DELETE CASCADE,
  CONSTRAINT `pembayaran_ibfk_2` FOREIGN KEY (`id_pelanggan`) REFERENCES `pelanggan` (`id_pelanggan`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table catering.pembayaran: ~97 rows (approximately)
INSERT INTO `pembayaran` (`id_pembayaran`, `id_pemesanan`, `id_pelanggan`, `bukti_pembayaran`, `status_pembayaran`, `metode_pembayaran`) VALUES
	('PMB1', 'PSM1', 'PLG5', '../uploads/ayambakar.jpeg', 'lunas', NULL),
	('PMB10', 'PSM12', 'PLG17', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB100', 'PSM103', 'PLG28', NULL, 'lunas', 'cash'),
	('PMB101', 'PSM104', 'PLG29', NULL, 'lunas', 'cash'),
	('PMB102', 'PSM103', 'PLG30', NULL, 'lunas', 'cash'),
	('PMB103', 'PSM104', 'PLG26', NULL, 'lunas', 'cash'),
	('PMB104', 'PSM105', 'PLG27', NULL, 'lunas', 'cash'),
	('PMB11', 'PSM13', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB12', 'PSM14', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB13', 'PSM15', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB14', 'PSM16', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB15', 'PSM17', 'PLG12', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB16', 'PSM18', 'PLG12', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB17', 'PSM19', 'PLG12', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB18', 'PSM20', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB19', 'PSM21', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB2', 'PSM2', 'PLG5', '../uploads/udangbalado.jpeg', 'lunas', NULL),
	('PMB20', 'PSM22', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB21', 'PSM24', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB22', 'PSM23', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB23', 'PSM25', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB24', 'PSM26', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB25', 'PSM27', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB26', 'PSM28', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB27', 'PSM29', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB28', 'PSM30', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB29', 'PSM31', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB30', 'PSM32', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB31', 'PSM33', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB32', 'PSM34', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB33', 'PSM35', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB34', 'PSM36', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB35', 'PSM37', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB36', 'PSM38', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB37', 'PSM39', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB38', 'PSM40', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB39', 'PSM41', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB4', 'PSM5', 'PLG6', '../uploads/dfd.drawio.png', 'lunas', NULL),
	('PMB40', 'PSM42', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB41', 'PSM43', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB42', 'PSM44', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB43', 'PSM45', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB44', 'PSM46', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB45', 'PSM47', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB46', 'PSM48', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB47', 'PSM49', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB48', 'PSM50', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB49', 'PSM51', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB5', 'PSM6', 'PLG7', '../uploads/basah.jpeg', 'lunas', NULL),
	('PMB50', 'PSM52', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB51', 'PSM53', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB52', 'PSM54', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB53', 'PSM55', 'PLG17', '../uploads/1760172465_bb.jpeg', 'lunas', NULL),
	('PMB54', 'PSM56', 'PLG17', '../uploads/1760280790_bb.jpeg', 'lunas', NULL),
	('PMB55', 'PSM57', 'PLG17', '../uploads/1760281302_bb.jpeg', 'lunas', NULL),
	('PMB56', 'PSM58', 'PLG17', '../uploads/1761799300_uhuy.drawio.png', 'lunas', NULL),
	('PMB57', 'PSM59', 'PLG17', '../uploads/1761820848_uhuy.drawio.png', 'lunas', NULL),
	('PMB58', 'PSM60', 'PLG17', '../uploads/1761822412_uhuy.drawio.png', 'lunas', NULL),
	('PMB59', 'PSM61', 'PLG17', '../uploads/1761893033_uhuy.drawio.png', 'lunas', NULL),
	('PMB6', 'PSM7', 'PLG2', '../uploads/j.drawio.png', 'lunas', NULL),
	('PMB60', 'PSM62', 'PLG17', '../uploads/1761893403_uhuy.drawio.png', 'lunas', NULL),
	('PMB61', 'PSM63', 'PLG17', '../uploads/1761894190_uhuy.drawio.png', 'lunas', NULL),
	('PMB62', 'PSM64', 'PLG17', '../uploads/1761894833_uhuy.drawio.png', 'lunas', NULL),
	('PMB63', 'PSM65', 'PLG14', '../uploads/1761896203_uhuy.drawio.png', 'lunas', NULL),
	('PMB64', 'PSM66', 'PLG11', '../uploads/1762065488_bb.jpeg', 'lunas', NULL),
	('PMB65', 'PSM67', 'PLG11', '../uploads/1762066492_bb.jpeg', 'lunas', NULL),
	('PMB66', 'PSM68', 'PLG11', '../uploads/1762067745_bb.jpeg', 'lunas', NULL),
	('PMB67', 'PSM69', 'PLG17', '../uploads/1762423099_bb.jpeg', 'lunas', NULL),
	('PMB68', 'PSM70', 'PLG18', '../uploads/1763966174_bb.jpeg', 'lunas', NULL),
	('PMB69', 'PSM71', 'PLG20', '../uploads/1763966291_bb.jpeg', 'lunas', NULL),
	('PMB70', 'PSM72', 'PLG20', '../uploads/1763966416_bb.jpeg', 'lunas', NULL),
	('PMB71', 'PSM73', 'PLG20', '../uploads/1763992370_bb.jpeg', 'lunas', NULL),
	('PMB72', 'PSM74', 'PLG20', '../uploads/1764033305_bb.jpeg', 'lunas', NULL),
	('PMB73', 'PSM76', 'PLG17', '../uploads/1764170585_bb.jpeg', 'lunas', NULL),
	('PMB74', 'PSM75', 'PLG17', '../uploads/1764170615_keranjang_kosong.png', 'lunas', NULL),
	('PMB75', 'PSM77', 'PLG17', '../uploads/1766760169_k.drawio.png', 'lunas', NULL),
	('PMB76', 'PSM78', 'PLG17', '../uploads/1766762303_k.drawio.png', 'lunas', NULL),
	('PMB77', 'PSM79', 'PLG14', '../uploads/1766762409_k.drawio.png', 'lunas', NULL),
	('PMB78', 'PSM80', 'PLG19', '../uploads/1766762469_rd.drawio.png', 'lunas', NULL),
	('PMB79', 'PSM82', 'PLG18', '../uploads/1767349082_Jurnal.png', 'lunas', NULL),
	('PMB8', 'PSM11', 'PLG17', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB80', 'PSM83', 'PLG20', '../uploads/1767349237_Jurnal.png', 'lunas', NULL),
	('PMB81', 'PSM84', 'PLG16', '../uploads/1767364383_WhatsApp Image 2026-01-02 at 19.19.52.jpeg', 'lunas', NULL),
	('PMB82', 'PSM85', 'PLG14', '../uploads/1767364482_WhatsApp Image 2026-01-02 at 19.19.52 (1).jpeg', 'lunas', NULL),
	('PMB83', 'PSM86', 'PLG15', '../uploads/1767364590_WhatsApp Image 2026-01-02 at 19.19.52 (1).jpeg', 'lunas', NULL),
	('PMB84', 'PSM87', 'PLG15', '../uploads/1767364976_WhatsApp Image 2026-01-02 at 19.19.52.jpeg', 'lunas', NULL),
	('PMB85', 'PSM88', 'PLG17', '../uploads/1767509918_WhatsApp Image 2026-01-02 at 19.19.52.jpeg', 'lunas', NULL),
	('PMB86', 'PSM89', 'PLG23', '../uploads/1767605981_bb.jpeg', 'lunas', NULL),
	('PMB87', 'PSM90', 'PLG11', '../uploads/1767606148_WhatsApp Image 2026-01-02 at 19.19.52 (1).jpeg', 'lunas', NULL),
	('PMB88', 'PSM91', 'PLG17', '../uploads/1767881220_bb.jpeg', 'lunas', NULL),
	('PMB89', 'PSM92', 'PLG14', '../uploads/1767881369_bb.jpeg', 'lunas', NULL),
	('PMB9', 'PSM10', 'PLG17', '../uploads/bb.jpeg', 'lunas', NULL),
	('PMB90', 'PSM93', 'PLG12', '../uploads/1767881481_bb.jpeg', 'lunas', NULL),
	('PMB91', 'PSM94', 'PLG12', '../uploads/1767881605_bb.jpeg', 'lunas', NULL),
	('PMB92', 'PSM95', 'PLG17', '../uploads/1769063668_bb.jpeg', 'lunas', NULL),
	('PMB93', 'PSM96', 'PLG24', '../uploads/1769215210_bb.jpeg', 'lunas', NULL),
	('PMB94', 'PSM97', 'PLG18', '../uploads/1769215443_bb.jpeg', 'lunas', NULL),
	('PMB95', 'PSM98', 'PLG16', '../uploads/1769215582_bb.jpeg', 'lunas', NULL),
	('PMB96', 'PSM99', 'PLG17', '../uploads/1769273211_bb.jpeg', 'lunas', NULL),
	('PMB97', 'PSM100', 'PLG25', '../uploads/1769274896_bb.jpeg', 'lunas', NULL),
	('PMB98', 'PSM101', 'PLG25', '../uploads/1769324547_bb.jpeg', 'lunas', NULL),
	('PMB99', 'PSM102', 'PLG25', '../uploads/1769391468_bb.jpeg', 'lunas', NULL);

-- Dumping structure for table catering.pemesanan
CREATE TABLE IF NOT EXISTS `pemesanan` (
  `id_pemesanan` varchar(8) NOT NULL,
  `id_pelanggan` varchar(8) DEFAULT NULL,
  `total_harga` decimal(10,2) NOT NULL,
  `status_pesanan` enum('menunggu','diproses','selesai','dibatalkan') NOT NULL,
  `sumber_pesanan` enum('web','telepon','langsung') DEFAULT 'web',
  PRIMARY KEY (`id_pemesanan`),
  KEY `id_pelanggan` (`id_pelanggan`),
  CONSTRAINT `pemesanan_ibfk_1` FOREIGN KEY (`id_pelanggan`) REFERENCES `pelanggan` (`id_pelanggan`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table catering.pemesanan: ~99 rows (approximately)
INSERT INTO `pemesanan` (`id_pemesanan`, `id_pelanggan`, `total_harga`, `status_pesanan`, `sumber_pesanan`) VALUES
	('PSM1', 'PLG5', 625000.00, 'selesai', 'web'),
	('PSM10', 'PLG17', 490000.00, 'selesai', 'web'),
	('PSM100', 'PLG25', 300000.00, 'selesai', 'web'),
	('PSM101', 'PLG25', 250000.00, 'selesai', 'web'),
	('PSM102', 'PLG25', 125000.00, 'selesai', 'web'),
	('PSM103', 'PLG30', 150000.00, 'diproses', 'langsung'),
	('PSM104', 'PLG26', 150000.00, 'diproses', 'langsung'),
	('PSM105', 'PLG27', 150000.00, 'selesai', 'langsung'),
	('PSM11', 'PLG17', 230000.00, 'selesai', 'web'),
	('PSM12', 'PLG17', 550000.00, 'selesai', 'web'),
	('PSM13', 'PLG11', 1470000.00, 'selesai', 'web'),
	('PSM14', 'PLG11', 220000.00, 'selesai', 'web'),
	('PSM15', 'PLG11', 364000.00, 'selesai', 'web'),
	('PSM16', 'PLG11', 864000.00, 'selesai', 'web'),
	('PSM17', 'PLG12', 245000.00, 'selesai', 'web'),
	('PSM18', 'PLG12', 588000.00, 'selesai', 'web'),
	('PSM19', 'PLG12', 480000.00, 'selesai', 'web'),
	('PSM2', 'PLG5', 25000.00, 'selesai', 'web'),
	('PSM20', 'PLG14', 670000.00, 'selesai', 'web'),
	('PSM21', 'PLG14', 670000.00, 'selesai', 'web'),
	('PSM22', 'PLG14', 600000.00, 'selesai', 'web'),
	('PSM23', 'PLG14', 700000.00, 'selesai', 'web'),
	('PSM24', 'PLG14', 270000.00, 'selesai', 'web'),
	('PSM25', 'PLG16', 440000.00, 'selesai', 'web'),
	('PSM26', 'PLG16', 502000.00, 'selesai', 'web'),
	('PSM27', 'PLG16', 1560000.00, 'selesai', 'web'),
	('PSM28', 'PLG16', 640000.00, 'selesai', 'web'),
	('PSM29', 'PLG20', 750000.00, 'selesai', 'web'),
	('PSM3', 'PLG5', 500000.00, 'selesai', 'web'),
	('PSM30', 'PLG20', 640000.00, 'selesai', 'web'),
	('PSM31', 'PLG20', 638000.00, 'selesai', 'web'),
	('PSM32', 'PLG20', 850000.00, 'selesai', 'web'),
	('PSM33', 'PLG20', 440000.00, 'selesai', 'web'),
	('PSM34', 'PLG20', 750000.00, 'selesai', 'web'),
	('PSM35', 'PLG20', 750000.00, 'selesai', 'web'),
	('PSM36', 'PLG19', 490000.00, 'selesai', 'web'),
	('PSM37', 'PLG19', 720000.00, 'selesai', 'web'),
	('PSM38', 'PLG19', 620000.00, 'selesai', 'web'),
	('PSM39', 'PLG19', 750000.00, 'selesai', 'web'),
	('PSM40', 'PLG19', 700000.00, 'selesai', 'web'),
	('PSM41', 'PLG19', 420000.00, 'selesai', 'web'),
	('PSM42', 'PLG19', 800000.00, 'selesai', 'web'),
	('PSM43', 'PLG19', 933000.00, 'selesai', 'web'),
	('PSM44', 'PLG20', 420000.00, 'selesai', 'web'),
	('PSM45', 'PLG20', 750000.00, 'selesai', 'web'),
	('PSM46', 'PLG15', 500000.00, 'selesai', 'web'),
	('PSM47', 'PLG15', 600000.00, 'selesai', 'web'),
	('PSM48', 'PLG15', 450000.00, 'selesai', 'web'),
	('PSM49', 'PLG15', 370000.00, 'selesai', 'web'),
	('PSM5', 'PLG6', 25000.00, 'selesai', 'web'),
	('PSM50', 'PLG15', 500000.00, 'selesai', 'web'),
	('PSM51', 'PLG15', 540000.00, 'selesai', 'web'),
	('PSM52', 'PLG15', 660000.00, 'selesai', 'web'),
	('PSM53', 'PLG15', 500000.00, 'selesai', 'web'),
	('PSM54', 'PLG15', 466000.00, 'selesai', 'web'),
	('PSM55', 'PLG17', 300000.00, 'selesai', 'web'),
	('PSM56', 'PLG17', 600000.00, 'selesai', 'web'),
	('PSM57', 'PLG17', 370000.00, 'selesai', 'web'),
	('PSM58', 'PLG17', 2500000.00, 'selesai', 'web'),
	('PSM59', 'PLG17', 300000.00, 'selesai', 'web'),
	('PSM6', 'PLG7', 400000.00, 'selesai', 'web'),
	('PSM60', 'PLG17', 475000.00, 'selesai', 'web'),
	('PSM61', 'PLG17', 250000.00, 'selesai', 'web'),
	('PSM62', 'PLG17', 150000.00, 'selesai', 'web'),
	('PSM63', 'PLG17', 250000.00, 'selesai', 'web'),
	('PSM64', 'PLG17', 875000.00, 'selesai', 'web'),
	('PSM65', 'PLG14', 300000.00, 'selesai', 'web'),
	('PSM66', 'PLG11', 1250000.00, 'selesai', 'web'),
	('PSM67', 'PLG11', 600000.00, 'selesai', 'web'),
	('PSM68', 'PLG11', 500000.00, 'selesai', 'web'),
	('PSM69', 'PLG17', 300000.00, 'selesai', 'web'),
	('PSM7', 'PLG2', 25000.00, 'selesai', 'web'),
	('PSM70', 'PLG18', 30000.00, 'selesai', 'web'),
	('PSM71', 'PLG20', 625000.00, 'selesai', 'web'),
	('PSM72', 'PLG20', 250000.00, 'selesai', 'web'),
	('PSM73', 'PLG20', 350000.00, 'selesai', 'web'),
	('PSM74', 'PLG20', 250000.00, 'selesai', 'web'),
	('PSM75', 'PLG17', 55000.00, 'selesai', 'web'),
	('PSM76', 'PLG17', 25000.00, 'selesai', 'web'),
	('PSM77', 'PLG17', 25000.00, 'selesai', 'web'),
	('PSM78', 'PLG17', 250000.00, 'selesai', 'web'),
	('PSM79', 'PLG14', 30000.00, 'selesai', 'web'),
	('PSM80', 'PLG19', 30000.00, 'selesai', 'web'),
	('PSM81', 'PLG19', 25000.00, 'selesai', 'web'),
	('PSM82', 'PLG18', 400000.00, 'selesai', 'web'),
	('PSM83', 'PLG20', 370000.00, 'selesai', 'web'),
	('PSM84', 'PLG16', 620000.00, 'selesai', 'web'),
	('PSM85', 'PLG14', 450000.00, 'selesai', 'web'),
	('PSM86', 'PLG15', 620000.00, 'selesai', 'web'),
	('PSM87', 'PLG15', 500000.00, 'selesai', 'web'),
	('PSM88', 'PLG17', 360000.00, 'selesai', 'web'),
	('PSM89', 'PLG23', 275000.00, 'selesai', 'web'),
	('PSM90', 'PLG11', 300000.00, 'selesai', 'web'),
	('PSM91', 'PLG17', 210000.00, 'selesai', 'web'),
	('PSM92', 'PLG14', 450000.00, 'selesai', 'web'),
	('PSM93', 'PLG12', 350000.00, 'selesai', 'web'),
	('PSM94', 'PLG12', 500000.00, 'selesai', 'web'),
	('PSM95', 'PLG17', 300000.00, 'selesai', 'web'),
	('PSM96', 'PLG24', 175000.00, 'selesai', 'web'),
	('PSM97', 'PLG18', 250000.00, 'selesai', 'web'),
	('PSM98', 'PLG16', 222000.00, 'selesai', 'web'),
	('PSM99', 'PLG17', 250000.00, 'selesai', 'web');

