text: -- phpMyAdmin SQL Dump
  -- version 4.6.5.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Dec 14, 2020 at 07:23 AM
  -- Server version: 10.1.21-MariaDB
  -- PHP Version: 7.1.1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `ams_native`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_disposisi`
  --
  
  CREATE TABLE `tbl_disposisi` (
    `id_disposisi` int(10) NOT NULL,
    `tujuan` varchar(250) NOT NULL,
    `isi_disposisi` mediumtext NOT NULL,
    `sifat` varchar(100) NOT NULL,
    `batas_waktu` date NOT NULL,
    `catatan` varchar(250) NOT NULL,
    `id_surat` int(10) NOT NULL,
    `id_user` tinyint(2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_instansi`
  --
  
  CREATE TABLE `tbl_instansi` (
    `id_instansi` tinyint(1) NOT NULL,
    `institusi` varchar(150) NOT NULL,
    `nama` varchar(150) NOT NULL,
    `status` varchar(150) NOT NULL,
    `alamat` varchar(150) NOT NULL,
    `kepsek` varchar(50) NOT NULL,
    `nip` varchar(25) NOT NULL,
    `website` varchar(50) NOT NULL,
    `email` varchar(50) NOT NULL,
    `logo` varchar(250) NOT NULL,
    `id_user` tinyint(2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_instansi`
  --
  
  INSERT INTO `tbl_instansi` (`id_instansi`, `institusi`, `nama`, `status`, `alamat`, `kepsek`, `nip`, `website`, `email`, `logo`, `id_user`) VALUES
  (1, 'Yayasan Indonesia Membangun', 'STIE INABA', 'Terakreditasi B', 'Jl Soekarno-Hatta No 448 , Kota Bandung, Jawa Barat', 'Dr. YOYO SUDARYO , S.E., M.M., Ak., C.A.', '0409126902', 'https://inaba.ac.id', 'support.it@inaba.ac.id', 'Logo-Inaba.png', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_klasifikasi`
  --
  
  CREATE TABLE `tbl_klasifikasi` (
    `id_klasifikasi` int(5) NOT NULL,
    `kode` varchar(30) NOT NULL,
    `nama` varchar(250) NOT NULL,
    `uraian` mediumtext NOT NULL,
    `id_user` tinyint(2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_klasifikasi`
  --
  
  INSERT INTO `tbl_klasifikasi` (`id_klasifikasi`, `kode`, `nama`, `uraian`, `id_user`) VALUES
  (3, 'ST', 'Surat Tugas', 'Surat Tugas Pegawai', 1),
  (4, 'SU', 'Surat Undangan', 'Surat Undangan', 1),
  (5, 'MOU', 'MOU', 'MOU', 1),
  (6, 'MOA', 'MOA', 'MOA', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_sett`
  --
  
  CREATE TABLE `tbl_sett` (
    `id_sett` tinyint(1) NOT NULL,
    `surat_masuk` tinyint(2) NOT NULL,
    `surat_keluar` tinyint(2) NOT NULL,
    `referensi` tinyint(2) NOT NULL,
    `id_user` tinyint(2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_sett`
  --
  
  INSERT INTO `tbl_sett` (`id_sett`, `surat_masuk`, `surat_keluar`, `referensi`, `id_user`) VALUES
  (1, 10, 10, 10, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_surat_keluar`
  --
  
  CREATE TABLE `tbl_surat_keluar` (
    `id_surat` int(10) NOT NULL,
    `no_agenda` int(10) NOT NULL,
    `tujuan` varchar(250) NOT NULL,
    `no_surat` varchar(50) NOT NULL,
    `isi` mediumtext NOT NULL,
    `referensi_surat` varchar(65) NOT NULL,
    `kode` varchar(30) NOT NULL,
    `tgl_surat` date NOT NULL,
    `tgl_catat` date NOT NULL,
    `file` varchar(250) NOT NULL,
    `keterangan` varchar(250) NOT NULL,
    `id_user` tinyint(2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_surat_keluar`
  --
  
  INSERT INTO `tbl_surat_keluar` (`id_surat`, `no_agenda`, `tujuan`, `no_surat`, `isi`, `referensi_surat`, `kode`, `tgl_surat`, `tgl_catat`, `file`, `keterangan`, `id_user`) VALUES
  (1, 1, 'test', '022', 'test', '011/IV/2020', 'ST', '2020-12-13', '2020-12-14', '6159-Implementasi_Association_Rules_dengan_Algoritma_Ap.pdf', 'test', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_surat_masuk`
  --
  
  CREATE TABLE `tbl_surat_masuk` (
    `id_surat` int(10) NOT NULL,
    `no_agenda` int(10) NOT NULL,
    `no_surat` varchar(50) NOT NULL,
    `asal_surat` varchar(250) NOT NULL,
    `isi` mediumtext NOT NULL,
    `referensi_surat` varchar(65) NOT NULL,
    `kode` varchar(30) NOT NULL,
    `indeks` varchar(30) NOT NULL,
    `tgl_surat` date NOT NULL,
    `tgl_diterima` date NOT NULL,
    `file` varchar(250) NOT NULL,
    `keterangan` varchar(250) NOT NULL,
    `id_user` tinyint(2) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_surat_masuk`
  --
  
  INSERT INTO `tbl_surat_masuk` (`id_surat`, `no_agenda`, `no_surat`, `asal_surat`, `isi`, `referensi_surat`, `kode`, `indeks`, `tgl_surat`, `tgl_diterima`, `file`, `keterangan`, `id_user`) VALUES
  (2, 1, '011/IV/2020', 'Kemeristek DIKTI', 'Undangan sosialisasi', '', 'SU', '1', '2020-03-01', '2020-03-01', '3037-srt edaran libur Nataldocx.pdf', 'Undangan sosialisasi', 3),
  (3, 2, '001/2020/12/LLDIKTI', 'LLDIKTI WIL IV', 'Surat Undangan Sosialisasi Prima', '', 'SU', '001', '2020-11-02', '2020-11-25', '143-APLIKASI SURAT PERJANJIAN KERJASAMA(MoU) PADA BIRO KERJASAMA UBIVERSITAS BINA DARMA PALEMBANG BERBASIS WEB.pdf', 'Undangan sosialisasi', 2),
  (4, 3, 'test', 'test', 'test', '001/2020/12/LLDIKTI', 'SU', 'test', '2020-12-14', '2020-12-14', '5468-Implementasi_Association_Rules_dengan_Algoritma_Ap.pdf', 'test', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_user`
  --
  
  CREATE TABLE `tbl_user` (
    `id_user` tinyint(2) NOT NULL,
    `username` varchar(30) NOT NULL,
    `password` varchar(35) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `nip` varchar(25) NOT NULL,
    `admin` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_user`
  --
  
  INSERT INTO `tbl_user` (`id_user`, `username`, `password`, `nama`, `nip`, `admin`) VALUES
  (2, 'admin', '7e89304e963d5cf4c384700c559ae0da', 'Rehan Hadiansah', '1', 1),
  (3, 'astrin', 'a386fd5ca1d5af8a88f171482ecdbb4c', 'astrin', '-', 3);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `tbl_disposisi`
  --
  ALTER TABLE `tbl_disposisi`
    ADD PRIMARY KEY (`id_disposisi`);
  
  --
  -- Indexes for table `tbl_instansi`
  --
  ALTER TABLE `tbl_instansi`
    ADD PRIMARY KEY (`id_instansi`);
  
  --
  -- Indexes for table `tbl_klasifikasi`
  --
  ALTER TABLE `tbl_klasifikasi`
    ADD PRIMARY KEY (`id_klasifikasi`);
  
  --
  -- Indexes for table `tbl_sett`
  --
  ALTER TABLE `tbl_sett`
    ADD PRIMARY KEY (`id_sett`);
  
  --
  -- Indexes for table `tbl_surat_keluar`
  --
  ALTER TABLE `tbl_surat_keluar`
    ADD PRIMARY KEY (`id_surat`);
  
  --
  -- Indexes for table `tbl_surat_masuk`
  --
  ALTER TABLE `tbl_surat_masuk`
    ADD PRIMARY KEY (`id_surat`);
  
  --
  -- Indexes for table `tbl_user`
  --
  ALTER TABLE `tbl_user`
    ADD PRIMARY KEY (`id_user`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `tbl_disposisi`
  --
  ALTER TABLE `tbl_disposisi`
    MODIFY `id_disposisi` int(10) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `tbl_klasifikasi`
  --
  ALTER TABLE `tbl_klasifikasi`
    MODIFY `id_klasifikasi` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  --
  -- AUTO_INCREMENT for table `tbl_surat_keluar`
  --
  ALTER TABLE `tbl_surat_keluar`
    MODIFY `id_surat` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `tbl_surat_masuk`
  --
  ALTER TABLE `tbl_surat_masuk`
    MODIFY `id_surat` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `tbl_user`
  --
  ALTER TABLE `tbl_user`
    MODIFY `id_user` tinyint(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  /*!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 */;
  