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

START TRANSACTION;



--
-- Database: `gasd3326_arsip`
--

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

--
-- Table structure for table `data_arsip`
--

CREATE TABLE `data_arsip` (
  `id` int(11) NOT NULL,
  `noarsip` varchar(100) NOT NULL,
  `pencipta` varchar(255) NOT NULL,
  `unit_pengolah` varchar(255) NOT NULL,
  `tanggal` date NOT NULL,
  `uraian` text NOT NULL,
  `ket` varchar(100) NOT NULL,
  `kode` varchar(10) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `nobox` varchar(10) NOT NULL,
  `lokasi` varchar(255) NOT NULL,
  `media` varchar(255) NOT NULL,
  `file` text DEFAULT NULL,
  `tgl_input` datetime NOT NULL DEFAULT current_timestamp(),
  `tgl_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp(),
  `username` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_arsip`
--

INSERT INTO `data_arsip` (`id`, `noarsip`, `pencipta`, `unit_pengolah`, `tanggal`, `uraian`, `ket`, `kode`, `jumlah`, `nobox`, `lokasi`, `media`, `file`, `tgl_input`, `tgl_update`, `username`) VALUES
(169, '2736/LL4/PT/2023', '1', '7', '2023-03-28', 'PAK_GATOT TRI PRANOTO', '', '12', 0, '', 'Miskarniati - Pengolah Data', 'Universitas Pelita Bangsa', '', '2024-11-05 13:51:58', '0000-00-00 00:00:00', 'gatot.pranoto@trilogi.ac.id'),
(168, '02/SI/Trilogi/XI/2024', '1', '7', '2024-11-02', 'untuk keperluan skripsi mahasiswa', '', '12', 0, '', 'Admin Prodi', 'Keperluan Skripsi', '', '2024-11-02 11:02:49', '0000-00-00 00:00:00', 'gatot.pranoto@trilogi.ac.id'),
(170, '36/TRILOGI/REKTOR/KET/VIII/2024', '1', '7', '2024-11-06', 'SURAT UNDANGAN', '', '1', 0, '', 'MUFTI', 'UNIVERSITAS PANCA', '', '2024-11-06 10:18:35', '0000-00-00 00:00:00', 'fera_risina@trilogi.ac.id'),
(171, '01/lppm/XI/2024', '1', '7', '2024-11-06', 'gdhagdjagjkdg', '', '17', 0, '', 'YYYYY', 'xxxxs', '', '2024-11-06 11:01:08', '0000-00-00 00:00:00', 'rifqi@trilogi.ac.id'),
(172, '15/TRILOGI/KMH/V/2026', '1', '7', '2024-11-03', 'Permohonan tempat', '', '4', 0, '', 'Sri', 'Ukm', '', '2024-11-07 07:49:42', '0000-00-00 00:00:00', 'rossiiskandar@trilogi.ac.id'),
(173, '01/trilogi/2024', '1', '7', '2024-11-12', 'Surat Tugas', '', '12', 0, '', 'gasa', 'Dekan', '', '2024-11-12 17:59:05', '2024-11-12 17:59:26', 'tepe'),
(174, '03/BPP/Trilogi/XI/2025', '1', '7', '2024-11-22', 'apalah saja', '', '12', 0, '', 'susi', 'Mahasiswa', 'Pertemauan_Ke_1.pdf', '2024-11-22 06:29:59', '2024-11-22 06:45:47', 'tepe');

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

--
-- Table structure for table `master_kode`
--

CREATE TABLE `master_kode` (
  `id` int(11) NOT NULL,
  `kode` varchar(10) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `retensi` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `master_kode`
--

INSERT INTO `master_kode` (`id`, `kode`, `nama`, `retensi`) VALUES
(6, '06', 'Syafbrani, S.Pd.,M.M.', 0),
(7, '07', 'Warid, S.P., M.Si.', 0),
(8, '08', 'Maulidian, S.Hut., M.M.', 0),
(9, '09', 'Rizka Ramayanti, S.E., M.Si', 0),
(10, '10', 'Silvester Dian Handy Permana, S.T., M.T.I, CDS, CPro.', 0),
(1, '01', 'Dr. Duana Fera Risina, S.Pd., M.Pd.', 0),
(2, '02', 'Budi Septiono, S.H.', 0),
(3, '03', 'Dra. Sri Rahayuningsih, M.M.', 0),
(4, '04', 'Rossi Iskandar, S.Pd.I., M.Pd.', 0),
(5, '05', 'Riko Noviantoro Widiarso, S.St., M.AP', 0),
(18, '18', 'Erneza Dewi Krishnasari, S.Ds., M.Ds', 0),
(17, '17', 'Dr. Ahmad Rifqi Fauzi, S.P., M.Si', 0),
(16, '16', 'Rudi Setiawan, S.Kom., M.Cs.', 0),
(15, '15', 'Novita, S.E.Ak., M.Ak., C.A.', 0),
(14, '14', 'Lely Dahlia, S.E., M.AK., CertIPSAS.', 0),
(13, '13', 'Hendyansyah Putra, S.E., M.M.', 0),
(12, '12', 'Gatot Tri Pranoto, S.Kom, M.Kom.', 0),
(11, '11', 'Wahyu Hidayat, S.E.', 0),
(19, '19', 'Dr. Aty Herawati', 0),
(20, '20', 'Sri Opti, S.E.Ak., M.M., CA.', 0),
(21, '21', 'Fanny Suzuda Pohan, S.E., M.M.', 0),
(22, '22', 'Dr. Mangasi Panjaitan', 0),
(23, '23', 'Dwi Sunu Kanto, Ph.D.', 0),
(24, '24', 'Winda Amelia, S.Pd., M.Pd.', 0),
(25, '25', 'Dr. Roostrianawahti Soekmono', 0),
(26, '26', 'Dr. Dina Nurul Fitria, S.E.,MT.,CSCA.,CRP.', 0),
(27, '27', 'Damar Rangga Putra, S.Sn. M.Ds', 0),
(28, '28', 'Oki Kurniawan, S.Ds., M.Ds.', 0),
(29, '29', 'Ir. Yaddarabullah, M.Kom., Asean.Eng.', 0),
(30, '30', 'Umar Al Faruq, S.Kom., M.Kom.', 0),
(31, '31', 'Dr. Arman, SP., M.Si.', 0),
(32, '32', 'Hermawan Seftiono, S.Si., M.Si.', 0),
(33, '33', 'Zed Abdullah, S.E., M.Si.', 0),
(37, '34', 'Prof. Dr. Pramono Hari Adi, MS.', 0),
(38, '35', 'Dr. Dendi Anggi Gumilang, SE., MM.', 0),
(39, '36', 'Dr. Anies Lastiati, MHRM., M.Ed.St., CA.', 0),
(40, '37', 'tepe', 0);

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

--
-- Table structure for table `master_lokasi`
--

CREATE TABLE `master_lokasi` (
  `id` int(11) NOT NULL,
  `nama_lokasi` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `master_lokasi`
--

INSERT INTO `master_lokasi` (`id`, `nama_lokasi`) VALUES
(1, 'GEDUNG REKTORAT LANTAI 5'),
(7, 'Lantai Dasar Dosen B'),
(8, 'Mahasiswa');

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

--
-- Table structure for table `master_media`
--

CREATE TABLE `master_media` (
  `id` int(11) NOT NULL,
  `nama_media` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `master_media`
--

INSERT INTO `master_media` (`id`, `nama_media`) VALUES
(5, 'SOFT COPY ( PC )'),
(12, 'SOFT COPY ( PC'),
(8, 'HARD COPY'),
(13, 'Mahasiswa');

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

--
-- Table structure for table `master_pencipta`
--

CREATE TABLE `master_pencipta` (
  `id` int(11) NOT NULL,
  `nama_pencipta` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `master_pencipta`
--

INSERT INTO `master_pencipta` (`id`, `nama_pencipta`) VALUES
(1, 'Gatot');

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

--
-- Table structure for table `master_pengolah`
--

CREATE TABLE `master_pengolah` (
  `id` int(11) NOT NULL,
  `nama_pengolah` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `master_pengolah`
--

INSERT INTO `master_pengolah` (`id`, `nama_pengolah`) VALUES
(7, 'Sekretariat Rektorat');

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

--
-- Table structure for table `sirkulasi`
--

CREATE TABLE `sirkulasi` (
  `id` int(11) NOT NULL,
  `noarsip` varchar(100) NOT NULL,
  `username_peminjam` varchar(255) NOT NULL,
  `keperluan` text DEFAULT NULL,
  `tgl_pinjam` datetime NOT NULL,
  `tgl_haruskembali` datetime NOT NULL,
  `tgl_pengembalian` datetime DEFAULT NULL,
  `tgl_transaksi` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `system_log`
--

CREATE TABLE `system_log` (
  `id` int(11) NOT NULL,
  `kode_transaksi` varchar(100) NOT NULL,
  `username_transaksi` varchar(255) NOT NULL,
  `tgl_transaksi` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `data_arsip`
--
ALTER TABLE `data_arsip`
  ADD PRIMARY KEY (`id`),
  ADD KEY `noarsip` (`noarsip`),
  ADD KEY `pencipta` (`pencipta`),
  ADD KEY `unit_pengolah` (`unit_pengolah`);
ALTER TABLE `data_arsip` ADD FULLTEXT KEY `uraian` (`uraian`);

--
-- Indexes for table `master_kode`
--
ALTER TABLE `master_kode`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode` (`kode`),
  ADD KEY `nama` (`nama`);

--
-- Indexes for table `master_lokasi`
--
ALTER TABLE `master_lokasi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nama_lokasi` (`nama_lokasi`);

--
-- Indexes for table `master_media`
--
ALTER TABLE `master_media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nama_media` (`nama_media`);

--
-- Indexes for table `master_pencipta`
--
ALTER TABLE `master_pencipta`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nama_pencipta` (`nama_pencipta`);

--
-- Indexes for table `master_pengolah`
--
ALTER TABLE `master_pengolah`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nama_pengolah` (`nama_pengolah`);

--
-- Indexes for table `sirkulasi`
--
ALTER TABLE `sirkulasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `noarsip` (`noarsip`),
  ADD KEY `username_peminjam` (`username_peminjam`),
  ADD KEY `tgl_pinjam` (`tgl_pinjam`),
  ADD KEY `tgl_pengembalian` (`tgl_pengembalian`),
  ADD KEY `tgl_haruskembali` (`tgl_haruskembali`);

--
-- Indexes for table `system_log`
--
ALTER TABLE `system_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kode_transaksi` (`kode_transaksi`),
  ADD KEY `username_transaksi` (`username_transaksi`),
  ADD KEY `tgl_transaksi` (`tgl_transaksi`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

