-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 30, 2026 at 04:32 PM -- Server version: 8.0.30 -- PHP Version: 8.1.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `laraveltprod` -- -- -------------------------------------------------------- -- -- Table structure for table `bahan` -- CREATE TABLE `bahan` ( `id` bigint UNSIGNED NOT NULL, `nama` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `bahan` -- INSERT INTO `bahan` (`id`, `nama`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Kedelai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, 'Karet', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, 'Kapas', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, 'Gula', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, 'Garam', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, 'Minyak', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, 'Tepung', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, 'Plastik Kemasan', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, 'Ragi', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, 'Air Mineral', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `connection` text COLLATE utf8mb3_unicode_ci NOT NULL, `queue` text COLLATE utf8mb3_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb3_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb3_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `hasilpanen` -- CREATE TABLE `hasilpanen` ( `id` bigint UNSIGNED NOT NULL, `bahan_id` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `tgl_pelaporan` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `petani_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `waktu_panen` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `jml` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `kualitas` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `hasilpanen` -- INSERT INTO `hasilpanen` (`id`, `bahan_id`, `tgl_pelaporan`, `petani_id`, `waktu_panen`, `jml`, `kualitas`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, '1', '2026-06-21', '1', '2026-06-21', '525', 'Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, '2', '2026-06-22', '2', '2026-06-22', '550', 'Sangat Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, '3', '2026-06-23', '3', '2026-06-23', '575', 'Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, '4', '2026-06-24', '4', '2026-06-24', '600', 'Sangat Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, '5', '2026-06-25', '5', '2026-06-25', '625', 'Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, '6', '2026-06-26', '6', '2026-06-26', '650', 'Sangat Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, '7', '2026-06-27', '7', '2026-06-27', '675', 'Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, '8', '2026-06-28', '8', '2026-06-28', '700', 'Sangat Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, '9', '2026-06-29', '9', '2026-06-29', '725', 'Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, '10', '2026-06-30', '10', '2026-06-30', '750', 'Sangat Baik', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `kategori` -- CREATE TABLE `kategori` ( `id` bigint UNSIGNED NOT NULL, `nama` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `prefix` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `kode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `kategori` -- INSERT INTO `kategori` (`id`, `nama`, `prefix`, `kode`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Supervisor Area 1', 'kelompoktani', 'SPV01', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, 'Supervisor Area 2', 'kelompoktani', 'SPV02', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, 'Supervisor Area 3', 'kelompoktani', 'SPV03', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, 'Supervisor Area 4', 'kelompoktani', 'SPV04', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, 'Supervisor Area 7', 'kelompoktani', 'SPV07', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, 'Supervisor Area 8', 'kelompoktani', 'SPV08', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, 'Supervisor Area 9', 'kelompoktani', 'SPV09', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, 'Supervisor Area 10', 'kelompoktani', 'SPV10', '2026-06-30 16:32:36', '2026-06-30 15:55:14', '2026-06-30 16:32:36'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1), (4, '2019_08_19_000000_create_failed_jobs_table', 1), (5, '2019_12_14_000001_create_personal_access_tokens_table', 1), (6, '2021_08_04_141828_create_sessions_table', 1), (7, '2021_08_06_155146_create_settings_table', 1), (8, '2021_11_12_212058_create_kategori_table', 1), (9, '2022_01_27_073840_create_bahan_table', 1), (10, '2022_01_27_073856_create_hasilpanen_table', 1), (11, '2022_01_27_073911_create_pengolahanbahan_table', 1), (12, '2022_01_27_073923_create_petani_table', 1), (13, '2022_01_27_073935_create_produk_table', 1), (14, '2022_01_27_074008_create_produkrugilaba_table', 1), (15, '2026_06_30_000001_create_monitoring_target_produksi_tables', 1), (16, '2026_06_30_231600_allow_deleted_users_on_production_tables', 2); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pengolahanbahan` -- CREATE TABLE `pengolahanbahan` ( `id` bigint UNSIGNED NOT NULL, `tgl` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `hasilpanen_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `waktupengolahan` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `jml_pengolahan` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `hasil_pengolahan` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `produk_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `jml` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `pengolahanbahan` -- INSERT INTO `pengolahanbahan` (`id`, `tgl`, `hasilpanen_id`, `waktupengolahan`, `jml_pengolahan`, `hasil_pengolahan`, `produk_id`, `jml`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, '2026-06-21', '1', '2026-06-21', '320', 'Baik', '1', '265', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, '2026-06-22', '2', '2026-06-22', '340', 'Baik', '2', '280', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, '2026-06-23', '3', '2026-06-23', '360', 'Baik', '3', '295', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, '2026-06-24', '4', '2026-06-24', '380', 'Baik', '4', '310', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, '2026-06-25', '5', '2026-06-25', '400', 'Baik', '5', '325', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, '2026-06-26', '6', '2026-06-26', '420', 'Baik', '6', '340', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, '2026-06-27', '7', '2026-06-27', '440', 'Baik', '7', '355', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, '2026-06-28', '8', '2026-06-28', '460', 'Baik', '8', '370', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, '2026-06-29', '9', '2026-06-29', '480', 'Baik', '9', '385', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, '2026-06-30', '10', '2026-06-30', '500', 'Baik', '10', '400', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb3_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb3_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `petani` -- CREATE TABLE `petani` ( `id` bigint UNSIGNED NOT NULL, `nama` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `kategori_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `petani` -- INSERT INTO `petani` (`id`, `nama`, `kategori_id`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Operator Lapangan 1', '1', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, 'Operator Lapangan 2', '2', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, 'Operator Lapangan 3', '3', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, 'Operator Lapangan 4', '4', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, 'Operator Lapangan 5', '5', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, 'Operator Lapangan 6', '6', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, 'Operator Lapangan 7', '7', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, 'Operator Lapangan 8', '8', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, 'Operator Lapangan 9', '9', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, 'Operator Lapangan 10', '10', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `produk` -- CREATE TABLE `produk` ( `id` bigint UNSIGNED NOT NULL, `nama` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `hargajual` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `produk` -- INSERT INTO `produk` (`id`, `nama`, `hargajual`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Tempe Premium', '10000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, 'Tahu Putih', '8000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, 'Keripik Tempe', '15000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, 'Susu Kedelai', '7000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, 'Kecap Kedelai', '12000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, 'Bantal Kapas', '25000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, 'Sandal Karet', '18000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, 'Kemasan Plastik', '5000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, 'Adonan Siap Olah', '20000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, 'Paket Produk Campur', '30000', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `produkrugilaba` -- CREATE TABLE `produkrugilaba` ( `id` bigint UNSIGNED NOT NULL, `tgl` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `produk_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `jml_terjual` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `produkrugilaba` -- INSERT INTO `produkrugilaba` (`id`, `tgl`, `produk_id`, `jml_terjual`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, '2026-06-21', '1', '130', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, '2026-06-22', '2', '140', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, '2026-06-23', '3', '150', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, '2026-06-24', '4', '160', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, '2026-06-25', '5', '170', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, '2026-06-26', '6', '180', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, '2026-06-27', '7', '190', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, '2026-06-28', '8', '200', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, '2026-06-29', '9', '210', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, '2026-06-30', '10', '220', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `realisasi_produksi` -- CREATE TABLE `realisasi_produksi` ( `id` bigint UNSIGNED NOT NULL, `target_id` bigint UNSIGNED NOT NULL, `jam_input` time NOT NULL, `jumlah` int UNSIGNED NOT NULL, `created_by` bigint UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `realisasi_produksi` -- INSERT INTO `realisasi_produksi` (`id`, `target_id`, `jam_input`, `jumlah`, `created_by`, `created_at`, `updated_at`) VALUES (1, 1, '08:00:00', 200, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, 1, '10:00:00', 235, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, 1, '13:00:00', 270, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, 1, '16:00:00', 305, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, 2, '08:00:00', 220, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, 2, '10:00:00', 255, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, 2, '13:00:00', 290, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, 2, '16:00:00', 325, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, 3, '08:00:00', 240, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, 3, '10:00:00', 275, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (11, 3, '13:00:00', 310, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (12, 3, '16:00:00', 345, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (13, 4, '08:00:00', 260, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (14, 4, '10:00:00', 295, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (15, 4, '13:00:00', 330, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (16, 4, '16:00:00', 365, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (17, 5, '08:00:00', 280, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (18, 5, '10:00:00', 315, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (19, 5, '13:00:00', 350, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (20, 5, '16:00:00', 385, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (21, 6, '08:00:00', 300, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (22, 6, '10:00:00', 335, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (23, 6, '13:00:00', 370, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (24, 6, '16:00:00', 405, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (25, 7, '08:00:00', 320, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (26, 7, '10:00:00', 355, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (27, 7, '13:00:00', 390, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (28, 7, '16:00:00', 425, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (29, 8, '08:00:00', 340, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (30, 8, '10:00:00', 375, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (31, 8, '13:00:00', 410, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (32, 8, '16:00:00', 445, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (33, 9, '08:00:00', 360, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (34, 9, '10:00:00', 395, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (35, 9, '13:00:00', 430, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (36, 9, '16:00:00', 465, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (37, 10, '08:00:00', 380, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (38, 10, '10:00:00', 415, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (39, 10, '13:00:00', 450, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (40, 10, '16:00:00', 485, NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `user_id` bigint UNSIGNED DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb3_unicode_ci, `payload` text COLLATE utf8mb3_unicode_ci NOT NULL, `last_activity` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('7gOqrd8rZ3ZrqjSMTeRJIyFK9Nqyk6Nzfsmaa3JG', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'YTo2OntzOjM6InVybCI7YTowOnt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hZG1pbi9oYXNpbHBhbmVuIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo2OiJfdG9rZW4iO3M6NDA6IjZhTldVQ2FJSVN5U3Z1U1ZXUUM5aWY3bmx0aXhWck9hR1lsRVM1MFoiO3M6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7czoxNzoicGFzc3dvcmRfaGFzaF93ZWIiO3M6NjA6IiQyeSQxMCRDaVNncG9CM1BRYmF1NnNWcjBhb0VlMHF1MUQ2RVlZa0xrYzgwaHdaRVV1bG1nQ1IzdWhxRyI7fQ==', 1782837164), ('mNkPTJOtyhtYtTAMqXTYjPPXNwHEHPbixUsnYIX3', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.126.0 Chrome/148.0.7778.97 Electron/42.2.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVmRPNXlhbVhKdzY3M1dBNmNjaFV2M01WMmtZYzNMMjBpUktTbWdqMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi91c2VycyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7czoxNzoicGFzc3dvcmRfaGFzaF93ZWIiO3M6NjA6IiQyeSQxMCRHSTdHM2FlNnd5MlE1ckFmNzJNWHF1Z1BBV0JnU0tQblNNUDVZSTI5YTdCU0lJdWJNYU1XLiI7fQ==', 1782836237); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` bigint UNSIGNED NOT NULL, `app_nama` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `app_namapendek` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `paginationjml` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `lembaga_nama` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `lembaga_jalan` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `lembaga_telp` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `lembaga_kota` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `lembaga_logo` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `sekolahttd` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `app_nama`, `app_namapendek`, `paginationjml`, `lembaga_nama`, `lembaga_jalan`, `lembaga_telp`, `lembaga_kota`, `lembaga_logo`, `sekolahttd`, `created_at`, `updated_at`) VALUES (1, 'Aplikasi Produksi', 'AP', '10', 'PT Produksi Nusantara', 'Jl. Industri No. 10', '0341-123121', 'Malang', 'assets/upload/logo.png', 'Manager Produksi', '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `target_produksi` -- CREATE TABLE `target_produksi` ( `id` bigint UNSIGNED NOT NULL, `tanggal` date NOT NULL, `produk_id` bigint UNSIGNED NOT NULL, `target` int UNSIGNED NOT NULL, `shift` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL, `operator_id` bigint UNSIGNED DEFAULT NULL, `status` varchar(30) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'ongoing', `created_by` bigint UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `target_produksi` -- INSERT INTO `target_produksi` (`id`, `tanggal`, `produk_id`, `target`, `shift`, `operator_id`, `status`, `created_by`, `created_at`, `updated_at`) VALUES (1, '2026-06-21', 1, 1100, 'Shift 1', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, '2026-06-22', 2, 1200, 'Shift 2', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, '2026-06-23', 3, 1300, 'Shift 3', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (4, '2026-06-24', 4, 1400, 'Shift 1', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (5, '2026-06-25', 5, 1500, 'Shift 2', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (6, '2026-06-26', 6, 1600, 'Shift 3', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (7, '2026-06-27', 7, 1700, 'Shift 1', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (8, '2026-06-28', 8, 1800, 'Shift 2', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (9, '2026-06-29', 9, 1900, 'Shift 3', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (10, '2026-06-30', 10, 2000, 'Shift 1', NULL, 'belum tercapai', NULL, '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `tipeuser` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `nomerinduk` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL, `two_factor_secret` text COLLATE utf8mb3_unicode_ci, `two_factor_recovery_codes` text COLLATE utf8mb3_unicode_ci, `remember_token` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `current_team_id` bigint UNSIGNED DEFAULT NULL, `profile_photo_path` varchar(2048) COLLATE utf8mb3_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `tipeuser`, `nomerinduk`, `username`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `remember_token`, `current_team_id`, `profile_photo_path`, `created_at`, `updated_at`) VALUES (1, 'Paimin', 'admin@gmail.com', 'admin', '1', 'admin', NULL, '$2y$10$CiSgpoB3PQbau6sVr0aoEe0qu1D6EYYkLkc80hwZEUulmgCR3uhqG', NULL, NULL, NULL, NULL, NULL, '2023-03-01 06:08:28', '2023-03-01 06:08:28'), (2, 'Pegawai', 'pegawai@gmail.com', 'pegawai', '2', 'pegawai', NULL, '$2y$10$RTZO4djWDczpAqPBbVsjH.qSTR6ZsY6c0uEGJ.tfONc.JqSt8dUwm', NULL, NULL, NULL, NULL, NULL, '2023-03-01 06:08:28', '2023-03-01 06:08:28'), (3, 'Manajer', 'manajer@gmail.com', 'manajer', '3', 'manajer', NULL, '$2y$10$dXOpF6Dt5H95NLHcF8x.6evnqjUxsf.vGEHf/B9rZao2yJ2oaHcny', NULL, NULL, NULL, NULL, NULL, '2023-03-01 06:08:28', '2023-03-01 06:08:28'); -- -------------------------------------------------------- -- -- Table structure for table `verifikasi_produksi` -- CREATE TABLE `verifikasi_produksi` ( `id` bigint UNSIGNED NOT NULL, `target_id` bigint UNSIGNED NOT NULL, `manager_id` bigint UNSIGNED DEFAULT NULL, `status` varchar(30) COLLATE utf8mb3_unicode_ci NOT NULL, `catatan` text COLLATE utf8mb3_unicode_ci, `verified_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `verifikasi_produksi` -- INSERT INTO `verifikasi_produksi` (`id`, `target_id`, `manager_id`, `status`, `catatan`, `verified_at`, `created_at`, `updated_at`) VALUES (1, 3, NULL, 'belum_disetujui', 'Evaluasi: produksi belum mencapai target harian.', '2026-06-30 15:55:14', '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (2, 6, NULL, 'belum_disetujui', 'Evaluasi: produksi belum mencapai target harian.', '2026-06-30 15:55:14', '2026-06-30 15:55:14', '2026-06-30 15:55:14'), (3, 9, NULL, 'belum_disetujui', 'Evaluasi: produksi belum mencapai target harian.', '2026-06-30 15:55:14', '2026-06-30 15:55:14', '2026-06-30 15:55:14'); -- -- Indexes for dumped tables -- -- -- Indexes for table `bahan` -- ALTER TABLE `bahan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `hasilpanen` -- ALTER TABLE `hasilpanen` ADD PRIMARY KEY (`id`); -- -- Indexes for table `kategori` -- ALTER TABLE `kategori` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `pengolahanbahan` -- ALTER TABLE `pengolahanbahan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `petani` -- ALTER TABLE `petani` ADD PRIMARY KEY (`id`); -- -- Indexes for table `produk` -- ALTER TABLE `produk` ADD PRIMARY KEY (`id`); -- -- Indexes for table `produkrugilaba` -- ALTER TABLE `produkrugilaba` ADD PRIMARY KEY (`id`); -- -- Indexes for table `realisasi_produksi` -- ALTER TABLE `realisasi_produksi` ADD PRIMARY KEY (`id`), ADD KEY `realisasi_produksi_target_id_jam_input_index` (`target_id`,`jam_input`), ADD KEY `realisasi_produksi_created_by_foreign` (`created_by`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `target_produksi` -- ALTER TABLE `target_produksi` ADD PRIMARY KEY (`id`), ADD KEY `target_produksi_produk_id_foreign` (`produk_id`), ADD KEY `target_produksi_tanggal_status_index` (`tanggal`,`status`), ADD KEY `target_produksi_operator_id_tanggal_index` (`operator_id`,`tanggal`), ADD KEY `target_produksi_created_by_foreign` (`created_by`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `verifikasi_produksi` -- ALTER TABLE `verifikasi_produksi` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `verifikasi_produksi_target_id_unique` (`target_id`), ADD KEY `verifikasi_produksi_manager_id_foreign` (`manager_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bahan` -- ALTER TABLE `bahan` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `hasilpanen` -- ALTER TABLE `hasilpanen` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `kategori` -- ALTER TABLE `kategori` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `pengolahanbahan` -- ALTER TABLE `pengolahanbahan` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `petani` -- ALTER TABLE `petani` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `produk` -- ALTER TABLE `produk` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `produkrugilaba` -- ALTER TABLE `produkrugilaba` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `realisasi_produksi` -- ALTER TABLE `realisasi_produksi` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `target_produksi` -- ALTER TABLE `target_produksi` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `verifikasi_produksi` -- ALTER TABLE `verifikasi_produksi` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- Constraints for dumped tables -- -- -- Constraints for table `realisasi_produksi` -- ALTER TABLE `realisasi_produksi` ADD CONSTRAINT `realisasi_produksi_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `realisasi_produksi_target_id_foreign` FOREIGN KEY (`target_id`) REFERENCES `target_produksi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `target_produksi` -- ALTER TABLE `target_produksi` ADD CONSTRAINT `target_produksi_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `target_produksi_operator_id_foreign` FOREIGN KEY (`operator_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `target_produksi_produk_id_foreign` FOREIGN KEY (`produk_id`) REFERENCES `produk` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE; -- -- Constraints for table `verifikasi_produksi` -- ALTER TABLE `verifikasi_produksi` ADD CONSTRAINT `verifikasi_produksi_manager_id_foreign` FOREIGN KEY (`manager_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `verifikasi_produksi_target_id_foreign` FOREIGN KEY (`target_id`) REFERENCES `target_produksi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;