-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------


-- Dumping structure for table super-app-properti-fi.arsip_penjualans
CREATE TABLE IF NOT EXISTS `arsip_penjualans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `penjualan_id` bigint(20) unsigned NOT NULL,
  `tanggal_arsip` date NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `arsip_penjualans_penjualan_id_foreign` (`penjualan_id`),
  CONSTRAINT `arsip_penjualans_penjualan_id_foreign` FOREIGN KEY (`penjualan_id`) REFERENCES `penjualans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.arsip_penjualans: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.artikels
CREATE TABLE IF NOT EXISTS `artikels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `gambar` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `artikels_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.artikels: ~0 rows (approximately)
INSERT INTO `artikels` (`id`, `judul`, `slug`, `deskripsi`, `gambar`, `created_at`, `updated_at`) VALUES
	(1, 'Tips Membeli Rumah Subsidi', 'tips-membeli-rumah-subsidi', 'Berikut adalah tips penting sebelum membeli rumah subsidi...', '[{"judul": "Cover", "galeri": "artikel/01K38CMVHXWSGRWZD1MAG0M6X7.jpg"}, {"judul": "Gambar", "galeri": "artikel/01K38CMVJ11VTZ6TK8DD0EV4NY.jpg"}]', '2025-08-15 04:11:11', '2025-08-22 14:59:44');

-- Dumping structure for table super-app-properti-fi.bank_kerjasamas
CREATE TABLE IF NOT EXISTS `bank_kerjasamas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_bank` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cabang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.bank_kerjasamas: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.berkas_konsumens
CREATE TABLE IF NOT EXISTS `berkas_konsumens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `konsumen_id` bigint(20) unsigned NOT NULL,
  `syarat_berkas_id` bigint(20) unsigned DEFAULT NULL,
  `jenis_berkas_id` bigint(20) unsigned DEFAULT NULL,
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `berkas_konsumens_konsumen_id_foreign` (`konsumen_id`),
  KEY `berkas_konsumens_syarat_berkas_id_foreign` (`syarat_berkas_id`),
  KEY `berkas_konsumens_jenis_berkas_id_foreign` (`jenis_berkas_id`),
  CONSTRAINT `berkas_konsumens_jenis_berkas_id_foreign` FOREIGN KEY (`jenis_berkas_id`) REFERENCES `jenis_berkas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `berkas_konsumens_konsumen_id_foreign` FOREIGN KEY (`konsumen_id`) REFERENCES `konsumens` (`id`) ON DELETE CASCADE,
  CONSTRAINT `berkas_konsumens_syarat_berkas_id_foreign` FOREIGN KEY (`syarat_berkas_id`) REFERENCES `syarat_berkas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.berkas_konsumens: ~3 rows (approximately)
INSERT INTO `berkas_konsumens` (`id`, `konsumen_id`, `syarat_berkas_id`, `jenis_berkas_id`, `data`, `created_at`, `updated_at`) VALUES
	(1, 1, 3, 1, 'berkas_konsumen/01KH6RPADJ9E4WZ6BYWB9S8ECD.jpeg', '2026-02-11 23:31:31', '2026-02-11 23:31:31');
INSERT INTO `berkas_konsumens` (`id`, `konsumen_id`, `syarat_berkas_id`, `jenis_berkas_id`, `data`, `created_at`, `updated_at`) VALUES
	(2, 1, 4, 1, NULL, '2026-02-11 23:31:31', '2026-02-11 23:31:31');
INSERT INTO `berkas_konsumens` (`id`, `konsumen_id`, `syarat_berkas_id`, `jenis_berkas_id`, `data`, `created_at`, `updated_at`) VALUES
	(3, 1, NULL, NULL, NULL, '2026-02-11 23:31:31', '2026-02-11 23:31:31');
INSERT INTO `berkas_konsumens` (`id`, `konsumen_id`, `syarat_berkas_id`, `jenis_berkas_id`, `data`, `created_at`, `updated_at`) VALUES
	(4, 1, 4, 1, 'berkas_konsumen/01KH6RV58ERMDY5KS5MEHR0QGN.pdf', '2026-02-11 23:34:10', '2026-02-11 23:34:10');

-- Dumping structure for table super-app-properti-fi.biaya_operasionals
CREATE TABLE IF NOT EXISTS `biaya_operasionals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `perumahan_id` bigint(20) unsigned DEFAULT NULL,
  `kategori_id` bigint(20) unsigned NOT NULL,
  `akun_id` bigint(20) unsigned NOT NULL,
  `tanggal` date NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `bukti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('aktif','dikoreksi','dibatalkan') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aktif',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `biaya_operasionals_kategori_id_foreign` (`kategori_id`),
  KEY `biaya_operasionals_akun_id_foreign` (`akun_id`),
  KEY `biaya_operasionals_tanggal_index` (`tanggal`),
  KEY `biaya_operasionals_perumahan_id_index` (`perumahan_id`),
  CONSTRAINT `biaya_operasionals_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON DELETE CASCADE,
  CONSTRAINT `biaya_operasionals_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `keuangan_kategoris` (`id`) ON DELETE CASCADE,
  CONSTRAINT `biaya_operasionals_perumahan_id_foreign` FOREIGN KEY (`perumahan_id`) REFERENCES `perumahans` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.biaya_operasionals: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.biodata_users
CREATE TABLE IF NOT EXISTS `biodata_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `pekerja_id` bigint(20) unsigned NOT NULL,
  `no_wa` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ktp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `biodata_users_user_id_foreign` (`user_id`),
  KEY `biodata_users_pekerja_id_foreign` (`pekerja_id`),
  CONSTRAINT `biodata_users_pekerja_id_foreign` FOREIGN KEY (`pekerja_id`) REFERENCES `pekerjas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `biodata_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.biodata_users: ~0 rows (approximately)
INSERT INTO `biodata_users` (`id`, `user_id`, `pekerja_id`, `no_wa`, `alamat`, `foto`, `file_ktp`, `created_at`, `updated_at`) VALUES
	(1, 1, 2, '082180181958', 'jambi', 'BiodataUser/Foto/01KH6SAMZ7DCAPM2VF9Z1DJD0T.jpg', NULL, '2026-02-11 23:41:28', '2026-02-11 23:42:37');

-- Dumping structure for table super-app-properti-fi.bloks
CREATE TABLE IF NOT EXISTS `bloks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `klaster_id` bigint(20) unsigned DEFAULT NULL,
  `nama_blok` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bloks_klaster_id_foreign` (`klaster_id`),
  CONSTRAINT `bloks_klaster_id_foreign` FOREIGN KEY (`klaster_id`) REFERENCES `klasters` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.bloks: ~5 rows (approximately)
INSERT INTO `bloks` (`id`, `klaster_id`, `nama_blok`, `deskripsi`, `created_at`, `updated_at`) VALUES
	(3, 3, 'A', NULL, '2025-08-16 21:27:00', '2025-08-16 21:27:00');
INSERT INTO `bloks` (`id`, `klaster_id`, `nama_blok`, `deskripsi`, `created_at`, `updated_at`) VALUES
	(4, 3, 'B', NULL, '2025-08-16 21:27:03', '2025-08-16 21:27:03');
INSERT INTO `bloks` (`id`, `klaster_id`, `nama_blok`, `deskripsi`, `created_at`, `updated_at`) VALUES
	(5, 3, 'C', '-', '2025-09-07 14:36:50', '2025-09-07 14:36:50');
INSERT INTO `bloks` (`id`, `klaster_id`, `nama_blok`, `deskripsi`, `created_at`, `updated_at`) VALUES
	(6, 3, 'D', '-', '2025-09-07 14:36:50', '2025-09-07 14:36:50');
INSERT INTO `bloks` (`id`, `klaster_id`, `nama_blok`, `deskripsi`, `created_at`, `updated_at`) VALUES
	(7, 3, 'E', '-', '2025-09-07 14:36:50', '2025-09-07 14:36:50');

