Barqun.comSql No Pass

frog · Jun 15, 2023

barqun.com

date: nov 2022
Format - .SQL
Size sql file - 1GB
All Rows - 2kk

Sample:

HTML:

(2873, 'default', 'updated', 'App\\Models\\Guru', 20, 'App\\Models\\User', 5, '{"attributes":{"nip":"\\u200c196205041981111003","nuptk":"\\u200c3836740641200042","nama":"Yohanis Parerungan","jenis_kelamin":"L","tempat_lahir":"Kurra","tanggal_lahir":"1962-04-29T16:00:00.000000Z","pendidikan":"S1","pangkat_gol":"IV\\/a","kompeten":null,"status_keaktifan":null},"old":{"nip":"\\u200c196205041981111003","nuptk":"\\u200c3836740641200042","nama":"Yohanis Parerungan","jenis_kelamin":"L","tempat_lahir":"Kurra","tanggal_lahir":"1962-04-30T16:00:00.000000Z","pendidikan":"S1","pangkat_gol":"IV\\/a","kompeten":null,"status_keaktifan":null}}', '2021-11-05 03:06:45', '2021-11-05 03:06:45'),
(2874, 'default', 'updated', 'App\\Models\\Guru', 21, 'App\\Models\\User', 5, '{"attributes":{"nip":"\\u200c","nuptk":"\\u200c6757749650300012","nama":"Yusniati Topadang Turu Allo","jenis_kelamin":"P","tempat_lahir":"Tapparan","tanggal_lahir":"1971-04-20T16:00:00.000000Z","pendidikan":"D4","pangkat_gol":"","kompeten":null,"status_keaktifan":null},"old":{"nip":"\\u200c","nuptk":"\\u200c6757749650300012","nama":"Yusniati Topadang Turu Allo","jenis_kelamin":"P","tempat_lahir":"Tapparan","tanggal_lahir":"1971-04-21T16:00:00.000000Z","pendidikan":"D4","pangkat_gol":"","kompeten":null,"status_keaktifan":null}}', '2021-11-05 03:06:45', '2021-11-05 03:06:45'),
(2875, 'default', 'updated', 'App\\Models\\Guru', 118, 'App\\Models\\User', 5, '{"attributes":{"nip":"\\u200c196612312003121003","nuptk":"\\u200c4952744645200002","nama":"A. Mustafa","jenis_kelamin":"L","tempat_lahir":"Alang-Alang","tanggal_lahir":"1966-11-05T16:00:00.000000Z","pendidikan":"S2","pangkat_gol":"III\\/a","kompeten":null,"status_keaktifan":null},"old":{"nip":"\\u200c196612312003121003","nuptk":"\\u200c4952744645200002","nama":"A. Mustafa","jenis_kelamin":"L","tempat_lahir":"Alang-Alang","tanggal_lahir":"1966-11-06T16:00:00.000000Z","pendidikan":"S2","pangkat_gol":"III\\/a","kompeten":null,"status_keaktifan":null}}', '2021-11-05 03:06:45', '2021-11-05 03:06:45'),

(981, 34, 1, 2, 'Ana Radiah', '‌6474026803680001', '‌196803282001052001', '‌2660746649300022', 'P', 'Surabaya', NULL, '1968-03-25', 'Induk', '081253872619', '821.12/012/BKD/VIII/2001', '2001-05-01', '821.12/012/BKD/VIII/2001', '2001-05-01', 'Guru Kelas', 'S1', 'Guru Kelas SD/MI', 'Guru Kelas SD/MI', 'III/c', '2020-05-01', 14, 0, 24, 'Tidak', NULL, NULL, NULL, NULL, '2021-11-19 11:17:09', 'Aktif', NULL, NULL),
(982, 34, 3, 2, 'ARIF WIDYANSYAH', '‌6474020810890002', '‌', '‌9341767668130073', 'L', 'BONTANG', NULL, '1989-10-05', 'Induk', '081347134015', NULL, '1900-01-01', NULL, '2016-01-04', 'Guru Kelas', 'S1', 'Guru Kelas SD/MI', NULL, NULL, '1900-01-01', 0, 0, 24, 'Tidak', NULL, NULL, NULL, NULL, '2021-11-19 11:17:09', 'Aktif', NULL, NULL),
(983, 34, 1, 2, 'Evi Fauziah', '‌6474025911670002', '‌196711192005022001', '‌9451745647300013', 'P', 'Jember', NULL, '1967-11-16', 'Induk', '081238929151', '813.2/006/BKD-BTG/I/2005', '2005-02-01', '813.2/006/BKD-BTG/1/2005', '2005-02-01', 'Guru Kelas', 'S1', 'Guru Kelas SD/MI', 'Guru Kelas SD/MI', 'III/b', '2020-07-01', 14, 0, 24, 'Tidak', NULL, NULL, NULL, NULL, '2021-11-19 11:17:09', 'Aktif', NULL, NULL),
(984, 34, 3, 2, 'Imro Atun Sukriana', '‌6474025303960007', '‌', '‌6638774675230052', 'P', 'Bontang', NULL, '1996-03-02', 'Induk', '081345014483', NULL, '1900-01-01', '001/800-SDKH/421.2/VII/2019', '2019-05-16', 'Guru Kelas', 'S1', 'Guru Kelas SD/MI', NULL, NULL, '1900-01-01', 0, 0, 24, 'Tidak', NULL, NULL, NULL, NULL, '2021-11-19 11:17:09', 'Aktif', NULL, NULL),
(985, 34, 1, 2, 'Masdar', '‌6474022911690002', '‌196911292005021001', '‌9461747649200013', 'L', 'Botta', NULL, '1969-11-26', 'Induk', '081346596967', '821.13/08/BKD-BTG/1/2006', '2006-02-01', '813.3/006/BKD-BTG/I/2005', '2005-02-01', 'Guru Kelas', 'S1', 'Bahasa Inggris', 'Guru Kelas SD/MI', 'III/d', '2021-05-01', 20, 0, 24, 'Tidak', NULL, NULL, NULL, NULL, '2021-11-19 11:17:09', 'Aktif', NULL, NULL);
INSERT INTO `gurus` (`id`, `sekolah_id`, `kepegawaian_id`, `mata_pelajaran_id`, `nama`, `nik`, `nip`, `nuptk`, `jenis_kelamin`, `tempat_lahir`, `kota`, `tanggal_lahir`, `status_tugas`, `nomor_hp`, `sk_cpns`, `tanggal_cpns`, `sk_pengangkatan`, `tmt_pengangkatan`, `jenis_ptk`, `pendidikan`, `bidang_studi_pendidikan`, `bidang_studi_sertifikasi`, `pangkat_gol`, `tmt_pangkat`, `masa_kerja_tahun`, `masa_kerja_bulan`, `jam_mengajar_perminggu`, `jabatan_kepsek`, `kompeten`, `status_validasi`, `verified_at`, `created_at`, `updated_at`, `status_keaktifan`, `tgl_mulai_keaktifan`, `tgl_non_aktif`) VALUES

