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

START TRANSACTION;



--
-- Database: `kemangsari`
--

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `action` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED 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_logs`
--

INSERT INTO `activity_logs` (`id`, `action`, `description`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Update Blog', 'Blog \"SHARING SESSIION\" telah diperbarui', 4, '2025-12-10 19:17:29', '2025-12-10 19:17:29'),
(2, 'Tambah Blog', 'Blog berjudul \"sosialisasi\" berhasil ditambahkan', 4, '2025-12-17 19:31:28', '2025-12-17 19:31:28'),
(3, 'Tambah Blog', 'Blog berjudul \"isra mi\'raj\" berhasil ditambahkan', 4, '2026-01-09 00:26:21', '2026-01-09 00:26:21'),
(4, 'Tambah Galeri', 'Galeri \"kemah\" berhasil ditambahkan', 4, '2026-01-09 00:44:54', '2026-01-09 00:44:54'),
(5, 'Hapus Galeri', 'Galeri \"kemah\" telah dihapus', 4, '2026-01-14 04:46:36', '2026-01-14 04:46:36'),
(6, 'Hapus Blog', 'Blog \"kunjungan\" telah dihapus', 4, '2026-01-15 03:03:16', '2026-01-15 03:03:16'),
(7, 'Hapus Blog', 'Blog \"edukasi\" telah dihapus', 4, '2026-01-15 03:03:23', '2026-01-15 03:03:23'),
(8, 'Hapus Blog', 'Blog \"SHARING SESSIION\" telah dihapus', 4, '2026-01-15 03:03:29', '2026-01-15 03:03:29'),
(9, 'Tambah Galeri', 'Galeri \"Isra Miraj 2026\" berhasil ditambahkan', 4, '2026-01-19 17:29:43', '2026-01-19 17:29:43'),
(10, 'Hapus Galeri', 'Galeri \"sharing\" telah dihapus', 4, '2026-01-19 17:30:26', '2026-01-19 17:30:26'),
(11, 'Hapus Galeri', 'Galeri \"Kampoeng Cireundeuu\" telah dihapus', 4, '2026-01-19 17:30:32', '2026-01-19 17:30:32'),
(12, 'Hapus Galeri', 'Galeri \"karang taruna\" telah dihapus', 4, '2026-01-19 17:30:36', '2026-01-19 17:30:36'),
(13, 'Hapus Galeri', 'Galeri \"edukasi\" telah dihapus', 4, '2026-01-19 17:30:40', '2026-01-19 17:30:40'),
(14, 'Tambah Galeri', 'Galeri \"imunisasi\" berhasil ditambahkan', 4, '2026-01-20 02:31:44', '2026-01-20 02:31:44'),
(15, 'Update Galeri', 'Galeri \"imunisasi\" telah diperbarui', 4, '2026-01-20 09:50:20', '2026-01-20 09:50:20'),
(16, 'Update Galeri', 'Galeri \"Isra Miraj 2026\" telah diperbarui', 4, '2026-01-20 09:50:28', '2026-01-20 09:50:28'),
(17, 'Tambah Galeri', 'Galeri \"tets\" berhasil ditambahkan', 4, '2026-01-20 09:50:45', '2026-01-20 09:50:45'),
(18, 'Tambah Galeri', 'Galeri \"satu\" berhasil ditambahkan', 4, '2026-01-20 09:51:07', '2026-01-20 09:51:07'),
(19, 'Update Galeri', 'Galeri \"imunisasi\" telah diperbarui', 4, '2026-01-20 09:51:21', '2026-01-20 09:51:21'),
(20, 'Tambah Galeri', 'Galeri \"dua\" berhasil ditambahkan', 4, '2026-01-20 09:53:34', '2026-01-20 09:53:34'),
(21, 'Update Galeri', 'Galeri \"tiga\" telah diperbarui', 4, '2026-01-20 09:53:45', '2026-01-20 09:53:45'),
(22, 'Update Galeri', 'Galeri \"empat\" telah diperbarui', 4, '2026-01-20 09:53:53', '2026-01-20 09:53:53'),
(23, 'Update Galeri', 'Galeri \"lima\" telah diperbarui', 4, '2026-01-20 09:54:01', '2026-01-20 09:54:01'),
(24, 'Update Galeri', 'Galeri \"satu\" telah diperbarui', 4, '2026-01-20 09:54:32', '2026-01-20 09:54:32'),
(25, 'Update Galeri', 'Galeri \"dua\" telah diperbarui', 4, '2026-01-20 09:54:39', '2026-01-20 09:54:39'),
(26, 'Update Blog', 'Blog \"satu\" telah diperbarui', 4, '2026-01-20 09:55:21', '2026-01-20 09:55:21'),
(27, 'Update Blog', 'Blog \"dua\" telah diperbarui', 4, '2026-01-20 09:55:42', '2026-01-20 09:55:42'),
(28, 'Update Blog', 'Blog \"tiga\" telah diperbarui', 4, '2026-01-20 09:56:08', '2026-01-20 09:56:08'),
(29, 'Update Blog', 'Blog \"empat\" telah diperbarui', 4, '2026-01-20 09:56:27', '2026-01-20 09:56:27'),
(30, 'Update Blog', 'Blog \"satu\" telah diperbarui', 4, '2026-01-20 10:02:49', '2026-01-20 10:02:49'),
(31, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-01-22 22:46:05', '2026-01-22 22:46:05'),
(32, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-01-22 22:46:39', '2026-01-22 22:46:39'),
(33, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-01-22 22:46:58', '2026-01-22 22:46:58'),
(34, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-01-22 22:47:12', '2026-01-22 22:47:12'),
(35, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-01-22 22:47:32', '2026-01-22 22:47:32'),
(36, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-24 18:32:23', '2026-02-24 18:32:23'),
(37, 'Tambah Blog', 'Blog berjudul \"lima\" berhasil ditambahkan', 4, '2026-02-24 21:48:35', '2026-02-24 21:48:35'),
(38, 'Update Blog', 'Blog \"lima\" telah diperbarui', 4, '2026-02-24 22:05:48', '2026-02-24 22:05:48'),
(39, 'Hapus Galeri', 'Foto galeri berhasil dihapus', 4, '2026-02-24 22:06:01', '2026-02-24 22:06:01'),
(40, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-02-24 22:15:21', '2026-02-24 22:15:21'),
(41, 'Hapus Galeri', 'Foto galeri berhasil dihapus', 4, '2026-02-24 22:47:21', '2026-02-24 22:47:21'),
(42, 'Hapus Galeri', 'Foto galeri berhasil dihapus', 4, '2026-02-24 22:47:29', '2026-02-24 22:47:29'),
(43, 'Hapus Galeri', 'Foto galeri berhasil dihapus', 4, '2026-02-24 22:47:43', '2026-02-24 22:47:43'),
(44, 'Hapus Galeri', 'Foto galeri berhasil dihapus', 4, '2026-02-24 22:47:49', '2026-02-24 22:47:49'),
(45, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-24 22:48:08', '2026-02-24 22:48:08'),
(46, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-02-25 00:04:07', '2026-02-25 00:04:07'),
(47, 'Update Galeri', 'Foto galeri berhasil diperbarui', 4, '2026-02-25 00:04:14', '2026-02-25 00:04:14'),
(48, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-25 00:04:21', '2026-02-25 00:04:21'),
(49, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-25 00:04:28', '2026-02-25 00:04:28'),
(50, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-25 00:04:34', '2026-02-25 00:04:34'),
(51, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-25 00:06:07', '2026-02-25 00:06:07'),
(52, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-25 00:06:13', '2026-02-25 00:06:13'),
(53, 'Tambah Galeri', 'Berhasil menambahkan foto galeri', 4, '2026-02-25 00:06:19', '2026-02-25 00:06:19'),
(54, 'Update Blog', 'Blog \"lima\" telah diperbarui', 4, '2026-02-25 00:06:56', '2026-02-25 00:06:56'),
(55, 'Update Blog', 'Blog \"satu\" telah diperbarui', 4, '2026-02-25 00:07:09', '2026-02-25 00:07:09'),
(56, 'Update Blog', 'Blog \"dua\" telah diperbarui', 4, '2026-02-25 00:07:19', '2026-02-25 00:07:19'),
(57, 'Update Blog', 'Blog \"tiga\" telah diperbarui', 4, '2026-02-25 00:07:28', '2026-02-25 00:07:28'),
(58, 'Hapus Blog', 'Blog \"empat\" telah dihapus', 4, '2026-02-25 00:07:31', '2026-02-25 00:07:31'),
(59, 'Update Blog', 'Blog \"Gotong Royong\" telah diperbarui', 4, '2026-02-25 00:07:56', '2026-02-25 00:07:56'),
(60, 'Update Blog', 'Blog \"17 Agustusan\" telah diperbarui', 4, '2026-02-25 00:08:08', '2026-02-25 00:08:08'),
(61, 'Update Blog', 'Blog \"Bersih-Bersih Lingkungan\" telah diperbarui', 4, '2026-02-25 00:08:29', '2026-02-25 00:08:29'),
(62, 'Update Blog', 'Blog \"Pemandangan Pagi hari\" telah diperbarui', 4, '2026-02-25 00:08:40', '2026-02-25 00:08:40');

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

--
-- Table structure for table `apbdes`
--

CREATE TABLE `apbdes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tahun` year(4) NOT NULL,
  `kategori` enum('Pendapatan','Belanja','Pembiayaan') NOT NULL,
  `kode_rekening` varchar(255) DEFAULT NULL,
  `uraian` varchar(255) NOT NULL,
  `anggaran` decimal(15,2) NOT NULL DEFAULT 0.00,
  `realisasi` decimal(15,2) NOT NULL DEFAULT 0.00,
  `sisa` decimal(15,2) NOT NULL DEFAULT 0.00,
  `keterangan` text DEFAULT NULL,
  `urutan` int(11) 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 `apbdes`
--

INSERT INTO `apbdes` (`id`, `tahun`, `kategori`, `kode_rekening`, `uraian`, `anggaran`, `realisasi`, `sisa`, `keterangan`, `urutan`, `created_at`, `updated_at`) VALUES
(1, '2025', 'Pembiayaan', '1.1.0.1.2.4', 'PEMBIYAAN JALAN', 100000.00, 10000.00, 90000.00, 'PEMBIYAAN', 1, '2025-12-23 00:20:54', '2025-12-23 00:20:54');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `excerpt` text DEFAULT NULL,
  `content` longtext NOT NULL,
  `date` date DEFAULT NULL,
  `views` bigint(20) UNSIGNED 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 `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `slug`, `thumbnail`, `excerpt`, `content`, `date`, `views`, `created_at`, `updated_at`) VALUES
