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

START TRANSACTION;



--
-- Database: `pembuatansk`
--

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

--
-- Table structure for table `sk_library`
--

CREATE TABLE `sk_library` (
  `id` int NOT NULL,
  `judul` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `menimbang` text COLLATE utf8mb4_general_ci,
  `mengingat` text COLLATE utf8mb4_general_ci,
  `menetapkan` text COLLATE utf8mb4_general_ci,
  `file_pdf` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_word` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `nomor_surat` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tanggal_ditetapkan` date DEFAULT NULL,
  `npp` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nama_dekan` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  `api_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ai_model` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'gemini-2.5-flash',
  `ai_enabled` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `nama_lengkap`, `email`, `role_id`, `api_key`, `ai_model`, `ai_enabled`) VALUES
(12, '5812019362', '/pM0VsuGkf1FOLn9LOW7', 'Agus Cahyo Nugroho, S.Kom., M.T.', 'agus.nugroho@unika.ac.id', 3, NULL, 'gemini-2.5-flash', 1),
(13, '5811994158', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Prof Bernardinus Harnadi, S.T., M.T. PhD', 'bharnadi@unika.ac.id', 3, NULL, 'gemini-2.5-flash', 1),
(14, '5812015296', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Dr. Albertus Dwiyoga Widiantoro, S.Kom., M.Kom.', 'yoga@unika.ac.id', 3, NULL, 'gemini-2.5-flash', 1),
(15, '5811997206', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Fx. Hendra Prasetya, S.T., M.T.', 'hendra@unika.ac.id', 3, NULL, 'gemini-2.5-flash', 1),
(16, '5812002254', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Erdhi Widyarto Nugroho, S.T., M.T.', 'erdhi@unika.ac.id', 3, NULL, 'gemini-2.5-flash-lite', 1),
(17, '5811995177', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Dr. Ir. T. Brenda Ch, S.T., M.T.', 'brenda@unika.ac.id', 3, NULL, 'gemini-2.5-flash', 1),
(18, '5812023424', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Stephani Inggrit Swastini Dewi, S.Kom., MBA', 'stephaniinggrit@unika.ac.id', 3, NULL, 'gemini-2.5-flash-lite', 1),
(19, '5812021403', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Ir. Andre Kurniawan Pamudji, S.Kom., M.Ling', 'andre.kurniawan@unika.ac.id', 3, NULL, 'gemini-2.5-flash', 1),
(20, '5812002255', '$2y$10$aTpRl84y932U6bzDBxS9h.EAQtb7DvfYypl5AUYM2u1uOevgtE8RG', 'Prof Dr. Ridwan Sanjaya, S.Kom., MS.IEC', 'ridwan@unika.ac.id', 3, NULL, 'gemini-2.5-flash-lite', 1),
(26, '5852021299', '$2y$10$x7Ql5Tis/ibYVaxL0y4SuuaP3pXRlh3sHATaSENTt/PVfu4vhF1vG', 'Agustina Alam Anggitasari, SE., M.M.', 'agustinalam@unika.ac.id', 3, NULL, 'gemini-2.5-flash', 1);

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `sk_library`
--
ALTER TABLE `sk_library`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

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

