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

START TRANSACTION;



--
-- Database: `smanbojo_db_cms_sekolahku_smanjo`
--

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

--
-- Table structure for table `academic_years`
--

CREATE TABLE `academic_years` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `academic_year` varchar(9) NOT NULL COMMENT 'Tahun Pelajaran',
  `semester` enum('odd','even') NOT NULL DEFAULT 'odd' COMMENT 'odd = Ganjil, even = Genap',
  `current_semester` enum('true','false') NOT NULL DEFAULT 'false',
  `admission_semester` enum('true','false') NOT NULL DEFAULT 'false',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `achievements`
--

CREATE TABLE `achievements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_id` bigint(20) DEFAULT 0,
  `achievement_description` varchar(255) NOT NULL,
  `achievement_type` bigint(20) DEFAULT 0,
  `achievement_level` smallint(6) NOT NULL DEFAULT 0,
  `achievement_year` year(4) NOT NULL,
  `achievement_organizer` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `admission_phases`
--

CREATE TABLE `admission_phases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `academic_year_id` bigint(20) DEFAULT 0 COMMENT 'Tahun Pelajaran',
  `phase_name` varchar(255) NOT NULL COMMENT 'Gelombang Pendaftaran',
  `phase_start_date` date DEFAULT NULL COMMENT 'Tanggal Mulai',
  `phase_end_date` date DEFAULT NULL COMMENT 'Tanggal Selesai',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `admission_quotas`
--

CREATE TABLE `admission_quotas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `academic_year_id` bigint(20) DEFAULT 0 COMMENT 'Tahun Pelajaran',
  `admission_type_id` bigint(20) DEFAULT 0 COMMENT 'Jalur Pendaftaran',
  `major_id` bigint(20) DEFAULT 0 COMMENT 'Program Keahlian',
  `quota` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Kuota Pendaftaran',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `albums`
--

CREATE TABLE `albums` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `album_title` varchar(255) NOT NULL,
  `album_description` varchar(255) DEFAULT NULL,
  `album_slug` varchar(255) DEFAULT NULL,
  `album_cover` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `albums`
--

