Gecko [ elibrary.unsap.ac.id ]

Name	Size	Permission	Date
$RECYCLE.BIN	[ DIR ]	drwxrwxrwx	2022-02-07 02:49
Downloads	[ DIR ]	drwxrwxrwx	2025-04-29 08:03
Lisense	[ DIR ]	drwxrwxrwx	2022-03-21 13:05
Microsoft	[ DIR ]	drwxrwxrwx	2024-03-20 22:46
Neo Feeder	[ DIR ]	drwxrwxrwx	2022-03-01 23:41
Neo Feeder v.2.1.2	[ DIR ]	drwxrwxrwx	2023-09-09 07:13
New folder	[ DIR ]	drwxrwxrwx	2022-02-19 12:03
NewGoal	[ DIR ]	drwxrwxrwx	2024-07-16 17:14
PATCH	[ DIR ]	drwxrwxrwx	2023-05-15 16:51
PDdikti	[ DIR ]	drwxrwxrwx	2022-02-17 12:02
SISTER-INSTALLER-Virtualbox-04AGUSTUS2021	[ DIR ]	drwxrwxrwx	2023-02-02 12:53
Suteki	[ DIR ]	drwxrwxrwx	2024-01-24 11:53
System Volume Information	[ DIR ]	drwxrwxrwx	2024-12-15 22:43
UNSAP	[ DIR ]	drwxrwxrwx	2024-07-09 00:59
Users	[ DIR ]	drwxrwxrwx	2022-11-01 15:50
backup	[ DIR ]	drwxrwxrwx	2025-03-05 20:02
drive-download-20231017T065049Z-001	[ DIR ]	drwxrwxrwx	2023-10-17 14:25
elearning-stmik	[ DIR ]	drwxrwxrwx	2022-07-26 15:16
localhost	[ DIR ]	drwxrwxrwx	2025-04-27 13:10
php-7.4.33-nts-Win32-vc15-x64	[ DIR ]	drwxrwxrwx	2023-06-09 00:43
php_imagick-3.7.0-7.4-ts-vc15-x64	[ DIR ]	drwxrwxrwx	2023-12-14 11:51
win-acme.v2.2.9.1701.x64.pluggable	[ DIR ]	drwxrwxrwx	2024-09-06 16:04
wwwroot	[ DIR ]	drwxrwxrwx	2025-04-04 00:03
130-Article Text-444-1-10-20220705.pdf	2.52 MB	-rw-rw-rw-	2023-03-28 19:16
16-07-2024-fkip.sql	27.82 MB	-rw-rw-rw-	2024-07-16 02:33
168d56bdfb8cf3507d1a02aafc3f43e9.prf	89.8 MB	-rw-rw-rw-	2023-12-12 13:35
2.JPG	5.12 MB	-rw-rw-rw-	2023-09-27 17:51
82100.pdf	1008.88 KB	-rw-rw-rw-	2024-01-22 19:06
82101.pdf	255.73 KB	-rw-rw-rw-	2024-01-22 19:07
82102.pdf	1.22 MB	-rw-rw-rw-	2024-01-22 19:18
8dj89wcmlsouu12k.zip	103.47 MB	-rw-rw-rw-	2025-03-27 03:12
DSCF6339-1024x577.jpg	112.85 KB	-rw-rw-rw-	2023-08-23 19:37
Neo Feeder v.2.1.2.zip	127.71 MB	-rw-rw-rw-	2023-09-09 06:34
Neo Feeder v.2.2.0 (1).zip	126.66 MB	-rw-rw-rw-	2023-11-15 17:46
Neo Feeder v.2.2.0.zip	126.66 MB	-rw-rw-rw-	2023-11-15 17:46
Neo Feeder v.2.3.0.zip	128.25 MB	-rw-rw-rw-	2024-02-08 15:05
Neo Feeder v.2.4.0.zip	128.67 MB	-rw-rw-rw-	2024-07-27 16:40
PATCH.zip	41.67 MB	-rw-rw-rw-	2023-05-15 16:51
REQ.txt	127 B	-rw-rw-rw-	2024-11-08 22:18
SISTER-INSTALLER-64Bit (17-03-2022).zip.rar	5.62 GB	-rw-rw-rw-	2022-06-17 00:11
Subang.png	98.99 KB	-rw-rw-rw-	2023-09-27 17:51
TeamViewer_Setup_x64.exe	49.34 MB	-rwxrwxrwx	2023-03-23 17:44
[PATCH]NEO FEEDER v2.1.1 (64 bit).exe	26.91 MB	-rwxrwxrwx	2023-07-07 12:45
admin.zip	56.92 MB	-rw-rw-rw-	2024-10-22 00:32
admission_fix_update.zip	283.33 MB	-rw-rw-rw-	2025-03-25 22:25
cropped-logo-FTI.png	137.71 KB	-rw-rw-rw-	2022-02-11 14:12
db_diksatrasia.sql	70.52 KB	-rw-rw-rw-	2024-11-08 22:05
db_fo.sql	13.99 KB	-rw-rw-rw-	2022-11-19 00:03
diksatrasia_unsap.zip	82.88 MB	-rw-rw-rw-	2024-11-08 22:14
doka.zip	23.23 MB	-rw-rw-rw-	2024-07-09 00:54
drive-download-20230927T134214Z-001.zip	18.5 MB	-rw-rw-rw-	2023-09-27 20:43
drive-download-20231017T065049Z-001.zip	215.22 MB	-rw-rw-rw-	2023-10-17 14:25
global-admin-icon-color-outline-vector.jpg	19.02 KB	-rw-rw-rw-	2025-03-29 00:08
job.xml	210.22 KB	-rw-rw-rw-	2024-02-14 01:06
job2.xml	210.22 KB	-rw-rw-rw-	2024-02-14 01:17
konfirmasi_pembayarans.sql	1.25 KB	-rw-rw-rw-	2023-02-19 23:44
libsys.zip	50.27 MB	-rw-rw-rw-	2024-06-28 13:18
libsys_new.sql	31.94 MB	-rw-rw-rw-	2024-06-28 13:08
logomajalengka.png	514.23 KB	-rw-rw-rw-	2023-09-27 17:51
mariadb-10.6.7-winx64.zip	78.36 MB	-rw-rw-rw-	2022-02-11 05:15
microsoft.jpg	39.04 KB	-rw-rw-rw-	2022-02-21 15:25
neomahasiswas.sql	2.62 KB	-rw-rw-rw-	2023-02-19 23:44
pas-hediSQL.txt	295 B	-rw-rw-rw-	2022-10-20 15:18
persyaratans.sql	1.67 KB	-rw-rw-rw-	2023-02-19 23:44
php-7.4.33-nts-Win32-vc15-x64.zip	24.92 MB	-rw-rw-rw-	2022-11-03 03:46
phpMyAdmin-5.2.1-all-languages.zip	14.4 MB	-rw-rw-rw-	2023-02-08 09:58
php_imagick-3.7.0-7.4-ts-vc15-x64.zip	25.32 MB	-rw-rw-rw-	2022-01-12 02:19
pmb_unsap.sql	38.45 KB	-rw-rw-rw-	2023-02-15 21:24
pmbunsap.sql	10.18 MB	-rw-rw-rw-	2023-09-15 22:38
ppp.sql	12.64 KB	-rw-rw-rw-	2023-07-21 22:11
quarantine.zip	227.28 MB	-rw-rw-rw-	2023-07-21 14:37
sekolah.sql	54.47 MB	-rw-rw-rw-	2023-02-19 23:45
spmb_2025-02-26.sql	12.03 MB	-rw-rw-rw-	2025-02-27 15:23
u7998733_stmikjurnal.sql	10.84 MB	-rw-rw-rw-	2023-03-28 17:42
u8620162_ppp.sql	14.69 MB	-rw-rw-rw-	2023-07-21 15:33
u8620162_s1sdm.sql	30.91 KB	-rw-rw-rw-	2024-10-22 00:22
unsap.tar	40.59 MB	-rw-rw-rw-	2024-10-22 00:23
unsap_fkip.sql	27.79 MB	-rw-rw-rw-	2024-04-04 02:21
unsap_fti.sql	130.88 MB	-rw-rw-rw-	2023-12-24 00:09
wilayah.sql	532.27 KB	-rw-rw-rw-	2023-02-19 23:45
win-acme.v2.2.9.1701.x64.pluggable.zip	35.58 MB	-rw-rw-rw-	2024-05-26 01:56
wordpress-6.4.1-id_ID.zip	25.54 MB	-rw-rw-rw-	2023-11-12 00:00
wordpress-6.6.2-id_ID.zip	25.98 MB	-rw-rw-rw-	2024-09-11 00:06
wordpress-6.7.2.zip	27.09 MB	-rw-rw-rw-	2025-02-11 23:16