18396, 2981, 'resmushed_quality', '72'),
(18397, 2981, 'resmushed_cumulated_original_sizes', '319131'),
(18398, 2981, 'resmushed_cumulated_optimized_sizes', '277136'),
(18399, 2982, '_wp_attached_file', '2020/06/fb-intuisi-naruto.jpg'),
(18400, 2982, '_wp_attachment_metadata', 'a:5:{s:5:"width";i:1000;s:6:"height";i:525;s:4:"file";s:29:"2020/06/fb-intuisi-naruto.jpg";s:5:"sizes";a:6:{s:6:"medium";a:4:{s:4:"file";s:29:"fb-intuisi-naruto-300x158.jpg";s:5:"width";i:300;s:6:"height";i:158;s:9:"mime-type";s:10:"image/jpeg";}s:9:"thumbnail";a:4:{s:4:"file";s:29:"fb-intuisi-naruto-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:12:"medium_large";a:4:{s:4:"file";s:29:"fb-intuisi-naruto-768x403.jpg";s:5:"width";i:768;s:6:"height";i:403;s:9:"mime-type";s:10:"image/jpeg";}s:18:"jannah-image-small";a:4:{s:4:"file";s:29:"fb-intuisi-naruto-220x150.jpg";s:5:"width";i:220;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:18:"jannah-image-large";a:4:{s:4:"file";s:29:"fb-intuisi-naruto-390x220.jpg";s:5:"width";i:390;s:6:"height";i:220;s:9:"mime-type";s:10:"image/jpeg";}s:17:"jannah-image-post";a:4:{s:4:"file";s:29:"fb-intuisi-naruto-780x470.jpg";s:5:"width";i:780;s:6:"height";i:470;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:12:{s:8:"aperture";s:1:"0";s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";s:1:"0";s:9:"copyright";s:0:"";s:12:"focal_length";s:1:"0";s:3:"iso";s:1:"0";s:13:"shutter_speed";s:1:"0";s:5:"title";s:0:"";s:11:"orientation";s:1:"0";s:8:"keywords";a:0:{}}}'),
(18401, 2982, 'resmushed_quality', '72'),
(18402, 2982, 'resmushed_cumulated_original_sizes', '291715'),
(18403, 2982, 'resmushed_cumulated_optimized_sizes', '251329'),
(18404, 2983, '_wp_attached_file', '2020/06/twit-intuisi-naruto.jpg'),
(18405, 2983, '_wp_attachment_metadata', 'a:5:{s:5:"width";i:1000;s:6:"height";i:500;s:4:"file";s:31:"2020/06/twit-intuisi-naruto.jpg";s:5:"sizes";a:6:{s:6:"medium";a:4:{s:4:"file";s:31:"twit-intuisi-naruto-300x150.jpg";s:5:"width";i:300;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:9:"thumbnail";a:4:{s:4:"file";s:31:"twit-intuisi-naruto-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:12:"medium_large";a:4:{s:4:"file";s:31:"twit-intuisi-naruto-768x384.jpg";s:5:"width";i:768;s:6:"height";i:384;s:9:"mime-type";s:10:"image/jpeg";}s:18:"jannah-image-small";a:4:{s:4:"file";s:31:"twit-intuisi-naruto-220x150.jpg";s:5:"width";i:220;s:6:"height";i:150;s:9:"mime-type";s:10:"image/jpeg";}s:18:"jannah-image-large";a:4:{s:4:"file";s:31:"twit-intuisi-naruto-390x220.jpg";s:5:"width";i:390;s:6:"height";i:220;s:9:"mime-type";s:10:"image/jpeg";}s:17:"jannah-image-post";a:4:{s:4:"file";s:31:"twit-intuisi-naruto-780x470.jpg";s:5:"width";i:780;s:6:"height";i:470;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:12:{s:8:"aperture";s:1:"0";s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";s:1:"0";s:9:"copyright";s:0:"";s:12:"focal_length";s:1:"0";s:3:"iso";s:1:"0";s:13:"shutter_speed";s:1:"0";s:5:"title";s:0:"";s:11:"orientation";s:1:"0";s:8:"keywords";a:0:{}}}'),

Hidden content

lbNewBieuser · Jun 15, 2023

thank you for sharing the dump it's very useful.

Barqun.comSql No Pass

frog

lbNewBieuser

Similar threads