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

START TRANSACTION;



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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` int NOT NULL,
  `filename` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `uploaded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`id`, `filename`, `path`, `uploaded_at`) VALUES
(5, 'Kenaikan Pangkat', 'downloads/685b6405155fb_test.txt', '2025-06-25 02:26:31'),
(12, 'Pencatuman Gelar', 'downloads/685b645f47e50_test.txt', '2025-06-25 02:52:15'),
(13, 'Anjab/ABK', 'downloads/685b6511744f6_test.txt', '2025-06-25 02:55:13'),
(14, 'Ijin Belajar', 'downloads/685b653eb79ee_test.txt', '2025-06-25 02:55:58'),
(15, 'Mutasi', 'downloads/685b6560a2374_test.txt', '2025-06-25 02:56:32'),
(16, 'Kenaikan Gaji', 'downloads/685b65819c97d_test.txt', '2025-06-25 02:57:05'),
(17, 'Pensiun', 'downloads/685b65972b52e_test.txt', '2025-06-25 02:57:27'),
(18, 'SOTK', 'downloads/685b65a923c55_test.txt', '2025-06-25 02:57:45');

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

--
-- Table structure for table `pegawai`
--

CREATE TABLE `pegawai` (
  `id` int NOT NULL,
  `nama_pegawai` varchar(100) NOT NULL,
  `jenis_kelamin` enum('L','P') NOT NULL,
  `tempat_lahir` varchar(100) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `jabatan` varchar(100) NOT NULL,
  `no_hp` varchar(20) NOT NULL,
  `alamat` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pegawai`
--

INSERT INTO `pegawai` (`id`, `nama_pegawai`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `jabatan`, `no_hp`, `alamat`) VALUES
(1, 'hafiz', 'L', 'palang', '2025-06-08', 'lantai 1', '081234567890', 'palang indonesia');

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

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

--
-- AUTO_INCREMENT for table `files`
--
ALTER TABLE `files`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `pegawai`
--
ALTER TABLE `pegawai`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

