-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 08 Jun 2022 pada 07.14
-- Versi server: 10.4.18-MariaDB
-- Versi PHP: 7.3.27

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: `laboraty`
--

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

--
-- Struktur dari tabel `akses`
--

CREATE TABLE `akses` (
  `id_akses` int(10) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `akses_chrome` varchar(30) NOT NULL,
  `akses_ruskdesk` varchar(50) NOT NULL,
  `akses_anydesk` varchar(30) NOT NULL,
  `id_ruskdesk` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `akses`
--

INSERT INTO `akses` (`id_akses`, `updated_at`, `created_at`, `akses_chrome`, `akses_ruskdesk`, `akses_anydesk`, `id_ruskdesk`) VALUES
(0, '2022-05-24 20:10:22', '0000-00-00 00:00:00', '667788', ' rust 990667s', 'any 99000', ' 12333dd'),
(5, '2022-05-23 23:08:17', '2022-05-23 23:08:17', '667788', 'rust 990', 'any 99000', '');

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

--
-- Struktur dari tabel `berkas`
--

CREATE TABLE `berkas` (
  `id_berkas` int(5) NOT NULL,
  `nama` varchar(500) NOT NULL,
  `nim` varchar(500) NOT NULL,
  `berkas` varchar(500) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `berkas`
--

INSERT INTO `berkas` (`id_berkas`, `nama`, `nim`, `berkas`, `created_at`, `updated_at`) VALUES
(7, 'Agus', '5180211265', '1650574242_d657f8abfb6a4aa1dd93.pdf', '2022-04-21 15:50:42', '2022-04-21 15:50:42'),
(8, 'apri yaqin', '290099', '1653070878_72a4c7ac11bfcbae6a95.pdf', '2022-05-21 01:21:18', '2022-05-21 01:21:18'),
(9, 'apri yaqin', '290099', '1653140043_6fdedfdc83751a3117e2.rar', '2022-05-21 20:34:03', '2022-05-21 20:34:03');

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

--
-- Struktur dari tabel `task`
--

CREATE TABLE `task` (
  `id_task` int(5) NOT NULL,
  `keterangan` varchar(500) DEFAULT NULL,
  `kelas` varchar(10) NOT NULL,
  `nama_dosen` varchar(500) NOT NULL,
  `taks` varchar(500) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `task`
--

INSERT INTO `task` (`id_task`, `keterangan`, `kelas`, `nama_dosen`, `taks`, `updated_at`, `created_at`) VALUES
(9, 'module 12', 'D', 'Ahsin Apri .S. Kom,.M.sc', '5180411265_ahsin apri aenul_P14stastitic.pdf', '2022-04-21 15:14:24', '2022-04-21 15:14:24'),
(11, 'video', 'Mekatronik', 'ahsunak ahhkkn', '1653123969_ab8d6abd4fad8b771076.mp4', '2022-05-21 16:06:09', '2022-05-21 16:06:09'),
(12, 'fdgdfgs', 'r', 'dsgsg', '1653139954_9caaa86ee3b2d3b753e5.pdf', '2022-05-21 20:32:34', '2022-05-21 20:32:34');

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

--
-- Struktur dari tabel `user`
--

CREATE TABLE `user` (
  `id` int(5) NOT NULL,
  `nama` varchar(500) NOT NULL,
  `username` varchar(500) NOT NULL,
  `password` varchar(500) NOT NULL,
  `salt` varchar(500) NOT NULL,
  `role` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`id`, `nama`, `username`, `password`, `salt`, `role`) VALUES
(1, 'Ahsin Apri Aenul Yaqin', 'ahsinapri', 'a7ea66b2598d683e32a3dd9c09e51575626195a8756a81.06826470', '626195a8756a81.06826470', 2),
(2, 'Fahmi Aziz Syamsudin', 'fahmi', '41851c2c39e9729d51870dc74e098950626195d923b386.87657484', '626195d923b386.87657484', 1),
(3, 'rohmana jaya kusuma', 'rohmana', 'a208f47c041d59ca01d0ebdf69c2a37f62619749070902.15197083', '62619749070902.15197083', 2),
(4, 'Aldefa', 'aldefa', '1a1aadd06cd9d2f53e055f0b8d873ae0628ca508b07bb6.42688150', '628ca508b07bb6.42688150', 2),
(5, 'Stefanus Joy', 'stefanus', 'dcd77bfb4f33c913c46eadebd61e711d628ca5e27143b1.76876906', '628ca5e27143b1.76876906', 2),
(6, 'ayela', 'ayela', '9c404614ddec75383488ac11e224b943628cd509aa3610.30301120', '628cd509aa3610.30301120', 2),
(7, 'Zul Fahmi Hidayatullah', 'zulfahmy', '9234ec5efc6f0a66a7670dea0932be65628f8ea5516395.98504497', '628f8ea5516395.98504497', 2),
(8, 'sakura', 'sakura', 'd1df49745f75a81137379b4bfe46825862a002620a3828.74895190', '62a002620a3828.74895190', 2);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `akses`
--
ALTER TABLE `akses`
  ADD PRIMARY KEY (`id_akses`);

--
-- Indeks untuk tabel `berkas`
--
ALTER TABLE `berkas`
  ADD PRIMARY KEY (`id_berkas`);

--
-- Indeks untuk tabel `task`
--
ALTER TABLE `task`
  ADD PRIMARY KEY (`id_task`);

--
-- Indeks untuk tabel `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `berkas`
--
ALTER TABLE `berkas`
  MODIFY `id_berkas` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `task`
--
ALTER TABLE `task`
  MODIFY `id_task` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `user`
--
ALTER TABLE `user`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
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 */;
