API tools faq
paste
Advertisement
Firdaus_Shinoda

db_kp

Firdaus_Shinoda
May 22nd, 2017
518
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 42.96 KB | None | 0 0
raw download clone embed print report
  1. --CREATE DATABASE db_kp;
  2. --USE db_kp;
  3.  
  4. CREATE TABLE IF NOT EXISTS `admin` (
  5.   `id_admin` int(10) NOT NULL,
  6.   `niy` varchar(20) DEFAULT NULL,
  7.   `nama_admin` varchar(100) DEFAULT NULL,
  8.   `username_admin` varchar(100) DEFAULT NULL,
  9.   `jabatan` varchar(20) DEFAULT NULL,
  10.   `password` longtext,
  11.   `agama` varchar(10) DEFAULT NULL,
  12.   `sex` varchar(15) DEFAULT NULL,
  13.   `tgl_lahir` int(2) DEFAULT NULL,
  14.   `bln_lahir` varchar(10) DEFAULT NULL,
  15.   `thn_lahir` int(4) DEFAULT NULL,
  16.   `email` varchar(100) DEFAULT NULL,
  17.   `alamat` varchar(100) DEFAULT NULL,
  18.   `golongan_darah` varchar(2) DEFAULT NULL,
  19.   `foto_admin` varchar(100) DEFAULT NULL,
  20.   `cdate` datetime DEFAULT NULL,
  21.   `mdate` datetime DEFAULT NULL,
  22.   `ddate` datetime DEFAULT NULL,
  23.   `deleted_flage` int(1) DEFAULT NULL
  24. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  25.  
  26. --
  27. -- Dumping data untuk tabel `admin`
  28. --
  29.  
  30. INSERT INTO `admin` (`id_admin`, `niy`, `nama_admin`, `username_admin`, `jabatan`, `password`, `agama`, `sex`, `tgl_lahir`, `bln_lahir`, `thn_lahir`, `email`, `alamat`, `golongan_darah`, `foto_admin`, `cdate`, `mdate`, `ddate`, `deleted_flage`) VALUES
  31. (1, '54321', 'Tyas Nevi', 'admin', '', '827ccb0eea8a706c4c34a16891f84e7b', 'Islam', 'Perempuan', 8, 'Desember', 0, '', 'tegal', NULL, NULL, NULL, '2017-04-19 13:47:27', NULL, 1);
  32.  
  33. -- --------------------------------------------------------
  34.  
  35. --
  36. -- Struktur dari tabel `bimbingan_online`
  37. --
  38.  
  39. CREATE TABLE IF NOT EXISTS `bimbingan_online` (
  40.   `id_bimbingan_online` int(10) NOT NULL,
  41.   `id_mahasiswa` int(20) DEFAULT NULL,
  42.   `id_dosen` varchar(20) DEFAULT NULL,
  43.   `isi` longtext,
  44.   `tipe` varchar(10) DEFAULT NULL,
  45.   `size` varchar(50) DEFAULT NULL,
  46.   `nama_file` varchar(100) DEFAULT NULL,
  47.   `stt_chat` int(1) DEFAULT NULL,
  48.   `stt_r_mhs` int(1) NOT NULL DEFAULT '1',
  49.   `stt_r_dsn` int(1) NOT NULL DEFAULT '1',
  50.   `send_by` varchar(10) DEFAULT NULL,
  51.   `cdate` datetime DEFAULT NULL,
  52.   `mdate` datetime DEFAULT NULL,
  53.   `ddate` datetime DEFAULT NULL,
  54.   `deleted_flage` int(1) DEFAULT NULL
  55. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  56.  
  57. -- --------------------------------------------------------
  58.  
  59. --
  60. -- Struktur dari tabel `dashboard`
  61. --
  62.  
  63. CREATE TABLE IF NOT EXISTS `dashboard` (
  64.   `id_dashboard` int(10) NOT NULL,
  65.   `isi` longtext,
  66.   `cdate` datetime DEFAULT NULL,
  67.   `mdate` datetime DEFAULT NULL,
  68.   `ddate` datetime DEFAULT NULL,
  69.   `deleted_flage` int(1) DEFAULT NULL
  70. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  71.  
  72. -- --------------------------------------------------------
  73.  
  74. --
  75. -- Struktur dari tabel `dashboard_file`
  76. --
  77.  
  78. CREATE TABLE IF NOT EXISTS `dashboard_file` (
  79.   `id_dashboard_file` int(10) NOT NULL,
  80.   `id_dashboard` int(10) DEFAULT NULL,
  81.   `nama` varchar(100) DEFAULT NULL,
  82.   `file` varchar(100) DEFAULT NULL,
  83.   `size` int(10) DEFAULT NULL,
  84.   `tipe` varchar(100) DEFAULT NULL
  85. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  86.  
  87. -- --------------------------------------------------------
  88.  
  89. --
  90. -- Struktur dari tabel `dashboard_img`
  91. --
  92.  
  93. CREATE TABLE IF NOT EXISTS `dashboard_img` (
  94.   `id_dashboard_img` int(10) NOT NULL,
  95.   `img` varchar(100) DEFAULT NULL,
  96.   `cdate` datetime DEFAULT NULL,
  97.   `mdate` datetime DEFAULT NULL,
  98.   `ddate` datetime DEFAULT NULL
  99. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  100.  
  101. --
  102. -- Dumping data untuk tabel `dashboard_img`
  103. --
  104.  
  105. INSERT INTO `dashboard_img` (`id_dashboard_img`, `img`, `cdate`, `mdate`, `ddate`) VALUES
  106. (2, 'X~rPRL215trzCF-iUh57.jpg', '2017-03-19 00:03:57', NULL, NULL),
  107. (3, 'riHNjP_V9PGnPox6iqd.jpg', '2017-03-19 00:04:12', NULL, NULL);
  108.  
  109. -- --------------------------------------------------------
  110.  
  111. --
  112. -- Struktur dari tabel `deskripsi_kp`
  113. --
  114.  
  115. CREATE TABLE IF NOT EXISTS `deskripsi_kp` (
  116.   `id_deskripsi_kp` int(1) NOT NULL,
  117.   `isi` longtext,
  118.   `cdate` datetime DEFAULT NULL
  119. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  120.  
  121. --
  122. -- Dumping data untuk tabel `deskripsi_kp`
  123. --
  124.  
  125. INSERT INTO `deskripsi_kp` (`id_deskripsi_kp`, `isi`, `cdate`) VALUES
  126. (1, 'Kerja Praktek adalah kegiatan mahasiswa yang dilakukan di masyarakat maupun di perusahaan atau instansi untuk mengaplikasikan ilmu yang diperoleh dan melihat relevansinya di masyarakat maupun melalui jalur pengembangan diri dengan mendalami bidang ilmu tertentu dan aplikasinya.', '2017-03-19 01:31:05');
  127.  
  128. -- --------------------------------------------------------
  129.  
  130. --
  131. -- Struktur dari tabel `dosen`
  132. --
  133.  
  134. CREATE TABLE IF NOT EXISTS `dosen` (
  135.   `id_dosen` varchar(20) NOT NULL DEFAULT '0',
  136.   `nama_dosen` varchar(50) DEFAULT NULL,
  137.   `jabatan` varchar(20) DEFAULT NULL,
  138.   `password` longtext,
  139.   `agama` varchar(10) DEFAULT NULL,
  140.   `sex` varchar(15) DEFAULT NULL,
  141.   `tgl_lahir` int(2) DEFAULT NULL,
  142.   `bln_lahir` varchar(10) DEFAULT NULL,
  143.   `thn_lahir` int(4) DEFAULT NULL,
  144.   `email` varchar(100) DEFAULT NULL,
  145.   `alamat` varchar(100) DEFAULT NULL,
  146.   `golongan_darah` varchar(2) DEFAULT NULL,
  147.   `foto_dosen` varchar(100) DEFAULT NULL,
  148.   `stt_login_dosen` int(1) DEFAULT '0',
  149.   `ldate_dosen` datetime DEFAULT '0000-00-00 00:00:00',
  150.   `cdate` datetime DEFAULT NULL,
  151.   `mdate` datetime DEFAULT NULL,
  152.   `ddate` datetime DEFAULT NULL,
  153.   `deleted_flage` int(1) DEFAULT NULL
  154. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  155.  
  156. --
  157. -- Dumping data untuk tabel `dosen`
  158. --
  159.  
  160. INSERT INTO `dosen` (`id_dosen`, `nama_dosen`, `jabatan`, `password`, `agama`, `sex`, `tgl_lahir`, `bln_lahir`, `thn_lahir`, `email`, `alamat`, `golongan_darah`, `foto_dosen`, `stt_login_dosen`, `ldate_dosen`, `cdate`, `mdate`, `ddate`, `deleted_flage`) VALUES
  161. ('10.007.032', 'Ginanjar Wiro Sasmito', 'Ka. Prodi', '827ccb0eea8a706c4c34a16891f84e7b', 'Islam', '', 2, 'Juni', 1983, '', '', 'A', NULL, 0, '2017-05-22 14:50:32', '2017-04-13 11:23:07', '2017-04-19 13:35:54', NULL, 1);
  162.  
  163. -- --------------------------------------------------------
  164.  
  165. --
  166. -- Struktur dari tabel `galeri`
  167. --
  168.  
  169. CREATE TABLE IF NOT EXISTS `galeri` (
  170.   `id_galeri` int(10) NOT NULL,
  171.   `img` varchar(100) DEFAULT NULL,
  172.   `nama` varchar(100) DEFAULT NULL,
  173.   `size` int(10) DEFAULT NULL,
  174.   `tipe` varchar(5) DEFAULT NULL,
  175.   `cdate` datetime DEFAULT NULL,
  176.   `mdate` datetime DEFAULT NULL,
  177.   `ddate` datetime DEFAULT NULL
  178. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  179.  
  180. --
  181. -- Dumping data untuk tabel `galeri`
  182. --
  183.  
  184. INSERT INTO `galeri` (`id_galeri`, `img`, `nama`, `size`, `tipe`, `cdate`, `mdate`, `ddate`) VALUES
  185. (1, 'BjkNjju~3VhPI19ot0h.jpg', 'IKITAS', 3338, 'image', '2017-04-13 11:28:17', NULL, NULL);
  186.  
  187. -- --------------------------------------------------------
  188.  
  189. --
  190. -- Struktur dari tabel `kp`
  191. --
  192.  
  193. CREATE TABLE IF NOT EXISTS `kp` (
  194.   `id_kp` varchar(10) NOT NULL DEFAULT '0',
  195.   `create_by` varchar(20) DEFAULT NULL,
  196.   `stt` int(1) DEFAULT NULL,
  197.   `cdate` datetime DEFAULT NULL,
  198.   `ddate` datetime DEFAULT NULL,
  199.   `deleted_flage` int(1) DEFAULT NULL
  200. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  201.  
  202. -- --------------------------------------------------------
  203.  
  204. --
  205. -- Struktur dari tabel `kp_anggota`
  206. --
  207.  
  208. CREATE TABLE IF NOT EXISTS `kp_anggota` (
  209.   `id_kp_anggota` int(10) NOT NULL,
  210.   `id_kp` varchar(10) DEFAULT NULL,
  211.   `id_mahasiswa` int(20) DEFAULT NULL,
  212.   `cdate` datetime DEFAULT NULL
  213. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  214.  
  215. -- --------------------------------------------------------
  216.  
  217. --
  218. -- Struktur dari tabel `kp_bimbingan`
  219. --
  220.  
  221. CREATE TABLE IF NOT EXISTS `kp_bimbingan` (
  222.   `id_kp_bimbingan` int(100) NOT NULL,
  223.   `id_pembimbing` int(10) DEFAULT NULL,
  224.   `id_kp` varchar(10) DEFAULT NULL,
  225.   `id_mahasiswa` int(20) DEFAULT NULL,
  226.   `tgl` date DEFAULT NULL,
  227.   `ket` longtext,
  228.   `ttd_by` int(10) DEFAULT NULL,
  229.   `cdate` datetime DEFAULT NULL
  230. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  231.  
  232. -- --------------------------------------------------------
  233.  
  234. --
  235. -- Struktur dari tabel `kp_harian`
  236. --
  237.  
  238. CREATE TABLE IF NOT EXISTS `kp_harian` (
  239.   `id_kp_harian` int(100) NOT NULL,
  240.   `id_pembimbing` int(10) DEFAULT NULL,
  241.   `id_kp` varchar(10) DEFAULT NULL,
  242.   `id_mahasiswa` int(20) DEFAULT NULL,
  243.   `tgl` date DEFAULT NULL,
  244.   `ket` longtext,
  245.   `cdate` datetime DEFAULT NULL
  246. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  247.  
  248. -- --------------------------------------------------------
  249.  
  250. --
  251. -- Struktur dari tabel `kp_laporan`
  252. --
  253.  
  254. CREATE TABLE IF NOT EXISTS `kp_laporan` (
  255.   `id_kp_laporan` int(10) NOT NULL,
  256.   `id_kp` varchar(10) DEFAULT NULL,
  257.   `nama_laporan` longtext,
  258.   `size` int(10) DEFAULT NULL,
  259.   `file` varchar(100) DEFAULT NULL,
  260.   `tipe` varchar(5) DEFAULT NULL,
  261.   `stt` int(1) DEFAULT NULL,
  262.   `cdate` datetime DEFAULT NULL,
  263.   `mdate` datetime DEFAULT NULL,
  264.   `ddate` datetime DEFAULT NULL,
  265.   `deleted_flage` int(1) DEFAULT NULL
  266. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  267.  
  268. -- --------------------------------------------------------
  269.  
  270. --
  271. -- Struktur dari tabel `kp_perusahaan`
  272. --
  273.  
  274. CREATE TABLE IF NOT EXISTS `kp_perusahaan` (
  275.   `id_kp_perusahaan` int(10) NOT NULL,
  276.   `id_kp` varchar(10) DEFAULT NULL,
  277.   `nama_perusahaan` varchar(100) DEFAULT NULL,
  278.   `deskripsi` longtext,
  279.   `alamat` varchar(100) DEFAULT NULL,
  280.   `file` varchar(100) DEFAULT NULL,
  281.   `nama_file` varchar(100) DEFAULT NULL,
  282.   `size` int(10) DEFAULT NULL,
  283.   `tipe` varchar(20) DEFAULT NULL
  284. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  285.  
  286. -- --------------------------------------------------------
  287.  
  288. --
  289. -- Struktur dari tabel `log_activity`
  290. --
  291.  
  292. CREATE TABLE IF NOT EXISTS `log_activity` (
  293.   `id_log_activity` int(100) NOT NULL,
  294.   `id` varchar(50) DEFAULT NULL,
  295.   `ket` varchar(200) DEFAULT NULL,
  296.   `cdate` datetime DEFAULT NULL,
  297.   `deleted_flage` int(1) DEFAULT NULL
  298. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  299.  
  300. -- --------------------------------------------------------
  301.  
  302. --
  303. -- Struktur dari tabel `mahasiswa`
  304. --
  305.  
  306. CREATE TABLE IF NOT EXISTS `mahasiswa` (
  307.   `id_mahasiswa` int(20) NOT NULL DEFAULT '0',
  308.   `nama_mahasiswa` varchar(50) DEFAULT NULL,
  309.   `password` longtext,
  310.   `agama` varchar(10) DEFAULT NULL,
  311.   `sex` varchar(15) DEFAULT NULL,
  312.   `tgl_lahir` int(2) DEFAULT NULL,
  313.   `bln_lahir` varchar(10) DEFAULT NULL,
  314.   `thn_lahir` int(4) DEFAULT NULL,
  315.   `email` varchar(100) DEFAULT NULL,
  316.   `alamat` varchar(100) DEFAULT NULL,
  317.   `golongan_darah` varchar(2) DEFAULT NULL,
  318.   `angkatan` int(4) DEFAULT NULL,
  319.   `foto_mahasiswa` varchar(100) DEFAULT NULL,
  320.   `stt_login_mahasiswa` int(1) DEFAULT '0',
  321.   `ldate_mahasiswa` datetime DEFAULT '0000-00-00 00:00:00',
  322.   `cdate` datetime DEFAULT NULL,
  323.   `mdate` datetime DEFAULT NULL,
  324.   `ddate` datetime DEFAULT NULL,
  325.   `deleted_flage` int(1) DEFAULT NULL
  326. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  327.  
  328. --
  329. -- Dumping data untuk tabel `mahasiswa`
  330. --
  331.  
  332. INSERT INTO `mahasiswa` (`id_mahasiswa`, `nama_mahasiswa`, `password`, `agama`, `sex`, `tgl_lahir`, `bln_lahir`, `thn_lahir`, `email`, `alamat`, `golongan_darah`, `angkatan`, `foto_mahasiswa`, `stt_login_mahasiswa`, `ldate_mahasiswa`, `cdate`, `mdate`, `ddate`, `deleted_flage`) VALUES
  333. (1212212, 'asaasas', '827ccb0eea8a706c4c34a16891f84e7b', '', '', 0, '', 0, '', '', NULL, 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 12:51:36', NULL, '2017-05-22 13:29:45', 0),
  334. (14090001, 'Wan Abud', 'df319aa814f8dde9101cf1374d53c44b', 'Islam', '', 16, 'April', 1996, '', '', NULL, 0, '14090001-3Lw_LVky2ZP6RBJytjFZ.png', 0, '0000-00-00 00:00:00', '2017-04-13 11:39:45', NULL, '2017-04-13 11:39:53', 0),
  335. (14090015, 'Firdaus Nur Sugiarto', '1483fd668d46cc2909bf051280049d1d', 'Islam', 'Laki - Laki', 12, 'Maret', 1996, '[email protected]', 'Limbangan Wetan, Brebes', 'A', 2014, 'qm6cIY257BpnfVrGdwY.png', 0, '2017-05-22 21:52:57', '2017-04-13 11:09:00', NULL, NULL, 1),
  336. (14090070, 'Arif Hidayab', 'd85d36da3801f76d3583fce43a56cfa6', '', 'Laki - Laki', 7, 'Agustus', 1994, '', '', NULL, 0, '14090070-w507ah8215S_~j14fso.png', 0, '2017-04-14 00:14:26', '2017-04-13 23:59:20', NULL, NULL, 1),
  337. (15090002, 'SYLVIANNA OKTAVIANY', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 16, 'Oktober', 1996, '', 'TEGAL', '', 2015, NULL, 0, '2017-05-22 14:45:52', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  338. (15090003, 'MUHAMAD ALI MUZNI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 25, 'Januari', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  339. (15090004, 'ARIZQI ARIFUL INSANI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 28, 'September', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  340. (15090005, 'TRI THOLABUL ILMI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 9, 'Oktober', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  341. (15090006, 'IBNU ALI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 16, 'Agustus', 1996, '', 'PEMALANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  342. (15090007, 'REZA KARINDRA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 4, 'Februari', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  343. (15090009, 'AMIN MUNTAJI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 20, 'Mei', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  344. (15090010, 'IBNU DHIKRI MUHAMMAD', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 5, 'Agustus', 1996, '', 'PEMALANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  345. (15090011, 'M. SALMAN AL FARISI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 17, 'Maret', 1994, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  346. (15090012, 'FATKHUL FALAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 7, 'November', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  347. (15090013, 'MUHAMMAD GUNTUR ARDIKA SETYAWAN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 28, 'November', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  348. (15090014, 'DADE LISTI APRILIYANI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 6, 'April', 1999, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  349. (15090016, 'DINA WAHYUNI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 12, 'Desember', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  350. (15090017, 'JONATHAN SATRIA RAHARDJO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 3, 'Juni', 1997, '', 'PEMALANG', '', 2015, NULL, 0, '2017-05-22 14:24:22', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  351. (15090018, 'ANA BELLA KURNIYANTO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 30, 'Desember', 1997, '', 'BANDUNG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  352. (15090019, 'GUNTUR WICAKSONO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 13, 'Februari', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  353. (15090021, 'AZKA WILLDAN MUKHOLLADUN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 18, 'Juni', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  354. (15090022, 'SYEH SHOLIKHUN NASIR', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 16, 'Januari', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  355. (15090023, 'FAIZAL DIAN PERMANA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 7, 'Juli', 1997, '', 'PEMALANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  356. (15090024, 'AHMAD AULA MISBAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 21, 'Februari', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  357. (15090025, 'ANNISA MARSA ZUMZUMI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 7, 'Juli', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  358. (15090026, 'CITRA WIDYA HAPSARI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 14, 'Mei', 1997, '', 'SEMARANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  359. (15090027, 'SENO HENDY NURCAHYO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 12, 'April', 1995, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  360. (15090030, 'NADIYA RIZQI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 11, 'November', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  361. (15090034, 'ALFAN FAIZAL ARSIDIN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 14, 'November', 1997, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  362. (15090036, 'INDRI NOVI RAHMAWATI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 11, 'November', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  363. (15090039, 'MUHAMMAD ADITYA NUR FATKHUDIN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 13, 'November', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  364. (15090041, 'NOVIANTO ARIEF WIBOWO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 5, 'November', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  365. (15090042, 'YULIANA KUSUMA WARDANI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 25, 'Juli', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  366. (15090043, 'RIDHO GUSTI MAULANA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 18, 'Januari', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  367. (15090044, 'MURTADO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 12, 'Juli', 1992, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  368. (15090045, 'MUHAMMAD BIRUL WALIDEN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 14, 'November', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  369. (15090047, 'GILANG PRIMANDHA ASHARI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 23, 'September', 1996, '', 'PEMALANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  370. (15090048, 'ILMA UTIANA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 16, 'Februari', 1999, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  371. (15090049, 'REFANGGA IMAN NINDAR', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 28, 'Mei', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  372. (15090050, 'DEDY DWI SAPUTRO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 13, 'Juni', 1995, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  373. (15090051, 'MUHAMMAD ZULFIKAR', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 17, 'Agustus', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  374. (15090052, 'AMALIA NURUL FAUZIAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 7, 'Februari', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  375. (15090053, 'ANGGI ANTORO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 4, 'November', 1997, '', 'PURBALINGGA', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  376. (15090054, 'DINI PRINDHI HAPSARI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 3, 'Juni', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  377. (15090055, 'NUR IMANI HIDAYAT', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 15, 'Desember', 1995, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  378. (15090056, 'SITI MARIA ULFAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 3, 'Agustus', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  379. (15090057, 'AGUNG SURYA NUGRAHA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 19, 'April', 1994, '', 'PEMALANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  380. (15090058, 'BAYOE PAMUNGKAS', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 16, 'Desember', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  381. (15090059, 'MUHAMMAD LUTFIANSYAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 20, 'Januari', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  382. (15090060, 'ENDANG SULISTIANI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 14, 'November', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  383. (15090061, 'DAFFA ZUHDAN MUHTAR', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 24, 'Juni', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  384. (15090062, 'FAHRI SEPTA MAULANA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 23, 'September', 1995, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  385. (15090063, 'MUHAMMAD ADI RUCHMANAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 26, 'Agustus', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  386. (15090065, 'ACHMAD AWALI YUSUF', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 17, 'Februari', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  387. (15090066, 'YASINTA ERSYAF SEPTALIA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 11, 'Maret', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  388. (15090068, 'SEBASTIAN ADHITYA PRAMUJA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 13, 'Maret', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  389. (15090069, 'ALDIN TRI MULYO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 29, 'Desember', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  390. (15090070, 'ESTRI ADININGRUM', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 17, 'Mei', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  391. (15090071, 'DANNY BUNGA LESTARI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 14, 'November', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  392. (15090072, 'SANDYA ARIF', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 9, 'September', 1995, '', 'BANDUNG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  393. (15090073, 'MOHAMAD NURLISTIANTO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 2, 'Agustus', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  394. (15090074, 'DWI CAHYO SAPUTRO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 18, 'Januari', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  395. (15090075, 'DENI MARWANSYAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 28, 'Februari', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  396. (15090076, 'ZULFAN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 28, 'Mei', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  397. (15090077, 'SAEFUL BAHRI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 14, 'November', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  398. (15090078, 'DANDY AZIDANSYAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 19, 'Juni', 1998, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  399. (15090079, 'BAYU ADI PRASETIYO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 28, 'Agustus', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  400. (15090080, 'DIO SURANDITO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 26, 'Agustus', 1997, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  401. (15090081, 'NABILA FEBBY UTAMI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 25, 'Februari', 1998, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  402. (15090082, 'AMIRUL MUSTAKIM', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 19, 'November', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  403. (15090083, 'NURUSSHOFA AL MUZAKI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 8, 'Januari', 1995, '', 'PEMALANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  404. (15090084, 'FITRIA TAHTA ALFINA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 7, 'April', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  405. (15090085, 'AGUS RIYANTO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 28, 'Agustus', 1995, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  406. (15090086, 'AFIDAH KHAIRINA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 28, 'Mei', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  407. (15090088, 'BUDI DARMAWAN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 12, 'Desember', 1997, '', 'TANGERANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  408. (15090089, 'IIN SUGIARTO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 3, 'Juni', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  409. (15090090, 'DIMAS ADITYA WIRAPRATAMA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 14, 'Maret', 1997, '', 'PENANDINGAN', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  410. (15090091, 'ARIF FIRMANSYAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 4, 'Juni', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  411. (15090092, 'EKA TESAR LAZUARDI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 16, 'Mei', 1997, '', 'PEMALANG', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  412. (15090094, 'SHABRINA DESIANA MAWARNI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 18, 'Desember', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  413. (15090096, 'SETIA BUDI SUSILO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 14, 'Juli', 1998, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  414. (15090097, 'GIAR AJI UBAEDAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 21, 'Mei', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  415. (15090098, 'FIKI CAHYANTO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 15, 'Oktober', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  416. (15090099, 'LANNY NADIA LIU', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Perempuan', 4, 'Desember', 1996, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  417. (15090100, 'MUMIN ZAZULI', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 6, 'Juli', 1997, '', 'BREBES', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  418. (15090103, 'AHMAD ZAKY AMMAR DANY', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 25, 'September', 1997, '', 'JAKARTA', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  419. (15090105, 'MOH. AKHIL AFRILIAWAN', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 25, 'April', 1998, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  420. (15090106, 'SULTHAN FALAH MURTADHO', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 4, 'September', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  421. (15090109, 'AMIN MAHMUD', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 16, 'Januari', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  422. (15090110, 'AZMI REGA PRATAMA', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 21, 'Oktober', 1997, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
  423. (15090113, 'MUHAMAD ARIF ARDIANSYAH', '827ccb0eea8a706c4c34a16891f84e7b', '', 'Laki - Laki', 6, 'Juli', 1996, '', 'TEGAL', '', 2015, NULL, 0, '0000-00-00 00:00:00', '2017-05-22 14:11:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1);
  424.  
  425. -- --------------------------------------------------------
  426.  
  427. --
  428. -- Struktur dari tabel `pembimbing`
  429. --
  430.  
  431. CREATE TABLE IF NOT EXISTS `pembimbing` (
  432.   `id_pembimbing` int(10) NOT NULL,
  433.   `id_kp` varchar(10) DEFAULT NULL,
  434.   `cdate` datetime DEFAULT NULL,
  435.   `mdate` datetime DEFAULT NULL,
  436.   `ddate` datetime DEFAULT NULL,
  437.   `deleted_flage` int(1) DEFAULT NULL
  438. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  439.  
  440. -- --------------------------------------------------------
  441.  
  442. --
  443. -- Struktur dari tabel `pembimbing_dosen`
  444. --
  445.  
  446. CREATE TABLE IF NOT EXISTS `pembimbing_dosen` (
  447.   `id_pembimbing_dosen` int(10) NOT NULL,
  448.   `id_pembimbing` int(10) DEFAULT NULL,
  449.   `id_dosen` varchar(20) DEFAULT NULL,
  450.   `cdate` datetime DEFAULT NULL,
  451.   `mdate` datetime DEFAULT NULL,
  452.   `ddate` datetime DEFAULT NULL
  453. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  454.  
  455. -- --------------------------------------------------------
  456.  
  457. --
  458. -- Struktur dari tabel `pembimbing_mahasiswa`
  459. --
  460.  
  461. CREATE TABLE IF NOT EXISTS `pembimbing_mahasiswa` (
  462.   `id_pembimbing_mahasiswa` int(10) NOT NULL,
  463.   `id_pembimbing` int(10) DEFAULT NULL,
  464.   `id_mahasiswa` int(20) DEFAULT NULL,
  465.   `id_kp_laporan` int(10) DEFAULT NULL,
  466.   `cdate` datetime DEFAULT NULL,
  467.   `mdate` datetime DEFAULT NULL,
  468.   `ddate` datetime DEFAULT NULL
  469. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  470.  
  471. -- --------------------------------------------------------
  472.  
  473. --
  474. -- Struktur dari tabel `sosial_link`
  475. --
  476.  
  477. CREATE TABLE IF NOT EXISTS `sosial_link` (
  478.   `id_sosial_link` int(5) NOT NULL,
  479.   `icon` varchar(100) DEFAULT NULL,
  480.   `link` longtext,
  481.   `cdate` datetime DEFAULT NULL
  482. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  483.  
  484. --
  485. -- Dumping data untuk tabel `sosial_link`
  486. --
  487.  
  488. INSERT INTO `sosial_link` (`id_sosial_link`, `icon`, `link`, `cdate`) VALUES
  489. (1, 'Facebook', 'https://web.facebook.com/groups/242495985935856/', '2017-04-13 11:35:29');
  490.  
  491. -- --------------------------------------------------------
  492.  
  493. --
  494. -- Struktur dari tabel `surat_ijin_kp`
  495. --
  496.  
  497. CREATE TABLE IF NOT EXISTS `surat_ijin_kp` (
  498.   `id_surat_ijin_kp` int(5) NOT NULL,
  499.   `nomor_surat` longtext,
  500.   `tgl_mulai` date DEFAULT NULL,
  501.   `jml_hari` int(5) DEFAULT NULL,
  502.   `email_d4` varchar(100) DEFAULT NULL,
  503.   `cdate` datetime DEFAULT NULL,
  504.   `nomor_surat_keluar` int(5) NOT NULL DEFAULT '0',
  505.   `tahun_print_terakhir` int(4) NOT NULL DEFAULT '2017'
  506. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  507.  
  508. --
  509. -- Dumping data untuk tabel `surat_ijin_kp`
  510. --
  511.  
  512. INSERT INTO `surat_ijin_kp` (`id_surat_ijin_kp`, `nomor_surat`, `tgl_mulai`, `jml_hari`, `email_d4`, `cdate`, `nomor_surat_keluar`, `tahun_print_terakhir`) VALUES
  513. (1, '10/TI.PHB', '2017-07-10', 52, '[email protected]', '2017-05-13 02:05:24', 2, 2017);
  514.  
  515. --
  516. -- Indexes for dumped tables
  517. --
  518.  
  519. --
  520. -- Indexes for table `admin`
  521. --
  522. ALTER TABLE `admin`
  523.   ADD PRIMARY KEY (`id_admin`);
  524.  
  525. --
  526. -- Indexes for table `bimbingan_online`
  527. --
  528. ALTER TABLE `bimbingan_online`
  529.   ADD PRIMARY KEY (`id_bimbingan_online`),
  530.   ADD KEY `id_mahasiswa` (`id_mahasiswa`),
  531.   ADD KEY `id_dosen` (`id_dosen`);
  532.  
  533. --
  534. -- Indexes for table `dashboard`
  535. --
  536. ALTER TABLE `dashboard`
  537.   ADD PRIMARY KEY (`id_dashboard`);
  538.  
  539. --
  540. -- Indexes for table `dashboard_file`
  541. --
  542. ALTER TABLE `dashboard_file`
  543.   ADD PRIMARY KEY (`id_dashboard_file`),
  544.   ADD KEY `id_dashboard` (`id_dashboard`);
  545.  
  546. --
  547. -- Indexes for table `dashboard_img`
  548. --
  549. ALTER TABLE `dashboard_img`
  550.   ADD PRIMARY KEY (`id_dashboard_img`);
  551.  
  552. --
  553. -- Indexes for table `deskripsi_kp`
  554. --
  555. ALTER TABLE `deskripsi_kp`
  556.   ADD PRIMARY KEY (`id_deskripsi_kp`);
  557.  
  558. --
  559. -- Indexes for table `dosen`
  560. --
  561. ALTER TABLE `dosen`
  562.   ADD PRIMARY KEY (`id_dosen`);
  563.  
  564. --
  565. -- Indexes for table `galeri`
  566. --
  567. ALTER TABLE `galeri`
  568.   ADD PRIMARY KEY (`id_galeri`);
  569.  
  570. --
  571. -- Indexes for table `kp`
  572. --
  573. ALTER TABLE `kp`
  574.   ADD PRIMARY KEY (`id_kp`);
  575.  
  576. --
  577. -- Indexes for table `kp_anggota`
  578. --
  579. ALTER TABLE `kp_anggota`
  580.   ADD PRIMARY KEY (`id_kp_anggota`),
  581.   ADD KEY `id_kp` (`id_kp`),
  582.   ADD KEY `id_mahasiswa` (`id_mahasiswa`);
  583.  
  584. --
  585. -- Indexes for table `kp_bimbingan`
  586. --
  587. ALTER TABLE `kp_bimbingan`
  588.   ADD PRIMARY KEY (`id_kp_bimbingan`),
  589.   ADD KEY `id_pembimbing` (`id_pembimbing`),
  590.   ADD KEY `id_kp` (`id_kp`),
  591.   ADD KEY `id_mahasiswa` (`id_mahasiswa`);
  592.  
  593. --
  594. -- Indexes for table `kp_harian`
  595. --
  596. ALTER TABLE `kp_harian`
  597.   ADD PRIMARY KEY (`id_kp_harian`),
  598.   ADD KEY `id_mahasiswa` (`id_mahasiswa`),
  599.   ADD KEY `id_pembimbing` (`id_pembimbing`),
  600.   ADD KEY `id_kp` (`id_kp`);
  601.  
  602. --
  603. -- Indexes for table `kp_laporan`
  604. --
  605. ALTER TABLE `kp_laporan`
  606.   ADD PRIMARY KEY (`id_kp_laporan`),
  607.   ADD KEY `id_kp` (`id_kp`);
  608.  
  609. --
  610. -- Indexes for table `kp_perusahaan`
  611. --
  612. ALTER TABLE `kp_perusahaan`
  613.   ADD PRIMARY KEY (`id_kp_perusahaan`),
  614.   ADD KEY `id_kp` (`id_kp`);
  615.  
  616. --
  617. -- Indexes for table `log_activity`
  618. --
  619. ALTER TABLE `log_activity`
  620.   ADD PRIMARY KEY (`id_log_activity`);
  621.  
  622. --
  623. -- Indexes for table `mahasiswa`
  624. --
  625. ALTER TABLE `mahasiswa`
  626.   ADD PRIMARY KEY (`id_mahasiswa`);
  627.  
  628. --
  629. -- Indexes for table `pembimbing`
  630. --
  631. ALTER TABLE `pembimbing`
  632.   ADD PRIMARY KEY (`id_pembimbing`),
  633.   ADD KEY `id_kp` (`id_kp`);
  634.  
  635. --
  636. -- Indexes for table `pembimbing_dosen`
  637. --
  638. ALTER TABLE `pembimbing_dosen`
  639.   ADD PRIMARY KEY (`id_pembimbing_dosen`),
  640.   ADD KEY `id_pembimbing` (`id_pembimbing`),
  641.   ADD KEY `id_dosen` (`id_dosen`);
  642.  
  643. --
  644. -- Indexes for table `pembimbing_mahasiswa`
  645. --
  646. ALTER TABLE `pembimbing_mahasiswa`
  647.   ADD PRIMARY KEY (`id_pembimbing_mahasiswa`),
  648.   ADD KEY `id_pembimbing` (`id_pembimbing`),
  649.   ADD KEY `id_mahasiswa` (`id_mahasiswa`),
  650.   ADD KEY `id_kp_laporan` (`id_kp_laporan`);
  651.  
  652. --
  653. -- Indexes for table `sosial_link`
  654. --
  655. ALTER TABLE `sosial_link`
  656.   ADD PRIMARY KEY (`id_sosial_link`);
  657.  
  658. --
  659. -- Indexes for table `surat_ijin_kp`
  660. --
  661. ALTER TABLE `surat_ijin_kp`
  662.   ADD PRIMARY KEY (`id_surat_ijin_kp`);
  663.  
  664. --
  665. -- AUTO_INCREMENT for dumped tables
  666. --
  667.  
  668. --
  669. -- AUTO_INCREMENT for table `admin`
  670. --
  671. ALTER TABLE `admin`
  672.   MODIFY `id_admin` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  673. --
  674. -- AUTO_INCREMENT for table `bimbingan_online`
  675. --
  676. ALTER TABLE `bimbingan_online`
  677.   MODIFY `id_bimbingan_online` int(10) NOT NULL AUTO_INCREMENT;
  678. --
  679. -- AUTO_INCREMENT for table `dashboard`
  680. --
  681. ALTER TABLE `dashboard`
  682.   MODIFY `id_dashboard` int(10) NOT NULL AUTO_INCREMENT;
  683. --
  684. -- AUTO_INCREMENT for table `dashboard_file`
  685. --
  686. ALTER TABLE `dashboard_file`
  687.   MODIFY `id_dashboard_file` int(10) NOT NULL AUTO_INCREMENT;
  688. --
  689. -- AUTO_INCREMENT for table `dashboard_img`
  690. --
  691. ALTER TABLE `dashboard_img`
  692.   MODIFY `id_dashboard_img` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
  693. --
  694. -- AUTO_INCREMENT for table `deskripsi_kp`
  695. --
  696. ALTER TABLE `deskripsi_kp`
  697.   MODIFY `id_deskripsi_kp` int(1) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  698. --
  699. -- AUTO_INCREMENT for table `galeri`
  700. --
  701. ALTER TABLE `galeri`
  702.   MODIFY `id_galeri` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  703. --
  704. -- AUTO_INCREMENT for table `kp_anggota`
  705. --
  706. ALTER TABLE `kp_anggota`
  707.   MODIFY `id_kp_anggota` int(10) NOT NULL AUTO_INCREMENT;
  708. --
  709. -- AUTO_INCREMENT for table `kp_bimbingan`
  710. --
  711. ALTER TABLE `kp_bimbingan`
  712.   MODIFY `id_kp_bimbingan` int(100) NOT NULL AUTO_INCREMENT;
  713. --
  714. -- AUTO_INCREMENT for table `kp_harian`
  715. --
  716. ALTER TABLE `kp_harian`
  717.   MODIFY `id_kp_harian` int(100) NOT NULL AUTO_INCREMENT;
  718. --
  719. -- AUTO_INCREMENT for table `kp_laporan`
  720. --
  721. ALTER TABLE `kp_laporan`
  722.   MODIFY `id_kp_laporan` int(10) NOT NULL AUTO_INCREMENT;
  723. --
  724. -- AUTO_INCREMENT for table `kp_perusahaan`
  725. --
  726. ALTER TABLE `kp_perusahaan`
  727.   MODIFY `id_kp_perusahaan` int(10) NOT NULL AUTO_INCREMENT;
  728. --
  729. -- AUTO_INCREMENT for table `log_activity`
  730. --
  731. ALTER TABLE `log_activity`
  732.   MODIFY `id_log_activity` int(100) NOT NULL AUTO_INCREMENT;
  733. --
  734. -- AUTO_INCREMENT for table `pembimbing`
  735. --
  736. ALTER TABLE `pembimbing`
  737.   MODIFY `id_pembimbing` int(10) NOT NULL AUTO_INCREMENT;
  738. --
  739. -- AUTO_INCREMENT for table `pembimbing_dosen`
  740. --
  741. ALTER TABLE `pembimbing_dosen`
  742.   MODIFY `id_pembimbing_dosen` int(10) NOT NULL AUTO_INCREMENT;
  743. --
  744. -- AUTO_INCREMENT for table `pembimbing_mahasiswa`
  745. --
  746. ALTER TABLE `pembimbing_mahasiswa`
  747.   MODIFY `id_pembimbing_mahasiswa` int(10) NOT NULL AUTO_INCREMENT;
  748. --
  749. -- AUTO_INCREMENT for table `sosial_link`
  750. --
  751. ALTER TABLE `sosial_link`
  752.   MODIFY `id_sosial_link` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  753. --
  754. -- AUTO_INCREMENT for table `surat_ijin_kp`
  755. --
  756. ALTER TABLE `surat_ijin_kp`
  757.   MODIFY `id_surat_ijin_kp` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  758. --
  759. -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
  760. --
  761.  
  762. --
  763. -- Ketidakleluasaan untuk tabel `bimbingan_online`
  764. --
  765. ALTER TABLE `bimbingan_online`
  766.   ADD CONSTRAINT `bimbingan_online_ibfk_1` FOREIGN KEY (`id_mahasiswa`) REFERENCES `mahasiswa` (`id_mahasiswa`),
  767.   ADD CONSTRAINT `bimbingan_online_ibfk_2` FOREIGN KEY (`id_dosen`) REFERENCES `dosen` (`id_dosen`);
  768.  
  769. --
  770. -- Ketidakleluasaan untuk tabel `dashboard_file`
  771. --
  772. ALTER TABLE `dashboard_file`
  773.   ADD CONSTRAINT `dashboard_file_ibfk_1` FOREIGN KEY (`id_dashboard`) REFERENCES `dashboard` (`id_dashboard`);
  774.  
  775. --
  776. -- Ketidakleluasaan untuk tabel `kp_anggota`
  777. --
  778. ALTER TABLE `kp_anggota`
  779.   ADD CONSTRAINT `kp_anggota_ibfk_1` FOREIGN KEY (`id_kp`) REFERENCES `kp` (`id_kp`),
  780.   ADD CONSTRAINT `kp_anggota_ibfk_2` FOREIGN KEY (`id_mahasiswa`) REFERENCES `mahasiswa` (`id_mahasiswa`);
  781.  
  782. --
  783. -- Ketidakleluasaan untuk tabel `kp_bimbingan`
  784. --
  785. ALTER TABLE `kp_bimbingan`
  786.   ADD CONSTRAINT `kp_bimbingan_ibfk_1` FOREIGN KEY (`id_pembimbing`) REFERENCES `pembimbing` (`id_pembimbing`),
  787.   ADD CONSTRAINT `kp_bimbingan_ibfk_2` FOREIGN KEY (`id_kp`) REFERENCES `kp` (`id_kp`),
  788.   ADD CONSTRAINT `kp_bimbingan_ibfk_3` FOREIGN KEY (`id_mahasiswa`) REFERENCES `mahasiswa` (`id_mahasiswa`);
  789.  
  790. --
  791. -- Ketidakleluasaan untuk tabel `kp_harian`
  792. --
  793. ALTER TABLE `kp_harian`
  794.   ADD CONSTRAINT `kp_harian_ibfk_1` FOREIGN KEY (`id_mahasiswa`) REFERENCES `mahasiswa` (`id_mahasiswa`),
  795.   ADD CONSTRAINT `kp_harian_ibfk_2` FOREIGN KEY (`id_pembimbing`) REFERENCES `pembimbing` (`id_pembimbing`),
  796.   ADD CONSTRAINT `kp_harian_ibfk_3` FOREIGN KEY (`id_kp`) REFERENCES `kp` (`id_kp`);
  797.  
  798. --
  799. -- Ketidakleluasaan untuk tabel `kp_laporan`
  800. --
  801. ALTER TABLE `kp_laporan`
  802.   ADD CONSTRAINT `kp_laporan_ibfk_1` FOREIGN KEY (`id_kp`) REFERENCES `kp` (`id_kp`);
  803.  
  804. --
  805. -- Ketidakleluasaan untuk tabel `kp_perusahaan`
  806. --
  807. ALTER TABLE `kp_perusahaan`
  808.   ADD CONSTRAINT `kp_perusahaan_ibfk_1` FOREIGN KEY (`id_kp`) REFERENCES `kp` (`id_kp`);
  809.  
  810. --
  811. -- Ketidakleluasaan untuk tabel `pembimbing`
  812. --
  813. ALTER TABLE `pembimbing`
  814.   ADD CONSTRAINT `pembimbing_ibfk_1` FOREIGN KEY (`id_kp`) REFERENCES `kp` (`id_kp`);
  815.  
  816. --
  817. -- Ketidakleluasaan untuk tabel `pembimbing_dosen`
  818. --
  819. ALTER TABLE `pembimbing_dosen`
  820.   ADD CONSTRAINT `pembimbing_dosen_ibfk_1` FOREIGN KEY (`id_pembimbing`) REFERENCES `pembimbing` (`id_pembimbing`),
  821.   ADD CONSTRAINT `pembimbing_dosen_ibfk_2` FOREIGN KEY (`id_dosen`) REFERENCES `dosen` (`id_dosen`);
  822.  
  823. --
  824. -- Ketidakleluasaan untuk tabel `pembimbing_mahasiswa`
  825. --
  826. ALTER TABLE `pembimbing_mahasiswa`
  827.   ADD CONSTRAINT `pembimbing_mahasiswa_ibfk_1` FOREIGN KEY (`id_pembimbing`) REFERENCES `pembimbing` (`id_pembimbing`),
  828.   ADD CONSTRAINT `pembimbing_mahasiswa_ibfk_2` FOREIGN KEY (`id_mahasiswa`) REFERENCES `mahasiswa` (`id_mahasiswa`),
  829.   ADD CONSTRAINT `pembimbing_mahasiswa_ibfk_3` FOREIGN KEY (`id_kp_laporan`) REFERENCES `kp_laporan` (`id_kp_laporan`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!