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

START TRANSACTION;



--
-- Database: `msdmikim_ami`
--

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

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

CREATE TABLE `users` (
  `id` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) DEFAULT 'admin123',
  `role` enum('ADMIN','AUDITOR','AUDITEE','AUDITOR_AUDITEE','SPM','KETUA_AUDIT') NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_active` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `username`, `password`, `role`, `unit`, `email`, `phone`, `created_at`, `updated_at`, `is_active`) VALUES
('1', 'Imelda', 'admin', 'admin123', 'SPM', 'Lembaga Penjaminan Mutu', 'spm@iki.ac.id', NULL, '2025-12-07 11:25:39', '2026-03-09 22:04:30', 1),
('u1772763830755', 'Sari Sarce Andriana, S.Kep.,Ners.,M.Pd', 'Sari', '123456', 'AUDITOR', '', 'Sari@iki.ac.id', '+6281313513727', '2026-03-05 19:23:49', '2026-05-07 02:25:45', 1),
('u1772763885650', 'Iriyanti Harun, S.KM.,M.Gizi', 'Iriyanti ', '123456', 'AUDITOR', '', 'Iriyanti@iki.ac.id', '+628114190183', '2026-03-05 19:24:44', '2026-05-07 02:26:30', 1),
('u1772763911676', 'Bdn. Imelda MG Sianipar, SST.,M.Keb', 'Imelda', '123456', 'AUDITOR', '', 'Imelda@iki.ac.id', '+6285220881004', '2026-03-05 19:25:10', '2026-05-07 02:26:53', 1),
('u1772763957384', 'Juliyanti S.Kep.,Ners.,M.Si', 'Juliyanti', 'Dosa310816', 'AUDITOR', '', 'Juliyanti@iki.ac.id', '+6285221440085', '2026-03-05 19:25:56', '2026-05-07 02:27:20', 1),
('u1772763988400', 'Berlyn D. Saragih, S.Kep.,Ners.,M.Kep', 'Berlyn ', '123456', 'AUDITOR', '', 'Berlyn@iki.ac.id', '+6281394399919', '2026-03-05 19:26:27', '2026-05-07 02:28:10', 1),
('u1772764084281', 'Ira Ocktavia Siagian, M.Kep.,Ns.,Sp.Kep.J', 'Ira', '123456', 'AUDITOR', '', 'Ira@iki.ac.id', '+6285317286118', '2026-03-05 19:28:03', '2026-05-07 02:28:32', 1),
('u1772764118167', 'Ria Angelina, S.Kep.,Ners.,M.Kep', 'Ria', '123456', 'AUDITOR', '', 'Ria@iki.ac.id', '+6281394100097', '2026-03-05 19:28:37', '2026-05-07 02:28:54', 1),
('u1772764203494', 'Widawati, SKM.,MKM', 'Widawati', '123456', 'AUDITOR', '', 'Widawati@iki.ac.id', '+6281318671200', '2026-03-05 19:30:02', '2026-05-07 02:29:11', 1),
('u1772764236090', 'Yuliati Widiastuti, S.Gz.,RD.,M.Gz.,AIFO', 'Yuliati ', '123456', 'AUDITOR', '', 'Yuliati@iki.ac.id', '+6281323909985', '2026-03-05 19:30:35', '2026-05-07 02:29:42', 1),
('u1772764265359', 'Asysyfa Riana, S.Gz.,MT.,AIFO', 'Asysyfa ', '123456', 'AUDITOR', '', 'Asysyfa@iki.ac.id', '+628112342986', '2026-03-05 19:31:04', '2026-05-07 02:30:08', 1),
('u1772764317901', 'Widyadari Prasetyaningrum, S.Kep.,Ners.,M.Kep', 'Widyadari ', '123456', 'AUDITOR', '', 'Widyadari@iki.ac.id', '+6282260246602', '2026-03-05 19:31:57', '2026-05-07 02:31:05', 1),
('u1772764345877', 'Tri Ardayani, S.Kep.,Ners.,MKM', 'Tri', '123456', 'AUDITOR', '', 'Tri@iki.ac.id', '+6281312914013', '2026-03-05 19:32:24', '2026-05-07 02:31:28', 1),
('u1772764391734', 'Yuliani, SE.,MM', 'Yuliani', '123456', 'AUDITOR', '', 'Yuliani@iki.ac.id', '+6281312914013', '2026-03-05 19:33:10', '2026-05-07 02:31:58', 1),
('u1772764456769', 'Stephanie Melia, S.Kep.,Ners.,MNS', 'Stephanie ', '521984', 'AUDITOR', '', 'Stephanie@iki.ac.id', '+6281296290231', '2026-03-05 19:34:15', '2026-05-07 02:32:20', 1),
('u1772764498174', 'Dr. Dian Ekawati, SE.,MM', 'Dian ', '123456', 'AUDITOR', '', 'Dian@iki.ac.id', '+6282118211309', '2026-03-05 19:34:57', '2026-05-07 02:33:08', 1),
('u1772764525807', 'Sundariningsih, S.ST.,M.Tr.Keb', 'Sundariningsih', '123456', 'AUDITOR', '', 'Sundariningsih@iki.ac.id', '+6282117333890', '2026-03-05 19:35:24', '2026-05-07 02:33:26', 1),
('u1772765288023', 'Srihesty Manan,S.Kep.,Ners.,M.Kes.AIFO.', 'Srihesty', '423156', 'AUDITEE', 'S1 Keperawatan', '', '+6285213545977', '2026-03-05 19:48:07', '2026-05-07 02:33:43', 1),
('u1772765347316', 'Bdn. Hani Triana, SST.,MKes.', 'Hani ', '021117', 'AUDITEE', 'S1 Kebidanan,Profesi Bidan', '', '+6281809389359', '2026-03-05 19:49:06', '2026-05-07 02:34:28', 1),
('u1772765393404', 'Galuh Chandra Irawan,SKM.,M.Gizi, AIFO', 'Galuh ', '123456', 'AUDITEE', 'S1 Gizi', 'Galuh@iki.ac.id', '+6285156367253', '2026-03-05 19:49:52', '2026-05-07 03:59:39', 1),
('u1772765424154', 'Neti Sitorus, SST.,M.Kes.', 'Neti ', '123456', 'AUDITEE', 'S1 Ilmu Kesehatan Masyarakat', '', '+6282219320841', '2026-03-05 19:50:23', '2026-05-07 02:37:00', 1),
('u1772765544843', 'Kristin Sihombing, SKM.MMRS', 'Kristin ', '123456', 'AUDITEE', 'D3 Manajemen Pelayanan Rumah Sakit', 'Kristin@iki.ac.id', '+6281322610227', '2026-03-05 19:52:23', '2026-05-07 02:40:45', 1),
('u1772766205516', 'Fahmi Fuadah,SST.,M.Kes.', 'Fahmi ', '123456', 'AUDITEE', 'UPT Perpustakaan', '', '+6285222608180', '2026-03-05 20:03:24', '2026-05-07 02:41:05', 1),
('u1772766299339', 'Yuli Yulianti, SST.', 'Yuli ', '123456', 'AUDITEE', 'Bagian Keuangan', 'Yuli@iki.ac.id', '+6283839364939', '2026-03-05 20:04:58', '2026-05-07 02:41:29', 1),
('u1772766341098', 'Dr.Gurdani Yogisutanti,SKM.,M.Sc', 'Gurdani', '123456', 'AUDITEE', 'Lembaga Penelitian & Pengabdian Masyarakat', 'Gurdani@iki.ac.id', '+6281395461573', '2026-03-05 20:05:40', '2026-05-07 02:43:26', 1),
('u1772766386952', 'Dr. Antonius Ngadiran,S.Kep.,Ners, M.Kep.,M.Pd', 'Antonius ', '123456', 'AUDITEE', 'Wakil Rektor II', '', '+6282117337439', '2026-03-05 20:06:26', '2026-05-07 02:44:12', 1),
('u1772766417697', 'Ns.Yunus Adhy Prasetyo S.Kep.,MNS, Ph.D', 'Yunus ', '123456', 'AUDITEE', 'Wakil Rektor III', '', '+6281290044813', '2026-03-05 20:06:56', '2026-05-07 02:43:49', 1),
('u1772858643903', 'Bagus Taryana, S.Psi, MM', 'Bagus', '123456', 'AUDITEE', 'Bagian Sumber Daya Manusia', 'Bagus@iki.ac.id', '085156194701', '2026-03-07 04:44:03', '2026-05-07 02:43:06', 1),
('u1772858735848', 'Reynaldi Tresnajaya, ST.,MM', 'Reynaldi', '123456', 'AUDITOR', '', 'Reynaldi@iki.ac.id', '+62817264763', '2026-03-07 04:45:35', '2026-05-07 02:42:57', 1),
('u1772868283118', 'Lidya Maryani, S.Kep.,Ners.,M.M.,M.Kep', 'Lidya', '123456', 'AUDITOR', '', '', '+6285793005055', '2026-03-07 07:24:43', '2026-05-07 02:42:27', 1),
('u1772868326548', 'Liliek Fauziah, S. Kep., Ners., M. Kep', 'Liliek ', '123456', 'AUDITEE', 'D3 Keperawatan', 'bagustaryana@gmail.com', '+628996881248', '2026-03-07 07:25:26', '2026-05-07 03:43:32', 1),
('u1772889399068', 'Monika Ginting, S.Kep.,Ners.,M.Kep', 'monika', '123456', 'AUDITOR', '', 'Monika@iki.ac.id', '+6282211116201', '2026-03-07 13:16:39', '2026-05-07 02:42:00', 1),
('u1773031904100', 'Ardhini Dwi Utari, Skep, Ners', 'Ardhini ', '123456', 'AUDITOR', '', 'Ardhini@iki.ac.id', '+6281312808787', '2026-03-08 21:51:44', '2026-05-07 02:40:18', 1),
('u1773052848512', 'Bdn. Henni Purnasari, SST.,M.Kes.', 'Henni', '123456', 'AUDITEE', 'D3 Kebidanan', 'Henni@iki.ac.id', '+6285720333672', '2026-03-09 03:40:48', '2026-05-07 02:36:40', 1),
('u1773371674531', 'Lidya Natalia, S.Kep.Ners.,MS.', 'Lidya N', 'sariwates18', 'AUDITEE', 'Program Profesi Ners', 'LidyaN@iki.ac.id', '+628122515600', '2026-03-13 03:14:34', '2026-05-07 02:36:17', 1),
('u1773372880333', 'Lia Dahlia Yuliana, SE.', 'Lia ', '123456', 'AUDITEE', 'Sarana Prasarana', 'Lia@iki.ac.id', '+6289508405986', '2026-03-13 03:34:40', '2026-05-07 02:35:49', 1),
('u1773567421844', 'Dr. Anni Sinaga, S.Kp., M.Kep', 'Anni', '123456', 'AUDITEE', 'Wakil Rektor I', 'Anni@iki.ac.id', '+6281394350894', '2026-03-15 09:37:01', '2026-05-07 02:35:29', 1),
('u1775444712346', 'ketuaaudit', 'ketuaaudit', '123456', 'KETUA_AUDIT', '', 'ketuaaudit@iki.ac.id', NULL, '2026-04-06 03:05:12', '2026-04-06 03:05:12', 1);

--
-- Indexes for dumped tables
--

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