(10, 'Bersih-Bersih Lingkungan', 'imunisasi', '1772003239_o9b5qgakwplkglo.jpeg', 'imunisasi ini bertujuan untuk', 'dgdgdgjd', '2025-12-23', 16, '2025-12-23 06:28:05', '2026-07-03 00:48:17'),
(11, 'Pemandangan Pagi hari', '17-agustus-2025', '1772003248_Lanskap-Persawahan-Terasering-Karpet-Hijau-yang-Menakjubkan.png', 'Hari Kemerdekaan', 'Testing', '2025-12-23', 16, '2025-12-23 06:35:27', '2026-07-03 00:48:17'),
(12, '17 Agustusan', 'isra-miraj', '1772003229_477bda60-e96d-45b5-9cb3-eb3862b94c11.jpg', 'peringatan isra mi\'raj 2026', 'memperingati hari besar', '2026-01-09', 16, '2026-01-09 00:26:21', '2026-07-03 00:48:17'),
(13, 'Gotong Royong', 'lima', '1772003216_o9b5qgakwplkglo.jpeg', 'jalan jalan', 'ini bertujuan untuk', '2026-02-25', 10, '2026-02-24 21:48:35', '2026-07-03 00:48:17');

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

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `comment` text 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 `blog_likes`
--

CREATE TABLE `blog_likes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` 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;

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `galeris`
--