INSERT INTO `albums` (`id`, `album_title`, `album_description`, `album_slug`, `album_cover`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Team Work Building 2023', 'Team Work Building', 'team-work-building-2023', '5cc26216a7c7b3b3a8fe688e3a3e2aa7.jpg', '2023-11-10 05:22:56', '2023-11-10 21:22:49', NULL, NULL, 1, 1, 0, 0, 'false'),
(2, 'Serah Terima Jabatan (Dadan Amdani-Sri Mulyawati) 3 Januari 2023', 'Serah Terima Jabatan (Dadan Amdani-Sri Mulyawati) 3 Januari 2023', 'serah-terima-jabatan-dadan-amdani-sri-mulyawati-3-januari-2023', '0a00ed9348b145f3d8b05eb2671a900b.jpg', '2023-11-11 04:14:54', '2023-11-10 23:28:24', NULL, NULL, 1, 1, 0, 0, 'false'),
(3, 'Serah Terima Jabatan (Nana Sutisa - Dadan Amdani) 10 November 2021', 'Serah Terima Jabatan (Nana Sutisn - Dadan Amdani)', 'serah-terima-jabatan-nana-sutisa-dadan-amdani-10-november-2021', 'b5d54cfa0a00843e26515968516fe983.jpg', '2023-11-14 05:15:35', '2023-11-13 22:18:53', NULL, NULL, 1, 1, 0, 0, 'false'),
(4, 'FOTO LOGO', 'Logo SMAN 1 Bojonegara', 'foto-logo', '35c86f8824ebfd140a64615034d9bae3.png', '2025-06-30 19:41:00', '2025-06-30 12:41:16', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `answers`
--

CREATE TABLE `answers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question_id` bigint(20) DEFAULT 0,
  `answer` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_slug` varchar(255) DEFAULT NULL,
  `category_description` varchar(255) DEFAULT NULL,
  `category_type` enum('post','file') DEFAULT 'post',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `category_name`, `category_slug`, `category_description`, `category_type`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'OSIS', 'osis', 'Kegiatan OSIS', 'post', '2023-01-15 21:23:22', '2023-11-09 05:04:18', NULL, NULL, 0, 1, 0, 0, 'false'),
(2, 'Download', 'download', 'Download', 'file', '2023-01-15 21:23:22', '2023-11-09 10:20:46', NULL, NULL, 0, 1, 0, 0, 'false'),
(3, 'Projek P5', 'projek-p5', 'Kegiatan Projek P5 Kurikulum Merdeka', 'post', NULL, '2023-11-09 05:02:45', NULL, NULL, 1, 1, 0, 0, 'false'),
(4, 'Ekskul', 'ekskul', 'Kegiatan Ekstrakurikuler', 'post', NULL, '2023-11-09 10:38:16', NULL, NULL, 1, 1, 0, 0, 'false'),
(5, 'Ekstrakurikuler', 'ekstrakurikuler', 'Ekstrakurikuler', 'post', NULL, '2023-11-09 10:38:21', NULL, NULL, 1, 1, 0, 0, 'false'),
(6, 'Mata Pelajaran', 'mata-pelajaran', 'Mata Pelajaran', 'post', NULL, '2023-11-09 10:41:48', NULL, NULL, 1, 1, 0, 0, 'false'),
(7, 'Palang Merah Remaja', 'palang-merah-remaja', 'Palang Merah Remaja', 'post', NULL, '2023-11-09 22:08:04', NULL, NULL, 1, 1, 0, 0, 'false'),
(8, 'Paskibra', 'paskibra', 'Paskibra', 'post', NULL, '2023-11-09 22:09:43', NULL, NULL, 1, 0, 0, 0, 'false'),
(9, 'Pencak Silat', 'pencak-silat', 'Pencak Silat', 'post', NULL, '2023-11-09 22:11:13', NULL, NULL, 1, 0, 0, 0, 'false'),
(10, 'Paduan Suara', 'paduan-suara', 'Paduan Suara', 'post', NULL, '2023-11-09 22:11:45', NULL, NULL, 1, 0, 0, 0, 'false'),
(11, 'Seni Tari', 'seni-tari', 'Seni Tari', 'post', NULL, '2023-11-09 22:12:01', NULL, NULL, 1, 0, 0, 0, 'false'),
(12, 'Fisika', 'fisika', 'Fisika', 'post', NULL, '2023-11-09 22:13:33', NULL, NULL, 1, 0, 0, 0, 'false'),
(13, 'Kimia', 'kimia', 'Kimia', 'post', NULL, '2023-11-09 22:13:42', NULL, NULL, 1, 0, 0, 0, 'false'),
(14, 'Biologi', 'biologi', 'Biologi', 'post', NULL, '2023-11-09 22:13:53', NULL, NULL, 1, 0, 0, 0, 'false'),
(15, 'Adiwiyata', 'adiwiyata', 'Adiwiyata', 'post', NULL, '2023-11-09 22:16:16', NULL, NULL, 1, 0, 0, 0, 'false'),
(16, 'PIK&R', 'pikr', 'PIK&R', 'post', NULL, '2023-11-09 22:17:10', NULL, NULL, 1, 0, 0, 0, 'false'),
(17, 'Volly ball', 'volly-ball', 'Volly ball', 'post', NULL, '2023-11-09 22:18:36', NULL, NULL, 1, 0, 0, 0, 'false'),
(18, 'Futsal', 'futsal', 'Futsal', 'post', NULL, '2023-11-09 22:18:47', NULL, NULL, 1, 0, 0, 0, 'false'),
(19, 'Basket Ball', 'basket-ball', 'Basket Ball', 'post', NULL, '2023-11-09 22:19:05', NULL, NULL, 1, 0, 0, 0, 'false'),
(20, 'Bulu Tangkis', 'bulu-tangkis', 'Bulu Tangkis', 'post', NULL, '2023-11-09 22:20:20', NULL, NULL, 1, 0, 0, 0, 'false'),
(21, 'Kegiatan Sekolah', 'kegiatan-sekolah', NULL, 'post', NULL, '2023-11-10 21:37:20', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `class_groups`
--

CREATE TABLE `class_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_group` varchar(100) DEFAULT NULL,
  `sub_class_group` varchar(100) DEFAULT NULL,
  `major_id` bigint(20) DEFAULT 0 COMMENT 'Program Keahlian',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `class_group_settings`
--

CREATE TABLE `class_group_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `academic_year_id` bigint(20) DEFAULT 0 COMMENT 'FK dari academic_years',
  `class_group_id` bigint(20) DEFAULT 0 COMMENT 'Kelas, FK dari class_groups',
  `employee_id` bigint(20) DEFAULT 0 COMMENT 'Wali Kelas, FK dari employees',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `class_group_students`
--

CREATE TABLE `class_group_students` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_group_setting_id` bigint(20) DEFAULT 0,
  `student_id` bigint(20) DEFAULT 0,
  `is_class_manager` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Ketua Kelas ?',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `comment_post_id` bigint(20) DEFAULT 0,
  `comment_author` varchar(255) NOT NULL,
  `comment_email` varchar(255) DEFAULT NULL,
  `comment_url` varchar(255) DEFAULT NULL,
  `comment_ip_address` varchar(255) NOT NULL,
  `comment_content` text NOT NULL,
  `comment_subject` varchar(255) DEFAULT NULL,
  `comment_reply` text DEFAULT NULL,
  `comment_status` enum('approved','unapproved','spam') DEFAULT 'approved',
  `comment_agent` varchar(255) DEFAULT NULL,
  `comment_parent_id` varchar(255) DEFAULT NULL,
  `comment_type` enum('post','message') DEFAULT 'post',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `comment_post_id`, `comment_author`, `comment_email`, `comment_url`, `comment_ip_address`, `comment_content`, `comment_subject`, `comment_reply`, `comment_status`, `comment_agent`, `comment_parent_id`, `comment_type`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 21, 'ARIEF FIRMANSYAH SAPUTRA', 'arifffirmasyah061@gmail.com', 'Yaaa', '182.3.37.104', 'Saya Arief Firmansyah Saputra dri klas 12 a2', NULL, NULL, 'approved', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36', NULL, 'post', '2025-09-28 15:05:36', '2025-09-28 08:05:36', NULL, NULL, NULL, 0, 0, 0, 'false'),
(2, 21, 'rahaf qornelia suci', 'rahafqornoliasuci@gmail.com', '', '114.79.1.214', 'saya rahaf qornelia dari kelas 12B2', NULL, NULL, 'approved', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.6422.72 Mobile Safari/537.36 HeyTapBrowser/45.12.9.1', NULL, 'post', '2025-09-29 12:16:03', '2025-09-29 05:16:03', NULL, NULL, NULL, 0, 0, 0, 'false');

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `assignment_letter_number` varchar(255) DEFAULT NULL COMMENT 'Nomor Surat Tugas',
  `assignment_letter_date` date DEFAULT NULL COMMENT 'Tanggal Surat Tugas',
  `assignment_start_date` date DEFAULT NULL COMMENT 'TMT Tugas',
  `parent_school_status` enum('true','false') NOT NULL DEFAULT 'true' COMMENT 'Status Sekolah Induk',
  `full_name` varchar(150) NOT NULL,
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `nik` varchar(50) DEFAULT NULL,
  `birth_place` varchar(255) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `mother_name` varchar(150) DEFAULT NULL,
  `street_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Jalan',
  `rt` varchar(10) DEFAULT NULL COMMENT 'Rukun Tetangga',
  `rw` varchar(10) DEFAULT NULL COMMENT 'Rukun Warga',
  `sub_village` varchar(255) DEFAULT NULL COMMENT 'Nama Dusun',
  `village` varchar(255) DEFAULT NULL COMMENT 'Nama Kelurahan/Desa',
  `sub_district` varchar(255) DEFAULT NULL COMMENT 'Kecamatan',
  `district` varchar(255) DEFAULT NULL COMMENT 'Kota/Kabupaten',
  `postal_code` varchar(20) DEFAULT NULL COMMENT 'Kode POS',
  `religion_id` bigint(20) DEFAULT 0,
  `marriage_status_id` bigint(20) DEFAULT 0,
  `spouse_name` varchar(255) DEFAULT NULL COMMENT 'Nama Pasangan : Suami / Istri',
  `spouse_employment_id` bigint(20) DEFAULT 0 COMMENT 'Pekerjaan Pasangan : Suami / Istri',
  `citizenship` enum('WNI','WNA') NOT NULL DEFAULT 'WNI' COMMENT 'Kewarganegaraan',
  `country` varchar(255) DEFAULT NULL,
  `npwp` varchar(100) DEFAULT NULL,
  `employment_status_id` bigint(20) DEFAULT 0 COMMENT 'Status Kepegawaian',
  `nip` varchar(100) DEFAULT NULL,
  `niy` varchar(100) DEFAULT NULL COMMENT 'NIY/NIGK',
  `nuptk` varchar(100) DEFAULT NULL,
  `employment_type_id` bigint(20) DEFAULT 0 COMMENT 'Jenis Guru dan Tenaga Kependidikan (GTK)',
  `decree_appointment` varchar(255) DEFAULT NULL COMMENT 'SK Pengangkatan',
  `appointment_start_date` date DEFAULT NULL COMMENT 'TMT Pengangkatan',
  `institution_lifter_id` bigint(20) DEFAULT 0 COMMENT 'Lembaga Pengangkat',
  `decree_cpns` varchar(100) DEFAULT NULL COMMENT 'SK CPNS',
  `pns_start_date` date DEFAULT NULL COMMENT 'TMT CPNS',
  `rank_id` bigint(20) DEFAULT 0 COMMENT 'Pangkat/Golongan',
  `salary_source_id` bigint(20) DEFAULT 0 COMMENT 'Sumber Gaji',
  `headmaster_license` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Punya Lisensi Kepala Sekolah?',
  `laboratory_skill_id` bigint(20) DEFAULT 0 COMMENT 'Keahlian Lab oratorium',
  `special_need_id` bigint(20) DEFAULT 0 COMMENT 'Mampu Menangani Kebutuhan Khusus',
  `braille_skills` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Keahlian Braile ?',
  `sign_language_skills` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Keahlian Bahasa Isyarat ?',
  `phone` varchar(255) DEFAULT NULL,
  `mobile_phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `photo` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `assignment_letter_number`, `assignment_letter_date`, `assignment_start_date`, `parent_school_status`, `full_name`, `gender`, `nik`, `birth_place`, `birth_date`, `mother_name`, `street_address`, `rt`, `rw`, `sub_village`, `village`, `sub_district`, `district`, `postal_code`, `religion_id`, `marriage_status_id`, `spouse_name`, `spouse_employment_id`, `citizenship`, `country`, `npwp`, `employment_status_id`, `nip`, `niy`, `nuptk`, `employment_type_id`, `decree_appointment`, `appointment_start_date`, `institution_lifter_id`, `decree_cpns`, `pns_start_date`, `rank_id`, `salary_source_id`, `headmaster_license`, `laboratory_skill_id`, `special_need_id`, `braille_skills`, `sign_language_skills`, `phone`, `mobile_phone`, `email`, `photo`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, '', '0000-00-00', '0000-00-00', 'true', 'Ali Sabana, ST., M.Pd', 'M', '197901082010011002', 'Cilegon', '1979-01-08', '', '', '', '', '', '', '', '', '', 89, 103, '', 10, 'WNI', 'Indonesia', NULL, 113, '197901082010011002', NULL, '', 125, '', '0000-00-00', 107, '', '0000-00-00', 144, 152, 'true', 159, 23, 'true', 'true', '', '08993934353', 'alisabana@gmail.com', 'c780e56ab791ab935272bce37e089d6b.JPG', '2023-11-09 17:47:58', '2023-11-09 11:15:53', NULL, NULL, 1, 1, 0, 0, 'false');

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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_title` varchar(255) DEFAULT NULL,
  `file_description` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_type` varchar(255) DEFAULT NULL,
  `file_category_id` bigint(20) DEFAULT 0,
  `file_path` varchar(255) DEFAULT NULL,
  `file_ext` varchar(255) DEFAULT NULL,
  `file_size` varchar(255) DEFAULT NULL,
  `file_visibility` enum('public','private') DEFAULT 'public',
  `file_counter` bigint(20) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`id`, `file_title`, `file_description`, `file_name`, `file_type`, `file_category_id`, `file_path`, `file_ext`, `file_size`, `file_visibility`, `file_counter`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Modul Projek P5 Gaya Hidup Berkelanjutan (GHB) 2023', NULL, '32cf4f8c2059b20acf7e0284d1a5a61b.php', 'text/x-php', 2, '/home/smanbojo/public_html/media_library/files/', '.php', '660.9', 'private', 35, '2023-11-09 17:25:02', '2024-05-31 03:11:59', '2023-11-09 17:36:06', '2023-11-10 05:42:53', 1, 1, 1, 1, 'false'),
(2, 'Kalender Pendidikan Prov.Banten 2023/2024', NULL, 'e00f6bc00ca3220477535f660a6932ee.php', 'text/x-php', 2, '/home/smanbojo/public_html/media_library/files/', '.php', '17.2', 'public', 154, '2023-11-11 09:59:16', '2025-11-28 00:28:17', NULL, NULL, 1, 1, 0, 0, 'false'),
(3, 'Tugas Tambahan 2023-2024', NULL, '77c066c8124c560158e272b4af4e58ce.php', 'text/x-php', 2, '/home/smanbojo/public_html/media_library/files/', '.php', '295.49', 'public', 186, '2023-11-13 05:40:35', '2025-11-28 01:11:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(4, 'y', NULL, NULL, NULL, 2, NULL, NULL, NULL, 'public', 0, '2024-02-17 03:54:35', '2024-02-16 20:55:36', '2024-02-17 03:55:36', NULL, 1, 0, 1, 0, 'true'),
(5, 'P', NULL, NULL, NULL, 2, NULL, NULL, NULL, 'private', 0, '2024-05-31 18:37:11', '2024-05-31 11:37:11', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `image_sliders`
--

CREATE TABLE `image_sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `caption` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `image_sliders`
--

INSERT INTO `image_sliders` (`id`, `caption`, `image`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua', '96367ca3e116a3a86a12100faff8cd76.jpg', '2023-01-15 21:23:22', '2023-10-06 06:58:22', '2023-10-06 13:58:22', NULL, 0, 0, 1, 0, 'true'),
(2, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua', '37053980eb24813622948ceaba8a3fc2.png', '2023-01-15 21:23:22', '2023-10-03 05:13:48', NULL, NULL, 0, 0, 0, 0, 'false');

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

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `link_title` varchar(255) NOT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `link_target` enum('_blank','_self','_parent','_top') DEFAULT '_blank',
  `link_image` varchar(100) DEFAULT NULL,
  `link_type` enum('link','banner') DEFAULT 'link',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `links`
--

INSERT INTO `links` (`id`, `link_title`, `link_url`, `link_target`, `link_image`, `link_type`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'CMS Sekolahku', 'https://sekolahku.web.id', '_blank', NULL, 'link', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(2, 'CMS Sekolahku', 'https://sekolahku.web.id', '_blank', '1.png', 'banner', '2023-01-15 21:23:22', '2024-03-19 09:13:11', '2024-03-19 16:13:11', NULL, 0, 0, 1, 0, 'true');

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

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `counter` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `datetime` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `majors`
--

CREATE TABLE `majors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `major_name` varchar(255) DEFAULT NULL COMMENT 'Program Keahlian / Jurusan',
  `major_short_name` varchar(255) DEFAULT NULL COMMENT 'Nama Singkat',
  `is_active` enum('true','false') DEFAULT 'true',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `menu_title` varchar(150) NOT NULL,
  `menu_url` varchar(150) NOT NULL,
  `menu_target` enum('_blank','_self','_parent','_top') DEFAULT '_self',
  `menu_type` varchar(100) NOT NULL DEFAULT 'pages',
  `menu_parent_id` bigint(20) DEFAULT 0,
  `menu_position` bigint(20) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `menu_title`, `menu_url`, `menu_target`, `menu_type`, `menu_parent_id`, `menu_position`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Hubungi Kami', 'hubungi-kami', '_self', 'modules', 0, 8, '2023-01-15 21:23:22', '2023-12-04 09:23:58', NULL, NULL, 0, 0, 0, 0, 'false'),
(2, 'Galeri Foto', 'galeri-foto', '_self', 'modules', 9, 1, '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(3, 'Galeri Video', 'galeri-video', '_self', 'modules', 9, 2, '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(4, 'Formulir PPDB', 'formulir-penerimaan-peserta-didik-baru', '_self', 'modules', 8, 1, '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(5, 'Hasil Seleksi', 'hasil-seleksi-penerimaan-peserta-didik-baru', '_self', 'modules', 8, 2, '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(6, 'Cetak Formulir', 'cetak-formulir-penerimaan-peserta-didik-baru', '_self', 'modules', 8, 3, '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(7, 'Download Formulir', 'download-formulir-penerimaan-peserta-didik-baru', '_self', 'modules', 8, 4, '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(8, 'PPDB 2022', '#', '', 'links', 0, 5, '2023-01-15 21:23:22', '2023-10-03 06:11:50', '2023-10-03 13:11:50', NULL, 0, 1, 1, 0, 'true'),
(9, 'Galeri', '#', '_self', 'links', 0, 7, '2023-01-15 21:23:22', '2023-12-04 09:23:58', NULL, NULL, 0, 0, 0, 0, 'false'),
(10, 'Kegiatan', '#', '', 'links', 0, 4, '2023-01-15 21:23:22', '2023-12-04 09:23:58', NULL, '2023-11-09 12:16:08', 0, 1, 0, 1, 'false'),
(12, 'Direktori', '#', '_self', 'links', 0, 5, '2023-01-15 21:23:22', '2023-12-04 09:23:58', NULL, NULL, 0, 0, 0, 0, 'false'),
(13, 'Direktori Alumni', 'direktori-alumni', '_self', 'modules', 12, 4, '2023-01-15 21:23:22', '2023-11-09 10:13:48', NULL, NULL, 0, 0, 0, 0, 'false'),
(14, 'Direktori Peserta Didik', 'direktori-peserta-didik', '_self', 'modules', 12, 2, '2023-01-15 21:23:22', '2023-11-09 10:13:48', NULL, NULL, 0, 0, 0, 0, 'false'),
(15, 'Direktori Guru dan Tenaga Kependidikan', 'direktori-guru-dan-tenaga-kependidikan', '_self', 'modules', 12, 1, '2023-01-15 21:23:22', '2023-11-09 10:13:48', NULL, NULL, 0, 0, 0, 0, 'false'),
(16, 'Pendaftaran Alumni', 'pendaftaran-alumni', '_self', 'modules', 12, 3, '2023-01-15 21:23:22', '2023-11-09 10:13:48', NULL, NULL, 0, 0, 0, 0, 'false'),
(17, 'Profil', 'read/2/profil', '_self', 'pages', 0, 1, '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(18, 'Visi dan Misi', 'read/3/visi-dan-misi', '_self', 'pages', 0, 2, '2023-01-15 21:23:22', '2023-12-04 09:23:58', NULL, NULL, 0, 0, 0, 0, 'false'),
(22, 'Ekstrakurikuler', 'kategori/ekstrakurikuler', '_self', 'post_categories', 0, 3, '2023-11-09 12:11:59', '2023-12-04 09:23:58', NULL, NULL, 1, 0, 0, 0, 'false'),
(23, 'OSIS', 'kategori/osis', '_self', 'post_categories', 10, 3, '2023-11-09 12:11:59', '2023-11-09 05:13:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(24, 'Projek P5', 'kategori/projek-p5', '_self', 'post_categories', 10, 2, '2023-11-09 12:11:59', '2023-11-09 05:13:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(26, 'Download', 'download/download', '_self', 'file_categories', 0, 6, '2023-11-09 17:21:11', '2023-12-04 09:23:58', NULL, NULL, 1, 0, 0, 0, 'false'),
(27, 'Ekskul', 'kategori/ekskul', '_self', 'post_categories', 10, 1, '2023-11-09 17:39:26', '2023-11-09 10:40:00', NULL, NULL, 1, 0, 0, 0, 'false'),
(32, 'Palang Merah Remaja', 'kategori/palang-merah-remaja', '_self', 'post_categories', 22, 2, '2023-11-10 05:08:16', '2023-11-09 22:10:02', NULL, NULL, 1, 0, 0, 0, 'false'),
(33, 'Paskibra', 'kategori/paskibra', '_self', 'post_categories', 22, 1, '2023-11-10 05:09:56', '2023-11-09 22:10:02', NULL, NULL, 1, 0, 0, 0, 'false'),
(34, 'Paduan Suara', 'kategori/paduan-suara', '_self', 'post_categories', 22, 4, '2023-11-10 05:12:16', '2023-11-09 22:17:38', NULL, NULL, 1, 0, 0, 0, 'false'),
(35, 'Seni Tari', 'kategori/seni-tari', '_self', 'post_categories', 22, 5, '2023-11-10 05:12:16', '2023-11-09 22:17:38', NULL, NULL, 1, 0, 0, 0, 'false'),
(36, 'Adiwiyata', 'kategori/adiwiyata', '_self', 'post_categories', 22, 6, '2023-11-10 05:16:29', '2023-11-09 22:17:38', NULL, NULL, 1, 0, 0, 0, 'false'),
(37, 'PIK&R', 'kategori/pikr', '_self', 'post_categories', 22, 3, '2023-11-10 05:17:21', '2023-11-09 22:17:38', NULL, NULL, 1, 0, 0, 0, 'false'),
(38, 'Basket Ball', 'kategori/basket-ball', '_self', 'post_categories', 22, 9, '2023-11-10 05:19:41', '2023-11-09 22:20:42', NULL, NULL, 1, 0, 0, 0, 'false'),
(39, 'Futsal', 'kategori/futsal', '_self', 'post_categories', 22, 7, '2023-11-10 05:19:41', '2023-11-09 22:20:04', NULL, NULL, 1, 0, 0, 0, 'false'),
(40, 'Volly ball', 'kategori/volly-ball', '_self', 'post_categories', 22, 10, '2023-11-10 05:19:41', '2023-11-09 22:20:42', NULL, NULL, 1, 0, 0, 0, 'false'),
(41, 'Bulu Tangkis', 'kategori/bulu-tangkis', '_self', 'post_categories', 22, 8, '2023-11-10 05:20:31', '2023-11-09 22:20:42', NULL, NULL, 1, 0, 0, 0, 'false'),
(42, 'Kegiatan Sekolah', 'kategori/kegiatan-sekolah', '_self', 'post_categories', 10, 4, '2023-11-11 04:58:01', '2023-11-10 21:58:20', NULL, NULL, 1, 0, 0, 0, 'false'),
(44, 'Erapor', 'https://www.sman1bojnegara.my.id', '_top', 'links', 0, 9, '2023-12-04 15:56:41', '2023-12-04 09:23:58', NULL, '2023-12-04 15:57:30', 1, 1, 0, 1, 'false'),
(45, 'SPMB 2025', 'spmb/index.php', '_parent', 'pages', 0, 10, '2025-06-30 23:16:01', '2025-06-30 17:27:48', NULL, '2025-07-01 00:27:48', 1, 1, 0, 1, 'false'),
(46, 'TKA-2025', 'read/21/tka-2025', '_self', 'pages', 0, 11, '2025-09-09 12:29:09', '2025-09-09 05:30:19', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module_name` varchar(255) NOT NULL,
  `module_description` varchar(255) DEFAULT NULL,
  `module_url` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `module_name`, `module_description`, `module_url`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Pengguna', 'Pengguna', 'users', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(2, 'PPDB / PMB', 'PPDB / PMB', 'admission', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(3, 'Tampilan', 'Tampilan', 'appearance', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(4, 'Blog', 'Blog', 'blog', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(5, 'GTK / Staff / Dosen', 'GTK / Staff / Dosen', 'employees', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(6, 'Media', 'Media', 'media', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(7, 'Plugins', 'Plugins', 'plugins', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(8, 'Data Referensi', 'Data Referensi', 'reference', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(9, 'Pengaturan', 'Pengaturan', 'settings', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(10, 'Akademik', 'Akademik', 'academic', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false');

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `option_group` varchar(100) NOT NULL,
  `option_name` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`id`, `option_group`, `option_name`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'student_status', 'Aktif', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(2, 'student_status', 'Lulus', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(3, 'student_status', 'Mutasi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(4, 'student_status', 'Dikeluarkan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(5, 'student_status', 'Mengundurkan Diri', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(6, 'student_status', 'Putus Sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(7, 'student_status', 'Meninggal', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(8, 'student_status', 'Hilang', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(9, 'student_status', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(10, 'employments', 'Tidak bekerja', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(11, 'employments', 'Nelayan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(12, 'employments', 'Petani', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(13, 'employments', 'Peternak', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(14, 'employments', 'PNS/TNI/POLRI', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(15, 'employments', 'Karyawan Swasta', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(16, 'employments', 'Pedagang Kecil', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(17, 'employments', 'Pedagang Besar', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(18, 'employments', 'Wiraswasta', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(19, 'employments', 'Wirausaha', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(20, 'employments', 'Buruh', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(21, 'employments', 'Pensiunan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(22, 'employments', 'Lain-lain', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(23, 'special_needs', 'Tidak', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(24, 'special_needs', 'Tuna Netra', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(25, 'special_needs', 'Tuna Rungu', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(26, 'special_needs', 'Tuna Grahita ringan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(27, 'special_needs', 'Tuna Grahita Sedang', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(28, 'special_needs', 'Tuna Daksa Ringan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(29, 'special_needs', 'Tuna Daksa Sedang', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(30, 'special_needs', 'Tuna Laras', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(31, 'special_needs', 'Tuna Wicara', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(32, 'special_needs', 'Tuna ganda', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(33, 'special_needs', 'Hiper aktif', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(34, 'special_needs', 'Cerdas Istimewa', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(35, 'special_needs', 'Bakat Istimewa', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(36, 'special_needs', 'Kesulitan Belajar', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(37, 'special_needs', 'Narkoba', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(38, 'special_needs', 'Indigo', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(39, 'special_needs', 'Down Sindrome', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(40, 'special_needs', 'Autis', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(41, 'special_needs', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(42, 'educations', 'Tidak sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(43, 'educations', 'Putus SD', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(44, 'educations', 'SD Sederajat', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(45, 'educations', 'SMP Sederajat', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(46, 'educations', 'SMA Sederajat', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(47, 'educations', 'D1', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(48, 'educations', 'D2', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(49, 'educations', 'D3', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(50, 'educations', 'D4/S1', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(51, 'educations', 'S2', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(52, 'educations', 'S3', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(53, 'scholarships', 'Anak berprestasi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(54, 'scholarships', 'Anak Miskin', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(55, 'scholarships', 'Pendidikan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(56, 'scholarships', 'Unggulan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(57, 'scholarships', 'Lain-lain', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(58, 'achievement_types', 'Sains', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(59, 'achievement_types', 'Seni', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(60, 'achievement_types', 'Olahraga', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(61, 'achievement_types', 'Lain-lain', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(62, 'achievement_levels', 'Sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(63, 'achievement_levels', 'Kecamatan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(64, 'achievement_levels', 'Kota/Kabupaten', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(65, 'achievement_levels', 'Propinsi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(66, 'achievement_levels', 'Nasional', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(67, 'achievement_levels', 'Internasional', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(68, 'monthly_incomes', 'Kurang dari 500,000', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(69, 'monthly_incomes', '500.000 - 999.9999', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(70, 'monthly_incomes', '1 Juta - 1.999.999', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(71, 'monthly_incomes', '2 Juta - 4.999.999', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(72, 'monthly_incomes', '5 Juta - 20 Juta', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(73, 'monthly_incomes', 'Lebih dari 20 Juta', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(74, 'residences', 'Bersama orang tua', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(75, 'residences', 'Wali', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(76, 'residences', 'Kos', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(77, 'residences', 'Asrama', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(78, 'residences', 'Panti Asuhan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(79, 'residences', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(80, 'transportations', 'Jalan kaki', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(81, 'transportations', 'Kendaraan pribadi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(82, 'transportations', 'Kendaraan Umum / angkot / Pete-pete', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(83, 'transportations', 'Jemputan Sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(84, 'transportations', 'Kereta Api', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(85, 'transportations', 'Ojek', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(86, 'transportations', 'Andong / Bendi / Sado / Dokar / Delman / Beca', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(87, 'transportations', 'Perahu penyebrangan / Rakit / Getek', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(88, 'transportations', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(89, 'religions', 'Islam', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(90, 'religions', 'Kristen / protestan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(91, 'religions', 'Katholik', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(92, 'religions', 'Hindu', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(93, 'religions', 'Budha', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(94, 'religions', 'Khong Hu Chu', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(95, 'religions', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(96, 'school_levels', '1 - Sekolah Dasar (SD) / Sederajat', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(97, 'school_levels', '2 - Sekolah Menengah Pertama (SMP) / Sederajat', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(98, 'school_levels', '3 - Sekolah Menengah Atas (SMA) / Aliyah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(99, 'school_levels', '4 - Sekolah Menengah Kejuruan (SMK)', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(100, 'school_levels', '5 - Universitas', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(101, 'school_levels', '6 - Sekolah Tinggi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(102, 'school_levels', '7 - Politeknik', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(103, 'marriage_status', 'Kawin', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(104, 'marriage_status', 'Belum Kawin', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(105, 'marriage_status', 'Berpisah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(106, 'institution_lifters', 'Pemerintah Pusat', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(107, 'institution_lifters', 'Pemerintah Provinsi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(108, 'institution_lifters', 'Pemerintah Kab/Kota', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(109, 'institution_lifters', 'Ketua yayasan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(110, 'institution_lifters', 'Kepala Sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(111, 'institution_lifters', 'Komite Sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(112, 'institution_lifters', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(113, 'employment_status', 'PNS ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(114, 'employment_status', 'PNS Diperbantukan ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(115, 'employment_status', 'PNS DEPAG ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(116, 'employment_status', 'GTY/PTY ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(117, 'employment_status', 'GTT/PTT Provinsi ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(118, 'employment_status', 'GTT/PTT Kota/Kabupaten', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(119, 'employment_status', 'Guru Bantu Pusat ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(120, 'employment_status', 'Guru Honor Sekolah ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(121, 'employment_status', 'Tenaga Honor Sekolah ', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(122, 'employment_status', 'CPNS', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(123, 'employment_status', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(124, 'employment_types', 'Guru Kelas', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(125, 'employment_types', 'Guru Mata Pelajaran', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(126, 'employment_types', 'Guru BK', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(127, 'employment_types', 'Guru Inklusi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(128, 'employment_types', 'Tenaga Administrasi Sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(129, 'employment_types', 'Guru Pendamping', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(130, 'employment_types', 'Guru Magang', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(131, 'employment_types', 'Guru TIK', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(132, 'employment_types', 'Laboran', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(133, 'employment_types', 'Pustakawan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(134, 'employment_types', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(135, 'ranks', 'I/A', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(136, 'ranks', 'I/B', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(137, 'ranks', 'I/C', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(138, 'ranks', 'I/D', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(139, 'ranks', 'II/A', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(140, 'ranks', 'II/B', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(141, 'ranks', 'II/C', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(142, 'ranks', 'II/D', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(143, 'ranks', 'III/A', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(144, 'ranks', 'III/B', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(145, 'ranks', 'III/C', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(146, 'ranks', 'III/D', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(147, 'ranks', 'IV/A', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(148, 'ranks', 'IV/B', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(149, 'ranks', 'IV/C', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(150, 'ranks', 'IV/D', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(151, 'ranks', 'IV/E', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(152, 'salary_sources', 'APBN', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(153, 'salary_sources', 'APBD Provinsi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(154, 'salary_sources', 'APBD Kab/Kota', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(155, 'salary_sources', 'Yayasan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(156, 'salary_sources', 'Sekolah', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(157, 'salary_sources', 'Lembaga Donor', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(158, 'salary_sources', 'Lainnya', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(159, 'laboratory_skills', 'Lab IPA', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(160, 'laboratory_skills', 'Lab Fisika', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(161, 'laboratory_skills', 'Lab Biologi', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(162, 'laboratory_skills', 'Lab Kimia', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(163, 'laboratory_skills', 'Lab Bahasa', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(164, 'laboratory_skills', 'Lab Komputer', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(165, 'laboratory_skills', 'Teknik Bangunan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(166, 'laboratory_skills', 'Teknik Survei & Pemetaan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(167, 'laboratory_skills', 'Teknik Ketenagakerjaan', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(168, 'laboratory_skills', 'Teknik Pendinginan & Tata Udara', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(169, 'laboratory_skills', 'Teknik Mesin', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(170, 'admission_types', 'Zonasi', '2023-10-03 13:06:03', '2023-10-03 06:06:03', NULL, NULL, 1, 0, 0, 0, 'false'),
(171, 'admission_types', 'Afirmasi', '2023-10-03 13:06:08', '2023-10-03 06:06:08', NULL, NULL, 1, 0, 0, 0, 'false'),
(172, 'admission_types', 'Perpindahan Orang tua', '2023-10-03 13:06:21', '2023-10-03 06:06:21', NULL, NULL, 1, 0, 0, 0, 'false'),
(173, 'admission_types', 'Prestasi Akademik', '2023-10-03 13:06:34', '2023-10-03 06:06:34', NULL, NULL, 1, 0, 0, 0, 'false'),
(174, 'admission_types', 'Prestasi Non Akademik', '2023-10-03 13:06:44', '2023-10-03 06:06:44', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `photos`
--

CREATE TABLE `photos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo_album_id` bigint(20) DEFAULT 0,
  `photo_name` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` (`id`, `photo_album_id`, `photo_name`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 1, 'efb46b846c4eddda2a51dc58cbd118f2.jpg', '2023-11-10 05:38:25', '2023-11-09 22:38:25', NULL, NULL, 1, 0, 0, 0, 'false'),
(2, 1, '002861a5487226ab2c9538ca825500d7.jpg', '2023-11-10 05:38:26', '2023-11-09 22:38:26', NULL, NULL, 1, 0, 0, 0, 'false'),
(3, 1, '43733a1ad5c49ca8db5e6922d6121f76.jpg', '2023-11-10 05:38:27', '2023-11-09 22:38:27', NULL, NULL, 1, 0, 0, 0, 'false'),
(4, 1, '0ec6b0a7a2c9540616cf4cf864e6272d.jpg', '2023-11-10 05:38:28', '2023-11-09 22:38:28', NULL, NULL, 1, 0, 0, 0, 'false'),
(5, 1, 'e82ded3196c919eafee32d443512d31a.jpg', '2023-11-10 05:38:28', '2023-11-09 22:38:28', NULL, NULL, 1, 0, 0, 0, 'false'),
(6, 1, '3c67de52eabc58e5fe84b0d313b20f5a.jpg', '2023-11-10 05:38:29', '2023-11-09 22:38:29', NULL, NULL, 1, 0, 0, 0, 'false'),
(7, 1, '4bd1ee37b08e7e84e62ec429afc02569.jpg', '2023-11-10 05:38:30', '2023-11-09 22:38:30', NULL, NULL, 1, 0, 0, 0, 'false'),
(8, 1, '31aed8cabc4294a020cd155cc472c8e1.jpg', '2023-11-10 05:38:31', '2023-11-09 22:38:31', NULL, NULL, 1, 0, 0, 0, 'false'),
(9, 1, '0289fa1ea3bfb2d14292dcc0d3f1657e.jpg', '2023-11-10 05:38:32', '2023-11-09 22:38:32', NULL, NULL, 1, 0, 0, 0, 'false'),
(10, 1, 'ffad6a7630180f10e96c3e6adfc564e7.jpg', '2023-11-10 05:38:32', '2023-11-09 22:38:32', NULL, NULL, 1, 0, 0, 0, 'false'),
(11, 1, '27be38e8d2798d7b58c3acfe2c7dc229.jpg', '2023-11-10 05:38:33', '2023-11-09 22:38:33', NULL, NULL, 1, 0, 0, 0, 'false'),
(12, 1, '37ef6f8e274301b602d0328d63f38166.jpg', '2023-11-10 05:38:34', '2023-11-09 22:38:34', NULL, NULL, 1, 0, 0, 0, 'false'),
(13, 1, '7b6dabfde4f1b891c30b2b41455731fe.jpg', '2023-11-10 05:38:35', '2023-11-09 22:38:35', NULL, NULL, 1, 0, 0, 0, 'false'),
(14, 1, '2b99b19391396fee747183b4d0adf816.jpg', '2023-11-10 05:38:36', '2023-11-09 22:38:36', NULL, NULL, 1, 0, 0, 0, 'false'),
(15, 1, '5d9c1249ec954143c1b171598d6da9be.jpg', '2023-11-10 05:38:37', '2023-11-09 22:38:37', NULL, NULL, 1, 0, 0, 0, 'false'),
(16, 1, '1a49f3b63f0a4271d5a9415f35922009.jpg', '2023-11-10 05:38:37', '2023-11-09 22:38:37', NULL, NULL, 1, 0, 0, 0, 'false'),
(17, 1, 'a5d1d7c24f6017f550a9b589cbe62bf1.jpg', '2023-11-10 05:38:38', '2023-11-09 22:38:38', NULL, NULL, 1, 0, 0, 0, 'false'),
(18, 1, 'a2dfdbf387dde3536a8ab855623d8fc7.jpg', '2023-11-11 04:15:30', '2023-11-10 21:15:30', NULL, NULL, 1, 0, 0, 0, 'false'),
(19, 1, '95a2a671366d7bd028d5af59ff0b4595.jpg', '2023-11-11 04:15:31', '2023-11-10 21:15:31', NULL, NULL, 1, 0, 0, 0, 'false'),
(20, 1, 'a2870c348be291a8577c7466dd95e5ec.jpg', '2023-11-11 04:15:32', '2023-11-10 21:15:32', NULL, NULL, 1, 0, 0, 0, 'false'),
(21, 1, '58a1fed248d059f9ad4b827bd3720265.jpg', '2023-11-11 04:15:33', '2023-11-10 21:15:33', NULL, NULL, 1, 0, 0, 0, 'false'),
(22, 1, '2d7864fc5235ce3297727356a8359cb4.jpg', '2023-11-11 04:15:34', '2023-11-10 21:15:34', NULL, NULL, 1, 0, 0, 0, 'false'),
(23, 1, 'eea61e7a572e089eeb0da2e92ef1296c.jpg', '2023-11-11 04:15:35', '2023-11-10 21:15:35', NULL, NULL, 1, 0, 0, 0, 'false'),
(24, 1, 'ca009519643200a6384fe29735116f19.jpg', '2023-11-11 04:15:36', '2023-11-10 21:15:36', NULL, NULL, 1, 0, 0, 0, 'false'),
(25, 1, 'ac27ed2f361c3536ff88712353746d48.jpg', '2023-11-11 04:15:36', '2023-11-10 21:15:36', NULL, NULL, 1, 0, 0, 0, 'false'),
(26, 1, 'e2a98327d9a643a3a4dd6331bce736df.jpg', '2023-11-11 04:15:37', '2023-11-10 21:15:37', NULL, NULL, 1, 0, 0, 0, 'false'),
(27, 2, '75a938fcb1c6cb646c52a225cd012109.jpg', '2023-11-11 04:21:17', '2023-11-10 21:21:17', NULL, NULL, 1, 0, 0, 0, 'false'),
(28, 2, '6d32d87e63972d58da16a34f1e07c40b.jpg', '2023-11-11 04:21:18', '2023-11-10 21:21:18', NULL, NULL, 1, 0, 0, 0, 'false'),
(29, 2, '1419a7296a0f571712b7f28961bf7da7.jpg', '2023-11-11 04:21:19', '2023-11-10 21:21:19', NULL, NULL, 1, 0, 0, 0, 'false'),
(30, 2, '87c92a7234541dfbcf668bf0784db2d3.jpg', '2023-11-11 04:21:20', '2023-11-10 21:21:20', NULL, NULL, 1, 0, 0, 0, 'false'),
(31, 2, '5086b34e94dbe6637b8d99318cd9ad67.jpg', '2023-11-11 04:21:22', '2023-11-10 21:21:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(32, 2, 'd5a7831ca2419fb8fea2a39c9e428f82.jpg', '2023-11-11 04:21:23', '2023-11-10 21:21:23', NULL, NULL, 1, 0, 0, 0, 'false'),
(33, 2, 'b250edea4a525ea3b00fb821d0ab6839.jpg', '2023-11-11 04:21:24', '2023-11-10 21:21:24', NULL, NULL, 1, 0, 0, 0, 'false'),
(34, 2, '5c407e1c90f41101b49f9a5be729ccee.jpg', '2023-11-11 04:21:25', '2023-11-10 21:21:25', NULL, NULL, 1, 0, 0, 0, 'false'),
(35, 2, '765d2d7c056c7fcb12530a833850aee1.jpg', '2023-11-11 04:21:26', '2023-11-10 21:21:26', NULL, NULL, 1, 0, 0, 0, 'false'),
(36, 3, 'e0b7dfd9ee504a40fcb6604c3e7527d9.jpg', '2023-11-14 05:17:19', '2023-11-13 22:17:19', NULL, NULL, 1, 0, 0, 0, 'false'),
(37, 3, 'ca8eee3ee319ce851adf6d7d4d48a1f6.jpg', '2023-11-14 05:17:20', '2023-11-13 22:17:20', NULL, NULL, 1, 0, 0, 0, 'false'),
(38, 3, '193e2746fc6f638821c348270d08dcaa.jpg', '2023-11-14 05:17:20', '2023-11-13 22:17:20', NULL, NULL, 1, 0, 0, 0, 'false'),
(39, 3, 'db48c015a22d8762c38e8cf8635a2018.jpg', '2023-11-14 05:17:21', '2023-11-13 22:17:21', NULL, NULL, 1, 0, 0, 0, 'false'),
(40, 1, '6f23503417a77c46ea685b64a9a2990e.jpg', '2023-11-14 10:16:10', '2023-11-14 03:16:10', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `pollings`
--

CREATE TABLE `pollings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `answer_id` bigint(20) DEFAULT 0,
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `post_title` varchar(255) DEFAULT NULL,
  `post_content` longtext DEFAULT NULL,
  `post_image` varchar(100) DEFAULT NULL,
  `post_author` bigint(20) DEFAULT 0,
  `post_categories` varchar(255) DEFAULT NULL,
  `post_type` varchar(50) NOT NULL DEFAULT 'post',
  `post_status` enum('publish','draft') DEFAULT 'draft',
  `post_visibility` enum('public','private') DEFAULT 'public',
  `post_comment_status` enum('open','close') DEFAULT 'close',
  `post_slug` varchar(255) DEFAULT NULL,
  `post_tags` varchar(255) DEFAULT NULL,
  `post_counter` bigint(20) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `post_title`, `post_content`, `post_image`, `post_author`, `post_categories`, `post_type`, `post_status`, `post_visibility`, `post_comment_status`, `post_slug`, `post_tags`, `post_counter`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, '', '<p>Masih Dalam Progres</p>', 'headmaster_photo.png', 0, '', 'opening_speech', 'publish', 'public', 'open', '', '', 0, '2023-01-15 21:23:22', '2023-10-03 05:24:21', NULL, NULL, 0, 1, 0, 0, 'false'),
(2, 'Profil', '<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"107\" height=\"21\"><strong>Nama Sekolah</strong></td>\n<td width=\"19\"><strong>:</strong></td>\n<td width=\"354\"><strong>SMAN 1 Bojonegara</strong></td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">NPSN</td>\n<td width=\"19\">:</td>\n<td width=\"354\">20605354</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Nomor Statistik Sekolah</td>\n<td width=\"19\">:</td>\n<td width=\"354\">301280407032</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Propinsi</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Banten</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Otonomi Daerah</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Kabupaten Serang</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Kecamatan</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Bojonegara</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Desa/Kelurahan</td>\n<td width=\"19\">:</td>\n<td>Bojonegara<cite></cite><br /><cite></cite></td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Alamat Sekolah</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Jl. KH. Bakrie No.02 Bojonegara</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Kode Pos</td>\n<td width=\"19\">:</td>\n<td width=\"354\">42454</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Telpon</td>\n<td width=\"19\">:</td>\n<td width=\"354\">(0245) 5751337</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Email</td>\n<td width=\"19\">:</td>\n<td width=\"354\">smanjobojonegara@gmail.com</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Daerah</td>\n<td width=\"19\">:</td>\n<td>Pedesaan<cite></cite></td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Status Sekolah</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Negeri</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Akreditasi</td>\n<td width=\"19\">:</td>\n<td width=\"354\">A</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Surat Keputusan/SK(Ditandatangani Oleh)</td>\n<td width=\"19\">:</td>\n<td width=\"354\">-</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Penerbit SK</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Bojonegara</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Tahun Berdiri</td>\n<td width=\"19\">:</td>\n<td>Tahun 2001<cite></cite><br /><cite></cite></td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Tahun Perubahan</td>\n<td width=\"19\">:</td>\n<td width=\"354\">5 Mei 2001</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Kegiatan KBM</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Pagi</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Bangunan Sekolah</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Milik Sendiri</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Lokasi Sekolah</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Bojonegara</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Jarak Ke Pusat Kec.</td>\n<td width=\"19\">:</td>\n<td width=\"354\">0,5 Km</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Jarak Ke Pusat Otda</td>\n<td width=\"19\">:</td>\n<td width=\"354\">25 Km</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Terletak Pada Lintasan</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Kecamatan</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Jumlah Keanggotaan Rayon</td>\n<td width=\"19\">:</td>\n<td width=\"354\">-&nbsp; Sekolah</td>\n</tr>\n<tr>\n<td width=\"107\" height=\"21\">Organisasi Penyelenggara</td>\n<td width=\"19\">:</td>\n<td width=\"354\">Pemerintah</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>', NULL, 1, '+1+', 'page', 'publish', 'public', 'open', 'profil', 'berita, pengumuman, sekilas-info', 1691, '2023-01-15 21:23:22', '2025-11-30 20:50:08', NULL, NULL, 0, 1, 0, 0, 'false'),
(3, 'Visi dan Misi', '<p>&nbsp;<strong><img style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699577563579.jpg\" alt=\"\" width=\"2537\" height=\"956\" /></strong></p>\n<p>\"MEWUJUDKAN SEKOLAH YANG BERINTEGRITAS UNTUK MEMBENTUK PESERTA DIDIK YANG BERKARAKTER PANCASILA SERTA TANGGAP TERHADAP PERKEMBANGAN IPTEK BERLANDASKAN IMAN DAN TAQWA\"</p>', NULL, 1, '+1+', 'page', 'publish', 'public', 'open', 'visi-dan-misi', 'berita, pengumuman, sekilas-info', 942, '2023-01-15 21:23:22', '2025-11-29 06:58:28', NULL, NULL, 0, 1, 0, 0, 'false'),
(4, 'Kegiatan Outing Class Projek P5 Gaya Hidup Berkelanjutan (GHB)', '<p style=\"text-align: justify;\">Pada kegiatan pembelajaran P5 Gaya Hidup Berkelanjutan peserta didik kelas X.1 - X.9 SMAN 1 Bojonegara melaksanakan kegiatan Outing Class pada tanggal 19- 21 September 2023.&nbsp;Tujuan diadakannya kegiatan ini adalah untuk mengenal lebih dekat tentang pengolahan sampah yang dijalankan di kampung bersih, kampung Dukuh Desa Margagiri Kecamatan Bojonegara.&nbsp;</p>\r\n<p style=\"text-align: justify;\"><span style=\"text-align: justify;\">Pada pelaksanaan kegiatan ini, peserta didik dibagi dalam beberapa kelompok dan melakukan perjalanan dari sekolah sampai ketempat tujuan. Peserta didik mendapat kesempatan melihat secara langsung pengolahan sampah yang dilakukan oleh kelompok peduli lingkungan yang dilakukan oleh pemuda setempat di kampung dukuh desa margagiri.</span></p>\r\n<p style=\"text-align: justify;\">Diharapkan setelah mengikuti kegiatan ini, peserta didik memiliki pengetahuan bagaimana mengolah sampah menjadi produk yang bernilai ekonomis dan berperan mengurangi dampak negatif sampah.</p>\r\n<p style=\"text-align: justify;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">Foto-foto Kegiatan</p>\r\n<p style=\"text-align: center;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699505185472.jpg\" alt=\"\" width=\"931\" height=\"419\" /></p>\r\n<p style=\"text-align: justify;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699505213247.jpg\" alt=\"\" width=\"799\" height=\"378\" /></p>\r\n<p style=\"text-align: justify;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699505589123.jpg\" alt=\"\" width=\"789\" height=\"355\" /></p>\r\n<p style=\"text-align: justify;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699505413242.jpg\" alt=\"\" width=\"915\" height=\"402\" /></p>\r\n<p style=\"text-align: justify;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699505620696.jpg\" alt=\"\" width=\"957\" height=\"524\" /></p>\r\n<h4 style=\"text-align: center;\">&nbsp;</h4>\r\n<h4 style=\"text-align: center;\">&nbsp;</h4>\r\n<h4 style=\"text-align: center;\">&nbsp;</h4>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>', '232e24e672fee9e9a44470a0fcc5dacd.jpg', 1, '+3+', 'post', 'publish', 'public', 'open', 'kegiatan-outing-class-projek-p5-gaya-hidup-berkelanjutan-ghb', 'berita, pengumuman, sekilas-info', 1047, '2023-10-03 13:13:12', '2025-11-30 01:19:05', NULL, NULL, 0, 1, 0, 0, 'false'),
(5, 'Sample Post 2', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'post_image.png', 1, '+1+', 'post', 'draft', 'public', 'open', 'sample-post-2', 'berita, pengumuman, sekilas-info', 7, '2023-01-15 21:23:22', '2023-11-09 05:34:18', '2023-11-09 12:01:00', '2023-11-09 12:33:47', 0, 1, 1, 1, 'false'),
(6, 'Sample Post 3', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'post_image.png', 1, '+1+', 'post', 'draft', 'public', 'open', 'sample-post-3', 'berita, pengumuman, sekilas-info', 7, '2023-01-15 21:23:22', '2023-11-09 05:34:27', '2023-11-09 12:01:00', '2023-11-09 12:33:57', 0, 1, 1, 1, 'false'),
(7, 'Sample Post 4', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'post_image.png', 1, '+1+', 'post', 'draft', 'public', 'open', 'sample-post-4', 'berita, pengumuman, sekilas-info', 7, '2023-01-15 21:23:22', '2023-11-09 05:34:37', '2023-11-09 12:01:00', '2023-11-09 12:33:57', 0, 1, 1, 1, 'false'),
(8, 'Sample Post 5', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'post_image.png', 1, '+1+', 'post', 'draft', 'public', 'open', 'sample-post-5', 'berita, pengumuman, sekilas-info', 7, '2023-01-15 21:23:22', '2023-11-09 05:34:46', '2023-11-09 12:01:00', '2023-11-09 12:33:57', 0, 1, 1, 1, 'false'),
(9, 'MPLS SMAN 1 Bojonegara 2923', 'SZ8Nv3GicoM', NULL, 0, NULL, 'video', 'draft', 'public', 'close', NULL, NULL, 0, '2023-10-03 12:26:14', '2023-11-17 17:37:17', '2023-11-11 06:27:01', '2023-11-18 00:37:17', 1, 1, 1, 1, 'false'),
(10, 'Kampanye dan Pameran Poster Projek P5 Gaya Hidup Berkelanjutan (GHB)', '<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\">Media yang dapat mendukung usaha untuk meningkatkan rasa kepedu<span class=\"ls50\">lian siswa-siswi&nbsp;</span>ialah melalui <span class=\"fc0 ls47 ws21\">poster</span><span class=\"ls47\">. <span class=\"fc0 ls51\">Pada dasarnya sebuah poster dibuat dengan tujuan menarik </span></span>perhatian banyak orang agar berpartisipasi memenuhi imbauan yan<span class=\"ls3\">g disampaikan dalam </span>poster tersebut. Dalam hal ini, siswa agar lebih tertarik<span class=\"ls52\"> dalam menjaga kebersihan </span>lingkungan sekolah.</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\">\r\n<div class=\"t m0 xa h3 y7c ff1 fs1 fc0 sc0 ls4a ws2\">Poster sebagai media informasi agar siswa peduli terhadap keber<span class=\"ls4f\">sihan lingkungan </span>sekolah. Sehingga siswa akan selalu mengingat untuk membuang sa<span class=\"ls68\">mpah pada </span>tempatnya. Poster juga menginformasikan agar audiens me<span class=\"ls44\">ngikuti ajakan atau </span>larangan. Sebagai contoh &ldquo;<span class=\"ff3 ls4f ws23\">Buanglah Sampah Pada Tempatnya</span><span class=\"ls57\">&rdquo;.</span></div>\r\n<div class=\"t m0 xa h3 y7c ff1 fs1 fc0 sc0 ls4a ws2\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y7c ff1 fs1 fc0 sc0 ls4a ws2\"><span class=\"ls57\">Kegiatan kampanye melalui media poster ini merupakan salah satu kegiatan Projek P5 dengan tema Gaya Hidup Berkelanjutan (GHB) yang diikuti oleh Kelas X.1 - X.9 SMAN 1 Bojonegara. Adapun t</span>ujuan dari kegiatan ini adalah memberikan penyuluhan kepad<span class=\"ls6a\">a siswa-siswi&nbsp;</span>untuk menumbuhkan jiwa <span class=\"ls6b\">kepedulian </span>terhadap lingkungan sekolah serta memiliki ketertarikan dalam menciptakan kebersihan lingku<span class=\"ls43\">ngan sekolah&nbsp;</span>melalui poster.</div>\r\n<div class=\"t m0 xa h3 y7c ff1 fs1 fc0 sc0 ls4a ws2\">&nbsp;</div>\r\n</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\">\r\n<div class=\"t m0 xa hf y62 ff1 fs1 fc0 sc0 ls4a ws2\">\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\"><span class=\"ls43\">Foto-Foto Kegiatan</span></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\"><span class=\"ls43\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699654241321.jpg\" alt=\"\" width=\"911\" height=\"410\" /></span></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699654538742.jpg\" alt=\"\" width=\"1000\" height=\"450\" /></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\"><span class=\"ls43\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699508690754.jpg\" width=\"1000\" height=\"749\" /></span></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\"><span class=\"ls43\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699508811060.jpg\" width=\"1000\" height=\"750\" /></span></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\"><span class=\"ls43\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699508763994.jpg\" width=\"1000\" height=\"750\" /></span></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699654362566.jpg\" alt=\"\" width=\"1000\" height=\"750\" /></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;<img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699654444135.jpg\" alt=\"\" width=\"1000\" height=\"750\" /></div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>', 'bf6889d67d0d59d65393f89f92dd428e.jpg', 1, '+3+', 'post', 'publish', 'public', 'open', 'kampanye-dan-pameran-poster-projek-p5-gaya-hidup-berkelanjutan-ghb', '', 1666, '2023-11-09 12:21:52', '2025-11-30 05:37:07', NULL, NULL, 1, 1, 0, 0, 'false'),
(11, 'Sarapan Sehat dan Pemberian Tablet Penambah Darah', '<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">Sarapan sehat merupakan kegiatan rutin yang dilakukan oleh SMAN 1 Bojonegara yang diadakan setiap bulan pada minggu pertama hari jumat.&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">Kegiatan sarapan sehat bertujuan meningkatkan kesadaran masyarakat khususnya siswa-siswi SMAN 1 Bojonegara mengenai pentingnya sarapan, manfaat sarapan, jenis sarapan sehat, dan jajanan aman.</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">Pada kesempatan ini dari pihak puskesmas bojonegara bekerja sama dengan SMAN 1 Bojonegara dengan memberikan penyuluhan tentang kesehatan khususnya pada kaum hawa betapa pentingnya makan-makanan bergizi dan asupan penambah darah. Kemudian diakhiri dengan pemberian tablet penambah darah pada siswa SMAN 1 Bojonegara.</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">Foto-foto Kegiatan</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699652996469.jpg\" alt=\"\" width=\"1181\" height=\"519\" /></div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699653019735.jpg\" alt=\"\" width=\"1181\" height=\"519\" /></div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\"><img style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699653049287.jpg\" alt=\"\" width=\"738\" height=\"984\" /></div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699653098494.jpg\" alt=\"\" width=\"679\" height=\"906\" /></div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: center;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>', '928f58d3a9482dc0873048443edb6c9e.jpg', 1, '+21+', 'post', 'publish', 'public', 'open', 'sarapan-sehat-dan-pemberian-tablet-penambah-darah', '', 487, '2023-11-09 12:22:58', '2025-11-30 18:13:25', NULL, NULL, 1, 1, 0, 0, 'false'),
(12, 'Kampanye Projek P5 Gaya Hidup Berkelanjutan (GHB)', '<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">Media yang dapat mendukung usaha untuk meningkatkan rasa kepedu<span class=\"ls50\">lian siswa-siswi&nbsp;</span>ialah melalui <span class=\"fc0 ls47 ws21\">poster</span><span class=\"ls47\">. <span class=\"fc0 ls51\">Pada dasarnya sebuah poster dibuat dengan tujuan menarik </span></span>perhatian banyak orang agar berpartisipasi memenuhi imbauan yan<span class=\"ls3\">g disampaikan dalam </span>poster tersebut. Dalam hal ini, siswa agar lebih tertarik<span class=\"ls52\"> dalam menjaga kebersihan </span>lingkungan sekolah.</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">\r\n<div class=\"t m0 xa h3 y7c ff1 fs1 fc0 sc0 ls4a ws2\">Poster sebagai media informasi agar siswa peduli terhadap keber<span class=\"ls4f\">sihan lingkungan </span>sekolah. Sehingga siswa akan selalu mengingat untuk membuang sa<span class=\"ls68\">mpah pada </span>tempatnya. Poster juga menginformasikan agar audiens me<span class=\"ls44\">ngikuti ajakan atau </span>larangan. Sebagai contoh &ldquo;<span class=\"ff3 ls4f ws23\">Buanglah Sampah Pada Tempatnya</span><span class=\"ls57\">&rdquo;.</span></div>\r\n</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">\r\n<div class=\"t m0 xa hf y62 ff1 fs1 fc0 sc0 ls4a ws2\">&nbsp;</div>\r\n<div class=\"t m0 xa hf y62 ff1 fs1 fc0 sc0 ls4a ws2\">\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\">Tujuan dari kegiatan abdimas adalah memberikan penyuluhan kepad<span class=\"ls6a\">a siswa-siswi&nbsp;</span>untuk menumbuhkan jiwa <span class=\"ls6b\">kepedulian </span>terhadap lingkungan sekolah melalui poster. Hasil karya yang dihasilkan berupa sebuah poster. Dengan penyuluhan melalui poster sebagai media kampan<span class=\"ls5b\">ye ini diharapkan </span>siswa memiliki ketertarikan dalam menciptakan kebersihan lingku<span class=\"ls43\">ngan sekolah.</span></div>\r\n</div>\r\n</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>', NULL, 1, '+3+', 'post', 'draft', 'public', 'open', 'kampanye-projek-p5-gaya-hidup-berkelanjutan-ghb', '', 0, '2023-11-09 12:28:31', '2023-11-09 05:31:41', NULL, NULL, 1, 1, 0, 0, 'false'),
(13, 'Kampanye Projek P5 Gaya Hidup Berkelanjutan (GHB)', '<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">Media yang dapat mendukung usaha untuk meningkatkan rasa kepedu<span class=\"ls50\">lian siswa-siswi&nbsp;</span>ialah melalui <span class=\"fc0 ls47 ws21\">poster</span><span class=\"ls47\">. <span class=\"fc0 ls51\">Pada dasarnya sebuah poster dibuat dengan tujuan menarik </span></span>perhatian banyak orang agar berpartisipasi memenuhi imbauan yan<span class=\"ls3\">g disampaikan dalam </span>poster tersebut. Dalam hal ini, siswa agar lebih tertarik<span class=\"ls52\"> dalam menjaga kebersihan </span>lingkungan sekolah.</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">\r\n<div class=\"t m0 xa h3 y7c ff1 fs1 fc0 sc0 ls4a ws2\">Poster sebagai media informasi agar siswa peduli terhadap keber<span class=\"ls4f\">sihan lingkungan </span>sekolah. Sehingga siswa akan selalu mengingat untuk membuang sa<span class=\"ls68\">mpah pada </span>tempatnya. Poster juga menginformasikan agar audiens me<span class=\"ls44\">ngikuti ajakan atau </span>larangan. Sebagai contoh &ldquo;<span class=\"ff3 ls4f ws23\">Buanglah Sampah Pada Tempatnya</span><span class=\"ls57\">&rdquo;.</span></div>\r\n</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">\r\n<div class=\"t m0 xa hf y62 ff1 fs1 fc0 sc0 ls4a ws2\">&nbsp;</div>\r\n<div class=\"t m0 xa hf y62 ff1 fs1 fc0 sc0 ls4a ws2\">\r\n<div class=\"t m0 xa h3 y81 ff1 fs1 fc0 sc0 ls69 ws2\">Tujuan dari kegiatan abdimas adalah memberikan penyuluhan kepad<span class=\"ls6a\">a siswa-siswi&nbsp;</span>untuk menumbuhkan jiwa <span class=\"ls6b\">kepedulian </span>terhadap lingkungan sekolah melalui poster. Hasil karya yang dihasilkan berupa sebuah poster. Dengan penyuluhan melalui poster sebagai media kampan<span class=\"ls5b\">ye ini diharapkan </span>siswa memiliki ketertarikan dalam menciptakan kebersihan lingku<span class=\"ls43\">ngan sekolah.</span></div>\r\n</div>\r\n</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>\r\n<div class=\"t m0 xa h3 y4e ff1 fs1 fc1 sc0 ls46 ws2\" style=\"text-align: justify;\">&nbsp;</div>', NULL, 1, '+3+', 'post', 'draft', 'public', 'open', 'kampanye-projek-p5-gaya-hidup-berkelanjutan-ghb', '', 0, '2023-11-09 12:29:33', '2023-11-09 05:31:52', NULL, NULL, 1, 1, 0, 0, 'false'),
(14, 'Outing Class Projek P5 GHB', '98zncQZu1jk', NULL, 0, NULL, 'video', 'draft', 'public', 'close', NULL, NULL, 0, '2023-11-09 13:51:10', '2023-11-09 06:51:10', NULL, NULL, 1, 0, 0, 0, 'false'),
(15, 'Lagu & Gerak Profil Pelajar Pancasila', 'iOmPpLw7VhE', NULL, 0, NULL, 'video', 'draft', 'public', 'close', NULL, NULL, 0, '2023-11-11 05:58:21', '2023-11-10 23:01:13', NULL, NULL, 1, 1, 0, 0, 'false'),
(16, 'Outing Class Mapel PKWU ke MAS WE FARM', '<p style=\"text-align: justify;\">Outing Class mata pelajaran PKWU Kelas XI SMAN 1 Bojonegara yang dilaksanakan pada tanggal 9 dan 10 Oktober 2023 ke MAS WE FARM tentang budidaya peternakan lele.</p>\r\n<p style=\"text-align: center;\">Foto-foto Kegiatan</p>\r\n<p style=\"text-align: center;\"><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699827140877.jpg\" width=\"1009\" height=\"454\" /></p>\r\n<p style=\"text-align: center;\">&nbsp;<img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699827458200.jpg\" alt=\"\" width=\"1000\" height=\"750\" /></p>\r\n<p><img src=\"https://sman1bojonegara.sch.id/media_library/posts/post-image-1699827052499.jpg\" alt=\"\" width=\"1000\" height=\"750\" /></p>', '751eee585a1816b9186d02455b75bbbe.jpg', 1, '+21+', 'post', 'publish', 'public', 'open', 'outing-class-mapel-pkwu-ke-mas-we-farm', '', 594, '2023-11-13 05:13:08', '2025-11-30 08:20:12', NULL, NULL, 1, 1, 0, 0, 'false'),
(17, 'Pembuatan Kursi dari Ecobrick', 'sNXv9OB4PnQ', NULL, 0, NULL, 'video', 'draft', 'public', 'close', NULL, NULL, 0, '2023-11-16 00:01:43', '2023-11-15 17:01:43', NULL, NULL, 1, 0, 0, 0, 'false'),
(18, 'Erapor', '<p>untuk erapor online :</p>\n<ol>\n<li>Erapor&nbsp;Kurmer klik <span style=\"color: #ff0000;\"><strong><a href=\"http://eraporkurmer.sman1bojnegara.my.id:3161\" target=\"_blank\" rel=\"noopener\">disni</a></strong></span></li>\n<li>Erapor K13 klik disini</li>\n</ol>', NULL, 1, NULL, 'page', 'draft', 'public', 'open', 'erapor', NULL, 11, '2023-12-04 15:30:39', '2023-12-04 08:53:23', NULL, NULL, 1, 1, 0, 0, 'false'),
(19, 'Info SPMB SMAN 1 Bojonegara', '<p>Halo apa kabar sobat smanjo, semoga semuanya dalam keadaan sehat wal afiat, aamiiin</p>\r\n<p>sobat smanjo kami updt info terkait SPMB SMAN 1 Bojonegara 2025. Pengumuman besok akan kami post di web dan di posgram. Bagi siswa yang dinyatakan diterima jangan lupa <em>download&nbsp;</em>bukti penerimaanya, dan diserahkan kepada panitia untuk lapor diri. Pengumuman akan di post besok tagal 30 Juni 2025. Selamat bagi calon siswa yang diterima, dan untuk siswa yang belum diterima jangan patah semangat tetap berjuang menjunung tinggi cita-cita.</p>\r\n<p>Hasil pengumuman bisa dilihat di link <a title=\"pengumuman SPMB 2025\" href=\"https://sman1bojonegara.sch.id/spmb/index.php\" target=\"_blank\" rel=\"noopener\">DISNI</a></p>', 'db24704a0c368d5a8da40d15c5dff354.png', 1, '', 'post', 'publish', 'public', 'open', 'info-spmb-sman-1-bojonegara', '', 231, '2025-06-30 00:02:50', '2025-11-29 06:58:30', NULL, NULL, 1, 1, 0, 0, 'false'),
(20, 'SPMB 2025', '<p>Spmb SMAN 1 Bojonegara</p>', NULL, 1, NULL, 'page', 'publish', 'public', 'open', 'spmb-2025', NULL, 14, '2025-06-30 23:14:53', '2025-08-25 13:07:04', NULL, NULL, 1, 0, 0, 0, 'false'),
(21, 'TKA-2025', '<p>Berikut untuk kebutuhan upload foto untuk TKA SMAN 1 Bojonegara Th. 2025 di GD, klik tautan berikut :</p>\n<p>Silhkan <span style=\"background-color: #ff0000;\"><a title=\"Link Upload Foto TKA\" href=\"https://forms.gle/PzQgWC6r164YQnqk6\">KILIK DISINI</a></span></p>', NULL, 1, NULL, 'page', 'publish', 'public', 'open', 'tka-2025', NULL, 1435, '2025-09-09 12:28:15', '2025-11-30 21:50:24', NULL, NULL, 1, 1, 0, 0, 'false');

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) DEFAULT NULL,
  `is_active` enum('true','false') DEFAULT 'false',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quote` varchar(255) DEFAULT NULL,
  `quote_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `quotes`
--

INSERT INTO `quotes` (`id`, `quote`, `quote_by`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Pendidikan merupakan tiket untuk masa depan. Hari esok untuk orang-orang yang telah mempersiapkan dirinya hari ini', 'Anonim', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(2, 'Agama tanpa ilmu pengetahuan adalah buta. Dan ilmu pengetahuan tanpa agama adalah lumpuh', 'Anonim', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(3, 'Hiduplah seakan-akan kau akan mati besok. Belajarlah seakan-akan kau akan hidup selamanya', 'Anonim', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `scholarships`
--

CREATE TABLE `scholarships` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_id` bigint(20) DEFAULT 0,
  `scholarship_type` bigint(20) DEFAULT 0,
  `scholarship_description` varchar(255) NOT NULL,
  `scholarship_start_year` year(4) NOT NULL,
  `scholarship_end_year` year(4) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `setting_group` varchar(100) NOT NULL,
  `setting_variable` varchar(255) DEFAULT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_default_value` text DEFAULT NULL,
  `setting_access_group` varchar(255) DEFAULT NULL,
  `setting_description` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;



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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `major_id` bigint(20) DEFAULT 0 COMMENT 'Program Keahlian',
  `first_choice_id` bigint(20) DEFAULT 0 COMMENT 'Pilihan Pertama PPDB',
  `second_choice_id` bigint(20) DEFAULT 0 COMMENT 'Pilihan Kedua PPDB',
  `registration_number` varchar(10) DEFAULT NULL COMMENT 'Nomor Pendaftaran',
  `admission_exam_number` varchar(10) DEFAULT NULL COMMENT 'Nomor Ujian Tes Tulis',
  `selection_result` varchar(100) DEFAULT NULL COMMENT 'Hasil Seleksi PPDB/PMB',
  `admission_phase_id` bigint(20) DEFAULT 0 COMMENT 'Gelombang Pendaftaran',
  `admission_type_id` bigint(20) DEFAULT 0 COMMENT 'Jalur Pendaftaran',
  `photo` varchar(100) DEFAULT NULL,
  `achievement` text DEFAULT NULL COMMENT 'Prestasi Calon Peserta Didik / Mahasiswa',
  `is_student` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Apakah Siswa Aktif ? Set true jika lolos seleksi PPDB dan set FALSE jika sudah lulus',
  `is_prospective_student` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Apakah Calon Siswa Baru ?',
  `is_alumni` enum('true','false','unverified') NOT NULL DEFAULT 'false' COMMENT 'Apakah Alumni?',
  `is_transfer` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Jenis Pendaftaran : Baru / Pindahan ?',
  `re_registration` enum('true','false') DEFAULT NULL COMMENT 'Konfirmasi Pendaftaran Ulang Calon Siswa Baru',
  `start_date` date DEFAULT NULL COMMENT 'Tanggal Masuk Sekolah',
  `identity_number` varchar(50) DEFAULT NULL COMMENT 'NIS/NIM',
  `nisn` varchar(50) DEFAULT NULL COMMENT 'Nomor Induk Siswa Nasional',
  `nik` varchar(50) DEFAULT NULL COMMENT 'Nomor Induk Kependudukan/KTP',
  `prev_exam_number` varchar(50) DEFAULT NULL COMMENT 'Nomor Peserta Ujian Sebelumnya',
  `prev_diploma_number` varchar(50) DEFAULT NULL COMMENT 'Nomor Ijazah Sebelumnya',
  `paud` enum('true','false') DEFAULT NULL COMMENT 'Apakah Pernah PAUD',
  `tk` enum('true','false') DEFAULT NULL COMMENT 'Apakah Pernah TK',
  `skhun` varchar(50) DEFAULT NULL COMMENT 'No. Seri Surat Keterangan Hasil Ujian Nasional Sebelumnya',
  `prev_school_name` varchar(255) DEFAULT NULL COMMENT 'Nama Sekolah Sebelumnya',
  `prev_school_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Sekolah Sebelumnya',
  `hobby` varchar(255) DEFAULT NULL,
  `ambition` varchar(255) DEFAULT NULL COMMENT 'Cita-Cita',
  `full_name` varchar(150) NOT NULL,
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `birth_place` varchar(255) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `religion_id` bigint(20) DEFAULT 0,
  `special_need_id` bigint(20) DEFAULT 0 COMMENT 'Berkeburuhan Khusus',
  `street_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Jalan',
  `rt` varchar(10) DEFAULT NULL COMMENT 'Alamat Jalan',
  `rw` varchar(10) DEFAULT NULL COMMENT 'Alamat Jalan',
  `sub_village` varchar(255) DEFAULT NULL COMMENT 'Nama Dusun',
  `village` varchar(255) DEFAULT NULL COMMENT 'Nama Kelurahan/Desa',
  `sub_district` varchar(255) DEFAULT NULL COMMENT 'Kecamatan',
  `district` varchar(255) DEFAULT NULL COMMENT 'Kota/Kabupaten',
  `postal_code` varchar(20) DEFAULT NULL COMMENT 'Kode POS',
  `residence_id` bigint(20) DEFAULT 0 COMMENT 'Tempat Tinggal',
  `transportation_id` bigint(20) DEFAULT 0 COMMENT 'Moda Transportasi',
  `phone` varchar(50) DEFAULT NULL,
  `mobile_phone` varchar(50) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `sktm` varchar(100) DEFAULT NULL COMMENT 'Surat Keterangan Tidak Mampu (SKTM)',
  `kks` varchar(100) DEFAULT NULL COMMENT 'Kartu Keluarga Sejahtera (KKS)',
  `kps` varchar(100) DEFAULT NULL COMMENT 'Kartu Pra Sejahtera (KPS)',
  `kip` varchar(100) DEFAULT NULL COMMENT 'Kartu Indonesia Pintar (KIP)',
  `kis` varchar(100) DEFAULT NULL COMMENT 'Kartu Indonesia Sehat (KIS)',
  `citizenship` enum('WNI','WNA') NOT NULL DEFAULT 'WNI' COMMENT 'Kewarganegaraan',
  `country` varchar(255) DEFAULT NULL,
  `father_name` varchar(150) DEFAULT NULL,
  `father_birth_year` year(4) DEFAULT NULL,
  `father_education_id` bigint(20) DEFAULT 0,
  `father_employment_id` bigint(20) DEFAULT 0,
  `father_monthly_income_id` bigint(20) DEFAULT 0,
  `father_special_need_id` bigint(20) DEFAULT 0,
  `mother_name` varchar(150) DEFAULT NULL,
  `mother_birth_year` year(4) DEFAULT NULL,
  `mother_education_id` bigint(20) DEFAULT 0,
  `mother_employment_id` bigint(20) DEFAULT 0,
  `mother_monthly_income_id` bigint(20) DEFAULT 0,
  `mother_special_need_id` bigint(20) DEFAULT 0,
  `guardian_name` varchar(150) DEFAULT NULL,
  `guardian_birth_year` year(4) DEFAULT NULL,
  `guardian_education_id` bigint(20) DEFAULT 0,
  `guardian_employment_id` bigint(20) DEFAULT 0,
  `guardian_monthly_income_id` bigint(20) DEFAULT 0,
  `mileage` smallint(6) DEFAULT NULL COMMENT 'Jarak tempat tinggal ke sekolah',
  `traveling_time` smallint(6) DEFAULT NULL COMMENT 'Waktu Tempuh',
  `height` smallint(6) DEFAULT NULL COMMENT 'Tinggi Badan',
  `weight` smallint(6) DEFAULT NULL COMMENT 'Berat Badan',
  `sibling_number` smallint(6) DEFAULT 0 COMMENT 'Jumlah Saudara Kandung',
  `student_status_id` bigint(20) DEFAULT 0 COMMENT 'Status siswa',
  `end_date` date DEFAULT NULL COMMENT 'Tanggal Keluar',
  `reason` varchar(255) DEFAULT NULL COMMENT 'Diisi jika peserta didik sudah keluar',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tag` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`id`, `tag`, `slug`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Berita', 'berita', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(2, 'Pengumuman', 'pengumuman', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(3, 'Sekilas Info', 'sekilas-info', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 0, 0, 0, 0, 'false'),
(6, 'sekilas-info', 'sekilas-info', '2023-10-03 12:17:24', '2023-10-03 05:17:24', NULL, NULL, 1, 0, 0, 0, 'false');

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `theme_name` varchar(255) NOT NULL,
  `theme_folder` varchar(255) DEFAULT NULL,
  `theme_author` varchar(255) DEFAULT NULL,
  `is_active` enum('true','false') DEFAULT 'false',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `theme_name`, `theme_folder`, `theme_author`, `is_active`, `created_at`, `updated_at`, `deleted_at`, `restored_at`, `created_by`, `updated_by`, `deleted_by`, `restored_by`, `is_deleted`) VALUES
(1, 'Sky Light', 'sky_light', 'Anton Sofyan', 'false', '2023-01-15 21:23:22', '2023-10-03 05:06:40', NULL, NULL, 1, 0, 0, 0, 'false'),
(2, 'Blue Sky', 'blue_sky', 'Anton Sofyan', 'false', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(3, 'Green Land', 'green_land', 'Anton Sofyan', 'false', '2023-01-15 21:23:22', '2023-01-15 14:23:22', NULL, NULL, 1, 0, 0, 0, 'false'),
(4, 'barka', 'barka', 'pesa', 'true', '2023-10-03 12:06:31', '2023-10-03 05:06:40', NULL, NULL, 1, 1, 0, 0, 'false');

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE `user_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_group` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `user_privileges`
--

CREATE TABLE `user_privileges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_group_id` bigint(20) DEFAULT 0,
  `module_id` bigint(20) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `restored_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT 0,
  `updated_by` bigint(20) DEFAULT 0,
  `deleted_by` bigint(20) DEFAULT 0,
  `restored_by` bigint(20) DEFAULT 0,
  `is_deleted` enum('true','false') DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `_sessions`
--

CREATE TABLE `_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `_sessions`
--

INSERT INTO `_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('e8b6f8911a585346e3833b6e18458964456e6b48', '66.249.75.171', 1764461345, 0x[encoded data, 7630 characters]),
('d216b0589116cb590a3185f48879e78d1dd19e71', '57.141.2.61', 1764462092, 0x[encoded data, 7630 characters]),
('8ecfe7f9c4b43ae2f2258e9de7ce12d0203260fa', '57.141.2.7', 1764465143, 0x[encoded data, 7630 characters]),
('86459e8be2e44328c3b89a1c93c2d680b4232595', '5.39.1.233', 1764465545, 0x[encoded data, 7630 characters]),
('2eff9c74b94f3f1b1c66b650d5a423e3ef68062d', '57.141.2.77', 1764466418, 0x[encoded data, 7630 characters]),
('447d9cc680d3e35240681c0088fd0b992e2c788d', '66.249.75.173', 1764468326, 0x[encoded data, 7630 characters]);
INSERT INTO `_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('a81c0a402d48c13865f4688d551fe45fc2fb2ba3', '5.39.109.178', 1764468514, 0x[encoded data, 7630 characters]),
('541e70efbd1a65344306f4a56d4d90c31fade46d', '57.141.2.11', 1764468879, 0x[encoded data, 7630 characters]),
('a2b3a4e8c11ee4fd50d9f33ecf3bc5de1d824d60', '66.249.75.171', 1764469033, 0x[encoded data, 7630 characters]),
('019108ef0dba797e9c9196bdb71df11329a7bcc9', '57.141.2.34', 1764469728, 0x[encoded data, 7630 characters]),
('86e000c0310b60b2000ec79085e98a961f46737b', '51.68.247.195', 1764471416, 0x[encoded data, 7630 characters]),
('26b5eb3aa7fb489d3b4e71b1afd27ebf97b2fbf4', '57.141.2.58', 1764471586, 0x[encoded data, 7630 characters]);
INSERT INTO `_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('5a9f77ca5a6af2b9bbfbca6ad5d06ed3abdbb58d', '176.31.139.3', 1764474604, 0x[encoded data, 7630 characters]),
('d457c689a82491ebe43cb12cc41ed957730689ef', '57.141.2.58', 1764475143, 0x[encoded data, 7630 characters]),
('ed36fa7e05c3212c12d1bbf6acccd9d0cc8c2780', '37.59.204.129', 1764477612, 0x[encoded data, 7630 characters]),
('d4e0518e6bd11e600c69c57d69621c6413e2bf4e', '47.128.32.101', 1764478107, 0x[encoded data, 7630 characters]),
('4e199d7ed41b3a52bb88db22985e7a7a5263337b', '57.141.2.27', 1764478202, 0x[encoded data, 7630 characters]),
('9c1e7887546016084cd2fc162d804d926b1ed911', '54.37.118.90', 1764481027, 0x[encoded data, 7630 characters]);
INSERT INTO `_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('fd3546f0488d4ac0820c0ecef61999cdc25640e1', '157.55.39.57', 1764483074, 0x[encoded data, 7630 characters]),
('1dc98168bad054ef41e5a34e67065692442ac8cc', '92.222.108.99', 1764483179, 0x[encoded data, 7630 characters]),
('9927fd52e08d692d0fefd1f915a8d9c352213bc0', '108.27.157.58', 1764484840, 0x[encoded data, 7630 characters]),
('f561d27a8e80c8ee31d8eddef13d9ef4efc4509a', '92.222.104.223', 1764485527, 0x[encoded data, 7630 characters]),
('2f0a98389b0bc7d796728a2576b99003ed76e61b', '37.59.204.133', 1764488199, 0x[encoded data, 7630 characters]),
('e8ee8ebc13ec8621030c65200a5b16f8b0b0de5a', '66.249.71.2', 1764490068, 0x[encoded data, 7630 characters]);
INSERT INTO `_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('aea45e71392731a1cb8c134e65255f9cca0db2a9', '51.68.247.222', 1764490812, 0x[encoded data, 7630 characters]),
('2abb2262dad10c2591805f81613d0afc2a7e779e', '54.37.118.92', 1764493168, 0x[encoded data, 7630 characters]),
('26ccd31c5f942800973848dfd397835f49960380', '40.77.167.48', 1764494432, 0x[encoded data, 7630 characters]),
('d096f3e50a30e3bdbadbb8885992ceaa3223eb3a', '92.222.104.216', 1764496417, 0x[encoded data, 7630 characters]),
('8249d34a5a4b2a7cd2dd58d7de85d85ed010e678', '94.23.188.223', 1764499220, 0x[encoded data, 7630 characters]),
('83f5954de6b4f41758407e7ab5684f89bfee1086', '51.68.247.197', 1764502646, 0x[encoded data, 7630 characters]);
INSERT INTO `_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('15ca8f817237bea16207f1272b31e993c73a6bf1', '92.222.108.101', 1764506113, 0x[encoded data, 7630 characters]),
('6b5303b0ac7173864f9a1d6a905d3aa4f48412d2', '66.249.75.172', 1764507038, 0x[encoded data, 7630 characters]),
('e1d11d76d8fc5a96dfc37c93bcce39aa91794cfe', '66.249.75.172', 1764507089, 0x[encoded data, 7630 characters]),
('2727a7e1f41773904db7e1124b0bce7286ca7cc4', '37.59.204.133', 1764510019, 0x[encoded data, 7630 characters]),
('976a8099cdad4aae710672b44ce3a99be570dfeb', '162.120.185.53', 1764511430, 0x[encoded data, 7630 characters]),
('06bf7097c370ff411090012492aa6caa503a76c9', '173.252.83.20', 1764511781, 0x[encoded data, 7630 characters]);
INSERT INTO `_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('7bd22cf97490d110c59a4e41d70e4362d152e165', '207.46.13.6', 1764513486, 0x[encoded data, 7630 characters]),
('6727cbd45863a842c484f044e105a2cbeedeb718', '176.31.139.13', 1764514396, 0x[encoded data, 7630 characters]),
('32bb8e826dcc1ab9b8fdf966741eeab4edbbd449', '66.249.75.172', 1764518838, 0x[encoded data, 7630 characters]),
('ec63206d74519e82785a079c506bd485d42ad2b5', '5.39.109.171', 1764519489, 0x[encoded data, 7630 characters]),
('0e2382c66c3f5585308fad1d56d4c9983c34710d', '152.114.192.68', 1764519764, 0x[encoded data, 7630 characters]),
('503c886903f32401a2be12126826df01ca64f07d', '162.120.185.27', 1764521930, 0x[encoded data, 7630 characters]);
