-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 11, 2026 at 02:37 PM -- Server version: 8.0.30 -- PHP Version: 8.1.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 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); -- -------------------------------------------------------- -- -- Table structure for table `mst_user` -- CREATE TABLE `mst_user` ( `user_id` int NOT NULL, `lengkap_nm` varchar(100) NOT NULL, `whatsapp_no` varchar(20) NOT NULL, `email_tx` varchar(50) NOT NULL, `password_tx` varchar(255) NOT NULL, `role_nm` enum('Admin','Pelanggan') NOT 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_user` -- INSERT INTO `mst_user` (`user_id`, `lengkap_nm`, `whatsapp_no`, `email_tx`, `password_tx`, `role_nm`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deleted_st`, `active_st`) VALUES (1, 'Admin Koneksi Sleman', '08123456788', 'admin@koneksi.com', 'a123', 'Admin', '2026-04-08 18:50:59', NULL, '2026-04-21 09:16:40', '1', NULL, NULL, 0, 1), (2, 'mark', '082212345678', 'mark@gmail.com', 'm123', 'Pelanggan', '2026-04-24 13:19:15', NULL, NULL, NULL, NULL, NULL, 0, 1), (3, 'mark lee ceo', '111111111111', 'markl@gmail.com', '$2y$10$a5Dz8pvz8NHxlUPdaD2FdeAwgmdqqk/rymD6qZZor1GFm1kqzVxPm', 'Pelanggan', '2026-06-03 04:34:48', NULL, '2026-06-08 06:16:52', NULL, NULL, NULL, 0, 1), (4, 'jaemin na', '1111111111', 'jaemin@gmail.com', '$2y$10$yMnF8w1EvEHIbor4BI/x9.9exPiCKbww2qVpPYURnoNiyr5PaHYkG', 'Pelanggan', '2026-06-05 04:08:33', NULL, '2026-06-09 19:05:58', NULL, NULL, NULL, 0, 1), (5, 'Haechan Chan', '82239221588', 'haechan@gmail.com', '922ae286d497ffc60de31b2e89ecc676', 'Pelanggan', '2026-06-09 18:34:56', NULL, '2026-06-09 18:36:39', 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`); -- -- Indexes for table `mst_user` -- ALTER TABLE `mst_user` ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `email_tx` (`email_tx`); -- -- 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; -- -- AUTO_INCREMENT for table `mst_user` -- ALTER TABLE `mst_user` MODIFY `user_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;