CREATE TABLE `galeris` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `gambar` 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;

--
-- Dumping data for table `galeris`
--

INSERT INTO `galeris` (`id`, `gambar`, `created_at`, `updated_at`) VALUES
(14, '1772003054_Lanskap-Persawahan-Terasering-Karpet-Hijau-yang-Menakjubkan.png', '2026-01-22 22:00:09', '2026-02-25 00:04:14'),
(16, '1772003047_hq720.jpg', '2026-02-24 22:48:08', '2026-02-25 00:04:07'),
(17, '1772003061_desktop-wallpaper-landscape-sawah.jpg', '2026-02-25 00:04:21', '2026-02-25 00:04:21'),
(18, '1772003068_no_brand_lukisan_pemandangan_sawah_padi_menguning_dengan_desain_realistis_dan_kontemporer_full01_bax47qzh.jpg', '2026-02-25 00:04:28', '2026-02-25 00:04:28'),
(19, '1772003074_fields-houses-paddy-wallpaper-preview.jpg', '2026-02-25 00:04:34', '2026-02-25 00:04:34'),
(20, '1772003167_images.jpg', '2026-02-25 00:06:07', '2026-02-25 00:06:07'),
(21, '1772003173_477bda60-e96d-45b5-9cb3-eb3862b94c11.jpg', '2026-02-25 00:06:13', '2026-02-25 00:06:13'),
(22, '1772003179_o9b5qgakwplkglo.jpeg', '2026-02-25 00:06:19', '2026-02-25 00:06:19');

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

