-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 31 Jul 2026 pada 14.14
-- Versi server: 10.4.32-MariaDB
-- Versi PHP: 8.2.12

START TRANSACTION;



--
-- Database: `fatayat_nu`
--

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

--
-- Struktur dari tabel `albums`
--

CREATE TABLE `albums` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_album` varchar(255) NOT NULL,
  `deskripsi` varchar(255) 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 untuk tabel `albums`
--

INSERT INTO `albums` (`id`, `nama_album`, `deskripsi`, `created_at`, `updated_at`) VALUES
(4, 'Pelantikan', 'Dilaksanakan pada 25 April 2026 di gedung MWCNU Tahunan Jepara', '2026-07-05 06:46:42', '2026-07-05 06:46:42'),
(5, 'Deftones', 'I love Chino Moreno', '2026-07-05 06:47:20', '2026-07-05 06:47:20'),
(6, 'Valorant', 'so fun yet it drains me', '2026-07-05 08:39:12', '2026-07-05 08:39:12'),
(7, 'Cat', 'Scaredycat', '2026-07-05 09:07:58', '2026-07-05 09:07:58'),
(9, 'Roblox', 'Memories', '2026-07-05 09:11:18', '2026-07-05 09:11:18'),
(10, 'Elden ring', NULL, '2026-07-05 19:07:59', '2026-07-05 19:07:59'),
(11, 'Pelantikan', 'I love Chino Moreno', '2026-07-22 00:09:31', '2026-07-22 00:09:31'),
(13, 'Pelantikan', 'w', '2026-07-22 22:54:17', '2026-07-22 22:54:17');

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

--
-- Struktur dari tabel `articles`
--

CREATE TABLE `articles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `status` enum('draft','published') NOT NULL DEFAULT 'published',
  `jenis` varchar(255) NOT NULL DEFAULT 'biasa',
  `link_dokumentasi` varchar(255) 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 untuk tabel `articles`
--

