-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 5.7.33 - MySQL Community Server (GPL) -- Server OS: Win64 -- HeidiSQL Version: 11.2.0.6213 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- 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) /*!40000 ALTER TABLE `bahan_bakus` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `bahan_bakus` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `banks` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `banks` ENABLE KEYS */; -- Dumping structure for table hpp-penjualan-laravel.breezy_sessions CREATE TABLE IF NOT EXISTS `breezy_sessions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `authenticatable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `authenticatable_id` bigint(20) unsigned NOT NULL, `panel_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `guard` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `expires_at` timestamp NULL DEFAULT NULL, `two_factor_secret` text COLLATE utf8mb4_unicode_ci, `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci, `two_factor_confirmed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `breezy_sessions_authenticatable_type_authenticatable_id_index` (`authenticatable_type`,`authenticatable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table hpp-penjualan-laravel.breezy_sessions: ~0 rows (approximately) /*!40000 ALTER TABLE `breezy_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `breezy_sessions` ENABLE KEYS */; -- Dumping structure for table hpp-penjualan-laravel.cache CREATE TABLE IF NOT EXISTS `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table hpp-penjualan-laravel.cache: ~5 rows (approximately) /*!40000 ALTER TABLE `cache` DISABLE KEYS */; INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel_cache_356a192b7913b04c54574d18c28d46e6395428ab', 'i:1;', 1750598745); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel_cache_356a192b7913b04c54574d18c28d46e6395428ab:timer', 'i:1750598745;', 1750598745); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel_cache_livewire-rate-limiter:a17961fa74e9275d529f489537f179c05d50c2f3', 'i:1;', 1750596856); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel_cache_livewire-rate-limiter:a17961fa74e9275d529f489537f179c05d50c2f3:timer', 'i:1750596856;', 1750596856); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel_cache_spatie.permission.cache', 'a:3:{s:5:"alias";a:4:{s:1:"a";s:2:"id";s:1:"b";s:4:"name";s:1:"c";s:10:"guard_name";s:1:"r";s:5:"roles";}s:11:"permissions";a:152:{i:0;a:4:{s:1:"a";i:1;s:1:"b";s:9:"view_role";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:1;a:4:{s:1:"a";i:2;s:1:"b";s:13:"view_any_role";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:2;a:4:{s:1:"a";i:3;s:1:"b";s:11:"create_role";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:3;a:4:{s:1:"a";i:4;s:1:"b";s:11:"update_role";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:4;a:4:{s:1:"a";i:5;s:1:"b";s:11:"delete_role";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:5;a:4:{s:1:"a";i:6;s:1:"b";s:15:"delete_any_role";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:6;a:4:{s:1:"a";i:7;s:1:"b";s:16:"view_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:7;a:4:{s:1:"a";i:8;s:1:"b";s:20:"view_any_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:8;a:4:{s:1:"a";i:9;s:1:"b";s:18:"create_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:9;a:4:{s:1:"a";i:10;s:1:"b";s:18:"update_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:10;a:4:{s:1:"a";i:11;s:1:"b";s:19:"restore_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:11;a:4:{s:1:"a";i:12;s:1:"b";s:23:"restore_any_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:12;a:4:{s:1:"a";i:13;s:1:"b";s:21:"replicate_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:13;a:4:{s:1:"a";i:14;s:1:"b";s:19:"reorder_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:14;a:4:{s:1:"a";i:15;s:1:"b";s:18:"delete_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:15;a:4:{s:1:"a";i:16;s:1:"b";s:22:"delete_any_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:16;a:4:{s:1:"a";i:17;s:1:"b";s:24:"force_delete_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:17;a:4:{s:1:"a";i:18;s:1:"b";s:28:"force_delete_any_bahan::baku";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:18;a:4:{s:1:"a";i:19;s:1:"b";s:12:"view_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:19;a:4:{s:1:"a";i:20;s:1:"b";s:16:"view_any_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:20;a:4:{s:1:"a";i:21;s:1:"b";s:14:"create_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:21;a:4:{s:1:"a";i:22;s:1:"b";s:14:"update_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:22;a:4:{s:1:"a";i:23;s:1:"b";s:15:"restore_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:23;a:4:{s:1:"a";i:24;s:1:"b";s:19:"restore_any_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:24;a:4:{s:1:"a";i:25;s:1:"b";s:17:"replicate_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:25;a:4:{s:1:"a";i:26;s:1:"b";s:15:"reorder_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:26;a:4:{s:1:"a";i:27;s:1:"b";s:14:"delete_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:27;a:4:{s:1:"a";i:28;s:1:"b";s:18:"delete_any_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:28;a:4:{s:1:"a";i:29;s:1:"b";s:20:"force_delete_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:29;a:4:{s:1:"a";i:30;s:1:"b";s:24:"force_delete_any_invoice";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:30;a:4:{s:1:"a";i:31;s:1:"b";s:18:"view_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:31;a:4:{s:1:"a";i:32;s:1:"b";s:22:"view_any_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:32;a:4:{s:1:"a";i:33;s:1:"b";s:20:"create_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:33;a:4:{s:1:"a";i:34;s:1:"b";s:20:"update_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:34;a:4:{s:1:"a";i:35;s:1:"b";s:21:"restore_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:35;a:4:{s:1:"a";i:36;s:1:"b";s:25:"restore_any_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:36;a:4:{s:1:"a";i:37;s:1:"b";s:23:"replicate_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:37;a:4:{s:1:"a";i:38;s:1:"b";s:21:"reorder_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:38;a:4:{s:1:"a";i:39;s:1:"b";s:20:"delete_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:39;a:4:{s:1:"a";i:40;s:1:"b";s:24:"delete_any_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:40;a:4:{s:1:"a";i:41;s:1:"b";s:26:"force_delete_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:41;a:4:{s:1:"a";i:42;s:1:"b";s:30:"force_delete_any_invoice::item";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:42;a:4:{s:1:"a";i:43;s:1:"b";s:12:"view_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:43;a:4:{s:1:"a";i:44;s:1:"b";s:16:"view_any_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:44;a:4:{s:1:"a";i:45;s:1:"b";s:14:"create_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:45;a:4:{s:1:"a";i:46;s:1:"b";s:14:"update_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:46;a:4:{s:1:"a";i:47;s:1:"b";s:15:"restore_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:47;a:4:{s:1:"a";i:48;s:1:"b";s:19:"restore_any_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:48;a:4:{s:1:"a";i:49;s:1:"b";s:17:"replicate_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:49;a:4:{s:1:"a";i:50;s:1:"b";s:15:"reorder_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:50;a:4:{s:1:"a";i:51;s:1:"b";s:14:"delete_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:51;a:4:{s:1:"a";i:52;s:1:"b";s:18:"delete_any_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:52;a:4:{s:1:"a";i:53;s:1:"b";s:20:"force_delete_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:53;a:4:{s:1:"a";i:54;s:1:"b";s:24:"force_delete_any_product";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:54;a:4:{s:1:"a";i:55;s:1:"b";s:13:"view_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:55;a:4:{s:1:"a";i:56;s:1:"b";s:17:"view_any_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:56;a:4:{s:1:"a";i:57;s:1:"b";s:15:"create_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:57;a:4:{s:1:"a";i:58;s:1:"b";s:15:"update_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:58;a:4:{s:1:"a";i:59;s:1:"b";s:16:"restore_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:59;a:4:{s:1:"a";i:60;s:1:"b";s:20:"restore_any_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:60;a:4:{s:1:"a";i:61;s:1:"b";s:18:"replicate_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:61;a:4:{s:1:"a";i:62;s:1:"b";s:16:"reorder_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:62;a:4:{s:1:"a";i:63;s:1:"b";s:15:"delete_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:63;a:4:{s:1:"a";i:64;s:1:"b";s:19:"delete_any_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:64;a:4:{s:1:"a";i:65;s:1:"b";s:21:"force_delete_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:65;a:4:{s:1:"a";i:66;s:1:"b";s:25:"force_delete_any_produksi";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:66;a:4:{s:1:"a";i:67;s:1:"b";s:18:"view_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:67;a:4:{s:1:"a";i:68;s:1:"b";s:22:"view_any_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:68;a:4:{s:1:"a";i:69;s:1:"b";s:20:"create_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:69;a:4:{s:1:"a";i:70;s:1:"b";s:20:"update_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:70;a:4:{s:1:"a";i:71;s:1:"b";s:21:"restore_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:71;a:4:{s:1:"a";i:72;s:1:"b";s:25:"restore_any_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:72;a:4:{s:1:"a";i:73;s:1:"b";s:23:"replicate_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:73;a:4:{s:1:"a";i:74;s:1:"b";s:21:"reorder_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:74;a:4:{s:1:"a";i:75;s:1:"b";s:20:"delete_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:75;a:4:{s:1:"a";i:76;s:1:"b";s:24:"delete_any_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:76;a:4:{s:1:"a";i:77;s:1:"b";s:26:"force_delete_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:77;a:4:{s:1:"a";i:78;s:1:"b";s:30:"force_delete_any_resep::produk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:78;a:4:{s:1:"a";i:79;s:1:"b";s:17:"view_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:79;a:4:{s:1:"a";i:80;s:1:"b";s:21:"view_any_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:80;a:4:{s:1:"a";i:81;s:1:"b";s:19:"create_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:81;a:4:{s:1:"a";i:82;s:1:"b";s:19:"update_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:82;a:4:{s:1:"a";i:83;s:1:"b";s:20:"restore_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:83;a:4:{s:1:"a";i:84;s:1:"b";s:24:"restore_any_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:84;a:4:{s:1:"a";i:85;s:1:"b";s:22:"replicate_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:85;a:4:{s:1:"a";i:86;s:1:"b";s:20:"reorder_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:86;a:4:{s:1:"a";i:87;s:1:"b";s:19:"delete_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:87;a:4:{s:1:"a";i:88;s:1:"b";s:23:"delete_any_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:88;a:4:{s:1:"a";i:89;s:1:"b";s:25:"force_delete_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:89;a:4:{s:1:"a";i:90;s:1:"b";s:29:"force_delete_any_stok::keluar";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:90;a:4:{s:1:"a";i:91;s:1:"b";s:16:"view_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:91;a:4:{s:1:"a";i:92;s:1:"b";s:20:"view_any_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:92;a:4:{s:1:"a";i:93;s:1:"b";s:18:"create_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:93;a:4:{s:1:"a";i:94;s:1:"b";s:18:"update_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:94;a:4:{s:1:"a";i:95;s:1:"b";s:19:"restore_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:95;a:4:{s:1:"a";i:96;s:1:"b";s:23:"restore_any_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:96;a:4:{s:1:"a";i:97;s:1:"b";s:21:"replicate_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:97;a:4:{s:1:"a";i:98;s:1:"b";s:19:"reorder_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:98;a:4:{s:1:"a";i:99;s:1:"b";s:18:"delete_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:99;a:4:{s:1:"a";i:100;s:1:"b";s:22:"delete_any_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:100;a:4:{s:1:"a";i:101;s:1:"b";s:24:"force_delete_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:101;a:4:{s:1:"a";i:102;s:1:"b";s:28:"force_delete_any_stok::masuk";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:102;a:4:{s:1:"a";i:103;s:1:"b";s:9:"view_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:103;a:4:{s:1:"a";i:104;s:1:"b";s:13:"view_any_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:104;a:4:{s:1:"a";i:105;s:1:"b";s:11:"create_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:105;a:4:{s:1:"a";i:106;s:1:"b";s:11:"update_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:106;a:4:{s:1:"a";i:107;s:1:"b";s:12:"restore_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:107;a:4:{s:1:"a";i:108;s:1:"b";s:16:"restore_any_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:108;a:4:{s:1:"a";i:109;s:1:"b";s:14:"replicate_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:109;a:4:{s:1:"a";i:110;s:1:"b";s:12:"reorder_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:110;a:4:{s:1:"a";i:111;s:1:"b";s:11:"delete_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:111;a:4:{s:1:"a";i:112;s:1:"b";s:15:"delete_any_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:112;a:4:{s:1:"a";i:113;s:1:"b";s:17:"force_delete_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:113;a:4:{s:1:"a";i:114;s:1:"b";s:21:"force_delete_any_user";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:114;a:4:{s:1:"a";i:115;s:1:"b";s:18:"page_MyProfilePage";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:115;a:4:{s:1:"a";i:116;s:1:"b";s:14:"view_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:116;a:4:{s:1:"a";i:117;s:1:"b";s:18:"view_any_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:117;a:4:{s:1:"a";i:118;s:1:"b";s:16:"create_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:118;a:4:{s:1:"a";i:119;s:1:"b";s:16:"update_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:119;a:4:{s:1:"a";i:120;s:1:"b";s:17:"restore_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:120;a:4:{s:1:"a";i:121;s:1:"b";s:21:"restore_any_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:121;a:4:{s:1:"a";i:122;s:1:"b";s:19:"replicate_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:122;a:4:{s:1:"a";i:123;s:1:"b";s:17:"reorder_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:123;a:4:{s:1:"a";i:124;s:1:"b";s:16:"delete_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:124;a:4:{s:1:"a";i:125;s:1:"b";s:20:"delete_any_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:125;a:4:{s:1:"a";i:126;s:1:"b";s:22:"force_delete_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:126;a:4:{s:1:"a";i:127;s:1:"b";s:26:"force_delete_any_pelanggan";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:127;a:4:{s:1:"a";i:128;s:1:"b";s:9:"view_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:128;a:4:{s:1:"a";i:129;s:1:"b";s:13:"view_any_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:129;a:4:{s:1:"a";i:130;s:1:"b";s:11:"create_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:130;a:4:{s:1:"a";i:131;s:1:"b";s:11:"update_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:131;a:4:{s:1:"a";i:132;s:1:"b";s:12:"restore_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:132;a:4:{s:1:"a";i:133;s:1:"b";s:16:"restore_any_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:133;a:4:{s:1:"a";i:134;s:1:"b";s:14:"replicate_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:134;a:4:{s:1:"a";i:135;s:1:"b";s:12:"reorder_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:135;a:4:{s:1:"a";i:136;s:1:"b";s:11:"delete_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:136;a:4:{s:1:"a";i:137;s:1:"b";s:15:"delete_any_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:137;a:4:{s:1:"a";i:138;s:1:"b";s:17:"force_delete_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:138;a:4:{s:1:"a";i:139;s:1:"b";s:21:"force_delete_any_bank";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:139;a:4:{s:1:"a";i:140;s:1:"b";s:17:"view_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:140;a:4:{s:1:"a";i:141;s:1:"b";s:21:"view_any_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:141;a:4:{s:1:"a";i:142;s:1:"b";s:19:"create_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:142;a:4:{s:1:"a";i:143;s:1:"b";s:19:"update_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:143;a:4:{s:1:"a";i:144;s:1:"b";s:20:"restore_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:144;a:4:{s:1:"a";i:145;s:1:"b";s:24:"restore_any_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:145;a:4:{s:1:"a";i:146;s:1:"b";s:22:"replicate_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:146;a:4:{s:1:"a";i:147;s:1:"b";s:20:"reorder_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:147;a:4:{s:1:"a";i:148;s:1:"b";s:19:"delete_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:148;a:4:{s:1:"a";i:149;s:1:"b";s:23:"delete_any_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:149;a:4:{s:1:"a";i:150;s:1:"b";s:25:"force_delete_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:150;a:4:{s:1:"a";i:151;s:1:"b";s:29:"force_delete_any_profile::app";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}i:151;a:4:{s:1:"a";i:152;s:1:"b";s:20:"widget_TerlarisChart";s:1:"c";s:3:"web";s:1:"r";a:1:{i:0;i:1;}}}s:5:"roles";a:1:{i:0;a:3:{s:1:"a";i:1;s:1:"b";s:11:"super_admin";s:1:"c";s:3:"web";}}}', 1750684996); /*!40000 ALTER TABLE `cache` ENABLE KEYS */; -- Dumping structure for table hpp-penjualan-laravel.cache_locks CREATE TABLE IF NOT EXISTS `cache_locks` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table hpp-penjualan-laravel.cache_locks: ~0 rows (approximately) /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */; -- Dumping structure for table hpp-penjualan-laravel.password_reset_tokens CREATE TABLE IF NOT EXISTS `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table hpp-penjualan-laravel.password_reset_tokens: ~0 rows (approximately) /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `pelanggans` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `pelanggans` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `products` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `produksis` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `produksis` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `profile_apps` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `profile_apps` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `resep_produks` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `resep_produks` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `roles` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `stok_keluars` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `stok_keluars` ENABLE KEYS */; -- 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) /*!40000 ALTER TABLE `stok_masuks` DISABLE KEYS */; /*!40000 ALTER TABLE `stok_masuks` ENABLE KEYS */; -- Dumping structure for table hpp-penjualan-laravel.users CREATE TABLE IF NOT EXISTS `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table hpp-penjualan-laravel.users: ~2 rows (approximately) /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin Utama', 'admin@example.com', NULL, '$2y$12$pVUXVhiukC1pFqnYowuIxulN3.9NCA2qb/t0YkQtiqum.UKIO1USm', NULL, '2025-06-20 05:41:24', '2025-06-20 05:41:24'); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (2, 'asdasd', 'asdasd@example.com', NULL, '$2y$12$aEPCVZdu3z9Hbr3S31fGWe3nXKoItY/Hzi1TGS.9u3xCb8CWuF7Mm', NULL, '2025-06-20 13:07:42', '2025-06-20 13:07:42'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;