--
-- Table structure for table `hero_sliders`
--

CREATE TABLE `hero_sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `judul` varchar(255) DEFAULT NULL,
  `deskripsi` text DEFAULT NULL,
  `gambar` varchar(255) NOT NULL,
  `urutan` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `hero_sliders`
--

INSERT INTO `hero_sliders` (`id`, `judul`, `deskripsi`, `gambar`, `urutan`, `is_active`, `created_at`, `updated_at`) VALUES
(14, 'Selamat Datang di Website Perumahan Kemang Asri', NULL, '1772002663_Lanskap-Persawahan-Terasering-Karpet-Hijau-yang-Menakjubkan.png', 1, 1, '2026-02-24 23:57:43', '2026-02-25 00:29:33'),
(15, 'Selamat Datang di Website Perumahan Kemang Asri', NULL, '1772006825_fields-houses-paddy-wallpaper-preview.jpg', 2, 1, '2026-02-25 01:07:05', '2026-02-25 01:07:05'),
(16, 'Selamat Datang di Website Perumahan Kemang Asri', NULL, '1772006837_desktop-wallpaper-landscape-sawah.jpg', 3, 1, '2026-02-25 01:07:17', '2026-02-25 01:07:17'),
(17, 'Selamat Datang di Website Perumahan Kemang Asri', NULL, '1772006849_no_brand_lukisan_pemandangan_sawah_padi_menguning_dengan_desain_realistis_dan_kontemporer_full01_bax47qzh.jpg', 4, 1, '2026-02-25 01:07:29', '2026-02-25 01:07:29'),
(18, 'Selamat Datang di Website Perumahan Kemang Asri', NULL, '1772006886_hq720.jpg', 5, 1, '2026-02-25 01:08:06', '2026-02-25 01:08:06');

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

--
-- Table structure for table `kontaks`
--

CREATE TABLE `kontaks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `pesan` text 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 `kontaks`
--

INSERT INTO `kontaks` (`id`, `nama`, `email`, `phone`, `pesan`, `created_at`, `updated_at`) VALUES
(1, 'lala', 'lala@gmail.com', '7849027379', 'haloo selamat pagi', '2025-12-03 19:09:30', '2025-12-03 19:09:30'),
(2, 'fathimah', 'fathimah@gmail.com', '73482', 'hai halo', '2025-12-10 02:06:17', '2025-12-10 02:06:17'),
(3, 'fafthimah', 'fathimah@gmail.com', '638y', 'hai halo', '2025-12-10 02:18:01', '2025-12-10 02:18:01'),
(4, 'yaya', 'yaya@gmail.com', '648484', 'hai', '2025-12-10 19:30:04', '2025-12-10 19:30:04'),
(5, 'yaya', 'yaya@gmail.com', '73482', 'asalamualaikum', '2025-12-10 19:51:33', '2025-12-10 19:51:33');

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

