text: -- phpMyAdmin SQL Dump
  -- version 4.5.1
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 01, 2017 at 06:00 AM
  -- Server version: 10.1.16-MariaDB
  -- PHP Version: 5.5.38
  
  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: `hrd`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `absensi`
  --
  
  CREATE TABLE `absensi` (
    `id_absensi` int(6) NOT NULL,
    `departemen` varchar(30) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `no_id` int(10) NOT NULL,
    `tgl_waktu` datetime NOT NULL,
    `status` varchar(15) NOT NULL,
    `lokasi_finger` int(1) NOT NULL,
    `no_pin` int(10) NOT NULL,
    `kode_verifikasi` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cuti`
  --
  
  CREATE TABLE `cuti` (
    `kd_cuti` int(3) NOT NULL,
    `nip` varchar(15) NOT NULL,
    `tanggal_cuti` date NOT NULL,
    `tanggal_selesai` date NOT NULL,
    `jumlah_cuti` int(2) NOT NULL,
    `keterangan` text NOT NULL,
    `status` enum('Approved','Rejected') NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `cuti`
  --
  
  INSERT INTO `cuti` (`kd_cuti`, `nip`, `tanggal_cuti`, `tanggal_selesai`, `jumlah_cuti`, `keterangan`, `status`) VALUES
  (1, '32669954', '2015-12-20', '2015-12-31', 1, 'Umroh', 'Rejected');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `departemen`
  --
  
  CREATE TABLE `departemen` (
    `id_dep` varchar(10) NOT NULL,
    `departemen` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `jabatan`
  --
  
  CREATE TABLE `jabatan` (
    `id_jabatan` varchar(10) NOT NULL,
    `jabatan` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `karyawan`
  --
  
  CREATE TABLE `karyawan` (
    `nik` varchar(10) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `bagian` varchar(50) NOT NULL,
    `k1_join` date NOT NULL,
    `k1_finish` date NOT NULL,
    `k2_join` date NOT NULL,
    `k2_finish` date NOT NULL,
    `status` enum('tetap','kontrak','magang') NOT NULL,
    `gambar` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `karyawan`
  --
  
  INSERT INTO `karyawan` (`nik`, `nama`, `bagian`, `k1_join`, `k1_finish`, `k2_join`, `k2_finish`, `status`, `gambar`) VALUES
  ('01022017', 'Hakko BIo Richard', 'IT', '2016-02-01', '2017-03-01', '2017-03-01', '2017-06-01', 'kontrak', 'foto_member/pos.jpg');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `lembur`
  --
  
  CREATE TABLE `lembur` (
    `kd_lembur` int(10) NOT NULL,
    `nip` varchar(15) NOT NULL,
    `tanggal_lembur` date NOT NULL,
    `jam_lembur` int(10) NOT NULL,
    `keterangan` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user`
  --
  
  CREATE TABLE `user` (
    `user_id` int(2) NOT NULL,
    `username` varchar(30) NOT NULL,
    `password` varchar(30) NOT NULL,
    `fullname` varchar(50) NOT NULL,
    `no_hp` varchar(15) NOT NULL,
    `level` varchar(30) NOT NULL,
    `gambar` varchar(150) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `user`
  --
  
  INSERT INTO `user` (`user_id`, `username`, `password`, `fullname`, `no_hp`, `level`, `gambar`) VALUES
  (3, 'hakkobio', 'hakkobio', 'Hakko Bio RIchard', 'none', 'admin', 'gambar_admin/DistroIT.jpg');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `absensi`
  --
  ALTER TABLE `absensi`
    ADD PRIMARY KEY (`id_absensi`);
  
  --
  -- Indexes for table `cuti`
  --
  ALTER TABLE `cuti`
    ADD PRIMARY KEY (`kd_cuti`);
  
  --
  -- Indexes for table `departemen`
  --
  ALTER TABLE `departemen`
    ADD PRIMARY KEY (`id_dep`);
  
  --
  -- Indexes for table `jabatan`
  --
  ALTER TABLE `jabatan`
    ADD PRIMARY KEY (`id_jabatan`);
  
  --
  -- Indexes for table `karyawan`
  --
  ALTER TABLE `karyawan`
    ADD PRIMARY KEY (`nik`);
  
  --
  -- Indexes for table `lembur`
  --
  ALTER TABLE `lembur`
    ADD PRIMARY KEY (`kd_lembur`);
  
  --
  -- Indexes for table `user`
  --
  ALTER TABLE `user`
    ADD PRIMARY KEY (`user_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `cuti`
  --
  ALTER TABLE `cuti`
    MODIFY `kd_cuti` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `lembur`
  --
  ALTER TABLE `lembur`
    MODIFY `kd_lembur` int(10) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `user`
  --
  ALTER TABLE `user`
    MODIFY `user_id` int(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 */;
  