-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `e_arsip`
--

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

--
-- Table structure for table `dokumen`
--

CREATE TABLE `dokumen` (
  `id` int(11) NOT NULL,
  `nama_dokumen` text NOT NULL,
  `keterangan` text NOT NULL,
  `file` varchar(20) NOT NULL,
  `size` varchar(100) NOT NULL,
  `id_jenis_dokumen` int(3) NOT NULL,
  `tahun_dokumen` varchar(4) NOT NULL,
  `id_upload` int(4) NOT NULL DEFAULT '1',
  `nomor_dokumen` varchar(20) NOT NULL,
  `unduh` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dokumen`
--

INSERT INTO `dokumen` (`id`, `nama_dokumen`, `keterangan`, `file`, `size`, `id_jenis_dokumen`, `tahun_dokumen`, `id_upload`, `nomor_dokumen`, `unduh`, `created_at`, `updated_at`) VALUES
(1, 'Memo Pimpinan', '<p>test</p>\r\n', '5uhuM.pdf', '0', 1, '2014', 1, 'KS01', 0, '2020-02-04 20:11:56', '2020-02-04 20:11:56'),
(2, 'TES', '<p>-</p>\r\n', 'J1fM1.pdf', '0', 2, '2014', 3, 'KS01', NULL, '2020-02-05 22:27:11', '2020-02-05 22:27:11'),
(3, 'Test Dokumen Nomor 3', '<p>Cuma test saja</p>\r\n', 'xHiu3.pdf', '0', 6, '2019', 3, 'KS03', NULL, '2020-02-06 18:09:32', '2020-02-06 18:09:32'),
(4, 'SK Penempatan Odan', '<p>Surat dari provinsi</p>\r\n', 'EjY8D.pdf', '0', 7, '2020', 3, 'SK01', NULL, '2020-02-06 18:22:23', '2020-02-06 18:22:23'),
(5, 'Ini adalah Dokumen Test 01', '<p>-</p>\r\n', 'QvAdi.jpg', '0', 3, '2019', 4, 'test01', NULL, '2020-02-21 01:52:41', '2020-02-20 17:52:41');

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

--
-- Table structure for table `jenis_dokumen`
--

CREATE TABLE `jenis_dokumen` (
  `id` int(11) NOT NULL,
  `jenis_dokumen` text NOT NULL,
  `lihat_dokumen` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jenis_dokumen`
--

INSERT INTO `jenis_dokumen` (`id`, `jenis_dokumen`, `lihat_dokumen`) VALUES
(1, 'Memo', 'Restirected'),
(2, 'Surat Edaran', 'Open'),
(3, 'Komitmen Mutu', 'Open'),
(4, 'Standar Mutu', 'Open'),
(5, 'Sertifikat', 'Open'),
(6, 'Monitoring Data', 'Restirected'),
(7, 'SK Dinas', 'Only Me');

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

--
-- Table structure for table `pengaturan`
--

CREATE TABLE `pengaturan` (
  `id` int(11) NOT NULL,
  `icon` varchar(100) NOT NULL,
  `bg` varchar(100) NOT NULL,
  `logo` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pengaturan`
--

INSERT INTO `pengaturan` (`id`, `icon`, `bg`, `logo`) VALUES
(1, 'favicon.ico', 'bg.jpg', 'logo.png');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `dokumen`
--
ALTER TABLE `dokumen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jenis_dokumen`
--
ALTER TABLE `jenis_dokumen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pengaturan`
--
ALTER TABLE `pengaturan`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dokumen`
--
ALTER TABLE `dokumen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `jenis_dokumen`
--
ALTER TABLE `jenis_dokumen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

