-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 08 Jun 2025 pada 17.08
-- Versi server: 10.4.32-MariaDB
-- Versi PHP: 8.1.25

START TRANSACTION;



--
-- Database: `db_ponpes`
--

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

--
-- Struktur dari tabel `janji`
--

CREATE TABLE `janji` (
  `id` int(11) NOT NULL,
  `wali` varchar(255) NOT NULL,
  `nama_santri` varchar(255) NOT NULL,
  `hubungan` varchar(255) NOT NULL,
  `nik` varchar(255) NOT NULL,
  `nisn_santri` varchar(255) NOT NULL,
  `no_telepon` varchar(20) NOT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `tanggal_janji` date NOT NULL,
  `waktu_janji` time NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `janji`
--

INSERT INTO `janji` (`id`, `wali`, `nama_santri`, `hubungan`, `nik`, `nisn_santri`, `no_telepon`, `foto`, `tanggal_janji`, `waktu_janji`, `created_at`) VALUES
(20, 'Amanuddin Sutoto', 'Fatimah Rusda', 'Anak Kandung', '3578195812060001', '0062522476', '085843949600', NULL, '2025-06-08', '12:21:00', '2025-06-08 05:21:36');

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

--
-- Struktur dari tabel `masuk`
--

CREATE TABLE `masuk` (
  `id` int(11) UNSIGNED NOT NULL,
  `wali` varchar(255) NOT NULL,
  `nama_santri` varchar(255) NOT NULL,
  `hubungan` varchar(100) NOT NULL,
  `nik` varchar(20) NOT NULL,
  `nisn_santri` varchar(20) NOT NULL,
  `no_telepon` varchar(20) NOT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `tanggal_janji` date NOT NULL,
  `waktu_janji` time NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `riwayat_janji`
--

CREATE TABLE `riwayat_janji` (
  `id` int(11) NOT NULL,
  `wali` varchar(255) DEFAULT NULL,
  `nama_santri` varchar(255) DEFAULT NULL,
  `hubungan` varchar(255) DEFAULT NULL,
  `nik` varchar(20) DEFAULT NULL,
  `nisn_santri` varchar(20) DEFAULT NULL,
  `no_telepon` varchar(15) DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `tanggal_janji` date DEFAULT NULL,
  `waktu_janji` time DEFAULT NULL,
  `qr_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `riwayat_janji`
--

INSERT INTO `riwayat_janji` (`id`, `wali`, `nama_santri`, `hubungan`, `nik`, `nisn_santri`, `no_telepon`, `foto`, `tanggal_janji`, `waktu_janji`, `qr_code`, `created_at`) VALUES
(1, 'Eko', 'Riski Ramadhan', 'Orang Tua', '23456789796576345', '235467890798567463', '+6285850236959', '1738824409_3a115cb06393e340d981.jpg', '2025-02-04', '20:15:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAJwUlEQVR4nO3d0Y4duQ0FwDjI//+y87ZAGgvFskhKx1v16nu7e3rmQDBBUT9+/vz5LyDTv28/APD7BBiCCTAEE2AIJsAQTIAhmABDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBi', '2025-02-05 09:58:14'),
(2, 'Yanto', 'Dika', 'Orang Tua', '2345678979657636', '89757464657687567', '+6285850236959', NULL, '2025-02-04', '21:09:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAJpklEQVR4nO3d0Y4ktw0FUG/g//9l5y2AC46yWpGU7uac1+muqunpC2EIivrx119//QFk+tftBwB+nQBDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIAhmAB', '2025-02-05 14:15:52'),
(3, 'Eko', 'Riski Ramadhan', 'Orang Tua', '23456789796576345', '235467890798567463', '086454456668', '1738824409_3a115cb06393e340d981.jpg', '2025-02-05', '21:16:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAJmUlEQVR4nO3dy25sJxAF0DjK///yzSCjixLSGKpgW2uN+zzc9hZyqSi+fv369QeQ6c/bLwB8nwBDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIAhmABDsL+', '2025-02-05 14:24:28'),
(4, 'Yanto', 'Dika', 'Orang Tua', '2345678979657636', '89757464657687567', '086454455537', NULL, '2025-02-05', '21:16:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAJyUlEQVR4nO3d0Y4sOw0FUA7i/3/58gC60ilBIBPbyYa1Xqe7qrpntqKxHOfXH3/88Rcg019vPwDwcwIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIAhmABDMAGGYAI', '2025-02-05 14:24:33'),
(5, 'Eko', 'Riski Ramadhan', 'Orang Tua', '23456789796576345', '235467890798567463', '086454456668', '1738824409_3a115cb06393e340d981.jpg', '2025-02-06', '10:19:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAKVUlEQVR4nO3dy24kOQ4F0PGg/v+Xq3e1CHQLVoqk4pbP2TrjkY8LwQTF+Pr9+/f/gEz/v30DwOcEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIAhmABDMAGGYL8+OObr66v8Pv7VetjA+ja2BhVsnWrr7a+PPZmmcHI', '2025-02-06 03:46:38'),
(6, 'Eko', 'Riski Ramadhan', 'Orang Tua', '23456789796576345', '235467890798567463', '086454456668', '1738824409_3a115cb06393e340d981.jpg', '2025-02-06', '10:47:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAKOklEQVR4nO3d0Y4bOQ4F0M0i///Ls28DTGFa27JIqm76nNe2q8p2LoQQFPXrr7/++g+Q6b+3HwD4nABDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBDs9wfv+fXrV/lz/Kv1sIGTx3hc+XGpvr9uPUafrS9', '2025-02-06 03:50:32'),
(7, 'Yanto', 'Dika', 'Orang Tua', '2345678979657636', '89757464657687567', '086454455537', '1738663950_90a447da5056e902f389.jpg', '2025-02-06', '10:47:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAKa0lEQVR4nO3d225jOQ4F0Mmg//+Xq98C9EFFsCxS0o7Xei2fS5xsCEVQ1NefP3/+B2T6/+kXAN4nwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIAhmABDMAGGYAIMwQQYggkwBPvnjWu+vr7K3+OvpoYNjN/qcaupD2+z8laFP/7Y+FY', '2025-02-06 03:53:56'),
(8, 'Rusman Hadi', 'Habibah Idana Zulfa', 'Anak Kandung', '3576024308060002', '0073769799', '085649427828', '1738824409_3a115cb06393e340d981.jpg', '2025-02-26', '13:13:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAK7UlEQVR4nO3dwY4dKRIF0PGo//+X3Yve5GiEBEUEcN3nLK18mVmv6gqFgeDX79+//wNk+u/tFwB+ToAhmABDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIA', '2025-05-17 11:58:57'),
(9, 'Abdul Ghonim', 'Salsabila Qoirun Nisa', 'Anak Kandung', '6103016811070004', '0072990361', '08125724935', '1738663950_90a447da5056e902f389.jpg', '2025-05-17', '18:57:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAK2ElEQVR4nO3d224kKxIF0PHo/P8ve15LOmIERQSwu9d6bGVlpsu9hcLB5ef39/c/QKb/3n4B4HsCDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIAhmABDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDME', '2025-05-17 11:59:14'),
(10, 'Abdul Ghonim', 'Salsabila Qoirun Nisa', 'Anak Kandung', '6103016811070004', '0072990361', '08125724935', '1738663950_90a447da5056e902f389.jpg', '2025-05-17', '19:09:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAALHElEQVR4nO3dy3IluW4FULfD///L5emZ8JosAEnu9lrDihRPSqodDAh8/PPnz5//AjL99+0XAP6eAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIAhmABDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEM', '2025-05-18 17:08:07'),
(11, 'Rusman Hadi', 'Habibah Idana Zulfa', 'Anak Kandung', '3576024308060002', '0073769799', '085649427828', '1738824409_3a115cb06393e340d981.jpg', '2025-05-17', '19:09:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAK30lEQVR4nO3dwY4dKRIF0PGo//+XPYvepNRiBBUEcN3nLK18mVnlukLxgODX79+//wNk+u/tFwB+ToAhmABDMAGGYAIMwQQYggkwBBNgCCbAEEyAIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AIJsAQTIA', '2025-05-18 17:08:44'),
(12, 'Maslikah', 'Aprilia Chandro Dwi Maulidya', 'Anak Kandung', '3523035509070001', '0073856694', '085231959130', NULL, '2025-05-17', '19:10:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAKa0lEQVR4nO3d0W7kOA4F0M1i/v+Xe98aaGNaG1mkpJs65zUp21WVCyEERX39+vXrP0Cm/55+AOA9AYZgAgzBBBiCCTAEE2AIJsAQTIAhmABDMAGGYAIMwQQYggkwBBNgCCbAEEyAIdg/L17z9fVV/hz/ajxs4PEYj18e/3Rs6rXjT2PbvIS', '2025-05-18 17:08:58'),
(13, 'Maslikah', 'Aprilia Chandro Dwi Maulidya', 'Anak Kandung', '3523035509070001', '0073856694', '085231959130', NULL, '2025-05-18', '00:09:00', 'iVBORw0KGgoAAAANSUhEUgAAAUAAAAFACAIAAABC8jL9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAKh0lEQVR4nO3d0W7kNgwF0Kbo///y9i1AjY1aWaSk2znnNTO2Z5ILIYRIff369esPINOfpx8AeE+AIZgAQzABhmACDMEEGIIJMAQTYAgmwBBMgCGYAEMwAYZgAgzBBBiCCTAEE2AI9teL93x9fZU/x2+Nhw08HuPx4vFPx6beO/42ts1LWHm', '2025-05-18 17:09:25');

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

--
-- Struktur dari tabel `riwayat_masuk`
--

CREATE TABLE `riwayat_masuk` (
  `id` int(11) NOT NULL,
  `wali` varchar(255) NOT NULL,
  `nama_santri` varchar(255) NOT NULL,
  `hubungan` varchar(100) NOT NULL,
  `nik` varchar(50) NOT NULL,
  `nisn_santri` varchar(50) NOT NULL,
  `no_telepon` varchar(20) NOT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `tanggal_janji` date NOT NULL,
  `waktu_janji` time NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` varchar(255) DEFAULT 'Selesai Bertamu'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `riwayat_masuk`
--

INSERT INTO `riwayat_masuk` (`id`, `wali`, `nama_santri`, `hubungan`, `nik`, `nisn_santri`, `no_telepon`, `foto`, `tanggal_janji`, `waktu_janji`, `created_at`, `updated_at`, `status`) VALUES
(11, 'Eko', 'Riski Ramadhan', 'Orang Tua', '23456789796576345', '235467890798567463', '086454456668', '1738824409_3a115cb06393e340d981.jpg', '2025-02-06', '10:19:00', '2025-02-05 22:09:30', '2025-02-05 23:46:49', 'Selesai Bertamu'),
(12, 'Abdul Ghonim', 'Salsabila Qoirun Nisa', 'Anak Kandung', '6103016811070004', '0072990361', '08125724935', '1738663950_90a447da5056e902f389.jpg', '2025-05-17', '18:57:00', '2025-05-17 05:02:54', '2025-05-17 05:02:54', 'Selesai Bertamu'),
(17, 'Abdul Ghonim', 'Salsabila Qoirun Nisa', 'Anak Kandung', '6103016811070004', '0072990361', '08125724935', '1738663950_90a447da5056e902f389.jpg', '2025-05-17', '18:57:00', '2025-05-17 05:03:29', '2025-05-17 05:03:29', 'Selesai Bertamu');

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

--
-- Struktur dari tabel `santri`
--

CREATE TABLE `santri` (
  `id` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nisn` varchar(20) NOT NULL,
  `tempat_lahir` varchar(100) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `jenis_kelamin` enum('Laki-laki','Perempuan') NOT NULL,
  `alamat` text NOT NULL,
  `asal_domisili` varchar(100) NOT NULL,
  `nama_wali` varchar(100) NOT NULL,
  `nomor_wali` varchar(15) NOT NULL,
  `pendidikan_terakhir` varchar(50) NOT NULL,
  `hobi` varchar(100) NOT NULL,
  `cita_cita` varchar(100) NOT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `santri`
--

INSERT INTO `santri` (`id`, `nama`, `nisn`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `alamat`, `asal_domisili`, `nama_wali`, `nomor_wali`, `pendidikan_terakhir`, `hobi`, `cita_cita`, `foto`, `created_at`, `updated_at`) VALUES
(1, 'Habibah Idana Zulfa', '0073769799', 'Mojokerto', '2006-08-03', 'Perempuan', 'Bancang, Wates, Magersari, Mojokerto', 'Mojokerto', 'Rusman Hadi', '085649427828', 'SMA', 'Membaca', 'Guru', '1738612323_d75eb6369854e03e88fd.jpg', '2025-02-03 19:52:03', '2025-02-20 05:56:30'),
(3, 'Salsabila Qoirun Nisa', '0072990361', 'Sanggau', '2007-11-18', 'Perempuan', 'Beringin, Kapuas, Sanggau, Kalimantan Barat', 'Sanggau Kalimantan Barat', 'Abdul Ghonim', '08125724935', 'SMA', 'Berenang', 'Atlet', '1738650045_d4d39aeabd6e80175c40.jpg', '2025-02-04 06:20:45', '2025-02-20 06:03:30'),
(4, 'Aprilia Chandro Dwi Maulidya', '0073856694', 'Tuban', '2007-04-15', 'Perempuan', 'Lengkong, Nganjuk', 'Tuban', 'Maslikah', '085231959130', 'Diploma 4', 'Membaca', 'Akuntan', NULL, '2025-02-20 06:10:12', '2025-02-20 06:10:12'),
(5, 'Fatimah Rusda', '0062522476', 'Gresik', '2006-12-18', 'Perempuan', 'jl. Romokalisari, Benowo, Surabaya', 'Surabaya', 'Amanuddin Sutoto', '085843949600', 'SMA', 'Listening Music', 'Bussines Woman', NULL, '2025-06-08 05:18:54', '2025-06-08 05:18:54'),
(6, 'Fithrica Sayyidatul Hamidah', '0074049283', 'Jombang', '2007-05-30', 'Perempuan', 'Megaluh Jombang', 'Jombang', 'Megaluh Jombang', '082142950189', 'SMA', 'Memasak', 'Memasak', NULL, '2025-06-08 14:40:45', '2025-06-08 14:40:45'),
(7, 'Ainun Nurlatifah', '0088424578', 'Grobogan', '2008-04-11', 'Perempuan', 'RT.03 RW.01 Plandirejo, kec. Plumpang. Jawa Timur', 'Tuban', 'Darmaji', '081026073177', 'SMA', 'Berenang', 'Menteri Keuangan', NULL, '2025-06-08 14:44:20', '2025-06-08 14:44:20'),
(8, 'Ayesha Farzana Parsa', '0074162153', 'Jombang', '2007-06-21', 'Perempuan', 'Dsn. Semanding Ds. Sumbermulyo, Jogoroto, Jambang', 'Jogoroto, Jombang', 'M. HARIS YUMUS', '085851884352', 'SMA', 'Menulis', 'Psikolog', NULL, '2025-06-08 14:47:48', '2025-06-08 14:47:48'),
(10, 'LATIFATUZ ZAHRO', '00737697999', 'Batu Raja', '2007-09-25', 'Perempuan', 'Sumatera Selatan', 'Sumatera Selatan', 'Mhammad Antoni', '082380526959', 'SMA', 'Melukis', 'Sastrawan', NULL, '2025-06-08 14:54:20', '2025-06-08 14:54:20'),
(11, 'Hanania Amiratuz Zahwan', '0063529426', 'Mojokerto', '2006-07-25', 'Perempuan', 'Dsn. Klampisan Ds. medali Kec, puri Kab, Mojokerto', 'Mojokerto', 'SUNAROI', '082142004045', 'SMA', 'Bernyanyi', 'Penyanyi', NULL, '2025-06-08 14:58:57', '2025-06-08 14:58:57'),
(12, 'FAIRUZ NUR ADIIBAH', '0072904296', 'Sidoarjo', '2007-01-02', 'Perempuan', 'Sidoarjo Sukodono', 'Sukodono', 'BADRUL KAMAL', '087852216971', 'SMA', 'Listening Music', 'Guru', NULL, '2025-06-08 15:01:33', '2025-06-08 15:01:33'),
(13, 'SHILVYKA', '00696912313', 'Bangkalan', '2006-02-07', 'Perempuan', 'Dsn. Majungan Ds. Baipajung Kec. Tanah Merah Kab. Bangkalan', 'Bangkalan', 'Choirul Anam', '087899900848', 'SMA', 'Menari', 'Penari', NULL, '2025-06-08 15:04:02', '2025-06-08 15:04:02');

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

--
-- Struktur dari tabel `wali`
--

CREATE TABLE `wali` (
  `id` int(11) NOT NULL,
  `nama_wali` varchar(100) NOT NULL,
  `nik` varchar(20) NOT NULL,
  `alamat` text NOT NULL,
  `no_telepon` varchar(15) NOT NULL,
  `pekerjaan` varchar(50) NOT NULL,
  `hubungan` varchar(50) NOT NULL,
  `nama_santri` varchar(100) NOT NULL,
  `nisn_santri` varchar(20) NOT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `wali`
--

INSERT INTO `wali` (`id`, `nama_wali`, `nik`, `alamat`, `no_telepon`, `pekerjaan`, `hubungan`, `nama_santri`, `nisn_santri`, `foto`, `created_at`, `updated_at`) VALUES
(1, 'Rusman Hadi', '3576024308060002', 'Bancang, Wates, Magersari, Mojokerto', '085649427828', 'Wiraswasta', 'Anak Kandung', 'Habibah Idana Zulfa', '0073769799', '1738824409_3a115cb06393e340d981.jpg', '2025-02-04 09:04:21', '2025-02-20 05:59:16'),
(4, 'Abdul Ghonim', '6103016811070004', 'Beringin, Kapuas, Sanggau, Kalimantan Barat', '08125724935', 'Wiraswasta', 'Anak Kandung', 'Salsabila Qoirun Nisa', '0072990361', '1738663950_90a447da5056e902f389.jpg', '2025-02-04 10:12:30', '2025-02-20 06:05:35'),
(5, 'Maslikah', '3523035509070001', 'Lengkong, Nganjuk', '085231959130', 'Wiraswasta', 'Anak Kandung', 'Aprilia Chandro Dwi Maulidya', '0073856694', NULL, '2025-02-20 06:16:16', '2025-02-20 06:16:16'),
(6, 'Amanuddin Sutoto', '3578195812060001', 'jl. Romokalisari, Benowo, Surabaya', '085843949600', 'Pegawai Swasta', 'Anak Kandung', 'Fatimah Rusda', '0062522476', NULL, '2025-06-08 05:21:17', '2025-06-08 05:21:17'),
(7, 'Sugi Mulyono', '35172051407070002', 'Megaluh Jombang', '082142950189', 'Pedagang', 'Anak Kandung', 'Fithrica Sayyidatul Hamidah', '0074049283', NULL, '2025-06-08 14:42:11', '2025-06-08 14:42:11'),
(8, 'Darmaji', '3315064601080004', 'RT.03 RW.01 Plandirejo, kec. Plumpang. Jawa Timur', '081026073177', 'Swasta', 'Anak Kandung', 'Ainun Nurlatifah', '0088424578', NULL, '2025-06-08 14:45:40', '2025-06-08 14:45:40'),
(9, 'M. HARIS YUMUS', '351719610607000', 'Dsn. Semanding Ds. Sumbermulyo, Jogoroto, Jambang', '085851884352', 'Guru PNS', 'Anak Kandung', 'Ayesha Farzana Parsa', '0074162153', NULL, '2025-06-08 14:50:00', '2025-06-08 14:50:00'),
(10, 'Mhammad Antoni', '1601296509070002', '1601296509070002', '082380526959', '082380526959', 'Anak Kandung', 'LATIFATUZ ZAHRO', '00737697999', NULL, '2025-06-08 14:55:33', '2025-06-08 14:55:33'),
(11, 'SUNAROI', '3516116507060003', 'Dsn. Klampisan Ds. medali Kec, puri Kab, Mojokerto', '082142004045', 'Wiraswasta', 'Anak Kandung', 'Hanania Amiratuz Zahwan', '0063529426', NULL, '2025-06-08 14:59:58', '2025-06-08 14:59:58'),
(12, 'BADRUL KAMAL', '3515144201070002', 'Sidoarjo Sukodono', '087852216971', 'Swasta', 'Anak Kandung', 'FAIRUZ NUR ADIIBAH', '0072904296', NULL, '2025-06-08 15:02:31', '2025-06-08 15:02:31'),
(13, 'Choirul Anam', '087899900848', 'Dsn. Majungan Ds. Baipajung Kec. Tanah Merah Kab. Bangkalan', '087899900848', 'Wiraswasta', 'Anak Kandung', 'SHILVYKA', '00696912313', NULL, '2025-06-08 15:05:00', '2025-06-08 15:05:00');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `janji`
--
ALTER TABLE `janji`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nik` (`nik`);

--
-- Indeks untuk tabel `masuk`
--
ALTER TABLE `masuk`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nik` (`nik`);

--
-- Indeks untuk tabel `riwayat_janji`
--
ALTER TABLE `riwayat_janji`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nik` (`nik`);

--
-- Indeks untuk tabel `riwayat_masuk`
--
ALTER TABLE `riwayat_masuk`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `santri`
--
ALTER TABLE `santri`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nisn` (`nisn`),
  ADD UNIQUE KEY `nama_wali` (`nama_wali`);

--
-- Indeks untuk tabel `wali`
--
ALTER TABLE `wali`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nik` (`nik`),
  ADD UNIQUE KEY `nisn_santri` (`nisn_santri`),
  ADD UNIQUE KEY `nama_wali` (`nama_wali`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `janji`
--
ALTER TABLE `janji`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT untuk tabel `masuk`
--
ALTER TABLE `masuk`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `riwayat_janji`
--
ALTER TABLE `riwayat_janji`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `riwayat_masuk`
--
ALTER TABLE `riwayat_masuk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT untuk tabel `santri`
--
ALTER TABLE `santri`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `wali`
--
ALTER TABLE `wali`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