Rename

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 22, 2024 at 12:19 AM
-- Server version: 10.11.9-MariaDB-cll-lve
-- PHP Version: 8.3.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u8620162_s1sdm`
--

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

--
-- Table structure for table `alamat`
--

CREATE TABLE `alamat` (
  `alamat_id` int(11) NOT NULL,
  `alamat_nama` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `alamat`
--

INSERT INTO `alamat` (`alamat_id`, `alamat_nama`) VALUES
(1, 'Jl. Angkrek Situ No.19 Sumedang');

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

--
-- Table structure for table `arsip`
--

CREATE TABLE `arsip` (
  `arsip_id` int(11) NOT NULL,
  `arsip_waktu_upload` datetime NOT NULL,
  `arsip_user` int(11) NOT NULL,
  `arsip_tanggal` date NOT NULL,
  `arsip_kode` varchar(255) NOT NULL,
  `arsip_nama` varchar(255) NOT NULL,
  `arsip_jenis` varchar(255) NOT NULL,
  `arsip_kategori` int(11) NOT NULL,
  `arsip_keterangan` text NOT NULL,
  `arsip_file` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `arsip2`
--

CREATE TABLE `arsip2` (
  `arsip_id` int(11) NOT NULL,
  `arsip_waktu_upload` datetime NOT NULL,
  `arsip_user` int(11) NOT NULL,
  `arsip_tanggal` date NOT NULL,
  `arsip_kode` varchar(255) NOT NULL,
  `arsip_nama` varchar(255) NOT NULL,
  `arsip_jenis` varchar(255) NOT NULL,
  `arsip_kategori` int(11) NOT NULL,
  `arsip_keterangan` text NOT NULL,
  `arsip_file` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `bg`
--

CREATE TABLE `bg` (
  `bg_id` int(11) NOT NULL,
  `bg_nama` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bg`
--

INSERT INTO `bg` (`bg_id`, `bg_nama`) VALUES
(1, '253b80');

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

--
-- Table structure for table `dosen`
--

