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

START TRANSACTION;



--
-- Database: `db_koneksistudio`
--

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

--
-- Table structure for table `dat_distribusi`
--

CREATE TABLE `dat_distribusi` (
  `distribusi_id` int NOT NULL,
  `reservasi_id` int NOT NULL,
  `gdrive_link` varchar(255) NOT NULL,
  `upload_tgl` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `akses_st` enum('Active','Expired') DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(50) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` varchar(50) DEFAULT NULL,
  `deleted_st` tinyint(1) DEFAULT '0',
  `active_st` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dat_distribusi`
--

INSERT INTO `dat_distribusi` (`distribusi_id`, `reservasi_id`, `gdrive_link`, `upload_tgl`, `akses_st`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deleted_st`, `active_st`) VALUES
(2, 22, 'https://n', '2026-04-17 17:00:00', 'Active', '2026-04-18 11:01:31', '1', '2026-04-18 11:10:21', '1', NULL, NULL, 0, 1),
(3, 25, 'https://drive.google.com/file/d/123456890abcdef/view?usp=sharing', '2026-05-01 13:48:45', 'Active', '2026-05-01 12:17:33', '1', '2026-05-01 13:48:45', '1', NULL, NULL, 0, 1),
(4, 78, 'vv', '2026-06-07 15:57:45', 'Active', '2026-06-07 15:57:45', 'Admin', '2026-06-08 07:41:05', 'Admin', NULL, NULL, 0, 1),
(5, 81, 'vjlh', '2026-06-09 07:58:03', 'Active', '2026-06-09 07:58:03', 'Admin', NULL, NULL, NULL, NULL, 0, 1),
(6, 85, 'https://drive.google.com/drive/folders/1NdxR-IS7LhNB9C-o3jdJ5LQfGF1Re84R', '2026-06-09 18:40:25', 'Active', '2026-06-09 18:40:25', 'Admin', NULL, NULL, NULL, NULL, 0, 1);

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

--
-- Table structure for table `dat_jadwal_tutup`
--

CREATE TABLE `dat_jadwal_tutup` (
  `tutup_id` int NOT NULL,
  `tgl_tutup` date NOT NULL,
  `keterangan_tx` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_st` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `dat_notifikasi`
--

CREATE TABLE `dat_notifikasi` (
  `notif_id` int NOT NULL,
  `user_id` int NOT NULL,
  `tipe_notif` enum('transaksi','promo','paket','sistem','distribusi') NOT NULL,
  `target_id` varchar(50) DEFAULT NULL,
  `judul_tx` varchar(100) NOT NULL,
  `pesan_tx` text NOT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_st` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dat_notifikasi`
--

INSERT INTO `dat_notifikasi` (`notif_id`, `user_id`, `tipe_notif`, `target_id`, `judul_tx`, `pesan_tx`, `is_read`, `created_at`, `deleted_st`) VALUES
(1, 1, 'transaksi', '82', 'Pembayaran Baru Masuk 💰', 'Pelanggan a/n cc baru saja mengirim bukti transfer via cc. Silakan divalidasi!', 1, '2026-06-09 12:28:08', 0),
(2, 2, 'paket', '35', 'Paket Baru: Mrak Chibi 🎉', 'Koneksi Studio Sleman punya layanan baru nih! Yuk cek detail paket Mrak Chibi sekarang.', 0, '2026-06-09 13:25:54', 0),
(3, 3, 'paket', '35', 'Paket Baru: Mrak Chibi 🎉', 'Koneksi Studio Sleman punya layanan baru nih! Yuk cek detail paket Mrak Chibi sekarang.', 0, '2026-06-09 13:25:54', 0),
(4, 4, 'paket', '35', 'Paket Baru: Mrak Chibi 🎉', 'Koneksi Studio Sleman punya layanan baru nih! Yuk cek detail paket Mrak Chibi sekarang.', 1, '2026-06-09 13:25:54', 0),
(5, 2, 'promo', '13', 'Promo Spesial: Mark 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode M127 biar foto makin hemat.', 0, '2026-06-09 13:27:08', 0),
(6, 3, 'promo', '13', 'Promo Spesial: Mark 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode M127 biar foto makin hemat.', 0, '2026-06-09 13:27:08', 0),
(7, 4, 'promo', '13', 'Promo Spesial: Mark 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode M127 biar foto makin hemat.', 1, '2026-06-09 13:27:08', 0),
(8, 1, 'transaksi', '84', 'Pembayaran Baru Masuk 💰', 'Pelanggan a/n Yy baru saja mengirim bukti transfer via Vv. Silakan divalidasi!', 1, '2026-06-09 18:29:03', 0),
(9, 1, 'transaksi', '85', 'Pembayaran Baru Masuk 💰', 'Pelanggan a/n Haechan baru saja mengirim bukti transfer via Spay. Silakan divalidasi!', 1, '2026-06-09 18:38:14', 0),
(10, 5, 'transaksi', '85', 'Pembayaran Berhasil! ✅', 'Hore! Pembayaran untuk booking jadwalmu udah dikonfirmasi. Siap-siap dandan yang rapi ya!', 0, '2026-06-09 18:39:38', 0),
(11, 5, 'distribusi', '85', 'Hasil Foto Udah Siap! 📸', 'Yeay! Hasil jepretan paket Ponyo kamu udah bisa diunduh nih. Cek link GDrive-nya sekarang ya!', 0, '2026-06-09 18:40:25', 0),
(12, 2, 'promo', '14', 'Promo Spesial: NCT 127 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode N127 biar foto makin hemat.', 0, '2026-06-09 18:41:27', 0),
(13, 3, 'promo', '14', 'Promo Spesial: NCT 127 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode N127 biar foto makin hemat.', 0, '2026-06-09 18:41:27', 0),
(14, 4, 'promo', '14', 'Promo Spesial: NCT 127 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode N127 biar foto makin hemat.', 1, '2026-06-09 18:41:27', 0),
(15, 5, 'promo', '14', 'Promo Spesial: NCT 127 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode N127 biar foto makin hemat.', 0, '2026-06-09 18:41:27', 0),
(16, 2, 'promo', '15', 'Promo Spesial: NCT DREAM 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode NCT biar foto makin hemat.', 0, '2026-06-09 19:02:24', 0),
(17, 3, 'promo', '15', 'Promo Spesial: NCT DREAM 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode NCT biar foto makin hemat.', 0, '2026-06-09 19:02:24', 0),
(18, 4, 'promo', '15', 'Promo Spesial: NCT DREAM 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode NCT biar foto makin hemat.', 1, '2026-06-09 19:02:24', 0),
(19, 5, 'promo', '15', 'Promo Spesial: NCT DREAM 🎁', 'Koneksi Studio lagi ada promo nih! Pakai kode NCT biar foto makin hemat.', 0, '2026-06-09 19:02:24', 0),
(20, 1, 'transaksi', '86', 'Pembayaran Baru Masuk 💰', 'Pelanggan a/n Jaemin baru saja mengirim bukti transfer via Spay. Silakan divalidasi!', 1, '2026-06-09 19:05:09', 0),
(21, 4, 'transaksi', '86', 'Pembayaran Berhasil! ✅', 'Hore! Pembayaran untuk booking jadwalmu udah dikonfirmasi. Siap-siap dandan yang rapi ya!', 0, '2026-06-10 12:18:18', 0),
(22, 4, 'transaksi', '84', 'Pembayaran Berhasil! ✅', 'Hore! Pembayaran untuk booking jadwalmu udah dikonfirmasi. Siap-siap dandan yang rapi ya!', 0, '2026-06-10 12:34:06', 0),
(23, 4, 'transaksi', '83', 'Pembayaran Berhasil! ✅', 'Hore! Pembayaran untuk booking jadwalmu udah dikonfirmasi. Siap-siap dandan yang rapi ya!', 0, '2026-06-10 12:34:45', 0),
(24, 1, 'transaksi', '74', 'Pembayaran Berhasil! ✅', 'Hore! Pembayaran untuk booking jadwalmu udah dikonfirmasi. Siap-siap dandan yang rapi ya!', 0, '2026-06-10 12:35:03', 0),
(25, 4, 'transaksi', '82', 'Pembayaran Berhasil! ✅', 'Hore! Pembayaran untuk booking jadwalmu udah dikonfirmasi. Siap-siap dandan yang rapi ya!', 0, '2026-06-10 12:55:20', 0),
(26, 1, 'transaksi', '87', 'Pembayaran Baru Masuk 💰', 'Pelanggan a/n Gg baru saja mengirim bukti transfer via Vg. Silakan divalidasi!', 0, '2026-06-10 12:58:20', 0),
(27, 4, 'transaksi', '87', 'Pembayaran Berhasil! ✅', 'Hore! Pembayaran untuk booking jadwalmu udah dikonfirmasi. Siap-siap dandan yang rapi ya!', 0, '2026-06-10 12:58:55', 0);

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

--
-- Table structure for table `dat_pembayaran`
--

CREATE TABLE `dat_pembayaran` (
  `pembayaran_id` int NOT NULL,
  `reservasi_id` int NOT NULL,
  `metode_id` int NOT NULL,
  `pengirim_nm` varchar(100) DEFAULT NULL,
  `asal_bank` varchar(50) DEFAULT NULL,
  `transfer_bukti` varchar(255) DEFAULT NULL,
  `bayar_tgl` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `validasi_st` enum('Pending','Verified','Rejected') DEFAULT 'Pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(50) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` varchar(50) DEFAULT NULL,
  `deleted_st` tinyint(1) DEFAULT '0',
  `active_st` tinyint(1) DEFAULT '1',
  `expired_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dat_pembayaran`
--

INSERT INTO `dat_pembayaran` (`pembayaran_id`, `reservasi_id`, `metode_id`, `pengirim_nm`, `asal_bank`, `transfer_bukti`, `bayar_tgl`, `validasi_st`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deleted_st`, `active_st`, `expired_at`) VALUES
(31, 58, 1, NULL, NULL, NULL, '2026-06-06 16:56:06', 'Pending', '2026-06-06 16:56:06', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL),
(32, 59, 2, '', '', '', '2026-06-06 17:11:32', 'Pending', '2026-06-06 17:11:32', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL),
(33, 60, 2, '', '', '', '2026-06-06 17:13:19', 'Pending', '2026-06-06 17:13:19', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL),
(34, 61, 1, '', '', '', '2026-06-06 18:00:27', 'Pending', '2026-06-06 18:00:27', NULL, NULL, NULL, NULL, NULL, 0, 1, '2026-06-07 03:00:27'),
(35, 62, 2, '', '', '', '2026-06-06 18:02:11', 'Pending', '2026-06-06 18:02:11', NULL, NULL, NULL, NULL, NULL, 0, 1, '2026-06-07 03:02:11'),
(36, 63, 2, '', '', '', '2026-06-06 18:02:41', 'Pending', '2026-06-06 18:02:41', NULL, NULL, NULL, NULL, NULL, 0, 1, '2026-06-07 03:02:41'),
(37, 64, 2, '', '', '', '2026-06-06 18:03:10', 'Pending', '2026-06-06 18:03:10', NULL, NULL, NULL, NULL, NULL, 0, 1, '2026-06-07 03:03:10'),
(38, 65, 1, '', '', '', '2026-06-06 18:03:47', 'Pending', '2026-06-06 18:03:47', NULL, NULL, NULL, NULL, NULL, 0, 1, '2026-06-07 03:03:47'),
(39, 66, 2, '', '', '', '2026-06-06 18:05:27', 'Rejected', '2026-06-06 18:05:27', NULL, '2026-06-07 05:28:18', NULL, NULL, NULL, 0, 1, '2026-06-07 03:05:27'),
(40, 67, 1, 'Gg', 'Bca', 'BUKTI_40_1780799527.jpg', '2026-06-07 02:32:07', 'Pending', '2026-06-07 02:31:37', NULL, '2026-06-07 02:32:07', NULL, NULL, NULL, 0, 1, '2026-06-07 11:31:37'),
(41, 68, 1, 'Yy', 'Yy', 'BUKTI_41_1780799707.jpg', '2026-06-07 02:35:07', 'Rejected', '2026-06-07 02:34:55', NULL, '2026-06-07 06:01:17', NULL, NULL, NULL, 0, 1, '2026-06-07 11:34:55'),
(42, 69, 1, '', '', '', '2026-06-07 02:35:51', 'Verified', '2026-06-07 02:35:51', NULL, '2026-06-07 05:04:39', NULL, NULL, NULL, 0, 1, '2026-06-07 11:35:51'),
(43, 70, 1, '', '', '', '2026-06-07 03:14:19', 'Rejected', '2026-06-07 03:14:19', NULL, '2026-06-07 05:04:33', NULL, NULL, NULL, 0, 1, '2026-06-07 12:14:19'),
(44, 71, 1, '', '', '', '2026-06-07 03:21:30', 'Verified', '2026-06-07 03:21:30', NULL, '2026-06-07 04:52:24', NULL, NULL, NULL, 0, 1, '2026-06-07 12:21:30'),
(45, 72, 2, '', '', '', '2026-06-07 03:23:29', 'Rejected', '2026-06-07 03:23:29', NULL, '2026-06-07 04:52:21', NULL, NULL, NULL, 0, 1, '2026-06-07 12:23:29'),
(46, 73, 2, '', '', '', '2026-06-07 03:31:13', 'Rejected', '2026-06-07 03:31:13', NULL, '2026-06-07 04:52:16', NULL, NULL, NULL, 0, 1, '2026-06-07 12:31:13'),
(47, 74, 2, 'Vv', 'Vv', 'BUKTI_47_1780809026.jpg', '2026-06-07 05:10:26', 'Verified', '2026-06-07 05:10:15', NULL, '2026-06-10 12:35:03', NULL, NULL, NULL, 0, 1, '2026-06-07 14:10:15'),
(48, 75, 2, 'Yy', 'Ii', 'BUKTI_48_1780809336.jpg', '2026-06-07 05:15:36', 'Verified', '2026-06-07 05:15:26', NULL, '2026-06-07 05:55:58', NULL, NULL, NULL, 0, 1, '2026-06-07 14:15:26'),
(49, 76, 2, 'Yy', 'Bca', 'BUKTI_49_1780831737.jpg', '2026-06-07 11:28:57', 'Pending', '2026-06-07 11:28:42', NULL, '2026-06-07 11:28:57', NULL, NULL, NULL, 0, 1, '2026-06-07 20:28:42'),
(50, 77, 2, 'Gkgg', 'Ghfy', 'BUKTI_50_1780835170.jpg', '2026-06-07 12:26:10', 'Rejected', '2026-06-07 12:25:58', NULL, '2026-06-07 12:28:12', NULL, NULL, NULL, 0, 1, '2026-06-07 21:25:58'),
(51, 78, 1, 'Hjhu', 'Hjhg', 'BUKTI_51_1780835232.jpg', '2026-06-07 12:27:12', 'Verified', '2026-06-07 12:26:58', NULL, '2026-06-07 12:27:51', NULL, NULL, NULL, 0, 1, '2026-06-07 21:26:58'),
(52, 79, 2, 'Uy', 'Jhu', 'BUKTI_52_1780835898.jpg', '2026-06-07 12:38:18', 'Pending', '2026-06-07 12:38:05', NULL, '2026-06-07 12:38:18', NULL, NULL, NULL, 0, 1, '2026-06-07 21:38:05'),
(53, 80, 2, '', '', '', '2026-06-07 13:39:02', 'Pending', '2026-06-07 13:39:02', NULL, NULL, NULL, NULL, NULL, 0, 1, '2026-06-07 22:39:02'),
(54, 81, 1, 'Gg', 'Ghh', 'BUKTI_54_1780991793.jpg', '2026-06-09 07:56:33', 'Verified', '2026-06-09 07:55:58', NULL, '2026-06-09 07:57:34', NULL, NULL, NULL, 0, 1, '2026-06-09 16:55:58'),
(55, 82, 2, 'cc', 'cc', 'BUKTI_55_1781008088.jpg', '2026-06-09 12:28:08', 'Verified', '2026-06-09 12:27:51', NULL, '2026-06-10 12:55:20', NULL, NULL, NULL, 0, 1, '2026-06-09 21:27:51'),
(56, 83, 1, '', '', '', '2026-06-09 14:57:14', 'Verified', '2026-06-09 14:57:14', NULL, '2026-06-10 12:34:45', NULL, NULL, NULL, 0, 1, '2026-06-09 23:57:14'),
(57, 84, 2, 'Yy', 'Vv', 'BUKTI_57_1781029743.jpg', '2026-06-09 18:29:03', 'Verified', '2026-06-09 18:28:44', NULL, '2026-06-10 12:34:06', NULL, NULL, NULL, 0, 1, '2026-06-10 03:28:44'),
(58, 85, 1, 'Haechan', 'Spay', 'BUKTI_58_1781030294.jpg', '2026-06-09 18:38:14', 'Verified', '2026-06-09 18:37:48', NULL, '2026-06-09 18:39:38', NULL, NULL, NULL, 0, 1, '2026-06-10 03:37:48'),
(59, 86, 1, 'Jaemin', 'Spay', 'BUKTI_59_1781031909.jpg', '2026-06-09 19:05:09', 'Verified', '2026-06-09 19:04:45', NULL, '2026-06-10 12:18:18', NULL, NULL, NULL, 0, 1, '2026-06-10 04:04:45'),
(60, 87, 1, 'Gg', 'Vg', 'BUKTI_60_1781096300.jpg', '2026-06-10 12:58:20', 'Verified', '2026-06-10 12:58:10', NULL, '2026-06-10 12:58:55', NULL, NULL, NULL, 0, 1, '2026-06-10 21:58:10'),
(61, 88, 1, '', '', '', '2026-06-10 20:11:18', 'Pending', '2026-06-10 20:11:18', NULL, NULL, NULL, NULL, NULL, 0, 1, '2026-06-11 05:11:18');

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

--
-- Table structure for table `dat_reservasi`
--

CREATE TABLE `dat_reservasi` (
  `reservasi_id` int NOT NULL,
  `user_id` int NOT NULL,
  `paket_id` int NOT NULL,
  `promo_id` int DEFAULT NULL,
  `foto_syarat_promo` varchar(255) DEFAULT NULL,
  `booking_tgl` date NOT NULL,
  `booking_jam` time NOT NULL,
  `final_harga` decimal(16,4) NOT NULL,
  `tambahan_orang` int DEFAULT '0',
  `sewa_kostum` varchar(100) DEFAULT NULL,
  `catatan_tx` text,
  `reservasi_st` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'Pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(50) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` varchar(50) DEFAULT NULL,
  `deleted_st` tinyint(1) DEFAULT '0',
  `active_st` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dat_reservasi`
--

INSERT INTO `dat_reservasi` (`reservasi_id`, `user_id`, `paket_id`, `promo_id`, `foto_syarat_promo`, `booking_tgl`, `booking_jam`, `final_harga`, `tambahan_orang`, `sewa_kostum`, `catatan_tx`, `reservasi_st`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deleted_st`, `active_st`) VALUES
(22, 1, 1, 3, NULL, '2026-04-20', '10:00:00', '150000.0000', 0, NULL, NULL, 'Dibatalkan', '2026-04-13 11:53:15', 'Admin', '2026-04-28 09:54:46', '1', NULL, NULL, 0, 1),
(24, 1, 1, NULL, NULL, '2026-04-22', '09:30:00', '100000.0000', 0, NULL, NULL, 'Selesai Sempurna', '2026-04-13 11:53:15', 'Admin', '2026-04-29 14:17:32', '1', NULL, NULL, 0, 1),
(25, 1, 1, NULL, NULL, '2026-04-29', '11:00:00', '50000.0000', 0, NULL, NULL, 'Selesai', '2026-04-29 15:49:29', NULL, '2026-05-01 12:17:33', '1', NULL, NULL, 0, 1),
(58, 1, 27, NULL, NULL, '2026-06-13', '11:00:00', '136000.0000', 0, NULL, NULL, 'Pending', '2026-06-06 16:56:06', NULL, NULL, NULL, NULL, NULL, 0, 1),
(59, 1, 27, 7, NULL, '2026-06-10', '12:00:00', '212000.0000', 5, '1 Kostum', 'rr', 'Pending', '2026-06-06 17:11:32', NULL, NULL, NULL, NULL, NULL, 0, 1),
(60, 1, 14, 7, NULL, '2026-06-10', '11:00:00', '1355000.0000', 5, '1 Kostum', 'rr', 'Pending', '2026-06-06 17:13:19', NULL, NULL, NULL, NULL, NULL, 0, 1),
(61, 1, 27, 7, NULL, '2026-06-13', '11:00:00', '212000.0000', 5, '1 Kostum', 'ty', 'Pending', '2026-06-06 18:00:27', NULL, NULL, NULL, NULL, NULL, 0, 1),
(62, 1, 33, NULL, NULL, '2026-06-13', '11:30:00', '256000.0000', 4, '2 Kostum', 'tt', 'Pending', '2026-06-06 18:02:11', NULL, NULL, NULL, NULL, NULL, 0, 1),
(63, 1, 33, 7, NULL, '2026-06-13', '11:30:00', '264000.0000', 6, '1 Kostum', 'y', 'Pending', '2026-06-06 18:02:41', NULL, NULL, NULL, NULL, NULL, 0, 1),
(64, 1, 33, 7, NULL, '2026-06-12', '11:00:00', '236000.0000', 4, '2 Kostum', 'yy', 'Pending', '2026-06-06 18:03:10', NULL, NULL, NULL, NULL, NULL, 0, 1),
(65, 1, 33, 7, NULL, '2026-06-17', '11:30:00', '198000.0000', 2, '2 Kostum', 'PRMSR989', 'Pending', '2026-06-06 18:03:47', NULL, NULL, NULL, NULL, NULL, 0, 1),
(66, 1, 27, 7, NULL, '2026-06-18', '11:30:00', '322000.0000', 10, '3 Kostum', 't', 'Dibatalkan', '2026-06-06 18:05:27', NULL, '2026-06-07 05:28:18', NULL, NULL, NULL, 0, 1),
(67, 1, 32, 5, NULL, '2026-06-09', '11:00:00', '200000.0000', 3, 'Tidak Sewa', 'rr', 'Pending', '2026-06-07 02:31:37', NULL, NULL, NULL, NULL, NULL, 0, 1),
(68, 1, 32, 5, NULL, '2026-06-07', '16:30:00', '162000.0000', 1, 'Tidak Sewa', NULL, 'Dibatalkan', '2026-06-07 02:34:55', NULL, '2026-06-07 06:01:17', NULL, NULL, NULL, 0, 1),
(69, 1, 32, 5, NULL, '2026-06-07', '16:30:00', '229000.0000', 4, '1 Kostum', 'xx', 'Selesai', '2026-06-07 02:35:51', NULL, '2026-06-07 05:04:39', NULL, NULL, NULL, 0, 1),
(70, 1, 32, 5, NULL, '2026-06-09', '12:00:00', '258000.0000', 5, '2 Kostum', 'yy', 'Dibatalkan', '2026-06-07 03:14:19', NULL, '2026-06-07 05:04:33', NULL, NULL, NULL, 0, 1),
(71, 1, 32, NULL, NULL, '2026-06-09', '12:00:00', '284000.0000', 6, '2 Kostum', 'tt', 'Selesai', '2026-06-07 03:21:30', NULL, '2026-06-07 04:52:24', NULL, NULL, NULL, 0, 1),
(72, 1, 33, NULL, NULL, '2026-06-10', '12:00:00', '294000.0000', 6, '2 Kostum', NULL, 'Dibatalkan', '2026-06-07 03:23:29', NULL, '2026-06-07 04:52:21', NULL, NULL, NULL, 0, 1),
(73, 1, 33, NULL, NULL, '2026-06-05', '17:00:00', '265000.0000', 5, '1 Kostum', 'gg', 'Dibatalkan', '2026-06-07 03:31:13', NULL, '2026-06-07 04:52:16', NULL, NULL, NULL, 0, 1),
(74, 1, 33, NULL, NULL, '2026-06-17', '12:00:00', '236000.0000', 4, 'Tidak Sewa', 'vv', 'Selesai', '2026-06-07 05:10:15', NULL, '2026-06-10 12:35:03', NULL, NULL, NULL, 0, 1),
(75, 3, 33, NULL, NULL, '2026-06-10', '11:30:00', '255000.0000', 5, 'Tidak Sewa', NULL, 'Selesai', '2026-06-07 05:15:26', NULL, '2026-06-07 05:55:58', NULL, NULL, NULL, 0, 1),
(76, 3, 27, 7, NULL, '2026-06-25', '12:30:00', '222000.0000', 5, '2 Kostum', 'gg', 'Pending', '2026-06-07 11:28:42', NULL, NULL, NULL, NULL, NULL, 0, 1),
(77, 4, 32, NULL, NULL, '2026-06-07', '20:00:00', '160000.0000', 0, '1 Kostum', 'yy', 'Dibatalkan', '2026-06-07 12:25:58', NULL, '2026-06-07 12:28:12', NULL, NULL, NULL, 0, 1),
(78, 4, 14, 7, NULL, '2026-06-07', '20:30:00', '1384000.0000', 6, '2 Kostum', 'ghg', 'Selesai', '2026-06-07 12:26:58', NULL, '2026-06-07 12:27:51', NULL, NULL, NULL, 0, 1),
(79, 4, 14, NULL, NULL, '2026-06-08', '20:30:00', '1270000.0000', 0, 'Tidak Sewa', NULL, 'Pending', '2026-06-07 12:38:05', NULL, NULL, NULL, NULL, NULL, 0, 1),
(80, 3, 32, 11, NULL, '2026-06-11', '12:30:00', '122500.0000', 5, 'Tidak Sewa', 'yy', 'Pending', '2026-06-07 13:39:02', NULL, NULL, NULL, NULL, NULL, 0, 1),
(81, 4, 34, 5, NULL, '2026-06-10', '12:00:00', '146000.0000', 4, '2 Kostum', 'ccc', 'Selesai', '2026-06-09 07:55:58', NULL, '2026-06-09 07:57:34', NULL, NULL, NULL, 0, 1),
(82, 4, 27, NULL, NULL, '2026-06-09', '20:30:00', '120000.0000', 0, '2 Kostum', 'cc', 'Verified', '2026-06-09 12:27:51', NULL, '2026-06-10 12:55:20', NULL, NULL, NULL, 0, 1),
(83, 4, 35, 5, NULL, '2026-06-10', '12:00:00', '103700.0000', 4, '2 Kostum', 'tt', 'Selesai', '2026-06-09 14:57:14', NULL, '2026-06-10 12:34:45', NULL, NULL, NULL, 0, 1),
(84, 4, 34, NULL, NULL, '2026-06-10', '12:00:00', '179000.0000', 6, '1 Kostum', 'vv', 'Selesai', '2026-06-09 18:28:44', NULL, '2026-06-10 12:34:06', NULL, NULL, NULL, 0, 1),
(85, 5, 32, NULL, NULL, '2026-06-11', '09:30:00', '208000.0000', 2, '2 Kostum', 'Tolong ya disiapkan dengan baik', 'Selesai', '2026-06-09 18:37:48', NULL, '2026-06-09 18:39:38', NULL, NULL, NULL, 0, 1),
(86, 4, 34, NULL, NULL, '2026-06-10', '13:00:00', '189000.0000', 6, '2 Kostum', 'tolong disiapkan', 'Selesai', '2026-06-09 19:04:45', NULL, '2026-06-10 12:18:18', NULL, NULL, NULL, 0, 1),
(87, 4, 34, NULL, NULL, '2026-06-10', '12:00:00', '170000.0000', 5, '2 Kostum', 'cc', 'Proses', '2026-06-10 12:58:10', NULL, '2026-06-10 12:59:01', NULL, NULL, NULL, 0, 1),
(88, 4, 34, NULL, NULL, '2026-06-11', '13:30:00', '75000.0000', 0, '2 Kostum', 'gg', 'Pending', '2026-06-10 20:11:18', NULL, NULL, NULL, NULL, NULL, 0, 1);

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

--
-- Table structure for table `mst_metode_bayar`
--

CREATE TABLE `mst_metode_bayar` (
  `metode_id` int NOT NULL,
  `tipe_metode` enum('Transfer Bank','QRIS') NOT NULL,
  `nama_metode` varchar(50) NOT NULL,
  `rekening_no` varchar(50) DEFAULT NULL,
  `atas_nama` varchar(100) NOT NULL,
  `qris_gambar` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(50) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` varchar(50) DEFAULT NULL,
  `deleted_st` tinyint(1) DEFAULT '0',
  `active_st` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `mst_metode_bayar`
--

INSERT INTO `mst_metode_bayar` (`metode_id`, `tipe_metode`, `nama_metode`, `rekening_no`, `atas_nama`, `qris_gambar`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deleted_st`, `active_st`) VALUES
(1, 'QRIS', 'QRIS', '-', 'Koneksi Studio', 'qris.jpeg', '2026-06-06 16:45:26', NULL, '2026-06-07 03:17:54', NULL, NULL, NULL, 0, 1),
(2, 'Transfer Bank', 'Bank BCA', '1234567890', 'Koneksi Studio', NULL, '2026-06-06 17:04:55', NULL, NULL, NULL, NULL, NULL, 0, 1);

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

--
-- Table structure for table `mst_paket`
--

CREATE TABLE `mst_paket` (
  `paket_id` int NOT NULL,
  `paket_nm` varchar(100) NOT NULL,
  `kategori_tx` varchar(50) DEFAULT NULL,
  `deskripsi_tx` text,
  `fasilitas_tx` text,
  `durasi_menit` int DEFAULT NULL,
  `normal_harga` decimal(16,4) NOT NULL,
  `thumbnail_foto` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(50) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` varchar(50) DEFAULT NULL,
  `deleted_st` tinyint(1) DEFAULT '0',
  `active_st` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `mst_paket`
--

INSERT INTO `mst_paket` (`paket_id`, `paket_nm`, `kategori_tx`, `deskripsi_tx`, `fasilitas_tx`, `durasi_menit`, `normal_harga`, `thumbnail_foto`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deleted_st`, `active_st`) VALUES
(1, 'Paket Graduation Basic', NULL, 'Foto wisuda 1 jam, max 5 orang dapat 1 cetak 10R', NULL, 0, '150000.0000', NULL, '2026-04-08 20:19:03', NULL, '2026-04-26 15:23:32', NULL, '2026-04-26 15:23:32', '0', 1, 0),
(3, 'bbb', NULL, 'bbbbbb', NULL, 0, '55000.0000', 'paket_1775715993.jpg', '2026-04-09 06:26:33', NULL, '2026-04-26 15:23:34', NULL, '2026-04-26 15:23:34', '0', 1, 0),
(4, 'gg', NULL, 'gg&', NULL, 0, '25000.0000', 'paket_1775831628.jpg', '2026-04-10 14:33:48', NULL, '2026-04-26 15:23:37', NULL, '2026-04-26 15:23:37', '0', 1, 0),
(5, 'vv', NULL, 'vvv', NULL, 0, '250000.0000', 'paket_1775832088.jpg', '2026-04-10 14:41:28', NULL, '2026-04-26 15:23:39', NULL, '2026-04-26 15:23:39', '0', 1, 0),
(6, 'hhii', NULL, 'hhh', 'cc', 30, '21000.0000', 'paket_1775833166.jpg', '2026-04-10 14:59:26', NULL, '2026-04-26 15:24:22', '0', '2026-04-26 15:24:22', '0', 1, 0),
(7, 'yyy', NULL, 'yuyuy', NULL, 0, '35000.0000', 'paket_1775835173.jpg', '2026-04-10 15:32:53', NULL, '2026-04-10 15:33:32', NULL, '2026-04-10 15:33:32', NULL, 1, 0),
(8, 'cf', NULL, 'cici', NULL, 0, '21000.0000', 'paket_1775977838.jpg', '2026-04-11 06:53:34', NULL, '2026-04-12 07:43:17', '1', '2026-04-12 07:43:17', NULL, 1, 0),
(9, 'ss', NULL, 'sssst', NULL, 0, '111000.0000', 'paket_1775895333.jpg', '2026-04-11 07:04:19', NULL, '2026-04-11 08:21:58', NULL, '2026-04-11 08:21:58', NULL, 1, 0),
(10, 'iii', NULL, 'uuu', NULL, 0, '260000.0000', 'paket_1775895990.jpg', '2026-04-11 08:21:13', '1', '2026-04-12 07:43:20', '1', '2026-04-12 07:43:20', NULL, 1, 0),
(11, 'ux', NULL, 'yx', NULL, 0, '210007.0000', 'paket_1775896087.jpg', '2026-04-11 08:27:44', '1', '2026-04-11 08:28:37', '1', '2026-04-11 08:28:37', NULL, 1, 0),
(12, 'ooo', NULL, 'xxx', NULL, 0, '850000.0000', 'paket_1775977877.jpg', '2026-04-12 07:11:17', '1', '2026-04-12 07:43:22', NULL, '2026-04-12 07:43:22', NULL, 1, 0),
(13, 'mt merbabu', NULL, 'cool and cold', NULL, 0, '59000.0000', 'paket_1775979895.jpg', '2026-04-12 07:44:55', '1', '2026-04-19 08:55:58', '1', '2026-04-19 08:55:58', '1', 1, 0),
(14, 'mark lee luv', 'Thematic', 'mark lee', 'mark lee\nrem', 90, '1270000.0000', 'paket_1780680692.jpg', '2026-04-12 07:56:33', '1', '2026-06-08 06:48:39', '1', '2026-06-08 06:48:39', 'Admin', 1, 1),
(15, 'llq', NULL, 'll', NULL, 0, '85000.0000', 'paket_1775996758.jpg', '2026-04-12 12:25:58', '1', '2026-04-13 15:35:15', '1', '2026-04-13 15:35:15', NULL, 1, 0),
(16, 'yy', NULL, 'yy', NULL, 0, '33.0000', 'paket_1776094560.jpg', '2026-04-13 15:36:00', '1', '2026-04-18 08:13:03', NULL, '2026-04-18 08:13:03', '1', 1, 0),
(17, 'ii', NULL, 'rr', NULL, 0, '22.0000', 'paket_1776094576.jpg', '2026-04-13 15:36:16', '1', '2026-04-18 08:13:01', NULL, '2026-04-18 08:13:01', '1', 1, 0),
(18, 'cat orange', NULL, 'cat luv', NULL, 0, '110000.0000', 'paket_1776589060.jpg', '2026-04-19 08:57:40', '1', '2026-04-19 08:58:45', '1', '2026-04-19 08:58:45', '1', 1, 0),
(19, 'shibal', NULL, 'luv everyone', NULL, 0, '111000.0000', 'paket_1776589316.jpg', '2026-04-19 09:01:56', '1', '2026-04-19 09:02:07', NULL, '2026-04-19 09:02:07', '1', 1, 0),
(20, 'shibal', NULL, 'xx', NULL, 0, '12000.0000', 'paket_1776590407.jpg', '2026-04-19 09:20:07', '1', '2026-04-19 09:20:12', NULL, '2026-04-19 09:20:12', '1', 1, 0),
(21, 'rem', NULL, 'mark', NULL, 0, '127.0000', 'paket_1776591118.jpg', '2026-04-19 09:31:26', '1', '2026-04-19 09:32:03', '1', '2026-04-19 09:32:03', '1', 1, 0),
(22, 'cattt', NULL, 'ccc', NULL, 0, '111.0000', 'paket_1776618571.jpg', '2026-04-19 17:09:31', '1', '2026-04-22 06:32:01', NULL, '2026-04-22 06:32:01', '0', 1, 0),
(23, 'rem', NULL, 'qq', NULL, 0, '127.0000', 'paket_1776618601.jpg', '2026-04-19 17:10:01', '1', '2026-04-26 15:32:42', NULL, '2026-04-26 15:32:42', '0', 1, 0),
(24, 'mark v2', NULL, 'xx', 'mark lee', 15, '127000.0000', 'paket_1776618620.jpg', '2026-04-19 17:10:20', '1', '2026-04-27 05:50:15', '0', '2026-04-27 05:50:15', '0', 1, 0),
(25, 'Prewedding', NULL, 'fmnfnfl', '1 set pakaian', 30, '15000.0000', '', '2026-04-26 13:38:04', '0', '2026-04-26 14:59:04', '0', '2026-04-26 14:59:04', '0', 1, 0),
(26, 'Yyyy', NULL, 'yy', 'yy\nyy', 45, '120000.0000', 'http://10.152.170.217/api_koneksi/uploads/paket_1777217046.jpg', '2026-04-26 15:08:17', '0', '2026-04-26 15:24:16', '0', '2026-04-26 15:24:16', '0', 1, 0),
(27, 'Kiki\'s Delivery', 'Grayscale', 'Finding magic in bakery', 'Free to choose Property\nFree digital soft copy\nFree 2 printed photo', 30, '100000.0000', 'paket_1780901848.jpg', '2026-04-26 15:26:41', '0', '2026-06-08 06:57:28', '1', NULL, NULL, 0, 1),
(28, 'shibal cat', NULL, 'shibal anyeong', 'free 1 luv', 60, '150000.0000', 'http://10.152.170.217/api_koneksi/uploads/paket_1777217835.jpg', '2026-04-26 15:37:15', '0', '2026-04-27 05:50:05', NULL, '2026-04-27 05:50:05', '0', 1, 0),
(29, 'Mark Lee Nct Dream', NULL, 'hdjdhdh', 'bfjfjfjf\nhdjfk', 30, '15000.0000', '', '2026-06-03 10:52:22', NULL, '2026-06-03 10:57:53', NULL, NULL, NULL, 1, 1),
(30, 'Xx', NULL, 'xx', 'cv', 15, '15000.0000', 'http://10.158.228.217/API_KONEKSI/uploads/paket/PKT_1780485019.jpg', '2026-06-03 11:10:19', '1', '2026-06-03 11:11:20', NULL, NULL, NULL, 1, 1),
(31, 'Dd', NULL, 'cfg', 'ffg', 45, '120000.0000', 'paket_1780488350.jpg', '2026-06-03 12:05:50', '1', '2026-06-03 12:07:08', '1', NULL, NULL, 1, 0),
(32, 'Ponyo', 'Art Box', 'Ponyo in the sea, finding love from sea', 'Free to choose Property\nFree digital soft copy\nFree 2 printed Photo', 30, '150000.0000', 'paket_1780680669.jpg', '2026-06-05 15:44:41', '1', '2026-06-08 06:55:05', '1', NULL, NULL, 0, 1),
(33, '4 Cute Cat', 'Art Box', 'cat', 'cat', 15, '160000.0000', 'paket_1780680780.jpg', '2026-06-05 17:33:00', '1', '2026-06-08 06:48:33', '1', '2026-06-08 06:48:33', 'Admin', 1, 1),
(34, 'Kiki and Cats', 'Thematic', 'Life is going on', 'Free to choose property\nFree digital soft copy\nFree 2 printed photo', 15, '55000.0000', 'paket_1780902067.jpg', '2026-06-08 07:01:07', '1', NULL, NULL, NULL, NULL, 0, 1),
(35, 'Mrak Chibi', 'Art Box', 'Mark cute chibi chan piknik', 'Free to choose Background\nFree to choose Property\nFree Digital Soft Copy', 45, '12700.0000', 'paket_1781011554.jpg', '2026-06-09 13:25:54', '1', NULL, NULL, NULL, NULL, 0, 1);

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

--
-- Table structure for table `mst_promo`
--

CREATE TABLE `mst_promo` (
  `promo_id` int NOT NULL,
  `promo_nm` varchar(100) NOT NULL,
  `kode_promo` varchar(50) DEFAULT NULL,
  `tipe_potongan` enum('nominal','persen') DEFAULT 'nominal',
  `potongan_nominal` decimal(16,4) NOT NULL,
  `min_pembelian` decimal(16,4) DEFAULT '0.0000',
  `maks_potongan` decimal(16,4) DEFAULT '0.0000',
  `kuota_promo` int DEFAULT '0',
  `mulai_tgl` date NOT NULL,
  `selesai_tgl` date NOT NULL,
  `mulai_jam` time NOT NULL,
  `selesai_jam` time NOT NULL,
  `wajib_upload_st` tinyint(1) NOT NULL DEFAULT '0',
  `instruksi_syarat` text,
  `total_terpakai` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(50) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` varchar(50) DEFAULT NULL,
  `deleted_st` tinyint(1) DEFAULT '0',
  `active_st` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `mst_promo`
--

INSERT INTO `mst_promo` (`promo_id`, `promo_nm`, `kode_promo`, `tipe_potongan`, `potongan_nominal`, `min_pembelian`, `maks_potongan`, `kuota_promo`, `mulai_tgl`, `selesai_tgl`, `mulai_jam`, `selesai_jam`, `wajib_upload_st`, `instruksi_syarat`, `total_terpakai`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deleted_st`, `active_st`) VALUES
(1, 'dd', NULL, 'nominal', '2121.0000', '0.0000', '0.0000', 0, '2026-04-12', '2026-04-13', '07:00:00', '08:00:00', 1, 'yy', 0, '2026-04-12 13:01:15', NULL, '2026-04-12 14:25:31', NULL, '2026-04-12 14:25:31', NULL, 1, 0),
(2, 'yy', NULL, 'nominal', '2112.0000', '0.0000', '0.0000', 0, '2026-04-12', '2026-04-13', '08:13:00', '06:13:00', 0, '', 0, '2026-04-12 14:13:43', '1', '2026-04-12 14:24:55', NULL, '2026-04-12 14:24:55', NULL, 1, 0),
(3, 'nccn', NULL, 'nominal', '224.0000', '0.0000', '0.0000', 0, '2026-04-12', '2026-04-14', '21:46:00', '21:46:00', 0, '', 0, '2026-04-12 14:46:43', '1', '2026-04-19 14:44:23', '1', '2026-04-19 14:44:23', '1', 1, 0),
(4, 'nct', 'NCT46', 'nominal', '127.0000', '0.0000', '0.0000', 0, '2026-04-19', '2026-04-30', '21:42:00', '21:42:00', 1, 'Ilichil', 0, '2026-04-19 14:43:28', '1', '2026-06-08 07:01:25', '1', '2026-06-08 07:01:25', '1', 1, 0),
(5, 'Dreaming', 'DRM11', 'nominal', '5000.0000', '55000.0000', '0.0000', 0, '2026-06-08', '2026-06-30', '06:00:00', '06:00:00', 1, 'Follo ig koneksi studio', 0, '2026-04-19 14:43:59', '1', '2026-06-08 07:02:41', '1', NULL, NULL, 0, 1),
(6, 'promo weekend', 'weekendseru', 'persen', '20.0000', '100000.0000', '25000.0000', 5, '2026-04-27', '2026-04-30', '09:00:00', '09:00:00', 1, '', 0, '2026-04-27 15:18:39', '0', '2026-04-27 16:39:29', NULL, '2026-04-27 16:39:29', '1', 1, 0),
(7, 'Promo seru', 'PRMSR989', 'nominal', '20000.0000', '10000.0000', '0.0000', 5, '2026-04-27', '2026-06-25', '00:00:00', '00:00:00', 0, '', 0, '2026-04-27 16:30:15', '0', '2026-06-08 07:01:30', '1', '2026-06-08 07:01:30', '1', 1, 1),
(8, 'ramadhan berkah', 'RMDHN', 'persen', '20.0000', '100000.0000', '25000.0000', 5, '2026-04-27', '2026-04-30', '12:30:00', '12:30:00', 1, 'xx', 0, '2026-04-27 16:41:07', '1', '2026-06-03 14:15:31', '1', '2026-06-03 14:15:31', '1', 1, 1),
(9, 'Willow', 'W123', 'persen', '80.0000', '1000000.0000', '0.0000', 5, '2026-06-03', '2026-06-25', '21:12:00', '21:12:00', 0, '', 0, '2026-06-03 14:12:57', '1', '2026-06-08 07:01:26', '1', '2026-06-08 07:01:26', '1', 1, 1),
(10, 'Xxxx', '', 'persen', '10.0000', '25000.0000', '2000.0000', 6, '2026-06-05', '2026-06-05', '21:17:00', '04:17:00', 1, 'yyyy', 0, '2026-06-05 14:17:30', '1', '2026-06-06 08:41:25', NULL, '2026-06-06 08:41:25', '1', 1, 1),
(11, 'Nct 127', 'NCT', 'persen', '50.0000', '100000.0000', '5000.0000', 0, '2026-06-06', '2026-06-10', '09:35:00', '20:35:00', 1, 'ss tt', 0, '2026-06-07 13:35:53', '1', '2026-06-08 07:01:29', '1', '2026-06-08 07:01:29', '1', 1, 1),
(12, 'Wait And See', 'ISEEU', 'persen', '25.0000', '150000.0000', '0.0000', 0, '2026-06-08', '2026-06-30', '06:00:00', '06:00:00', 0, '', 0, '2026-06-08 07:03:30', '1', '2026-06-08 07:03:54', '1', NULL, NULL, 0, 1),
(13, 'Mark', 'M127', 'persen', '27.0000', '150000.0000', '0.0000', 0, '2026-06-09', '2026-06-30', '06:00:00', '06:00:00', 1, 'Follow tiktok koneksi studio', 0, '2026-06-09 13:27:08', '1', NULL, NULL, NULL, NULL, 0, 1),
(14, 'NCT 127', 'N127', 'nominal', '5000.0000', '100000.0000', '5000.0000', 0, '2026-06-10', '2026-06-30', '12:00:00', '12:00:00', 0, '', 0, '2026-06-09 18:41:27', '1', NULL, NULL, NULL, NULL, 0, 1),
(15, 'NCT DREAM', 'NCT', 'nominal', '10000.0000', '100000.0000', '0.0000', 0, '2026-06-10', '2026-06-30', '12:00:00', '12:00:00', 0, '', 0, '2026-06-09 19:02:24', '1', NULL, NULL, NULL, NULL, 0, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `dat_distribusi`
--
ALTER TABLE `dat_distribusi`
  ADD PRIMARY KEY (`distribusi_id`),
  ADD KEY `reservasi_id` (`reservasi_id`);

--
-- Indexes for table `dat_jadwal_tutup`
--
ALTER TABLE `dat_jadwal_tutup`
  ADD PRIMARY KEY (`tutup_id`);

--
-- Indexes for table `dat_notifikasi`
--
ALTER TABLE `dat_notifikasi`
  ADD PRIMARY KEY (`notif_id`),
  ADD KEY `fk_notifikasi_user` (`user_id`);

--
-- Indexes for table `dat_pembayaran`
--
ALTER TABLE `dat_pembayaran`
  ADD PRIMARY KEY (`pembayaran_id`),
  ADD KEY `reservasi_id` (`reservasi_id`),
  ADD KEY `metode_id` (`metode_id`);

--
-- Indexes for table `dat_reservasi`
--
ALTER TABLE `dat_reservasi`
  ADD PRIMARY KEY (`reservasi_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `paket_id` (`paket_id`),
  ADD KEY `promo_id` (`promo_id`);

--
-- Indexes for table `mst_metode_bayar`
--
ALTER TABLE `mst_metode_bayar`
  ADD PRIMARY KEY (`metode_id`);

--
-- Indexes for table `mst_paket`
--
ALTER TABLE `mst_paket`
  ADD PRIMARY KEY (`paket_id`);

--
-- Indexes for table `mst_promo`
--
ALTER TABLE `mst_promo`
  ADD PRIMARY KEY (`promo_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dat_distribusi`
--
ALTER TABLE `dat_distribusi`
  MODIFY `distribusi_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `dat_jadwal_tutup`
--
ALTER TABLE `dat_jadwal_tutup`
  MODIFY `tutup_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dat_notifikasi`
--
ALTER TABLE `dat_notifikasi`
  MODIFY `notif_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `dat_pembayaran`
--
ALTER TABLE `dat_pembayaran`
  MODIFY `pembayaran_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `dat_reservasi`
--
ALTER TABLE `dat_reservasi`
  MODIFY `reservasi_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT for table `mst_metode_bayar`
--
ALTER TABLE `mst_metode_bayar`
  MODIFY `metode_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mst_paket`
--
ALTER TABLE `mst_paket`
  MODIFY `paket_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `mst_promo`
--
ALTER TABLE `mst_promo`
  MODIFY `promo_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `dat_distribusi`
--
ALTER TABLE `dat_distribusi`
  ADD CONSTRAINT `dat_distribusi_ibfk_1` FOREIGN KEY (`reservasi_id`) REFERENCES `dat_reservasi` (`reservasi_id`) ON DELETE CASCADE;

--
-- Constraints for table `dat_notifikasi`
--
ALTER TABLE `dat_notifikasi`
  ADD CONSTRAINT `fk_notifikasi_user` FOREIGN KEY (`user_id`) REFERENCES `mst_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dat_pembayaran`
--
ALTER TABLE `dat_pembayaran`
  ADD CONSTRAINT `dat_pembayaran_ibfk_1` FOREIGN KEY (`reservasi_id`) REFERENCES `dat_reservasi` (`reservasi_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `dat_pembayaran_ibfk_2` FOREIGN KEY (`metode_id`) REFERENCES `mst_metode_bayar` (`metode_id`) ON DELETE RESTRICT;

--
-- Constraints for table `dat_reservasi`
--
ALTER TABLE `dat_reservasi`
  ADD CONSTRAINT `dat_reservasi_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `mst_user` (`user_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `dat_reservasi_ibfk_2` FOREIGN KEY (`paket_id`) REFERENCES `mst_paket` (`paket_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `dat_reservasi_ibfk_3` FOREIGN KEY (`promo_id`) REFERENCES `mst_promo` (`promo_id`) ON DELETE SET NULL;
COMMIT;

