-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 14, 2023 at 04:30 AM
-- Server version: 10.4.17-MariaDB
-- PHP Version: 7.4.13
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `db_lembaga`
--
-- --------------------------------------------------------
--
-- Table structure for table `agenda`
--
CREATE TABLE `agenda` (
`agenda_id` int(11) NOT NULL,
`tema` varchar(200) DEFAULT NULL,
`slug_tema` varchar(200) DEFAULT NULL,
`gambar` varchar(200) DEFAULT NULL,
`isi_agenda` text DEFAULT NULL,
`tempat` varchar(120) DEFAULT NULL,
`pengirim` varchar(100) DEFAULT NULL,
`tgl_mulai` date DEFAULT NULL,
`tgl_selesai` date DEFAULT NULL,
`tgl_posting` date DEFAULT NULL,
`jam` varchar(100) DEFAULT NULL,
`hits` int(11) DEFAULT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`sts` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `agenda`
--
INSERT INTO `agenda` (`agenda_id`, `tema`, `slug_tema`, `gambar`, `isi_agenda`, `tempat`, `pengirim`, `tgl_mulai`, `tgl_selesai`, `tgl_posting`, `jam`, `hits`, `id`, `sts`) VALUES
(2, 'Bimtek Pengelolaan Website Dinas Versi terbaru', 'bimtek-pengelolaan-website-dinas-versi-terbaru', '1627956974_0377753d26438dc3142d.png', ' Bimtek ini bertujuan untuk memberikan pelatihan agar Administrator OPD dapat memanfaatkan semua fitur secara optimal.
', 'Kantor Dinas Pemuda dan Olahraga', 'Datagoe Software', '2021-09-09', '2021-09-10', '2021-08-03', '09.00 - selesai', 58, 1, NULL),
(3, 'Pembahasan Verifikasi Usulan Rencana Kerja dan Anggaran TA 2021', 'pembahasan-verifikasi-usulan-rencana-kerja-dan-anggaran-ta-2021', 'default.png', 'Rapat penting yang berfungsi untuk membahas berbagai isu strategis dengan ribu ratu Lembata, terkhusus di bidang pemuda olahraga dan kebudayaan.
', 'Kantor Dinas BKD Keuangan Kab. Lembata', 'Dinas BKD Keuangan', '2021-09-12', '2021-09-13', '2021-06-02', '09.00 - selesai', 80, 1, NULL),
(4, 'Gelar Rapat Persiapan Pengadaan Barang dan Jasa TA 2021', 'gelar-rapat-persiapan-pengadaan-barang-dan-jasa-ta-2021', 'default.png', 'Mempersiapkan data-data penunjang kinerja setiap instansi yang merupakan hal penting dalam pengolaan pengadaan barang dan jasa yang profesional dan akuntabel.
', 'Kantor Dinas Pemuda dan Olahraga', 'Dinas Kominfo Kab. Lembata', '2021-09-11', '2021-09-11', '2021-06-02', '09.00 - selesai', 95, 1, NULL),
(5, 'Rapat Tindak Lanjuti PP Nomor 49 Tahun 2020', 'rapat-tindak-lanjuti-pp-nomor-49-tahun-2020', 'default.png', ' Mengingat Peraturan Perundangan yang belum maksimal dilaksanakan, maka akan dilaksanan rapat konsolidasi setiap OPD yang ada di Pemerintahan daerah Kabupaten Lembata.
', 'Kantor Dinas Pemuda dan Olahraga', 'Dinas Kominfo Kabupaten Lembata', '2021-10-01', '2021-10-01', '2021-06-03', '08.00 - selesai', 99, 1, NULL),
(8, 'Rilies Update CMS Versi 3.0.2', 'rilies-update-cms-versi-302', 'default.png', ' Untuk meningkatkan kenyamanan dalam penggunaan CMS maka akan segera dibuka workshop CMS Datagoe', 'Lembata - NTT', 'Datagoe Software', '2022-04-25', '2022-04-26', '2022-04-23', '08 sampai selesai', 38, 1, NULL),
(9, 'El Tari Memorial Cup Ke-31 Tahun 2022', 'el-tari-memorial-cup-ke-31-tahun-2022', 'default.png', 'Kompetisi sepak bola liga III zona Nusa Tenggara Timur, El Tari Memorial Cup (ETMC) ke – 31 tahun 2022 akan digelar di Kabupaten Lembata NTT
', 'Gelora 99 Kabupaten Lembata', 'Disporabud', '2022-07-01', '2022-07-31', '2022-06-17', '14.00 - Selesai', 41, 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `bankdata`
--
CREATE TABLE `bankdata` (
`bankdata_id` int(11) NOT NULL,
`nama_bankdata` varchar(200) DEFAULT NULL,
`fileupload` varchar(200) DEFAULT NULL,
`slug_bank` varchar(255) DEFAULT NULL,
`tgl_upload` date DEFAULT NULL,
`hits` int(11) DEFAULT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`sts` varchar(1) DEFAULT NULL,
`ket` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `bankdata`
--
INSERT INTO `bankdata` (`bankdata_id`, `nama_bankdata`, `fileupload`, `slug_bank`, `tgl_upload`, `hits`, `id`, `sts`, `ket`) VALUES
(1, 'Rencana dan program kerja pembinaan organisasi kepemudaan', '1624787922_9110c06de6b051bd2a4a.txt', 'rencana-dan-program-kerja-pembinaan-organisasi-kepemudaan', '2021-06-04', 5, 1, NULL, NULL),
(2, 'Rumusan kebijakan teknis bidang keolahragaan', '1629372547_de2ea6f345b7e33bb086.png', 'rumusan-kebijakan-teknis-bidang-keolahragaan', '2021-06-04', 8, 1, NULL, NULL),
(3, 'Laporan hasil pelaksanaan rencana strategis dan rencana kerja Dinas', '1624787979_c5b0b1f94365244368e8.txt', 'laporan-hasil-pelaksanaan-rencana-strategis-dan-rencana-kerja-dinas', '2021-06-04', 9, 1, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `berita`
--
CREATE TABLE `berita` (
`berita_id` int(11) NOT NULL,
`judul_berita` varchar(200) DEFAULT NULL,
`slug_berita` varchar(250) DEFAULT NULL,
`ringkasan` varchar(500) DEFAULT NULL,
`isi` longtext DEFAULT NULL,
`gambar` varchar(150) DEFAULT NULL,
`tgl_berita` date DEFAULT NULL,
`status` varchar(5) DEFAULT NULL,
`kategori_id` int(11) DEFAULT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`jenis_berita` varchar(20) DEFAULT NULL,
`hits` int(11) DEFAULT NULL,
`likepost` int(11) DEFAULT 0,
`headline` varchar(1) DEFAULT NULL,
`ket_foto` varchar(255) DEFAULT NULL,
`filepdf` varchar(100) DEFAULT NULL,
`sts_komen` varchar(1) DEFAULT '0',
`pilihan` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `berita`
--
INSERT INTO `berita` (`berita_id`, `judul_berita`, `slug_berita`, `ringkasan`, `isi`, `gambar`, `tgl_berita`, `status`, `kategori_id`, `id`, `jenis_berita`, `hits`, `likepost`, `headline`, `ket_foto`, `filepdf`, `sts_komen`, `pilihan`) VALUES
(6, 'Visi dan Misi', 'visi-dan-misi', NULL, ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686534101_0d9abc78b172d53ab901.png', '2021-05-25', '1', 2, 1, 'Halaman', 415, 0, NULL, '', NULL, '0', NULL),
(7, 'Struktur Organisasi', 'struktur-organisasi', NULL, ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686534113_d4724f9680241f3332be.png', '2021-05-28', '1', 0, 1, 'Halaman', 159, 0, NULL, '', NULL, '0', NULL),
(8, 'Tugas Pokok dan Fungsi', 'tugas-pokok-dan-fungsi', NULL, ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686534124_e107bdad75288d925abf.png', '2021-05-28', '1', 0, 1, 'Halaman', 180, 0, NULL, 'Ini adalah keterangan gambar', NULL, '0', NULL),
(18, 'Syarat dan Kondisi', 'syarat-dan-kondisi', NULL, ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'default.png', '2021-07-28', '1', 0, 1, 'Halaman', 45, 0, NULL, '', NULL, '0', NULL),
(19, 'Redaksi', 'redaksi', NULL, ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
RENCANA STRATEGIS DINAS TAHUN 2019 - 2022
Contoh halaman yang disematkan dengan file pdf.
1. Langkah 1 : Tambahkan halaman seperti biasa. Silahkan masukan judul dan isi seperti biasa, dan simpan halaman.
2. Langkah 2 : Sematkan file pdf pada judul halaman dengan icon putih.
Pada halaman yang hendak disematkan klik disamping judul untuk menambahkan file PDF.
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nHalaman yang berhasil disematkan file PDF, iconnya akan berubah menjadi file pdf.
', 'default.png', '2021-08-18', '1', 0, 1, 'Halaman', 153, 0, NULL, '', '1630684760_0cedb3658bbf674bc524.pdf', '0', NULL),
(30, 'Sejarah', 'sejarah', NULL, ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'default.png', '2022-10-31', '1', 0, 1, 'Halaman', 2, 0, NULL, '', NULL, '0', NULL),
(31, 'RPJPD', 'rpjpd', NULL, ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'default.png', '2022-10-31', '1', 0, 1, 'Halaman', 6, 0, NULL, '', NULL, '0', NULL),
(34, 'Kegiatan Erkam', 'kegiatan-erkam', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686545937_8ec4bd7cf28762b708f7.jpg', '2023-06-12', '1', 16, 17, 'Berita', 0, 0, '0', 'Kegiatan Erkam', NULL, '0', '0'),
(35, 'Tahsin Qur\'an', 'tahsin-quran', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686546108_fb231d06d07b918849e1.jpeg', '2023-06-12', '1', 5, 17, 'Berita', 0, 0, '0', 'Tahsin Qur\'an', NULL, '0', '0'),
(36, 'Pramuka Day', 'pramuka-day', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock,', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686546754_a8cf3b81f3de2c128ae2.jpg', '2023-06-12', '1', 16, 1, 'Berita', 0, 0, '0', 'Pramuka Day', NULL, '0', '0'),
(37, 'Ujian Berbasis Android', 'ujian-berbasis-android', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock,', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686546830_5dcfeda8825a56e2f5d7.jpg', '2023-06-12', '1', 16, 17, 'Berita', 0, 0, '0', 'Ujian Berbasis Android', NULL, '0', '0'),
(38, 'Hafalan Qur\'an', 'hafalan-quran', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686546985_32d2f1a7197878b8fdd3.jpeg', '2023-06-12', '1', 2, 17, 'Berita', 0, 0, '0', 'Hafalan Qur\'an', NULL, '0', '0'),
(39, 'Tes PPDB', 'tes-ppdb', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686547168_9147d179747907d12389.jpg', '2023-06-12', '1', 13, 17, 'Berita', 0, 0, '0', 'Tes PPDB', NULL, '0', '0'),
(40, 'Juara 1 Lomba Futsal', 'juara-1-lomba-futsal', ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old', ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.
The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', '1686547282_a68d25b98537d50ed5d9.jpg', '2023-06-12', '1', 4, 17, 'Berita', 1, 0, '1', 'Juara 1 Lomba Futsal', NULL, '1', '1');
-- --------------------------------------------------------
--
-- Table structure for table `berita_komen`
--
CREATE TABLE `berita_komen` (
`beritakomen_id` int(11) NOT NULL,
`berita_id` int(11) DEFAULT NULL,
`nama_komen` varchar(100) DEFAULT NULL,
`hp_komen` varchar(20) DEFAULT NULL,
`isi_komen` text DEFAULT NULL,
`tanggal_komen` datetime DEFAULT NULL,
`balas_komen` text DEFAULT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`sts_komen` varchar(1) DEFAULT NULL,
`email_komen` varchar(100) DEFAULT NULL,
`tgl_balas` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `berita_tag`
--
CREATE TABLE `berita_tag` (
`beritatag_id` int(30) NOT NULL,
`berita_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `berita_tag`
--
INSERT INTO `berita_tag` (`beritatag_id`, `berita_id`, `tag_id`) VALUES
(39, 34, 6),
(40, 35, 2),
(41, 36, 7),
(42, 37, 6),
(43, 38, 2),
(44, 39, 7),
(46, 40, 1);
-- --------------------------------------------------------
--
-- Table structure for table `bt_bidang`
--
CREATE TABLE `bt_bidang` (
`bidang_id` int(11) NOT NULL,
`nama_bidang` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `bt_bidang`
--
INSERT INTO `bt_bidang` (`bidang_id`, `nama_bidang`) VALUES
(4, 'Infrastruktur dan Telematika');
-- --------------------------------------------------------
--
-- Table structure for table `bt_bukutamu`
--
CREATE TABLE `bt_bukutamu` (
`bukutamu_id` int(11) NOT NULL,
`bidang_id` int(11) DEFAULT NULL,
`nama` varchar(200) DEFAULT NULL,
`telp` varchar(20) DEFAULT NULL,
`instansi` varchar(150) DEFAULT NULL,
`keperluan` text DEFAULT NULL,
`status` varchar(1) DEFAULT NULL,
`tanggal` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `cms__grupakses`
--
CREATE TABLE `cms__grupakses` (
`id_grupakses` int(11) NOT NULL,
`id_grup` int(11) NOT NULL,
`id_modul` int(11) NOT NULL,
`akses` tinyint(4) DEFAULT 0,
`aksesmenu` int(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cms__grupakses`
--
INSERT INTO `cms__grupakses` (`id_grupakses`, `id_grup`, `id_modul`, `akses`, `aksesmenu`) VALUES
(1, 1, 1, 1, 0),
(2, 1, 2, 1, 0),
(3, 1, 3, 1, 0),
(4, 1, 4, 1, 0),
(5, 1, 5, 1, 0),
(6, 1, 6, 1, 0),
(7, 1, 7, 1, 0),
(8, 1, 8, 1, 0),
(9, 1, 9, 1, 0),
(10, 1, 10, 1, 0),
(11, 1, 11, 1, 0),
(12, 1, 12, 1, 0),
(13, 1, 13, 1, 0),
(15, 1, 15, 1, 0),
(16, 1, 16, 1, 0),
(18, 1, 18, 1, 0),
(20, 1, 20, 1, 0),
(21, 1, 21, 1, 0),
(22, 1, 22, 1, 0),
(23, 1, 23, 1, 0),
(27, 1, 27, 1, 0),
(28, 1, 28, 1, 0),
(29, 1, 29, 1, 0),
(30, 1, 30, 1, 0),
(31, 1, 31, 1, 0),
(33, 1, 33, 1, 0),
(34, 1, 34, 1, 0),
(35, 1, 35, 1, 0),
(36, 1, 36, 1, 0),
(37, 1, 37, 1, 0),
(38, 1, 38, 1, 0),
(39, 1, 39, 1, 0),
(41, 1, 41, 1, 0),
(43, 1, 43, 1, 0),
(44, 1, 44, 1, 0),
(45, 1, 45, 1, 1),
(46, 1, 46, 1, 1),
(47, 1, 47, 0, 1),
(48, 1, 48, 0, 1),
(51, 1, 49, 0, 1),
(52, 1, 50, 0, 1),
(53, 1, 51, 0, 1),
(54, 1, 52, 1, 0),
(55, 1, 53, 0, 1),
(56, 1, 54, 0, 1),
(57, 2, 2, 1, 0),
(58, 2, 3, 1, 0),
(59, 2, 4, 1, 0),
(62, 2, 5, 1, 0),
(63, 2, 6, 1, 0),
(64, 2, 7, 1, 0),
(65, 2, 8, 1, 0),
(66, 2, 9, 1, 0),
(67, 2, 10, 1, 0),
(68, 2, 11, 1, 0),
(69, 2, 12, 1, 0),
(70, 2, 13, 1, 0),
(71, 2, 15, 1, 0),
(72, 2, 16, 1, 0),
(74, 2, 18, 1, 0),
(76, 2, 20, 1, 0),
(77, 2, 21, 1, 0),
(78, 2, 22, 1, 0),
(80, 2, 23, 1, 0),
(82, 2, 27, 1, 0),
(83, 2, 28, 1, 0),
(84, 2, 29, 3, 0),
(85, 2, 31, 3, 0),
(87, 2, 39, 3, 0),
(89, 2, 30, 3, 0),
(90, 2, 52, 3, 0),
(91, 2, 33, 3, 0),
(92, 2, 34, 3, 0),
(93, 2, 35, 3, 0),
(94, 2, 36, 3, 0),
(95, 2, 37, 3, 0),
(96, 2, 38, 3, 0),
(97, 2, 41, 3, 0),
(99, 2, 43, 1, 0),
(100, 2, 44, 1, 0),
(101, 2, 45, 0, 1),
(102, 2, 46, 0, 1),
(103, 2, 47, 0, 1),
(104, 2, 48, 0, 1),
(105, 2, 49, 0, 1),
(106, 2, 50, 0, 1),
(107, 2, 54, 0, 1),
(108, 2, 51, 0, 0),
(109, 2, 53, 0, 0),
(110, 3, 2, 2, 0),
(111, 3, 3, 3, 0),
(112, 3, 4, 3, 0),
(115, 3, 5, 2, 0),
(116, 3, 6, 2, 0),
(117, 3, 7, 2, 0),
(118, 3, 8, 2, 0),
(119, 3, 9, 3, 0),
(120, 3, 10, 3, 0),
(121, 3, 11, 3, 0),
(122, 3, 12, 3, 0),
(123, 3, 13, 3, 0),
(124, 3, 15, 3, 0),
(125, 3, 16, 2, 0),
(127, 3, 18, 2, 0),
(129, 3, 20, 3, 0),
(130, 3, 21, 3, 0),
(131, 3, 22, 3, 0),
(133, 3, 23, 3, 0),
(135, 3, 27, 2, 0),
(136, 3, 28, 3, 0),
(137, 3, 29, 3, 0),
(138, 3, 31, 3, 0),
(140, 3, 39, 3, 0),
(142, 3, 30, 3, 0),
(143, 3, 52, 3, 0),
(144, 3, 33, 3, 0),
(145, 3, 34, 3, 0),
(146, 3, 35, 3, 0),
(147, 3, 36, 3, 0),
(148, 3, 37, 3, 0),
(149, 3, 38, 3, 0),
(150, 3, 41, 3, 0),
(152, 3, 43, 3, 0),
(153, 3, 44, 3, 0),
(154, 3, 45, 0, 1),
(155, 3, 46, 0, 1),
(156, 3, 47, 0, 0),
(157, 3, 48, 0, 1),
(158, 3, 49, 0, 0),
(159, 3, 50, 0, 1),
(160, 3, 54, 0, 0),
(161, 3, 51, 0, 0),
(162, 3, 53, 0, 0),
(163, 1, 55, 1, 0),
(164, 2, 55, 1, 0),
(165, 3, 55, 3, 0),
(166, 1, 57, 1, 0),
(167, 1, 58, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `cms__modpublic`
--
CREATE TABLE `cms__modpublic` (
`id_modpublic` int(11) NOT NULL,
`modpublic` varchar(100) DEFAULT NULL,
`link` varchar(100) DEFAULT NULL,
`stsmod` int(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `cms__modpublic`
--
INSERT INTO `cms__modpublic` (`id_modpublic`, `modpublic`, `link`, `stsmod`) VALUES
(1, 'Berita', 'berita', 1),
(2, 'Data Pegawai', 'pegawai', 1),
(3, 'Layanan', 'layanan', 1),
(4, 'Pengumuman', 'pengumuman', 1),
(5, 'Agenda Kegiatan', 'agenda', 1),
(6, 'Bank Data', 'bankdata', 1),
(7, 'Produk Hukum', 'produkhukum', 1),
(8, 'Info Grafis', 'infografis', 1),
(9, 'Transparansi', 'transparansi', 1),
(10, 'Galeri Foto', 'foto', 1),
(11, 'Galeri Video', 'video', 1),
(12, 'Survei', 'survey', 1),
(13, 'Buku Tamu', 'bukutamu', 1),
(15, 'Masukan dan Saran', 'masukansaran', 1),
(16, 'E-Book', 'ebook', 1),
(17, 'Peta Situs', 'petasitus', 1),
(18, 'Fasilitas', 'fasilitas', 1);
-- --------------------------------------------------------
--
-- Table structure for table `cms__modul`
--
CREATE TABLE `cms__modul` (
`id_modul` int(11) NOT NULL,
`modul` varchar(50) NOT NULL,
`aktif` tinyint(1) NOT NULL DEFAULT 0,
`urut` int(4) DEFAULT NULL,
`level` tinyint(1) NOT NULL DEFAULT 1,
`hidden` tinyint(1) NOT NULL DEFAULT 0,
`gm` varchar(50) DEFAULT NULL,
`tipemn` varchar(10) DEFAULT NULL,
`urlmenu` varchar(50) DEFAULT NULL,
`ikonmn` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cms__modul`
--
INSERT INTO `cms__modul` (`id_modul`, `modul`, `aktif`, `urut`, `level`, `hidden`, `gm`, `tipemn`, `urlmenu`, `ikonmn`) VALUES
(1, 'Dashboard', 1, 0, 1, 1, '-', NULL, NULL, '-'),
(2, 'Data Berita', 1, 1, 0, 0, 'Berita', 'sm', 'berita/all', 'mdi mdi-newspaper'),
(3, 'Kategori Berita', 1, 2, 1, 0, 'Berita', 'sm', 'berita/allkategori', 'mdi mdi-window-restore'),
(4, 'Tagar Berita', 1, 3, 1, 0, 'Berita', 'sm', 'berita/alltag', 'mdi mdi-tag-multiple'),
(5, 'Data Layanan', 1, 1, 1, 0, 'Informasi', 'sm', 'layanan/all', 'mdi mdi-teach'),
(6, 'Data Agenda', 1, 2, 1, 0, 'Informasi', 'sm', 'agenda/all', 'mdi mdi-timetable'),
(7, 'Bank Data', 1, 3, 1, 0, 'Informasi', 'sm', 'bankdata/all', 'mdi mdi-file-multiple'),
(8, 'Pengumuman', 1, 4, 1, 0, 'Informasi', 'sm', 'pengumuman/all', 'mdi mdi-bullhorn'),
(9, 'Produk Hukum', 1, 5, 1, 0, 'Informasi', 'sm', 'produkhukum/all', 'mdi mdi-scale-balance'),
(10, 'Sambutan Kepala', 1, 1, 1, 0, 'Lembaga', 'sm', 'sambutan', 'mdi mdi-voice'),
(11, 'Data Pegawai', 1, 2, 1, 0, 'Lembaga', 'sm', 'pegawai/all', 'mdi mdi-folder-account'),
(12, 'Transparansi', 1, 3, 1, 0, 'Lembaga', 'sm', 'transparansi/list', 'mdi mdi-chart-arc'),
(13, 'Fasilitas', 1, 4, 1, 0, 'Lembaga', 'sm', 'fasilitas/list', 'mdi mdi-folder-star'),
(15, 'Counter', 1, 5, 1, 0, 'Lembaga', 'sm', 'counter', 'mdi mdi-chart-timeline'),
(16, 'Data Foto', 1, 1, 1, 0, 'Galeri', 'sm', 'foto/all', 'mdi mdi-folder-multiple-image'),
(18, 'Data Video', 1, 2, 1, 0, 'Galeri', 'sm', 'video/all', 'mdi mdi-youtube'),
(20, 'Survei', 1, 1, 1, 0, 'Interaksi', 'sm', 'survey/all', 'far fa-check-square'),
(21, 'Jajak Pendapat', 1, 2, 1, 0, 'Interaksi', 'sm', 'poling', 'mdi mdi-chart-bar-stacked'),
(22, 'Buku Tamu', 1, 4, 1, 0, 'Interaksi', 'sm', 'bukutamu/list', 'far fa-comment-dots'),
(23, 'Masukan Saran', 1, 3, 1, 0, 'Interaksi', 'sm', 'kritiksaran/list', 'far fa-comments'),
(27, 'Ebook', 1, 1, 1, 0, 'Ebook', 'sm', 'ebook/all', 'mdi mdi-library'),
(28, 'Kategori Ebook', 1, 2, 1, 0, 'Ebook', 'sm', 'ebook/kategori', 'mdi mdi-layers'),
(29, 'Pengaturan', 1, 1, 1, 0, 'Pengaturan', 'sm', 'konfigurasi', 'mdi mdi-wrench'),
(30, 'Template', 1, 4, 1, 0, 'Pengaturan', 'sm', 'template', 'mdi mdi-palette'),
(31, 'Pengguna', 1, 2, 1, 0, 'Pengaturan', 'sm', 'user', 'mdi mdi-account-settings-variant'),
(33, 'Halaman', 1, 1, 1, 0, 'Setkonten', 'sm', 'halaman', 'mdi mdi mdi-book-open-page-variant'),
(34, 'Banner', 1, 2, 1, 0, 'Setkonten', 'sm', 'banner', 'mdi mdi-image-multiple'),
(35, 'Infografis', 1, 3, 1, 0, 'Setkonten', 'sm', 'infografis/all', 'mdi mdi-folder-multiple-image mdi-2x'),
(36, 'Section', 1, 4, 1, 0, 'Setkonten', 'sm', 'section', 'mdi mdi-vector-arrange-below'),
(37, 'Link Terkait', 1, 5, 1, 0, 'Setkonten', 'sm', 'linkterkait', 'mdi mdi-link-variant'),
(38, 'Modal Popup', 1, 6, 1, 0, 'Setkonten', 'sm', 'penawaran', 'mdi mdi-camera-metering-center'),
(39, 'Menu', 1, 3, 1, 0, 'Pengaturan', 'sm', 'menu', 'mdi mdi-sitemap'),
(41, 'Unit Kerja', 1, 7, 1, 0, 'Setkonten', 'sm', 'unitkerja', 'mdi mdi-file-multiple mdi-2x'),
(43, 'Dokumen', 1, 1, 3, 0, 'Dokumen', 'sm', 'dokumen', 'mdi mdi-book-multiple'),
(44, 'Kategori', 1, 2, 3, 0, 'Dokumen', 'sm', 'dokumen/kategori', 'mdi mdi-library-books'),
(45, 'BLOG', 1, 1, 2, 1, 'Berita', 'utm', NULL, 'mdi mdi-rss'),
(46, 'INFORMASI', 1, 2, 2, 1, 'Informasi', 'utm', NULL, 'mdi mdi-inbox-multiple'),
(47, 'LEMBAGA', 1, 3, 2, 1, 'Lembaga', 'utm', NULL, 'mdi mdi-bank'),
(48, 'GALERI', 1, 4, 2, 1, 'Galeri', 'utm', NULL, 'mdi mdi-folder-multiple-outline'),
(49, 'INTERAKSI', 1, 5, 2, 1, 'Interaksi', 'utm', NULL, 'mdi mdi-forum'),
(50, 'EBOOK', 1, 6, 2, 1, 'Ebook', 'utm', NULL, 'mdi mdi-book-open-page-variant'),
(51, 'KONFIGURASI', 1, 7, 2, 1, 'Pengaturan', 'utm', NULL, 'mdi mdi-cogs mdi-2x'),
(52, 'Modul CMS', 1, 5, 1, 0, 'Pengaturan', 'sm', 'modul', 'mdi mdi-compare'),
(53, 'KELOLA KONTEN', 1, 8, 2, 1, 'Setkonten', 'utm', NULL, 'mdi mdi-dropbox'),
(54, 'DOKUMEN', 0, 9, 3, 1, 'Dokumen', 'utm', NULL, 'mdi mdi-content-duplicate'),
(55, 'Iklan', 1, 8, 3, 0, 'Setkonten', 'sm', 'iklan', 'mdi mdi-camera-burst'),
(56, 'Upgrade CMS', 0, 6, 3, 0, 'Pengaturan', 'sm', 'upgradecms', 'fas fa-code'),
(57, 'Tanya Jawab', 1, 9, 3, 0, 'Setkonten', 'sm', 'tanyajawab/list', 'mdi mdi-comment-question-outline'),
(58, 'Partisipan', 0, 5, 3, 0, 'Interaksi', 'sm', 'daftar/list', 'fab fa-slideshare');
-- --------------------------------------------------------
--
-- Table structure for table `cms__usergrup`
--
CREATE TABLE `cms__usergrup` (
`id_grup` int(11) NOT NULL,
`nama_grup` varchar(20) NOT NULL,
`jenis` tinyint(2) NOT NULL DEFAULT 1,
`ketgrup` varchar(200) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`created_by` int(11) DEFAULT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_by` int(11) NOT NULL,
`sts_menu` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cms__usergrup`
--
INSERT INTO `cms__usergrup` (`id_grup`, `nama_grup`, `jenis`, `ketgrup`, `created_at`, `created_by`, `updated_at`, `updated_by`, `sts_menu`) VALUES
(1, 'Global Administrator', 1, 'Super User (Akses semua Modul dan Menu)', '2021-04-30 17:45:38', NULL, '2021-04-30 17:45:38', 0, 1),
(2, 'Editor', 2, 'Wewenang Pengguna untuk Editor (Akses semua Menu Kecuali Pengaturan)', '2022-03-16 09:34:03', NULL, '2022-03-16 09:34:03', 0, 1),
(3, 'Author', 2, 'Wewenang untuk Author, Hanya Mengolah Datanya sendiri. Menu aktif Berita, Informasi, Galeri & E-book', '2022-03-17 00:59:24', NULL, '2022-03-17 00:59:24', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `counter`
--
CREATE TABLE `counter` (
`id_counter` int(2) NOT NULL,
`nm` varchar(255) DEFAULT NULL,
`jm` int(11) DEFAULT NULL,
`ic` varchar(100) DEFAULT NULL,
`sumber` varchar(255) DEFAULT NULL,
`link` varchar(100) DEFAULT NULL,
`sts` varchar(1) NOT NULL DEFAULT '1',
`bgc` varchar(50) NOT NULL DEFAULT '#2f79b6'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `counter`
--
INSERT INTO `counter` (`id_counter`, `nm`, `jm`, `ic`, `sumber`, `link`, `sts`, `bgc`) VALUES
(1, 'SEKOLAH DASAR', 49090, 'fa fa-university', 'Sekretariat', '#', '1', '#00a7e1'),
(2, 'SLTP', 564, 'fas fa-chalkboard-teacher', 'Sekretariat', '#', '1', '#3ddc97'),
(3, 'PAUD', 331, 'fas fa-child', 'Sekretariat', '#', '1', '#e4cc37'),
(4, 'PKBM', 4312, 'fas fa-boxes', 'Sekretariat', '#', '1', '#f06543');
-- --------------------------------------------------------
--
-- Table structure for table `custome__anggota`
--
CREATE TABLE `custome__anggota` (
`anggota_id` int(11) NOT NULL,
`nama` varchar(200) DEFAULT NULL,
`no_hp` varchar(20) DEFAULT NULL,
`tempat_lahir` varchar(200) DEFAULT NULL,
`tgl_lahir` date DEFAULT NULL,
`jk` varchar(1) DEFAULT NULL,
`alamat` text DEFAULT NULL,
`tgl_daftar` date NOT NULL,
`status` varchar(1) DEFAULT NULL,
`nik` varchar(17) DEFAULT NULL,
`provinsi` varchar(100) DEFAULT NULL,
`kab` varchar(100) DEFAULT NULL,
`kec` varchar(100) DEFAULT NULL,
`kel` varchar(100) DEFAULT NULL,
`rtrw` varchar(50) DEFAULT NULL,
`pekerjaan` varchar(150) DEFAULT NULL,
`pendidikan` varchar(150) DEFAULT NULL,
`dok_ktp` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `custome__opd`
--
CREATE TABLE `custome__opd` (
`opd_id` int(11) NOT NULL,
`nama_opd` varchar(200) DEFAULT NULL,
`deskripsi_opd` text DEFAULT NULL,
`singkatan_opd` varchar(100) DEFAULT NULL,
`alamat` varchar(255) DEFAULT NULL,
`tipe_id` int(11) DEFAULT NULL,
`sts` varchar(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `custome__opd`
--
INSERT INTO `custome__opd` (`opd_id`, `nama_opd`, `deskripsi_opd`, `singkatan_opd`, `alamat`, `tipe_id`, `sts`) VALUES
(0, 'ALL', '-', '-', '-', 1, '1'),
(1, 'ADMIN BERITA', ' Admin website kategori berita', 'ADMIN BERITA', 'Website lembaga by aplikasi pendidikan net', 5, '1'),
(2, 'ADMIN INFORMASI', ' Admin website kategori informasi', 'ADMININFORMASI', 'Website lembaga by aplikasi pendidikan net', 5, '1'),
(3, 'ADMIN LAYANAN', ' Admin website kategori layanan', 'ADMIN LAYANAN', 'Website lembaga by aplikasi pendidikan net', 5, '1'),
(4, 'OPERATOR 1', ' Operator Website 1', 'OPERATOR 1', 'Website lembaga by aplikasi pendidikan net', 6, '1'),
(5, 'OPERATOR 2', ' Operator Website 2 ', 'OPERATOR 2', 'Website lembaga by aplikasi pendidikan net', 6, '1');
-- --------------------------------------------------------
--
-- Table structure for table `custome__opdtipe`
--
CREATE TABLE `custome__opdtipe` (
`tipe_id` int(11) NOT NULL,
`nama_tipe` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `custome__opdtipe`
--
INSERT INTO `custome__opdtipe` (`tipe_id`, `nama_tipe`) VALUES
(1, 'DINAS'),
(5, 'ADMIN'),
(6, 'OPS');
-- --------------------------------------------------------
--
-- Table structure for table `ebook`
--
CREATE TABLE `ebook` (
`ebook_id` int(11) NOT NULL,
`kategoriebook_id` int(11) DEFAULT NULL,
`judul` varchar(250) DEFAULT NULL,
`gambar` varchar(200) DEFAULT NULL,
`fileebook` varchar(200) DEFAULT NULL,
`penulis` varchar(200) DEFAULT NULL,
`j_hal` varchar(50) DEFAULT NULL,
`tanggal` date DEFAULT NULL,
`hits` int(11) DEFAULT NULL,
`status` varchar(1) DEFAULT NULL,
`id` int(11) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `ebook`
--
INSERT INTO `ebook` (`ebook_id`, `kategoriebook_id`, `judul`, `gambar`, `fileebook`, `penulis`, `j_hal`, `tanggal`, `hits`, `status`, `id`) VALUES
(2, 1, 'Digital Marketing melalui Aplikasi', '1639361861_351b4e0a65f86a8c0ba3.jpg', '1634212422_40a889d196d4391a76d4.pdf', 'Usman Camdani', '190', '2021-10-14', 24, '1', 1),
(5, 1, 'Mengelola Kualitas Layanan di bidang Telekomunikasi', '1639578966_3427d41502e76bb7fb11.jpg', '1634288761_8dbbb2854600cb088a00.pdf', 'Ikatan Bankir Indonesia ', '124', '2021-10-15', 13, '1', 1),
(6, 3, 'Legenda Putri Duyung', '1639579019_ea6360db0359f7106061.jpg', '1634358817_58dd7a7fdb1651781f28.pdf', 'Dian K', '102', '2021-10-16', 19, '1', 1),
(7, 1, 'Internet Marketing', '1639361251_8c7e8af5a81339c63bf9.png', '1639361251_5298acf8cc7605860af8.pdf', 'James Murdor', '122', '2021-12-13', 6, '1', 1);
-- --------------------------------------------------------
--
-- Table structure for table `faq_jawab`
--
CREATE TABLE `faq_jawab` (
`faq_jawabid` int(11) NOT NULL,
`faq_tanyaid` int(11) DEFAULT NULL,
`faq_jawaban` text DEFAULT NULL,
`sts_jwb` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `faq_jawab`
--
INSERT INTO `faq_jawab` (`faq_jawabid`, `faq_tanyaid`, `faq_jawaban`, `sts_jwb`) VALUES
(1, 1, 'CMS Datagoe adalah content management system (CMS) open-source berbasis PHP dan MySQL yang digunakan untuk mendukung apa pun dari situs anda dengan lalu lintas tinggi.', NULL),
(3, 3, 'Calon Presiden dan calon Wakil Presiden diusulkan dalam 1 (satu) pasangan oleh Partai Politik atau Gabungan Partai Politik.', NULL),
(7, 2, 'Fungsi partai politik terhadap negara antara lain adalah menciptakan pemerintahan yang efektif dan adanya partisipasi politik terhadap pemerintahan yang berkuasa.
', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `faq_tanya`
--
CREATE TABLE `faq_tanya` (
`faq_tanyaid` int(11) NOT NULL,
`faqtanya` varchar(255) DEFAULT NULL,
`sts_faqtanya` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `faq_tanya`
--
INSERT INTO `faq_tanya` (`faq_tanyaid`, `faqtanya`, `sts_faqtanya`) VALUES
(1, 'Apa itu CMS Datagoe?', '1'),
(2, 'Apa tugas dari Partai Politik ', '1'),
(3, 'Apakah calon presiden harus dari Partai politik?', '1');
-- --------------------------------------------------------
--
-- Table structure for table `fasilitas`
--
CREATE TABLE `fasilitas` (
`fasilitas_id` int(11) NOT NULL,
`fasilitas` varchar(100) DEFAULT NULL,
`cover_foto` varchar(100) DEFAULT NULL,
`ket` varchar(255) DEFAULT NULL,
`lokasi` text DEFAULT NULL,
`sts` varchar(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `fasilitas`
--
INSERT INTO `fasilitas` (`fasilitas_id`, `fasilitas`, `cover_foto`, `ket`, `lokasi`, `sts`) VALUES
(1, 'Gedung Sekolah', '1686534762_da47e0bc6bf5603057b1.jpg', 'Berikut data foto gedung sekolah', '', '1');
-- --------------------------------------------------------
--
-- Table structure for table `fasilitas_detail`
--
CREATE TABLE `fasilitas_detail` (
`fasilitasdetail_id` int(11) NOT NULL,
`fasilitas_id` int(11) DEFAULT NULL,
`gambar` varchar(100) DEFAULT NULL,
`deskripsi` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `fasilitas_detail`
--
INSERT INTO `fasilitas_detail` (`fasilitasdetail_id`, `fasilitas_id`, `gambar`, `deskripsi`) VALUES
(1, 1, '1666793399_e5c458ce0d0acdb50ee2.jpg', 'Tampak Belakang');
-- --------------------------------------------------------
--
-- Table structure for table `foto`
--
CREATE TABLE `foto` (
`foto_id` int(11) NOT NULL,
`kategorifoto_id` int(11) DEFAULT NULL,
`judul` varchar(200) DEFAULT NULL,
`tanggal` date DEFAULT NULL,
`gambar` varchar(200) DEFAULT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`hits` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `foto`
--
INSERT INTO `foto` (`foto_id`, `kategorifoto_id`, `judul`, `tanggal`, `gambar`, `id`, `hits`) VALUES
(44, 1, 'Wisma Atlet Kemayoran dan Rusunawa Raih Penghargaan Inovasi Pelayanan Publik Penanganan Covid-19', '2021-06-14', '1623601134_a4755ab7a88523662a5d.jpg', 1, 1),
(46, 1, 'Siap Diresmikan, Floodway Cisangkuy Akan Tambah Kapasitas Penanganan Banjir di Bandung', '2021-06-14', '1623816361_35910235c35789e18949.jpg', 1, 1),
(47, 2, 'Demo Foto', '2021-06-16', '1650116579_1b9dd22e99989cd76e14.jpg', 1, 1),
(50, 1, 'Demo Foto 4', '2021-06-16', '1650115911_30b8d2e45c439caba8da.jpg', 1, 1),
(51, 1, 'Demo Foto 2', '2021-06-16', '1650115989_656fa50360a1157aeddf.jpg', 1, 1),
(52, 2, 'Demo Foto 2', '2021-06-16', '1623816515_25de364958d48be7a6ad.jpg', 1, 1),
(57, 6, 'Expect Nothing', '2021-06-16', '1623816679_7fb1cfd80ab799fdafe9.png', 1, 1),
(58, 7, 'Tampilan Baru CMS', '2022-04-16', '1650116664_2e68aa0d5bf747c2b424.jpg', 1, NULL),
(59, 7, 'Konfigurasi CMS', '2022-04-16', '1650115295_3bd00ce6766779ebb32b.jpg', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `informasi`
--
CREATE TABLE `informasi` (
`informasi_id` int(11) NOT NULL,
`nama` varchar(200) DEFAULT NULL,
`slug_informasi` varchar(200) DEFAULT NULL,
`isi_informasi` text DEFAULT NULL,
`gambar` varchar(120) DEFAULT NULL,
`tgl_informasi` date DEFAULT NULL,
`hits` int(11) DEFAULT NULL,
`type` int(1) DEFAULT NULL COMMENT '0=Layanan\r\n1=Pengumuman',
`id` int(11) UNSIGNED DEFAULT NULL,
`fileunduh` varchar(200) DEFAULT NULL,
`sts_aktif` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `informasi`
--
INSERT INTO `informasi` (`informasi_id`, `nama`, `slug_informasi`, `isi_informasi`, `gambar`, `tgl_informasi`, `hits`, `type`, `id`, `fileunduh`, `sts_aktif`) VALUES
(2, 'Renstra Dinas Pemuda Olahraga dan Kebudayaan Tahun 2020 - 2021', 'renstra-dinas-pemuda-olahraga-dan-kebudayaan-tahun-2020-2021', ' Rencana strategis Dinas Pemuda Olahraga dan Kebudayaan Kabupaten Lembata Tahun 2020 - 202.', '1622784809_6fd7ee491a1ba50ed3aa.jpg', '2021-06-02', 92, 0, 1, NULL, NULL),
(5, 'LKJIP DISPORABUD Tahun 2021', 'lkjip-disporabud-tahun-2021', 'Laporan Kinerja Instansi Pemerintah (LKjIP) merupakan suatu bentuk pertanggungjawaban tentang penyelenggaraan negara yang berdayaguna dan berhasilguna sesuai dengan Instruksi Presiden (Inpres) Nomor 7 tahun 1999 tentang Akuntabilitas Kinerja Instansi Pemerintah dan Surat Edaran Menteri Pendayagunaan Aparatur Negara.
', 'default.png', '2021-06-02', 79, 0, 1, NULL, NULL),
(6, 'IKU DISPORABUD Tahun 2021', 'iku-disporabud-tahun-2021', 'Indikator kinerja utama atau IKU adalah ukuran atau indikator kinerja suatu instansi, utamanya dalam mencapai tujuan dan sasaran tertentu. Setiap lembaga atau instansi pemerintah wajib merumuskan indikator kinerja utama, dan menjadikan hal itu sebagai prioritas utama.
', 'default.png', '2021-06-02', 122, 0, 1, '1622707876_b0c0282580f4b6491c83.pdf', NULL),
(8, 'Surat Edaran Penyelenggaran Latihan di Masa Pandemi Covid 19', 'surat-edaran-penyelenggaran-latihan-di-masa-pandemi-covid-19', ' Di informasikan untuk setiap pengurus cabang olahraga, untuk tetap mematuhi protokol kesehatan di masa covid 19. Surat lengkap dapat di unduh dibawah.
', '1686540955_2113742d7f8fb63d7dfe.jpg', '2021-06-04', 58, 1, 1, '', NULL),
(9, 'Sebaran Data Quisioner Online', 'sebaran-data-quisioner-online', 'Sesuai surat dari DISPORABUD Kabupaten Lembata Nomor : 556/1737 tanggal 04 Juni 2021 perihal permintaan sebaran data Quisioner Online, dimohon kepada pengunjung Website DINPORAPAR Kabupaten Purbalingga untuk membantu proses penyebaran dan pengisian Quisioner online melalui Media sosial. Adapun tautan dari quisioner yang akan disebarkan : bit/ly/siapberbagiwisatalagi.
atas kerjasama dari pengunjung website kami sampaikan terima kasih
', '1649395640_44f0761ca182d8e9a585.jpeg', '2021-06-04', 76, 1, 1, '1622789361_38adb5a21a9f05960095.png', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `kategori`
--
CREATE TABLE `kategori` (
`kategori_id` int(11) NOT NULL,
`nama_kategori` varchar(100) DEFAULT NULL,
`slug_kategori` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `kategori`
--
INSERT INTO `kategori` (`kategori_id`, `nama_kategori`, `slug_kategori`) VALUES
(0, 'Hal', 'Hal'),
(1, 'Informasi', 'Informasi'),
(2, 'Artikel', 'Artikel'),
(4, 'Olahraga', 'Olahraga'),
(5, 'Inspirasi', 'Inspirasi'),
(11, 'Puisi', 'Puisi'),
(13, 'Internasional', 'Internasional'),
(15, 'Teknologi', 'Teknologi'),
(16, 'Berita', 'Berita');
-- --------------------------------------------------------
--
-- Table structure for table `kategori_ebook`
--
CREATE TABLE `kategori_ebook` (
`kategoriebook_id` int(11) NOT NULL,
`kategoriebook_nama` varchar(200) DEFAULT NULL,
`kategoriebook_slug` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `kategori_ebook`
--
INSERT INTO `kategori_ebook` (`kategoriebook_id`, `kategoriebook_nama`, `kategoriebook_slug`) VALUES
(1, 'Informasi Publik', 'Informasi-Publik'),
(3, 'Cerita Rakyat', 'Cerita-Rakyat');
-- --------------------------------------------------------
--
-- Table structure for table `kategori_foto`
--
CREATE TABLE `kategori_foto` (
`kategorifoto_id` int(11) NOT NULL,
`nama_kategori_foto` varchar(200) DEFAULT NULL,
`slug_kategori_foto` varchar(200) DEFAULT NULL,
`cover_foto` varchar(100) DEFAULT NULL,
`ket` text DEFAULT NULL,
`tgl_album` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `kategori_foto`
--
INSERT INTO `kategori_foto` (`kategorifoto_id`, `nama_kategori_foto`, `slug_kategori_foto`, `cover_foto`, `ket`, `tgl_album`) VALUES
(1, 'Kegiatan Rutin', 'kegiatan-rutin', '1686535585_1f91f265d889d1ffeb53.jpeg', 'Kegiatan rutin sehari-hari', '2021-05-13'),
(2, 'Sekolah', 'sekolah', '1686535626_233df20a3d1c7fcff792.jpg', 'Sekolah', '2021-11-20'),
(6, 'Ujian', 'ujian', '1686535658_4c15447731474c222789.jpg', 'Ujian', '2021-11-12'),
(7, 'Pramuka', 'pramuka', '1686535726_58f02c0fa3cfc81b2cd7.jpg', 'Pramuka', '2022-01-22');
-- --------------------------------------------------------
--
-- Table structure for table `kategori_video`
--
CREATE TABLE `kategori_video` (
`kategorivideo_id` int(11) NOT NULL,
`nama_kategori_video` varchar(200) DEFAULT NULL,
`slug_kategori_video` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `kategori_video`
--
INSERT INTO `kategori_video` (`kategorivideo_id`, `nama_kategori_video`, `slug_kategori_video`) VALUES
(11, 'Aplikasi Absen Siswa Gratis', 'Aplikasi-Absen-Siswa-Gratis'),
(12, 'Aplikasi CBT Gratis', 'Aplikasi-CBT-Gratis'),
(13, 'Aplikasi Sistem Akademik Gratis', 'Aplikasi-Sistem-Akademik-Gratis');
-- --------------------------------------------------------
--
-- Table structure for table `kritiksaran`
--
CREATE TABLE `kritiksaran` (
`kritiksaran_id` int(11) NOT NULL,
`nama` varchar(200) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`judul` varchar(200) DEFAULT NULL,
`isi_kritik` text DEFAULT NULL,
`tanggal` date DEFAULT NULL,
`status` int(1) DEFAULT NULL,
`no_hpusr` varchar(15) DEFAULT NULL,
`balas` text DEFAULT NULL,
`tgl_bls` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `kritiksaran`
--
INSERT INTO `kritiksaran` (`kritiksaran_id`, `nama`, `email`, `judul`, `isi_kritik`, `tanggal`, `status`, `no_hpusr`, `balas`, `tgl_bls`) VALUES
(2, 'Desi Gili', 'disporabudkablembata@gmail.com', 'Pengaduan', 'Pelayanan kurang baik untuk beberapa perangkat. Mohon ditingkatkan pelayanannya.', '2022-07-21', 1, '0813538909821', 'Baik. Akan kami tindak lanjuti. Mohon maaf atas ketidaknyamanan nya klik disini untuk ke web cms datagoe', '2022-09-07');
-- --------------------------------------------------------
--
-- Table structure for table `link_terkait`
--
CREATE TABLE `link_terkait` (
`id_link` int(11) NOT NULL,
`nama_link` varchar(200) DEFAULT NULL,
`url` varchar(200) DEFAULT NULL,
`gambar` varchar(100) DEFAULT NULL,
`status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `link_terkait`
--
INSERT INTO `link_terkait` (`id_link`, `nama_link`, `url`, `gambar`, `status`) VALUES
(8, 'Simpatika', 'https://simpatika.kemenag.go.id/', '1686533421_f32dd96e76773d5511f0.png', 1),
(9, 'ERKAM', 'https://erkam.kemenag.go.id/', '1686533459_4990ac06233826c73ab5.png', 1),
(10, 'Emis', 'https://emis.kemenag.go.id/', '1686533480_6ae819699ac5eedbd645.png', 1),
(11, 'Bos Kemenag', 'https://bos.kemenag.go.id/', '1686533507_fbea0816fb951a46e183.png', 1),
(12, 'Playstore', 'https://play.google.com/', '1686533538_987f3e321344e4f2e0f1.png', 1);
-- --------------------------------------------------------
--
-- Table structure for table `menu`
--
CREATE TABLE `menu` (
`menu_id` int(11) NOT NULL,
`nama_menu` varchar(100) DEFAULT NULL,
`menu_link` varchar(200) DEFAULT NULL,
`parent` varchar(1) DEFAULT NULL,
`icon` varchar(50) DEFAULT NULL,
`urutan` int(11) DEFAULT NULL,
`target` varchar(50) DEFAULT NULL,
`posisi` varchar(1) DEFAULT '0',
`linkexternal` varchar(1) DEFAULT NULL,
`stsmenu` int(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `menu`
--
INSERT INTO `menu` (`menu_id`, `nama_menu`, `menu_link`, `parent`, `icon`, `urutan`, `target`, `posisi`, `linkexternal`, `stsmenu`) VALUES
(1, 'HOME', '/', 'N', 'fas fa-home', 0, '_parent', '0', 'Y', 1),
(2, 'PROFIL', '#', 'Y', '', 1, NULL, '0', '', 1),
(3, 'BERITA', 'berita', 'N', '', 2, '_parent', '0', 'N', 1),
(5, 'GALERI', '#', 'Y', '', 4, NULL, '0', '', 1),
(6, 'INFORMASI', '#', 'Y', '', 3, NULL, '0', '', 1),
(13, 'Redaksi', 'page/redaksi', NULL, '', 1, '_parent', '2', 'N', 1),
(14, 'Syarat & Kondisi', 'page/syarat-dan-kondisi', NULL, '', 2, '_parent', '2', 'N', 1),
(15, 'Peta Situs', 'petasitus', NULL, '', 3, '_parent', '2', 'N', 1),
(19, 'E-BOOK', 'ebook', 'N', 'mdi mdi-book-open-page-variant', 6, '_parent', '0', 'N', 1),
(21, 'INTERAKSI', '#', 'Y', 'fas fa-hands-helping', 5, '_parent', '0', 'N', 1),
(22, 'BERANDA', '/', NULL, 'fas fa-home', 1, '_parent', '1', 'Y', 1),
(23, 'PEGAWAI', 'pegawai', 'N', '', 2, '_parent', '1', 'N', 1),
(24, 'PROFIL DINAS', 'page/sejarah', 'N', '', 3, '_parent', '1', 'N', 1),
(25, 'TRANSPARANSI ANGGARAN', 'transparansi', NULL, '', 4, '_parent', '1', 'N', 1);
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` bigint(20) UNSIGNED NOT NULL,
`version` varchar(255) NOT NULL,
`class` varchar(255) NOT NULL,
`group` varchar(255) NOT NULL,
`namespace` varchar(255) NOT NULL,
`time` int(11) NOT NULL,
`batch` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `migrations`
--
INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2017-11-20-223112', 'Myth\\Auth\\Database\\Migrations\\CreateAuthTables', 'default', 'Myth\\Auth', 1613099987, 1);
-- --------------------------------------------------------
--
-- Table structure for table `modalpopup`
--
CREATE TABLE `modalpopup` (
`modalpopup_id` int(1) NOT NULL,
`judultawaran` varchar(100) DEFAULT NULL,
`isitawaran` text DEFAULT NULL,
`gbrtawaran` varchar(100) DEFAULT NULL,
`linktawaran` varchar(100) DEFAULT NULL,
`namatombol` varchar(50) DEFAULT NULL,
`sts_tombol` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `modalpopup`
--
INSERT INTO `modalpopup` (`modalpopup_id`, `judultawaran`, `isitawaran`, `gbrtawaran`, `linktawaran`, `namatombol`, `sts_tombol`) VALUES
(1, 'PPDB', ' ', '1.png', 'https://www.aplikasipendidikan.net/', 'PPDB New', '1');
-- --------------------------------------------------------
--
-- Table structure for table `pegawai`
--
CREATE TABLE `pegawai` (
`pegawai_id` int(11) NOT NULL,
`nip` varchar(50) DEFAULT NULL,
`nama` varchar(200) DEFAULT NULL,
`tempat_lahir` varchar(100) DEFAULT NULL,
`tgl_lahir` date DEFAULT NULL,
`jk` varchar(1) DEFAULT NULL,
`agama` varchar(30) DEFAULT NULL,
`pangkat` varchar(50) DEFAULT NULL,
`jabatan` varchar(100) DEFAULT NULL,
`gambar` varchar(200) DEFAULT NULL,
`filetupoksi` varchar(100) DEFAULT NULL,
`publikasi` text DEFAULT NULL,
`penelitian` text DEFAULT NULL,
`pengabdian` text DEFAULT NULL,
`asal_s1` varchar(200) DEFAULT NULL,
`asal_s2` varchar(200) DEFAULT NULL,
`asal_s3` varchar(200) DEFAULT NULL,
`bidang_pakar` varchar(200) DEFAULT NULL,
`bio_singkat` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `pegawai`
--
INSERT INTO `pegawai` (`pegawai_id`, `nip`, `nama`, `tempat_lahir`, `tgl_lahir`, `jk`, `agama`, `pangkat`, `jabatan`, `gambar`, `filetupoksi`, `publikasi`, `penelitian`, `pengabdian`, `asal_s1`, `asal_s2`, `asal_s3`, `bidang_pakar`, `bio_singkat`) VALUES
(48, '0912212', 'Budiman', 'Waikomo', '1985-03-20', 'L', 'Islam', 'II A', 'Waka Kurikulum', 'default.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(49, '9912012', 'Wahyu Jatmiko', 'London', '1985-03-21', 'L', 'Islam', 'IIC', 'Waka kesiswaan', 'default.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(50, '1929411', 'Ahmad Rosikin', 'Bukit', '1985-03-22', 'L', 'Islam', 'III D', 'Kepala TU', 'default.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(51, '8812012', 'M Rafli Habibi', 'Waikomo', '1985-03-23', 'P', 'Islam', 'IV A', 'Waka Sarana ', 'default.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `poling`
--
CREATE TABLE `poling` (
`poling_id` int(11) NOT NULL,
`pilihan` varchar(150) DEFAULT NULL,
`type` varchar(20) DEFAULT NULL,
`rating` int(5) DEFAULT 0,
`status` varchar(1) DEFAULT 'Y',
`id` int(11) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `poling`
--
INSERT INTO `poling` (`poling_id`, `pilihan`, `type`, `rating`, `status`, `id`) VALUES
(1, 'Bagaimanakah menurut Anda dengan Pelayanan dan Kinerja CMS Datagoe ?', 'Pertanyaan', NULL, 'Y', 1),
(2, 'Sangat Baik', 'Jawaban', 23, 'Y', 1),
(3, 'Baik', 'Jawaban', 9, 'Y', 1),
(4, 'Cukup Baik', 'Jawaban', 5, 'Y', 1),
(6, 'Belum Tahu', 'Jawaban', 2, 'Y', 1);
-- --------------------------------------------------------
--
-- Table structure for table `produk_hukum`
--
CREATE TABLE `produk_hukum` (
`produk_id` int(11) NOT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`nama_produk` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `produk_hukum`
--
INSERT INTO `produk_hukum` (`produk_id`, `id`, `nama_produk`) VALUES
(8, 1, 'UNDANG - UNDANG'),
(9, 1, 'PERATURAN GUBERNUR'),
(10, 1, 'PERATURAN DAERAH');
-- --------------------------------------------------------
--
-- Table structure for table `produk_kathukum`
--
CREATE TABLE `produk_kathukum` (
`kathukum_id` int(11) NOT NULL,
`produk_id` int(11) DEFAULT NULL,
`nama_kathukum` varchar(255) DEFAULT NULL,
`file_kathukum` varchar(100) DEFAULT NULL,
`tanggal_kathukum` date DEFAULT NULL,
`status_kathukum` varchar(1) DEFAULT NULL COMMENT '0=tidak aktif 1=aktif',
`skathukum` varchar(1) DEFAULT NULL COMMENT '1=lanjut, 0=tidaklanjut',
`hits` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `produk_kathukum`
--
INSERT INTO `produk_kathukum` (`kathukum_id`, `produk_id`, `nama_kathukum`, `file_kathukum`, `tanggal_kathukum`, `status_kathukum`, `skathukum`, `hits`) VALUES
(22, 8, 'UNDANG - UNDANG KEARSIPAN', '-', '2022-01-26', '1', '1', 0),
(23, 9, 'Pergub Perpustakaan 13 Tahun 2019', '1643183596_597406ee73d127728042.pdf', '2022-01-26', '1', '0', 0),
(24, 8, 'UNDANG - UNDANG KOMUNIKASI', NULL, '2022-01-26', '1', '1', 0),
(25, 10, 'Perda Perpustakaan 12 Tahun 2019', '1643185291_d7fc0936dcfa6805ea8b.txt', '2022-01-26', '1', '0', 0),
(26, 10, 'Perda Kearsipan 2021', '1643185324_ad098a596cdf6315a73d.txt', '2022-01-26', '1', '0', 0);
-- --------------------------------------------------------
--
-- Table structure for table `produk_subkathukum`
--
CREATE TABLE `produk_subkathukum` (
`subkathukum_id` int(11) NOT NULL,
`kathukum_id` int(11) DEFAULT NULL,
`nama_subkathukum` varchar(255) DEFAULT NULL,
`file_subkathukum` varchar(100) DEFAULT NULL,
`tanggal_subkathukum` date DEFAULT NULL,
`status_subkathukum` varchar(1) DEFAULT NULL,
`hits` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `produk_subkathukum`
--
INSERT INTO `produk_subkathukum` (`subkathukum_id`, `kathukum_id`, `nama_subkathukum`, `file_subkathukum`, `tanggal_subkathukum`, `status_subkathukum`, `hits`) VALUES
(15, 22, 'Undang-undang kearsipan no 22', '1643162886_fd2dc6ea89a708c17fc3.pdf', '2022-01-26', '1', NULL),
(16, 22, 'Undang -Undang No 30', '1643184229_2f4a6da77bc16aa72b22.txt', '2022-01-26', '1', NULL),
(17, 22, 'Undang-undang no 50', '1643184306_278b6dfaa0d49f5ae9d8.txt', '2022-01-26', '1', NULL),
(18, 24, 'Undang-undang Komunikasi no 1', '1643184455_f6f959e514f55a33607e.txt', '2022-01-26', '1', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `section`
--
CREATE TABLE `section` (
`section_id` int(11) NOT NULL,
`nama_section` varchar(100) DEFAULT NULL,
`gambar` varchar(200) DEFAULT NULL,
`link` varchar(200) DEFAULT NULL,
`linksumber` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `section`
--
INSERT INTO `section` (`section_id`, `nama_section`, `gambar`, `link`, `linksumber`) VALUES
(1, 'LAYANAN', '1655792214_70107ab76c42da98cef0.png', 'layanan', 'N'),
(2, 'SURVEI KEPUASAN', '1655792202_eca61b1640dcdda50be4.png', 'survey', 'N'),
(3, 'AGENDA', '1655791207_4c583efb71366983ae12.png', 'agenda', 'N'),
(4, 'BANK DATA', '1655791375_bed701f9e766b52f59ac.png', 'bankdata', 'N'),
(5, 'PEGAWAI', '1655791791_3724d6d86a2f9576a145.png', 'pegawai', 'N'),
(6, 'STRUKTUR', '1655791700_3a9c6901c6da15da8cb0.png', 'page/struktur-organisasi', 'N'),
(7, 'VISI MISI', '1655791541_d700245f9a864657be9d.png', 'page/visi-dan-misi', 'N'),
(8, 'LEMBAGA', '1655791598_484fe526227a4618c477.png', ' https://aplikasipendidikan.net/', 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `submenu`
--
CREATE TABLE `submenu` (
`submenu_id` int(11) NOT NULL,
`menu_id` int(11) DEFAULT NULL,
`nama_submenu` varchar(100) DEFAULT NULL,
`link_submenu` varchar(200) DEFAULT NULL,
`iconsm` varchar(50) DEFAULT NULL,
`urutansm` int(11) DEFAULT NULL,
`targetsm` varchar(50) DEFAULT NULL,
`linkexternalsm` varchar(1) DEFAULT NULL,
`stssubmenu` int(1) NOT NULL DEFAULT 1,
`parentsm` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `submenu`
--
INSERT INTO `submenu` (`submenu_id`, `menu_id`, `nama_submenu`, `link_submenu`, `iconsm`, `urutansm`, `targetsm`, `linkexternalsm`, `stssubmenu`, `parentsm`) VALUES
(1, 2, 'Visi dan Misi', 'page/visi-dan-misi', 'mdi mdi-library-books', 0, '_parent', 'N', 1, NULL),
(2, 2, 'Struktur Organisasi', 'page/struktur-organisasi', 'fa fa-users', 1, '_parent', 'N', 1, NULL),
(3, 2, 'Data Pegawai', 'pegawai', 'fas fa-user-tie', 3, '_parent', 'N', 1, NULL),
(4, 5, 'Foto', 'foto', 'far fa-image', 1, '_parent', 'N', 1, NULL),
(5, 5, 'Video', 'video', 'fas fa-video', 2, '_parent', 'N', 1, NULL),
(6, 6, 'Layanan', 'layanan', 'fas fa-chalkboard-teacher', 1, '_parent', 'N', 1, 'N'),
(7, 6, 'Pengumuman', 'pengumuman', 'fas fa-bullhorn', 2, '_parent', 'N', 1, 'N'),
(8, 6, 'Agenda', 'agenda', 'far fa-calendar-check', 3, '_parent', 'N', 1, 'N'),
(9, 6, 'Bank Data', 'bankdata', 'fas fa-database', 4, '_parent', 'N', 1, 'N'),
(10, 2, 'Tugas Pokok dan Fungsi', 'page/tugas-pokok-dan-fungsi', 'mdi mdi-buffer', 2, '_parent', 'N', 1, NULL),
(13, 6, 'Produk Hukum', 'produkhukum', 'fa fa-balance-scale', 5, '_parent', 'N', 1, NULL),
(14, 6, 'Infografis', 'infografis', 'far fa-images', 6, '_parent', 'N', 1, 'N'),
(16, 21, 'Survei', 'survey', 'far fa-check-square', 1, '_parent', 'N', 1, NULL),
(17, 21, 'Buku Tamu', 'bukutamu', 'far fa-comment-alt', 3, '_parent', 'N', 1, NULL),
(19, 6, 'Transparansi Anggaran', 'transparansi', 'fas fa-chart-pie', 7, '_parent', 'N', 1, 'N'),
(20, 21, 'Masukan Saran', 'masukansaran', 'far fa-comments', 2, NULL, 'N', 1, NULL),
(21, 6, 'Informasi Berkala', '#', 'fas fa-expand', 8, '_parent', 'Y', 1, 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `subsubmenu`
--
CREATE TABLE `subsubmenu` (
`subsubmenu_id` int(11) NOT NULL,
`submenu_id` int(11) DEFAULT NULL,
`nama_subsubmenu` varchar(100) DEFAULT NULL,
`link_subsubmenu` varchar(200) DEFAULT NULL,
`iconssm` varchar(50) DEFAULT NULL,
`urutanssm` int(11) DEFAULT NULL,
`targetssm` varchar(50) DEFAULT NULL,
`linkexternalssm` varchar(1) DEFAULT NULL,
`stsssm` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `subsubmenu`
--
INSERT INTO `subsubmenu` (`subsubmenu_id`, `submenu_id`, `nama_subsubmenu`, `link_subsubmenu`, `iconssm`, `urutanssm`, `targetssm`, `linkexternalssm`, `stsssm`) VALUES
(1, 21, 'Daftar Informasi Publik', 'page/rpjpd', 'fas fa-sticky-note', 1, '_parent', 'N', '1'),
(2, 21, 'Rencana Strategis', 'page/rencana-strategis', 'far fa-sticky-note', 2, '_parent', 'N', '1');
-- --------------------------------------------------------
--
-- Table structure for table `survey_jawaban`
--
CREATE TABLE `survey_jawaban` (
`jawaban_id` int(11) NOT NULL,
`pertanyaan_id` int(11) DEFAULT NULL,
`jawaban` varchar(200) DEFAULT NULL,
`nilai` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `survey_jawaban`
--
INSERT INTO `survey_jawaban` (`jawaban_id`, `pertanyaan_id`, `jawaban`, `nilai`) VALUES
(1, 3, 'Tidak sesuai', 1),
(2, 3, 'Kurang sesuai', 2),
(3, 3, 'Sesuai', 3),
(6, 3, 'Sangat Sesuai', 4),
(7, 4, 'Tidak Mudah', 1),
(8, 4, 'Kurang Mudah', 2),
(9, 4, 'Mudah', 3),
(10, 4, 'Sangat Mudah', 4);
-- --------------------------------------------------------
--
-- Table structure for table `survey_pertanyaan`
--
CREATE TABLE `survey_pertanyaan` (
`pertanyaan_id` int(11) NOT NULL,
`survey_id` int(11) DEFAULT NULL,
`pertanyaan` varchar(255) DEFAULT NULL,
`status` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `survey_pertanyaan`
--
INSERT INTO `survey_pertanyaan` (`pertanyaan_id`, `survey_id`, `pertanyaan`, `status`) VALUES
(3, 1, 'Bagaimana pendapat Saudara tentang kesesuaian persyaratan pelayanan dengan jenis pelayanannya.', '1'),
(4, 1, 'Bagaimana pemahaman Saudara tentang kemudahan prosedur\r\npelayanan di unit ini.', '1');
-- --------------------------------------------------------
--
-- Table structure for table `survey_responden`
--
CREATE TABLE `survey_responden` (
`responden_id` int(11) NOT NULL,
`survey_id` int(11) DEFAULT NULL,
`nohp` varchar(15) DEFAULT NULL,
`nama` varchar(150) DEFAULT NULL,
`saran` text DEFAULT NULL,
`tanggal` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `survey_responden`
--
INSERT INTO `survey_responden` (`responden_id`, `survey_id`, `nohp`, `nama`, `saran`, `tanggal`) VALUES
(7, 1, '081353967028', 'Vian Taum', 'Tingkatkan pelayanan, dan maju terus', '2021-12-03'),
(8, 1, '+621125678909', 'No Google', 'Ini isi tanpa google secret', '2022-10-30'),
(9, 1, '+621125678909', 'Deril', 'COba', '2022-11-30'),
(10, 1, '213', 'ewq', 'asd', '2023-01-27'),
(11, 1, '081353967028', 'deril taum', 'Coba', '2023-03-20'),
(12, 1, '081353967028', 'deril taum', 'tanpa gogle', '2023-03-21');
-- --------------------------------------------------------
--
-- Table structure for table `survey_topik`
--
CREATE TABLE `survey_topik` (
`survey_id` int(11) NOT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`nama_survey` varchar(255) DEFAULT NULL,
`status` varchar(1) DEFAULT NULL,
`hits` int(11) DEFAULT 0,
`skor` int(11) DEFAULT 0,
`r1_stb` int(11) DEFAULT 0,
`r2_stb` int(11) DEFAULT 0,
`r1_kb` int(11) DEFAULT 0,
`r2_kb` int(11) DEFAULT 0,
`r1_b` int(11) DEFAULT 0,
`r2_b` int(11) DEFAULT 0,
`r1_sb` int(11) DEFAULT 0,
`r2_sb` int(11) DEFAULT 0,
`ket_stb` varchar(100) DEFAULT NULL,
`ket_kb` varchar(100) DEFAULT NULL,
`ket_b` varchar(100) DEFAULT NULL,
`ket_sb` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `survey_topik`
--
INSERT INTO `survey_topik` (`survey_id`, `id`, `nama_survey`, `status`, `hits`, `skor`, `r1_stb`, `r2_stb`, `r1_kb`, `r2_kb`, `r1_b`, `r2_b`, `r1_sb`, `r2_sb`, `ket_stb`, `ket_kb`, `ket_b`, `ket_sb`) VALUES
(1, 1, 'Quisioner Survei Kepuasan Pelayanan Masyarakat', '1', 19, 64, 1, 4, 5, 9, 10, 19, 20, 25, 'Sangat Tidak Baik', 'Kurang Baik', 'Baik', 'Sangat Baik'),
(5, 1, 'Survei Kepuasan Perlengkapan Pelayanan', '0', 0, 0, 1, 4, 5, 9, 10, 19, 20, 25, 'Sangat Tidak Lengkap', 'Kurang Lengkap', 'Lengkap', 'Sangat Lengkap');
-- --------------------------------------------------------
--
-- Table structure for table `tag`
--
CREATE TABLE `tag` (
`tag_id` int(11) NOT NULL,
`nama_tag` varchar(100) DEFAULT NULL,
`slug_tag` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tag`
--
INSERT INTO `tag` (`tag_id`, `nama_tag`, `slug_tag`) VALUES
(1, 'Olahraga', 'Olahraga'),
(2, 'Edukasi', 'Edukasi'),
(3, 'Kesehatan', 'Kesehatan'),
(6, 'Teknologi', 'Teknologi'),
(7, 'Berita', 'Berita');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_banner`
--
CREATE TABLE `tbl_banner` (
`id_banner` int(11) NOT NULL,
`banner_image` varchar(255) DEFAULT NULL,
`ket` varchar(200) DEFAULT NULL,
`type` int(1) DEFAULT NULL,
`link` varchar(100) DEFAULT NULL,
`posisi` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tbl_banner`
--
INSERT INTO `tbl_banner` (`id_banner`, `banner_image`, `ket`, `type`, `link`, `posisi`) VALUES
(1, '1638761650_69a7e858b593cba59fb4.jpg', 'Pesan Presiden RI Jokowi, saat pembukaan HAORNAS ke- 37 pada 9 September lalu', 1, NULL, NULL),
(2, '1638761743_e37a26ddd2b4a5be19c4.jpeg', 'Kembangkan Sistem dan big data analytic', 1, NULL, NULL),
(3, '1638761689_1ee8af85c9b1b4f8ee5b.jpeg', 'Olahraga bukan hanya urusan individu', 1, NULL, NULL),
(4, '1638761583_c0d10721fde79e3224a5.jpg', 'Olahraga adalah ibadah', 1, NULL, NULL),
(5, '1638761953_37739d0da03652bb60cd.png', 'Ekonomi Digital Untuk Indonesia Lebih Sejahtera', 1, NULL, NULL),
(6, '1638761531_e0124927df005023b977.jpeg', 'Tumbuh Kembang Anak Media Digital', 1, NULL, NULL),
(7, '1666836763_7199eae813fcf44003c1.jpg', 'Manfaat Teknologi Digital bagi Pendidikan Anak', 1, NULL, NULL),
(8, '1686534572_a7e9c1a20c4035682736.png', 'Dapatkan full source code', 0, 'transparansi', NULL),
(9, '1666836591_a7f275b099bba1f337dc.png', 'Efek Negatif Teknologi Digital pada Anak', 1, NULL, NULL),
(11, '1686534457_11fb05aa64bcacf502ea.png', 'Banner New', 0, 'survey', NULL),
(14, '1658642029_3da19d397e07fd8c975c.jpeg', 'Tetap Terapkan Protokol Kesehatan', 2, 'http://cms.datagoe.com', '1'),
(15, '1658642640_69884874a473394ca728.jpg', 'Selamat Hari Pancasila Tahun 2022', 2, '#', '1'),
(16, '1658648273_b04aa409496d163c1684.jpeg', 'Ucapan Selamat Hari Otonomi Lembata', 2, 'http://cms.datagoe.com', '2'),
(17, '1666587280_0cef4b8a5570755da611.jpg', 'Stop Gratifikasi', 2, 'http://cms.datagoe.com', '3');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_setaplikasi`
--
CREATE TABLE `tbl_setaplikasi` (
`id_setaplikasi` int(11) NOT NULL,
`nama` varchar(200) DEFAULT NULL,
`alamat` varchar(200) DEFAULT NULL,
`no_telp` varchar(100) DEFAULT NULL,
`kecamatan` varchar(120) DEFAULT NULL,
`kabupaten` varchar(120) DEFAULT NULL,
`provinsi` varchar(120) DEFAULT NULL,
`website` varchar(200) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`deskripsi` text DEFAULT NULL,
`logo` varchar(200) DEFAULT NULL,
`sts_sambutan` varchar(1) DEFAULT NULL,
`icon` varchar(255) DEFAULT NULL,
`google_map` text DEFAULT NULL,
`nama_pimpinan` varchar(100) DEFAULT NULL,
`jabatan_pimpinan` varchar(100) DEFAULT NULL,
`sambutan` text DEFAULT NULL,
`gbr_sambutan` varchar(200) DEFAULT NULL,
`link_gmap` varchar(200) DEFAULT NULL,
`sosmed_fb` varchar(200) DEFAULT NULL,
`sosmed_instagram` varchar(200) DEFAULT NULL,
`sosmed_twiter` varchar(200) DEFAULT NULL,
`sosmed_youtube` varchar(200) DEFAULT NULL,
`kategori_id` int(11) DEFAULT NULL,
`judul_section` varchar(50) DEFAULT NULL,
`sts_section` varchar(1) DEFAULT NULL,
`sts_modal` varchar(1) DEFAULT NULL,
`ck` varchar(1) DEFAULT NULL,
`sts_count` varchar(1) DEFAULT NULL,
`sts_rt` varchar(1) DEFAULT NULL,
`hplogo` int(11) DEFAULT NULL,
`wllogo` int(11) DEFAULT NULL,
`hpbanner` int(11) DEFAULT NULL,
`wlbanner` int(11) DEFAULT NULL,
`sts_regis` varchar(1) DEFAULT NULL,
`sts_web` varchar(1) DEFAULT NULL,
`sts_posting` varchar(1) DEFAULT NULL COMMENT '0=langsung aktif\r\n1=verifikasi admin',
`verbost` varchar(1) DEFAULT NULL COMMENT '0=ver 4\r\n1=ver 5',
`smtp_host` varchar(200) DEFAULT NULL,
`smtp_username` varchar(50) DEFAULT NULL,
`smtp_password` varchar(255) DEFAULT NULL,
`smtp_port` int(5) DEFAULT NULL,
`smtp_pengirim` varchar(100) DEFAULT NULL,
`smtp_pesanbalas` text DEFAULT NULL,
`g_sitekey` varchar(50) DEFAULT NULL,
`g_secretkey` varchar(50) DEFAULT NULL,
`vercms` varchar(20) DEFAULT NULL,
`verdb` varchar(100) DEFAULT NULL,
`konek_opd` tinyint(1) DEFAULT 0,
`id_grup` int(11) DEFAULT 3,
`footer_cms` text DEFAULT NULL,
`ukuran_upload` int(5) DEFAULT NULL,
`tokenwa` varchar(50) DEFAULT NULL,
`no_waysender` varchar(20) DEFAULT NULL,
`wa_penerima` varchar(20) DEFAULT NULL,
`katamutiara` text DEFAULT NULL,
`namasingkat` varchar(200) DEFAULT NULL,
`urlserver` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tbl_setaplikasi`
--
INSERT INTO `tbl_setaplikasi` (`id_setaplikasi`, `nama`, `alamat`, `no_telp`, `kecamatan`, `kabupaten`, `provinsi`, `website`, `email`, `deskripsi`, `logo`, `sts_sambutan`, `icon`, `google_map`, `nama_pimpinan`, `jabatan_pimpinan`, `sambutan`, `gbr_sambutan`, `link_gmap`, `sosmed_fb`, `sosmed_instagram`, `sosmed_twiter`, `sosmed_youtube`, `kategori_id`, `judul_section`, `sts_section`, `sts_modal`, `ck`, `sts_count`, `sts_rt`, `hplogo`, `wllogo`, `hpbanner`, `wlbanner`, `sts_regis`, `sts_web`, `sts_posting`, `verbost`, `smtp_host`, `smtp_username`, `smtp_password`, `smtp_port`, `smtp_pengirim`, `smtp_pesanbalas`, `g_sitekey`, `g_secretkey`, `vercms`, `verdb`, `konek_opd`, `id_grup`, `footer_cms`, `ukuran_upload`, `tokenwa`, `no_waysender`, `wa_penerima`, `katamutiara`, `namasingkat`, `urlserver`) VALUES
(1, 'Website Lembaga', 'Jln. Protocol Utama', '+62123456789', 'Lebatukan', 'Malang', 'Jawa Timur', 'https://aplikasipendidikan.net', 'shareaplikasipendidikan@gmail.com', 'MAN 1 Kota Baru, Madrasah Mandiri, Berakhlak dan Berprestasi', '1686532732_ac5f3faaff364161f375.png', '1', 'icon.png', '', 'H. Dadan Iskandar, M.Pd', 'Kepala Madrasah', ' ssalamu’alaikum Warohmatullahi Wabarokatuh
Alhamdulillah, segala puji dan syukur kita panjatkan ke hadirat Allah SWT yang telah melimpahkan nikmat kepada kita semua mulai dari nikmat sehat, iman dan kesempatan untuk dapat mengabdi di bidang pendidikan untuk mencerdaskan anak bangsa.
Pendidikan adalah modal utama bagi suatu bangsa dalam upaya meningkatkan kualitas sumberdaya manusia yang dimilikinya. Sumberdaya manusia yang berkualitas akan mampu mengelola sumber daya alam untuk meningkatkan kesejahteraan masyarakat.
MAN 2 Kota Malang sebagai salah satu Madrasah unggulan senantiasa berusaha mewujudkan apa yang menjadi harapan pemerintah dan masyarakat melalui serangkaian kegiatan dan program kerja yang berorientasi kepada peningkatan kualitas dan daya saing lulusan yang berakhlaqul karimah.
Dalam rangka merealisasikan hal tersebut perlu dijalin kerjasama dan komunikasi yang baik antara pihak Madrasah, Masyarakat (Komite) dan pemerintah yang mengurusi lembaga pendidikan yakni Kemenag dan Kemendikbud Ristek.
Website ini kami hadirkan dalam rangka untuk menjalin komunikasi dan mengawali kerjasama yang baik antara pihak Madrasah, Peserta didik, Wali murid, Masyarakat dan Pemerintah, dan pada akhirnya komunikasi ini akan sangat berguna bagi semua pihak yang berkepentingan dengan dunia pendidikan. Semoga situs web ini dapat memberikan manfaat bagi siapa saja yang mengunjungi. Terimakasih.
Wassalamu’alaikum Warohmatullahi Wabarokatuh
', '1686531890_97119edf5a65a19f7d2f.png', 'https://goo.gl/maps/QVtSNqKmgkHTBUCN8', 'https://www.facebook.com/aplikasipendidikanet', 'https://www.instagram.com/aplikasipendidikanet/', 'https://twitter.com/aplikasipendik1', 'https://www.youtube.com/channel/UCsiAiiC3LKnkeoHp2brYefA', 1, 'INFORMASI INSTANSI', '1', '1', '1', '1', '1', 55, 255, 600, 1800, '1', '1', '1', '0', 'smtp.hostinger.com', 'cs@aplikasipendidikan.net', 'Derilkepotil21', 465, 'CMS LEMBAGA', 'Terima Kasih telah menghubungi kami..!', '', '', '3.0.4', NULL, 1, 3, 'Dibuat dengan Oleh Aplikasi Pendidikan ', NULL, '', '', '', 'Jangan berhenti ketika kamu lelah, tetapi berhentilah ketika kamu sudah selesai.', 'MAN ONE', 'https://waysender-v2.ridped.com');
-- --------------------------------------------------------
--
-- Table structure for table `template`
--
CREATE TABLE `template` (
`template_id` int(5) NOT NULL,
`nama` varchar(100) DEFAULT NULL,
`pembuat` varchar(50) DEFAULT NULL,
`folder` varchar(50) DEFAULT NULL,
`status` int(1) DEFAULT NULL,
`id` int(11) UNSIGNED NOT NULL,
`ket` varchar(255) DEFAULT NULL,
`img` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `template`
--
INSERT INTO `template` (`template_id`, `nama`, `pembuat`, `folder`, `status`, `id`, `ket`, `img`) VALUES
(1, 'Web PLUS 1', 'Rp.850.000', 'plus1', 0, 1, 'Ukuran logo: Tinggi 121px Lebar 112px ', '1664432678_54cd12a3ae164bb4b421.jpg'),
(2, 'Web PLUS 2', 'Rp.750.000', 'plus2', 0, 1, 'Ukuran logo : Tinggi 90px Lebar 375px', '1664432530_bf187694af6636360050.jpg'),
(7, 'One Page', 'Vian Taum', 'onepage', 0, 1, 'Tema dengan Satu Halaman', NULL),
(9, 'Sekolah', 'Rp.250.000', 'basic', 1, 1, 'Ukuran logo : Tinggi 55px Lebar 255px', '1686629862_ffdab370255bfec87902.png'),
(10, 'Template NEWS', '1.500.000', 'news', 0, 1, 'Tema Portal Berita', 'default.png');
-- --------------------------------------------------------
--
-- Table structure for table `transparan`
--
CREATE TABLE `transparan` (
`transparan_id` int(11) NOT NULL,
`id` int(11) UNSIGNED NOT NULL DEFAULT 1,
`judul` varchar(255) DEFAULT NULL,
`tahun` varchar(4) DEFAULT NULL,
`jenis` varchar(1) DEFAULT NULL COMMENT '0=Pendapatan\r\n1=Pengeluaran',
`sts` varchar(1) DEFAULT NULL,
`vawal` varchar(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `transparan`
--
INSERT INTO `transparan` (`transparan_id`, `id`, `judul`, `tahun`, `jenis`, `sts`, `vawal`) VALUES
(1, 1, 'Realisasi Pendapatan Tahun Anggaran 2015', '2015', '0', '1', '0'),
(2, 1, 'Realisasi Belanja Tahun Anggaran 2015', '2015', '1', '1', '1');
-- --------------------------------------------------------
--
-- Table structure for table `transparan_detail`
--
CREATE TABLE `transparan_detail` (
`transparandetail_id` int(11) NOT NULL,
`transparan_id` int(11) DEFAULT NULL,
`transparan_nama` varchar(250) DEFAULT NULL,
`transparan_jumlah` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `transparan_detail`
--
INSERT INTO `transparan_detail` (`transparandetail_id`, `transparan_id`, `transparan_nama`, `transparan_jumlah`) VALUES
(1, 1, 'Pembentukan Dana Cadangan', 11500),
(2, 1, 'Penyertaan Modal', 3307),
(3, 1, 'Retribusi', 379),
(4, 1, 'Pajak Daerah', 240),
(8, 2, 'Belanja Pegawai', 1208),
(9, 2, 'Belanja Hibah', 2126),
(10, 2, 'Belanja Bantuan Sosial', 342),
(11, 2, 'Belanja Bagi Hasil kepada kepada Provinsi', 159),
(12, 2, 'Belanja tidak terduga', 1007);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) UNSIGNED NOT NULL,
`email` varchar(255) NOT NULL,
`username` varchar(30) DEFAULT NULL,
`opd_id` int(11) DEFAULT 0,
`id_grup` int(11) DEFAULT 1,
`fullname` varchar(255) DEFAULT NULL,
`user_image` varchar(255) NOT NULL DEFAULT 'avatar.PNG',
`password_hash` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT 0,
`level` varchar(15) DEFAULT NULL,
`new_email` varchar(191) DEFAULT NULL,
`activate_hash` varchar(191) DEFAULT NULL,
`reset_hash` varchar(191) DEFAULT NULL,
`reset_expires` bigint(20) DEFAULT NULL,
`created_at` varchar(50) DEFAULT NULL,
`updated_at` varchar(50) DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`sts_on` varchar(1) DEFAULT NULL,
`login_attempts` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `email`, `username`, `opd_id`, `id_grup`, `fullname`, `user_image`, `password_hash`, `active`, `level`, `new_email`, `activate_hash`, `reset_hash`, `reset_expires`, `created_at`, `updated_at`, `last_login`, `sts_on`, `login_attempts`) VALUES
(1, 'shareaplikasipendidikan@gmail.com', 'admin', 0, 1, 'Aplikasi Pendidikan', '1649394521_dd7f9ba3dc6b70c44beb.png', '$2y$10$r8qpXJVHdYRMLFOuL/In3.R8LbLDovMpivG3O0P2zp7Sa09LhP6D.', 1, 'admin', NULL, NULL, NULL, NULL, NULL, '2021-10-14 10:05:30', '2023-06-13 11:43:24', '1', 0),
(17, 'ops1@gmail.com', 'operator', 4, 3, 'Wulan Mulyani', '1686545674_d2aa21e525f5c126aeb7.png', '$2y$10$LYHgHYavES0q8/t4CnpvGu6MNQ44HjwwysAR4a5ey80/rCEyLbr4O', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-12 12:57:12', '0', 0);
-- --------------------------------------------------------
--
-- Table structure for table `video`
--
CREATE TABLE `video` (
`video_id` int(11) NOT NULL,
`kategorivideo_id` int(11) DEFAULT NULL,
`judul` varchar(255) DEFAULT NULL,
`video_link` varchar(200) DEFAULT NULL,
`tanggal` date DEFAULT NULL,
`id` int(11) UNSIGNED DEFAULT NULL,
`sts_v` varchar(1) DEFAULT NULL,
`ket_video` text DEFAULT NULL,
`hits` int(11) DEFAULT NULL,
`likevideo` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `video`
--
INSERT INTO `video` (`video_id`, `kategorivideo_id`, `judul`, `video_link`, `tanggal`, `id`, `sts_v`, `ket_video`, `hits`, `likevideo`) VALUES
(7, 11, 'Absen Siswa Selvie', 'MjME00R4oMg', '2023-06-12', 1, '1', 'Absensi Scan QR Code Gratis', NULL, 0),
(8, 11, 'Absen Madrasah', 'jbE7YKV2RCc', '2023-06-12', 1, '1', 'Absensi Scan QR Code Gratis', NULL, 0),
(9, 11, 'Absen QR Code', '6hnmYIgiYOE', '2023-06-12', 1, '1', 'Absensi Scan QR Code Gratis', NULL, 0),
(10, 12, 'Garuda CBT', 'DTYrlGCJv8A', '2023-06-12', 1, '1', 'Umbk Cbt Free', NULL, 0),
(11, 12, 'Bee El-scbt', 'gYcQYy2xgS0', '2023-06-12', 1, '1', 'Umbk Cbt Free', NULL, 0),
(12, 12, 'Edmad CBT', 'ubIQzmrdIpk', '2023-06-12', 1, '1', 'Umbk Cbt Free', NULL, 0),
(13, 12, 'OCBTX', '1BXJ3dZemfA', '2023-06-12', 1, '1', 'Umbk Cbt Free', NULL, 0),
(14, 12, 'UMBK CBt', 'MBWdVoG_rVA', '2023-06-12', 1, '1', 'Umbk Cbt Free', NULL, 0);
-- --------------------------------------------------------
--
-- Table structure for table `visitor`
--
CREATE TABLE `visitor` (
`ip` varchar(20) DEFAULT NULL,
`tgl` date DEFAULT NULL,
`hits` int(11) DEFAULT NULL,
`online` varchar(255) DEFAULT NULL,
`time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `visitor`
--
INSERT INTO `visitor` (`ip`, `tgl`, `hits`, `online`, `time`) VALUES
('127.0.0.1', '2022-06-13', 8, '1655109007', '2022-06-13 16:30:07'),
('127.0.0.1', '2022-06-17', 20, '1655476361', '2022-06-17 22:32:41'),
('127.0.0.1', '2022-07-10', 1, '1657458147', '2022-07-10 21:02:27'),
('127.0.0.1', '2022-10-03', 11, '1664764110', '2022-10-03 10:28:30'),
('::1', '2022-10-31', 136, '1667229750', '2022-10-31 23:22:30'),
('::1', '2022-11-01', 677, '1667318348', '2022-11-01 23:59:08'),
('::1', '2022-11-02', 149, '1667398747', '2022-11-02 22:19:07'),
('::1', '2022-11-03', 80, '1667454495', '2022-11-03 13:48:15'),
('::1', '2022-11-04', 46, '1667542400', '2022-11-04 14:13:20'),
('::1', '2022-11-05', 330, '1667657356', '2022-11-05 22:09:16'),
('::1', '2022-11-07', 2, '1667822418', '2022-11-07 20:00:18'),
('::1', '2022-11-08', 5, '1667903110', '2022-11-08 18:25:10'),
('::1', '2022-11-14', 5, '1668411122', '2022-11-14 15:32:02'),
('::1', '2022-11-22', 1, '1669078196', '2022-11-22 08:49:56'),
('::1', '2022-11-30', 92, '1669804540', '2022-11-30 18:35:40'),
('::1', '2022-12-01', 13, '1669893392', '2022-12-01 19:16:32'),
('::1', '2022-12-02', 6, '1669952380', '2022-12-02 11:39:40'),
('::1', '2022-12-13', 2, '1670919791', '2022-12-13 16:23:11'),
('::1', '2022-12-14', 1, '1670996975', '2022-12-14 13:49:35'),
('::1', '2022-12-19', 132, '1671454963', '2022-12-19 21:02:43'),
('::1', '2022-12-23', 7, '1671763882', '2022-12-23 10:51:22'),
('::1', '2023-01-12', 15, '1673509136', '2023-01-12 15:38:56'),
('::1', '2023-01-16', 1, '1673879284', '2023-01-16 22:28:04'),
('::1', '2023-01-17', 6, '1673949496', '2023-01-17 17:58:16'),
('::1', '2023-01-18', 34, '1674022545', '2023-01-18 14:15:45'),
('::1', '2023-01-19', 27, '1674138427', '2023-01-19 22:27:07'),
('::1', '2023-01-26', 9, '1674739595', '2023-01-26 21:26:35'),
('::1', '2023-01-27', 7, '1674791928', '2023-01-27 11:58:48'),
('::1', '2023-01-28', 6, '1674911763', '2023-01-28 21:16:03'),
('::1', '2023-01-31', 155, '1675167242', '2023-01-31 20:14:02'),
('::1', '2023-02-01', 35, '1675258662', '2023-02-01 21:37:42'),
('::1', '2023-02-02', 84, '1675335026', '2023-02-02 18:50:26'),
('::1', '2023-02-03', 15, '1675425207', '2023-02-03 19:53:27'),
('::1', '2023-02-04', 63, '1675518401', '2023-02-04 21:46:41'),
('::1', '2023-02-05', 8, '1675588789', '2023-02-05 17:19:49'),
('::1', '2023-02-07', 1, '1675776093', '2023-02-07 21:21:33'),
('::1', '2023-02-09', 4, '1675932161', '2023-02-09 16:42:41'),
('::1', '2023-02-13', 10, '1676299597', '2023-02-13 22:46:37'),
('::1', '2023-02-14', 31, '1676378392', '2023-02-14 20:39:52'),
('::1', '2023-02-15', 31, '1676434317', '2023-02-15 12:11:57'),
('::1', '2023-02-16', 18, '1676541719', '2023-02-16 18:01:59'),
('::1', '2023-02-17', 1, '1676624703', '2023-02-17 17:05:03'),
('::1', '2023-02-25', 1, '1677298602', '2023-02-25 12:16:42'),
('::1', '2023-02-27', 26, '1677509637', '2023-02-27 22:53:57'),
('::1', '2023-02-28', 16, '1677594206', '2023-02-28 22:23:26'),
('::1', '2023-03-02', 4, '1677762605', '2023-03-02 21:10:05'),
('::1', '2023-03-03', 3, '1677849214', '2023-03-03 21:13:34'),
('::1', '2023-03-04', 8, '1677918217', '2023-03-04 16:23:37'),
('::1', '2023-03-05', 25, '1678021868', '2023-03-05 21:11:08'),
('::1', '2023-03-06', 28, '1678080889', '2023-03-06 13:34:49'),
('::1', '2023-03-07', 109, '1678163470', '2023-03-07 12:31:10'),
('::1', '2023-03-10', 1, '1678463246', '2023-03-10 23:47:26'),
('::1', '2023-03-12', 37, '1678593428', '2023-03-12 11:57:08'),
('::1', '2023-03-17', 10, '1679024601', '2023-03-17 11:43:21'),
('::1', '2023-03-18', 8, '1679148392', '2023-03-18 22:06:32'),
('::1', '2023-03-19', 5, '1679237452', '2023-03-19 22:50:52'),
('::1', '2023-03-20', 23, '1679292354', '2023-03-20 14:05:54'),
('::1', '2023-03-21', 64, '1679413121', '2023-03-21 23:38:41'),
('::1', '2023-03-22', 22, '1679493948', '2023-03-22 22:05:48'),
('::1', '2023-03-23', 13, '1679548657', '2023-03-23 13:17:37'),
('::1', '2023-03-25', 11, '1679746205', '2023-03-25 20:10:05'),
('::1', '2023-03-26', 87, '1679840408', '2023-03-26 22:20:08'),
('::1', '2023-03-27', 30, '1679932594', '2023-03-27 23:56:34'),
('::1', '2023-03-28', 42, '1680010895', '2023-03-28 21:41:35'),
('::1', '2023-03-29', 16, '1680063746', '2023-03-29 12:22:26'),
('::1', '2023-06-12', 100, '1686550650', '2023-06-12 14:17:30'),
('127.0.0.1', '2023-06-12', 20, '1686540633', '2023-06-12 11:30:33'),
('::1', '2023-06-13', 7, '1686630090', '2023-06-13 12:21:30'),
('127.0.0.1', '2023-06-13', 6, '1686629892', '2023-06-13 12:18:12'),
('::1', '2023-06-14', 1, '1686709816', '2023-06-14 10:30:16');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `agenda`
--
ALTER TABLE `agenda`
ADD PRIMARY KEY (`agenda_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `bankdata`
--
ALTER TABLE `bankdata`
ADD PRIMARY KEY (`bankdata_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `berita`
--
ALTER TABLE `berita`
ADD PRIMARY KEY (`berita_id`),
ADD KEY `id` (`id`),
ADD KEY `kategori_id` (`kategori_id`);
--
-- Indexes for table `berita_komen`
--
ALTER TABLE `berita_komen`
ADD PRIMARY KEY (`beritakomen_id`),
ADD KEY `id` (`id`),
ADD KEY `berita_id` (`berita_id`);
--
-- Indexes for table `berita_tag`
--
ALTER TABLE `berita_tag`
ADD PRIMARY KEY (`beritatag_id`),
ADD KEY `berita_id` (`berita_id`),
ADD KEY `tag_id` (`tag_id`);
--
-- Indexes for table `bt_bidang`
--
ALTER TABLE `bt_bidang`
ADD PRIMARY KEY (`bidang_id`);
--
-- Indexes for table `bt_bukutamu`
--
ALTER TABLE `bt_bukutamu`
ADD PRIMARY KEY (`bukutamu_id`),
ADD KEY `bidang_id` (`bidang_id`);
--
-- Indexes for table `cms__grupakses`
--
ALTER TABLE `cms__grupakses`
ADD PRIMARY KEY (`id_grupakses`),
ADD KEY `id_grup` (`id_grup`),
ADD KEY `id_modul` (`id_modul`);
--
-- Indexes for table `cms__modpublic`
--
ALTER TABLE `cms__modpublic`
ADD PRIMARY KEY (`id_modpublic`);
--
-- Indexes for table `cms__modul`
--
ALTER TABLE `cms__modul`
ADD PRIMARY KEY (`id_modul`);
--
-- Indexes for table `cms__usergrup`
--
ALTER TABLE `cms__usergrup`
ADD PRIMARY KEY (`id_grup`);
--
-- Indexes for table `counter`
--
ALTER TABLE `counter`
ADD PRIMARY KEY (`id_counter`);
--
-- Indexes for table `custome__anggota`
--
ALTER TABLE `custome__anggota`
ADD PRIMARY KEY (`anggota_id`);
--
-- Indexes for table `custome__opd`
--
ALTER TABLE `custome__opd`
ADD PRIMARY KEY (`opd_id`),
ADD KEY `tipe_id` (`tipe_id`);
--
-- Indexes for table `custome__opdtipe`
--
ALTER TABLE `custome__opdtipe`
ADD PRIMARY KEY (`tipe_id`);
--
-- Indexes for table `ebook`
--
ALTER TABLE `ebook`
ADD PRIMARY KEY (`ebook_id`),
ADD KEY `kategoriebook_id` (`kategoriebook_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `faq_jawab`
--
ALTER TABLE `faq_jawab`
ADD PRIMARY KEY (`faq_jawabid`),
ADD KEY `faq_tanyaid` (`faq_tanyaid`);
--
-- Indexes for table `faq_tanya`
--
ALTER TABLE `faq_tanya`
ADD PRIMARY KEY (`faq_tanyaid`);
--
-- Indexes for table `fasilitas`
--
ALTER TABLE `fasilitas`
ADD PRIMARY KEY (`fasilitas_id`);
--
-- Indexes for table `fasilitas_detail`
--
ALTER TABLE `fasilitas_detail`
ADD PRIMARY KEY (`fasilitasdetail_id`),
ADD KEY `fasilitas_id` (`fasilitas_id`);
--
-- Indexes for table `foto`
--
ALTER TABLE `foto`
ADD PRIMARY KEY (`foto_id`),
ADD KEY `id` (`id`),
ADD KEY `kategorifoto_id` (`kategorifoto_id`);
--
-- Indexes for table `informasi`
--
ALTER TABLE `informasi`
ADD PRIMARY KEY (`informasi_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `kategori`
--
ALTER TABLE `kategori`
ADD PRIMARY KEY (`kategori_id`);
--
-- Indexes for table `kategori_ebook`
--
ALTER TABLE `kategori_ebook`
ADD PRIMARY KEY (`kategoriebook_id`);
--
-- Indexes for table `kategori_foto`
--
ALTER TABLE `kategori_foto`
ADD PRIMARY KEY (`kategorifoto_id`);
--
-- Indexes for table `kategori_video`
--
ALTER TABLE `kategori_video`
ADD PRIMARY KEY (`kategorivideo_id`);
--
-- Indexes for table `kritiksaran`
--
ALTER TABLE `kritiksaran`
ADD PRIMARY KEY (`kritiksaran_id`);
--
-- Indexes for table `link_terkait`
--
ALTER TABLE `link_terkait`
ADD PRIMARY KEY (`id_link`);
--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
ADD PRIMARY KEY (`menu_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `modalpopup`
--
ALTER TABLE `modalpopup`
ADD PRIMARY KEY (`modalpopup_id`);
--
-- Indexes for table `pegawai`
--
ALTER TABLE `pegawai`
ADD PRIMARY KEY (`pegawai_id`);
--
-- Indexes for table `poling`
--
ALTER TABLE `poling`
ADD PRIMARY KEY (`poling_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `produk_hukum`
--
ALTER TABLE `produk_hukum`
ADD PRIMARY KEY (`produk_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `produk_kathukum`
--
ALTER TABLE `produk_kathukum`
ADD PRIMARY KEY (`kathukum_id`),
ADD KEY `produk_id` (`produk_id`);
--
-- Indexes for table `produk_subkathukum`
--
ALTER TABLE `produk_subkathukum`
ADD PRIMARY KEY (`subkathukum_id`),
ADD KEY `kathukum_id` (`kathukum_id`);
--
-- Indexes for table `section`
--
ALTER TABLE `section`
ADD PRIMARY KEY (`section_id`);
--
-- Indexes for table `submenu`
--
ALTER TABLE `submenu`
ADD PRIMARY KEY (`submenu_id`),
ADD KEY `menu_id` (`menu_id`);
--
-- Indexes for table `subsubmenu`
--
ALTER TABLE `subsubmenu`
ADD PRIMARY KEY (`subsubmenu_id`),
ADD KEY `submenu_id` (`submenu_id`);
--
-- Indexes for table `survey_jawaban`
--
ALTER TABLE `survey_jawaban`
ADD PRIMARY KEY (`jawaban_id`),
ADD KEY `pertanyaan_id` (`pertanyaan_id`);
--
-- Indexes for table `survey_pertanyaan`
--
ALTER TABLE `survey_pertanyaan`
ADD PRIMARY KEY (`pertanyaan_id`),
ADD KEY `survey_id` (`survey_id`);
--
-- Indexes for table `survey_responden`
--
ALTER TABLE `survey_responden`
ADD PRIMARY KEY (`responden_id`),
ADD KEY `survey_id` (`survey_id`);
--
-- Indexes for table `survey_topik`
--
ALTER TABLE `survey_topik`
ADD PRIMARY KEY (`survey_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `tag`
--
ALTER TABLE `tag`
ADD PRIMARY KEY (`tag_id`);
--
-- Indexes for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
ADD PRIMARY KEY (`id_banner`);
--
-- Indexes for table `tbl_setaplikasi`
--
ALTER TABLE `tbl_setaplikasi`
ADD PRIMARY KEY (`id_setaplikasi`),
ADD KEY `kategori_id` (`kategori_id`),
ADD KEY `id_grup` (`id_grup`);
--
-- Indexes for table `template`
--
ALTER TABLE `template`
ADD PRIMARY KEY (`template_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `transparan`
--
ALTER TABLE `transparan`
ADD PRIMARY KEY (`transparan_id`),
ADD KEY `id` (`id`);
--
-- Indexes for table `transparan_detail`
--
ALTER TABLE `transparan_detail`
ADD PRIMARY KEY (`transparandetail_id`),
ADD KEY `transparan_id` (`transparan_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `email` (`email`),
ADD UNIQUE KEY `username` (`username`),
ADD KEY `username_2` (`username`),
ADD KEY `username_3` (`username`),
ADD KEY `opd_id` (`opd_id`),
ADD KEY `id_grup` (`id_grup`);
--
-- Indexes for table `video`
--
ALTER TABLE `video`
ADD PRIMARY KEY (`video_id`),
ADD KEY `id` (`id`),
ADD KEY `kategorivideo_id` (`kategorivideo_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `agenda`
--
ALTER TABLE `agenda`
MODIFY `agenda_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `bankdata`
--
ALTER TABLE `bankdata`
MODIFY `bankdata_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `berita`
--
ALTER TABLE `berita`
MODIFY `berita_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `berita_komen`
--
ALTER TABLE `berita_komen`
MODIFY `beritakomen_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `berita_tag`
--
ALTER TABLE `berita_tag`
MODIFY `beritatag_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT for table `bt_bidang`
--
ALTER TABLE `bt_bidang`
MODIFY `bidang_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `bt_bukutamu`
--
ALTER TABLE `bt_bukutamu`
MODIFY `bukutamu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `cms__grupakses`
--
ALTER TABLE `cms__grupakses`
MODIFY `id_grupakses` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=168;
--
-- AUTO_INCREMENT for table `cms__modpublic`
--
ALTER TABLE `cms__modpublic`
MODIFY `id_modpublic` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `cms__modul`
--
ALTER TABLE `cms__modul`
MODIFY `id_modul` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;
--
-- AUTO_INCREMENT for table `cms__usergrup`
--
ALTER TABLE `cms__usergrup`
MODIFY `id_grup` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `counter`
--
ALTER TABLE `counter`
MODIFY `id_counter` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `custome__anggota`
--
ALTER TABLE `custome__anggota`
MODIFY `anggota_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `custome__opd`
--
ALTER TABLE `custome__opd`
MODIFY `opd_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `custome__opdtipe`
--
ALTER TABLE `custome__opdtipe`
MODIFY `tipe_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `ebook`
--
ALTER TABLE `ebook`
MODIFY `ebook_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `faq_jawab`
--
ALTER TABLE `faq_jawab`
MODIFY `faq_jawabid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `faq_tanya`
--
ALTER TABLE `faq_tanya`
MODIFY `faq_tanyaid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `fasilitas`
--
ALTER TABLE `fasilitas`
MODIFY `fasilitas_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `fasilitas_detail`
--
ALTER TABLE `fasilitas_detail`
MODIFY `fasilitasdetail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `foto`
--
ALTER TABLE `foto`
MODIFY `foto_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;
--
-- AUTO_INCREMENT for table `informasi`
--
ALTER TABLE `informasi`
MODIFY `informasi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `kategori`
--
ALTER TABLE `kategori`
MODIFY `kategori_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `kategori_ebook`
--
ALTER TABLE `kategori_ebook`
MODIFY `kategoriebook_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `kategori_foto`
--
ALTER TABLE `kategori_foto`
MODIFY `kategorifoto_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `kategori_video`
--
ALTER TABLE `kategori_video`
MODIFY `kategorivideo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `kritiksaran`
--
ALTER TABLE `kritiksaran`
MODIFY `kritiksaran_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `link_terkait`
--
ALTER TABLE `link_terkait`
MODIFY `id_link` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `modalpopup`
--
ALTER TABLE `modalpopup`
MODIFY `modalpopup_id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `pegawai`
--
ALTER TABLE `pegawai`
MODIFY `pegawai_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
--
-- AUTO_INCREMENT for table `poling`
--
ALTER TABLE `poling`
MODIFY `poling_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `produk_hukum`
--
ALTER TABLE `produk_hukum`
MODIFY `produk_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `produk_kathukum`
--
ALTER TABLE `produk_kathukum`
MODIFY `kathukum_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `produk_subkathukum`
--
ALTER TABLE `produk_subkathukum`
MODIFY `subkathukum_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `section`
--
ALTER TABLE `section`
MODIFY `section_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `submenu`
--
ALTER TABLE `submenu`
MODIFY `submenu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `subsubmenu`
--
ALTER TABLE `subsubmenu`
MODIFY `subsubmenu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `survey_jawaban`
--
ALTER TABLE `survey_jawaban`
MODIFY `jawaban_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `survey_pertanyaan`
--
ALTER TABLE `survey_pertanyaan`
MODIFY `pertanyaan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `survey_responden`
--
ALTER TABLE `survey_responden`
MODIFY `responden_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `survey_topik`
--
ALTER TABLE `survey_topik`
MODIFY `survey_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tag`
--
ALTER TABLE `tag`
MODIFY `tag_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
MODIFY `id_banner` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `tbl_setaplikasi`
--
ALTER TABLE `tbl_setaplikasi`
MODIFY `id_setaplikasi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `template`
--
ALTER TABLE `template`
MODIFY `template_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `transparan`
--
ALTER TABLE `transparan`
MODIFY `transparan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `transparan_detail`
--
ALTER TABLE `transparan_detail`
MODIFY `transparandetail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `video`
--
ALTER TABLE `video`
MODIFY `video_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `agenda`
--
ALTER TABLE `agenda`
ADD CONSTRAINT `agenda_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
--
-- Constraints for table `bankdata`
--
ALTER TABLE `bankdata`
ADD CONSTRAINT `bankdata_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
--
-- Constraints for table `berita`
--
ALTER TABLE `berita`
ADD CONSTRAINT `berita_ibfk_1` FOREIGN KEY (`kategori_id`) REFERENCES `kategori` (`kategori_id`) ON UPDATE CASCADE,
ADD CONSTRAINT `berita_ibfk_2` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
--
-- Constraints for table `berita_tag`
--
ALTER TABLE `berita_tag`
ADD CONSTRAINT `berita_tag_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON UPDATE CASCADE;
--
-- Constraints for table `bt_bukutamu`
--
ALTER TABLE `bt_bukutamu`
ADD CONSTRAINT `bt_bukutamu_ibfk_1` FOREIGN KEY (`bidang_id`) REFERENCES `bt_bidang` (`bidang_id`) ON UPDATE CASCADE;
--
-- Constraints for table `cms__grupakses`
--
ALTER TABLE `cms__grupakses`
ADD CONSTRAINT `cms__grupakses_ibfk_2` FOREIGN KEY (`id_modul`) REFERENCES `cms__modul` (`id_modul`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `cms__grupakses_ibfk_3` FOREIGN KEY (`id_grup`) REFERENCES `cms__usergrup` (`id_grup`) ON DELETE CASCADE;
--
-- Constraints for table `custome__opd`
--
ALTER TABLE `custome__opd`
ADD CONSTRAINT `custome__opd_ibfk_1` FOREIGN KEY (`tipe_id`) REFERENCES `custome__opdtipe` (`tipe_id`) ON UPDATE CASCADE;
--
-- Constraints for table `ebook`
--
ALTER TABLE `ebook`
ADD CONSTRAINT `ebook_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE,
ADD CONSTRAINT `ebook_ibfk_2` FOREIGN KEY (`kategoriebook_id`) REFERENCES `kategori_ebook` (`kategoriebook_id`) ON UPDATE CASCADE;
--
-- Constraints for table `faq_jawab`
--
ALTER TABLE `faq_jawab`
ADD CONSTRAINT `faq_jawab_ibfk_1` FOREIGN KEY (`faq_tanyaid`) REFERENCES `faq_tanya` (`faq_tanyaid`) ON UPDATE CASCADE;
--
-- Constraints for table `fasilitas_detail`
--
ALTER TABLE `fasilitas_detail`
ADD CONSTRAINT `fasilitas_detail_ibfk_1` FOREIGN KEY (`fasilitas_id`) REFERENCES `fasilitas` (`fasilitas_id`) ON UPDATE CASCADE;
--
-- Constraints for table `foto`
--
ALTER TABLE `foto`
ADD CONSTRAINT `foto_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE,
ADD CONSTRAINT `foto_ibfk_2` FOREIGN KEY (`kategorifoto_id`) REFERENCES `kategori_foto` (`kategorifoto_id`) ON UPDATE CASCADE;
--
-- Constraints for table `informasi`
--
ALTER TABLE `informasi`
ADD CONSTRAINT `informasi_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
--
-- Constraints for table `poling`
--
ALTER TABLE `poling`
ADD CONSTRAINT `poling_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
--
-- Constraints for table `produk_hukum`
--
ALTER TABLE `produk_hukum`
ADD CONSTRAINT `produk_hukum_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
--
-- Constraints for table `produk_kathukum`
--
ALTER TABLE `produk_kathukum`
ADD CONSTRAINT `produk_kathukum_ibfk_1` FOREIGN KEY (`produk_id`) REFERENCES `produk_hukum` (`produk_id`) ON UPDATE CASCADE;
--
-- Constraints for table `produk_subkathukum`
--
ALTER TABLE `produk_subkathukum`
ADD CONSTRAINT `produk_subkathukum_ibfk_1` FOREIGN KEY (`kathukum_id`) REFERENCES `produk_kathukum` (`kathukum_id`) ON UPDATE CASCADE;
--
-- Constraints for table `submenu`
--
ALTER TABLE `submenu`
ADD CONSTRAINT `submenu_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`menu_id`) ON UPDATE CASCADE;
--
-- Constraints for table `subsubmenu`
--
ALTER TABLE `subsubmenu`
ADD CONSTRAINT `subsubmenu_ibfk_1` FOREIGN KEY (`submenu_id`) REFERENCES `submenu` (`submenu_id`) ON UPDATE CASCADE;
--
-- Constraints for table `survey_jawaban`
--
ALTER TABLE `survey_jawaban`
ADD CONSTRAINT `survey_jawaban_ibfk_1` FOREIGN KEY (`pertanyaan_id`) REFERENCES `survey_pertanyaan` (`pertanyaan_id`) ON UPDATE CASCADE;
--
-- Constraints for table `survey_pertanyaan`
--
ALTER TABLE `survey_pertanyaan`
ADD CONSTRAINT `survey_pertanyaan_ibfk_1` FOREIGN KEY (`survey_id`) REFERENCES `survey_topik` (`survey_id`) ON UPDATE CASCADE;
--
-- Constraints for table `survey_responden`
--
ALTER TABLE `survey_responden`
ADD CONSTRAINT `survey_responden_ibfk_1` FOREIGN KEY (`survey_id`) REFERENCES `survey_topik` (`survey_id`) ON UPDATE CASCADE;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;