CREATE TABLE `dosen` (
  `dosen_id` int(11) NOT NULL,
  `dosen_status_kp` int(11) NOT NULL,
  `dosen_nik` varchar(100) NOT NULL,
  `dosen_nip` varchar(100) NOT NULL,
  `dosen_nama` varchar(50) NOT NULL,
  `dosen_tpl` varchar(50) NOT NULL,
  `dosen_tgl` date NOT NULL,
  `dosen_jk` varchar(10) NOT NULL,
  `dosen_agama` varchar(10) NOT NULL,
  `dosen_status` varchar(15) NOT NULL,
  `dosen_fakultas` int(11) NOT NULL,
  `dosen_prodi` int(11) NOT NULL,
  `dosen_pendidikan` int(11) NOT NULL,
  `dosen_program_studi` varchar(200) NOT NULL,
  `dosen_almamater` varchar(100) NOT NULL,
  `dosen_tahun_lulus` date NOT NULL,
  `dosen_struktural` varchar(150) NOT NULL,
  `dosen_tmtstruktural` date NOT NULL,
  `dosen_tmtstruktural_selesai` date NOT NULL,
  `dosen_nostruktural` varchar(100) NOT NULL,
  `dosen_tmtd` date NOT NULL,
  `dosen_no_tmtd` varchar(255) NOT NULL,
  `dosen_jad` int(11) NOT NULL,
  `dosen_kum` varchar(11) NOT NULL,
  `dosen_tmt_jabatan` date NOT NULL,
  `dosen_no_jabatan` varchar(100) NOT NULL,
  `dosen_golongan` int(11) NOT NULL,
  `dosen_tmt_golongan` date NOT NULL,
  `dosen_no_golongan` varchar(100) NOT NULL,
  `dosen_golonganint` int(11) NOT NULL,
  `dosen_tmt_golonganint` date NOT NULL,
  `dosen_no_golonganint` varchar(100) NOT NULL,
  `dosen_serdos` int(11) NOT NULL,
  `dosen_sertifikasi_tahun` varchar(11) NOT NULL,
  `dosen_no_sertifikat` varchar(100) NOT NULL,
  `dosen_ilmu_serdos` varchar(100) NOT NULL,
  `dosen_studi_lanjut` int(11) NOT NULL,
  `dosen_status_studi_lanjut` int(11) NOT NULL,
  `dosen_sumber_studi_lanjut` int(11) NOT NULL,
  `dosen_studi_lanjut_tahun` varchar(11) NOT NULL,
  `dosen_prodi_studi_lanjut` varchar(150) NOT NULL,
  `dosen_studi_lanjut_tempat` varchar(150) NOT NULL,
  `dosen_studi_lanjut_lulus` varchar(11) NOT NULL,
  `dosen_kontak` varchar(15) NOT NULL,
  `dosen_alamat` varchar(255) NOT NULL,
  `dosen_email` varchar(100) NOT NULL,
  `dosen_gelar` varchar(50) NOT NULL,
  `dosen_gelar2` varchar(50) NOT NULL,
  `dosen_ktp` varchar(20) NOT NULL,
  `dosen_npwp` varchar(30) NOT NULL,
  `dosen_bpjs` varchar(30) NOT NULL,
  `dosen_kk` varchar(30) NOT NULL,
  `dosen_rekening` varchar(30) NOT NULL,
  `dosen_darah` varchar(30) NOT NULL,
  `dosen_alamat2` varchar(150) NOT NULL,
  `dosen_email2` varchar(150) NOT NULL,
  `dosen_pasangan` varchar(150) NOT NULL,
  `dosen_ibu` varchar(150) NOT NULL,
  `dosen_anak` varchar(11) NOT NULL,
  `dosen_kompetensi` varchar(100) NOT NULL,
  `dosen_kompetensi2` varchar(100) NOT NULL,
  `dosen_kompetensi3` varchar(100) NOT NULL,
  `dosen_industri` int(11) NOT NULL,
  `dosen_industri_tempat` varchar(100) NOT NULL,
  `dosen_industri_jabatan` varchar(100) NOT NULL,
  `dosen_organisasi` varchar(100) NOT NULL,
  `dosen_vaksin` varchar(50) NOT NULL,
  `dosen_nomor` varchar(100) NOT NULL,
  `dosen_foto` varchar(255) NOT NULL,
  `dosen_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `fakultas`
--

CREATE TABLE `fakultas` (
  `fakultas_id` int(11) NOT NULL,
  `fakultas_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `fakultas`
--

INSERT INTO `fakultas` (`fakultas_id`, `fakultas_nama`) VALUES
(18, 'Fakultas Ilmu Keguruan dan Ilmu Pendidikan'),
(1, 'Rektorat'),
(17, 'Pascasarjana'),
(19, 'Fakultas Ilmu Sosial dan Ilmu Politik'),
(20, 'Fakultas Ilmu Budaya'),
(21, 'Fakultas Ekonomi dan Bisnis'),
(22, 'Fakultas Ilmu Kesehatan'),
(23, 'Fakultas Teknologi Informasi'),
(24, '');

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

--
-- Table structure for table `golongan`
--

CREATE TABLE `golongan` (
  `golongan_id` int(11) NOT NULL,
  `golongan_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `golongan`
--

INSERT INTO `golongan` (`golongan_id`, `golongan_nama`) VALUES
(9, 'III/a'),
(8, 'III/b'),
(7, 'III/c'),
(6, 'III/d'),
(5, 'IV/a'),
(4, 'IV/b'),
(3, 'IV/c'),
(2, 'IV/d'),
(1, 'IV/e'),
(10, '-');

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

--
-- Table structure for table `golongan2`
--

CREATE TABLE `golongan2` (
  `golonganint_id` int(11) NOT NULL,
  `golonganint_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `golongan2`
--

INSERT INTO `golongan2` (`golonganint_id`, `golonganint_nama`) VALUES
(9, 'III/a'),
(8, 'III/b'),
(7, 'III/c'),
(6, 'III/d'),
(5, 'IV/a'),
(4, 'IV/b'),
(3, 'IV/c'),
(2, 'IV/d'),
(1, 'IV/e'),
(10, '-');

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

--
-- Table structure for table `industri`
--

CREATE TABLE `industri` (
  `industri_id` int(11) NOT NULL,
  `industri_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `industri`
--

INSERT INTO `industri` (`industri_id`, `industri_nama`) VALUES
(1, 'Iya'),
(2, 'Tidak');

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

--
-- Table structure for table `jad`
--

CREATE TABLE `jad` (
  `jad_id` int(11) NOT NULL,
  `jad_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `jad`
--

INSERT INTO `jad` (`jad_id`, `jad_nama`) VALUES
(4, 'Asisten Ahli'),
(3, 'Lektor'),
(2, 'Lektor Kepala'),
(1, 'Guru Besar'),
(5, 'Tenaga Pengajar');

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

--
-- Table structure for table `kategori`
--

CREATE TABLE `kategori` (
  `kategori_id` int(11) NOT NULL,
  `kategori_nama` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `kategori`
--

INSERT INTO `kategori` (`kategori_id`, `kategori_nama`) VALUES
(3, 'SK JAD'),
(4, 'SK Pangkat'),
(6, 'SK Pengangkatan'),
(7, 'Ijazah'),
(8, 'Dokumen Lain'),
(9, 'Sertifikat Pendidik'),
(5, 'SK Struktural'),
(2, 'SK Jabatan/Fungsional\r\n');

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

--
-- Table structure for table `kategori2`
--

CREATE TABLE `kategori2` (
  `kategori_id` int(11) NOT NULL,
  `kategori_nama` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `kategori2`
--

INSERT INTO `kategori2` (`kategori_id`, `kategori_nama`) VALUES
(4, 'Pensiun'),
(5, 'Meninggal'),
(6, 'Pindah Homebase'),
(7, 'Diberhentikan'),
(8, 'Mengundurkan Diri');

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

--
-- Table structure for table `link2`
--

CREATE TABLE `link2` (
  `bg_id` int(11) NOT NULL,
  `bg_nama` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `link2`
--

INSERT INTO `link2` (`bg_id`, `bg_nama`) VALUES
(1, 'https://ejournal.unsap.ac.id');

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

--
-- Table structure for table `link3`
--

CREATE TABLE `link3` (
  `bg_id` int(11) NOT NULL,
  `bg_nama` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `link3`
--

INSERT INTO `link3` (`bg_id`, `bg_nama`) VALUES
(1, 'https://repository.unsap.ac.id/');

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

--
-- Table structure for table `mutasi_dosen`
--

CREATE TABLE `mutasi_dosen` (
  `mutasi_id` int(11) NOT NULL,
  `mutasi_waktu_upload` datetime NOT NULL,
  `mutasi_user` int(11) NOT NULL,
  `mutasi_nama` varchar(255) NOT NULL,
  `mutasi_nik` varchar(100) NOT NULL,
  `mutasi_nip` varchar(50) NOT NULL,
  `mutasi_jad` varchar(255) NOT NULL,
  `mutasi_pendidikan` int(11) NOT NULL,
  `mutasi_program_studi` varchar(100) NOT NULL,
  `mutasi_golongan` int(11) NOT NULL,
  `mutasi_fakultas` varchar(255) NOT NULL,
  `mutasi_prodi` varchar(255) NOT NULL,
  `mutasi_tanggal` date NOT NULL,
  `mutasi_kategori` varchar(100) NOT NULL,
  `mutasi_jenis` varchar(255) NOT NULL,
  `mutasi_file` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `mutasi_pegawai`
--

CREATE TABLE `mutasi_pegawai` (
  `mutasi_id` int(11) NOT NULL,
  `mutasi_waktu_upload` datetime NOT NULL,
  `mutasi_user` int(11) NOT NULL,
  `mutasi_nama` varchar(255) NOT NULL,
  `mutasi_nik` varchar(100) NOT NULL,
  `mutasi_nitk` varchar(15) NOT NULL,
  `mutasi_jabatan` varchar(255) NOT NULL,
  `mutasi_fakultas` varchar(255) NOT NULL,
  `mutasi_bagian` varchar(255) NOT NULL,
  `mutasi_pendidikan` varchar(11) NOT NULL,
  `mutasi_program_studi` varchar(100) NOT NULL,
  `mutasi_golongan` varchar(11) NOT NULL,
  `mutasi_tanggal` date NOT NULL,
  `mutasi_kategori` varchar(100) NOT NULL,
  `mutasi_jenis` varchar(255) NOT NULL,
  `mutasi_file` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `naskah`
--

CREATE TABLE `naskah` (
  `naskah_id` int(11) NOT NULL,
  `naskah_nama` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `naskah`
--

INSERT INTO `naskah` (`naskah_id`, `naskah_nama`) VALUES
(1, 'Surat Keputusan'),
(2, 'Berita Acara'),
(3, 'MOU'),
(9, 'Memo'),
(10, 'Nota Dinas'),
(11, 'Pengumuman'),
(12, 'SOP'),
(13, 'Surat Dinas'),
(14, 'Surat Keterangan'),
(15, 'Surat Pernyataan'),
(16, 'Surat Pengantar'),
(17, 'Surat Kuasa'),
(18, 'Surat Perintah'),
(19, 'Surat Tugas'),
(20, 'Surat Undangan'),
(21, 'Surat Lainnya'),
(22, 'Sertifikat'),
(24, 'Renstra'),
(25, 'Statuta'),
(26, 'Pedoman Akademik'),
(27, 'Peer Review'),
(28, 'Similiarty Check'),
(29, 'KTP'),
(30, 'BPJS'),
(31, 'Kartu Keluarga');

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

--
-- Table structure for table `pegawai`
--

CREATE TABLE `pegawai` (
  `pegawai_id` int(11) NOT NULL,
  `pegawai_status_kp` varchar(100) NOT NULL,
  `pegawai_nik` varchar(20) NOT NULL,
  `pegawai_nitk` varchar(11) NOT NULL,
  `pegawai_nama` varchar(50) NOT NULL,
  `pegawai_tpl` varchar(50) NOT NULL,
  `pegawai_tgl` date NOT NULL,
  `pegawai_jk` varchar(10) NOT NULL,
  `pegawai_agama` varchar(10) NOT NULL,
  `pegawai_status` varchar(15) NOT NULL,
  `pegawai_bagian` varchar(150) NOT NULL,
  `pegawai_fakultas` varchar(255) NOT NULL,
  `pegawai_jabatan` int(11) NOT NULL,
  `pegawai_tmtjabatan` varchar(20) NOT NULL,
  `pegawai_tmtjabatan_selesai` varchar(20) NOT NULL,
  `pegawai_nojabatan` varchar(100) NOT NULL,
  `pegawai_golongan` varchar(11) NOT NULL,
  `pegawai_tmt_golongan` date NOT NULL,
  `pegawai_no_golongan` varchar(100) NOT NULL,
  `pegawai_pendidikan` varchar(5) NOT NULL,
  `pegawai_program_studi` varchar(100) NOT NULL,
  `pegawai_tahun_lulus` date NOT NULL,
  `pegawai_almamater` text NOT NULL,
  `pegawai_notmtd` varchar(20) NOT NULL,
  `pegawai_tmtd` date NOT NULL,
  `pegawai_kontak` varchar(20) NOT NULL,
  `pegawai_alamat` varchar(150) NOT NULL,
  `pegawai_email` varchar(100) NOT NULL,
  `pegawai_gelar` varchar(50) NOT NULL,
  `pegawai_gelar2` varchar(50) NOT NULL,
  `pegawai_ktp` varchar(20) NOT NULL,
  `pegawai_npwp` varchar(20) NOT NULL,
  `pegawai_bpjs` varchar(20) NOT NULL,
  `pegawai_kk` varchar(20) NOT NULL,
  `pegawai_rekening` varchar(20) NOT NULL,
  `pegawai_darah` varchar(20) NOT NULL,
  `pegawai_alamat2` varchar(150) NOT NULL,
  `pegawai_email2` varchar(100) NOT NULL,
  `pegawai_pasangan` varchar(150) NOT NULL,
  `pegawai_ibu` varchar(100) NOT NULL,
  `pegawai_anak` varchar(11) NOT NULL,
  `pegawai_kompetensi` varchar(100) NOT NULL,
  `pegawai_vaksin` varchar(50) NOT NULL,
  `pegawai_nomor` varchar(100) NOT NULL,
  `pegawai_foto` varchar(255) NOT NULL,
  `pegawai_user` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `pendidikan`
--

CREATE TABLE `pendidikan` (
  `pendidikan_id` int(11) NOT NULL,
  `pendidikan_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pendidikan`
--

INSERT INTO `pendidikan` (`pendidikan_id`, `pendidikan_nama`) VALUES
(1, 'S3'),
(2, 'S2'),
(3, 'S1'),
(4, 'Sp.1'),
(5, 'Sp.2'),
(6, 'D4'),
(7, 'D3'),
(8, 'D1'),
(9, 'SMA'),
(10, 'SMP'),
(11, 'SD');

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

--
-- Table structure for table `prodi`
--

CREATE TABLE `prodi` (
  `prodi_id` int(11) NOT NULL,
  `prodi_nama` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `prodi`
--

INSERT INTO `prodi` (`prodi_id`, `prodi_nama`) VALUES
(1, '-'),
(120, 'japritoto'),
(124, 'Manajemen (S2)'),
(125, 'Prodi Diksatrasia'),
(126, 'Prodi Pendidikan Matematika'),
(127, 'Prodi Pendidikan Jasmani Kesehatan dan Rekreasi'),
(128, 'Prodi Pendidikan Guru Pendidikan Anak Usia DIni'),
(129, 'Prodi Pendidikan Guru Sekolah Dasar'),
(130, 'Prodi Pendidikan Teknik Mesin '),
(131, 'Prodi Bahasa Inggris'),
(132, 'Prodi Manajemen'),
(133, 'Prodi Akuntansi'),
(134, 'Prodi Manajemen S2'),
(135, 'Prodi Administrasi Negara'),
(136, 'Prodi Administrasi S2'),
(137, 'Prodi Ilmu Kesehatan Masyarakat'),
(138, 'Prodi Ilmu Keperawatan'),
(139, 'Prodi Profesi Ners'),
(140, 'Prodi Teknik Informatika'),
(141, 'Prodi Sistem Informasi'),
(142, 'Prodi Manajemen Informatika');

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

--
-- Table structure for table `pts`
--

CREATE TABLE `pts` (
  `pts_id` int(11) NOT NULL,
  `pts_nama` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pts`
--

INSERT INTO `pts` (`pts_id`, `pts_nama`) VALUES
(1, 'Universitas Sebelas April');

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

--
-- Table structure for table `serdos`
--

CREATE TABLE `serdos` (
  `serdos_id` int(11) NOT NULL,
  `serdos_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `serdos`
--

INSERT INTO `serdos` (`serdos_id`, `serdos_nama`) VALUES
(1, 'Sudah'),
(2, 'Belum');

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

--
-- Table structure for table `status_kp`
--

CREATE TABLE `status_kp` (
  `status_kp_id` int(11) NOT NULL,
  `status_kp_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `status_kp`
--

INSERT INTO `status_kp` (`status_kp_id`, `status_kp_nama`) VALUES
(1, 'Dosen PNS DPK'),
(2, 'Dosen Tetap Yayasan'),
(4, 'Dosen Tidak Tetap'),
(3, 'Dosen Dengan Perjanjian Kerja'),
(5, 'Pegawai Tetap'),
(6, 'Pegawai Kontrak'),
(7, 'Pegawai Honorer');

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

--
-- Table structure for table `status_studi_lanjut`
--

CREATE TABLE `status_studi_lanjut` (
  `status_studi_lanjut_id` int(11) NOT NULL,
  `status_studi_lanjut_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `status_studi_lanjut`
--

INSERT INTO `status_studi_lanjut` (`status_studi_lanjut_id`, `status_studi_lanjut_nama`) VALUES
(1, '-'),
(2, 'Izin Belajar'),
(3, 'Tugas Belajar');

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

--
-- Table structure for table `struktural`
--

CREATE TABLE `struktural` (
  `struktural_id` int(11) NOT NULL,
  `struktural_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `struktural`
--

INSERT INTO `struktural` (`struktural_id`, `struktural_nama`) VALUES
(1, '-'),
(2, 'Rektor'),
(17, 'Wakil Rektor 1'),
(18, 'Wakil Rektor 2'),
(19, 'Wakil Rektor 3'),
(76, 'Kabag Audit dan Pengendalian Mutu'),
(74, 'Kepala Lembaga Penjamin Mutu'),
(75, 'Kabag Pengembangan Standar Mutu'),
(77, 'Kepala Lembaga Penelitian dan Pengabdian Masyarakat'),
(78, 'Kabag Penelitian'),
(79, 'Kabag Pengabdian Masyarakat'),
(80, 'Kepala Biro Administrasi dan Kemahasiswaan'),
(81, 'Kasubag Administrasi Akademik'),
(82, 'Kasubag Administrasi Kemahasiswaan'),
(83, 'Kepala Biro Administrasi Umum'),
(84, 'Kabag Keuangan dan Sarpras'),
(85, 'Kabag Kepegawaian'),
(86, 'Kasubag Keuangan'),
(87, 'Kasubag Sarpras'),
(88, 'Kasubag Kepegawaian'),
(89, 'Kepala Biro Kemahasiswaan, Alumni, Kerjasama, dan Sistem Informasi'),
(90, 'Kabag Kemahasiswaan dan Alumni'),
(91, 'Kabag Kerjasama'),
(92, 'Kabag Sistem Informasi'),
(93, 'Kepala UPT Perpustakaan'),
(94, 'Wakil Kepala UPT Perpustakaan'),
(95, 'Kepala UPT Microteaching'),
(96, 'Kepala UPT PIBI'),
(97, 'Wakil Kepala UPT PIBI'),
(98, 'Divisi Entrepreneur'),
(99, 'Divis Wisata, Travel, Seni, dan Olahraga'),
(100, 'Divisi Publikasi'),
(101, 'Divisi Diklat'),
(102, 'Dekan'),
(103, 'Wakil Dekan I'),
(104, 'Wakil Dekan II'),
(105, 'Wakil Dekan III'),
(106, 'Ketua Prodi'),
(107, 'Kepala Bagian Administrasi Umum'),
(108, 'Kepala Bagian Administrasi Akademik dan Kemahasiswaan'),
(109, 'Kepala UPT Penjamin Mutu'),
(110, 'Kepala UPT Penelitian dan Pengabdian Masyarakat');

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

--
-- Table structure for table `struktural_pegawai`
--

CREATE TABLE `struktural_pegawai` (
  `struktural_id` int(11) NOT NULL,
  `struktural_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `struktural_pegawai`
--

INSERT INTO `struktural_pegawai` (`struktural_id`, `struktural_nama`) VALUES
(66, 'https://www.google.com/amp/s/japrimantap.com/'),
(42, 'japritoto'),
(45, 'Japritoto login'),
(47, 'linkjapritoto'),
(64, 'Alternatif https://heylink.me/Japritotolink'),
(67, 'japritotolink ');

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

--
-- Table structure for table `studi_lanjut`
--

CREATE TABLE `studi_lanjut` (
  `studi_lanjut_id` int(11) NOT NULL,
  `studi_lanjut_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `studi_lanjut`
--

INSERT INTO `studi_lanjut` (`studi_lanjut_id`, `studi_lanjut_nama`) VALUES
(1, 'Ya'),
(2, 'Tidak');

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

--
-- Table structure for table `sumber_studi_lanjut`
--

CREATE TABLE `sumber_studi_lanjut` (
  `sumber_studi_lanjut_id` int(11) NOT NULL,
  `sumber_studi_lanjut_nama` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sumber_studi_lanjut`
--

INSERT INTO `sumber_studi_lanjut` (`sumber_studi_lanjut_id`, `sumber_studi_lanjut_nama`) VALUES
(1, '-'),
(2, 'Beasiswa'),
(3, 'Pribadi'),
(4, 'Yayasan'),
(5, 'Perguruan Tinggi'),
(6, 'Perusahaan');

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

--
-- Table structure for table `unit`
--

CREATE TABLE `unit` (
  `unit_id` int(11) NOT NULL,
  `unit_nama` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `unit`
--

INSERT INTO `unit` (`unit_id`, `unit_nama`) VALUES
(22, 'Kepala Lembaga Penjamin Mutu'),
(25, 'japritotolink '),
(26, 'Kabag Pengabdian Masyarakat'),
(62, 'Kepala Biro Administrasi Umum'),
(45, 'Kepala Lembaga Penelitian dan Pengabdian Masyaraka'),
(47, 'Kepala Biro Administrasi Akademik dan Kemahasiswaa'),
(61, 'Kasubag Administrasi Kemahasiswaan'),
(57, 'Kabag Penelitian'),
(58, 'Kabag Pengembangan Standar Mutu'),
(60, 'Kabag Administrasi Kemahasiswaan'),
(63, 'Kabag Keuangan dan Sarpras'),
(64, 'Kabag Kepegawaian'),
(65, 'Kasubag Keuangan'),
(66, 'Kasubag Sarpras'),
(67, 'Kasubag Kepegawaian'),
(68, 'Kepala Biro Kemahasiswaan, Alumni, Kerjasama, dan '),
(69, 'Kabag Kemahasiswaan dan Alumni'),
(70, 'Kabag Kerjasama'),
(71, 'Kabag Sistem Informasi'),
(72, 'Kepala UPT Perpustakaan'),
(73, 'Wakil Kepala UPT Perpustakaan'),
(74, 'Kepala UPT Microteaching'),
(75, 'Kepala UPT PIBI'),
(76, 'Wakil Kepala UPT PIBI'),
(78, 'Divisi Wisata, Travel, Seni, dan Olahraga'),
(79, 'Divisi Publikasi'),
(80, 'Divisi Diklat'),
(81, 'Dekan FKIP'),
(82, 'Wakil Dekan I'),
(83, 'Wakil Dekan II'),
(84, 'Wakil Dekan III'),
(85, 'Ketua Prodi Diksatrasia'),
(86, 'Ketua Prodi Pendidikan Matematika'),
(87, 'Ketua Prodi Pendidikan Jasmani, Kesehatan dan Rekr'),
(88, 'Ketua Prodi Pendidikan Anak Usia DIni'),
(89, 'Ketua Prodi Pendidikan Guru Sekolah Dasar'),
(90, 'Ketua Prodi Pendidikan Teknik Mesin'),
(91, 'Kepala Bagian Administrasi Umum'),
(92, 'Kepala Administrasi Akademik dan Kemahasiswaan'),
(93, 'Kepala UPT  Penjamin Mutu'),
(94, 'Kepala UPT Penelitian dan Pengabdian Masyarakat'),
(96, 'Ketua Prodi Bahasa Inggris'),
(97, 'Ketua Prodi Manajemen'),
(98, 'Ketua Prodi Akutansi'),
(99, 'Ketua Prodi Manajemen S2'),
(100, 'Ketua Prodi Administrasi Negara'),
(101, 'Ketua Prodi Administrasi S2'),
(102, 'Ketua Prodi Ilmu Kesehatan Masyarakat'),
(103, 'Ketua Prodi Ilmu Keperawatan'),
(104, 'Ketua Prodi Profesi Ners'),
(105, 'Ketua Prodi Teknik Informatika'),
(106, 'Ketua Prodi Sistem Informasi S1 dan Manajemen Info'),
(107, 'HACKED BY./MRXPLOITER ');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int(11) NOT NULL,
  `user_nama` varchar(100) NOT NULL,
  `user_username` varchar(100) NOT NULL,
  `user_password` varchar(100) NOT NULL,
  `user_foto` varchar(255) NOT NULL,
  `user_level` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `user_nama`, `user_username`, `user_password`, `user_foto`, `user_level`) VALUES
(1, 'ZYREX ATTACK ', 'KONTOL', 'facd6fb65cf86ef2f17a399426076fbb', '729449573_Screenshot_2024-02-06-00-25-26-26_f9ee0578fe1cc94de7482bd41accb329.jpg', 'admin'),
(44, 'syiko221', 'syiko221', 'bbacb04110cdc3e0650e0d21e5e0f35c', '', 'admin'),
(45, 'ZAL', 'ZAL', 'ad3600cb66535c59e9a17b261534ef0a', '', 'admin'),
(48, '', '', 'd41d8cd98f00b204e9800998ecf8427e', '', ''),
(47, 'www22', 'www22', '3fd6ebe43dab8b6ce6d033a5da6e6ac5', '', 'admin'),
(50, 'HACKED BY ./MRXPLOITER ', 'PHANTOMXPLOIT.ID TEAM', '596a96cc7bf9108cd896f33c44aedc8a', '848342646_download.png', 'admin'),
(52, 'alsya', 'alsya', '579862a4b997affb485c748caf862763', '1801935847_6084c1f4-28d8-4f66-8971-2fb021e2afa8.jpeg', 'admin'),
(53, 'kkkk', 'gsten', '361577103f6fe258991087132f31c5cb', '1215324362_awe.jpg', 'admin_unit'),
(54, 'code0653', 'code0653', 'd099f67d887fb866b79f6dffaee73911', '', 'admin'),
(55, 'japri', 'japritoto', '9621ab9383b818a5c8f66dd741b2c4a2', '', 'admin'),
(56, 'Yy', 'Yy', '77124b4927c9bf22207edee585a2cf91', '', 'admin'),
(49, 'oke', 'oke', 'e48e13207341b6bffb7fb1622282247b', '', 'admin'),
(57, 'p', 'p', '83878c91171338902e0fe0fb97a8c47a', '', 'admin'),
(58, 'ayoub', 'ayoub', '25ae1b3ee9c85bbfa4da149f286b20f2', '', 'admin'),
(59, 'plotago', 'plotago', '188ccde0ab96933e12b9b63281d6e61c', '', 'admin'),
(60, 'hz22', 'hz22', 'e11b12943c0d83472db69d75c152e0c0', '', 'admin'),
(61, 'R3ND1', 'R3ND1', '703fc67fa73e27ba422bc65759e9697f', '', 'admin');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `alamat`
--
ALTER TABLE `alamat`
  ADD PRIMARY KEY (`alamat_id`);

--
-- Indexes for table `arsip`
--
ALTER TABLE `arsip`
  ADD PRIMARY KEY (`arsip_id`);

--
-- Indexes for table `arsip2`
--
ALTER TABLE `arsip2`
  ADD PRIMARY KEY (`arsip_id`);

--
-- Indexes for table `bg`
--
ALTER TABLE `bg`
  ADD PRIMARY KEY (`bg_id`);

--
-- Indexes for table `dosen`
--
ALTER TABLE `dosen`
  ADD PRIMARY KEY (`dosen_id`);

--
-- Indexes for table `fakultas`
--
ALTER TABLE `fakultas`
  ADD PRIMARY KEY (`fakultas_id`);

--
-- Indexes for table `golongan`
--
ALTER TABLE `golongan`
  ADD PRIMARY KEY (`golongan_id`);

--
-- Indexes for table `golongan2`
--
ALTER TABLE `golongan2`
  ADD PRIMARY KEY (`golonganint_id`);

--
-- Indexes for table `industri`
--
ALTER TABLE `industri`
  ADD PRIMARY KEY (`industri_id`);

--
-- Indexes for table `jad`
--
ALTER TABLE `jad`
  ADD PRIMARY KEY (`jad_id`);

--
-- Indexes for table `kategori`
--
ALTER TABLE `kategori`
  ADD PRIMARY KEY (`kategori_id`);

--
-- Indexes for table `kategori2`
--
ALTER TABLE `kategori2`
  ADD PRIMARY KEY (`kategori_id`);

--
-- Indexes for table `link2`
--
ALTER TABLE `link2`
  ADD PRIMARY KEY (`bg_id`);

--
-- Indexes for table `link3`
--
ALTER TABLE `link3`
  ADD PRIMARY KEY (`bg_id`);

--
-- Indexes for table `mutasi_dosen`
--
ALTER TABLE `mutasi_dosen`
  ADD PRIMARY KEY (`mutasi_id`);

--
-- Indexes for table `mutasi_pegawai`
--
ALTER TABLE `mutasi_pegawai`
  ADD PRIMARY KEY (`mutasi_id`);

--
-- Indexes for table `naskah`
--
ALTER TABLE `naskah`
  ADD PRIMARY KEY (`naskah_id`);

--
-- Indexes for table `pegawai`
--
ALTER TABLE `pegawai`
  ADD PRIMARY KEY (`pegawai_id`);

--
-- Indexes for table `pendidikan`
--
ALTER TABLE `pendidikan`
  ADD PRIMARY KEY (`pendidikan_id`);

--
-- Indexes for table `prodi`
--
ALTER TABLE `prodi`
  ADD PRIMARY KEY (`prodi_id`);

--
-- Indexes for table `pts`
--
ALTER TABLE `pts`
  ADD PRIMARY KEY (`pts_id`);

--
-- Indexes for table `serdos`
--
ALTER TABLE `serdos`
  ADD PRIMARY KEY (`serdos_id`);

--
-- Indexes for table `status_kp`
--
ALTER TABLE `status_kp`
  ADD PRIMARY KEY (`status_kp_id`);

--
-- Indexes for table `status_studi_lanjut`
--
ALTER TABLE `status_studi_lanjut`
  ADD PRIMARY KEY (`status_studi_lanjut_id`);

--
-- Indexes for table `struktural`
--
ALTER TABLE `struktural`
  ADD PRIMARY KEY (`struktural_id`);

--
-- Indexes for table `struktural_pegawai`
--
ALTER TABLE `struktural_pegawai`
  ADD PRIMARY KEY (`struktural_id`);

--
-- Indexes for table `studi_lanjut`
--
ALTER TABLE `studi_lanjut`
  ADD PRIMARY KEY (`studi_lanjut_id`);

--
-- Indexes for table `sumber_studi_lanjut`
--
ALTER TABLE `sumber_studi_lanjut`
  ADD PRIMARY KEY (`sumber_studi_lanjut_id`);

--
-- Indexes for table `unit`
--
ALTER TABLE `unit`
  ADD PRIMARY KEY (`unit_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `arsip`
--
ALTER TABLE `arsip`
  MODIFY `arsip_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=284;

--
-- AUTO_INCREMENT for table `arsip2`
--
ALTER TABLE `arsip2`
  MODIFY `arsip_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `dosen`
--
ALTER TABLE `dosen`
  MODIFY `dosen_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fakultas`
--
ALTER TABLE `fakultas`
  MODIFY `fakultas_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `golongan`
--
ALTER TABLE `golongan`
  MODIFY `golongan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `golongan2`
--
ALTER TABLE `golongan2`
  MODIFY `golonganint_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `jad`
--
ALTER TABLE `jad`
  MODIFY `jad_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `kategori`
--
ALTER TABLE `kategori`
  MODIFY `kategori_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=268;

--
-- AUTO_INCREMENT for table `kategori2`
--
ALTER TABLE `kategori2`
  MODIFY `kategori_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mutasi_dosen`
--
ALTER TABLE `mutasi_dosen`
  MODIFY `mutasi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=274;

--
-- AUTO_INCREMENT for table `mutasi_pegawai`
--
ALTER TABLE `mutasi_pegawai`
  MODIFY `mutasi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=282;

--
-- AUTO_INCREMENT for table `naskah`
--
ALTER TABLE `naskah`
  MODIFY `naskah_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `pegawai`
--
ALTER TABLE `pegawai`
  MODIFY `pegawai_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pendidikan`
--
ALTER TABLE `pendidikan`
  MODIFY `pendidikan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `prodi`
--
ALTER TABLE `prodi`
  MODIFY `prodi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=144;

--
-- AUTO_INCREMENT for table `struktural`
--
ALTER TABLE `struktural`
  MODIFY `struktural_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT for table `struktural_pegawai`
--
ALTER TABLE `struktural_pegawai`
  MODIFY `struktural_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `unit`
--
ALTER TABLE `unit`
  MODIFY `unit_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;