-- 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 `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 `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 `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;