INSERT INTO `articles` (`id`, `title`, `slug`, `content`, `image`, `images`, `status`, `jenis`, `link_dokumentasi`, `created_at`, `updated_at`) VALUES
(2, 'Ramadhan Ke - 30', 'ramadhan-ke-30', '*Selamat Menunaikan Ibadah Puasa*\r\n\r\n_Pergi pagi memetik melati_\r\n_Harumnya sampai ke dalam rumah_\r\n_Ramadhan pergi sedih di hati_\r\n_Semoga berkahnya tetap melimpah_\r\n\r\n💚💚💚💚💚💚💚💚💚\r\n\r\n*Pimpinan Anak Cabang Fatayat NU Tahunan*\r\n\r\n#Safari1447H\r\n#MediaPACFNUTahunan\r\n#PACFNUTahunan\r\n#Ramadhankareem', 'articles/Jx6wMOpWPWDfsqUeoRCbRbzNd54EF1tHm4UgyzpP.png', NULL, 'published', 'biasa', NULL, '2026-03-01 13:37:49', '2026-04-11 00:29:25'),
(3, '1 Syawal 1447 H', '1-syawal-1447-h', '*Selamat Hari Raya Idul Fitri*\r\n\r\n_Pergi berlayar menuju seberang_\r\n_Singgah sebentar di pulau bahari_\r\n_Ramadhan telah kita lewati dengan tenang_\r\n_Kini Idul Fitri menyucikan diri dan hati_\r\n\r\n💚💚💚💚💚💚💚💚💚\r\n\r\n*Pimpinan Anak Cabang Fatayat NU Tahunan*\r\n\r\n#Safari1447H\r\n#MediaPACFNUTahunan\r\n#PACFNUTahunan\r\n#Ramadhankareem', 'articles/yYFc4Jjg2CgXXSU0O0WfcVIgMIszdBfWXWHyvnWZ.png', NULL, 'published', 'biasa', NULL, '2026-04-10 22:16:16', '2026-04-11 00:28:59'),
(5, 'Ramadhan Ke-29', 'ramadhan-ke-29', '*Selamat Menunaikan Ibadah Puasa*\r\n\r\n_Beli madu di toko seberang_\r\n_Jangan lupa membeli kurma juga_\r\n_Puasa membuat tubuh lebih tenang_\r\n_Sehat raga bahagia jiwa_\r\n\r\n💚💚💚💚💚💚💚💚💚\r\n\r\n*Pimpinan Anak Cabang Fatayat NU Tahunan*\r\n\r\n#Safari1447H\r\n#MediaPACFNUTahunan\r\n#PACFNUTahunan\r\n#Ramadhankareem', 'articles/tSv8MeXzzTSQK3nGhXSMlCzXDhtYHeJMVG2r6GO1.png', NULL, 'published', 'biasa', NULL, '2026-04-11 00:29:57', '2026-04-11 00:29:57'),
(6, 'Ramadhan Ke-28', 'ramadhan-ke-28', '*Selamat Menunaikan Ibadah Puasa*\r\n\r\n_Burung merpati terbang ke Mekkah_\r\n_Hinggap sebentar di pohon kurma_\r\n_Indahnya Islam mengajarkan ukhuwah_\r\n_Silaturrahmi mempererat rasa_\r\n\r\n💚💚💚💚💚💚💚💚💚\r\n\r\n*Pimpinan Anak Cabang Fatayat NU Tahunan*\r\n\r\n#Safari1447H\r\n#MediaPACFNUTahunan\r\n#PACFNUTahunan\r\n#Ramadhankareem', 'articles/azWCiXmQ7G1W9DrxgFJyZtGWslIOnQC55rx4Xasb.png', NULL, 'published', 'biasa', NULL, '2026-04-11 00:30:29', '2026-04-11 00:30:29'),
(7, 'Kabar duka', 'kabar-duka', 'Inna lillahi wa inna ilaihi raji’un.\r\n\r\nKeluarga Besar PAC Fatayat NU Tahunan turut berduka cita atas wafatnya\r\n*BAPAK MUHAMMAD NUR AINI BIN MBAH MUSLIKHAN*\r\n(Ayahanda dari M.Bayu Nugroho Ketua PAC IPNU Kecamatan Tahunan).\r\n\r\nSemoga Allah SWT menerima seluruh amal ibadahnya dan menempatkannya di tempat terbaik di sisi-Nya.\r\n\r\nAl-Fatihah…\r\n\r\n#BerdukaCita\r\n#Innalillahi\r\n#FatayatNU\r\n#IPNUIPPNU\r\n#KhidmahNU', 'articles/r9WD03P86iNn5yh4WisKh7zYagVTpyWMCUNdZY3z.jpg', NULL, 'draft', 'biasa', NULL, '2026-04-11 00:30:51', '2026-07-02 21:06:30'),
(8, 'Adam got his 67th ACE in valorant', 'adam-got-his-67th-ace-in-valorant', 'bambam bammbammm', 'articles/wEgkqXBM1soAWXfydH2xGpw7JSn28wOpAb3D5vH2.jpg', NULL, 'published', 'biasa', NULL, '2026-07-05 01:34:52', '2026-07-05 01:34:52'),
(10, 'Games stuff', 'games-stuff', 'damn', 'articles/XffgH4kxGqU2dHubrb5sQJxXVRY3osKdOP5HOXaG.png', '[\"articles\\/oPJDmZs9h227O9zvtCgH5yzheTKSUelMm6qWr7H7.png\",\"articles\\/OhM9axp3qNkemqeXjEZxlOsIDbY1NpG5LLV7UaoX.png\"]', 'published', 'biasa', NULL, '2026-07-05 07:46:19', '2026-07-05 08:12:18'),
(12, 'add', 'add', 'adad', 'articles/AD5h96Fy78ebRb95Rv8kseXUBuijq9aFHXPWf9qD.jpg', '[\"articles\\/RtSiEPxLOfo3i7N8a2YjWnqpCDoKueIcClyCkDZB.jpg\",\"articles\\/WygTOEHLpnUgLb1FEyIWbpR1LJSAjc6uC3rDlr9O.jpg\"]', 'published', 'biasa', NULL, '2026-07-05 08:14:04', '2026-07-05 08:18:24'),
(13, 'Neverpitou HXH', 'neverpitou-hxh', 'Neferpitou, atau biasa dipanggil Pitou, adalah salah satu karakter paling populer dari anime dan manga Hunter x Hunter. Sebagai Semut Chimera Pengawal Kerajaan (Royal Guard) pertama yang lahir, Pitou sangat setia kepada Raja Semut dan dikenal karena kemampuan Nen Spesialis-nya yang mengerikan.', 'articles/9c4nAZTlFBvSvPD0PWF58hNBcns9Ht1PjT3pxcaw.jpg', '[\"articles\\/QMxIn6A5P0gYLbr8XDF5LxImyfd5O1kFC54y2zYS.jpg\",\"articles\\/VwaRBp0gLmlHL7LfA47qIqfRxUWTsRjUuBtxDHWB.jpg\",\"articles\\/zI8b1rHzT3IVcPQVk9ZogEBE7s3SK5kkaffgs1CH.jpg\"]', 'published', 'biasa', NULL, '2026-07-05 08:23:28', '2026-07-05 19:07:37'),
(14, 'Elden Ring', 'elden-ring', 'peak', 'articles/EFvG0mTuauQ4rD5tgmYL6can3sbaZKruCdd1GZTR.png', '[\"articles\\/fr8rAEnLs1xm6ULeActLCoWPfiFKil1sn0HpgJWx.png\",\"articles\\/BVdN7tsfdrij7ogS9IrQWc6TOYYCKmUsjYSOy6m2.png\",\"articles\\/3TF10s67ga5i5h17cg2l5tIubJuTGnVh1ganv0X9.png\",\"articles\\/TWdavnwf5ssnEyOuLDXuDU6jihIW4ED2TOkVnKyQ.png\",\"articles\\/bE9tKHIskEF5fGyOrRewGSWHQhOBN0zFWzgFpkB7.png\",\"articles\\/QhCimCJeXrfGUPO2KImz1CpOIUVVoJau1aMNwJKj.png\"]', 'published', 'lembaga', NULL, '2026-07-05 18:27:16', '2026-07-05 18:27:16');

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

