-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 18, 2026 at 09:28 AM
-- Server version: 8.4.3
-- PHP Version: 8.3.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `sttf_cilegon`
--

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

--
-- Table structure for table `agendas`
--

CREATE TABLE `agendas` (
  `id` int UNSIGNED NOT NULL,
  `judul` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `tanggal` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `tanggal_filter` date DEFAULT NULL,
  `deskripsi` text COLLATE utf8mb4_general_ci NOT NULL,
  `posisi` enum('left','right') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'left',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `agendas`
--

INSERT INTO `agendas` (`id`, `judul`, `tanggal`, `tanggal_filter`, `deskripsi`, `posisi`, `created_at`) VALUES
(5, 'Batas Akhir Gelombang 1 PMB', '25 MEI 2026', '2026-05-25', 'Penutupan pendaftaran mahasiswa baru jalur seleksi raport.', 'left', '2026-04-18 05:55:53'),
(6, 'Workshop Robotika Nasional', '10 JUNI 2026', '2026-06-10', 'Kolaborasi riset antar universitas teknologi.', 'right', '2026-04-18 05:55:53'),
(7, 'STTF Career Expo', '05 JULI 2026', '2026-07-05', 'Sesi rekrutmen langsung bersama mitra industri raksasa.', 'left', '2026-04-18 05:55:53'),
(8, 'Inaugurasi Mahasiswa Baru', '20 AGUSTUS 2026', '2026-08-20', 'Penyambutan angkatan 2026/2027.', 'right', '2026-04-18 05:55:53'),
(9, 'Pra UKK TITL', '16 April 2026', '2026-04-16', 'bisa gk ya?', 'left', '2026-04-18 07:39:13');

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

--
-- Table structure for table `berita`
--

CREATE TABLE `berita` (
  `id` int UNSIGNED NOT NULL,
  `judul` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `konten` text COLLATE utf8mb4_general_ci NOT NULL,
  `gambar` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` enum('draft','published') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'published',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `berita`
--

INSERT INTO `berita` (`id`, `judul`, `slug`, `konten`, `gambar`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Pra UKK TITL', 'pra-ukk-titl', 'djsflkj ierwtokg dlgks;fdg', NULL, 'published', '2026-04-18 02:02:39', '2026-04-18 02:02:39'),
(2, 'Lolos SNBP!', 'lolos-snbp', 'ha ha ha hi hi hi', '1776478265_f23fead819e29e9d656f.jpeg', 'published', '2026-04-18 02:11:05', '2026-04-18 02:11:05'),
(3, 'STTF Cilegon Jalin Kerjasama Global dengan POSCO Korea', 'sttf-cilegon-jalin-kerjasama-global-dengan-posco-korea', 'STTF Cilegon resmi menandatangani MOU kerjasama riset dan penempatan kerja bagi lulusan terbaik di POSCO Korea Selatan. Program ini mencakup magang intensif dan beasiswa pendidikan lanjut.', NULL, '', '2026-04-18 03:41:26', NULL),
(4, 'Inovasi Robot Pembersih Limbah Industri Karya Mahasiswa Elektro', 'inovasi-robot-pembersih-limbah-industri-karya-mahasiswa-elektro', 'Mahasiswa Teknik Elektro angkatan 2023 berhasil menciptakan prototipe robot otonom untuk membersihkan limbah cair industri. Alat ini menggunakan sensor pintar untuk mendeteksi tingkat keasaman cairan.', NULL, '', '2026-04-18 03:41:26', NULL);

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

--
-- Table structure for table `downloads`
--

CREATE TABLE `downloads` (
  `id` int UNSIGNED NOT NULL,
  `nama_berkas` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `kategori` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Umum',
  `file_path` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `ukuran` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `downloads` int NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `downloads`
--

INSERT INTO `downloads` (`id`, `nama_berkas`, `kategori`, `file_path`, `ukuran`, `downloads`, `created_at`) VALUES
(1, 'Silabus', 'akademik', 'debian VS ubuntu.pdf', '46.91 KB', 6, '2026-04-18 06:17:54');

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

--
-- Table structure for table `experts`
--

CREATE TABLE `experts` (
  `id` int UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `spesialisasi` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `foto` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `experts`
--

INSERT INTO `experts` (`id`, `nama`, `spesialisasi`, `foto`, `created_at`) VALUES
(13, 'Dr. Eng. Ahmad Syarif', 'Expert in Robotics & AI', NULL, NULL),
(14, 'Ir. Bambang Wijaya, M.T.', 'Industrial Automation Specialist', NULL, NULL),
(15, 'Siti Aminah, Ph.D.', 'Chemical Process Engineer', NULL, NULL),
(16, 'Hendro Prasetyo, M.Eng.', 'Power System Analyst', NULL, NULL);

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int UNSIGNED NOT NULL,
  `pertanyaan` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `jawaban` text COLLATE utf8mb4_general_ci NOT NULL,
  `urutan` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `pertanyaan`, `jawaban`, `urutan`) VALUES
(10, 'Bagaimana prosedur pendaftaran mahasiswa baru?', 'Pendaftaran dapat dilakukan secara online melalui tombol \"Inisiasi Pendaftaran\" di atas atau datang langsung ke sekretariat pendaftaran di kampus STTF Cilegon.', 1),
(11, 'Apakah tersedia kelas untuk karyawan?', 'Ya, STTF Cilegon menyediakan kelas karyawan dengan jadwal yang fleksibel tanpa mengganggu waktu kerja profesional Anda.', 2),
(12, 'Apakah ada program beasiswa industri?', 'Tentu, kami bekerja sama dengan berbagai mitra industri di Cilegon untuk memberikan beasiswa bagi mahasiswa berprestasi dan kurang mampu.', 3);

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int UNSIGNED NOT NULL,
  `judul` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `kategori` enum('fasilitas','kegiatan') COLLATE utf8mb4_general_ci NOT NULL,
  `tipe` enum('image','video_local','video_youtube') COLLATE utf8mb4_general_ci DEFAULT 'image',
  `video_url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gambar` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deskripsi` text COLLATE utf8mb4_general_ci,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `judul`, `kategori`, `tipe`, `video_url`, `gambar`, `deskripsi`, `created_at`) VALUES
(9, 'Karya Robotika', 'kegiatan', 'image', NULL, 'robotics_project.png', 'Prototipe Robotic Arm.', NULL),
(10, 'Seminar Teknologi', 'kegiatan', 'image', NULL, 'activity_seminar.png', 'Diskusi panel rutin.', NULL),
(11, 'Praktikum Kimia', 'fasilitas', 'image', NULL, 'lab_chemical.png', 'Aktivitas riset Lab Kimia.', NULL),
(12, 'Sports Activity', 'kegiatan', 'image', NULL, 'activity_sports.png', 'Futsal & Basket.', NULL),
(13, 'Lab Mechanical', 'fasilitas', 'image', NULL, 'lab_mechanical.png', 'Fasilitas CNC Advanced.', NULL),
(14, 'Lab Electrical', 'fasilitas', 'image', NULL, 'lab_electrical.png', 'Riset Microcontroller.', NULL),
(15, 'Karya Robotika', 'kegiatan', 'image', NULL, 'robotics_project.png', 'Prototipe Robotic Arm.', NULL),
(16, 'Seminar Teknologi', 'kegiatan', 'image', NULL, 'activity_seminar.png', 'Diskusi panel rutin.', NULL),
(17, 'Praktikum Kimia', 'fasilitas', 'image', NULL, 'lab_chemical.png', 'Aktivitas riset Lab Kimia.', NULL),
(18, 'Sports Activity', 'kegiatan', 'image', NULL, 'activity_sports.png', 'Futsal & Basket.', NULL),
(19, 'Lab Mechanical', 'fasilitas', 'image', NULL, 'lab_mechanical.png', 'Fasilitas CNC Advanced.', NULL),
(20, 'Lab Electrical', 'fasilitas', 'image', NULL, 'lab_electrical.png', 'Riset Microcontroller.', NULL),
(21, 'Karya Robotika', 'kegiatan', 'image', NULL, 'robotics_project.png', 'Prototipe Robotic Arm.', NULL),
(22, 'Seminar Teknologi', 'kegiatan', 'image', NULL, 'activity_seminar.png', 'Diskusi panel rutin.', NULL),
(23, 'Praktikum Kimia', 'fasilitas', 'image', NULL, 'lab_chemical.png', 'Aktivitas riset Lab Kimia.', NULL),
(24, 'Sports Activity', 'kegiatan', 'image', NULL, 'activity_sports.png', 'Futsal & Basket.', NULL),
(26, 'UKBI', 'kegiatan', 'video_local', NULL, '1776492480_79995edd10e03b1ffecd.mp4', 'UKBI', '2026-04-18 06:08:00'),
(27, 'tes yt', 'kegiatan', 'video_youtube', 'https://www.youtube.com/watch?v=nlcsayZJI6g', NULL, 'tes yt', '2026-04-18 06:12:20');

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

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

CREATE TABLE `migrations` (
  `id` bigint UNSIGNED NOT NULL,
  `version` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `class` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `group` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `namespace` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `time` int NOT NULL,
  `batch` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2026-04-18-015405', 'App\\Database\\Migrations\\CreateBeritaTable', 'default', 'App', 1776477265, 1),
(2, '2026-04-18-020703', 'App\\Database\\Migrations\\CreatePmbTable', 'default', 'App', 1776478041, 2),
(3, '2026-04-18-031240', 'App\\Database\\Migrations\\CreateWebsiteCoreTables', 'default', 'App', 1776481980, 3),
(4, '2026-04-18-032001', 'App\\Database\\Migrations\\CreateMoreContentTables', 'default', 'App', 1776482414, 4),
(5, '2026-04-18-034807', 'App\\Database\\Migrations\\CreateAgendaTable', 'default', 'App', 1776484113, 5),
(6, '2026-04-18-055446', 'App\\Database\\Migrations\\AddDateFilterToAgendas', 'default', 'App', 1776491700, 6),
(7, '2026-04-18-060339', 'App\\Database\\Migrations\\AddVideoSupportToGallery', 'default', 'App', 1776492259, 7),
(8, '2026-04-18-061113', 'App\\Database\\Migrations\\FixGalleryGambarNullable', 'default', 'App', 1776492689, 8),
(9, '2026-04-18-061416', 'App\\Database\\Migrations\\CreateDownloadTable', 'default', 'App', 1776492894, 9),
(10, '2026-04-18-072410', 'App\\Database\\Migrations\\CreateSliderTable', 'default', 'App', 1776497062, 10);

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

--
-- Table structure for table `pmb`
--

CREATE TABLE `pmb` (
  `id` int UNSIGNED NOT NULL,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `asal_sekolah` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `jurusan_pilihan` enum('Teknik Mesin','Teknik Elektro','Teknik Kimia') COLLATE utf8mb4_general_ci NOT NULL,
  `no_hp` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `status_seleksi` enum('Menunggu','Lulus','Tidak Lulus') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Menunggu',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pmb`
--

INSERT INTO `pmb` (`id`, `nama_lengkap`, `asal_sekolah`, `jurusan_pilihan`, `no_hp`, `status_seleksi`, `created_at`, `updated_at`) VALUES
(1, 'Tb. Eka Nugraha', 'SMKN 2', 'Teknik Mesin', '087737264307', 'Menunggu', '2026-04-18 02:12:31', '2026-04-18 02:12:31');

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

--
-- Table structure for table `programs`
--

CREATE TABLE `programs` (
  `id` int UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_general_ci NOT NULL,
  `ikon` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `programs`
--

INSERT INTO `programs` (`id`, `nama`, `deskripsi`, `ikon`, `slug`) VALUES
(10, 'Teknik Mesin (S1)', 'Rekayasa mekanikal modern, manufaktur pintar, dan analisis struktur aerodinamis berbantuan sistem komputasi terkini.', 'precision_manufacturing', 'teknik-mesin'),
(11, 'Teknik Elektro (S1)', 'Pengembangan sistem kelistrikan pintar, IoT (Internet of Things), mikroprosesor, dan arsitektur kontrol robotik.', 'memory', 'teknik-elektro'),
(12, 'Teknik Kimia (S1)', 'Sintesis material maju, energi terbarukan, dan rekayasa proses kimia berfokus pada teknologi hijau berkelanjutan.', 'science', 'teknik-kimia');

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

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

CREATE TABLE `settings` (
  `id` int UNSIGNED NOT NULL,
  `key` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `value` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`) VALUES
(1, 'site_title', 'STTF Cilegon - Future Tech Institute'),
(2, 'site_description', 'Sekolah Tinggi Teknologi Fatahillah Cilegon. Pusat inkubasi engineering masa depan.'),
(3, 'contact_email', 'info@sttfcilegon.ac.id'),
(4, 'contact_phone', '(0254) 1234567'),
(5, 'contact_address', 'Jl. Pangeran Jayakarta, Cilegon, Banten');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int UNSIGNED NOT NULL,
  `judul` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `sub_judul` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gambar` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `link_tujuan` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `urutan` int NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `judul`, `sub_judul`, `gambar`, `link_tujuan`, `urutan`, `created_at`) VALUES
(1, 'tes', 'tes juga', '1776497176_b7771db4ad72fed8930c.jpg', '', 1, '2026-04-18 07:26:16'),
(2, 'tes info', 'tes juga', '1776497215_f14bddd00779ade2f326.jpg', '', 2, '2026-04-18 07:26:55');

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

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

CREATE TABLE `testimonials` (
  `id` int UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `jabatan` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `pesan` text COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `testimonials` (`id`, `nama`, `jabatan`, `pesan`, `created_at`) VALUES
(7, 'DIAN PRATIWI', 'Electrical Engineer at POSCO', 'Kurikulum STTF sangat adaptif dengan kebutuhan industri di Cilegon. Saya langsung bekerja sebelum wisuda.', NULL),
(8, 'IKHSAN KAMAL', 'Maintenance Supervisor at KS', 'Fasilitas laboratorium mesin di STTF sangat lengkap, membuat transisi ke dunia kerja menjadi sangat mulus.', NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int UNSIGNED NOT NULL,
  `username` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `nama_lengkap` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `role` enum('admin','editor') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'editor',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `nama_lengkap`, `role`, `created_at`, `updated_at`) VALUES
(1, 'admin', '$2y$10$uK3AGDX8mLmy6lVKlGNS6uNobRIbsmPb4Uct4lFlEB1AI8bQbDym6', 'Administrator Utama', 'admin', '2026-04-18 03:13:20', NULL),
(2, 'eka', '$2y$10$s3x/7BPDoTH6CYGE8C73gOhnl2kICEjFe/ZTuPZqsZN.DAZAITRoK', 'Tb. Eka Nugraha', 'editor', '2026-04-18 03:15:47', NULL);

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

--
-- Table structure for table `visitation_logs`
--

CREATE TABLE `visitation_logs` (
  `id` int UNSIGNED NOT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_general_ci NOT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `visit_date` date NOT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `visitation_logs`
--

INSERT INTO `visitation_logs` (`id`, `ip_address`, `user_agent`, `visit_date`, `created_at`) VALUES
(1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:28:34'),
(2, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:30:01'),
(3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:31:58'),
(4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:33:30'),
(5, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:37:00'),
(6, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:37:03'),
(7, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:39:11'),
(8, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:45:49'),
(9, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 03:46:26'),
(10, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 04:14:49'),
(11, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 04:14:50'),
(12, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 04:56:42'),
(13, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 05:24:18'),
(14, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 05:25:47'),
(15, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 05:52:45'),
(16, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 05:57:36'),
(17, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 06:10:41'),
(18, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 06:18:03'),
(19, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 06:32:44'),
(20, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:26:20'),
(21, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:27:08'),
(22, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:31:24'),
(23, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:32:20'),
(24, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:33:16'),
(25, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:34:51'),
(26, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:38:07'),
(27, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:39:17'),
(28, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:43:23'),
(29, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:44:03'),
(30, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:44:05'),
(31, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:44:42'),
(32, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:44:43'),
(33, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:45:54'),
(34, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:47:15'),
(35, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:47:23'),
(36, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:48:16'),
(37, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:49:55'),
(38, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:56:21'),
(39, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:56:33'),
(40, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:56:46'),
(41, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:56:55'),
(42, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:57:00'),
(43, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:58:33'),
(44, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 07:58:37'),
(45, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:05:32'),
(46, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:11:34'),
(47, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:13:18'),
(48, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:13:23'),
(49, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:14:06'),
(50, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:14:08'),
(51, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:14:54'),
(52, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:14:57'),
(53, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:16:53'),
(54, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 08:54:30'),
(55, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '2026-04-18', '2026-04-18 09:12:13');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `key` (`key`);

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `visitation_logs`
--
ALTER TABLE `visitation_logs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