--
-- Table structure for table `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 for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2025_11_21_072215_create_blogs_table', 2),
(7, '2025_11_21_073456_create_galeris_table', 3),
(8, '2025_11_21_074752_create_profiles_table', 4),
(9, '2025_11_21_075557_create_kontaks_table', 5),
(10, '2025_11_22_014842_create_roles_table', 6),
(11, '2025_11_22_014931_add_role_id_to_users_table', 7),
(12, '2025_11_24_055516_create_penduduks_table', 8),
(13, '2025_11_25_032257_add_no_kk_to_penduduks_table', 9),
(14, '2025_11_30_090143_add_kepala_keluarga_status_to_penduduks_table', 10),
(15, '2025_12_02_093439_add_profile_fields_to_users_table', 11),
(16, '2025_12_03_033426_add_role_to_users_table', 12),
(17, '2025_12_04_000000_add_death_migration_tracking_to_penduduks', 13),
(18, '2025_12_05_012428_create_spots_table', 14),
(19, '2025_12_10_063323_create_activity_logs_table', 15),
(20, '2025_12_16_081103_create_pemerintah_desas_table', 16),
(21, '2025_12_19_034419_create_blog_likes_table', 17),
(22, '2025_12_19_034504_create_blog_comments_table', 17),
(23, '2025_12_23_020448_add_agama_pekerjaan_to_penduduks_table', 18),
(24, '2025_12_23_051256_create_surats_table', 19),
(25, '2025_12_23_064539_create_umkms_table', 20),
(26, '2025_12_23_071153_create_apbdes_table', 21);

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

--
-- Table structure for table `pemerintah_desas`
--

CREATE TABLE `pemerintah_desas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama` varchar(255) NOT NULL,
  `jabatan` varchar(255) NOT NULL,
  `foto` varchar(255) NOT NULL,
  `is_active` 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 `pemerintah_desas`
--

INSERT INTO `pemerintah_desas` (`id`, `nama`, `jabatan`, `foto`, `is_active`, `created_at`, `updated_at`) VALUES
(4, 'ali', 'humas', '1772007431_ChatGPT Image Feb 25, 2026, 03_10_01 PM.png', 1, '2025-12-16 02:49:18', '2026-02-25 01:17:11'),
(5, 'lala', 'keuangan', '1772007482_ChatGPT Image Feb 25, 2026, 03_15_16 PM.png', 1, '2025-12-16 03:03:54', '2026-02-25 01:18:02'),
(9, 'iwan', 'keamanan', '1772007553_ChatGPT Image Feb 25, 2026, 03_19_00 PM.png', 1, '2025-12-16 20:48:13', '2026-02-25 01:19:13'),
(10, 'Awan Setiawan', 'Wakin RT', '1772007355_ChatGPT Image Feb 25, 2026, 03_15_07 PM.png', 1, '2025-12-23 06:38:15', '2026-02-25 01:15:55');

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

--
-- Table structure for table `penduduks`
--

CREATE TABLE `penduduks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama` varchar(255) NOT NULL,
  `no_kk` varchar(255) DEFAULT NULL,
  `nik` varchar(255) NOT NULL,
  `jenis_kelamin` enum('Laki-laki','Perempuan') NOT NULL,
  `tempat_lahir` varchar(255) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` varchar(255) NOT NULL,
  `rt` varchar(255) DEFAULT NULL,
  `rw` varchar(255) DEFAULT NULL,
  `kepala_keluarga` varchar(255) DEFAULT NULL,
  `status_pernikahan` enum('Belum Menikah','Menikah','Cerai Hidup','Cerai Mati') DEFAULT NULL,
  `agama` varchar(255) DEFAULT NULL,
  `pekerjaan` varchar(255) DEFAULT NULL,
  `status_kependudukan` enum('hidup','meninggal','pindah') NOT NULL DEFAULT 'hidup',
  `tanggal_peristiwa` date DEFAULT NULL,
  `foto` 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 for table `penduduks`
--