-- Dumping structure for table super-app-properti-fi.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.faqs
CREATE TABLE IF NOT EXISTS `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.faqs: ~10 rows (approximately)
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(5, 'Apa itu KPR subsidi?', 'KPR subsidi adalah program pembiayaan rumah dari pemerintah dengan bunga tetap rendah dan cicilan ringan untuk masyarakat berpenghasilan rendah (MBR).', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(6, 'Berapa bunga KPR subsidi?', 'Bunga KPR subsidi tetap 5% selama masa kredit sesuai ketentuan pemerintah.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(7, 'Berapa lama tenor KPR subsidi?', 'Tenor KPR subsidi bisa sampai 20 tahun, tergantung kebijakan bank dan kemampuan pembayaran.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(8, 'Siapa saja yang bisa mengajukan KPR subsidi?', 'WNI yang belum memiliki rumah, berusia minimal 21 tahun atau sudah menikah, serta memiliki penghasilan maksimal sesuai batas yang ditentukan pemerintah.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(9, 'Apa saja syarat dokumen pengajuan?', 'Fotokopi KTP, KK, NPWP, slip gaji atau surat keterangan penghasilan, dan dokumen pendukung lainnya sesuai ketentuan bank.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(10, 'Apakah ada uang muka (DP)?', 'Uang muka KPR subsidi biasanya mulai dari 1% dari harga rumah sesuai program pemerintah.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(11, 'Berapa kisaran cicilan per bulan?', 'Cicilan tergantung harga rumah dan tenor, namun umumnya mulai dari sekitar 1 jutaan per bulan.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(12, 'Apakah bisa untuk wiraswasta?', 'Bisa, selama memiliki bukti penghasilan yang jelas dan memenuhi syarat dari pihak bank.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(13, 'Berapa lama proses pengajuan KPR?', 'Proses pengajuan biasanya memakan waktu 2–4 minggu tergantung kelengkapan dokumen dan proses verifikasi bank.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');
INSERT INTO `faqs` (`id`, `question`, `answer`, `is_active`, `created_at`, `updated_at`) VALUES
	(14, 'Bagaimana cara survei lokasi perumahan?', 'Anda bisa menghubungi marketing kami melalui WhatsApp atau mengisi form booking untuk menjadwalkan kunjungan lokasi.', 1, '2026-02-11 23:40:28', '2026-02-11 23:40:28');

-- Dumping structure for table super-app-properti-fi.fee_marketings
CREATE TABLE IF NOT EXISTS `fee_marketings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kategori_id` bigint(20) unsigned NOT NULL,
  `marketing_id` bigint(20) unsigned NOT NULL,
  `penjualan_id` bigint(20) unsigned NOT NULL,
  `akun_id` bigint(20) unsigned NOT NULL,
  `tanggal` date NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `status_bayar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bukti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fee_marketings_kategori_id_foreign` (`kategori_id`),
  KEY `fee_marketings_marketing_id_foreign` (`marketing_id`),
  KEY `fee_marketings_penjualan_id_foreign` (`penjualan_id`),
  KEY `fee_marketings_akun_id_foreign` (`akun_id`),
  KEY `fee_marketings_tanggal_index` (`tanggal`),
  KEY `fee_marketings_status_bayar_index` (`status_bayar`),
  CONSTRAINT `fee_marketings_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fee_marketings_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `keuangan_kategoris` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fee_marketings_marketing_id_foreign` FOREIGN KEY (`marketing_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fee_marketings_penjualan_id_foreign` FOREIGN KEY (`penjualan_id`) REFERENCES `penjualans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.fee_marketings: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.fee_vendors
CREATE TABLE IF NOT EXISTS `fee_vendors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kategori_id` bigint(20) unsigned NOT NULL,
  `nama_vendor` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kontak` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `perumahan_id` bigint(20) unsigned DEFAULT NULL,
  `akun_id` bigint(20) unsigned NOT NULL,
  `tanggal` date NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `status_bayar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bukti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fee_vendors_kategori_id_foreign` (`kategori_id`),
  KEY `fee_vendors_perumahan_id_foreign` (`perumahan_id`),
  KEY `fee_vendors_akun_id_foreign` (`akun_id`),
  KEY `fee_vendors_tanggal_index` (`tanggal`),
  KEY `fee_vendors_status_bayar_index` (`status_bayar`),
  KEY `fee_vendors_nama_vendor_index` (`nama_vendor`),
  CONSTRAINT `fee_vendors_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fee_vendors_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `keuangan_kategoris` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fee_vendors_perumahan_id_foreign` FOREIGN KEY (`perumahan_id`) REFERENCES `perumahans` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.fee_vendors: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.jenis_berkas
CREATE TABLE IF NOT EXISTS `jenis_berkas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.jenis_berkas: ~3 rows (approximately)
INSERT INTO `jenis_berkas` (`id`, `nama`, `created_at`, `updated_at`) VALUES
	(1, 'SUBSIDI', '2025-08-15 04:11:11', '2025-08-15 04:11:11');
INSERT INTO `jenis_berkas` (`id`, `nama`, `created_at`, `updated_at`) VALUES
	(2, 'KOMERSIL', '2025-08-15 04:11:11', '2025-08-15 04:11:11');
INSERT INTO `jenis_berkas` (`id`, `nama`, `created_at`, `updated_at`) VALUES
	(3, 'NON-SUBSIDI', '2025-08-15 04:11:11', '2025-08-15 04:11:11');

-- Dumping structure for table super-app-properti-fi.jobs
CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci 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,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.jobs: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.job_batches
CREATE TABLE IF NOT EXISTS `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.job_batches: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.kas_mutasis
CREATE TABLE IF NOT EXISTS `kas_mutasis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `akun_id` bigint(20) unsigned NOT NULL,
  `transaksi_id` bigint(20) unsigned DEFAULT NULL,
  `tanggal` date NOT NULL,
  `debit` decimal(15,2) NOT NULL DEFAULT '0.00',
  `kredit` decimal(15,2) NOT NULL DEFAULT '0.00',
  `saldo_setelah` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kas_mutasis_transaksi_id_foreign` (`transaksi_id`),
  KEY `kas_mutasis_akun_id_tanggal_index` (`akun_id`,`tanggal`),
  CONSTRAINT `kas_mutasis_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON DELETE CASCADE,
  CONSTRAINT `kas_mutasis_transaksi_id_foreign` FOREIGN KEY (`transaksi_id`) REFERENCES `keuangan_transaksis` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.kas_mutasis: ~0 rows (approximately)
INSERT INTO `kas_mutasis` (`id`, `akun_id`, `transaksi_id`, `tanggal`, `debit`, `kredit`, `saldo_setelah`, `created_at`, `updated_at`) VALUES
	(1, 1, 1, '2026-02-11', 500000.00, 0.00, 1000500000.00, '2026-02-11 23:32:52', '2026-02-11 23:32:52');

-- Dumping structure for table super-app-properti-fi.keuangan_akuns
CREATE TABLE IF NOT EXISTS `keuangan_akuns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_akun` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_akun` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipe` enum('kas','bank','e-wallet') COLLATE utf8mb4_unicode_ci NOT NULL,
  `saldo_awal` decimal(15,2) NOT NULL DEFAULT '0.00',
  `saldo_akhir` decimal(15,2) NOT NULL DEFAULT '0.00',
  `is_aktif` tinyint(1) NOT NULL DEFAULT '1',
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.keuangan_akuns: ~0 rows (approximately)
INSERT INTO `keuangan_akuns` (`id`, `nama_akun`, `kode_akun`, `tipe`, `saldo_awal`, `saldo_akhir`, `is_aktif`, `keterangan`, `created_at`, `updated_at`) VALUES
	(1, 'BTN', 'BTN', 'bank', 1000000000.00, 1000500000.00, 1, 'PT GRAHA AKSATA MAHAJAYA', '2026-02-07 19:52:14', '2026-02-11 23:32:52');

