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

START TRANSACTION;



--
-- Database: `auth_system`
--

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `nama` varchar(100) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `kelas` varchar(10) DEFAULT NULL,
  `jurusan` varchar(50) DEFAULT NULL,
  `jabatan` varchar(50) DEFAULT NULL,
  `angkatan` year(4) DEFAULT NULL,
  `jenis_kelamin` enum('L','P') DEFAULT NULL,
  `role` enum('admin','user') NOT NULL DEFAULT 'user'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `users` (`id`, `nama`, `username`, `password`, `kelas`, `jurusan`, `jabatan`, `angkatan`, `jenis_kelamin`, `role`) VALUES
(1, '123', '123', '$2y$10$XcWhJQOi6OtmWfe2RW7M9eq9l.oaYjbGhsg6AunDWsVj8AnczWpaO', 'X', 'DPB', 'Ketua', NULL, NULL, 'user');

INSERT INTO users (nama, username, password, role)
VALUES ('Administrator', 'admin', '$2y$10$o8n6gA55/ER6/XzZFNHpzeI2zeYNYzs27ZAHQoLsNQrD4o/qE0LmS', 'admin');


--
-- Indexes for dumped tables
--

--
-- 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 `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