INSERT INTO `penduduks` (`id`, `nama`, `no_kk`, `nik`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `alamat`, `rt`, `rw`, `kepala_keluarga`, `status_pernikahan`, `agama`, `pekerjaan`, `status_kependudukan`, `tanggal_peristiwa`, `foto`, `created_at`, `updated_at`) VALUES
(4, 'yaya', NULL, '77288', 'Perempuan', 'jakarta', '2000-04-23', 'yhsybsysb', '12', '08', NULL, 'Menikah', 'Islam', 'Nelayan', 'hidup', NULL, '1764494187_OIP.jpg', '2025-11-30 02:16:28', '2025-12-22 19:06:45'),
(6, 'ibu', NULL, '54746', 'Laki-laki', 'JAKARTA', '2022-04-23', 'dbhd dd', '10', '08', NULL, NULL, NULL, NULL, 'hidup', NULL, '1764813118_OIP.jpg', '2025-12-03 18:51:58', '2025-12-12 01:00:21'),
(7, 'fathimah', NULL, '647468727', 'Perempuan', 'JAKARATA', '2002-03-31', 'nddj f', '21', '07', 'ayip', 'Belum Menikah', NULL, NULL, 'hidup', NULL, '1764817351_OIP.jpg', '2025-12-03 20:02:31', '2025-12-03 20:02:31');

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

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `judul` varchar(255) NOT NULL,
  `gambar` varchar(255) NOT NULL,
  `deskripsi` longtext 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 `profiles`
--

INSERT INTO `profiles` (`id`, `judul`, `gambar`, `deskripsi`, `created_at`, `updated_at`) VALUES
(1, 'Perumahan Kemang Asri', 'profil-desa/1771998725_logo3.png', 'Kami sampaikan selamat datang di situs web KemangSari. Kami senang Anda sudah berkunjung, semoga melalui situs web ini kami dapat memberikan segala informasi yang aktual dan terpercaya langsung dari Perumahan kami. Situs web ini merupakan salah satu wujud dari komitmen Kepala Perumahan KemangSari pada pentingnya komunikasi dan transparansi publik. Situs web ini adalah bagian dari Pelayanan Administrasi Terpadu perumahan KemangSari yang mulai diimplementasikan berbasis Teknolog', '2025-12-01 20:59:03', '2026-02-25 01:06:02');

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` 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;

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

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2025-11-21 18:52:17', '2025-11-21 18:52:17'),
(2, 'admin', '2025-11-21 18:57:59', '2025-11-21 18:57:59'),
(3, 'admin', '2025-11-21 19:00:37', '2025-11-21 19:00:37');

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

--
-- Table structure for table `sambutan_kepala_desas`
--

CREATE TABLE `sambutan_kepala_desas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_kepala_desa` varchar(255) DEFAULT NULL,
  `sambutan` text DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `jabatan` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sambutan_kepala_desas`
--

INSERT INTO `sambutan_kepala_desas` (`id`, `nama_kepala_desa`, `sambutan`, `foto`, `created_at`, `updated_at`, `jabatan`, `is_active`) VALUES
(1, 'Rohimin', 'Assalamu’alaikum warahmatullahi wabarakatuh,\r\nSalam sejahtera bagi kita semua. Pertama-tama marilah kita panjatkan puji dan syukur ke hadirat Allah SWT, karena atas rahmat dan karunia-Nya kita dapat berkumpul pada hari ini dalam keadaan sehat wal’afiat. Sebagai Ketua RT, saya mengucapkan terima kasih yang sebesar-besarnya kepada seluruh warga yang telah berpartisipasi dan mendukung setiap kegiatan yang kita laksanakan bersama. Tanpa kebersamaan, gotong royong, dan rasa peduli antar warga, lingkungan kita tidak akan menjadi tempat tinggal yang aman, nyaman, dan harmonis.\r\nSaya berharap ke depannya kita dapat terus mempererat tali silaturahmi, meningkatkan rasa kebersamaan, serta menjaga keamanan dan kebersihan lingkungan. Mari kita jadikan wilayah kita sebagai lingkungan yang tidak hanya indah secara fisik, tetapi juga hangat dalam hubungan antar warganya.\r\nApabila selama saya menjalankan amanah sebagai Ketua RW terdapat kekurangan, saya mohon maaf yang sebesar-besarnya. Kritik dan saran dari bapak/ibu semua sangat saya harapkan demi kemajuan bersama.\r\nAkhir kata, semoga setiap langkah dan upaya kita dalam membangun lingkungan ini selalu diberkahi dan membawa kebaikan bagi kita semua.\r\nWassalamu’alaikum warahmatullahi wabarakatuh.', 'sambutan/1772002825_ChatGPT Image Feb 25, 2026, 08_31_37 AM.png', '2025-12-23 19:40:04', '2026-02-25 00:00:50', 'Ketua RT 006', 1);

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

