May 30, 2022 at 12:29 AM
INSERT INTO `siswa` (`id`, `nama`, `username`, `password`, `aktif`, `nis`, `nisn`, `nik`, `tempat_lahir`, `tanggal_lahir`, `jk`, `agama_id`, `agama_str`, `no_kk`, `alamat`, `kelurahan`, `kecamatan`, `kota_kab`, `kode_pos`, `jenis_tinggal`, `telepon`, `handphone`, `email`, `lintang`, `bujur`, `ayah_nama`, `ayah_tempat_lahir`, `ayah_tanggal_lahir`, `ayah_pekerjaan`, `ayah_pendapatan`, `ayah_nik`, `ibu_nama`, `ibu_tempat_lahir`, `ibu_tanggal_lahir`, `ibu_pekerjaan`, `ibu_pendapatan`, `ibu_nik`, `wali_nama`, `wali_tempat_lahir`, `wali_tanggal_lahir`, `wali_pekerjaan`, `wali_pendapatan`, `wali_nik`, `asal_sekolah`, `asal_alamat_sekolah`, `jenis_masuk`, `status_aktif`, `tahun_id`, `tanggal_masuk`, `no_un_smp`, `no_ijazah`, `no_skhun`, `file_kk`, `file_akte`, `file_skhun`, `file_ijazah`, `log_data_diri`, `log_orang_tua`, `log_pendidikan`, `log_tempat_tinggal`, `log_created`, `log_updated`) VALUES
SampleSpoiler
(530, 'LUNA', '17751', '$2y$10$i9RC9p20PfKYLcoIuu4ipeTuHlsiUBstqIAeyCynhj1rSvHBtYdEy', 1, '17751', '0033216221', '3175076304030004', 'Pekalongan', '2003-04-23', 'P', '56', NULL, '3375022203110006', 'Jl. H. Agus Salim Gg. Poncol VII No. 16 RT.2 RW.2 ', 'Poncol', 'Kec. Pekalongan Timur', '', '51122', 'Bersama orang tua', '', '081903686166', '[email protected]', '', '', 'Nadim Abdul Kadir Syawie', 'Pekalongan, Jawa Tengah, Indonesia', '1970-04-21', 'Karyawan Swasta', 0, '', 'Majedah', 'Pekalongan, Jawa Tengah, Indonesia', '1984-05-30', 'Ibu Rumah Tangga', 0, '', '', '', '1970-04-21', '', 0, '', 'SMP N 2 Pekalongan', 'Jl. Cendrawasih No.11, Pekalongan', 'B', NULL, 20181, '2018-07-16', '2-18-03-04-002-137-8', 'DN-Dp/13 0521524', 'DN-03 D 0040977', '{\"name\": \"kartu_keluarga_530.jpg\", \"size\": 245743, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_530.jpg\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_530.jpg\"}', '{\"name\": \"akte_kelahiran_530.jpg\", \"size\": 600572, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_530.jpg\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_530.jpg\"}', '{\"name\": \"skhun_530.jpg\", \"size\": 693330, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_530.jpg\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_530.jpg\"}', '{\"name\": \"ijazah_530.jpg\", \"size\": 817564, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_530.jpg\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_530.jpg\"}', '2021-01-12 16:28:23', '2021-01-15 18:10:54', '2021-01-15 18:09:37', NULL, '', '{\"agent\":\"Chrome 87.0.4280.141\",\"ip_address\":\"36.68.55.54\",\"platform\":\"Android\",\"waktu\":\"2021-01-15 18:07:03\",\"id_user\":\"530\",\"nama\":\"LUNA\",\"username\":\"17751\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 10; vivo 1935) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Mobile Safari\\/537.36\",\"log_login\":null}'),
(531, 'M. GYAN HENDRIANSYAH', '17580', '$2y$10$crOpQQ8EzhLPqveZTlPc.uX6vTz0L9cV6Crw1IyNqt8afcX0jDzmi', 1, '17580', '0026697997', '3375022912020003', 'Pekalongan', '2002-12-29', 'L', 'Islam', NULL, '3375021010180002', 'Jl. Ki Mangun Sarkoro No 14 Setono RT.5 RW.1 Dekoro', 'Setono', 'Kec. Pekalongan Timur', '', '51123', 'Bersama orang tua', '', '085869407056', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{\"name\": \"kartu_keluarga_531.jpg\", \"size\": 511159, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_531.jpg\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_531.jpg\"}', '{\"name\": \"akte_kelahiran_531.jpg\", \"size\": 211947, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_531.jpg\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_531.jpg\"}', '{\"name\": \"skhun_531.jpg\", \"size\": 260067, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_531.jpg\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_531.jpg\"}', '{\"name\": \"ijazah_531.jpg\", \"size\": 311545, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_531.jpg\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_531.jpg\"}', NULL, NULL, NULL, NULL, '', '{\"agent\":\"Chrome 80.0.3987.149\",\"ip_address\":\"112.215.153.128\",\"platform\":\"Android\",\"waktu\":\"2021-04-21 13:05:12\",\"id_user\":\"531\",\"nama\":\"M. GYAN HENDRIANSYAH\",\"username\":\"17580\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 8.0.0; ASUS_X00RD) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/80.0.3987.149 Mobile Safari\\/537.36\",\"log_login\":null}'),
(532, 'Moh.Fajrul Falah', '17654', '$2y$10$0r2jZhbwLNDU.HLTC0DXBuo3AtHheRuBCzjhTR5ZH0bGhxZPnqKLW', 1, '17654', '0026843192', '3326160401020002', 'Pekalongan', '2002-01-04', 'L', '56', NULL, '3326161001110156', 'Kauman RT.8 RW.4 Kauman', 'Kauman', 'Kec. Wiradesa', '', '51152', '', '', '087721558347', '', '', '', 'Ghufron Faza', 'Pekalongan', '1966-06-28', 'Buruh bangunan', 1680000, '2236162806660002', '', '', '0000-00-00', '', 0, '', 'Moh. Fathurrohman', 'Pekalongan', '2000-10-29', 'Wiraswasta', 1200000, '2236162910000002', 'SMA N 1 PEKALONGAN', 'Jl. RA. Kartini No 39 Pekalongan', 'B', NULL, 20181, '0000-00-00', '2-18-03-33-037-091-6', '0583924', '0477575', '{\"name\": \"kartu_keluarga_532.pdf\", \"size\": 312502, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_532.pdf\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_532.pdf\"}', '{\"name\": \"akte_kelahiran_532.pdf\", \"size\": 220947, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_532.pdf\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_532.pdf\"}', '{\"name\": \"skhun_532.pdf\", \"size\": 342770, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_532.pdf\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_532.pdf\"}', '{\"name\": \"ijazah_532.pdf\", \"size\": 322318, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_532.pdf\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_532.pdf\"}', '2021-04-22 15:11:16', '2021-04-22 15:22:08', '2021-04-22 15:41:30', NULL, '', '{\"agent\":\"Chrome 87.0.4280.141\",\"ip_address\":\"112.215.241.191\",\"platform\":\"Android\",\"waktu\":\"2021-04-24 07:50:06\",\"id_user\":\"532\",\"nama\":\"Moh.Fajrul Falah\",\"username\":\"17654\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 10; RMX1851) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Mobile Safari\\/537.36\",\"log_login\":null}'),
(533, 'Muhammad Dwiko Rizqi', '17722', '$2y$10$MLloZTvXjz0TfJYNdniO3.C8FyK6d16PpZ9nOVIroE2XMTYQI81uu', 1, '17722', '0039380585', '3375010805030002', 'Pekalongan', '2003-05-08', 'L', '56', NULL, '3375010408070011', 'Jl. Hayam Wuruk Pesindon III/10 RT.1 RW.13 ', 'Bendan kergon', 'Kec. Pekalongan Barat', '', '51119', 'Bersama orang tua', '', '085641451309', '[email protected]', '', '', 'Kusbandi', 'Pekalongan', '1965-06-30', 'Buruh Harian Lepas', 1500000, '3375013006650005', 'Nur Rizkiyah', 'Pekalongan', '1970-04-14', 'Ibu Rumah Tangga', 0, '3375015404700003', '', '', '1970-04-14', '', 0, '', 'SMP Negeri 6 Pekalongan', 'Jl. Ra. Kartini No.36, Keputran, Kec. Pekalongan Timur, Pekalongan', 'B', NULL, 20181, '2018-07-16', '2-18-03-04-006-018-7', 'DN-Dp/13 0521621', 'DN-03-D 0041560', '{\"name\": \"kartu_keluarga_533.pdf\", \"size\": 989721, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_533.pdf\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_533.pdf\"}', '{\"name\": \"akte_kelahiran_533.pdf\", \"size\": 913493, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_533.pdf\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_533.pdf\"}', '{\"name\": \"skhun_533.pdf\", \"size\": 1035626, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_533.pdf\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_533.pdf\"}', '{\"name\": \"ijazah_533.pdf\", \"size\": 1079802, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_533.pdf\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_533.pdf\"}', '2021-01-14 22:04:15', '2021-01-19 11:33:41', '2021-01-14 21:27:53', NULL, '', '{\"agent\":\"Chrome 87.0.4280.141\",\"ip_address\":\"36.68.55.168\",\"platform\":\"Windows 10\",\"waktu\":\"2021-01-14 21:12:52\",\"id_user\":\"533\",\"nama\":\"Muhammad Dwiko Rizqi\",\"username\":\"17722\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Safari\\/537.36\",\"log_login\":null}'),
(534, 'MUHAMMAD IZZULFAHMI ROBBANI', '17585', '$2y$10$cUO3lBb0sYH/LBRWyYe6puaqWC//xYpbORyFPi48itw2Mx0XicTYi', 1, '17585', '0031667664', '3326132502030021', 'Pekalongan', '2003-02-25', 'L', '56', NULL, '3375042808170011', 'Perumahan Puri Kencana Asri Blok B-8, Kripan Lor, kecamatan Pekalongan Selatan RT.3 RW.3 ', 'Kuripan Yosorejo', 'Kec. Pekalongan Selatan', '', '51137', 'Bersama orang tua', '0285-4482069', '085717241972', '[email protected]', '', '', 'Bambang Sungkowo', 'Pekalongan', '0001-01-01', 'PNS', 0, '3326132912650001', 'Heni Ariani', 'Pekalongan', '0001-01-01', '-', 0, '3326135812710021', '-', '-', '0000-00-00', '', 0, '', 'SMP N 2 PEKALONGAN', 'Jalan Cendrawasih No. 11 Pekalongan', 'B', NULL, 20181, '2018-07-16', '2-18-03-04-002-079-2', 'DN-Dp/13 0521466', 'DN-03 D 0040919', '{\"name\": \"kartu_keluarga_534.pdf\", \"size\": 270267, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_534.pdf\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_534.pdf\"}', '{\"name\": \"akte_kelahiran_534.pdf\", \"size\": 165790, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_534.pdf\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_534.pdf\"}', '{\"name\": \"skhun_534.pdf\", \"size\": 346880, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_534.pdf\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_534.pdf\"}', '{\"name\": \"ijazah_534.pdf\", \"size\": 510227, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_534.pdf\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_534.pdf\"}', '2021-01-12 20:37:23', '2021-01-12 20:44:08', '2021-01-12 20:44:36', NULL, '', '{\"agent\":\"Chrome 87.0.4280.141\",\"ip_address\":\"114.5.105.93\",\"platform\":\"Windows 8.1\",\"waktu\":\"2021-01-14 14:32:35\",\"id_user\":\"534\",\"nama\":\"MUHAMMAD IZZULFAHMI ROBBANI\",\"username\":\"17585\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Windows NT 6.3; WOW64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Safari\\/537.36\",\"log_login\":null}'),
(535, 'NABILA INTAN SARI', '17842', '$2y$10$cOEiwmb.icOvoHGdbVU6H.wjIXtrNBfnf5V2sX6q3WWCXVCCrXJr2', 1, '17842', '0027988149', '3325115805020004', 'KABUPATEN BATANG', '2002-05-18', 'P', 'Islam', NULL, '3325110711160008', 'Dukuh Kebonan RT.4 RW.2 Kebonan', 'Proyonanggan Utara', 'Kec. Batang', '', '51211', 'Bersama orang tua', '', '', '', '', '', 'Sumantri(alm)', 'Batang', '1973-04-06', '-', 0, '-', 'Karyumi', 'Batang', '1973-04-06', 'Wiraswasta', 0, '3325114604730004', '', '', '1973-04-06', '', 0, '', 'SMPN 3 BATANG', 'Jalan Ki Mangunsarkoro No.3 Proyonanggan Selatan Batang', 'P', NULL, 20192, '2019-07-15', '2-17-03-31-033-057-8', 'DN-03 DI/13 0044663', 'DN-03 D 0437570', '{\"name\": \"kartu_keluarga_535.jpg\", \"size\": 433495, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_535.jpg\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_535.jpg\"}', '{\"name\": \"akte_kelahiran_535.pdf\", \"size\": 1014289, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_535.pdf\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_535.pdf\"}', '{\"name\": \"skhun_535.jpg\", \"size\": 1105625, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_535.jpg\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_535.jpg\"}', '{\"name\": \"ijazah_535.jpg\", \"size\": 974087, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_535.jpg\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_535.jpg\"}', NULL, '2021-01-14 21:37:05', '2021-01-14 21:25:16', NULL, '', '{\"agent\":\"Chrome 87.0.4280.141\",\"ip_address\":\"36.72.251.132\",\"platform\":\"Windows 8.1\",\"waktu\":\"2021-01-15 20:00:10\",\"id_user\":\"535\",\"nama\":\"NABILA INTAN SARI\",\"username\":\"17842\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Safari\\/537.36 Edg\\/87.0.664.75\",\"log_login\":null}'),
(536, 'NADIA TUTANIA', '17550', '$2y$10$aWfhDLB7emzjkMxIcRDbK.Ht1NLvILQsMJz7RkLic7isPcR.AsdTS', 1, '17550', '0033233758', '3375045712030001', 'Kota Pekalongan', '2003-12-17', 'P', '56', NULL, '3375042102110006', 'Kandang Panjang Gg. 1 No. 10 RT.5 RW.3 ', 'Kandang Panjang', 'Kec. Pekalongan Utara', '', '51142', 'Bersama orang tua', '', '085655701107', '[email protected]', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SMPN 02 PEKALONGAN', 'Jl. Cendrawasih no 11', 'B', NULL, 20181, '2018-07-16', '2-18-03-04-002-180-5', 'DN-Dp/13 0521567', 'DN-03 D 0041020', '{\"name\": \"kartu_keluarga_536.pdf\", \"size\": 1887155, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_536.pdf\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_536.pdf\"}', '{\"name\": \"akte_kelahiran_536.pdf\", \"size\": 839000, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_536.pdf\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_536.pdf\"}', '{\"name\": \"skhun_536.pdf\", \"size\": 716120, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_536.pdf\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_536.pdf\"}', '{\"name\": \"ijazah_536.pdf\", \"size\": 751455, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_536.pdf\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_536.pdf\"}', '2021-05-22 13:51:47', NULL, '2021-01-15 16:23:01', NULL, '', '{\"agent\":\"Chrome 83.0.4103.106\",\"ip_address\":\"114.5.221.48\",\"platform\":\"Android\",\"waktu\":\"2021-01-15 16:37:11\",\"id_user\":\"536\",\"nama\":\"NADIA TUTANIA\",\"username\":\"17550\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 10; SM-A217F) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/83.0.4103.106 Mobile Safari\\/537.36\",\"log_login\":null}'),
(537, 'Najwa Tiara Djunaedy Putri', '17690', '$2y$10$Q8FkUI0N9gi7ESvzvXbuY.YA1eQQEL6p4fgn15HWdOf26cmrWCxYC', 1, '17690', '0033252783', '3326157006030021', 'Kota Pekalongan', '2003-06-30', 'P', '56', NULL, '3326150602070013', 'Jl. Melati No. 31 Graha Tirto Asri RT.9 RW.4 ', 'Tanjung', 'Kec. Tirto', '', '51151', 'Bersama orang tua', '', '087801316376', '[email protected]', '', '', 'Ade Djunaedy Soleh', 'Sengkang', '1971-06-08', 'Wiraswasta', 3000000, '3326150806710021', 'Lily Herdyantie', 'Semarang', '1976-03-03', 'Ibu rumah tangga', 0, '3326154303760021', '', '', '0000-00-00', '', 0, '', 'SMA Negeri 1 Pekalongan', 'Jl. RA Kartini No. 39, Kota Pekalongan', 'B', NULL, 20181, '2018-07-16', '2-18-03-04-001-019-6', 'DN-Dp/13 0521185', 'DN-03 D 0040638', '{\"name\": \"kartu_keluarga_537.pdf\", \"size\": 488885, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_537.pdf\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_537.pdf\"}', '{\"name\": \"akte_kelahiran_537.pdf\", \"size\": 524161, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_537.pdf\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_537.pdf\"}', '{\"name\": \"skhun_537.pdf\", \"size\": 511999, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_537.pdf\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_537.pdf\"}', '{\"name\": \"ijazah_537.pdf\", \"size\": 478383, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_537.pdf\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_537.pdf\"}', '2021-01-25 10:11:29', '2021-01-25 10:16:11', '2021-01-25 10:13:00', NULL, '', '{\"agent\":\"Chrome 81.0.4044.138\",\"ip_address\":\"120.188.82.119\",\"platform\":\"Android\",\"waktu\":\"2021-01-27 11:29:44\",\"id_user\":\"537\",\"nama\":\"Najwa Tiara Djunaedy Putri\",\"username\":\"17690\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 9; SM-A107F) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/81.0.4044.138 Mobile Safari\\/537.36\",\"log_login\":null}'),
(538, 'Nico Satria Prakosa', '17623', '$2y$10$Emeac.zLVTDUDCyagN.J1OT9RUFEDLsFVUIyiUvM0saGbw4NG/kNS', 1, '17623', '0037948471', '3325110901030005', 'Pekalongan', '2003-01-09', 'L', 'Islam', NULL, '3325112502074307', 'Jl. Gajah Mada No. 55 RT.2 RW.4 Bangunsari Barat', 'Proyonanggan Tengah', 'Kec. Batang', '', '51211', 'Bersama orang tua', '', '08562885089', '[email protected]', '', '', 'Teguh Dwi Janarko', 'Batang', '1974-01-20', 'Pegawai Negeri Sipil', 3000000, '3325112001740002', 'Niken Woelandari', 'Batang', '1976-05-11', 'Ibu Rumah Tangga', 0, '332511510760001', '', '', '0000-00-00', '', 0, '', 'SMP NEGERI 6 PEKALONGAN', 'Jln. RA Kartini No.36 Pekalongan, Kelurahan Keputran, Kecamatan Pekalongan Timur, Kota Pekalongan, Jawa Tengah', 'B', NULL, 20181, '2018-07-16', '2-18-03-04-006-115-6', 'DN-03 D 0041656', 'DN-Dp/13 0521717', '{\"name\": \"kartu_keluarga_538.jpg\", \"size\": 306254, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_538.jpg\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_538.jpg\"}', '{\"name\": \"akte_kelahiran_538.jpg\", \"size\": 369238, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_538.jpg\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_538.jpg\"}', '{\"name\": \"skhun_538.jpg\", \"size\": 479185, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_538.jpg\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_538.jpg\"}', '{\"name\": \"ijazah_538.jpg\", \"size\": 422965, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_538.jpg\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_538.jpg\"}', NULL, '2021-01-17 21:42:25', '2021-01-17 21:25:39', NULL, '', '{\"agent\":\"Chrome 87.0.4280.141\",\"ip_address\":\"36.80.118.114\",\"platform\":\"Android\",\"waktu\":\"2021-01-17 22:16:22\",\"id_user\":\"538\",\"nama\":\"Nico Satria Prakosa\",\"username\":\"17623\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 10; SM-A505F) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Mobile Safari\\/537.36\",\"log_login\":null}'),
(539, 'NISRINA ADIBA', '17624', '$2y$10$8y59GfDFoctURCkaVtAmf.2osObBtF48SnDzbf6gD3J2n6qeHkjlW', 1, '17624', '0033190344', '3326155203030004', 'Pekalongan', '2003-03-12', 'P', '56', NULL, '3326152802090001', 'Perum GTA Jl. Seruni II No 50 RT.5 RW.4 ', 'Tanjung', 'Kec. Tirto', '', '51151', 'Bersama orang tua', '0285-4418027', '085781991853', '[email protected]', '', '', 'Ahmad Bakhir', 'Pekalongan', '0000-00-00', 'PNS', 0, '3326150909710025', 'Tri Wigati', 'Pekalongan', '0000-00-00', 'PNS', 0, '3326156309700004', '-', '-', '0000-00-00', '-', 0, '-', 'SMP N 2 Pekalongan', 'Jalan Cendrawasih 11 Pekalongan', 'B', NULL, 20181, '2018-07-16', '2-18-03-04-002-209-8', 'DN-Dp/13 0521596', 'DN-03 D 0041049', '{\"name\": \"kartu_keluarga_539.jpg\", \"size\": 633041, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_539.jpg\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_539.jpg\"}', '{\"name\": \"akte_kelahiran_539.jpg\", \"size\": 1018365, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_539.jpg\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_539.jpg\"}', '{\"name\": \"skhun_539.jpg\", \"size\": 451084, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_539.jpg\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_539.jpg\"}', '{\"name\": \"ijazah_539.jpg\", \"size\": 435636, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_539.jpg\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_539.jpg\"}', '2021-01-15 14:53:00', '2021-01-16 19:21:52', '2021-01-27 11:14:21', NULL, '', '{\"agent\":\"Chrome 87.0.4280.141\",\"ip_address\":\"36.68.53.167\",\"platform\":\"Android\",\"waktu\":\"2021-01-15 15:22:41\",\"id_user\":\"539\",\"nama\":\"NISRINA ADIBA\",\"username\":\"17624\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 10; CPH2127) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Mobile Safari\\/537.36\",\"log_login\":null}'),
(540, 'NUR SUKMA AMELIA', '17660', '$2y$10$yV4PTSngyJQOgKL41d8Z6eNC/z3XTerjUtfYKD8imJHslaF1DoN8e', 1, '17660', '0032951675', '3375034308030002', 'Pekalongan', '2003-08-03', 'P', '56', NULL, '3375030407070039', 'Jl. Kusuma Bangsa Gg. Pahlawan III/45 RT.1 RW.2 ', 'Panjang Baru', 'Kec. Pekalongan Utara', '', '51141', 'Bersama orang tua', '', '+6288225130491', '[email protected]', '', '', 'Subiyono', 'Pekalongan', '1961-12-12', 'Buruh', 0, '3375031212610004', 'Herlinawati', 'Pekalongan ', '1963-02-21', 'Ibu rumah tangga', 0, '3375036102630001', '', '', '0000-00-00', '', 0, '', 'SMPN 01 PEKALONGAN', 'Jl. Wr. Supratman No.8, Kandang Panjang, Pekalongan Utara, Kota Pekalongan, Jawa Tengah 51149', 'B', NULL, 20201, '2018-07-16', '2-18-04-001-021-4', 'DN-Dp/13 0521187', '423.7/343', '{\"name\": \"kartu_keluarga_540.pdf\", \"size\": 844522, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_540.pdf\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_540.pdf\"}', '{\"name\": \"akte_kelahiran_540.pdf\", \"size\": 853695, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_540.pdf\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_540.pdf\"}', '{\"name\": \"skhun_540.pdf\", \"size\": 398164, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_540.pdf\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_540.pdf\"}', '{\"name\": \"ijazah_540.pdf\", \"size\": 766626, \"is_image\": false, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_540.pdf\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_540.pdf\"}', '2021-01-14 20:56:12', '2021-01-14 21:27:51', '2021-01-14 21:17:28', NULL, '', '{\"agent\":\"Chrome 89.0.4389.128\",\"ip_address\":\"114.79.16.179\",\"platform\":\"Windows 10\",\"waktu\":\"2021-04-21 11:10:11\",\"id_user\":\"540\",\"nama\":\"NUR SUKMA AMELIA\",\"username\":\"17660\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/89.0.4389.128 Safari\\/537.36\",\"log_login\":null}'),
(541, 'NURUL NASWAA KAMILA', '17692', '$2y$10$rtcPgoLzU9u12xEG6/2XluzgvPA8z68laWb/2skqj6Jp69YRaERrq', 1, '17692', '0039732657', '3375014404030003', 'Kota Pekalongan', '2003-04-04', 'P', '56', NULL, '3375010902120002', 'Jl. Permai No. 242 Binagriya Indah RT.2 RW.15 ', 'Bendan Kergon', 'Kec. Pekalongan Barat', '', '51113', 'Bersama orang tua', '', '089619746068', '[email protected]', '', '', 'H. Safrudin', 'Pelalongan', '1977-01-06', 'Wiraswasta', 5000000, '3375010601770007', 'Lusiana', 'Pekalongan', '1978-09-18', 'Karyawan Swasta', 5000000, '3375016809780003', '', '', '0000-00-00', '', 0, '', 'SMP NEGERI 2 PEKALONGAN', 'Jl. Cendrawasih No.11, Kandang Panjang, Pekalongan Utara, Kota Pekalongan, Jawa Tengah', 'B', NULL, 20201, '2018-07-16', '2-18-03-04-002-211-6', 'DN-Dp/13 0521598', 'DN-03 D 0041051', '{\"name\": \"kartu_keluarga_541.jpg\", \"size\": 665631, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_541.jpg\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_541.jpg\"}', '{\"name\": \"akte_kelahiran_541.jpg\", \"size\": 897488, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_541.jpg\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_541.jpg\"}', '{\"name\": \"skhun_541.jpg\", \"size\": 887146, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_541.jpg\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_541.jpg\"}', '{\"name\": \"ijazah_541.jpg\", \"size\": 839360, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_541.jpg\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_541.jpg\"}', '2021-01-17 20:33:39', '2021-01-17 20:38:41', '2021-01-17 20:33:54', NULL, '', '{\"agent\":\"Chrome 83.0.4103.101\",\"ip_address\":\"103.105.27.87\",\"platform\":\"Android\",\"waktu\":\"2021-01-17 20:39:26\",\"id_user\":\"541\",\"nama\":\"NURUL NASWAA KAMILA\",\"username\":\"17692\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 10; SM-A605G) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/83.0.4103.101 Mobile Safari\\/537.36\",\"log_login\":null}'),
(542, 'RAISA MARANTA SAIKA', '17661', '$2y$10$atfgGfTaTbCDkn0t3sVxWO23n89fntb9hIkGI.OhLJHG/Lw1PM..O', 1, '17661', '0033217951', '3375025105030001', 'Pekalongan', '2003-05-11', 'P', '56', NULL, '3375022709070018', 'Jl. HOS Cokroaminoto Gg 16 No 2 RT.3 RW.12 ', 'Noyontaansari', 'Kec. Pekalongan Timur', '', '51129', 'Bersama orang tua', '', '0816644646', '[email protected]', '', '', 'Syaiful Rijal', 'Batang', '1979-07-19', 'Wiraswasta', 0, '', 'Ika Rusfiana', 'Pekalongan', '1979-07-19', 'Ibu Rumah Tangga', 0, '', '', '', '1979-07-19', '', 0, '', 'SMPN 2 Pekalongan', 'Jl. Cendrawasih No. 11 Pekalongan', 'B', NULL, 20181, '2016-02-01', '2-18-03-04-002-146-7', 'DN/Dp/13 0521533', 'DN-03 D 0040986', '{\"name\": \"kartu_keluarga_542.jpg\", \"size\": 349786, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/kartu_keluarga/kartu_keluarga_542.jpg\", \"server_path\": \"./files/dokumen_siswa/kartu_keluarga/kartu_keluarga_542.jpg\"}', '{\"name\": \"akte_kelahiran_542.jpg\", \"size\": 689621, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/akte_kelahiran/akte_kelahiran_542.jpg\", \"server_path\": \"./files/dokumen_siswa/akte_kelahiran/akte_kelahiran_542.jpg\"}', '{\"name\": \"skhun_542.jpg\", \"size\": 640377, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/skhun/skhun_542.jpg\", \"server_path\": \"./files/dokumen_siswa/skhun/skhun_542.jpg\"}', '{\"name\": \"ijazah_542.jpg\", \"size\": 629818, \"is_image\": true, \"url_path\": \"/files/dokumen_siswa/ijazah/ijazah_542.jpg\", \"server_path\": \"./files/dokumen_siswa/ijazah/ijazah_542.jpg\"}', '2021-01-14 20:52:05', '2021-01-14 21:04:08', '2021-01-14 21:00:52', NULL, '', '{\"agent\":\"Chrome 84.0.4147.111\",\"ip_address\":\"114.4.220.190\",\"platform\":\"Android\",\"waktu\":\"2021-01-14 20:57:18\",\"id_user\":\"542\",\"nama\":\"RAISA MARANTA SAIKA\",\"username\":\"17661\",\"access\":\"siswa\",\"string\":\"Mozilla\\/5.0 (Linux; Android 7.1.1; CPH1725) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/84.0.4147.111 Mobile Safari\\/537.36\",\"log_login\":null}'),
Format: sql
Link: Sman1pekalongan.sch.id / https://sias.sman1pekalongan.sch.id/
Users: 1500
Size - 80mb
Leaked db By Chucky


