[BLOB]\"></strong></p>', 'sop');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `gambar` longtext DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `gambar`, `name`, `created_by`, `status`) VALUES
(7, 'Header.jpg', NULL, 1, 'aktif'),
(14, 'banner.png', NULL, 1, 'nonaktif'),
(16, 'dieng1.jpg', 'dieng', 5, 'nonaktif');

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

--
-- Table structure for table `survei_kepuasan`
--

CREATE TABLE `survei_kepuasan` (
  `id` int(11) NOT NULL,
  `sangat_puas` int(11) DEFAULT NULL,
  `puas` int(11) DEFAULT NULL,
  `kurang_puas` int(11) DEFAULT NULL,
  `tidak_puas` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `survei_kepuasan`
--

INSERT INTO `survei_kepuasan` (`id`, `sangat_puas`, `puas`, `kurang_puas`, `tidak_puas`) VALUES
(1, 1364, 421, 49, 61);

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

--
-- Table structure for table `users_role`
--

CREATE TABLE `users_role` (
  `id` int(11) NOT NULL,
  `roles_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users_role`
--

INSERT INTO `users_role` (`id`, `roles_name`) VALUES
(1, 'superadmin'),
(2, 'admin'),
(3, 'Kabupaten / Kota'),
(4, 'Akademik'),
(5, 'adminlbh'),
(6, 'validator');

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id_video` char(36) NOT NULL,
  `judul_video` text DEFAULT NULL,
  `thumbnail_video` mediumtext DEFAULT NULL,
  `link_youtube_video` text DEFAULT NULL,
  `publish_video` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`id_video`, `judul_video`, `thumbnail_video`, `link_youtube_video`, `publish_video`, `created_at`, `updated_at`, `deleted_at`) VALUES
('656a70da-7452-488d-89dd-4943b2916ea4', 'PODCAST JDIH JATENG EPISODE 2 \"Sinau Nang Biro Hukum\"', 'mq2.jpg', 'https://www.youtube.com/watch?v=sWIgfqiJap8', '1', '2023-03-27 02:47:29', '2023-04-17 04:45:50', NULL),
('737075d1-136f-4cef-b364-a279001e41ec', 'PODCAST JDIH JATENG EPISODE 1 \"Perda Perlindungan Anak\"', 'mq1.jpg', 'https://www.youtube.com/watch?v=Vj_Mz23lJfg', '1', '2023-03-27 02:45:52', '2023-04-17 04:46:27', NULL),
('b5a12ddf-f352-4579-b179-38d52dd76c33', 'PODCAST JDIH JATENG EPS 3 \"JDIH dan Layanan Hukum Terintegrasi untuk Biro Hukum yang semakin Ngayemi lan Nglayani\"', 'mq2.jpeg', 'https://www.youtube.com/watch?v=0Sxb_2bthkk', '1', '2023-04-17 04:44:13', '2023-04-17 05:02:29', NULL);

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

--
-- Table structure for table `visitor`
--

CREATE TABLE `visitor` (
  `id` int(11) NOT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `hits` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `online` varchar(30) DEFAULT NULL,
  `time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `visitor`
--

INSERT INTO `visitor` (`id`, `ip`, `hits`, `date`, `online`, `time`) VALUES
(1, '::1', 1, '2023-08-24', '1692860532', '2023-08-24 00:02:12');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- Indexes for table `inventarisasi_hukum`
--
ALTER TABLE `inventarisasi_hukum`
  ADD PRIMARY KEY (`id`),
  ADD KEY `no_peraturan` (`no_peraturan`);

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

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

--
-- Indexes for table `konfigurasi_periode_bankum`
--
ALTER TABLE `konfigurasi_periode_bankum`
  ADD PRIMARY KEY (`id_konfigurasi_periode`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `video`
--
ALTER TABLE `video`
  ADD PRIMARY KEY (`id_video`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for table `download`
--
ALTER TABLE `download`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `galeri`
--
ALTER TABLE `galeri`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `pelayanan_hukum`
--
ALTER TABLE `pelayanan_hukum`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `visitor`
--
ALTER TABLE `visitor`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