--
-- Table structure for table `spots`
--

CREATE TABLE `spots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `link` 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 for table `spots`
--

INSERT INTO `spots` (`id`, `name`, `type`, `location`, `description`, `image`, `link`, `created_at`, `updated_at`) VALUES
(1, 'Kampung Adat Cireundeu', 'wisata', 'RW 10, Kelurahan Leuwigajah, Kecamatan Cimahi Selatan, Kota Cimahi, Jawa Barat.', 'Kampung adat tradisional yang masyarakatnya secara turun‑temurun mempertahankan filosofi hidup dan pola pangan unik', 'spots/EWLYICuUQOVJIQruPZcHQ29mecwM8sEprsjdVZ68.png', 'https://www.google.co.id/maps/place/Kampung+Adat+Cireundeu/@-6.9142579,107.5225021,1251m/data=!3m1!1e3!4m5!3m4!1s0x2e68e5677feb1ae5:0xadcfb026116f3446!8m2!3d-6.9142798!4d107.523423', '2025-12-04 19:17:19', '2025-12-04 19:30:31'),
(2, 'Serba Singkong', 'kuliner', 'di dalam area Kampung Adat Cireundeu', 'Serba Singkong adalah usaha UMKM lokal di Kampung Cireundeu yang menawarkan makanan & jajanan olahan singkong', 'spots/l6kgBEbkIP6xHFMFcnKL5r97Um0xeiC3FMbN8fFC.jpg', 'https://www.google.co.id/maps/place/Kampung+Adat+Cireundeu/@-6.9142579,107.5225021,1251m/data=!3m1!1e3!4m5!3m4!1s0x2e68e5677feb1ae5:0xadcfb026116f3446!8m2!3d-6.9142798!4d107.523423', '2025-12-04 19:51:07', '2025-12-04 19:51:07'),
(3, 'Hutan kampung Cireundeu', 'wisata', 'Leuwigajah, Cimahi Selatan.', 'terdapat areal pertanian, hutan adat (leuweung), dan lingkungan alam yang cukup asri', 'spots/IDcF17ID9LotQAZooDMxm0G6eJyyHm5MnkLbAe39.jpg', 'https://www.google.co.id/maps/place/Kampung+Adat+Cireundeu/@-6.9142579,107.5225021,1251m/data=!3m1!1e3!4m5!3m4!1s0x2e68e5677feb1ae5:0xadcfb026116f3446!8m2!3d-6.9142798!4d107.523423', '2025-12-04 19:53:27', '2025-12-04 19:53:27'),
(8, 'kebun stawbery', 'wisata', 'jln cireundeu', 'dbhddhd', 'spots/vidQZPwDO51uU3K0pP1iydR9zwMPUQPuFT2V9rcs.jpg', NULL, '2025-12-18 01:55:25', '2025-12-18 01:55:25');

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

--
-- Table structure for table `statistik_penduduk`
--

CREATE TABLE `statistik_penduduk` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jenis_kelamin` enum('Laki-laki','Perempuan') NOT NULL,
  `kategori_usia` enum('Remaja','Dewasa','Lansia') NOT NULL,
  `jumlah` int(11) 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 `statistik_penduduk`
--

INSERT INTO `statistik_penduduk` (`id`, `jenis_kelamin`, `kategori_usia`, `jumlah`, `created_at`, `updated_at`) VALUES
(1, 'Laki-laki', 'Remaja', 374, '2026-01-12 20:50:39', '2026-02-24 22:49:16'),
(2, 'Laki-laki', 'Dewasa', 277, '2026-01-14 00:14:27', '2026-01-14 04:45:58'),
(3, 'Laki-laki', 'Lansia', 200, '2026-01-14 04:45:29', '2026-01-14 04:45:29'),
(4, 'Perempuan', 'Remaja', 155, '2026-01-14 04:46:06', '2026-01-14 04:46:06'),
(5, 'Perempuan', 'Dewasa', 175, '2026-01-14 04:46:13', '2026-01-14 04:46:13'),
(6, 'Perempuan', 'Lansia', 367, '2026-01-14 04:46:22', '2026-01-14 04:46:22');

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

