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


-- Dumping structure for table hpp-penjualan-laravel.bahan_bakus
CREATE TABLE IF NOT EXISTS `bahan_bakus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `satuan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `harga_per_satuan` decimal(12,2) NOT NULL DEFAULT '0.00',
  `stok` decimal(12,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.bahan_bakus: ~2 rows (approximately)
INSERT INTO `bahan_bakus` (`id`, `nama`, `satuan`, `harga_per_satuan`, `stok`, `created_at`, `updated_at`) VALUES
	(5, 'Emas 24K', 'gram', 1700000.00, 100.00, '2025-06-22 03:02:54', '2025-06-22 03:02:54');
INSERT INTO `bahan_bakus` (`id`, `nama`, `satuan`, `harga_per_satuan`, `stok`, `created_at`, `updated_at`) VALUES
	(6, 'Lem Khusus', 'ml', 5000.00, 100.00, '2025-06-22 03:03:16', '2025-06-22 03:03:16');

-- Dumping structure for table hpp-penjualan-laravel.banks
CREATE TABLE IF NOT EXISTS `banks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_bank` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `norek` 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.banks: ~2 rows (approximately)
INSERT INTO `banks` (`id`, `nama_bank`, `norek`, `created_at`, `updated_at`) VALUES
	(1, 'BRI', '5021545488', '2025-06-22 20:24:13', '2025-06-22 20:24:13');
INSERT INTO `banks` (`id`, `nama_bank`, `norek`, `created_at`, `updated_at`) VALUES
	(2, 'BCA', '5021545488', '2025-06-22 20:24:13', '2025-06-22 20:24:13');

-- Dumping structure for table hpp-penjualan-laravel.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 hpp-penjualan-laravel.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table hpp-penjualan-laravel.invoices
CREATE TABLE IF NOT EXISTS `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kode_invoice` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date NOT NULL,
  `pelanggan_id` bigint(20) unsigned NOT NULL,
  `total` decimal(12,2) DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoices_kode_invoice_unique` (`kode_invoice`),
  KEY `invoices_pelanggan_id_foreign` (`pelanggan_id`),
  CONSTRAINT `invoices_pelanggan_id_foreign` FOREIGN KEY (`pelanggan_id`) REFERENCES `pelanggans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.invoices: ~2 rows (approximately)
INSERT INTO `invoices` (`id`, `kode_invoice`, `tanggal`, `pelanggan_id`, `total`, `created_at`, `updated_at`) VALUES
	(6, 'Bakulpulley-0001', '2025-06-22', 1, 3000000.00, '2025-06-22 03:06:42', '2025-06-22 20:07:57');
INSERT INTO `invoices` (`id`, `kode_invoice`, `tanggal`, `pelanggan_id`, `total`, `created_at`, `updated_at`) VALUES
	(8, 'Bakulpulley-0002', '2025-06-22', 2, 7750000.00, '2025-06-22 03:53:33', '2025-06-22 20:07:42');

-- Dumping structure for table hpp-penjualan-laravel.invoice_items
CREATE TABLE IF NOT EXISTS `invoice_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `kuantitas` int(11) NOT NULL,
  `harga_satuan` decimal(12,2) NOT NULL,
  `subtotal` decimal(12,2) NOT NULL,
  `laba_rugi` decimal(15,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_items_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_items_product_id_foreign` (`product_id`),
  CONSTRAINT `invoice_items_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.invoice_items: ~3 rows (approximately)
INSERT INTO `invoice_items` (`id`, `invoice_id`, `product_id`, `kuantitas`, `harga_satuan`, `subtotal`, `laba_rugi`, `created_at`, `updated_at`) VALUES
	(24, 8, 6, 1, 1750000.00, 1750000.00, 37000.00, '2025-06-22 20:07:36', '2025-06-22 20:07:36');
INSERT INTO `invoice_items` (`id`, `invoice_id`, `product_id`, `kuantitas`, `harga_satuan`, `subtotal`, `laba_rugi`, `created_at`, `updated_at`) VALUES
	(25, 8, 7, 2, 3000000.00, 6000000.00, 2596000.00, '2025-06-22 20:07:42', '2025-06-22 20:07:42');
INSERT INTO `invoice_items` (`id`, `invoice_id`, `product_id`, `kuantitas`, `harga_satuan`, `subtotal`, `laba_rugi`, `created_at`, `updated_at`) VALUES
	(26, 6, 7, 1, 3000000.00, 3000000.00, 1298000.00, '2025-06-22 20:07:57', '2025-06-22 20:07:57');

-- Dumping structure for table hpp-penjualan-laravel.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 hpp-penjualan-laravel.jobs: ~0 rows (approximately)

-- Dumping structure for table hpp-penjualan-laravel.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 hpp-penjualan-laravel.job_batches: ~0 rows (approximately)

-- Dumping structure for table hpp-penjualan-laravel.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=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.migrations: ~19 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_06_20_053418_create_products_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(5, '2025_06_20_053428_create_bahan_bakus_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(6, '2025_06_20_053442_create_resep_produks_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(7, '2025_06_20_053453_create_produksis_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(8, '2025_06_20_053511_create_invoices_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(9, '2025_06_20_053523_create_invoice_items_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(10, '2025_06_20_053534_create_stok_masuks_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(11, '2025_06_20_053545_create_stok_keluars_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(12, '2025_06_20_125010_create_breezy_sessions_table', 2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(13, '2025_06_20_130302_create_permission_tables', 3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(14, '2025_06_21_204508_create_pelanggans_table', 4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(15, '2025_06_21_213051_update_invoices_table_add_pelanggan_id', 5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(16, '2025_06_21_234822_add_invoice_item_id_to_stok_keluars_table', 6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(17, '2025_06_22_195818_add_laba_rugi_to_invoice_items_table', 7);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(18, '2025_06_22_202047_create_profile_apps_table', 8);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(19, '2025_06_22_202054_create_banks_table', 8);

-- Dumping structure for table hpp-penjualan-laravel.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 hpp-penjualan-laravel.model_has_permissions: ~0 rows (approximately)

-- Dumping structure for table hpp-penjualan-laravel.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 hpp-penjualan-laravel.model_has_roles: ~2 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);

-- Dumping structure for table hpp-penjualan-laravel.pelanggans
CREATE TABLE IF NOT EXISTS `pelanggans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci,
  `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 hpp-penjualan-laravel.pelanggans: ~0 rows (approximately)
INSERT INTO `pelanggans` (`id`, `nama`, `no_hp`, `alamat`, `created_at`, `updated_at`) VALUES
	(1, 'Lukman store', '081234567890', NULL, '2025-06-21 21:35:21', '2025-06-21 22:12:25');
INSERT INTO `pelanggans` (`id`, `nama`, `no_hp`, `alamat`, `created_at`, `updated_at`) VALUES
	(2, 'Andi Sutanto', '082154875421', NULL, '2025-06-22 02:27:41', '2025-06-22 02:50:08');

-- Dumping structure for table hpp-penjualan-laravel.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=153 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.permissions: ~141 rows (approximately)
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'view_role', 'web', '2025-06-20 13:03:37', '2025-06-20 13:03:37');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(2, 'view_any_role', 'web', '2025-06-20 13:03:37', '2025-06-20 13:03:37');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(3, 'create_role', 'web', '2025-06-20 13:03:37', '2025-06-20 13:03:37');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(4, 'update_role', 'web', '2025-06-20 13:03:37', '2025-06-20 13:03:37');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(5, 'delete_role', 'web', '2025-06-20 13:03:37', '2025-06-20 13:03:37');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(6, 'delete_any_role', 'web', '2025-06-20 13:03:37', '2025-06-20 13:03:37');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(7, 'view_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(8, 'view_any_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(9, 'create_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(10, 'update_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(11, 'restore_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(12, 'restore_any_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(13, 'replicate_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(14, 'reorder_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(15, 'delete_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(16, 'delete_any_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(17, 'force_delete_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(18, 'force_delete_any_bahan::baku', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(19, 'view_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(20, 'view_any_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(21, 'create_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(22, 'update_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(23, 'restore_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(24, 'restore_any_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(25, 'replicate_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(26, 'reorder_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(27, 'delete_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(28, 'delete_any_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(29, 'force_delete_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(30, 'force_delete_any_invoice', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(31, 'view_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(32, 'view_any_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(33, 'create_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(34, 'update_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(35, 'restore_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(36, 'restore_any_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(37, 'replicate_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(38, 'reorder_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(39, 'delete_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(40, 'delete_any_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(41, 'force_delete_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(42, 'force_delete_any_invoice::item', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(43, 'view_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(44, 'view_any_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(45, 'create_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(46, 'update_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(47, 'restore_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(48, 'restore_any_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(49, 'replicate_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(50, 'reorder_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(51, 'delete_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(52, 'delete_any_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(53, 'force_delete_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(54, 'force_delete_any_product', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(55, 'view_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(56, 'view_any_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(57, 'create_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(58, 'update_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(59, 'restore_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(60, 'restore_any_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(61, 'replicate_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(62, 'reorder_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(63, 'delete_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(64, 'delete_any_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(65, 'force_delete_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(66, 'force_delete_any_produksi', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(67, 'view_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(68, 'view_any_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(69, 'create_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(70, 'update_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(71, 'restore_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(72, 'restore_any_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(73, 'replicate_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(74, 'reorder_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(75, 'delete_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(76, 'delete_any_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(77, 'force_delete_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(78, 'force_delete_any_resep::produk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(79, 'view_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(80, 'view_any_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(81, 'create_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(82, 'update_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(83, 'restore_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(84, 'restore_any_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(85, 'replicate_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(86, 'reorder_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(87, 'delete_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(88, 'delete_any_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(89, 'force_delete_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(90, 'force_delete_any_stok::keluar', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(91, 'view_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(92, 'view_any_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(93, 'create_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(94, 'update_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(95, 'restore_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(96, 'restore_any_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(97, 'replicate_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(98, 'reorder_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(99, 'delete_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(100, 'delete_any_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(101, 'force_delete_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(102, 'force_delete_any_stok::masuk', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(103, 'view_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(104, 'view_any_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(105, 'create_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(106, 'update_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(107, 'restore_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(108, 'restore_any_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(109, 'replicate_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(110, 'reorder_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(111, 'delete_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(112, 'delete_any_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(113, 'force_delete_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(114, 'force_delete_any_user', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(115, 'page_MyProfilePage', 'web', '2025-06-20 13:05:17', '2025-06-20 13:05:17');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(116, 'view_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(117, 'view_any_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(118, 'create_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(119, 'update_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(120, 'restore_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(121, 'restore_any_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(122, 'replicate_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(123, 'reorder_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(124, 'delete_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(125, 'delete_any_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(126, 'force_delete_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(127, 'force_delete_any_pelanggan', 'web', '2025-06-22 00:36:54', '2025-06-22 00:36:54');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(128, 'view_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(129, 'view_any_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(130, 'create_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(131, 'update_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(132, 'restore_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(133, 'restore_any_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(134, 'replicate_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(135, 'reorder_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(136, 'delete_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(137, 'delete_any_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(138, 'force_delete_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(139, 'force_delete_any_bank', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(140, 'view_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(141, 'view_any_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(142, 'create_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(143, 'update_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(144, 'restore_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(145, 'restore_any_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(146, 'replicate_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(147, 'reorder_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(148, 'delete_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(149, 'delete_any_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(150, 'force_delete_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(151, 'force_delete_any_profile::app', 'web', '2025-06-22 20:23:11', '2025-06-22 20:23:11');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(152, 'widget_TerlarisChart', 'web', '2025-06-22 20:23:12', '2025-06-22 20:23:12');

-- Dumping structure for table hpp-penjualan-laravel.products
CREATE TABLE IF NOT EXISTS `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kode_produk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `harga_jual` decimal(12,2) DEFAULT '0.00',
  `hpp` decimal(12,2) DEFAULT NULL,
  `stok` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_kode_produk_unique` (`kode_produk`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.products: ~2 rows (approximately)
INSERT INTO `products` (`id`, `kode_produk`, `nama`, `harga_jual`, `hpp`, `stok`, `created_at`, `updated_at`) VALUES
	(6, 'P-001', 'Cincin Emas Typex', 1750000.00, 1713000.00, 199, '2025-06-22 03:01:32', '2025-06-22 20:07:52');
INSERT INTO `products` (`id`, `kode_produk`, `nama`, `harga_jual`, `hpp`, `stok`, `created_at`, `updated_at`) VALUES
	(7, 'P-002', 'Kalung', 3000000.00, 1702000.00, 8, '2025-06-22 03:51:31', '2025-06-22 20:07:57');

-- Dumping structure for table hpp-penjualan-laravel.produksis
CREATE TABLE IF NOT EXISTS `produksis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `berat_total` decimal(12,2) NOT NULL,
  `biaya_bubut` decimal(12,2) NOT NULL DEFAULT '0.00',
  `biaya_finish` decimal(12,2) NOT NULL DEFAULT '0.00',
  `hpp_per_item` decimal(12,2) DEFAULT NULL,
  `jumlah_dibuat` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `produksis_product_id_foreign` (`product_id`),
  CONSTRAINT `produksis_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.produksis: ~1 rows (approximately)
INSERT INTO `produksis` (`id`, `product_id`, `berat_total`, `biaya_bubut`, `biaya_finish`, `hpp_per_item`, `jumlah_dibuat`, `tanggal`, `created_at`, `updated_at`) VALUES
	(6, 6, 1.00, 2000.00, 1000.00, 1713000.00, 1, '2025-06-22', '2025-06-22 03:05:18', '2025-06-22 03:05:18');
INSERT INTO `produksis` (`id`, `product_id`, `berat_total`, `biaya_bubut`, `biaya_finish`, `hpp_per_item`, `jumlah_dibuat`, `tanggal`, `created_at`, `updated_at`) VALUES
	(7, 7, 1.00, 1000.00, 1000.00, 1702000.00, 1, '2025-06-22', '2025-06-22 03:52:30', '2025-06-22 03:52:30');

-- Dumping structure for table hpp-penjualan-laravel.profile_apps
CREATE TABLE IF NOT EXISTS `profile_apps` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` 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 hpp-penjualan-laravel.profile_apps: ~0 rows (approximately)
INSERT INTO `profile_apps` (`id`, `nama`, `logo`, `telp`, `alamat`, `created_at`, `updated_at`) VALUES
	(1, 'Berkah Baja', 'logo/01JYBX0BN6MRFRK6ZRBZWGPTCM.jpg', '081393737897', 'Tegalrejo 02/09, Depan Kampus Polman Ceper, Klaten\n', '2025-06-22 20:24:52', '2025-06-22 20:24:52');

-- Dumping structure for table hpp-penjualan-laravel.resep_produks
CREATE TABLE IF NOT EXISTS `resep_produks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `bahan_baku_id` bigint(20) unsigned NOT NULL,
  `kuantitas` decimal(12,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `resep_produks_product_id_foreign` (`product_id`),
  KEY `resep_produks_bahan_baku_id_foreign` (`bahan_baku_id`),
  CONSTRAINT `resep_produks_bahan_baku_id_foreign` FOREIGN KEY (`bahan_baku_id`) REFERENCES `bahan_bakus` (`id`) ON DELETE CASCADE,
  CONSTRAINT `resep_produks_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.resep_produks: ~2 rows (approximately)
INSERT INTO `resep_produks` (`id`, `product_id`, `bahan_baku_id`, `kuantitas`, `created_at`, `updated_at`) VALUES
	(8, 6, 5, 1.00, '2025-06-22 03:03:45', '2025-06-22 03:03:45');
INSERT INTO `resep_produks` (`id`, `product_id`, `bahan_baku_id`, `kuantitas`, `created_at`, `updated_at`) VALUES
	(9, 6, 6, 2.00, '2025-06-22 03:03:51', '2025-06-22 03:03:51');
INSERT INTO `resep_produks` (`id`, `product_id`, `bahan_baku_id`, `kuantitas`, `created_at`, `updated_at`) VALUES
	(10, 7, 5, 1.00, '2025-06-22 03:51:45', '2025-06-22 03:51:53');

-- Dumping structure for table hpp-penjualan-laravel.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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.roles: ~2 rows (approximately)
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'super_admin', 'web', '2025-06-20 13:03:37', '2025-06-20 13:03:37');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(2, 'asd', 'web', '2025-06-20 13:07:32', '2025-06-20 13:07:32');

