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

START TRANSACTION;



--
-- Database: `db_isvill`
--

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

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

CREATE TABLE `achievements` (
  `id` bigint UNSIGNED NOT NULL,
  `program` enum('ib','iis') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ib',
  `title_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc_id` text COLLATE utf8mb4_unicode_ci,
  `desc_en` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `achievements`
--

INSERT INTO `achievements` (`id`, `program`, `title_id`, `title_en`, `desc_id`, `desc_en`, `image`, `created_at`, `updated_at`) VALUES
(1, 'ib', 'Prestasi Siswa: Juara 3 EF Spelling Bee Competition 2024', 'Student Achievement: 3rd Place at EF Spelling Bee Competition 2024', 'Kami bangga mengumumkan bahwa Ahmad Akhtar Abyadh Mayeli telah meraih peringkat ke-3 dalam ajang EF Spelling Bee Competition 2024. Prestasi ini merupakan bukti dedikasi dan pengembangan diri siswa dalam bidang literasi bahasa Inggris.', 'We are proud to announce that Ahmad Akhtar Abyadh Mayeli has secured 3rd place in the EF Spelling Bee Competition 2024. This achievement reflects the student\'s dedication and commitment to excellence in English literacy.', 'achievements/01KSH95EPRTX56KSDTSJDDATX6.png', '2026-05-25 21:37:23', '2026-05-25 21:37:23'),
(2, 'ib', 'Prestasi Siswa: Medali Emas Taekwondo di Hobby Land Championship 2024', 'Student Achievement: Gold Medalist at Hobby Land Taekwondo Championship 2024', 'Selamat kepada Tatyana Dealova Ayunda N, siswa kelas 3, atas keberhasilannya meraih medali emas dalam Girls\' Taekwondo Competition di ajang Hobby Land Taekwondo Championship Tangcity Cup 2024. Kami sangat bangga atas dedikasi dan pencapaian luar biasa ini.', 'Congratulations to Tatyana Dealova Ayunda N, a Grade 3 student, for securing a gold medal in the Girls\' Taekwondo Competition at the Hobby Land Taekwondo Championship Tangcity Cup 2024. We are proud of this exceptional dedication and achievement.', 'achievements/01KSH9HKASWM4TJC8N66K0KC8X.png', '2026-05-25 21:44:01', '2026-05-25 21:44:01'),
(3, 'ib', 'Prestasi Siswa: Juara 1 Renang Gaya Punggung di Cikal Amri Cup', 'Student Achievement: 1st Place in Backstroke at Cikal Amri Cup', 'Selamat kepada Shakeela Nawara A. P., siswa kelas 2.1, atas pencapaian luar biasa sebagai juara 1 pada kategori Girls\' 25m Backstroke dalam kompetisi renang Olympics Cikal Amri Cup. Kami bangga atas dedikasi dan kerja keras yang telah ditunjukkan.', 'Congratulations to Shakeela Nawara A. P., a Grade 2.1 student, for her remarkable achievement as the 1st place winner in the Girls\' 25m Backstroke category at the Olympics Cikal Amri Cup swimming competition. We are proud of the dedication and hard work she has demonstrated.', 'achievements/01KSH9ZF7PRAWFTKEXEEHMKEWK.png', '2026-05-25 21:51:36', '2026-05-25 21:51:36'),
(4, 'ib', 'Prestasi Siswa: Raihan Medali di Kujang Cup Swimming Competition', 'Student Achievement: Medalists at Kujang Cup Swimming Competition', 'Selamat kepada Marwa Azkiya Elshanum, siswa kelas 4, atas keberhasilannya meraih Medali Emas pada kategori 21m Freestyle (Board), serta dua Medali Perunggu pada kategori 21m Freestyle (Fins) dan 21m Breaststroke di ajang Kujang Cup. Pencapaian ini merupakan bukti kerja keras dan dedikasi siswa dalam bidang olahraga renang.', 'Congratulations to Marwa Azkiya Elshanum, a Grade 4 student, for securing a Gold Medal in the 21m Freestyle (Board) category, as well as two Bronze Medals in the 21m Freestyle (Fins) and 21m Breaststroke categories at the Kujang Cup. This achievement is a testament to the student\'s hard work and dedication in swimming.', 'achievements/01KSHA2KRS1SWAEBX7RRTKTX6E.png', '2026-05-25 21:53:19', '2026-05-25 21:53:19'),
(5, 'ib', 'Prestasi Siswa: Juara 1 Karate di Olimpiade Olahraga Siswa Nasional', 'Student Achievement: 1st Place in Karate at the National Student Sports Olympiad', 'Kami mengucapkan selamat kepada Mahira Aleeya Wiraputra, siswa kelas 4.1, atas pencapaiannya meraih Juara 1 dalam kategori Putri pada kompetisi Karate di ajang Olimpiade Olahraga Siswa Nasional (O2SN). Prestasi ini merupakan kebanggaan bagi sekolah atas dedikasi siswa dalam bidang olahraga bela diri.', 'We congratulate Mahira Aleeya Wiraputra, a Grade 4.1 student, for securing 1st place in the Girls\' category at the National Student Sports Olympiad (O2SN) Karate competition. This achievement is a source of pride for the school, reflecting the student\'s dedication to martial arts.', 'achievements/01KSHA54C24YWWCTJQ3E6771E6.png', '2026-05-25 21:54:41', '2026-05-25 21:54:41'),
(6, 'ib', 'Prestasi Siswa: Medali Emas Taekwondo Kyorugi di Tangcity Cup 2024', 'Student Achievement: Gold Medalist in Taekwondo Kyorugi at Tangcity Cup 2024', 'Selamat kepada Lathifa Aisyah Luthfi, siswa kelas 1, atas keberhasilannya meraih Medali Emas dalam kategori Girls\' Taekwondo Kyorugi di ajang Hobby Land Taekwondo Championship Tangcity Cup 2024. Prestasi ini menunjukkan semangat juang dan dedikasi yang tinggi dalam bidang olahraga.', 'Congratulations to Lathifa Aisyah Luthfi, a Grade 1 student, for securing a Gold Medal in the Girls\' Taekwondo Kyorugi category at the Hobby Land Taekwondo Championship Tangcity Cup 2024. This achievement reflects her spirit and strong dedication to sports.', 'achievements/01KSHA734HGN6FRYTQKM01R2YF.png', '2026-05-25 21:55:46', '2026-05-25 21:55:46'),
(7, 'ib', 'Prestasi Siswa: Juara 1 Creative Dance di Gebyar Porseni IGTKI 2025', 'Student Achievement: 1st Place in Creative Dance at Gebyar Porseni IGTKI 2025', 'Selamat kepada Kindergarten 2\'s Dancing Club atas pencapaian luar biasa sebagai Juara 1 kategori Creative Dance dalam ajang Gebyar Porseni Anak TK IGTKI Kabupaten Tangerang yang diselenggarakan di Taman Impian Jaya Ancol pada Selasa, 18 Februari 2025. Prestasi ini merupakan hasil dari kerja keras dan kolaborasi yang solid dari para siswa.', 'Congratulations to the Kindergarten 2\'s Dancing Club for their outstanding achievement as 1st place winners in the Creative Dance category at the Gebyar Porseni Anak TK IGTKI Kabupaten Tangerang, held at Taman Impian Jaya Ancol on Tuesday, February 18, 2025. This achievement reflects the students\' hard work and solid collaboration.', 'achievements/01KSHEAXE8DW7KFHSW2QH8NWSA.png', '2026-05-25 23:07:45', '2026-05-25 23:07:45'),
(8, 'ib', 'Prestasi Siswa: Medali Emas Taekwondo Kyorugi di Tangcity Cup 2024', 'Student Achievement: Gold Medalist in Taekwondo Kyorugi at Tangcity Cup 2024', 'Selamat kepada Muhammad Izzam Anshar R, siswa kelas 3, atas keberhasilannya meraih Medali Emas dalam kategori Boys\' Taekwondo Kyorugi di ajang Hobby Land Taekwondo Championship Tangcity Cup 2024. Prestasi ini merupakan bukti nyata dari dedikasi dan kerja keras siswa dalam bidang olahraga.', 'Congratulations to Muhammad Izzam Anshar R, a Grade 3 student, for securing a Gold Medal in the Boys\' Taekwondo Kyorugi category at the Hobby Land Taekwondo Championship Tangcity Cup 2024. This achievement is a testament to the student\'s dedication and hard work in sports.', 'achievements/01KSHECNYT4ZAYSWKCDMC46N57.png', '2026-05-25 23:08:43', '2026-05-25 23:08:43'),
(9, 'ib', 'Prestasi Siswa: Juara 1 Garuda League U-10 Tournament 2024/2025', 'Student Achievement: 1st Place in Garuda League U-10 Tournament 2024/2025', 'Selamat kepada Idlan Hafizh Sidqi Husaeni, siswa kelas 5, atas keberhasilannya meraih Juara 1 dalam turnamen Garuda League U-10 tahun 2024/2025. Prestasi ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga sepak bola.', 'Congratulations to Idlan Hafizh Sidqi Husaeni, a Grade 5 student, for securing 1st place in the Garuda League U-10 Tournament 2024/2025. This achievement is a testament to the student\'s dedication and hard work in football.', 'achievements/01KSHEJQQG5GBJVF7YKG3X65ZV.png', '2026-05-25 23:12:01', '2026-05-25 23:12:01'),
(10, 'ib', 'Prestasi Siswa: Peraih Medali Emas di Festival Sains Nasional 2024', 'Student Achievement: Gold Medalist at the National Science Festival 2024', 'Selamat kepada Havva Shalihaniyya Maryam, siswa kelas 6, atas keberhasilannya meraih Medali Emas dalam ajang Olimpiade Sains di Festival Sains Nasional (FSN) 2024. Pencapaian ini merupakan bukti dedikasi dan keunggulan akademik siswa di bidang ilmu pengetahuan.', 'Congratulations to Havva Shalihaniyya Maryam, a Grade 6 student, for securing a Gold Medal in the Science Olympiad at the National Science Festival (FSN) 2024. This achievement is a testament to the student\'s dedication and academic excellence in the field of science.', 'achievements/01KSHEMT2FB2PX2S3GG21J8D98.png', '2026-05-25 23:13:09', '2026-05-25 23:13:09'),
(11, 'ib', 'Prestasi Siswa: Juara 1 Sculpture Art Challenge oleh Junior Lab', 'Student Achievement: 1st Place in Sculpture Art Challenge by Junior Lab', 'Selamat kepada Gandewa Arjuna Gelar, siswa kelas 5, atas keberhasilannya meraih Juara 1 dalam ajang Sculpture Art Challenge 2024 yang diselenggarakan oleh Junior Lab. Pencapaian ini merupakan bukti kreativitas dan dedikasi siswa dalam bidang seni rupa.', 'Congratulations to Gandewa Arjuna Gelar, a Grade 5 student, for securing 1st place in the Sculpture Art Challenge 2024, organized by Junior Lab. This achievement is a testament to the student\'s creativity and dedication in the field of visual arts.', 'achievements/01KSHER0XQDBNHWBDCR00V5TR3.png', '2026-05-25 23:14:55', '2026-05-25 23:14:55'),
(12, 'ib', 'Prestasi Siswa: Juara di Liga Sentra Banten dan Nasional', 'Student Achievement: Success in Liga Sentra Banten and National Series', 'Selamat kepada Dimas Abimanyu Pamungkas N, siswa kelas 6, atas keberhasilannya meraih Juara 1 dalam Liga Sentra Banten Provincial Series dan Juara 3 dalam Liga Sentra National Series. Prestasi ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga.', 'Congratulations to Dimas Abimanyu Pamungkas N, a Grade 6 student, for securing 1st place in the Liga Sentra Banten Provincial Series and 3rd place in the Liga Sentra National Series. This achievement is a testament to the student\'s dedication and hard work in sports.', 'achievements/01KSHET3N6YBVCVNRA8DJBGJW9.png', '2026-05-25 23:16:03', '2026-05-25 23:16:03'),
(13, 'ib', 'Prestasi Siswa: Juara 1 EF Spelling Bee Competition 2024', 'Student Achievement: 1st Place at EF Spelling Bee Competition 2024', 'Selamat kepada Aufar Kaisar Permana atas pencapaian luar biasa sebagai Juara 1 dalam EF Spelling Bee Competition 2024. Prestasi ini merupakan bukti dedikasi dan kemampuan akademik siswa dalam literasi bahasa Inggris.', 'Congratulations to Aufar Kaisar Permana for his remarkable achievement as the 1st place winner in the EF Spelling Bee Competition 2024. This achievement is a testament to the student\'s dedication and academic proficiency in English literacy.', 'achievements/01KSHEVTCKSXEZPGC5P1DC2KK9.png', '2026-05-25 23:16:59', '2026-05-25 23:16:59'),
(14, 'ib', 'Prestasi Siswa: Juara 1 Plate Division di Turnamen Baseball Internasional', 'Student Achievement: 1st Place in Plate Division at International Baseball Tournament', 'Selamat kepada Idlan Hafizh Sidqi Husaeni, siswa kelas G6.2, atas keberhasilannya meraih Juara 1 dalam Plate Division di ajang 3rd U-12 Malaysia National & International Invitation Baseball Tournament. Pencapaian ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga bisbol.', 'Congratulations to Idlan Hafizh Sidqi Husaeni, a G6.2 student, for securing 1st Place in the Plate Division at the 3rd U-12 Malaysia National & International Invitation Baseball Tournament. This achievement is a testament to the student\'s dedication and hard work in baseball.', 'achievements/01KSHEXB1YV0SJC0ASTPDAJWPG.png', '2026-05-25 23:17:49', '2026-05-25 23:17:49'),
(15, 'iis', 'Prestasi Siswa: Juara 1 Ratoh Jaroe di Indonesia Menari 2024', 'Student Achievement: 1st Place in Ratoh Jaroe at Indonesia Menari 2024', 'Selamat kepada Tim Tari Saman SD Islamic Village atas keberhasilannya meraih Juara 1 dalam Ratoh Jaroe Competition di ajang Indonesia Menari 2024 pada 24 Agustus 2024. Prestasi ini merupakan bukti dedikasi, kekompakan, dan kerja keras tim dalam melestarikan seni tari tradisional.', 'Congratulations to the SD Islamic Village Saman Dance Team for securing 1st Place in the Ratoh Jaroe Competition at Indonesia Menari 2024 on August 24, 2024. This achievement is a testament to the team\'s dedication, synchronization, and hard work in preserving traditional dance.', 'achievements/01KSHFS9GM0HEPVBEAPNNHVY4V.png', '2026-05-25 23:33:05', '2026-05-25 23:33:05'),
(16, 'iis', 'Prestasi Siswa: Juara 2 Bantalan pada Tangerang Gemilang Student Archery Championship 2023', 'Student Achievement: 2nd Place in Archery at Tangerang Gemilang Student Archery Championship 2023', 'Selamat kepada Sabrina Syakira Almahyra, siswa kelas 3B dari program IIS SD Islamic Village, atas keberhasilannya meraih Juara 2 Bantalan dan peringkat ke-9 dari 60 peserta dalam kualifikasi kategori Putri 10 Meter Standard Bow pada kejuaraan Tangerang Gemilang Student Archery Championship 2023.', 'Congratulations to Sabrina Syakira Almahyra, a Grade 3B student from the SD Islamic Village IIS Program, for securing 2nd Place in Archery (Bantalan) and ranking 9th out of 60 participants in the Girls\' 10-meter Standard Bow qualification at the Tangerang Gemilang Student Archery Championship 2023.', 'achievements/01KSHFWCCEFDK74QJNQ38G50DN.png', '2026-05-25 23:34:46', '2026-05-25 23:47:29'),
(17, 'iis', 'Prestasi Siswa: Raihan Medali di Kejuaraan Panahan Sekolah Cakra Buana 2024', 'Student Achievement: Medalist at the Cakra Buana School Archery Championship 2024', 'Selamat kepada Sabrina Syakira Almahyra, siswa kelas 3B dari program IIS SD Islamic Village, atas pencapaian luar biasa dalam Kejuaraan Panahan Sekolah Cakra Buana 2024. Sabrina berhasil meraih Juara 1 Beregu Putri (Medali Emas), Juara 1 Bantalan (Medali Emas) pada kategori Putri 5 Meter Standard Bow SD 1-3, serta Juara 2 Bantalan (Medali Perak) pada kategori Putri 7 Meter Standard Bow SD 4-6 pada 2 & 3 Maret 2024.', 'Congratulations to Sabrina Syakira Almahyra, a Grade 3B student from the SD Islamic Village IIS Program, for her outstanding achievement at the Cakra Buana School Archery Championship 2024. Sabrina secured 1st Place Girls\' Team (Gold Medal), 1st Place Archery/Bantalan (Gold Medal) in the Girls\' 5 Meter Standard Bow SD 1-3 category, and 2nd Place Archery/Bantalan (Silver Medal) in the Girls\' 7 Meter Standard Bow SD 4-6 category on March 2-3, 2024.', 'achievements/01KSHFY4436V4ENN38C0S55RWF.png', '2026-05-25 23:35:43', '2026-05-25 23:47:45'),
(18, 'iis', 'Prestasi Siswa: Juara 2 Beregu pada Gunung Geulis Archery Championship 2024', 'Student Achievement: 2nd Place Team Winner at the Gunung Geulis Archery Championship 2024', 'Selamat kepada Sabrina Syakira Almahyra, siswa kelas 3B dari program IIS SD Islamic Village, atas keberhasilannya meraih Juara 2 Beregu dalam kategori Standard Bow U12 Women di ajang Gunung Geulis Archery Championship 2024 pada Sabtu, 27 Januari 2024.', 'Congratulations to Sabrina Syakira Almahyra, a Grade 3B student from the SD Islamic Village IIS Program, for securing 2nd Place in the Team category (Standard Bow U12 Women) at the Gunung Geulis Archery Championship 2024 on Saturday, January 27, 2024.', 'achievements/01KSHG053Q6NDDTWY36T1ZYDZJ.png', '2026-05-25 23:36:50', '2026-05-25 23:48:08'),
(19, 'iis', 'Prestasi Siswa: Juara 3 Liga Sentra Indonesia Seri Nasional', 'Student Achievement: 3rd Place at Liga Sentra Indonesia National Series', 'Selamat kepada Muhammad Farras Apriza, siswa kelas 6A dari program IIS SD Islamic Village, atas keberhasilannya meraih Juara 3 dalam Liga Sentra Indonesia Seri Nasional yang diselenggarakan oleh Liga Sentra Indonesia pada 3-15 Februari 2025. Pencapaian ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga sepak bola.', 'Congratulations to Muhammad Farras Apriza, a Grade 6A student from the SD Islamic Village IIS Program, for securing 3rd Place in the Liga Sentra Indonesia National Series, organized by Liga Sentra Indonesia from February 3-15, 2025. This achievement is a testament to the student\'s dedication and hard work in football.', 'achievements/01KSHG1R220RHVETSCZZRNWN9V.png', '2026-05-25 23:37:42', '2026-05-25 23:48:28'),
(20, 'iis', 'Prestasi Siswa: Juara 1 Spelling Bee di SYAFEST 2024', 'Student Achievement: 1st Place in Spelling Bee at SYAFEST 2024', 'Selamat kepada Kinanti Prameswari Santosa, siswa kelas 5A dari program IIS SD Islamic Village, atas keberhasilannya meraih Juara 1 dalam lomba Spelling Bee pada ajang SYAFEST 2024 \"Syafana Festival 2024\". Prestasi ini merupakan bukti kemampuan akademik siswa dalam literasi bahasa Inggris.', 'Congratulations to Kinanti Prameswari Santosa, a Grade 5A student from the SD Islamic Village IIS Program, for securing 1st Place in the Spelling Bee competition at SYAFEST 2024 \"Syafana Festival 2024\". This achievement is a testament to the student\'s academic proficiency in English literacy.', 'achievements/01KSHG3BMR1TAPH3VZM1H20Z3X.png', '2026-05-25 23:38:35', '2026-05-25 23:48:59'),
(21, 'iis', 'Prestasi Siswa: Peraih Medali Perak di Ganesha National Open Taekwondo Competition 2024', 'Student Achievement: Silver Medalist at the Ganesha National Open Taekwondo Competition 2024', 'Selamat kepada Defasa Queen Rain Ramadhani, siswa kelas 8A dari program IIS SMP Islamic Village, atas keberhasilannya meraih Medali Perak dalam ajang Ganesha National Open Taekwondo Competition 2024. Prestasi ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga bela diri.', 'Congratulations to Defasa Queen Rain Ramadhani, a Grade 8A student from the IIS SMP Islamic Village program, for securing a Silver Medal at the Ganesha National Open Taekwondo Competition 2024. This achievement is a testament to the student\'s dedication and hard work in martial arts.', 'achievements/01KSHG545Q9HCRWPVT3MDGPZST.png', '2026-05-25 23:39:33', '2026-05-25 23:50:13'),
(22, 'iis', 'Prestasi Siswa: Peraih Medali Perunggu di Piala KONI CUP 2024', 'Student Achievement: Bronze Medalist at the KONI CUP 2024', 'Selamat kepada Defasa Queen Rain Ramadhani, siswa kelas 8A dari program IIS SMP Islamic Village, atas keberhasilannya meraih Medali Perunggu dalam kategori Cadet Kyorugi Putri U44 pada ajang Piala KONI CUP 2024. Prestasi ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga bela diri.', 'Congratulations to Defasa Queen Rain Ramadhani, a Grade 8A student from the IIS SMP Islamic Village program, for securing a Bronze Medal in the Cadet Kyorugi Putri U44 category at the KONI CUP 2024. This achievement is a testament to the student\'s dedication and hard work in martial arts.', 'achievements/01KSHG6X6GDBMMM6758M29CAA2.png', '2026-05-25 23:40:31', '2026-05-25 23:50:31'),
(23, 'iis', 'Prestasi Siswa: Juara 2 di 51AP Indonesian International Open Karate Championship', 'Student Achievement: 2nd Place at 51AP Indonesian International Open Karate Championship', 'Selamat kepada Azfar Zidane Indratmoko, siswa kelas 8A dari program IIS SMP Islamic Village, atas keberhasilannya meraih Juara 2 dalam ajang 51AP Indonesian International Open Karate Championship. Prestasi ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga bela diri karate.', 'Congratulations to Azfar Zidane Indratmoko, a Grade 8A student from the IIS SMP Islamic Village program, for securing 2nd Place at the 51AP Indonesian International Open Karate Championship. This achievement is a testament to the student\'s dedication and hard work in karate.', 'achievements/01KSHG8GRMFQT5QEE06B5H6F2Q.png', '2026-05-25 23:41:24', '2026-05-25 23:50:43'),
(24, 'iis', 'Prestasi Siswa: Juara Renang di Area Speed Challenge 2025', 'Student Achievement: Swimming Champion at Area Speed Challenge 2025', 'Selamat kepada Azfar Zidane Indratmoko, siswa kelas 8A dari program IIS SMP Islamic Village, atas keberhasilannya meraih Juara 1 pada seri 25m Gaya Bebas dan Juara 3 pada seri 25m Gaya Dada dalam ajang Perlombaan Renang Antar Pelajar \"Area Speed Challenge 2025\". Pencapaian ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga renang.', 'Congratulations to Azfar Zidane Indratmoko, a Grade 8A student from the IIS SMP Islamic Village program, for securing 1st Place in the 25m Freestyle series and 3rd Place in the 25m Breaststroke series at the \"Area Speed Challenge 2025\" student swimming competition. This achievement is a testament to the student\'s dedication and hard work in swimming.', 'achievements/01KSHGA69KK5W68CDAMTT5VYZ2.png', '2026-05-25 23:42:19', '2026-05-25 23:51:12'),
(25, 'iis', 'Prestasi Siswa: Juara 3 Olimpiade Olahraga Siswa Nasional Tingkat Kecamatan', 'Student Achievement: 3rd Place at the National Student Sports Olympiad (District Level)', 'Selamat kepada Aqil Rasyid Adha, siswa kelas 5B dari program IIS SD Islamic Village, atas keberhasilannya meraih Juara 3 dalam Olimpiade Olahraga Siswa Nasional tingkat Kecamatan Kelapa Dua pada 25 April 2024. Prestasi ini merupakan bukti dedikasi dan kerja keras siswa dalam bidang olahraga.', 'Congratulations to Aqil Rasyid Adha, a Grade 5B student from the SD Islamic Village IIS Program, for securing 3rd Place in the National Student Sports Olympiad at the Kelapa Dua District level on April 25, 2024. This achievement is a testament to the student\'s dedication and hard work in sports.', 'achievements/01KSHGE1S9CANK9PXEFJVZFJ7E.png', '2026-05-25 23:44:25', '2026-05-25 23:53:01'),
(26, 'iis', 'Prestasi Siswa: Peraih Medali Silver & Bronze di Isaac Newton Competition', 'Student Achievement: Silver & Bronze Medalist at Isaac Newton Competition', 'Selamat kepada Riffat Althaf Fauzan, siswa kelas 8A dari program IIS SMP Islamic Village, atas keberhasilannya meraih Medali Silver dan Medali Bronze dalam ajang Isaac Newton Competition (Olimnus x Himabio IPB University). Prestasi ini merupakan bukti kemampuan akademik siswa yang luar biasa.', 'Congratulations to Riffat Althaf Fauzan, a Grade 8A student from the IIS SMP Islamic Village program, for winning a Silver Medal and a Bronze Medal at the Isaac Newton Competition (Olimnus x Himabio IPB University). This achievement is a testament to the student\'s outstanding academic capabilities.', 'achievements/01KSHGFVFSV109Q95SP877MW05.png', '2026-05-25 23:45:24', '2026-05-25 23:53:17');

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

--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` bigint UNSIGNED NOT NULL,
  `program` enum('ib','iis','early_years') COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc_id` text COLLATE utf8mb4_unicode_ci,
  `desc_en` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activities`
--

INSERT INTO `activities` (`id`, `program`, `title_id`, `title_en`, `desc_id`, `desc_en`, `created_at`, `updated_at`) VALUES
(1, 'ib', 'Praktik Dasar Perawatan Pesawat', 'Basic Aircraft Maintenance Practice', 'Siswa Program IB mengikuti kegiatan praktik dasar perawatan pesawat untuk memahami komponen utama dan prosedur pemeriksaan keselamatan penerbangan.', 'IB students participated in basic aircraft maintenance activities to understand aircraft components and safety inspection procedures.', '2026-06-03 21:22:25', '2026-06-03 21:22:25'),
(2, 'ib', 'Kunjungan Industri ke Hanggar Penerbangan', 'Industrial Visit to Aviation Hangar', 'Kegiatan kunjungan industri memberikan kesempatan kepada siswa untuk melihat langsung proses maintenance pesawat di lingkungan kerja profesional.', 'This industrial visit allowed students to observe aircraft maintenance operations in a professional aviation environment.', '2026-06-03 21:24:49', '2026-06-03 21:24:49'),
(3, 'ib', 'Pelatihan Keselamatan Kerja Penerbangan', 'Aviation Safety Training', 'Siswa mendapatkan pelatihan mengenai prosedur keselamatan kerja dan penggunaan alat pelindung diri sesuai standar industri penerbangan.', 'Students received training on workplace safety procedures and proper use of protective equipment according to aviation industry standards.', '2026-06-04 00:55:00', '2026-06-04 00:55:00'),
(4, 'ib', 'Simulasi Ground Handling Pesawat', 'Aircraft Ground Handling Simulation', 'Kegiatan simulasi ground handling bertujuan memberikan pengalaman praktik mengenai proses pelayanan pesawat di area apron.', 'The ground handling simulation provided practical experience in aircraft service operations on the airport apron.', '2026-06-04 00:55:51', '2026-06-04 00:55:51'),
(5, 'ib', 'Workshop Digital Marketing', 'Digital Marketing Workshop', 'Siswa IIS mempelajari strategi pemasaran digital, pengelolaan media sosial, dan teknik promosi bisnis melalui platform online.', 'IIS students learned digital marketing strategies, social media management, and online business promotion techniques.', '2026-06-04 00:56:51', '2026-06-04 00:56:51'),
(6, 'ib', 'Seminar Kewirausahaan Muda', 'Young Entrepreneurship Seminar', 'Seminar menghadirkan pelaku usaha muda yang berbagi pengalaman membangun bisnis dan menghadapi tantangan dunia usaha modern.', 'The seminar featured young entrepreneurs sharing experiences in building businesses and overcoming modern business challenges.', '2026-06-04 00:57:53', '2026-06-04 00:57:53'),
(7, 'ib', 'Pelatihan Public Speaking', 'Public Speaking Training', 'Kegiatan ini bertujuan meningkatkan kemampuan komunikasi, presentasi, dan kepercayaan diri siswa dalam berbicara di depan umum.', 'This activity aimed to improve students\' communication, presentation, and public speaking confidence.', '2026-06-04 00:59:11', '2026-06-04 00:59:11'),
(8, 'ib', 'Business Project Exhibition', 'Business Project Exhibition', 'Siswa IIS mempresentasikan hasil proyek bisnis yang telah dikembangkan selama proses pembelajaran kepada guru dan praktisi industri.', 'IIS students presented their business projects to teachers and industry practitioners as part of their learning activities.', '2026-06-04 00:59:59', '2026-06-04 00:59:59'),
(9, 'iis', 'Business Project Exhibition', 'Business Project Exhibition', 'Siswa IIS mempresentasikan hasil proyek bisnis yang telah dikembangkan selama proses pembelajaran kepada guru dan praktisi industri.', 'IIS students presented their business projects to teachers and industry practitioners as part of their learning activities.', '2026-06-04 01:46:11', '2026-06-04 01:46:11'),
(10, 'iis', 'Pelatihan Public Speaking', 'Public Speaking Training', 'Kegiatan ini bertujuan meningkatkan kemampuan komunikasi, presentasi, dan kepercayaan diri siswa dalam berbicara di depan umum.', 'This activity aimed to improve students\' communication, presentation, and public speaking confidence.', '2026-06-04 01:47:51', '2026-06-04 01:47:51'),
(11, 'iis', 'Seminar Kewirausahaan Muda', 'Young Entrepreneurship Seminar', 'Seminar menghadirkan pelaku usaha muda yang berbagi pengalaman membangun bisnis dan menghadapi tantangan dunia usaha modern.', 'The seminar featured young entrepreneurs sharing experiences in building businesses and overcoming modern business challenges.', '2026-06-04 01:49:15', '2026-06-04 01:49:15'),
(12, 'iis', 'Workshop Digital Marketing', 'Digital Marketing Workshop', 'Siswa IIS mempelajari strategi pemasaran digital, pengelolaan media sosial, dan teknik promosi bisnis melalui platform online.', 'IIS students learned digital marketing strategies, social media management, and online business promotion techniques.', '2026-06-04 01:50:20', '2026-06-04 01:50:20'),
(13, 'iis', 'Simulasi Ground Handling Pesawat', 'Aircraft Ground Handling Simulation', 'Kegiatan simulasi ground handling bertujuan memberikan pengalaman praktik mengenai proses pelayanan pesawat di area apron.', 'The ground handling simulation provided practical experience in aircraft service operations on the airport apron.', '2026-06-04 01:51:27', '2026-06-04 01:51:27'),
(14, 'iis', 'Pelatihan Keselamatan Kerja Penerbangan', 'Aviation Safety Training', 'Siswa mendapatkan pelatihan mengenai prosedur keselamatan kerja dan penggunaan alat pelindung diri sesuai standar industri penerbangan.', 'Students received training on workplace safety procedures and proper use of protective equipment according to aviation industry standards.', '2026-06-04 01:52:46', '2026-06-04 01:52:46'),
(15, 'iis', 'Kunjungan Industri ke Hanggar Penerbangan', 'Industrial Visit to Aviation Hangar', 'Kegiatan kunjungan industri memberikan kesempatan kepada siswa untuk melihat langsung proses maintenance pesawat di lingkungan kerja profesional.', 'This industrial visit allowed students to observe aircraft maintenance operations in a professional aviation environment.', '2026-06-04 01:53:50', '2026-06-04 01:53:50'),
(16, 'iis', 'Praktik Dasar Perawatan Pesawat', 'Basic Aircraft Maintenance Practice', 'Siswa Program IB mengikuti kegiatan praktik dasar perawatan pesawat untuk memahami komponen utama dan prosedur pemeriksaan keselamatan penerbangan.', 'IB students participated in basic aircraft maintenance activities to understand aircraft components and safety inspection procedures.', '2026-06-04 01:54:46', '2026-06-04 01:54:46'),
(17, 'early_years', 'Pertunjukan Seni Nusantara', 'Nusantara Art Performance', 'Siswa menampilkan tarian tradisional dengan kostum budaya.', 'Students performing traditional dances with cultural costumes.', '2026-06-07 19:53:02', '2026-06-07 19:53:02'),
(18, 'early_years', 'Hari Kemerdekaan', 'Independence Day Celebration', 'Perayaan kemerdekaan dengan lomba dan pawai anak.', 'Independence day celebration with games and kids parade.', '2026-06-07 19:59:04', '2026-06-07 19:59:04'),
(19, 'early_years', 'Kunjungan Kebun Binatang', 'Zoo Field Trip', 'Kegiatan belajar sambil mengenal hewan di lingkungan terbuka.', 'Field trip activities to learn about animals in the zoo.', '2026-06-07 20:05:13', '2026-06-07 20:05:13'),
(20, 'early_years', 'Lomba Mewarnai', 'Coloring Competition', 'Mengembangkan kreativitas anak melalui lomba mewarnai.', 'Developing children\'s creativity through a coloring competition.', '2026-06-07 20:06:35', '2026-06-07 20:06:35'),
(21, 'early_years', 'Hari Profesi', 'Career Day', 'Anak-anak berpakaian sesuai cita-cita masa depan mereka.', 'Children dressed up according to their future career dreams.', '2026-06-07 20:07:50', '2026-06-07 20:07:50'),
(22, 'early_years', 'Memasak Bersama', 'Cooking Together', 'Belajar dasar memasak makanan sehat sederhana bersama guru.', 'Learning the basics of cooking simple healthy food with teachers.', '2026-06-07 20:11:45', '2026-06-07 20:11:45'),
(23, 'early_years', 'Olahraga Ceria', 'Fun Sports Day', 'Aktivitas fisik untuk melatih ketangkasan dan kerjasama tim.', 'Physical activities to train agility and team collaboration.', '2026-06-07 20:27:07', '2026-06-07 20:27:07'),
(24, 'early_years', 'Bercerita di Perpustakaan', 'Storytelling at Library', 'Sesi mendengarkan cerita untuk meningkatkan minat baca.', 'Storytelling session to increase interest in reading.', '2026-06-07 20:28:34', '2026-06-07 20:28:34'),
(25, 'early_years', 'Pertunjukan Seni Nusantara', 'Nusantara Art Performance', 'Siswa menampilkan tarian tradisional dengan kostum budaya.', 'Students performing traditional dances with cultural costumes.', '2026-06-07 20:29:31', '2026-06-07 20:29:31'),
(26, 'ib', 'Hari Kemerdekaan', 'Independence Day Celebration', 'Perayaan kemerdekaan dengan lomba dan pawai anak.', 'Independence day celebration with games and kids parade.', '2026-06-07 20:32:30', '2026-06-07 20:32:30'),
(27, 'early_years', 'Kunjungan Kebun Binatang', 'Zoo Field Trip', 'Kegiatan belajar sambil mengenal hewan di lingkungan terbuka.', 'Field trip activities to learn about animals in the zoo.', '2026-06-07 20:34:34', '2026-06-07 20:34:34'),
(28, 'early_years', 'Hari Kemerdekaan', 'Independence Day Celebration', 'Perayaan kemerdekaan dengan lomba dan pawai anak.', 'Independence day celebration with games and kids parade.', '2026-06-07 20:48:55', '2026-06-07 20:48:55'),
(29, 'early_years', 'Lomba Mewarnai', 'Coloring Competition', 'Mengembangkan kreativitas anak melalui lomba mewarnai.', 'Developing children\'s creativity through a coloring competition.', '2026-06-07 20:52:27', '2026-06-07 20:52:27'),
(30, 'early_years', 'Hari Profesi', 'Career Day', 'Anak-anak berpakaian sesuai cita-cita masa depan mereka.', 'Children dressed up according to their future career dreams.', '2026-06-07 20:53:35', '2026-06-07 20:53:35'),
(31, 'early_years', 'Memasak Bersama', 'Cooking Together', 'Belajar dasar memasak makanan sehat sederhana bersama guru.', 'Learning the basics of cooking simple healthy food with teachers.', '2026-06-07 20:55:09', '2026-06-07 20:55:09'),
(32, 'early_years', 'Olahraga Ceria', 'Fun Sports Day', 'Aktivitas fisik untuk melatih ketangkasan dan kerjasama tim.', 'Physical activities to train agility and team collaboration.', '2026-06-07 20:57:05', '2026-06-07 20:57:05'),
(33, 'early_years', 'Bercerita di Perpustakaan', 'Storytelling at Library', 'Sesi mendengarkan cerita untuk meningkatkan minat baca.', 'Storytelling session to increase interest in reading.', '2026-06-07 20:58:10', '2026-06-07 20:58:10'),
(34, 'early_years', 'Pertunjukan Seni Nusantara', 'Nusantara Art Performance', 'Siswa menampilkan tarian tradisional dengan kostum budaya.', 'Students performing traditional dances with cultural costumes.', '2026-06-07 21:10:51', '2026-06-07 21:10:51');

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

--
-- Table structure for table `activity_images`
--

CREATE TABLE `activity_images` (
  `id` bigint UNSIGNED NOT NULL,
  `activity_id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_images`
--

INSERT INTO `activity_images` (`id`, `activity_id`, `image`, `created_at`, `updated_at`) VALUES
(1, 1, 'activities/01KT8DWGKVW0H1Y4J79FZCNS05.jpg', '2026-06-03 21:22:25', '2026-06-03 21:22:25'),
(2, 1, 'activities/01KT8DWGMFZWPCFCCPFR77CQSH.jpg', '2026-06-03 21:22:25', '2026-06-03 21:22:25'),
(3, 1, 'activities/01KT8DWGMJGAQFVQAZ2ZR8GZFA.jpg', '2026-06-03 21:22:25', '2026-06-03 21:22:25'),
(4, 2, 'activities/01KT8E0WTBZYYJTX63DD2YTNHK.jpg', '2026-06-03 21:24:49', '2026-06-03 21:24:49'),
(5, 2, 'activities/01KT8E0WTGMM54MSEQ3ZNK6MRQ.jpg', '2026-06-03 21:24:49', '2026-06-03 21:24:49'),
(6, 2, 'activities/01KT8E0WTQ6SD7ZMQX6CMHXJ99.jpg', '2026-06-03 21:24:49', '2026-06-03 21:24:49'),
(7, 2, 'activities/01KT8E0WTS9MYY5PQSHNJ421A8.jpg', '2026-06-03 21:24:49', '2026-06-03 21:24:49'),
(8, 3, 'activities/01KT8T1RVM93FXAAJ59KYPNKSA.jpg', '2026-06-04 00:55:00', '2026-06-04 00:55:00'),
(9, 3, 'activities/01KT8T1RWR5GWXBD13JY4WPB9S.jpg', '2026-06-04 00:55:00', '2026-06-04 00:55:00'),
(10, 4, 'activities/01KT8T39ZBBET2CT7JZFABJ6GQ.jpg', '2026-06-04 00:55:51', '2026-06-04 00:55:51'),
(11, 4, 'activities/01KT8T39ZF892WJ481B8KC9BYG.jpg', '2026-06-04 00:55:51', '2026-06-04 00:55:51'),
(12, 5, 'activities/01KT8T5568RPF261YA30K06509.jpg', '2026-06-04 00:56:51', '2026-06-04 00:56:51'),
(13, 5, 'activities/01KT8T556DHSFC840JJMD34GET.jpg', '2026-06-04 00:56:51', '2026-06-04 00:56:51'),
(14, 5, 'activities/01KT8T556F7YNP1C3R4S0ND7G8.jpg', '2026-06-04 00:56:51', '2026-06-04 00:56:51'),
(15, 6, 'activities/01KT8T713XX86SGWVFKATFJDX0.jpg', '2026-06-04 00:57:53', '2026-06-04 00:57:53'),
(16, 6, 'activities/01KT8T7156DGZDBST6WHQ73NVT.jpg', '2026-06-04 00:57:53', '2026-06-04 00:57:53'),
(17, 7, 'activities/01KT8T9DSSNAJ7M5QJKG9ERZ58.jpg', '2026-06-04 00:59:11', '2026-06-04 00:59:11'),
(18, 7, 'activities/01KT8T9DT4C3QD5W5WNQS6VZC0.jpg', '2026-06-04 00:59:11', '2026-06-04 00:59:11'),
(19, 8, 'activities/01KT8TAWSN6JD5QSR0WK1100AF.jpg', '2026-06-04 00:59:59', '2026-06-04 00:59:59'),
(20, 8, 'activities/01KT8TAWT1T2RSW0WS9SXN35SR.jpg', '2026-06-04 00:59:59', '2026-06-04 00:59:59'),
(21, 9, 'activities/01KT8WZF89V1FJNV07TMX6MDXT.jpg', '2026-06-04 01:46:11', '2026-06-04 01:46:11'),
(22, 9, 'activities/01KT8WZF8FR3SQ32MTM7XET3Y6.jpg', '2026-06-04 01:46:11', '2026-06-04 01:46:11'),
(23, 10, 'activities/01KT8X2GYP97T67JVQ0R457NFQ.jpg', '2026-06-04 01:47:51', '2026-06-04 01:47:51'),
(24, 10, 'activities/01KT8X2GYT4PMWAX9S3D81GM27.jpg', '2026-06-04 01:47:51', '2026-06-04 01:47:51'),
(25, 11, 'activities/01KT8X52RV9V3Z796NSEJS2C9K.jpg', '2026-06-04 01:49:15', '2026-06-04 01:49:15'),
(26, 11, 'activities/01KT8X52RZVCXYFM0PV1ZDGKM2.jpg', '2026-06-04 01:49:15', '2026-06-04 01:49:15'),
(27, 11, 'activities/01KT8X52S29MK3MSYZNDH7YN8H.jpg', '2026-06-04 01:49:15', '2026-06-04 01:49:15'),
(28, 12, 'activities/01KT8X730PJ04J6QGENTKBNWQG.jpg', '2026-06-04 01:50:20', '2026-06-04 01:50:20'),
(29, 12, 'activities/01KT8X730V9PKK9TMHHQQCNDF5.jpg', '2026-06-04 01:50:20', '2026-06-04 01:50:20'),
(30, 13, 'activities/01KT8X93WHG6JBEBKBBD0YFSHB.jpg', '2026-06-04 01:51:27', '2026-06-04 01:51:27'),
(31, 13, 'activities/01KT8X93WNVB6RD6ZBZ8Z0SYB1.jpg', '2026-06-04 01:51:27', '2026-06-04 01:51:27'),
(32, 14, 'activities/01KT8XBH8ZVGDPAY6YQ5GKDQ2Y.jpg', '2026-06-04 01:52:46', '2026-06-04 01:52:46'),
(33, 14, 'activities/01KT8XBH92GYPX9K36JG6BQW20.jpg', '2026-06-04 01:52:46', '2026-06-04 01:52:46'),
(34, 15, 'activities/01KT8XDG0C8BRBTKHVJ863QSD4.jpg', '2026-06-04 01:53:50', '2026-06-04 01:53:50'),
(35, 15, 'activities/01KT8XDG0GXKRBMDZRNJFAGQST.jpg', '2026-06-04 01:53:50', '2026-06-04 01:53:50'),
(36, 16, 'activities/01KT8XF61MBXMD6XCZSENFX2S6.jpg', '2026-06-04 01:54:46', '2026-06-04 01:54:46'),
(37, 16, 'activities/01KT8XF61R93650EVRK5M3JBZV.jpg', '2026-06-04 01:54:46', '2026-06-04 01:54:46'),
(38, 17, 'activities/01KTJJBPWRS1RX7YD2A9QPWXXS.jpg', '2026-06-07 19:53:02', '2026-06-07 19:53:02'),
(39, 18, 'activities/01KTJJPRS4JSNVCEH6VGX9P94G.jpg', '2026-06-07 19:59:04', '2026-06-07 19:59:04'),
(40, 19, 'activities/01KTJK20MY4X502A2C8WHHGN0Q.jpg', '2026-06-07 20:05:13', '2026-06-07 20:05:13'),
(41, 20, 'activities/01KTJK4H0BDPJMQE0XH9WEXQ6E.jpg', '2026-06-07 20:06:35', '2026-06-07 20:06:35'),
(42, 21, 'activities/01KTJK6T794GCF5YZT84MY8BFY.jpg', '2026-06-07 20:07:50', '2026-06-07 20:07:50'),
(43, 22, 'activities/01KTJKE038E4A8JZ0KPYV55B0A.jpg', '2026-06-07 20:11:45', '2026-06-07 20:11:45'),
(44, 23, 'activities/01KTJMA4JA0D86P3YTZC37G5QQ.jpg', '2026-06-07 20:27:07', '2026-06-07 20:27:07'),
(45, 24, 'activities/01KTJMCSJGT89CAYV0RYG8DYA7.jpg', '2026-06-07 20:28:34', '2026-06-07 20:28:34'),
(46, 25, 'activities/01KTJMEH7BPG5J8J79ZSSNPV21.jpg', '2026-06-07 20:29:31', '2026-06-07 20:29:31'),
(47, 26, 'activities/01KTJMKZTS976V4HQ17QD3ZKQT.jpg', '2026-06-07 20:32:30', '2026-06-07 20:32:30'),
(48, 27, 'activities/01KTJMQRPNMNEFSKHFX051Y4AD.jpg', '2026-06-07 20:34:34', '2026-06-07 20:34:34'),
(49, 28, 'activities/01KTJNJ1V2XZF32DRBGMCMKGKW.jpg', '2026-06-07 20:48:55', '2026-06-07 20:48:55'),
(50, 29, 'activities/01KTJNRGHZAZFJ6Z123GNGBQ4Q.jpg', '2026-06-07 20:52:27', '2026-06-07 20:52:27'),
(51, 30, 'activities/01KTJNTK74CCCQTMN6QN8Z7DSA.jpg', '2026-06-07 20:53:35', '2026-06-07 20:53:35'),
(52, 31, 'activities/01KTJNXF5ATRSWJSTK3EV6SX6Z.jpg', '2026-06-07 20:55:09', '2026-06-07 20:55:09'),
(53, 32, 'activities/01KTJP0ZQP8WN8T3BSBSVQXX19.jpg', '2026-06-07 20:57:05', '2026-06-07 20:57:05'),
(54, 33, 'activities/01KTJP2ZVB5NVYBN5RPN104FMS.jpg', '2026-06-07 20:58:10', '2026-06-07 20:58:10'),
(55, 34, 'activities/01KTJPT6Y4A0JCEZ4PQS4AXDY8.jpg', '2026-06-07 21:10:51', '2026-06-07 21:10:51');

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` bigint UNSIGNED NOT NULL,
  `parents_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kids_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `school` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kategori` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subkeluhan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subkeluhan_lainnya` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pesan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','responded') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_messages`
--

INSERT INTO `contact_messages` (`id`, `parents_name`, `kids_name`, `phone_number`, `email`, `school`, `grade`, `kategori`, `subkeluhan`, `subkeluhan_lainnya`, `pesan`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ani', 'Yufi', '082128254262', 'yufi@gmail.com', 'PYP (EL)', 'Kelas 6.2', 'Pertanyaan', NULL, NULL, 'kjasdlamdakjds,m', 'responded', '2026-05-29 20:18:17', '2026-06-05 19:39:24');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint UNSIGNED NOT NULL,
  `category` enum('general','ib','iis') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_id` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_en` longtext COLLATE utf8mb4_unicode_ci,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail_alt_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail_alt_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `category`, `title_id`, `title_en`, `slug_id`, `slug_en`, `location_id`, `location_en`, `content_id`, `content_en`, `start_date`, `end_date`, `thumbnail`, `thumbnail_alt_id`, `thumbnail_alt_en`, `registration_link`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'general', 'Open House dan Expo Pendidikan 2026', 'Open House and Education Expo 2026', 'open-house-dan-expo-pendidikan-2026', 'open-house-and-education-expo-2026', 'Aula Utama SMK Penerbangan Indonesia', 'Indonesia Aviation School Main Hall', '<p><strong><em>SMK Penerbangan Indonesia</em></strong> menyelenggarakan kegiatan Open House dan Expo Pendidikan yang terbuka untuk siswa SMP, orang tua, dan masyarakat umum.<br><br>Peserta dapat mengenal lebih dekat berbagai program pendidikan yang tersedia, melihat fasilitas sekolah, serta berdiskusi langsung dengan guru dan siswa aktif mengenai pengalaman belajar di sekolah.</p><blockquote><p>mlkmdlfls</p></blockquote><p><br>Selain pameran pendidikan, kegiatan ini juga menghadirkan berbagai seminar singkat, demonstrasi praktik siswa, dan sesi konsultasi karier untuk membantu peserta menentukan jalur pendidikan yang sesuai.</p>', '<p><strong><em>Indonesia Aviation School</em></strong> is organizing an Open House and Education Expo for junior high school students, parents, and the general public.<br><br>Visitors will have the opportunity to explore school facilities, learn about academic programs, and interact directly with teachers and students.<br></p><blockquote><p>ksmdlksmf</p></blockquote><p><br>The event will also feature educational seminars, student demonstrations, and career consultation sessions.</p>', '2026-07-15 00:00:00', '2026-07-15 00:00:00', 'event-thumbnails/01KT5VD0CV3APFS9HKD0AM4AM4.jpg', 'Kegiatan Open House dan Expo Pendidikan', 'Open House and Education Expo event', 'https://example.com/events/open-house-2026', 0, '2026-06-02 21:20:54', '2026-06-05 19:37:06');

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

--
-- Table structure for table `extracurriculars`
--

CREATE TABLE `extracurriculars` (
  `id` bigint UNSIGNED NOT NULL,
  `program` enum('ib','iis') COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `extracurriculars`
--

INSERT INTO `extracurriculars` (`id`, `program`, `title_id`, `title_en`, `created_at`, `updated_at`) VALUES
(1, 'iis', 'Basket', 'Basketball', '2026-05-24 19:26:13', '2026-05-24 19:26:13'),
(2, 'iis', 'Futsal', 'Futsal', '2026-05-24 19:27:04', '2026-05-24 19:27:04'),
(3, 'iis', 'Memanah', 'Archery', '2026-05-24 19:32:13', '2026-05-24 19:32:13'),
(4, 'iis', 'Sains Club', 'Science Club', '2026-05-24 19:33:16', '2026-05-24 19:33:16'),
(5, 'iis', 'Mini Soccer', 'Mini Soccer', '2026-05-24 19:34:22', '2026-05-24 19:34:22'),
(6, 'iis', 'Bulu Tangkis', 'Badminton', '2026-05-24 19:35:12', '2026-05-24 19:35:12'),
(7, 'iis', 'Pramuka', 'Scout', '2026-05-24 19:36:04', '2026-05-24 19:36:04'),
(8, 'iis', 'PMR', 'Red Cross Youth', '2026-05-24 19:36:51', '2026-05-24 19:36:51'),
(9, 'iis', 'Tari Kreasi', 'Creative Dance', '2026-05-24 19:37:47', '2026-05-24 19:37:47'),
(10, 'iis', 'Taekwondo', 'Taekwondo', '2026-05-24 19:42:34', '2026-05-24 19:42:34'),
(11, 'ib', 'Futsal', 'Futsal', '2026-05-24 19:43:56', '2026-05-24 19:43:56'),
(12, 'ib', 'Bulu Tangkis', 'Badminton', '2026-05-24 19:44:27', '2026-05-24 19:44:27'),
(13, 'ib', 'Musik', 'Music', '2026-05-24 19:44:54', '2026-05-24 19:44:54'),
(14, 'ib', 'Design Club', 'Design Club', '2026-05-24 19:46:17', '2026-05-24 19:46:17'),
(15, 'ib', 'English Club', 'English Club', '2026-05-24 19:46:44', '2026-05-24 19:46:44'),
(16, 'ib', 'Youth Scientific Paper', 'Youth Scientific Paper', '2026-05-24 19:50:48', '2026-05-24 19:50:48'),
(17, 'ib', 'Pramuka', 'Scout', '2026-05-24 19:51:20', '2026-05-24 19:51:20');

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

--
-- Table structure for table `extracurricular_images`
--

CREATE TABLE `extracurricular_images` (
  `id` bigint UNSIGNED NOT NULL,
  `extracurricular_id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `extracurricular_images`
--

INSERT INTO `extracurricular_images` (`id`, `extracurricular_id`, `image`, `created_at`, `updated_at`) VALUES
(1, 1, 'extracurriculars/01KSEF8J99N80QJAY9WFRS5APY.jpg', '2026-05-24 19:26:13', '2026-05-24 19:26:13'),
(2, 2, 'extracurriculars/01KSEFA41D70ZHR1ZNVQ4N4EYG.jpg', '2026-05-24 19:27:04', '2026-05-24 19:27:04'),
(3, 3, 'extracurriculars/01KSEFKHBP5ER745JZ09XDZ94A.jpg', '2026-05-24 19:32:13', '2026-05-24 19:32:13'),
(4, 4, 'extracurriculars/01KSEFNF2RZRW0NMPHNH9CCHTA.jpg', '2026-05-24 19:33:16', '2026-05-24 19:33:16'),
(5, 5, 'extracurriculars/01KSEFQF2PVNMSKPBTEMA6GH83.jpg', '2026-05-24 19:34:22', '2026-05-24 19:34:22'),
(6, 6, 'extracurriculars/01KSEFS0KJTEN40BT7RZNFT8WJ.jpg', '2026-05-24 19:35:12', '2026-05-24 19:35:12'),
(7, 7, 'extracurriculars/01KSEFTK7RW42JGYVVHH1D5VD1.jpg', '2026-05-24 19:36:04', '2026-05-24 19:36:04'),
(8, 8, 'extracurriculars/01KSEFW0HTT069N1KY70B22X14.jpg', '2026-05-24 19:36:51', '2026-05-24 19:36:51'),
(9, 9, 'extracurriculars/01KSEFXQ6AW1952BV77DRWPB8H.jpeg', '2026-05-24 19:37:47', '2026-05-24 19:37:47'),
(10, 10, 'extracurriculars/01KSEG6FDHHG5BS1GM7T673WP2.jpg', '2026-05-24 19:42:34', '2026-05-24 19:42:34'),
(11, 11, 'extracurriculars/01KSEG909Q89VN40DK605J2AB6.jpg', '2026-05-24 19:43:56', '2026-05-24 19:43:56'),
(12, 12, 'extracurriculars/01KSEG9XRWDQR4BX1MTQNY3EB8.jpg', '2026-05-24 19:44:27', '2026-05-24 19:44:27'),
(13, 13, 'extracurriculars/01KSEGAR74V0EVC3JMZSHRH2M0.jpg', '2026-05-24 19:44:54', '2026-05-24 19:44:54'),
(14, 14, 'extracurriculars/01KSEGD9617EDC4E1FKSN24BJH.jpg', '2026-05-24 19:46:17', '2026-05-24 19:46:17'),
(15, 15, 'extracurriculars/01KSEGE3JGK0NNTCHC768ZVJEB.jpg', '2026-05-24 19:46:44', '2026-05-24 19:46:44'),
(16, 16, 'extracurriculars/01KSEGNJQ1Q187Y64JG6RKTK71.jpg', '2026-05-24 19:50:48', '2026-05-24 19:50:48'),
(17, 17, 'extracurriculars/01KSEGPHM0N66Q9REF1CNMAYAQ.jpg', '2026-05-24 19:51:20', '2026-05-24 19:51:20');

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

--
-- Table structure for table `facilities`
--

CREATE TABLE `facilities` (
  `id` bigint UNSIGNED NOT NULL,
  `program` enum('ib','iis') COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `facilities`
--

INSERT INTO `facilities` (`id`, `program`, `title_id`, `title_en`, `created_at`, `updated_at`) VALUES
(1, 'ib', 'kantin', 'Cafetaria', '2026-05-24 19:00:55', '2026-05-24 19:00:55'),
(2, 'ib', 'Lab. Fisika', 'Physics Laboratory', '2026-05-24 19:04:11', '2026-05-24 19:04:11'),
(3, 'ib', 'Lab. Biokimia', 'Biochemistry Laboratory', '2026-05-24 19:05:27', '2026-05-24 19:05:27'),
(4, 'ib', 'Lab. Komputer', 'Computer Laboratory', '2026-05-24 19:06:33', '2026-05-24 19:06:33'),
(5, 'ib', 'Perpustakaan PYP', 'PYP Library', '2026-05-24 19:08:36', '2026-05-24 19:08:36'),
(6, 'ib', 'Perpustakaan MYP & HS', 'MYP & High School Library', '2026-05-24 19:09:29', '2026-05-24 19:09:29'),
(7, 'ib', 'Tempat Bermain Anak TK', 'Kindergarten Playground', '2026-05-24 19:12:39', '2026-05-24 19:12:39'),
(8, 'iis', 'Kantin', 'Canteen', '2026-05-24 19:14:28', '2026-05-24 19:14:28'),
(9, 'iis', 'Lab. Fisika', 'Physics Laboratory', '2026-05-24 19:15:45', '2026-05-24 19:15:45'),
(10, 'iis', 'Perpustakaan', 'Library', '2026-05-24 19:19:13', '2026-05-24 19:19:13');

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

--
-- Table structure for table `facility_images`
--

CREATE TABLE `facility_images` (
  `id` bigint UNSIGNED NOT NULL,
  `facility_id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `facility_images`
--

INSERT INTO `facility_images` (`id`, `facility_id`, `image`, `created_at`, `updated_at`) VALUES
(1, 1, 'facilities/01KSEDT7R629JDPQZSWVKTG46Y.jpg', '2026-05-24 19:00:55', '2026-05-24 19:00:55'),
(2, 1, 'facilities/01KSEDT7RYTVZ4R7J75H32F29W.jpg', '2026-05-24 19:00:55', '2026-05-24 19:00:55'),
(3, 2, 'facilities/01KSEE076PPJSR6DDVVP440DSX.jpg', '2026-05-24 19:04:11', '2026-05-24 19:04:11'),
(4, 3, 'facilities/01KSEE2HB44TR2NDBWQWG9A47Z.jpg', '2026-05-24 19:05:27', '2026-05-24 19:05:27'),
(5, 4, 'facilities/01KSEE4HY9RHRS72BHHPVXAR91.jpg', '2026-05-24 19:06:33', '2026-05-24 19:06:33'),
(6, 5, 'facilities/01KSEE89D4Y8CS75BZYN9BSJGA.jpg', '2026-05-24 19:08:36', '2026-05-24 19:08:36'),
(7, 5, 'facilities/01KSEE89D963JDG1499ZD7CWP8.jpg', '2026-05-24 19:08:36', '2026-05-24 19:08:36'),
(8, 6, 'facilities/01KSEE9X1FAJQ8X9M2D5206H2Y.jpg', '2026-05-24 19:09:29', '2026-05-24 19:09:29'),
(9, 7, 'facilities/01KSEEFPPE69K87X2GMYTEXSRY.jpg', '2026-05-24 19:12:39', '2026-05-24 19:12:39'),
(10, 7, 'facilities/01KSEEFPPJEQ58CMD5TWSD2QDT.jpg', '2026-05-24 19:12:39', '2026-05-24 19:12:39'),
(11, 7, 'facilities/01KSEEFPPNB4N4V5AP5DMK92XK.jpg', '2026-05-24 19:12:39', '2026-05-24 19:12:39'),
(12, 7, 'facilities/01KSEEFPPQS5J0B56NK6RHSQXE.jpg', '2026-05-24 19:12:39', '2026-05-24 19:12:39'),
(13, 8, 'facilities/01KSEEK1RXX334RNVZT2C42XRN.jpg', '2026-05-24 19:14:28', '2026-05-24 19:14:28'),
(14, 8, 'facilities/01KSEEK1S1EZMABZTG2YBSSKM4.jpg', '2026-05-24 19:14:28', '2026-05-24 19:14:28'),
(15, 9, 'facilities/01KSEENC867MY8JGQHSRJ26093.jpg', '2026-05-24 19:15:45', '2026-05-24 19:15:45'),
(16, 9, 'facilities/01KSEENC8H7SX4EXZC7J9ZJV3W.jpg', '2026-05-24 19:15:45', '2026-05-24 19:15:45'),
(17, 9, 'facilities/01KSEENC8K10FT1DD8WNHYACQX.jpg', '2026-05-24 19:15:45', '2026-05-24 19:15:45'),
(18, 10, 'facilities/01KSEEVR0Y0ED0H1N61FB7ZQE7.jpg', '2026-05-24 19:19:13', '2026-05-24 19:19:13'),
(19, 10, 'facilities/01KSEEVR11T5Z1A418RKY369AH.jpg', '2026-05-24 19:19:13', '2026-05-24 19:19:13'),
(20, 10, 'facilities/01KSEEVR14Q1MCYJKKRQ18FRVM.jpg', '2026-05-24 19:19:13', '2026-05-24 19:19:13');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_04_14_015925_create_facilities_table', 1),
(5, '2026_04_14_021801_create_activities_table', 1),
(6, '2026_04_14_021817_create_achievements_table', 1),
(7, '2026_04_14_021826_create_extracurriculars_table', 1),
(8, '2026_04_14_030624_create_contact_messages_table', 1),
(9, '2026_04_14_030637_create_spmb_applications_table', 1),
(10, '2026_04_14_074126_create_facility_images_table', 1),
(11, '2026_04_16_012549_create_extracurricular_images_table', 1),
(12, '2026_04_16_020102_create_activity_images_table', 1),
(13, '2026_04_17_070651_create_testimonials_table', 1),
(14, '2026_04_21_021145_create_news_table', 1),
(15, '2026_04_21_021152_create_events_table', 1),
(16, '2026_05_11_015823_create_spmb_targets_table', 1),
(17, '2026_05_12_060847_create_permission_tables', 1),
(18, '2026_05_13_040201_create_notifications_table', 1),
(19, '2026_06_03_080956_add_published_at_to_news_table', 2),
(20, '2026_06_08_014412_alter_program_enum_on_activities_table', 3);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1);

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint UNSIGNED NOT NULL,
  `category` enum('general','ib','iis') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `summary_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `summary_en` text COLLATE utf8mb4_unicode_ci,
  `content_id` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_en` longtext COLLATE utf8mb4_unicode_ci,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail_alt_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail_alt_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description_id` text COLLATE utf8mb4_unicode_ci,
  `meta_description_en` text COLLATE utf8mb4_unicode_ci,
  `view_count` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `category`, `title_id`, `title_en`, `slug_id`, `slug_en`, `summary_id`, `summary_en`, `content_id`, `content_en`, `thumbnail`, `thumbnail_alt_id`, `thumbnail_alt_en`, `meta_title_id`, `meta_title_en`, `meta_description_id`, `meta_description_en`, `view_count`, `created_at`, `published_at`, `updated_at`) VALUES
(1, 'general', 'SMK Penerbangan Indonesia Gelar Seminar Karier Bersama Industri Nasional', 'Indonesia Aviation Vocational School Holds Career Seminar with National Industry Partners', 'seminar-karier-bersama-industri-nasional', 'career-seminar-with-national-industry-partners', 'Seminar karier menghadirkan berbagai perusahaan nasional untuk memberikan wawasan dunia kerja kepada siswa.', 'Career seminar featuring national companies to provide students with insights into today\'s job market.', '<p>SMK Penerbangan Indonesia sukses menyelenggarakan Seminar Karier yang menghadirkan berbagai perusahaan nasional dari sektor teknologi, manufaktur, dan transportasi. Kegiatan ini bertujuan memberikan wawasan kepada siswa mengenai kebutuhan dunia kerja yang terus berkembang.<br><br>Dalam kegiatan tersebut, para narasumber membagikan pengalaman profesional serta tips menghadapi proses rekrutmen modern. Siswa juga mendapatkan kesempatan untuk berdiskusi langsung dengan praktisi industri.<br><br>Melalui kegiatan ini, sekolah berharap lulusan memiliki kesiapan yang lebih baik dalam memasuki dunia kerja maupun melanjutkan pendidikan ke jenjang yang lebih tinggi.</p>', '<p>Indonesia Aviation Vocational School successfully organized a Career Seminar attended by representatives from various national companies in technology, manufacturing, and transportation sectors.<br><br>The speakers shared professional experiences and practical recruitment tips. Students were also given opportunities to engage directly with industry practitioners.<br><br>The school expects this initiative to better prepare graduates for both higher education and future careers.</p>', 'news-thumbnails/01KT5KFJSB5F8VRCBWZ6D0NTE4.jpg', 'Seminar karier siswa bersama praktisi industri', 'Student career seminar with industry professionals', 'Seminar Karier Bersama Industri Nasional | SMK Penerbangan Indonesia', 'Career Seminar with National Industry Partners | Indonesia Aviation School', 'Seminar karier yang menghadirkan perusahaan nasional untuk mempersiapkan siswa menghadapi dunia kerja modern.', 'Career seminar featuring national companies to help students prepare for modern professional careers.', 0, '2026-06-02 19:02:30', '2026-05-31 17:00:00', '2026-06-03 01:16:48'),
(2, 'ib', 'Program IB Kunjungi Hanggar Perawatan Pesawat Komersial', 'IB Program Visits Commercial Aircraft Maintenance Hangar', 'program-ib-kunjungi-hanggar-perawatan-pesawat', 'ib-program-visits-aircraft-maintenance-hangar', 'Kunjungan industri siswa IB ke hanggar pesawat untuk mempelajari proses maintenance secara langsung.', 'IB students visit an aircraft maintenance hangar to gain practical industry experience.', '<p>Siswa Program IB mengikuti kunjungan industri ke salah satu hanggar perawatan pesawat komersial terbesar di Indonesia. Kegiatan ini bertujuan memberikan pemahaman langsung mengenai proses maintenance pesawat yang dilakukan oleh tenaga profesional.<br><br>Selama kunjungan, siswa diperkenalkan pada berbagai komponen pesawat, prosedur keselamatan kerja, serta standar operasional yang diterapkan dalam industri penerbangan.<br><br>Pengalaman ini memberikan wawasan praktis yang melengkapi pembelajaran teori di kelas sehingga siswa lebih siap menghadapi dunia industri penerbangan.</p>', '<p>IB students participated in an industrial visit to one of Indonesia&#039;s largest commercial aircraft maintenance hangars.<br><br>During the visit, students learned about aircraft components, workplace safety procedures, and operational standards used in the aviation industry.<br><br>The experience provided valuable practical knowledge that complements classroom learning.</p>', 'news-thumbnails/01KT5T4CBNC304P1M19BXXKQWH.jpg', 'Siswa IB mengunjungi hanggar perawatan pesawat', 'IB students visiting an aircraft maintenance hangar', 'Kunjungan Industri IB ke Hanggar Pesawat', 'IB Industrial Visit to Aircraft Maintenance Hangar', 'Siswa Program IB mempelajari proses perawatan pesawat melalui kunjungan industri langsung ke hanggar penerbangan.', 'IB students explore aircraft maintenance operations through an industry visit to a commercial hangar.', 0, '2026-06-02 20:58:43', '2026-05-10 17:00:00', '2026-06-03 01:17:07'),
(3, 'iis', 'Program IIS Selenggarakan Workshop Digital Marketing dan Bisnis Modern', 'IIS Program Hosts Digital Marketing and Modern Business Workshop', 'workshop-digital-marketing-dan-bisnis-modern', 'digital-marketing-and-modern-business-workshop', 'Workshop Digital Marketing memberikan pemahaman mengenai strategi pemasaran modern dan bisnis digital.', 'Digital Marketing Workshop introduces students to modern marketing strategies and digital business practices.', '<p>Program IIS mengadakan workshop Digital Marketing yang diikuti oleh seluruh siswa tingkat akhir. Kegiatan ini menghadirkan praktisi pemasaran digital yang berpengalaman dalam mengelola berbagai kampanye bisnis online.<br><br>Peserta mempelajari strategi pemasaran melalui media sosial, optimasi konten digital, serta analisis perilaku konsumen menggunakan berbagai platform modern.<br><br>Melalui workshop ini, siswa diharapkan mampu memahami tren bisnis digital dan memiliki keterampilan yang relevan dengan kebutuhan industri saat ini.</p>', '<p>The <strong>IIS Program</strong> organized a Digital Marketing Workshop attended by final-year students.<br><br>Participants learned social media marketing strategies, content optimization techniques, and consumer behavior analysis using modern digital platforms.<br><br>This workshop aims to equip students with skills relevant to today&#039;s digital business environment.</p>', 'news-thumbnails/01KT5V14PXQS2WYAHWMP0TRKQ8.jpg', 'Workshop digital marketing untuk siswa IIS', 'Digital marketing workshop for IIS students', 'Workshop Digital Marketing IIS', 'IIS Digital Marketing Workshop', 'Program IIS mengadakan workshop digital marketing untuk meningkatkan kompetensi siswa dalam dunia bisnis modern.', 'The IIS Program hosts a digital marketing workshop to strengthen students\' business and marketing skills.', 0, '2026-06-02 21:14:25', '2026-05-12 17:00:00', '2026-06-03 01:17:24');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `images` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `images`, `created_at`, `updated_at`) VALUES
(5, '[\"notifications/01KS4NEE48WHKEAGAFWQAAJ43N.jpg\", \"notifications/01KS4KN2H73NZ2JCXS03YKG1KG.jpg\"]', '2026-05-20 23:30:33', '2026-06-05 19:41:55');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'superadmin', 'web', '2026-05-19 01:49:40', '2026-05-19 01:49:40'),
(2, 'cms_admin', 'web', '2026-05-19 01:49:40', '2026-05-19 01:49:40'),
(3, 'spmb_admin', 'web', '2026-05-19 01:49:40', '2026-05-19 01:49:40');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('8yexlGuMngFMF3hP84918Yb9htEOIKafJjUCNm5r', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTo4OntzOjY6Il90b2tlbiI7czo0MDoieVk1Z2RHaTF6Q29vNTR3NGZlYks1dElhaFRzS1FXbUlwVVBZNklyWiI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM4OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvYWRtaW4vYWN0aXZpdGllcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7czoxNzoicGFzc3dvcmRfaGFzaF93ZWIiO3M6NjA6IiQyeSQxMiQ5blVCMnpuT0FDVmFiSEREMUVKRFMuSTJXRktLd1pzWlhSR3MwYXk5cFFFWjB3UVdFMHFNdSI7czo2OiJ0YWJsZXMiO2E6Mjp7czo0MDoiY2VkN2Q0NGFlZTMwMDFmODZkYjU0OGU5ZWI4Nzg5NThfY29sdW1ucyI7YTo1OntpOjA7YTo3OntzOjQ6InR5cGUiO3M6NjoiY29sdW1uIjtzOjQ6Im5hbWUiO3M6NzoicHJvZ3JhbSI7czo1OiJsYWJlbCI7czo3OiJQcm9ncmFtIjtzOjg6ImlzSGlkZGVuIjtiOjA7czo5OiJpc1RvZ2dsZWQiO2I6MTtzOjEyOiJpc1RvZ2dsZWFibGUiO2I6MDtzOjI0OiJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiO047fWk6MTthOjc6e3M6NDoidHlwZSI7czo2OiJjb2x1bW4iO3M6NDoibmFtZSI7czo4OiJ0aXRsZV9pZCI7czo1OiJsYWJlbCI7czoxMDoiVGl0bGUgKElEKSI7czo4OiJpc0hpZGRlbiI7YjowO3M6OToiaXNUb2dnbGVkIjtiOjE7czoxMjoiaXNUb2dnbGVhYmxlIjtiOjA7czoyNDoiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjtOO31pOjI7YTo3OntzOjQ6InR5cGUiO3M6NjoiY29sdW1uIjtzOjQ6Im5hbWUiO3M6ODoidGl0bGVfZW4iO3M6NToibGFiZWwiO3M6MTA6IlRpdGxlIChFTikiO3M6ODoiaXNIaWRkZW4iO2I6MDtzOjk6ImlzVG9nZ2xlZCI7YjoxO3M6MTI6ImlzVG9nZ2xlYWJsZSI7YjowO3M6MjQ6ImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI7Tjt9aTozO2E6Nzp7czo0OiJ0eXBlIjtzOjY6ImNvbHVtbiI7czo0OiJuYW1lIjtzOjEyOiJpbWFnZXMuaW1hZ2UiO3M6NToibGFiZWwiO3M6NToiSW1hZ2UiO3M6ODoiaXNIaWRkZW4iO2I6MDtzOjk6ImlzVG9nZ2xlZCI7YjoxO3M6MTI6ImlzVG9nZ2xlYWJsZSI7YjowO3M6MjQ6ImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI7Tjt9aTo0O2E6Nzp7czo0OiJ0eXBlIjtzOjY6ImNvbHVtbiI7czo0OiJuYW1lIjtzOjEyOiJpbWFnZXNfY291bnQiO3M6NToibGFiZWwiO3M6MTI6IlRvdGFsIEltYWdlcyI7czo4OiJpc0hpZGRlbiI7YjowO3M6OToiaXNUb2dnbGVkIjtiOjE7czoxMjoiaXNUb2dnbGVhYmxlIjtiOjA7czoyNDoiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjtOO319czo0MDoiMzI3MDEzNTY5YWZkNjk3MDgyZTRmZjk0YzcyMmY2N2NfY29sdW1ucyI7YTo1OntpOjA7YTo3OntzOjQ6InR5cGUiO3M6NjoiY29sdW1uIjtzOjQ6Im5hbWUiO3M6NzoicHJvZ3JhbSI7czo1OiJsYWJlbCI7czo3OiJQcm9ncmFtIjtzOjg6ImlzSGlkZGVuIjtiOjA7czo5OiJpc1RvZ2dsZWQiO2I6MTtzOjEyOiJpc1RvZ2dsZWFibGUiO2I6MDtzOjI0OiJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiO047fWk6MTthOjc6e3M6NDoidHlwZSI7czo2OiJjb2x1bW4iO3M6NDoibmFtZSI7czo4OiJ0aXRsZV9pZCI7czo1OiJsYWJlbCI7czoxMDoiVGl0bGUgKElEKSI7czo4OiJpc0hpZGRlbiI7YjowO3M6OToiaXNUb2dnbGVkIjtiOjE7czoxMjoiaXNUb2dnbGVhYmxlIjtiOjA7czoyNDoiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjtOO31pOjI7YTo3OntzOjQ6InR5cGUiO3M6NjoiY29sdW1uIjtzOjQ6Im5hbWUiO3M6ODoidGl0bGVfZW4iO3M6NToibGFiZWwiO3M6MTA6IlRpdGxlIChFTikiO3M6ODoiaXNIaWRkZW4iO2I6MDtzOjk6ImlzVG9nZ2xlZCI7YjoxO3M6MTI6ImlzVG9nZ2xlYWJsZSI7YjowO3M6MjQ6ImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI7Tjt9aTozO2E6Nzp7czo0OiJ0eXBlIjtzOjY6ImNvbHVtbiI7czo0OiJuYW1lIjtzOjEyOiJpbWFnZXMuaW1hZ2UiO3M6NToibGFiZWwiO3M6NToiSW1hZ2UiO3M6ODoiaXNIaWRkZW4iO2I6MDtzOjk6ImlzVG9nZ2xlZCI7YjoxO3M6MTI6ImlzVG9nZ2xlYWJsZSI7YjowO3M6MjQ6ImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI7Tjt9aTo0O2E6Nzp7czo0OiJ0eXBlIjtzOjY6ImNvbHVtbiI7czo0OiJuYW1lIjtzOjEyOiJpbWFnZXNfY291bnQiO3M6NToibGFiZWwiO3M6MTI6IlRvdGFsIEltYWdlcyI7czo4OiJpc0hpZGRlbiI7YjowO3M6OToiaXNUb2dnbGVkIjtiOjE7czoxMjoiaXNUb2dnbGVhYmxlIjtiOjA7czoyNDoiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjtOO319fXM6ODoiZmlsYW1lbnQiO2E6MDp7fX0=', 1780891947);

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

--
-- Table structure for table `spmb_applications`
--

CREATE TABLE `spmb_applications` (
  `id` bigint UNSIGNED NOT NULL,
  `no_formulir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thn_ajaran` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `program` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenjang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_panggilan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `nisn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kewarganegaraan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `saudara` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci,
  `rt` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rw` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelurahan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kota` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provinsi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_pos` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telp_rumah` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jarak_sekolah` int DEFAULT NULL,
  `hp_ayah` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hp_ibu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_ortu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transportasi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sumber_info` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sehat_tinggi` int DEFAULT NULL,
  `sehat_berat` int DEFAULT NULL,
  `penyakit` json DEFAULT NULL,
  `penyakit_lainnya` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keb_khusus_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keb_khusus_ket` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kekhasan_fisik` text COLLATE utf8mb4_unicode_ci,
  `ayah_nama` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ayah_tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ayah_tanggal_lahir` date DEFAULT NULL,
  `ayah_pekerjaan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ayah_pendidikan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ayah_penghasilan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ayah_penghasilan_lainnya` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ibu_nama` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ibu_tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ibu_tanggal_lahir` date DEFAULT NULL,
  `ibu_pekerjaan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ibu_pendidikan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ibu_penghasilan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ibu_penghasilan_lainnya` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sekolah_asal_jenis` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sekolah_asal_nama` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sekolah_asal_alamat` text COLLATE utf8mb4_unicode_ci,
  `sekolah_asal_desa` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sekolah_asal_kecamatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sekolah_asal_kota` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sekolah_asal_provinsi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `saudara_kandung` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `spmb_applications`
--

INSERT INTO `spmb_applications` (`id`, `no_formulir`, `thn_ajaran`, `program`, `jenjang`, `nama_lengkap`, `nama_panggilan`, `jk`, `tempat_lahir`, `tanggal_lahir`, `nisn`, `nik`, `kewarganegaraan`, `saudara`, `alamat`, `rt`, `rw`, `kelurahan`, `kecamatan`, `kota`, `provinsi`, `kode_pos`, `telp_rumah`, `jarak_sekolah`, `hp_ayah`, `hp_ibu`, `email_ortu`, `transportasi`, `sumber_info`, `sehat_tinggi`, `sehat_berat`, `penyakit`, `penyakit_lainnya`, `keb_khusus_status`, `keb_khusus_ket`, `kekhasan_fisik`, `ayah_nama`, `ayah_tempat_lahir`, `ayah_tanggal_lahir`, `ayah_pekerjaan`, `ayah_pendidikan`, `ayah_penghasilan`, `ayah_penghasilan_lainnya`, `ibu_nama`, `ibu_tempat_lahir`, `ibu_tanggal_lahir`, `ibu_pekerjaan`, `ibu_pendidikan`, `ibu_penghasilan`, `ibu_penghasilan_lainnya`, `sekolah_asal_jenis`, `sekolah_asal_nama`, `sekolah_asal_alamat`, `sekolah_asal_desa`, `sekolah_asal_kecamatan`, `sekolah_asal_kota`, `sekolah_asal_provinsi`, `saudara_kandung`, `created_at`, `updated_at`) VALUES
(1, 'SPMB_001', '2026/2027', 'National School', 'SMA PLUS ISLAMIC VILLAGE', 'Yufi Fahreza', 'Yufi', 'laki-laki', 'Ciamis', '2000-07-27', '678768768921', '32456786578878787', 'WNI', 'Anak ke 3', 'Jl. Gatot Subroto, RT.002/RW.001, Alam Jaya, Kec. Jatiuwung', '02', '02', 'Kadu', 'Curug', 'Kab. Tangerang', 'Banten', '15810', '082128254262', 2, '082687988798', '082687986789', 'yufi@gmail.com', 'Jemputan Sekolah', 'Instagram', 167, 56, '{\"dbd\": false, \"tbc\": false, \"cacar\": false, \"liver\": false}', NULL, 'tidak', NULL, 'Pake kacamata', 'Eddy', 'Jakarta', '2026-05-03', 'Karyawan Swasta', 'SMA', '>6 Jt', NULL, 'Ani', 'Ciamis', '2026-05-10', 'Ibu RT', 'SMA', '4 - 6 Jt', NULL, 'SMP', 'SMP N 2 Cisaga', 'Noong Cisaga', 'Desa Noong', 'Cisaga', 'Ciamis', 'Jawabarat', '[\"Rivaldy\", \"Fawzia\", \"Yufi\", \"Fachri\", \"Delvi\"]', '2026-05-19 19:45:58', '2026-05-19 20:17:33'),
(2, 'SPMB-2026-00002', '2027/2028', 'National School', 'SMA PLUS ISLAMIC VILLAGE', 'Shelomita Damayanti', 'Shela', 'perempuan', 'Bandung', '2006-12-03', '2345678765678', '3276011508120003', 'WNI', 'Anak ke 3', 'Jl. Gatot Subroto, RT.002/RW.001, Alam Jaya, Kec. Jatiuwung', '001', '011', 'Kadu', 'Curug', 'Kota Tangerang', 'Banten', '15810', '082128254262', 3, '082128254262', NULL, 'yufi@gmail.com', 'Kendaraan Pribadi', 'Instagram', 167, 57, '{\"dbd\": false, \"tbc\": false, \"cacar\": false, \"liver\": false, \"lainnya\": null}', NULL, 'tidak', NULL, 'Ngambekkan', 'Eddy', 'Jakarta', '2026-05-03', 'Karyawan Swasta', 'S1', '>6 Jt', NULL, 'Ani', 'Ciamis', '2026-05-10', 'Ibu R T', 'SMA', '<4 Jt', NULL, 'SMP', 'SMP N 2 Bandung', 'Noong Cisaga', 'Desa Noong', 'Cisaga', 'Bandung', 'Jawabarat', '[\"Yufi\", \"Shela\", null, null, null]', '2026-05-21 00:39:57', '2026-05-21 00:39:57');

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

--
-- Table structure for table `spmb_targets`
--

CREATE TABLE `spmb_targets` (
  `id` bigint UNSIGNED NOT NULL,
  `thn_ajaran` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `program` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenjang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_total` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `program` enum('ib','iis') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alumni_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `thn_lulus` int NOT NULL,
  `current_job` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_en` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_urut` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `program`, `name`, `alumni_status`, `thn_lulus`, `current_job`, `content_id`, `content_en`, `image`, `no_urut`, `created_at`, `updated_at`) VALUES
(1, 'ib', 'Ahmad Fauzan', 'Alumni SMK Penerbangan', 2020, 'Pilot Lion Air', 'Belajar di program ini memberikan banyak pengalaman berharga. Materi yang diajarkan sangat relevan dengan kebutuhan industri saat ini. Selain itu, para instruktur selalu memberikan bimbingan yang membantu saya memahami konsep-konsep teknis secara mendalam.\n\nSetelah lulus, saya merasa lebih percaya diri dalam menghadapi proses rekrutmen kerja. Berbagai proyek yang dikerjakan selama pembelajaran menjadi nilai tambah saat membangun portofolio profesional.', 'This program provided valuable learning experiences and industry-relevant knowledge. The instructors were highly supportive and helped me understand technical concepts effectively.\n\nAfter graduation, I felt more confident when applying for jobs. The projects completed during the program strengthened my professional portfolio.', 'testimonials/01KSVJQMXN31YDVHMVCPGZM5P3.png', 1, '2026-05-29 21:37:01', '2026-06-01 18:53:41'),
(2, 'ib', 'Siti Nurhaliza', 'Alumni SMA Negeri 5 Jakarta', 2021, 'Data Analyst at PT Bank Central Asia Tbk', 'Program ini membantu saya memahami dunia data dan analisis secara lebih terstruktur. Saya belajar bagaimana mengolah data, membuat visualisasi, serta menyusun laporan yang dapat digunakan untuk pengambilan keputusan bisnis.\n\nLingkungan belajar yang kondusif membuat saya nyaman untuk bertanya dan berdiskusi. Setiap tugas yang diberikan mendorong saya untuk berpikir kritis dan mencari solusi yang efektif.\n\nBerkat pengalaman tersebut, saya berhasil mendapatkan pekerjaan sebagai Data Analyst. Kompetensi yang saya peroleh selama masa pembelajaran menjadi modal utama dalam menjalankan pekerjaan saya saat ini.', 'This program helped me understand data analytics in a structured and practical way. I learned data processing, visualization, and reporting techniques used in real business environments.\n\nThe supportive learning environment encouraged active discussion and critical thinking. Each assignment challenged me to develop effective solutions.\n\nThanks to these experiences, I successfully started my career as a Data Analyst. The skills I gained continue to support my professional growth.', 'testimonials/01KT2ZK9VMWM5W374MNSWA3W3R.png', 2, '2026-06-01 18:36:31', '2026-06-01 18:36:31'),
(3, 'ib', 'Muhammad Rizky Pratama', 'Alumni SMK Penerbangan Bandung', 2019, 'Network Engineer at PT Indosat Ooredoo Hutchison', 'Selama mengikuti program ini, saya memperoleh pemahaman yang kuat mengenai teknologi jaringan dan infrastruktur IT. Materi pembelajaran disusun secara sistematis sehingga mudah dipahami oleh peserta dari berbagai latar belakang.\n\nSelain teori, saya juga mendapatkan banyak kesempatan praktik yang membantu meningkatkan kemampuan teknis. Pengalaman tersebut membuat saya lebih siap menghadapi tantangan di dunia kerja yang sesungguhnya.\n\nSaat ini saya bekerja sebagai Network Engineer dan sering menerapkan konsep-konsep yang dipelajari selama program berlangsung. Saya bersyukur pernah menjadi bagian dari program yang sangat bermanfaat ini.', 'During the program, I gained a solid understanding of networking technologies and IT infrastructure. The learning materials were well-structured and easy to follow.\n\nIn addition to theory, I had many hands-on opportunities that strengthened my technical skills. These experiences prepared me well for real-world challenges.\n\nI currently work as a Network Engineer and frequently apply the concepts learned during the program. I am grateful to have been part of such a beneficial learning experience.', 'testimonials/01KT2ZR19F7EXXZ7WNPACMN0DC.png', 3, '2026-06-01 18:39:06', '2026-06-01 18:39:06'),
(4, 'iis', 'Dinda Maharani Putri', 'Alumni SMA Negeri 3 Bandung', 2021, 'Human Resource Officer at PT Astra International Tbk', 'Program IIS memberikan saya pemahaman yang kuat mengenai manajemen sumber daya manusia, komunikasi bisnis, dan administrasi perkantoran. Materi yang disampaikan sangat aplikatif dan sesuai dengan kebutuhan dunia kerja saat ini.\n\nSelama mengikuti pembelajaran, saya juga mendapatkan kesempatan untuk mengembangkan kemampuan presentasi, kerja tim, dan pemecahan masalah. Pengalaman tersebut membantu saya menjadi lebih percaya diri dalam lingkungan profesional.\n\nSaat ini saya bekerja sebagai Human Resource Officer dan banyak pengetahuan yang saya peroleh masih digunakan dalam aktivitas kerja sehari-hari. Program ini menjadi salah satu langkah penting dalam perjalanan karier saya.', 'The IIS program provided me with a strong understanding of human resource management, business communication, and office administration. The learning materials were practical and aligned with current industry needs.\n\nThroughout the program, I developed presentation, teamwork, and problem-solving skills that increased my confidence in professional environments.\n\nToday, I work as a Human Resource Officer, and many of the skills I learned continue to support my daily responsibilities. This program played an important role in my career journey.', 'testimonials/01KT30GQHHG96QJ1WSSND0CNM4.jpg', 3, '2026-06-01 18:52:35', '2026-06-05 19:32:11'),
(5, 'iis', 'Rafi Akbar Nugraha', 'Alumni SMK Negeri 2 Tasikmalaya', 2020, 'Business Development Staff at PT Tokopedia', 'Program IIS membantu saya memahami konsep bisnis modern, strategi pemasaran, dan pengelolaan proyek secara efektif. Kurikulum yang disusun memberikan keseimbangan antara teori dan praktik sehingga mudah diterapkan di dunia kerja.\n\nBerbagai studi kasus yang diberikan selama pembelajaran membuat saya terbiasa menganalisis masalah dan mencari solusi yang tepat. Hal tersebut menjadi bekal berharga ketika menghadapi tantangan pekerjaan.', 'The IIS program helped me understand modern business concepts, marketing strategies, and project management practices. The curriculum balanced theory and practical implementation effectively.\n\nThrough various case studies, I learned how to analyze problems and develop suitable solutions, which became valuable assets in my professional career.', 'testimonials/01KT30VDBSQW2AGCAJZTVG8TTK.jpg', 2, '2026-06-01 18:58:25', '2026-06-01 18:58:25'),
(6, 'iis', 'Nabila Azzahra', 'Alumni SMA Negeri 1 Ciamis', 2022, 'Administration Staff at PT Bank Mandiri Persero Tbk', 'Melalui Program IIS, saya memperoleh wawasan yang luas mengenai administrasi keuangan, pengelolaan dokumen, dan pelayanan profesional. Materi pembelajaran disampaikan secara sistematis sehingga mudah dipahami dan diterapkan.\n\nSelain kemampuan teknis, program ini juga membantu meningkatkan keterampilan komunikasi dan manajemen waktu yang sangat dibutuhkan dalam dunia kerja. Saya merasa lebih siap menghadapi lingkungan kerja yang dinamis.\n\nSaat ini saya bekerja sebagai Finance Administration Staff dan banyak kompetensi yang diperoleh selama pembelajaran menjadi dasar dalam menjalankan tugas sehari-hari. Pengalaman belajar yang saya dapatkan sangat berharga untuk perkembangan karier saya.', 'Through the IIS program, I gained extensive knowledge of financial administration, document management, and professional services. The learning materials were delivered systematically and were easy to apply.\n\nThe program also improved my communication and time-management skills, which are essential in today\'s workplace. I felt well prepared for a dynamic professional environment.\n\nI currently work as a Finance Administration Staff, and many of the competencies I gained are directly applicable to my daily responsibilities. The learning experience has been highly valuable for my career growth.', 'testimonials/01KT31BEJPAPY5QC74MNWY9AFZ.jpg', 3, '2026-06-01 19:07:11', '2026-06-01 19:07:11'),
(7, 'ib', 'Jepri Jusuf', 'Alumni SMA Negeri 1 Ciamis', 2018, 'Finance Administration Staff at PT Bank Mandiri Persero Tbk', 'Melalui Program IIS, saya memperoleh wawasan yang luas mengenai administrasi keuangan, pengelolaan dokumen, dan pelayanan profesional. Materi pembelajaran disampaikan secara sistematis sehingga mudah dipahami dan diterapkan.\n\nSelain kemampuan teknis, program ini juga membantu meningkatkan keterampilan komunikasi dan manajemen waktu yang sangat dibutuhkan dalam dunia kerja. Saya merasa lebih siap menghadapi lingkungan kerja yang dinamis.', 'Through the IIS program, I gained extensive knowledge of financial administration, document management, and professional services. The learning materials were delivered systematically and were easy to apply.\n\nThe program also improved my communication and time-management skills, which are essential in today\'s workplace. I felt well prepared for a dynamic professional environment.', 'testimonials/01KT39KV95SM5FY48G12S2K9XZ.png', 4, '2026-06-01 21:31:35', '2026-06-01 21:31:35'),
(8, 'iis', 'Ahmad Fauzan', 'Alumni SMK Penerbangan', 2019, 'Network Engineer at PT Indosat Ooredoo Hutchison', 'oidsjpokdsf', 'sjdposadk', 'testimonials/01KTDCACHEDN7FR2P37ZM9A4HB.png', 1, '2026-06-05 19:31:15', '2026-06-05 19:32:25');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `activity_images`
--
ALTER TABLE `activity_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_images_activity_id_foreign` (`activity_id`);

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

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `events_slug_id_unique` (`slug_id`),
  ADD UNIQUE KEY `events_slug_en_unique` (`slug_en`);

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

--
-- Indexes for table `extracurricular_images`
--
ALTER TABLE `extracurricular_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `extracurricular_images_extracurricular_id_foreign` (`extracurricular_id`);

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

--
-- Indexes for table `facility_images`
--
ALTER TABLE `facility_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `facility_images_facility_id_foreign` (`facility_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `news_slug_id_unique` (`slug_id`),
  ADD UNIQUE KEY `news_slug_en_unique` (`slug_en`);

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `achievements`
--
ALTER TABLE `achievements`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `activities`
--
ALTER TABLE `activities`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `activity_images`
--
ALTER TABLE `activity_images`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `extracurriculars`
--
ALTER TABLE `extracurriculars`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `extracurricular_images`
--
ALTER TABLE `extracurricular_images`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `facilities`
--
ALTER TABLE `facilities`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `facility_images`
--
ALTER TABLE `facility_images`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `spmb_applications`
--
ALTER TABLE `spmb_applications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `spmb_targets`
--
ALTER TABLE `spmb_targets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `activity_images`
--
ALTER TABLE `activity_images`
  ADD CONSTRAINT `activity_images_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `extracurricular_images`
--
ALTER TABLE `extracurricular_images`
  ADD CONSTRAINT `extracurricular_images_extracurricular_id_foreign` FOREIGN KEY (`extracurricular_id`) REFERENCES `extracurriculars` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `facility_images`
--
ALTER TABLE `facility_images`
  ADD CONSTRAINT `facility_images_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `facilities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

