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

START TRANSACTION;



--
-- 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 `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 `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 `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 `pengolahanbahan`
--
ALTER TABLE `pengolahanbahan`
  ADD PRIMARY KEY (`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 `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 `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 `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;