-- Dumping structure for table hpp-penjualan-laravel.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 hpp-penjualan-laravel.role_has_permissions: ~151 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);

-- Dumping structure for table hpp-penjualan-laravel.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 hpp-penjualan-laravel.sessions: ~2 rows (approximately)
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('5qFHHB3zYtNGjhjNmSCaOebl7FsRrgwDqAAYhnzt', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoick9VTTJyMm1xREQ4eHRWVDJ4Q2tuVEp4ZDNnTXdqYkprQ09kRVRHQiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozMzoiaHR0cDovL2hwcC1wZW5qdWFsYW4tbGFyYXZlbC50ZXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1750609640);
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('QPDHJLjKWrTieBkZ9c4rMMa9T5AJKJEVxXKs5PfD', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiSU9nQzM4R2w0TGduWGE3aWMzc0hwb0ZNclNhNWxxeTNmeFN1UndQMCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMzOiJodHRwOi8vaHBwLXBlbmp1YWxhbi1sYXJhdmVsLnRlc3QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfM2RjN2E5MTNlZjVmZDRiODkwZWNhYmUzNDg3MDg1NTczZTE2Y2Y4MiI7aToxO3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTIkcFZVWFZoaXVrQzFwRnFuWW93dUl4dWxOMy45TkNBMnFiL3QwWWtRdGlxdW0uVUtJTzFVU20iO3M6ODoiZmlsYW1lbnQiO2E6MDp7fX0=', 1750600498);

-- Dumping structure for table hpp-penjualan-laravel.stok_keluars
CREATE TABLE IF NOT EXISTS `stok_keluars` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `invoice_item_id` bigint(20) unsigned DEFAULT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stok_keluars_product_id_foreign` (`product_id`),
  KEY `stok_keluars_invoice_item_id_foreign` (`invoice_item_id`),
  CONSTRAINT `stok_keluars_invoice_item_id_foreign` FOREIGN KEY (`invoice_item_id`) REFERENCES `invoice_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `stok_keluars_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.stok_keluars: ~3 rows (approximately)
INSERT INTO `stok_keluars` (`id`, `product_id`, `invoice_item_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
	(10, 6, 24, '2025-06-22', 1, 'Transaksi Penjualan', '2025-06-22 20:07:36', '2025-06-22 20:07:36');
INSERT INTO `stok_keluars` (`id`, `product_id`, `invoice_item_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
	(11, 7, 25, '2025-06-22', 2, 'Transaksi Penjualan', '2025-06-22 20:07:42', '2025-06-22 20:07:42');
INSERT INTO `stok_keluars` (`id`, `product_id`, `invoice_item_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
	(12, 7, 26, '2025-06-22', 1, 'Transaksi Penjualan', '2025-06-22 20:07:57', '2025-06-22 20:07:57');

-- Dumping structure for table hpp-penjualan-laravel.stok_masuks
CREATE TABLE IF NOT EXISTS `stok_masuks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stok_masuks_product_id_foreign` (`product_id`),
  CONSTRAINT `stok_masuks_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table hpp-penjualan-laravel.stok_masuks: ~0 rows (approximately)