--
-- Struktur dari tabel `article_images`
--

CREATE TABLE `article_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `article_id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `events`
--

CREATE TABLE `events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `location` varchar(255) NOT NULL,
  `event_date` datetime NOT NULL,
  `status` enum('upcoming','completed') NOT NULL DEFAULT 'upcoming',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `events`
--

INSERT INTO `events` (`id`, `name`, `description`, `location`, `event_date`, `status`, `created_at`, `updated_at`) VALUES
(3, 'Adam', 'dadwadawda', 'Demak', '2026-04-09 15:24:00', 'upcoming', '2026-04-11 01:25:06', '2026-07-05 09:12:59'),
(5, 'Ngaji bareng', NULL, 'Gedung MWCNU Tahunan', '2026-07-05 18:00:00', 'upcoming', '2026-07-05 03:34:04', '2026-07-05 03:34:04'),
(7, 'Sorrowful reunion', 'damn', 'Home', '2026-07-02 12:00:00', 'upcoming', '2026-07-05 09:12:52', '2026-07-05 09:12:52'),
(8, 'Total Check-ins', 'dadwad', 'dwada', '2026-08-06 12:00:00', 'upcoming', '2026-07-05 09:13:07', '2026-07-05 09:13:07'),
(9, 'Norway vs Brazil', 'Erling braut haaland', 'NA', '2026-07-16 12:00:00', 'upcoming', '2026-07-05 19:12:03', '2026-07-05 19:12:03');

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

--
-- Struktur dari tabel `failed_jobs`
--

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

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

--
-- Struktur dari tabel `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `album_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `galleries`
--

INSERT INTO `galleries` (`id`, `image_path`, `created_at`, `updated_at`, `album_id`) VALUES
(2, 'galleries/39CgKKjewBhHyVmVO5zecesODMULGXHPoeMDZyHt.jpg', '2026-05-16 05:34:04', '2026-05-16 05:34:04', 0),
(3, 'galleries/nxcjzoG9izck4wEZ0hR3rEmjlnMn07aTtuDaZXX1.jpg', '2026-05-16 05:34:04', '2026-05-16 05:34:04', 0),
(4, 'galleries/yX0Td3cszvQedEbq0NatFUPoTrIN9yK0HtzoPppY.jpg', '2026-05-16 05:34:04', '2026-05-16 05:34:04', 0),
(5, 'galleries/JbxuM4jHzFQNhFP8XJa2BePNtiI2C4Bhk2FMnRFn.jpg', '2026-05-16 05:34:04', '2026-05-16 05:34:04', 0),
(6, 'galleries/WBoxZBiZCZu3Opfl0mJdZ9RyXf5gTBDlD8jHIWO2.jpg', '2026-07-02 21:09:36', '2026-07-02 21:09:36', 0),
(7, 'galleries/7iucIYqk5bpOD23pyKvxKjSZrTL048jmjrcxO7FU.jpg', '2026-07-02 21:09:36', '2026-07-02 21:09:36', 0),
(8, 'galleries/eKOuyzkoh2o2RyV8rkTsNWHy37cVHuPDcGUsMrbB.jpg', '2026-07-02 21:09:37', '2026-07-02 21:09:37', 0),
(9, 'galleries/rKMSyCrTkS0KNCq4AyRnBl9ybVLNZ6saA7LhVR0G.jpg', '2026-07-02 21:09:37', '2026-07-02 21:09:37', 0),
(10, 'galleries/kvgPdbhD8CpfgGXMJvjyUvYyDkOnCGyIwBZvSFV1.jpg', '2026-07-05 06:37:49', '2026-07-05 06:37:49', 1),
(11, 'galleries/4UMWKr5OjSLR7M1uiGxhW3qKIVlBPD1Mzl8K3ojt.jpg', '2026-07-05 06:37:50', '2026-07-05 06:37:50', 1),
(12, 'galleries/sBNdHG41CKU3oXfwKSDMhntS9TtqjXulEDTo71kS.jpg', '2026-07-05 06:37:50', '2026-07-05 06:37:50', 1),
(13, 'galleries/Y3szSQGLBlY7khSHrytTcGpEUXpMxBaDzTEJ12Gk.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(14, 'galleries/2mSak60AwdL4HCD7PvJVhzJyySHG0rGrHtzodrYZ.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(15, 'galleries/MP3odkjNqJnKsWHxbGDVPIT21hECoHvUnoKzaSeI.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(16, 'galleries/gqhlwJBFW99AYlTYY0sS4gxR3ddXaukF7UUXbyPM.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(17, 'galleries/ojRbCa45lKCGD6OzYjd3dx5b11RT6iU7iIDTkxky.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(18, 'galleries/goSfggQEXNcK2bY8TPqoGXoegVUZ8TdeFLcSOQKd.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(19, 'galleries/awaYAEDgcwRoApbilsl5FQBTRGJsfvymP2Tt2kdj.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(20, 'galleries/gguv1geUTnNRkBVWh3YBMk7rXTj6vNwm1weZX5tz.png', '2026-07-05 06:45:25', '2026-07-05 06:45:25', 3),
(21, 'galleries/gvGqhwcIAhQ1rGnZFvWwYEm9cUjOO1hriucO8JsB.png', '2026-07-05 06:45:26', '2026-07-05 06:45:26', 3),
(22, 'galleries/AlKyfcJMlR4kK7bpe1UAzoM40J204gH46Z8m85UY.png', '2026-07-05 06:45:26', '2026-07-05 06:45:26', 3),
(23, 'galleries/idGtnAQS43PYt0AqHshTpNjC5SMJKNwBLdTacdnN.jpg', '2026-07-05 06:47:02', '2026-07-05 06:47:02', 4),
(24, 'galleries/9rM8hyuP3nksUYzvDntb0vqdnXZ2cMOPr6TGBrRh.jpg', '2026-07-05 06:47:02', '2026-07-05 06:47:02', 4),
(25, 'galleries/ssAmBsy62ZAkUmE3Xv2wSffYf7dE1VUzsIXhC9MJ.jpg', '2026-07-05 06:47:02', '2026-07-05 06:47:02', 4),
(26, 'galleries/l1p8yq10Q23EOjx4MH7xVXDWLMfWkoidNDPKOOyp.jpg', '2026-07-05 06:47:02', '2026-07-05 06:47:02', 4),
(27, 'galleries/m44iuIe3YvCpFyVzuPSqv5jLjpeR5xHEy1ljrjwG.jpg', '2026-07-05 06:47:02', '2026-07-05 06:47:02', 4),
(28, 'galleries/g57k5DYFnmwR2qQgpNCpeQ1NDzVDbDwoP6pui5Vd.jpg', '2026-07-05 06:47:03', '2026-07-05 06:47:03', 4),
(29, 'galleries/soDqzPdpFCvO6JU5dMgslACkDZ9rmXhdUo4RSnBq.png', '2026-07-05 06:47:41', '2026-07-05 06:47:41', 5),
(30, 'galleries/J1xJbmqx6K2Ap9ajg6kQBBy6YM4YwxIkqDOEYrf9.png', '2026-07-05 06:47:41', '2026-07-05 06:47:41', 5),
(31, 'galleries/RJTeQJYdcLZ5DjWqrqIyImYtzb7DMHA2RHJR5POI.png', '2026-07-05 06:47:41', '2026-07-05 06:47:41', 5),
(32, 'galleries/6fS8VuG1r9wW7L8XHWik73eLyyXd8VzWcnR57kXP.png', '2026-07-05 06:47:41', '2026-07-05 06:47:41', 5),
(33, 'galleries/qGJVNGhQlEygSo8NNHolk3RXeExNl24IRKovryKH.png', '2026-07-05 06:47:41', '2026-07-05 06:47:41', 5),
(34, 'galleries/lr02Hgn5XlFKCC2I2E4WvgJk9prZHxlmyxYKZf6j.png', '2026-07-05 06:47:42', '2026-07-05 06:47:42', 5),
(35, 'galleries/RuHzFlHGf4m31jwkfqW0EhAMEJoVJHYm043owFzw.png', '2026-07-05 06:47:42', '2026-07-05 06:47:42', 5),
(36, 'galleries/Z8aFmzc7KU1cSQxyBJFjMyM366buODvxc24v7BwX.png', '2026-07-05 06:47:42', '2026-07-05 06:47:42', 5),
(37, 'galleries/pwhK7nXPSzqbw1Olzl0lBY95DW5CyMPlSMKMgea8.png', '2026-07-05 06:47:42', '2026-07-05 06:47:42', 5),
(38, 'galleries/XL7S2iHqhJxfkQQOTqygVJ5biPHmG6NGUADIoQIY.png', '2026-07-05 06:47:42', '2026-07-05 06:47:42', 5),
(39, 'galleries/Ucm2u6fSvMw9Tq8KdrqiEfBJxZW499vgecs11L2C.png', '2026-07-05 08:40:29', '2026-07-05 08:40:29', 6),
(40, 'galleries/5I7lZC7PTZq6bWLNP0e499bgkXy585mLBTpp55p3.png', '2026-07-05 08:40:29', '2026-07-05 08:40:29', 6),
(41, 'galleries/Z2jx1bgRp427509xJUfQcPst1W3NlCObMXeAix1e.png', '2026-07-05 08:40:29', '2026-07-05 08:40:29', 6),
(42, 'galleries/q3sLTkRBJg0TMhe4slCm2XrnNreLpTSXlvxrKLbC.png', '2026-07-05 08:40:29', '2026-07-05 08:40:29', 6),
(43, 'galleries/Y1Bq8YTsVe5eJjRIhBFOoNpnwAFgAFWgrCf8rn4L.png', '2026-07-05 08:40:29', '2026-07-05 08:40:29', 6),
(44, 'galleries/vszLHLwPHyV0K5OIZTMPTI8CJyoqlFFR1DjoARaa.png', '2026-07-05 08:40:29', '2026-07-05 08:40:29', 6),
(45, 'galleries/s5SiqVO7pxoX7qfxOyHg1ltmkP1RyNc97KGX918b.png', '2026-07-05 08:40:30', '2026-07-05 08:40:30', 6),
(46, 'galleries/kT7FCkkRWUdTxWHMJ7DrRgm8ZUEPgFN5TJTOYrQ0.png', '2026-07-05 09:08:51', '2026-07-05 09:08:51', 7),
(47, 'galleries/ZVK8z22E0bu6tub3BZLkVF0gyDytfOpg4mW2PIDX.png', '2026-07-05 09:08:52', '2026-07-05 09:08:52', 7),
(48, 'galleries/EHmdgFBFWmJGskXINnnAytmmTlGVMtbLFXfSjzEv.png', '2026-07-05 09:08:52', '2026-07-05 09:08:52', 7),
(49, 'galleries/E0f0v2RzCzjpUs9nTL554iyZgw3Gi4nuX8AXaqU7.png', '2026-07-05 09:08:52', '2026-07-05 09:08:52', 7),
(50, 'galleries/N881EDfZjPjo7UzuEofEOx6VYsIcOimxr88YwzlE.png', '2026-07-05 09:08:52', '2026-07-05 09:08:52', 7),
(51, 'galleries/bV0NYAuENqFYyCRrOGIm8Dc8p0GaTvJKgHS9vOQT.png', '2026-07-05 09:08:52', '2026-07-05 09:08:52', 7),
(52, 'galleries/A5zk8ctkSkB7wFv1wI6s1U48LPvXLB6HDlvHT4Y2.png', '2026-07-05 09:08:53', '2026-07-05 09:08:53', 7),
(53, 'galleries/apJ941RVx9xLrdW7IMzoGnbhJmFRlo1tIpLWzhCk.png', '2026-07-05 09:08:53', '2026-07-05 09:08:53', 7),
(54, 'galleries/fbVSdC2HysKnHXOjRR3SnxHLEkpTFm4zrMYp7KxQ.png', '2026-07-05 09:08:53', '2026-07-05 09:08:53', 7),
(55, 'galleries/22xz8pE0cGTUTFcpAMeXAUghnutncbeTpij8tO54.jpg', '2026-07-05 09:10:51', '2026-07-05 09:10:51', 8),
(56, 'galleries/KzIPrxoUQieDs1JgTXa0ZthJvZKadXO2NC1i3DXt.jpg', '2026-07-05 09:10:51', '2026-07-05 09:10:51', 8),
(57, 'galleries/X2egjIvemB9UtyDRdyqKn9N2RC1hZdFtvTInG9WE.jpg', '2026-07-05 09:10:51', '2026-07-05 09:10:51', 8),
(58, 'galleries/9B5B6w8udtkQrEZ4jAYfWfxavmKJL2FXGAjk0I3y.jpg', '2026-07-05 09:10:51', '2026-07-05 09:10:51', 8),
(59, 'galleries/WEffipcxMF5wQQeVxcqOePD9GsNGk2cPhCOp3R5h.jpg', '2026-07-05 09:10:52', '2026-07-05 09:10:52', 8),
(60, 'galleries/QE07Tr77amesfEWyBWww9aVs8H85okQNrCnjngpg.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(61, 'galleries/YhgFfDjgDr8T2YzjGy2X2z2whuDPtriTLxCejicc.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(62, 'galleries/IYcBEfFUQTJB6ATrO6WEqcFRFUWoMSFRrzZYLA0w.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(63, 'galleries/pfIzMLkdYJr5pFH865QkBoD6m586575iLPyoElcg.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(64, 'galleries/4UwomqMekeeqa9CpKzkjIgJbM1N159HNFs2q5yqH.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(65, 'galleries/zMZzOMJv4L71Tu3Ut4ljDPYlVj7eVxZqKElXbNdl.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(66, 'galleries/ksUaYBE21OvGLmipO4Q39FKfmUaiOF1o2a5v9ck4.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(67, 'galleries/qmbFUIAtAOl2UqFw9CgpLXCbxi4Fai6JBa4X8D51.png', '2026-07-05 09:11:30', '2026-07-05 09:11:30', 9),
(68, 'galleries/yvdePE8ywCVVo9dFb5al73OADH7RJ5xmjvUGRLZe.png', '2026-07-05 19:10:16', '2026-07-05 19:10:16', 10),
(69, 'galleries/Js5WiqK69XrqUtW2Hp0bLEuezasH3fcUAzRKV26T.png', '2026-07-05 19:10:16', '2026-07-05 19:10:16', 10),
(70, 'galleries/aXW3aDcRxGg7t4Lgdgh5ZDzwwjUDgFuRIrkV6ZxD.png', '2026-07-05 19:10:16', '2026-07-05 19:10:16', 10),
(71, 'galleries/I7ze4vD6xvcAFl6mPwfMt0AlEC2I4pdyxnGqNg5G.png', '2026-07-05 19:10:16', '2026-07-05 19:10:16', 10),
(72, 'galleries/6C5ASrjv9iDGfuycf4ZnWMMwfLAufhVbdip88Zik.png', '2026-07-05 19:10:16', '2026-07-05 19:10:16', 10),
(73, 'galleries/j1EOgDENuMRXKGzjdke9xvObSX0B7zSoUASmwIl7.png', '2026-07-05 19:10:16', '2026-07-05 19:10:16', 10),
(74, 'galleries/KBm7x2caso0lnMgpdtzccVlYNFitzLYWjWJMZq4L.png', '2026-07-05 19:10:17', '2026-07-05 19:10:17', 10),
(75, 'galleries/5EQqmQvgFXhNZ31fwsZfwCJjsxrDK6seVfVN1ZIu.png', '2026-07-05 19:10:17', '2026-07-05 19:10:17', 10),
(76, 'galleries/qCe242p2Ww2Hekua4OoeSpUWyJOl2mP2R0kxPSuH.png', '2026-07-05 19:10:17', '2026-07-05 19:10:17', 10),
(77, 'galleries/WfuA4dEVJoeOg23LdyZHEFJpN0qGCZOvqxIqnRuS.jpg', '2026-07-22 00:09:49', '2026-07-22 00:09:49', 11),
(78, 'galleries/f5OV0x2Hv5lK7vSpAOzIV4afv5gNqO9yyr8u8abr.jpg', '2026-07-22 00:09:49', '2026-07-22 00:09:49', 11),
(79, 'galleries/iEus6F71VB9zt3ZJGvrRncCuEtOUvLeXGwEJaFZ4.jpg', '2026-07-22 00:09:49', '2026-07-22 00:09:49', 11),
(80, 'galleries/fE3cY8FR2PleIzv93xTaMRD6H5ziuvxkrUNGoWEO.jpg', '2026-07-22 00:09:49', '2026-07-22 00:09:49', 11),
(81, 'galleries/mtz8Pr9UjJFKXB9iIOunYm6T0rhDwxpypKu5LxaX.jpg', '2026-07-22 00:09:49', '2026-07-22 00:09:49', 11),
(82, 'galleries/vaxZo2p1Vh5sLy1P5gqJCaN9wY8iCHtpQq1mTJcf.jpg', '2026-07-22 00:09:49', '2026-07-22 00:09:49', 11);

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

--
-- Struktur dari tabel `jobs`
--

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

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

--
-- Struktur dari tabel `job_batches`
--

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

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

--
-- Struktur dari tabel `migrations`
--

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

--
-- Dumping data untuk tabel `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_03_01_144021_create_articles_table', 1),
(5, '2026_03_01_144029_create_events_table', 1),
(6, '2026_05_16_101720_create_penguruses_table', 2),
(7, '2026_05_16_101724_create_galleries_table', 2),
(8, '2026_05_16_103737_add_jenis_to_articles_table', 2),
(9, '2026_05_16_122659_restructure_gallery_and_articles', 3),
(10, '2026_05_16_122705_create_article_images_table', 3),
(11, '2026_07_05_092925_add_position_to_pengurus_table', 4),
(12, '2026_07_05_104407_create_albums_table', 5),
(13, '2026_07_05_131741_setup_album_dan_galeri', 6),
(14, '2026_07_05_134114_add_deskripsi_ke_albums', 7),
(15, '2026_07_05_143308_add_images_to_articles_table', 8),
(16, '2026_07_05_150429_add_images_to_articles_table', 8);

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