-- Dumping structure for table super-app-properti-fi.keuangan_kategoris
CREATE TABLE IF NOT EXISTS `keuangan_kategoris` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_kategori` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipe` enum('pemasukan','pengeluaran','netral') COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.keuangan_kategoris: ~13 rows (approximately)
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(42, 'Booking Fee', 'pemasukan', 'booking_fee', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(43, 'Uang Muka', 'pemasukan', 'uang_muka', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(44, 'Angsuran', 'pemasukan', 'angsuran', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(45, 'Pelunasan', 'pemasukan', 'pelunasan', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(46, 'Tambahan Modal', 'pemasukan', 'setor_Tambahan_Modal', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(47, 'Setoran Investor', 'pemasukan', 'Setoran_Investor', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(48, 'Modal_Disetor', 'pemasukan', 'Modal Disetor', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(49, 'Pencairan Bank', 'pemasukan', 'pencairan_bank', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(50, 'Biaya Operasional', 'pengeluaran', 'biaya_operasional', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(51, 'Fee Marketing', 'pengeluaran', 'fee_marketing', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(52, 'Fee Vendor', 'pengeluaran', 'fee_vendor', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(53, 'Biaya Listrik', 'pengeluaran', 'biaya_listrik', '2026-02-04 00:39:26', '2026-02-04 00:39:26');
INSERT INTO `keuangan_kategoris` (`id`, `nama_kategori`, `tipe`, `kode`, `created_at`, `updated_at`) VALUES
	(54, 'Mutasi Kas', 'netral', 'kas_mutasi', '2026-02-04 00:39:26', '2026-02-04 00:39:26');

-- Dumping structure for table super-app-properti-fi.keuangan_transaksis
CREATE TABLE IF NOT EXISTS `keuangan_transaksis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `perumahan_id` bigint(20) unsigned DEFAULT NULL,
  `akun_id` bigint(20) unsigned NOT NULL,
  `kategori_id` bigint(20) unsigned NOT NULL,
  `ref_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_id` bigint(20) unsigned DEFAULT NULL,
  `tanggal` date NOT NULL,
  `tipe` enum('pemasukan','pengeluaran') COLLATE utf8mb4_unicode_ci NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `keuangan_transaksis_perumahan_id_foreign` (`perumahan_id`),
  KEY `keuangan_transaksis_akun_id_foreign` (`akun_id`),
  KEY `keuangan_transaksis_kategori_id_foreign` (`kategori_id`),
  KEY `keuangan_transaksis_ref_type_ref_id_index` (`ref_type`,`ref_id`),
  KEY `keuangan_transaksis_tanggal_index` (`tanggal`),
  CONSTRAINT `keuangan_transaksis_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON DELETE CASCADE,
  CONSTRAINT `keuangan_transaksis_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `keuangan_kategoris` (`id`) ON DELETE CASCADE,
  CONSTRAINT `keuangan_transaksis_perumahan_id_foreign` FOREIGN KEY (`perumahan_id`) REFERENCES `perumahans` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.keuangan_transaksis: ~0 rows (approximately)
INSERT INTO `keuangan_transaksis` (`id`, `perumahan_id`, `akun_id`, `kategori_id`, `ref_type`, `ref_id`, `tanggal`, `tipe`, `nominal`, `keterangan`, `created_at`, `updated_at`) VALUES
	(1, 3, 1, 42, 'App\\Models\\Penjualan', 1, '2026-02-11', 'pemasukan', 500000.00, 'Booking Fee Blok ___a01___ Perumahan __griya aksata____', '2026-02-11 23:32:52', '2026-02-11 23:32:52');

-- Dumping structure for table super-app-properti-fi.klasters
CREATE TABLE IF NOT EXISTS `klasters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `perumahan_id` bigint(20) unsigned DEFAULT NULL,
  `nama_klaster` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `klasters_perumahan_id_foreign` (`perumahan_id`),
  CONSTRAINT `klasters_perumahan_id_foreign` FOREIGN KEY (`perumahan_id`) REFERENCES `perumahans` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.klasters: ~2 rows (approximately)
INSERT INTO `klasters` (`id`, `perumahan_id`, `nama_klaster`, `deskripsi`, `created_at`, `updated_at`) VALUES
	(3, 3, 'Bahari Vilage', NULL, '2025-08-16 21:21:20', '2025-08-16 21:21:20');
INSERT INTO `klasters` (`id`, `perumahan_id`, `nama_klaster`, `deskripsi`, `created_at`, `updated_at`) VALUES
	(4, 3, 'tes', 's', '2025-09-07 15:11:14', '2025-09-07 15:11:14');

-- Dumping structure for table super-app-properti-fi.konsumens
CREATE TABLE IF NOT EXISTS `konsumens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `petugas_id` bigint(20) unsigned DEFAULT NULL,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci,
  `pekerjaan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penghasilan_bulanan` decimal(15,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `konsumens_nik_unique` (`nik`),
  KEY `konsumens_petugas_id_foreign` (`petugas_id`),
  CONSTRAINT `konsumens_petugas_id_foreign` FOREIGN KEY (`petugas_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.konsumens: ~0 rows (approximately)
INSERT INTO `konsumens` (`id`, `petugas_id`, `nama_lengkap`, `no_hp`, `nik`, `alamat`, `pekerjaan`, `penghasilan_bulanan`, `created_at`, `updated_at`) VALUES
	(1, 4, 'muhammad lukman sarip', '082180181958', '2456454545', 'Jl.Jambi Simpang III Sipin, Kec. Kota Baru, Kota Jambi, Jambi 36321', 'SSH', 400000.00, '2026-02-07 20:15:24', '2026-02-07 20:15:24');

-- Dumping structure for table super-app-properti-fi.leads
CREATE TABLE IF NOT EXISTS `leads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_followup` enum('baru','dihubungi','closing','batal') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'baru',
  `catatan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.leads: ~10 rows (approximately)
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(1, 'Budi Santoso', '081234567890', 'FB Ads', 'closing', 'Tertarik rumah tipe 36 di Project A', '2025-08-15 04:11:11', '2025-08-18 14:32:37');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(2, 'Siti Aminah', '082345678901', 'Website', 'closing', 'Minta brosur via WhatsApp', '2025-08-15 04:11:11', '2025-08-15 15:32:32');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(3, 'MUHAMMAD LUKMAN SARIP', '085215548888', 'Website', 'baru', 'Jangan ragu untuk mengirim pesan Kepada kami,\r\nJangan ragu untuk mengirim pesan Kepada kami,', '2025-08-28 01:05:52', '2025-08-28 01:05:52');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(4, 'asd', '0852155488881', 'Website', 'baru', 'asd', '2025-08-28 01:07:18', '2025-08-28 01:07:18');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(5, 'asd', '13', 'Website', 'baru', '123', '2025-08-28 01:10:38', '2025-08-28 01:10:38');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(6, 'asd', '123123', 'Website', 'baru', '213', '2025-08-28 01:12:57', '2025-08-28 01:12:57');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(7, '123', '123', 'Website', 'baru', '123', '2025-08-28 01:13:26', '2025-08-28 01:13:26');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(8, '123', '123', 'Website', 'baru', '123', '2025-09-28 01:14:17', '2025-08-28 01:14:17');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(9, 'asd', '213', 'Website', 'baru', '123', '2025-08-28 01:15:43', '2025-08-28 01:15:43');
INSERT INTO `leads` (`id`, `nama_lengkap`, `no_hp`, `sumber`, `status_followup`, `catatan`, `created_at`, `updated_at`) VALUES
	(10, '1', '1', 'Website', 'baru', '1', '2025-08-28 01:15:52', '2025-08-28 01:15:52');

-- Dumping structure for table super-app-properti-fi.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.migrations: ~49 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '0001_01_01_000000_create_users_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(2, '0001_01_01_000001_create_cache_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(3, '0001_01_01_000002_create_jobs_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(4, '2025_08_14_173122_create_pekerjas_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(5, '2025_08_14_173305_create_biodata_users_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(6, '2025_08_14_173602_create_promos_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(7, '2025_08_14_173753_create_perusahaans_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(8, '2025_08_14_173948_create_leads_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(9, '2025_08_14_174110_create_setting_webs_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(10, '2025_08_14_174243_create_testimonis_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(11, '2025_08_14_174348_create_artikels_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(12, '2025_08_15_033025_create_perumahans_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(13, '2025_08_15_033831_create_klasters_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(14, '2025_08_15_034408_create_bloks_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(15, '2025_08_15_034458_create_rumahs_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(16, '2025_08_15_035128_create_site_plans_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(17, '2025_08_15_035342_create_syarat_berkas_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(18, '2025_08_15_035444_create_jenis_berkas_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(19, '2025_08_15_035625_create_syarat_has_jenis_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(20, '2025_08_15_040332_create_konsumens_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(21, '2025_08_15_040447_create_berkas_konsumens_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(22, '2025_08_15_040554_create_penjualans_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(23, '2025_08_15_040742_create_arsip_penjualans_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(24, '2025_08_15_113803_add_meta_apiwa_pixelfb_to_setting_webs_table', 2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(25, '2025_08_18_140519_add_jenis_berkas_id_to_berkas_konsumens_table', 3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(26, '2025_08_21_152747_create_permission_tables', 4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(27, '2025_08_24_225714_add_fields_to_perumahans_table', 5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(28, '2025_08_24_232359_add_background_siteplan_to_perumahan_table', 6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(29, '2025_08_26_011840_create_faqs_table', 7);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(30, '2025_08_29_143033_add_viewbox_to_perumahans_table', 8);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(31, '2025_09_04_010315_create_breezy_tables', 9);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(32, '2025_09_09_215137_add_bukti_to_penjualans_table', 10);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(33, '2025_09_09_224800_add_rekening_to_penjualans_table', 11);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(34, '2026_01_25_144311_add_embed_video_to_perumahans_table', 12);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(35, '2026_01_25_150533_create_keuangan_akuns_table', 13);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(36, '2026_01_26_230130_create_keuangan_kategoris_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(37, '2026_01_26_230406_create_keuangan_transaksis_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(38, '2026_01_26_231150_create_kas_mutasis_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(39, '2026_01_26_231533_create_pembayaran_penjualans_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(40, '2026_01_26_231908_create_bank_kerjasamas_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(41, '2026_01_26_232012_create_pencairan_banks_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(42, '2026_01_26_232234_create_biaya_operasionals_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(43, '2026_01_26_232357_create_fee_marketings_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(44, '2026_01_26_233012_create_fee_vendors_table', 14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(45, '2026_01_28_223323_add_akun_id_to_penjualans', 15);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(46, '2026_01_29_000350_add_status_to_pembayaran_penjualans', 16);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(47, '2026_01_29_011655_add_status_to_biaya_operasionals_table', 17);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(48, '2026_01_30_114541_create_setoran_modals_table', 18);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(49, '2026_02_01_220721_add_perumahan_id_to_setoran_modals_table', 19);

-- Dumping structure for table super-app-properti-fi.model_has_permissions
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.model_has_permissions: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.model_has_roles
CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.model_has_roles: ~4 rows (approximately)
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
	(1, 'App\\Models\\User', 1);
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
	(2, 'App\\Models\\User', 2);
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
	(4, 'App\\Models\\User', 4);
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
	(5, 'App\\Models\\User', 5);

-- Dumping structure for table super-app-properti-fi.pekerjas
CREATE TABLE IF NOT EXISTS `pekerjas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.pekerjas: ~3 rows (approximately)
INSERT INTO `pekerjas` (`id`, `nama`, `created_at`, `updated_at`) VALUES
	(1, 'Admin Pemasaran', '2025-08-15 04:11:11', '2025-08-15 04:11:11');
INSERT INTO `pekerjas` (`id`, `nama`, `created_at`, `updated_at`) VALUES
	(2, 'Marketing', '2025-08-15 04:11:11', '2025-08-15 04:11:11');
INSERT INTO `pekerjas` (`id`, `nama`, `created_at`, `updated_at`) VALUES
	(3, 'Sales Freelance', '2025-08-15 04:11:11', '2025-08-15 04:11:11');

-- Dumping structure for table super-app-properti-fi.pembayaran_penjualans
CREATE TABLE IF NOT EXISTS `pembayaran_penjualans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kategori_id` bigint(20) unsigned NOT NULL,
  `penjualan_id` bigint(20) unsigned NOT NULL,
  `akun_id` bigint(20) unsigned NOT NULL,
  `tanggal` date NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `metode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `bukti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('aktif','dikoreksi','dibatalkan') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aktif',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pembayaran_penjualans_kategori_id_foreign` (`kategori_id`),
  KEY `pembayaran_penjualans_penjualan_id_foreign` (`penjualan_id`),
  KEY `pembayaran_penjualans_akun_id_foreign` (`akun_id`),
  KEY `pembayaran_penjualans_tanggal_index` (`tanggal`),
  CONSTRAINT `pembayaran_penjualans_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pembayaran_penjualans_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `keuangan_kategoris` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pembayaran_penjualans_penjualan_id_foreign` FOREIGN KEY (`penjualan_id`) REFERENCES `penjualans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.pembayaran_penjualans: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.pencairan_banks
CREATE TABLE IF NOT EXISTS `pencairan_banks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kategori_id` bigint(20) unsigned NOT NULL,
  `penjualan_id` bigint(20) unsigned NOT NULL,
  `akun_id` bigint(20) unsigned NOT NULL,
  `bank_id` bigint(20) unsigned NOT NULL,
  `tahap` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_cair` date NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `bukti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pencairan_banks_kategori_id_foreign` (`kategori_id`),
  KEY `pencairan_banks_akun_id_foreign` (`akun_id`),
  KEY `pencairan_banks_bank_id_foreign` (`bank_id`),
  KEY `pencairan_banks_penjualan_id_bank_id_index` (`penjualan_id`,`bank_id`),
  KEY `pencairan_banks_tanggal_cair_index` (`tanggal_cair`),
  KEY `pencairan_banks_status_index` (`status`),
  CONSTRAINT `pencairan_banks_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pencairan_banks_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `bank_kerjasamas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pencairan_banks_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `keuangan_kategoris` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pencairan_banks_penjualan_id_foreign` FOREIGN KEY (`penjualan_id`) REFERENCES `penjualans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.pencairan_banks: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.penjualans
CREATE TABLE IF NOT EXISTS `penjualans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `verifikator_id` bigint(20) unsigned DEFAULT NULL,
  `rumah_id` bigint(20) unsigned NOT NULL,
  `konsumen_id` bigint(20) unsigned NOT NULL,
  `biaya_booking` decimal(15,2) DEFAULT NULL,
  `tanggal_booking` date DEFAULT NULL,
  `status` enum('baru','proses_bank','disetujui','akad','serah_terima','ditolak','batal') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'baru',
  `bukti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rekening` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `akun_id` bigint(20) unsigned DEFAULT NULL,
  `catatan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `penjualans_verifikator_id_foreign` (`verifikator_id`),
  KEY `penjualans_rumah_id_foreign` (`rumah_id`),
  KEY `penjualans_konsumen_id_foreign` (`konsumen_id`),
  CONSTRAINT `penjualans_konsumen_id_foreign` FOREIGN KEY (`konsumen_id`) REFERENCES `konsumens` (`id`) ON DELETE CASCADE,
  CONSTRAINT `penjualans_rumah_id_foreign` FOREIGN KEY (`rumah_id`) REFERENCES `rumahs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `penjualans_verifikator_id_foreign` FOREIGN KEY (`verifikator_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.penjualans: ~1 rows (approximately)
INSERT INTO `penjualans` (`id`, `verifikator_id`, `rumah_id`, `konsumen_id`, `biaya_booking`, `tanggal_booking`, `status`, `bukti`, `rekening`, `akun_id`, `catatan`, `created_at`, `updated_at`) VALUES
	(1, 1, 4, 1, 500000.00, '2026-02-11', 'proses_bank', 'bukti/01KH6RRRZKETCZVWZ30WSCTTY9.pdf', NULL, 1, 'Booking Fee Blok ___a01___ Perumahan __griya aksata____', '2026-02-11 23:32:52', '2026-02-11 23:34:50');

-- Dumping structure for table super-app-properti-fi.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=394 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.permissions: ~393 rows (approximately)
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'view_role', 'web', '2025-08-21 15:28:12', '2025-08-21 15:28:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(2, 'view_any_role', 'web', '2025-08-21 15:28:12', '2025-08-21 15:28:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(3, 'create_role', 'web', '2025-08-21 15:28:12', '2025-08-21 15:28:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(4, 'update_role', 'web', '2025-08-21 15:28:12', '2025-08-21 15:28:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(5, 'delete_role', 'web', '2025-08-21 15:28:12', '2025-08-21 15:28:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(6, 'delete_any_role', 'web', '2025-08-21 15:28:12', '2025-08-21 15:28:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(7, 'view_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(8, 'view_any_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(9, 'create_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(10, 'update_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(11, 'restore_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(12, 'restore_any_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(13, 'replicate_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(14, 'reorder_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(15, 'delete_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(16, 'delete_any_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(17, 'force_delete_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(18, 'force_delete_any_arsip::penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(19, 'view_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(20, 'view_any_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(21, 'create_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(22, 'update_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(23, 'restore_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(24, 'restore_any_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(25, 'replicate_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(26, 'reorder_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(27, 'delete_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(28, 'delete_any_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(29, 'force_delete_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(30, 'force_delete_any_artikel', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(31, 'view_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(32, 'view_any_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(33, 'create_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(34, 'update_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(35, 'restore_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(36, 'restore_any_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(37, 'replicate_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(38, 'reorder_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(39, 'delete_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(40, 'delete_any_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(41, 'force_delete_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(42, 'force_delete_any_biodata::user', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(43, 'view_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(44, 'view_any_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(45, 'create_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(46, 'update_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(47, 'restore_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(48, 'restore_any_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(49, 'replicate_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(50, 'reorder_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(51, 'delete_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(52, 'delete_any_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(53, 'force_delete_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(54, 'force_delete_any_blok', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(55, 'view_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(56, 'view_any_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(57, 'create_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(58, 'update_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(59, 'restore_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(60, 'restore_any_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(61, 'replicate_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(62, 'reorder_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(63, 'delete_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(64, 'delete_any_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(65, 'force_delete_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(66, 'force_delete_any_jenis::berkas', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(67, 'view_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(68, 'view_any_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(69, 'create_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(70, 'update_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(71, 'restore_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(72, 'restore_any_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(73, 'replicate_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(74, 'reorder_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(75, 'delete_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(76, 'delete_any_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(77, 'force_delete_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(78, 'force_delete_any_klaster', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(79, 'view_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(80, 'view_any_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(81, 'create_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(82, 'update_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(83, 'restore_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(84, 'restore_any_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(85, 'replicate_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(86, 'reorder_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(87, 'delete_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(88, 'delete_any_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(89, 'force_delete_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(90, 'force_delete_any_konsumen', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(91, 'view_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(92, 'view_any_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(93, 'create_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(94, 'update_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(95, 'restore_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(96, 'restore_any_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(97, 'replicate_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(98, 'reorder_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(99, 'delete_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(100, 'delete_any_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(101, 'force_delete_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(102, 'force_delete_any_lead', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(103, 'view_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(104, 'view_any_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(105, 'create_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(106, 'update_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(107, 'restore_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(108, 'restore_any_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(109, 'replicate_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(110, 'reorder_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(111, 'delete_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(112, 'delete_any_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(113, 'force_delete_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(114, 'force_delete_any_pekerja', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(115, 'view_penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(116, 'view_any_penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(117, 'create_penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(118, 'update_penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(119, 'restore_penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(120, 'restore_any_penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(121, 'replicate_penjualan', 'web', '2025-08-21 15:29:06', '2025-08-21 15:29:06');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(122, 'reorder_penjualan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(123, 'delete_penjualan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(124, 'delete_any_penjualan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(125, 'force_delete_penjualan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(126, 'force_delete_any_penjualan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(127, 'view_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(128, 'view_any_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(129, 'create_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(130, 'update_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(131, 'restore_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(132, 'restore_any_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(133, 'replicate_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(134, 'reorder_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(135, 'delete_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(136, 'delete_any_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(137, 'force_delete_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(138, 'force_delete_any_perumahan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(139, 'view_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(140, 'view_any_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(141, 'create_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(142, 'update_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(143, 'restore_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(144, 'restore_any_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(145, 'replicate_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(146, 'reorder_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(147, 'delete_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(148, 'delete_any_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(149, 'force_delete_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(150, 'force_delete_any_perusahaan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(151, 'view_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(152, 'view_any_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(153, 'create_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(154, 'update_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(155, 'restore_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(156, 'restore_any_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(157, 'replicate_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(158, 'reorder_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(159, 'delete_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(160, 'delete_any_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(161, 'force_delete_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(162, 'force_delete_any_promo', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(163, 'view_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(164, 'view_any_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(165, 'create_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(166, 'update_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(167, 'restore_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(168, 'restore_any_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(169, 'replicate_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(170, 'reorder_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(171, 'delete_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(172, 'delete_any_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(173, 'force_delete_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(174, 'force_delete_any_rumah', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(175, 'view_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(176, 'view_any_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(177, 'create_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(178, 'update_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(179, 'restore_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(180, 'restore_any_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(181, 'replicate_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(182, 'reorder_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(183, 'delete_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(184, 'delete_any_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(185, 'force_delete_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(186, 'force_delete_any_setting::web', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(187, 'view_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(188, 'view_any_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(189, 'create_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(190, 'update_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(191, 'restore_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(192, 'restore_any_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(193, 'replicate_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(194, 'reorder_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(195, 'delete_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(196, 'delete_any_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(197, 'force_delete_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(198, 'force_delete_any_site::plan', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(199, 'view_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(200, 'view_any_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(201, 'create_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(202, 'update_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(203, 'restore_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(204, 'restore_any_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(205, 'replicate_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(206, 'reorder_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(207, 'delete_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(208, 'delete_any_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(209, 'force_delete_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(210, 'force_delete_any_syarat::berkas', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(211, 'view_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(212, 'view_any_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(213, 'create_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(214, 'update_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(215, 'restore_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(216, 'restore_any_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(217, 'replicate_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(218, 'reorder_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(219, 'delete_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(220, 'delete_any_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(221, 'force_delete_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(222, 'force_delete_any_testimoni', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(223, 'view_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(224, 'view_any_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(225, 'create_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(226, 'update_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(227, 'restore_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(228, 'restore_any_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(229, 'replicate_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(230, 'reorder_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(231, 'delete_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(232, 'delete_any_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(233, 'force_delete_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(234, 'force_delete_any_user', 'web', '2025-08-21 15:29:07', '2025-08-21 15:29:07');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(235, 'view_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(236, 'view_any_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(237, 'create_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(238, 'update_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(239, 'restore_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(240, 'restore_any_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(241, 'replicate_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(242, 'reorder_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(243, 'delete_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(244, 'delete_any_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(245, 'force_delete_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(246, 'force_delete_any_faq', 'web', '2025-08-28 00:28:05', '2025-08-28 00:28:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(247, 'page_MyProfilePage', 'web', '2025-09-09 00:55:04', '2025-09-09 00:55:04');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(248, 'widget_PatientTypeOverview', 'web', '2026-01-26 23:55:41', '2026-01-26 23:55:41');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(249, 'widget_PenjualanChart', 'web', '2026-01-26 23:55:41', '2026-01-26 23:55:41');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(250, 'widget_KonsumenChart', 'web', '2026-01-26 23:55:41', '2026-01-26 23:55:41');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(251, 'widget_LeadChart', 'web', '2026-01-26 23:55:41', '2026-01-26 23:55:41');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(252, 'view_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(253, 'view_any_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(254, 'create_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(255, 'update_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(256, 'restore_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(257, 'restore_any_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(258, 'replicate_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(259, 'reorder_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(260, 'delete_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(261, 'delete_any_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(262, 'force_delete_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(263, 'force_delete_any_bank::kerjasama', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(264, 'view_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(265, 'view_any_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(266, 'create_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(267, 'update_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(268, 'restore_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(269, 'restore_any_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(270, 'replicate_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(271, 'reorder_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(272, 'delete_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(273, 'delete_any_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(274, 'force_delete_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(275, 'force_delete_any_biaya::operasional', 'web', '2026-01-30 12:19:12', '2026-01-30 12:19:12');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(276, 'view_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(277, 'view_any_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(278, 'create_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(279, 'update_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(280, 'restore_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(281, 'restore_any_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(282, 'replicate_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(283, 'reorder_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(284, 'delete_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(285, 'delete_any_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(286, 'force_delete_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(287, 'force_delete_any_kas::mutasi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(288, 'view_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(289, 'view_any_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(290, 'create_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(291, 'update_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(292, 'restore_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(293, 'restore_any_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(294, 'replicate_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(295, 'reorder_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(296, 'delete_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(297, 'delete_any_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(298, 'force_delete_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(299, 'force_delete_any_keuangan::akun', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(300, 'view_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(301, 'view_any_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(302, 'create_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(303, 'update_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(304, 'restore_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(305, 'restore_any_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(306, 'replicate_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(307, 'reorder_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(308, 'delete_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(309, 'delete_any_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(310, 'force_delete_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(311, 'force_delete_any_keuangan::kategori', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(312, 'view_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(313, 'view_any_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(314, 'create_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(315, 'update_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(316, 'restore_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(317, 'restore_any_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(318, 'replicate_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(319, 'reorder_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(320, 'delete_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(321, 'delete_any_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(322, 'force_delete_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(323, 'force_delete_any_keuangan::transaksi', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(324, 'view_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(325, 'view_any_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(326, 'create_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(327, 'update_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(328, 'restore_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(329, 'restore_any_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(330, 'replicate_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(331, 'reorder_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(332, 'delete_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(333, 'delete_any_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(334, 'force_delete_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(335, 'force_delete_any_pembayaran::penjualan', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(336, 'view_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(337, 'view_any_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(338, 'create_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(339, 'update_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(340, 'restore_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(341, 'restore_any_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(342, 'replicate_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(343, 'reorder_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(344, 'delete_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(345, 'delete_any_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(346, 'force_delete_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(347, 'force_delete_any_pencairan::bank', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(348, 'view_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(349, 'view_any_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(350, 'create_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(351, 'update_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(352, 'restore_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(353, 'restore_any_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(354, 'replicate_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(355, 'reorder_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(356, 'delete_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(357, 'delete_any_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(358, 'force_delete_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(359, 'force_delete_any_setoran::modal', 'web', '2026-01-30 12:19:13', '2026-01-30 12:19:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(360, 'view_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(361, 'view_any_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(362, 'create_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(363, 'update_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(364, 'restore_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(365, 'restore_any_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(366, 'replicate_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(367, 'reorder_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(368, 'delete_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(369, 'delete_any_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(370, 'force_delete_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(371, 'force_delete_any_fee::marketing', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(372, 'view_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(373, 'view_any_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(374, 'create_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(375, 'update_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(376, 'restore_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(377, 'restore_any_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(378, 'replicate_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(379, 'reorder_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(380, 'delete_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(381, 'delete_any_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(382, 'force_delete_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(383, 'force_delete_any_fee::vendor', 'web', '2026-01-30 15:55:50', '2026-01-30 15:55:50');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(384, 'page_LaporanArusKas', 'web', '2026-01-30 15:55:51', '2026-01-30 15:55:51');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(385, 'page_LaporanLabaRugi', 'web', '2026-01-30 15:55:51', '2026-01-30 15:55:51');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(386, 'page_LaporanPenjualan', 'web', '2026-01-30 15:55:51', '2026-01-30 15:55:51');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(387, 'page_LaporanPerumahan', 'web', '2026-01-30 15:55:51', '2026-01-30 15:55:51');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(388, 'page_LaporanSaldoAkun', 'web', '2026-01-30 15:55:51', '2026-01-30 15:55:51');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(389, 'page_LaporanTransaksi', 'web', '2026-02-03 23:36:13', '2026-02-03 23:36:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(390, 'widget_KeuanganChart', 'web', '2026-02-03 23:36:13', '2026-02-03 23:36:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(391, 'widget_KeuanganLabaBersihChart', 'web', '2026-02-03 23:36:13', '2026-02-03 23:36:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(392, 'widget_KeuanganSaldoKumulatifChart', 'web', '2026-02-03 23:36:13', '2026-02-03 23:36:13');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(393, 'widget_KeuanganStatsOverview', 'web', '2026-02-03 23:36:13', '2026-02-03 23:36:13');

-- Dumping structure for table super-app-properti-fi.perumahans
CREATE TABLE IF NOT EXISTS `perumahans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_perumahan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `map` text COLLATE utf8mb4_unicode_ci,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `gambar` json DEFAULT NULL,
  `perusahaan_id` bigint(20) unsigned DEFAULT NULL,
  `tipe` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `harga` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `luas_bangunan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `luas_lahan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kamar_tidur` int(11) DEFAULT NULL,
  `kamar_mandi` int(11) DEFAULT NULL,
  `atap` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dinding` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lantai_pondasi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_siteplan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `viewbox` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `denah_unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `embed_video` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `perumahans_perusahaan_id_foreign` (`perusahaan_id`),
  CONSTRAINT `perumahans_perusahaan_id_foreign` FOREIGN KEY (`perusahaan_id`) REFERENCES `perusahaans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.perumahans: ~2 rows (approximately)
INSERT INTO `perumahans` (`id`, `nama_perumahan`, `lokasi`, `map`, `deskripsi`, `gambar`, `perusahaan_id`, `tipe`, `harga`, `luas_bangunan`, `luas_lahan`, `kamar_tidur`, `kamar_mandi`, `atap`, `dinding`, `lantai_pondasi`, `background_siteplan`, `viewbox`, `denah_unit`, `embed_video`, `created_at`, `updated_at`) VALUES
	(3, 'Griya Aksata', 'TANGKIT', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d34273.34726490212!2d103.69779845!3d-1.646295!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e258578dd10ac6d%3A0xf8c853ecea782dfd!2sSimpang%20Tangkit!5e1!3m2!1sen!2sid!4v1756046849023!5m2!1sen!2sid" width="600" height="450" style="border:0;" allowfullscreen="" loading="lazy" referrerpolicy="no-referrer-when-downgrade"></iframe>', '<p>Sebuah kawasan yang menghadirkan ruang terbuka hijau yang luas menjadi sebuah gaya hidup dan kebutuhan untuk bermain bersama anak-anak yang disajikan di dalam cluster Park Avenue</p>', '[{"judul": "Cover", "galeri": "perumahan/01K38153545XDWJVHDWXK4G8Z5.jpg"}, {"judul": "Gambar", "galeri": "perumahan/01K3815359SM00N3V1WA0M9K4W.jpg"}]', 2, '36', '166000000', '36', '112', 2, 1, 'Baja Ringan', 'Bata Merah', 'Keramik & Batu Bata Sloof Cor Bertulang', 'perumahan/background_siteplan/01K3TB3YSJ1Z5BCCCMGQZSRD1Y.jpg', '0 0 1280 1600', 'perumahan/denah_unit/01K3EDCK0CRNGCRT2V0K5PJ3AH.jpg', '<iframe width="1183" height="665" src="https://www.youtube.com/embed/zCdk9haiBSc" title="PERUBAHAN SUBSIDI - GRIYA AKSATA TANGKIT MUARO JAMBI" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>', '2025-08-16 21:16:27', '2026-01-25 14:46:40');

-- Dumping structure for table super-app-properti-fi.perusahaans
CREATE TABLE IF NOT EXISTS `perusahaans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kontak` json DEFAULT NULL,
  `sosmed` json DEFAULT NULL,
  `dok_profile_perusahaan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.perusahaans: ~2 rows (approximately)
INSERT INTO `perusahaans` (`id`, `logo`, `nama`, `kontak`, `sosmed`, `dok_profile_perusahaan`, `created_at`, `updated_at`) VALUES
	(2, 'logo_perusahaan/01K2PCWCM3ZCBCBMXC40ATBZNJ.png', 'PT TRI PUTRA BAHARI', '[{"label": "Whatsapp", "value": "082180181958"}, {"label": "Email", "value": "info@yourdomain.com"}, {"label": "Telepon", "value": "+62 812-3456-7890"}, {"label": "Alamat", "value": "Jl. Contoh No.123, Jakarta"}]', '[{"url": "https://www.facebook.com/web.jasa", "platform": "Facebook"}, {"url": "https://www.instagram.com/web.jasa", "platform": "Instagram"}, {"url": "https://twitter.com/web_jasa", "platform": "Twitter"}, {"url": "https://www.linkedin.com/company/web-jasa", "platform": "Linkedin"}]', 'artikel/01KH6S24QGF9HPM6JBKK2WDF7N.png', '2025-08-15 15:16:51', '2026-02-11 23:37:59');
INSERT INTO `perusahaans` (`id`, `logo`, `nama`, `kontak`, `sosmed`, `dok_profile_perusahaan`, `created_at`, `updated_at`) VALUES
	(3, 'logo_perusahaan/01KH6S0H9ZFEHGNNX4ZACQZQA3.png', 'PT GRAHA AKSATA MAHAJAYA', '[{"label": "Whatsapp", "value": "082180181958"}, {"label": "Email", "value": "info@yourdomain.com"}, {"label": "Telepon", "value": "+62 812-3456-7890"}, {"label": "Alamat", "value": "Jl. Contoh No.123, Jakarta"}]', '[{"url": "https://www.facebook.com/web.jasa", "platform": "Facebook"}, {"url": "https://www.instagram.com/web.jasa", "platform": "Instagram"}, {"url": "https://twitter.com/web_jasa", "platform": "Twitter"}, {"url": "https://www.linkedin.com/company/web-jasa", "platform": "Linkedin"}]', 'artikel/01KH6S1QD5P0J9NBSFBGH605B1.png', '2025-08-15 15:16:51', '2026-02-11 23:37:45');

-- Dumping structure for table super-app-properti-fi.promos
CREATE TABLE IF NOT EXISTS `promos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `judul_promo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_mulai` date NOT NULL,
  `tanggal_berakhir` date NOT NULL,
  `gambar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `promos_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.promos: ~0 rows (approximately)
INSERT INTO `promos` (`id`, `judul_promo`, `slug`, `deskripsi`, `tanggal_mulai`, `tanggal_berakhir`, `gambar`, `link`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'Promo Rumah Subsidi Agustus', 'promo-rumah-subsidi-agustus', '<h1>📣 Promo Perumahan Bahari Village – Muaro Jambi</h1><p>✨ <em>2,5 Juta Udah Bisa Bobok di Rumah Baru!</em> ✨</p><p>Mau punya rumah sendiri tapi budget terbatas?<br>&nbsp;Sekarang nggak lagi mimpi! Di <strong>Bahari Village, Tangkit – Muaro Jambi</strong>, kamu bisa punya rumah subsidi dengan cicilan super ringan.</p><p>🏡 <strong>Kenapa harus pilih Bahari Village?</strong><br>✅ Lokasi strategis: 8MWQ+P9V Tangkit, Muaro Jambi Regency, Jambi<br>✅ Harga terjangkau sesuai program rumah subsidi<br>✅ Cicilan mulai <strong>Rp1 jutaan</strong> per bulan<br>✅ Fasilitas umum lengkap<br>✅ Lingkungan nyaman &amp; asri</p><p>💸 Cukup bayar <strong>2,5 Juta aja</strong>, kamu sudah bisa tidur nyenyak di rumah baru milik sendiri.<br>Nggak perlu nunggu lama, unit terbatas loh!</p><p>📍 Lokasi gampang dijangkau, dekat akses jalan utama dan fasilitas penting. Cocok untuk keluarga muda maupun pekerja di Jambi.</p><p>📞 Info &amp; Pemesanan:<br>&nbsp;👉 <a href="https://triputrabahari.com/marketing"><span style="text-decoration: underline;">Hubungi marketing resmi Bahari Village</span></a><br>📲 WA/Telp: [<a href="https://triputrabahari.com/marketing"><span style="text-decoration: underline;">KLIK DISINI</span></a>]</p><p>✨ Jangan tunggu harga naik!<br>&nbsp;Bahari Village – <em>Hunian Nyaman, Harga Bersahabat.</em></p><p><br></p>', '2025-08-01', '2025-08-31', 'promo/01K3H3F30V3K473KG5FQ3ZX7VJ.jpg', 'https://contohwebsite.com/promo-agustus', 1, '2025-08-15 04:11:11', '2025-09-06 02:40:52');

-- Dumping structure for table super-app-properti-fi.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.roles: ~4 rows (approximately)
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'super_admin', 'web', '2025-08-21 15:28:12', '2025-08-21 15:28:12');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(2, 'marketing', 'web', '2025-08-21 15:31:03', '2025-08-21 15:31:03');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(4, 'keuangan', 'web', '2026-01-26 23:55:41', '2026-01-26 23:55:41');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(5, 'owner', 'web', '2026-01-30 15:57:34', '2026-01-30 15:57:34');

-- Dumping structure for table super-app-properti-fi.role_has_permissions
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.role_has_permissions: ~672 rows (approximately)
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(1, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(2, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(3, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(4, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(5, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(6, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(7, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(8, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(9, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(10, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(11, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(12, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(13, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(14, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(15, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(16, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(17, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(18, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(19, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(20, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(21, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(22, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(23, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(24, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(25, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(26, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(27, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(28, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(29, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(30, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(31, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(32, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(33, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(34, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(35, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(36, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(37, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(38, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(39, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(40, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(41, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(42, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(43, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(44, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(45, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(46, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(47, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(48, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(49, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(50, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(51, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(52, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(53, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(54, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(55, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(56, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(57, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(58, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(59, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(60, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(61, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(62, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(63, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(64, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(65, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(66, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(67, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(68, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(69, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(70, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(71, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(72, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(73, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(74, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(75, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(76, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(77, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(78, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(79, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(80, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(81, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(82, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(83, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(84, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(85, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(86, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(87, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(88, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(89, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(90, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(91, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(92, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(93, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(94, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(95, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(96, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(97, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(98, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(99, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(100, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(101, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(102, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(103, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(104, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(105, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(106, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(107, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(108, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(109, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(110, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(111, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(112, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(113, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(114, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(115, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(116, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(117, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(118, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(119, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(120, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(121, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(122, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(123, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(124, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(125, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(126, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(127, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(128, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(129, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(130, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(131, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(132, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(133, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(134, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(135, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(136, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(137, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(138, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(139, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(140, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(141, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(142, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(143, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(144, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(145, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(146, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(147, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(148, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(149, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(150, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(151, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(152, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(153, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(154, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(155, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(156, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(157, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(158, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(159, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(160, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(161, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(162, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(163, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(164, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(165, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(166, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(167, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(168, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(169, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(170, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(171, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(172, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(173, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(174, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(175, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(176, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(177, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(178, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(179, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(180, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(181, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(182, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(183, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(184, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(185, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(186, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(187, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(188, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(189, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(190, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(191, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(192, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(193, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(194, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(195, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(196, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(197, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(198, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(199, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(200, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(201, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(202, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(203, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(204, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(205, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(206, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(207, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(208, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(209, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(210, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(211, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(212, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(213, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(214, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(215, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(216, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(217, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(218, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(219, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(220, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(221, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(222, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(223, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(224, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(225, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(226, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(227, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(228, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(229, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(230, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(231, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(232, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(233, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(234, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(235, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(236, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(237, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(238, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(239, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(240, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(241, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(242, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(243, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(244, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(245, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(246, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(247, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(248, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(249, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(250, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(251, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(252, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(253, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(254, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(255, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(256, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(257, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(258, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(259, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(260, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(261, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(262, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(263, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(264, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(265, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(266, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(267, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(268, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(269, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(270, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(271, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(272, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(273, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(274, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(275, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(276, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(277, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(278, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(279, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(280, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(281, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(282, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(283, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(284, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(285, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(286, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(287, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(288, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(289, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(290, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(291, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(292, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(293, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(294, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(295, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(296, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(297, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(298, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(299, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(300, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(301, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(302, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(303, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(304, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(305, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(306, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(307, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(308, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(309, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(310, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(311, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(312, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(313, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(314, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(315, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(316, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(317, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(318, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(319, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(320, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(321, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(322, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(323, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(324, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(325, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(326, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(327, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(328, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(329, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(330, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(331, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(332, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(333, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(334, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(335, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(336, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(337, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(338, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(339, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(340, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(341, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(342, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(343, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(344, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(345, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(346, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(347, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(348, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(349, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(350, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(351, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(352, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(353, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(354, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(355, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(356, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(357, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(358, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(359, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(360, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(361, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(362, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(363, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(364, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(365, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(366, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(367, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(368, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(369, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(370, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(371, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(372, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(373, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(374, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(375, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(376, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(377, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(378, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(379, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(380, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(381, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(382, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(383, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(384, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(385, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(386, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(387, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(388, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(389, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(390, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(391, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(392, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(393, 1);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(19, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(20, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(21, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(22, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(23, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(24, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(25, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(26, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(27, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(28, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(29, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(30, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(31, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(32, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(33, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(34, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(35, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(36, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(37, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(38, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(39, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(40, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(41, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(42, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(79, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(80, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(81, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(82, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(83, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(84, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(85, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(86, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(87, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(88, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(89, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(90, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(91, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(92, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(94, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(95, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(96, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(97, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(98, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(115, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(116, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(117, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(118, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(119, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(120, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(121, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(122, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(123, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(124, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(125, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(126, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(151, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(152, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(153, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(154, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(155, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(156, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(157, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(158, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(159, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(160, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(161, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(162, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(211, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(212, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(213, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(214, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(215, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(216, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(217, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(218, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(219, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(220, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(221, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(222, 2);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(7, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(8, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(9, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(10, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(11, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(12, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(13, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(14, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(15, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(16, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(17, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(18, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(79, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(80, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(81, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(82, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(83, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(84, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(85, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(86, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(115, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(116, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(117, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(118, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(119, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(120, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(121, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(122, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(247, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(248, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(249, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(250, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(251, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(252, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(253, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(254, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(264, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(265, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(266, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(267, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(268, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(269, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(270, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(271, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(272, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(273, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(274, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(275, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(276, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(277, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(278, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(279, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(280, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(281, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(282, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(283, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(284, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(285, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(286, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(287, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(288, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(289, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(290, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(291, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(292, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(293, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(294, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(295, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(300, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(301, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(302, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(312, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(313, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(314, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(315, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(316, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(317, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(318, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(319, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(320, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(321, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(322, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(323, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(324, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(325, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(326, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(327, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(328, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(329, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(330, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(331, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(336, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(337, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(338, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(339, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(340, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(341, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(342, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(343, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(344, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(345, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(346, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(347, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(348, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(349, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(350, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(351, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(352, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(353, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(354, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(355, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(356, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(357, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(358, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(359, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(360, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(361, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(362, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(363, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(364, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(365, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(366, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(367, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(368, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(369, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(370, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(371, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(372, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(373, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(374, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(375, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(376, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(377, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(378, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(379, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(380, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(381, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(382, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(383, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(384, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(385, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(386, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(387, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(388, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(389, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(390, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(391, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(392, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(393, 4);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(247, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(248, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(249, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(250, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(251, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(276, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(277, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(278, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(279, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(280, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(281, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(282, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(283, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(284, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(285, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(286, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(287, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(288, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(289, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(290, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(291, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(292, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(293, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(294, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(295, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(296, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(297, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(298, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(299, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(312, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(313, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(314, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(315, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(316, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(317, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(318, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(319, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(320, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(321, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(322, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(323, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(384, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(385, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(386, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(387, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(388, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(389, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(390, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(391, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(392, 5);
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(393, 5);

-- Dumping structure for table super-app-properti-fi.rumahs
CREATE TABLE IF NOT EXISTS `rumahs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `blok_id` bigint(20) unsigned DEFAULT NULL,
  `jenis` enum('subsidi','komersil','non-subsidi') COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_rumah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipe_rumah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `luas_tanah` int(11) NOT NULL,
  `luas_bangunan` int(11) NOT NULL,
  `kamar_tidur` int(11) NOT NULL,
  `kamar_mandi` int(11) NOT NULL,
  `harga` decimal(15,2) NOT NULL,
  `spesifikasi_teknis` text COLLATE utf8mb4_unicode_ci,
  `status` enum('tersedia','booking','terjual') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tersedia',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rumahs_blok_id_foreign` (`blok_id`),
  CONSTRAINT `rumahs_blok_id_foreign` FOREIGN KEY (`blok_id`) REFERENCES `bloks` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.rumahs: ~3 rows (approximately)
INSERT INTO `rumahs` (`id`, `blok_id`, `jenis`, `nomor_rumah`, `tipe_rumah`, `luas_tanah`, `luas_bangunan`, `kamar_tidur`, `kamar_mandi`, `harga`, `spesifikasi_teknis`, `status`, `created_at`, `updated_at`) VALUES
	(1, 3, 'subsidi', '02', '36/72', 72, 36, 2, 1, 150000000.00, 'Fondasi batu kali, dinding bata ringan, atap baja ringan.', 'tersedia', '2025-08-15 04:11:11', '2026-02-03 23:14:47');
INSERT INTO `rumahs` (`id`, `blok_id`, `jenis`, `nomor_rumah`, `tipe_rumah`, `luas_tanah`, `luas_bangunan`, `kamar_tidur`, `kamar_mandi`, `harga`, `spesifikasi_teknis`, `status`, `created_at`, `updated_at`) VALUES
	(2, 3, 'komersil', '03', '45/90', 90, 45, 3, 2, 350000000.00, 'Pondasi beton bertulang, dinding bata merah, atap genteng beton.', 'tersedia', '2025-08-15 04:11:11', '2026-01-28 21:45:57');
INSERT INTO `rumahs` (`id`, `blok_id`, `jenis`, `nomor_rumah`, `tipe_rumah`, `luas_tanah`, `luas_bangunan`, `kamar_tidur`, `kamar_mandi`, `harga`, `spesifikasi_teknis`, `status`, `created_at`, `updated_at`) VALUES
	(4, 3, 'subsidi', '01', '36', 12, 12, 121, 12, 12.00, '12', 'booking', '2025-08-16 23:12:45', '2026-02-11 23:34:50');

-- Dumping structure for table super-app-properti-fi.sessions
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.sessions: ~2 rows (approximately)
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('3xad3zwnh6UnywTTtGSWwdlY2oXd34AQTVFtMoJK', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicXZDbmZRTFlVREpacUhqbEdZdllJRUFOcDFmRmprVXdaUXBDc2h4MSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vc3VwZXItYXBwLXByb3BlcnRpLWZpLnRlc3QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1776091840);
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('PUdTccSjynvTGYwLNGn4QuGOOarMzTopQ4MBGs7T', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieFFNQlpOTEpMZE82UWNqMHB1cFJ6VDBoQm5DOEJmQ3RLbkYzb2oyMCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTM6Imh0dHBzOi8vc3VwZXItYXBwLXByb3BlcnRpLWZpLnRlc3QvcGVydW1haGFuL2RldGFpbC8zIjt9fQ==', 1770973676);

-- Dumping structure for table super-app-properti-fi.setoran_modals
CREATE TABLE IF NOT EXISTS `setoran_modals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sumber_modal` enum('owner','investor','pinjaman') COLLATE utf8mb4_unicode_ci NOT NULL,
  `pemberi_modal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kategori_id` bigint(20) unsigned NOT NULL,
  `perumahan_id` bigint(20) unsigned DEFAULT NULL,
  `akun_id` bigint(20) unsigned NOT NULL,
  `tanggal` date NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `bukti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('menunggu','diterima','ditolak') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'menunggu',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `setoran_modals_kategori_id_foreign` (`kategori_id`),
  KEY `setoran_modals_akun_id_foreign` (`akun_id`),
  KEY `setoran_modals_perumahan_id_foreign` (`perumahan_id`),
  CONSTRAINT `setoran_modals_akun_id_foreign` FOREIGN KEY (`akun_id`) REFERENCES `keuangan_akuns` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `setoran_modals_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `keuangan_kategoris` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `setoran_modals_perumahan_id_foreign` FOREIGN KEY (`perumahan_id`) REFERENCES `perumahans` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.setoran_modals: ~0 rows (approximately)

-- Dumping structure for table super-app-properti-fi.setting_webs
CREATE TABLE IF NOT EXISTS `setting_webs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kontak` json DEFAULT NULL,
  `sosmed` json DEFAULT NULL,
  `meta_tag` text COLLATE utf8mb4_unicode_ci,
  `api_wa` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pixel_fb` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.setting_webs: ~0 rows (approximately)
INSERT INTO `setting_webs` (`id`, `logo`, `nama`, `kontak`, `sosmed`, `meta_tag`, `api_wa`, `pixel_fb`, `created_at`, `updated_at`) VALUES
	(1, 'logo_web/01KH6N65F5YE4QREVCMVSJKAQW.png', 'Demo Super App Properti', '[{"label": "Whatsapp", "value": "082180181958"}, {"label": "Email", "value": "info@yourdomain.com"}, {"label": "Telepon", "value": "+62 812-3456-7890"}, {"label": "Alamat", "value": "Jl. Contoh No.123, Jakarta"}]', '[{"url": "https://www.facebook.com/web.jasa", "platform": "Facebook"}, {"url": "https://www.instagram.com/web.jasa", "platform": "Instagram"}, {"url": "https://twitter.com/web_jasa", "platform": "Twitter"}, {"url": "https://www.linkedin.com/company/web-jasa", "platform": "Linkedin"}]', 'SuperApp, developer hunian subsidi di Jambi. Hunian strategis, harga terjangkau, proses KPR mudah. Cek promo rumah subsidi terbaru di Jambi!', NULL, NULL, '2025-08-15 04:11:11', '2026-02-11 22:30:16');

-- Dumping structure for table super-app-properti-fi.site_plans
CREATE TABLE IF NOT EXISTS `site_plans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rumah_id` bigint(20) unsigned DEFAULT NULL,
  `koordinat_polygon` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `warna` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '#00ff00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `site_plans_rumah_id_foreign` (`rumah_id`),
  CONSTRAINT `site_plans_rumah_id_foreign` FOREIGN KEY (`rumah_id`) REFERENCES `rumahs` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.site_plans: ~3 rows (approximately)
INSERT INTO `site_plans` (`id`, `rumah_id`, `koordinat_polygon`, `warna`, `created_at`, `updated_at`) VALUES
	(1, 2, '409,79 422,82 424,84 424,89 415,124 410,124 393,119 394,108 402,79 409,79', '#00ff00', '2025-08-15 04:11:11', '2025-08-15 04:11:11');
INSERT INTO `site_plans` (`id`, `rumah_id`, `koordinat_polygon`, `warna`, `created_at`, `updated_at`) VALUES
	(3, 1, '430,84 448,89 448,95 440,129 431,129 418,126 416,124 422,94 426,84 430,84', '#00ff00', '2025-08-15 04:11:11', '2025-08-15 04:11:11');
INSERT INTO `site_plans` (`id`, `rumah_id`, `koordinat_polygon`, `warna`, `created_at`, `updated_at`) VALUES
	(4, 4, '455,90 472,95 463,135 455,135 440,130 449,90 455,90', '#00ff00', '2025-08-15 04:11:11', '2025-08-15 04:11:11');

-- Dumping structure for table super-app-properti-fi.syarat_berkas
CREATE TABLE IF NOT EXISTS `syarat_berkas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `skor` int(11) DEFAULT NULL,
  `null` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pilihan_jawaban` json DEFAULT NULL,
  `rules` json DEFAULT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `suffix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `suffixicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `suffixiconcolor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefixicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefixiconcolor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` tinyint(1) NOT NULL DEFAULT '0',
  `tel` tinyint(1) NOT NULL DEFAULT '0',
  `image` tinyint(1) NOT NULL DEFAULT '0',
  `multiple` tinyint(1) NOT NULL DEFAULT '0',
  `email` tinyint(1) NOT NULL DEFAULT '0',
  `grid_full` tinyint(1) NOT NULL DEFAULT '0',
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.syarat_berkas: ~4 rows (approximately)
INSERT INTO `syarat_berkas` (`id`, `nama`, `skor`, `null`, `type`, `pilihan_jawaban`, `rules`, `required`, `suffix`, `prefix`, `url`, `suffixicon`, `suffixiconcolor`, `prefixicon`, `prefixiconcolor`, `currency`, `tel`, `image`, `multiple`, `email`, `grid_full`, `keterangan`, `created_at`, `updated_at`) VALUES
	(3, 'KTP', NULL, NULL, 'upload', NULL, '[null]', 1, NULL, NULL, '0', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, '2025-08-16 23:47:20', '2025-08-16 23:47:20');
INSERT INTO `syarat_berkas` (`id`, `nama`, `skor`, `null`, `type`, `pilihan_jawaban`, `rules`, `required`, `suffix`, `prefix`, `url`, `suffixicon`, `suffixiconcolor`, `prefixicon`, `prefixiconcolor`, `currency`, `tel`, `image`, `multiple`, `email`, `grid_full`, `keterangan`, `created_at`, `updated_at`) VALUES
	(4, 'SYARAT LENGKAP KPR SUBSIDI', NULL, NULL, 'upload', NULL, '[null]', 0, NULL, NULL, '0', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 'Jika Berkas Sudah Lengkap', '2025-08-19 20:53:45', '2026-02-11 22:38:58');
INSERT INTO `syarat_berkas` (`id`, `nama`, `skor`, `null`, `type`, `pilihan_jawaban`, `rules`, `required`, `suffix`, `prefix`, `url`, `suffixicon`, `suffixiconcolor`, `prefixicon`, `prefixiconcolor`, `currency`, `tel`, `image`, `multiple`, `email`, `grid_full`, `keterangan`, `created_at`, `updated_at`) VALUES
	(5, 'Sertifikat', NULL, NULL, 'upload', NULL, '[null]', 0, NULL, NULL, '0', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 'Jika sudah Serah Terima Kunci', '2025-08-19 20:53:45', '2026-02-11 22:38:34');

-- Dumping structure for table super-app-properti-fi.syarat_has_jenis
CREATE TABLE IF NOT EXISTS `syarat_has_jenis` (
  `jenis_id` bigint(20) unsigned NOT NULL,
  `syarat_berkas_id` bigint(20) unsigned NOT NULL,
  `urutan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `syarat_has_jenis_jenis_id_foreign` (`jenis_id`),
  KEY `syarat_has_jenis_syarat_berkas_id_foreign` (`syarat_berkas_id`),
  CONSTRAINT `syarat_has_jenis_jenis_id_foreign` FOREIGN KEY (`jenis_id`) REFERENCES `jenis_berkas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `syarat_has_jenis_syarat_berkas_id_foreign` FOREIGN KEY (`syarat_berkas_id`) REFERENCES `syarat_berkas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.syarat_has_jenis: ~0 rows (approximately)
INSERT INTO `syarat_has_jenis` (`jenis_id`, `syarat_berkas_id`, `urutan`, `created_at`, `updated_at`) VALUES
	(1, 4, 3, '2025-08-19 20:54:04', '2025-08-19 20:54:04');
INSERT INTO `syarat_has_jenis` (`jenis_id`, `syarat_berkas_id`, `urutan`, `created_at`, `updated_at`) VALUES
	(1, 3, 1, '2026-02-11 22:37:54', '2026-02-11 22:37:54');

-- Dumping structure for table super-app-properti-fi.testimonis
CREATE TABLE IF NOT EXISTS `testimonis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `gambar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table super-app-properti-fi.testimonis: ~2 rows (approximately)
INSERT INTO `testimonis` (`id`, `nama`, `email`, `keterangan`, `gambar`, `created_at`, `updated_at`) VALUES
	(1, 'Andi Saputra', 'andi@example.com', 'Pelayanan cepat, rumah sesuai ekspektasi!', 'testimoni/01K2PBVACKTP9PBPY2J5G3BABX.png', '2025-08-15 04:11:11', '2025-08-15 14:59:27');
INSERT INTO `testimonis` (`id`, `nama`, `email`, `keterangan`, `gambar`, `created_at`, `updated_at`) VALUES
	(2, 'Siti Rahma', 'arieflukman557@gmail.com', 'Proses KPR mudah, marketingnya ramah.', 'testimoni/01K38AS5TS1S26N1D9XV0MK8S0.jpg', '2025-08-15 04:11:11', '2025-08-22 14:27:08');