--
-- Table structure for table `surats`
--

CREATE TABLE `surats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `kode` varchar(255) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `nik` varchar(16) NOT NULL,
  `jenis_surat` varchar(255) NOT NULL,
  `keperluan` text NOT NULL,
  `no_telp` varchar(255) DEFAULT NULL,
  `status` enum('pending','diproses','siap_diambil','selesai') NOT NULL DEFAULT 'pending',
  `catatan_admin` longtext DEFAULT NULL,
  `tanggal_diproses` timestamp NULL DEFAULT NULL,
  `tanggal_selesai` timestamp NULL 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 `surats`
--

INSERT INTO `surats` (`id`, `kode`, `nama`, `nik`, `jenis_surat`, `keperluan`, `no_telp`, `status`, `catatan_admin`, `tanggal_diproses`, `tanggal_selesai`, `created_at`, `updated_at`) VALUES
(2, 'SURAT-2025-606036', 'fathimah', '9876567891098762', 'surat_usaha', 'surat ini saya buat untuk keperluan saya untuk memabangunn sebuah usahaa', '0844868363772', 'diproses', 'mohon di tunggu buk', '2025-12-29 20:52:16', NULL, '2025-12-29 20:51:42', '2025-12-29 20:52:16'),
(3, 'SURAT-2026-546511', 'awan setiawan', '3205021507880020', 'surat_tidak_mampu', 'tolong buatkan surat itu ya', '081228768158', 'siap_diambil', 'silahkan datang ke RT terdekat karena sudah kita buatkan', NULL, '2026-01-09 00:31:49', '2026-01-09 00:30:57', '2026-01-09 00:31:49');

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

--
-- Table structure for table `umkms`
--

CREATE TABLE `umkms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_usaha` varchar(255) NOT NULL,
  `pemilik` varchar(255) NOT NULL,
  `deskripsi` text DEFAULT NULL,
  `alamat` varchar(255) NOT NULL,
  `no_telepon` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `umkms`
--

INSERT INTO `umkms` (`id`, `nama_usaha`, `pemilik`, `deskripsi`, `alamat`, `no_telepon`, `email`, `kategori`, `foto`, `instagram`, `facebook`, `whatsapp`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'kebun stawbery', 'yaya', 'gehdbdy', 'jl cireundeu', '0857657', 'yaya@gmail.com', 'Pertanian', '1766472964_rumah 5.jpg', NULL, NULL, '7397493', 1, '2025-12-22 23:56:05', '2025-12-22 23:56:05');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_comments_blog_id_foreign` (`blog_id`);

--
-- Indexes for table `blog_likes`
--
ALTER TABLE `blog_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_likes_blog_id_foreign` (`blog_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 `galeris`
--
ALTER TABLE `galeris`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- Indexes for table `penduduks`
--
ALTER TABLE `penduduks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `penduduks_nik_unique` (`nik`);

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

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

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

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

--
-- Indexes for table `statistik_penduduk`
--
ALTER TABLE `statistik_penduduk`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `statistik_penduduk_jenis_kelamin_kategori_usia_unique` (`jenis_kelamin`,`kategori_usia`);

--
-- Indexes for table `surats`
--
ALTER TABLE `surats`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `surats_kode_unique` (`kode`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `apbdes`
--
ALTER TABLE `apbdes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blog_likes`
--
ALTER TABLE `blog_likes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `galeris`
--
ALTER TABLE `galeris`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `hero_sliders`
--
ALTER TABLE `hero_sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `kontaks`
--
ALTER TABLE `kontaks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `pemerintah_desas`
--
ALTER TABLE `pemerintah_desas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `penduduks`
--
ALTER TABLE `penduduks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `profiles`
--
ALTER TABLE `profiles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `sambutan_kepala_desas`
--
ALTER TABLE `sambutan_kepala_desas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `spots`
--
ALTER TABLE `spots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `statistik_penduduk`
--
ALTER TABLE `statistik_penduduk`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `surats`
--
ALTER TABLE `surats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `umkms`
--
ALTER TABLE `umkms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD CONSTRAINT `blog_comments_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blog_likes`
--
ALTER TABLE `blog_likes`
  ADD CONSTRAINT `blog_likes_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE;
COMMIT;

