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

START TRANSACTION;



--
-- Database: `pemilu`
--

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

--
-- Table structure for table `daftar_kegiatan`
--

CREATE TABLE `daftar_kegiatan` (
  `id` int(11) NOT NULL,
  `nomor` varchar(255) NOT NULL,
  `daftar_kegiatan` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `daftar_kegiatan`
--

INSERT INTO `daftar_kegiatan` (`id`, `nomor`, `daftar_kegiatan`) VALUES
(1, '1', 'Megawal Kotak Suara\r\ndi Balai desa'),
(2, '2', 'Pengambilan sumpah anggota KPPS');

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

--
-- Table structure for table `kegiatan`
--

CREATE TABLE `kegiatan` (
  `id` int(11) NOT NULL,
  `tps` varchar(255) NOT NULL,
  `nama_kegiatan` varchar(255) NOT NULL,
  `foto_kegiatan` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kegiatan`
--

INSERT INTO `kegiatan` (`id`, `tps`, `nama_kegiatan`, `foto_kegiatan`) VALUES
(16, 'tps4', 'Megawal Kotak Suara\r\ndi Balai desa', 'http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/photos/vyg4n7wth_ekclj.jpg'),
(17, 'tps4', 'Pengambilan sumpah anggota KPPS', 'http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/photos/7oqwxdluvgmzk5i.jpg,http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/photos/7j84nouztw30gcb.jpg'),
(19, 'tps2', 'Pengambilan sumpah anggota KPPS', 'http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/photos/_9m1p2bfu6ecs3k.jpg,http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/photos/7yoqim152frd6tk.jpg,http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/photos/o_1rewbj49dkyu8.jpg'),
(37, 'tps1', 'Megawal Kotak Suara\ndi Balai desa', 'http://localhost/pemilu/uploads/photos/Screenshot (1).png'),
(38, 'tps1', 'Pengambilan sumpah anggota KPPS', 'http://localhost/pemilu/uploads/photos/Screenshot (1).png'),
(39, 'tps1', 'Megawal Kotak Suara\ndi Balai desa', 'http://localhost/pemilu/uploads/photos/Screenshot (1).png');

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

--
-- Table structure for table `pengguna`
--

CREATE TABLE `pengguna` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `nama_pengguna` varchar(255) NOT NULL,
  `login_session_key` varchar(255) DEFAULT NULL,
  `email_status` varchar(255) DEFAULT NULL,
  `password_expire_date` datetime DEFAULT '2024-04-04 00:00:00',
  `password_reset_key` varchar(255) DEFAULT NULL,
  `user_role_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `pengguna`
--

INSERT INTO `pengguna` (`id`, `username`, `password`, `email`, `photo`, `nama_pengguna`, `login_session_key`, `email_status`, `password_expire_date`, `password_reset_key`, `user_role_id`) VALUES
(1, 'admin', '$2y$10$nPw/ooF1ZZ5HaghoI5K2xuo2GMP4U8ePus.8oynnmT53I0v50UAwW', 'admin@gmail.com', 'http://localhost/pemilu/uploads/files/ignf059au3_e4pq.PNG', 'Administrator', '1d40d63fd7215e6405004b8b3a12a9ad', NULL, '2024-04-04 00:00:00', NULL, 1),
(2, 'tps1', '$2y$10$CFo1M.jJ1Sq8r9CMaggEkO.qQOpUxmUg2SRD2WadSG26NMo4/mbRu', 'tps1@gmail.com', 'http://localhost/pemilu/uploads/files/_e2kxq7c8z6bnu1.jpeg', 'TPS1', NULL, NULL, '2024-04-04 00:00:00', NULL, 2),
(3, 'tps2', '$2y$10$QoUFHBhHjUKuJWo2eFFDnOHooJMqsYAKDmG2F2szHSxJu4JkztFfe', 'tps2@gmail.com', 'http://localhost/pemilu/uploads/files/dx2rea0i1qjwf6g.PNG', 'TPS 2', NULL, NULL, '2024-04-04 00:00:00', NULL, 2),
(4, 'tps3', '$2y$10$zRmDuaU/F3tRLAeQlcD6euPaoMdDwfJepyKdk2hVNAW5Ewh4NVkiS', 'tps3@gmail.com', 'http://localhost/pemilu/uploads/files/qiwtm9l_4cop1ry.png', 'TPS 3', '91295018c017b53eda758c37a1944794', NULL, '2024-04-04 00:00:00', NULL, 2),
(5, 'tps4', '$2y$10$DrCNvBliJCiVe9PSzi7M7.O4U7z6/MzxxRX.S7Cyks/xBfkzHXU6C', 'tps4@gmail.com', 'http://localhost/pemilu/uploads/files/p5tsr3uyd7igvaz.jpeg', 'TPS 4', 'dda7671e89fa7112a2a7b7db07142d55', NULL, '2024-04-04 00:00:00', NULL, 2),
(6, 'tps5', '$2y$10$8QvpbLPxWbtIHwZkbi0uAOZIDFvZ97//WgYP/8i1kd7aI9MRVTbBK', 'tps5@gmail.com', 'http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/files/8qjk7s0cn5apf4z.PNG', 'TPS 5', NULL, NULL, '2024-04-04 00:00:00', NULL, 2),
(7, 'tps6', '$2y$10$6GxXDDdiudhiO0YOzyWoF.jh6eq90IRSObtV64mRou/DA3qfIFUdS', 'tps6@gmail.com', 'http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/files/sy9ckzi47tfvr_b.png', 'TPS 6', NULL, NULL, '2024-04-04 00:00:00', NULL, 2),
(8, 'tps7', '$2y$10$vlr0CwRANaLXJ.RqdsT.xOBcjaU4clrApQKio.PMSapfIxbqaAK6O', 'tps7@gmail.com', 'http://smpnngusikan-28157.portmap.io:63394/pemilu/uploads/files/wr1lsveo93k76cz.jpeg', 'TPS 7', NULL, NULL, '2024-04-04 00:00:00', NULL, 2);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`role_id`, `role_name`) VALUES
(1, 'Administrator'),
(2, 'User');

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

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `permission_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `page_name` varchar(255) NOT NULL,
  `action_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` (`permission_id`, `role_id`, `page_name`, `action_name`) VALUES
(1171, 1, 'pengguna', 'list'),
(1172, 1, 'pengguna', 'view'),
(1173, 1, 'pengguna', 'add'),
(1174, 1, 'pengguna', 'edit'),
(1175, 1, 'pengguna', 'editfield'),
(1176, 1, 'pengguna', 'delete'),
(1177, 1, 'pengguna', 'import_data'),
(1178, 1, 'pengguna', 'accountedit'),
(1179, 1, 'pengguna', 'accountview'),
(1180, 1, 'kegiatan', 'list'),
(1181, 1, 'kegiatan', 'view'),
(1182, 1, 'kegiatan', 'add'),
(1183, 1, 'kegiatan', 'edit'),
(1184, 1, 'kegiatan', 'editfield'),
(1185, 1, 'kegiatan', 'delete'),
(1186, 1, 'role_permissions', 'list'),
(1187, 1, 'role_permissions', 'view'),
(1188, 1, 'role_permissions', 'add'),
(1189, 1, 'role_permissions', 'edit'),
(1190, 1, 'role_permissions', 'editfield'),
(1191, 1, 'role_permissions', 'delete'),
(1192, 1, 'roles', 'list'),
(1193, 1, 'roles', 'view'),
(1194, 1, 'roles', 'add'),
(1195, 1, 'roles', 'edit'),
(1196, 1, 'roles', 'editfield'),
(1197, 1, 'roles', 'delete'),
(1198, 1, 'isian_anggota', 'list'),
(1199, 1, 'daftar_kegiatan', 'list'),
(1200, 1, 'daftar_kegiatan', 'view'),
(1201, 1, 'daftar_kegiatan', 'add'),
(1202, 1, 'daftar_kegiatan', 'edit'),
(1203, 1, 'daftar_kegiatan', 'editfield'),
(1204, 1, 'daftar_kegiatan', 'delete'),
(1205, 2, 'pengguna', 'accountedit'),
(1206, 2, 'pengguna', 'accountview'),
(1207, 2, 'kegiatan', 'list'),
(1208, 2, 'kegiatan', 'view'),
(1209, 2, 'kegiatan', 'add'),
(1210, 2, 'kegiatan', 'edit'),
(1211, 2, 'kegiatan', 'editfield'),
(1212, 2, 'kegiatan', 'delete'),
(1213, 2, 'isian_anggota', 'list');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`role_id`),
  ADD UNIQUE KEY `role_name` (`role_name`);

--
-- Indexes for table `role_permissions`
--
ALTER TABLE `role_permissions`
  ADD PRIMARY KEY (`permission_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `daftar_kegiatan`
--
ALTER TABLE `daftar_kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kegiatan`
--
ALTER TABLE `kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `pengguna`
--
ALTER TABLE `pengguna`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `role_permissions`
--
ALTER TABLE `role_permissions`
  MODIFY `permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1214;
COMMIT;