--
-- Struktur dari tabel `pengurus`
--

CREATE TABLE `pengurus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `kategori` enum('PAC','Lembaga') NOT NULL,
  `bidang` varchar(255) DEFAULT NULL,
  `jabatan` varchar(255) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `pengurus`
--

INSERT INTO `pengurus` (`id`, `kategori`, `bidang`, `jabatan`, `nama`, `created_at`, `updated_at`, `position`) VALUES
(11, 'PAC', NULL, 'Penasehat', 'KH. Misbahudin', '2026-05-16 04:54:04', '2026-07-05 19:12:52', 1),
(12, 'PAC', NULL, 'Penasehat', 'Hj. Siti Rujayani, M.Pd.I', '2026-05-16 04:54:15', '2026-07-05 19:12:52', 2),
(13, 'PAC', NULL, 'Pembina', 'Siti Muyassaroh, S.Ag', '2026-05-16 04:54:59', '2026-07-05 19:12:53', 3),
(14, 'PAC', NULL, 'Pembina', 'Siti Muyassaroh, S.Ag', '2026-05-16 04:55:00', '2026-07-05 19:12:53', 4),
(15, 'PAC', NULL, 'Pembina', 'Halimatus Sa\'diyyah, S.Pd.l', '2026-05-16 04:55:55', '2026-07-05 19:12:53', 5),
(16, 'PAC', NULL, 'Dewan Kehormatan', 'Hj. Nanik, S.Pd., M.Pd.', '2026-05-16 04:56:14', '2026-07-05 19:12:53', 6),
(17, 'PAC', NULL, 'Ketua', 'Rachisatul Wachidah, S.Pd.', '2026-05-16 04:56:33', '2026-07-05 19:12:53', 7),
(18, 'PAC', NULL, 'Wakil Ketua I', 'Nzahlati', '2026-05-16 04:57:49', '2026-07-05 19:12:53', 9),
(19, 'PAC', NULL, 'Wakil Ketua II', 'Khoiriyyah Qurba, S.Pd', '2026-05-16 04:57:59', '2026-07-05 19:12:53', 10),
(20, 'PAC', NULL, 'Sekretaris', 'Nur Hikmah, S.E, M.E.', '2026-05-16 04:58:25', '2026-07-05 19:12:53', 11),
(21, 'PAC', NULL, 'Wakil Sekretaris I', 'Siti Ulfah, S.I.Kom', '2026-05-16 04:58:40', '2026-07-05 19:12:53', 12),
(22, 'PAC', NULL, 'Wakil Sekretaris II', 'Nurmala Fadhilah Jaya, S.Tr., Keb., AH', '2026-05-16 05:00:48', '2026-07-05 19:12:53', 13),
(23, 'PAC', NULL, 'Bendahara', 'Tria Efiana', '2026-05-16 05:01:00', '2026-07-05 19:12:53', 14),
(24, 'PAC', NULL, 'Wakil Bendahara', 'Siti Zumiatun', '2026-05-16 05:01:10', '2026-07-05 19:12:54', 15),
(25, 'PAC', NULL, 'Wakil Bendahara', 'Hj. Sri Endah Wahyuningsih', '2026-05-16 05:01:18', '2026-07-05 19:12:54', 16),
(26, 'PAC', 'Bidang Pengembangan Organisasi dan Pengkaderan', 'Koordinator', 'Naili Ni\'mah, S.Sy', '2026-05-16 05:01:37', '2026-05-16 05:01:37', 0),
(27, 'PAC', 'Bidang Pengembangan Organisasi dan Pengkaderan', 'Wakil Koordinator', 'Khusnul Khotimah, S.Pd.l', '2026-05-16 05:01:51', '2026-05-16 05:01:51', 0),
(28, 'PAC', 'Bidang Pengembangan Organisasi dan Pengkaderan', 'Anggota', 'Choifah, S.Pd., M.Pd', '2026-05-16 05:02:01', '2026-05-16 05:02:01', 0),
(29, 'PAC', 'Bidang Pengembangan Organisasi dan Pengkaderan', 'Anggota', 'Iis Maesaroh', '2026-05-16 05:07:07', '2026-05-16 05:07:07', 0),
(30, 'PAC', 'Bidang Pendidikan dan Dakwah', 'Koordinator', 'Mufida Sholikhatin', '2026-05-16 05:07:18', '2026-05-16 05:07:18', 0),
(31, 'PAC', 'Bidang Pendidikan dan Dakwah', 'Wakil Koordinator', 'Hj. Afifah', '2026-05-16 05:07:31', '2026-05-16 05:07:31', 0),
(32, 'PAC', 'Bidang Pendidikan dan Dakwah', 'Anggota', 'Alfiatur Rohmah, S.Pd', '2026-05-16 05:07:45', '2026-05-16 05:07:45', 0),
(33, 'PAC', 'Bidang Kesehatan dan Lingkungan Hidup', 'Koordinator', 'Ariana Riansa', '2026-05-16 05:08:28', '2026-05-16 05:08:28', 0),
(34, 'PAC', 'Bidang Kesehatan dan Lingkungan Hidup', 'Wakil Koordinator', 'Kurnia Fitri Setia Umi, Amd., Keb', '2026-05-16 05:08:45', '2026-05-16 05:08:45', 0),
(35, 'PAC', 'Bidang Kesehatan dan Lingkungan Hidup', 'Anggota', 'Ika Riyanasari, S.E', '2026-05-16 05:08:56', '2026-05-16 05:08:56', 0),
(36, 'PAC', 'Bidang Kesehatan dan Lingkungan Hidup', 'Anggota', 'Evi Wulandari', '2026-05-16 05:09:08', '2026-05-16 05:09:08', 0),
(49, 'Lembaga', NULL, 'Penanggungjawab', 'Rachisatul Wachidah, S.Pd', '2026-07-05 03:17:17', '2026-07-05 03:21:57', 1),
(50, 'Lembaga', 'Ikatan Alumni Fatayat Nahdlatul Ulama (IAF NU)', 'Koordinator', 'Hj. Siti Fadhilah, SE, S.Pd.', '2026-07-05 03:17:17', '2026-07-05 03:17:17', 2),
(51, 'Lembaga', 'Ikatan Alumni Fatayat Nahdlatul Ulama (IAF NU)', 'Anggota', 'Hidayatul Ismiyah', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 3),
(52, 'Lembaga', 'Ikatan Alumni Fatayat Nahdlatul Ulama (IAF NU)', 'Anggota', 'Muntianah', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 4),
(53, 'Lembaga', 'Forum Da’iyah Fatayat Nahdlatul Ulama (FORDAF)', 'Koordinator', 'Siti Hidayati', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 5),
(54, 'Lembaga', 'Forum Da’iyah Fatayat Nahdlatul Ulama (FORDAF)', 'Anggota', 'Siti Mastukah', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 6),
(55, 'Lembaga', 'Forum Da’iyah Fatayat Nahdlatul Ulama (FORDAF)', 'Anggota', 'Untsa Nailil Muna, S.Pd.I.', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 7),
(56, 'Lembaga', 'Ikatan Hafidhoh Fatayat Nahdlatul Ulama (IHF)', 'Koordinator', 'Alfiyah, AH.', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 8),
(57, 'Lembaga', 'Ikatan Hafidhoh Fatayat Nahdlatul Ulama (IHF)', 'Anggota', 'Hj. Istikharatul Lutfiana Junaidi, AH.', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 9),
(58, 'Lembaga', 'Ikatan Hafidhoh Fatayat Nahdlatul Ulama (IHF)', 'Anggota', 'Siti Rofiatul Hanik, S.Pd., AH.', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 10),
(59, 'Lembaga', 'Koperasi', 'Koordinator', 'Sofiatun, S.Pd.I, M.Pd', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 11),
(60, 'Lembaga', 'Koperasi', 'Anggota', 'Wiwit Silviyani, S.Ak', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 12),
(61, 'Lembaga', 'Koperasi', 'Anggota', 'Mukhoyyaroh', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 13),
(62, 'Lembaga', 'Lembaga Konsultasi Pemberdayaan Perempuan dan Perlindungan Anak (LKP3A)', 'Koordinator', 'Nur Eva Nisfianti, S.Pd', '2026-07-05 03:17:18', '2026-07-05 03:17:18', 14),
(63, 'Lembaga', 'Lembaga Konsultasi Pemberdayaan Perempuan dan Perlindungan Anak (LKP3A)', 'Anggota', 'Nur Azizah, S.Pd.I, S.Pd.', '2026-07-05 03:17:19', '2026-07-05 03:17:19', 15),
(64, 'Lembaga', 'Lembaga Konsultasi Pemberdayaan Perempuan dan Perlindungan Anak (LKP3A)', 'Anggota', 'Susianik', '2026-07-05 03:17:19', '2026-07-05 03:17:19', 16),
(65, 'Lembaga', 'Garda Fatayat (GARFA)', 'Komandan', 'Sa\'diyah', '2026-07-05 03:17:19', '2026-07-05 03:17:19', 17),
(66, 'Lembaga', 'Garda Fatayat (GARFA)', 'Wakil Komandan', 'Fitriyatus Sholikah', '2026-07-05 03:17:19', '2026-07-05 03:17:19', 18),
(67, 'Lembaga', 'Garda Fatayat (GARFA)', 'Anggota', 'Ani Muflihah, S.Pd', '2026-07-05 03:17:19', '2026-07-05 03:17:19', 19),
(68, 'Lembaga', 'Garda Fatayat (GARFA)', 'Anggota', 'Hj. Anik W', '2026-07-05 03:17:19', '2026-07-05 03:17:19', 20);

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

--
-- Struktur dari tabel `sessions`
--

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

--
-- Dumping data untuk tabel `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('cveu4YzFCMcucMvMaC2Y8bEYyblThBI87dTenRYq', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.129.1 Chrome/148.0.7778.280 Electron/42.6.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibHRzZmlPa1k2UWRKSVc0YUdnV3V3bkV6OVJYWE9ZZGFmcjJkcUxQcSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9nYWxlcmkiO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6RUpXNVBsVnMwVG4wN3hLYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1784786441),
('jfatxesWmTR3FcmpU4ihOXHjSiFJHSkBuaA66P9X', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSHpWcDUzYklqZmZXSFlOaDR4NHhoblBVOHBTSFhRM204TzlFQ0RRZSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9nYWxlcmkiO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6RUpXNVBsVnMwVG4wN3hLYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjA6e31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1784707472),
('lU07oNJ4P3ccYfvsn2r2Asge4j2TNloYnZkzn9uK', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiMkY2UFR2OGR5alU0cTl0WnFoZWlDSUE0S25tUzVHaEJnQVM2cTRCSSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9iZXJpdGEiO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6ZkplMkpNU3BFdlB1RTZTVCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjA6e31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1784787080);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `albums`
--
ALTER TABLE `albums`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `articles`
--
ALTER TABLE `articles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `articles_slug_unique` (`slug`);

--
-- Indeks untuk tabel `article_images`
--
ALTER TABLE `article_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `article_images_article_id_foreign` (`article_id`);

--
-- Indeks untuk tabel `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indeks untuk tabel `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `pengurus`
--
ALTER TABLE `pengurus`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `albums`
--
ALTER TABLE `albums`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `articles`
--
ALTER TABLE `articles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT untuk tabel `article_images`
--
ALTER TABLE `article_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `events`
--
ALTER TABLE `events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT untuk tabel `pengurus`
--
ALTER TABLE `pengurus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `article_images`
--
ALTER TABLE `article_images`
  ADD CONSTRAINT `article_images_article_id_foreign` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE;
COMMIT;

