-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 30, 2024 at 10:57 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: `pickup_service` -- -- -------------------------------------------------------- -- -- Table structure for table `checkbox_options` -- CREATE TABLE `checkbox_options` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `price` int NOT NULL, `handling_fee` int NOT NULL, `selected` tinyint(1) NOT NULL DEFAULT '0', `kode_pu` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `checkbox_options` -- INSERT INTO `checkbox_options` (`id`, `name`, `price`, `handling_fee`, `selected`, `kode_pu`, `created_at`, `updated_at`) VALUES (25, 'Filter Oli Bosch', 150000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:19:43'), (26, 'Busi Denso', 35000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:19:43'), (27, 'Kampas Rem Aisin', 300000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:19:43'), (28, 'Disc Brake TRW', 750000, 0, 1, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:51:21'), (29, 'Filter Udara Sakura', 100000, 0, 1, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:51:23'), (30, 'Kampas Kopling Federal Parts', 500000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:19:43'), (31, 'Water Pump GMB', 450000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:19:43'), (32, 'Shock Absorber KYB', 800000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:45:58'), (33, 'Aki Yuasa', 1200000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:45:53'), (34, 'Ban Dunlop', 900000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 10:19:43'), (35, 'Oli Mesin Motul', 250000, 0, 0, 'N-1931741605480', '2024-06-10 10:19:43', '2024-06-10 12:09:13'), (36, 'Filter Oli Bosch', 150000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 12:10:28'), (37, 'Busi Denso', 35000, 0, 1, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 12:04:21'), (38, 'Kampas Rem Aisin', 300000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 12:10:26'), (39, 'Disc Brake TRW', 750000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (40, 'Filter Udara Sakura', 100000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (41, 'Kampas Kopling Federal Parts', 500000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (42, 'Water Pump GMB', 450000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (43, 'Shock Absorber KYB', 800000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (44, 'Aki Yuasa', 1200000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (45, 'Ban Dunlop', 900000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (46, 'Oli Mesin Motul', 250000, 0, 0, 'N-2343417004377', '2024-06-10 10:35:00', '2024-06-10 10:35:00'), (201, 'Filter Oli Bosch', 150000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:50:36'), (202, 'Busi Denso', 35000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:50:36'), (203, 'Kampas Rem Aisin', 300000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:52:00'), (204, 'Disc Brake TRW', 750000, 0, 1, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:51:56'), (205, 'Filter Udara Sakura', 100000, 0, 1, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:52:01'), (206, 'Kampas Kopling Federal Parts', 500000, 0, 1, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:52:03'), (207, 'Water Pump GMB', 450000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:50:36'), (208, 'Shock Absorber KYB', 800000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:50:36'), (209, 'Aki Yuasa', 1200000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:50:36'), (210, 'Ban Dunlop', 900000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:50:36'), (211, 'Oli Mesin Motul', 250000, 0, 0, 'N-0965597470670', '2024-06-11 14:50:36', '2024-06-11 14:50:36'), (212, 'Filter Oli Bosch', 150000, 0, 1, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:41'), (213, 'Busi Denso', 35000, 0, 1, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:41'), (214, 'Kampas Rem Aisin', 300000, 0, 1, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:43'), (215, 'Disc Brake TRW', 750000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (216, 'Filter Udara Sakura', 100000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (217, 'Kampas Kopling Federal Parts', 500000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (218, 'Water Pump GMB', 450000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (219, 'Shock Absorber KYB', 800000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (220, 'Aki Yuasa', 1200000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (221, 'Ban Dunlop', 900000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (222, 'Oli Mesin Motul', 250000, 0, 0, 'N-1577459997419', '2024-06-11 14:51:03', '2024-06-11 14:51:03'), (223, 'Filter Oli Bosch', 150000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (224, 'Busi Denso', 35000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (225, 'Kampas Rem Aisin', 300000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:55:10'), (226, 'Disc Brake TRW', 750000, 0, 1, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:54:17'), (227, 'Filter Udara Sakura', 100000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (228, 'Kampas Kopling Federal Parts', 500000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (229, 'Water Pump GMB', 450000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (230, 'Shock Absorber KYB', 800000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (231, 'Aki Yuasa', 1200000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (232, 'Ban Dunlop', 900000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (233, 'Oli Mesin Motul', 250000, 0, 0, 'N-9375810652649', '2024-06-11 23:52:44', '2024-06-11 23:52:44'), (234, 'Filter Oli Bosch', 150000, 0, 1, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:39'), (235, 'Busi Denso', 35000, 0, 1, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:40'), (236, 'Kampas Rem Aisin', 300000, 0, 1, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:43'), (237, 'Disc Brake TRW', 750000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (238, 'Filter Udara Sakura', 100000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (239, 'Kampas Kopling Federal Parts', 500000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (240, 'Water Pump GMB', 450000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (241, 'Shock Absorber KYB', 800000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (242, 'Aki Yuasa', 1200000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (243, 'Ban Dunlop', 900000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (244, 'Oli Mesin Motul', 250000, 0, 0, 'N-6417925993725', '2024-06-11 23:53:14', '2024-06-11 23:53:14'), (245, 'Filter Oli Bosch', 150000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (246, 'Busi Denso', 35000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (247, 'Kampas Rem Aisin', 300000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (248, 'Disc Brake TRW', 750000, 0, 1, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (249, 'Filter Udara Sakura', 100000, 0, 1, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (250, 'Kampas Kopling Federal Parts', 500000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (251, 'Water Pump GMB', 450000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (252, 'Shock Absorber KYB', 800000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:31', '2024-06-12 00:12:31'), (253, 'Aki Yuasa', 1200000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:32', '2024-06-12 00:12:32'), (254, 'Ban Dunlop', 900000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:32', '2024-06-12 00:12:32'), (255, 'Oli Mesin Motul', 250000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:32', '2024-06-12 00:12:32'), (256, 'Filter Oli Bosch', 150000, 0, 0, 'N-4396201418795', '2024-06-12 00:12:32', '2024-06-12 00:12:32'), (301, 'Filter Oli Bosch', 150000, 10000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (302, 'Busi Denso', 35000, 5000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (303, 'Kampas Rem Aisin', 300000, 15000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (304, 'Disc Brake TRW', 750000, 20000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (305, 'Filter Udara Sakura', 100000, 7000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (306, 'Kampas Kopling Federal Parts', 500000, 18000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (307, 'Water Pump GMB', 450000, 16000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (308, 'Shock Absorber KYB', 800000, 22000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (309, 'Aki Yuasa', 1200000, 30000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (310, 'Ban Dunlop', 900000, 25000, 1, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:49:34'), (311, 'Oli Mesin Motul', 250000, 12000, 0, 'N-7024599354758', '2024-06-30 22:47:22', '2024-06-30 22:47:22'), (312, 'Filter Oli Bosch', 150000, 10000, 1, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:48:28'), (313, 'Busi Denso', 35000, 5000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'), (314, 'Kampas Rem Aisin', 300000, 15000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:50:26'), (315, 'Disc Brake TRW', 750000, 20000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'), (316, 'Filter Udara Sakura', 100000, 7000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'), (317, 'Kampas Kopling Federal Parts', 500000, 18000, 1, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:48:45'), (318, 'Water Pump GMB', 450000, 16000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'), (319, 'Shock Absorber KYB', 800000, 22000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'), (320, 'Aki Yuasa', 1200000, 30000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'), (321, 'Ban Dunlop', 900000, 25000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'), (322, 'Oli Mesin Motul', 250000, 12000, 0, 'N-3147337376211', '2024-06-30 22:47:46', '2024-06-30 22:47:46'); -- -------------------------------------------------------- -- -- Table structure for table `detail` -- CREATE TABLE `detail` ( `kode_detail` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `detail` -- INSERT INTO `detail` (`kode_detail`, `image`, `keterangan`, `created_at`, `updated_at`) VALUES ('N-1931741605480', 'gambar/dc0285c8-dc5b-472c-b681-ad2d615d56323014655413825107352.jpg', 'Megawat Service Hari Ke 1', '2024-06-10 12:27:00', '2024-06-10 12:27:00'), ('N-1931741605480', 'gambar/246f73c1-efcb-4987-83b7-f222474e24018345579673139815328.jpg', 'Anjay Megawat Hari ke 2', '2024-06-10 12:27:42', '2024-06-10 12:27:42'), ('N-1931741605480', 'gambar/0c7af0d0-6dc5-4d95-9d2b-3ee51b4bb6184040532238713528977.jpg', 'Rahasia dah Hari ke 3', '2024-06-10 12:28:32', '2024-06-10 12:28:32'), ('N-2343417004377', 'gambar/5d7c03d7-b5bc-41a6-bfa4-8f912da2cf118765385194783437495.jpg', 'Lak iki ws soro megawat', '2024-06-10 12:29:27', '2024-06-10 12:29:27'), ('N-2343417004377', 'gambar/1dd038e7-20be-4a1e-be40-cd50beb7a1951463779601324309651.jpg', 'Hari ke 2 mentelek', '2024-06-10 12:30:14', '2024-06-10 12:30:14'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_09_10_052128_create_role_table', 1), (2, '2014_10_12_000000_create_users_table', 1), (3, '2014_10_12_100000_create_password_reset_tokens_table', 1), (4, '2019_08_19_000000_create_failed_jobs_table', 1), (5, '2019_12_14_000001_create_personal_access_tokens_table', 1), (6, '2024_03_16_052713_create_pickup_table', 1), (7, '2024_05_18_214259_create_detail_table', 1), (8, '2024_06_10_013137_create_checkbox_options_table', 2); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pickup` -- CREATE TABLE `pickup` ( `kode_pu` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `id_customer` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `id_pegawai` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_penjemputan` enum('1','2','3','4','5','6') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('lunas','belum_bayar') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bukti_pengiriman` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image_bukti` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `metode_pembayaran` enum('QRIS','COD') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `merk_kendaraan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `plat_nomor` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `biaya` int DEFAULT NULL, `penambahan_biaya` int DEFAULT NULL, `detail_biaya` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `pickup` -- INSERT INTO `pickup` (`kode_pu`, `id_customer`, `id_pegawai`, `status_penjemputan`, `status`, `bukti_pengiriman`, `image_path`, `image_bukti`, `metode_pembayaran`, `keterangan`, `merk_kendaraan`, `plat_nomor`, `biaya`, `penambahan_biaya`, `detail_biaya`, `created_at`, `updated_at`) VALUES ('N-0965597470670', 'IDCUST15319', 'PEG001', '6', 'lunas', NULL, 'gambar\\e8527e3e-18f0-4aee-a32e-b7dac1ccdbdd.png', 'gambar/IMG-20240611-WA0033.jpg', 'COD', 'macet tak mampu jalan', 'Jazz', 'P4447HR', 2100000, 6000, 2106000, '2024-06-11 14:50:36', '2024-06-11 14:55:38'), ('N-1577459997419', 'IDCUST15319', 'PEG001', '6', 'lunas', NULL, 'gambar\\0198af1c-5c67-4e74-994f-f2cf57330b97.png', 'gambar/IMG-20240611-WA0029.jpg', 'COD', 'cleaning', 'Alya', 'P2111GH', 485000, 70000, 555000, '2024-06-11 14:51:03', '2024-06-11 14:55:50'), ('N-1931741605480', 'IDCUST15319', 'PEG001', '6', 'lunas', NULL, 'gambar\\6e39d1ec-aef6-4ab2-955b-89ce90f0b10c.png', NULL, 'COD', NULL, 'Avanza', 'P1234HB', 850000, 32000, 882000, '2024-06-10 10:19:43', '2024-06-10 12:46:48'), ('N-2343417004377', 'IDCUST15319', 'PEG001', '6', 'belum_bayar', NULL, 'gambar\\afbfd400-0db5-4591-9e4b-dfdde16fc332.png', 'gambar/IMG-20240610-WA0021.jpg', 'QRIS', NULL, 'Jazz', 'P5678HG', 485000, 300000, 785000, '2024-06-10 10:35:00', '2024-06-11 15:34:53'), ('N-3147337376211', 'IDCUST15319', 'PEG001', '5', 'belum_bayar', 'booking', NULL, NULL, 'COD', 'Cat Baret', 'Xenia', 'P9393UO', 678000, 10000, 688000, '2024-06-30 22:47:46', '2024-06-30 22:51:17'), ('N-4396201418795', 'IDCUST15319', 'PEG001', '1', 'belum_bayar', 'booking', NULL, NULL, NULL, 'anu', 'anu', 'anu', NULL, NULL, NULL, '2024-06-12 00:12:31', '2024-06-12 00:12:31'), ('N-6417925993725', 'IDCUST15319', 'PEG001', '4', 'belum_bayar', 'booking', NULL, NULL, 'QRIS', 'Mati Lampu Depan', 'Jazz', 'P8989HR', 485000, 30000, 515000, '2024-06-11 23:53:14', '2024-06-11 23:55:01'), ('N-7024599354758', 'IDCUST15319', 'PEG001', '5', 'belum_bayar', 'Pemesanan', NULL, NULL, 'COD', 'Ban bocor', 'Avanza', 'P3333OP', 925000, 20000, 945000, '2024-06-30 22:47:22', '2024-06-30 22:51:22'), ('N-9375810652649', 'IDCUST15319', 'PEG001', '4', 'belum_bayar', 'Pemesanan', NULL, NULL, 'COD', 'ganti kaca', 'Ferarri', 'P4447HR', 750000, 1000, 751000, '2024-06-11 23:52:44', '2024-06-11 23:55:19'); -- -------------------------------------------------------- -- -- Table structure for table `role` -- CREATE TABLE `role` ( `id_role` bigint UNSIGNED NOT NULL, `nama` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `role` -- INSERT INTO `role` (`id_role`, `nama`) VALUES (1, 'customer'), (2, 'pegawai'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id_user` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `no_telepon` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `alamat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `id_role` bigint UNSIGNED DEFAULT NULL, `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id_user`, `nama`, `no_telepon`, `token`, `alamat`, `longitude`, `latitude`, `email`, `password`, `id_role`, `foto`, `created_at`, `updated_at`) VALUES ('CUS001', 'Customer A', '081234567890', 'pIApbEUV4N3aF03NDQJAMc1LcXtBT5XEtZYrhLY6P53arVCfIJix9vQFSJtOw8IXKICh3OpGoiNGE7apwblXKusnhDuvH6GnZ4bBolTA09SVBsmsaN2scGJsYc9hNAkFgF63lw5dxyn5z7z1RTGdLLvdK0GDCFNATJpMDRPJopk0P2YY08i7JTBWCK6kI9fj17nhnHyM', 'Jalan Contoh No. 123', '113.100000', '-8.100000', 'customer@gmail.com', '$2y$10$YD8f1WfRordCPlsIAHZjH.Twm7jtm0yW0QNOoIntzKLq6IksRCtN6', 1, NULL, '2024-03-27 06:43:01', '2024-05-18 17:08:58'), ('CUS002', 'Customer B', '081234567899', 'aaaaaaaaaaaaa', 'Jalan Contoh No. 1', '-8.162770', '113.682691', 'customer2@example.com', '$2y$10$lKTCHlP7efoHsD7wI1FtP.5FPo8/4/PqQLgP/Nf0emjQTKhhI94iC', 1, NULL, '2024-03-27 06:43:01', '2024-03-27 06:43:01'), ('IDCUST15319', 'fathurrahman', '0895388770664', 'r1fVUMif21wKHXFReTqIfqICbaW3Xl61pSpGHyGJx1PiMm4t0ZFWi6VnZz38pt5Sl8YgG7jk7OPqInMT8FaqEF9otwkCEUbeYNq87jymaXJuQbLFeerbWFmE7x524Nkc2mGztgPQsPz0TtxCjb9VzhRwSWUzNYzItrqL2FtNpqQ7jRBTmAfNyU39dTvrevY5ZOLTuJD5', 'jl.cempaka no.7', '-122.084', '37.4219983', 'fathur@gmail.com', '$2y$10$iPcBbIZlX/z9q3vq8tYnm.0J3kHaPp1QefExx7JxNtTxyJUvLJW76', 1, NULL, '2024-05-04 23:42:17', '2024-06-30 22:50:14'), ('IDCUST19451', 'PINO EKO', '0898338381', 'GxEW2XCdF8j1AOotpM36ub6bzh3GmhAahCPzdaqdkMlrzxIb7d3uh8muZEQpVDhD5GcPVeGVZoMfVzH2gGGXnWS3lQHqdymWPdGzkEwWhkkQhp7hGwgoT5nc6gUNjMCG3l0IPm8Oz8HYeBssCkGfTwKrzadCe3UGYNBpcGTRFt4G7vfbfjq21N3qkGSKQcByY6IaSnYI', 'jl cempaka no 7 gebang jember', '113.681755', '-8.1638178', 'pino@gmail.com', '$2y$10$ZxSYO1L7ixKoONewkwzHOuAZ1EePC.SXkm6U/6CMvt4K0KbF2wQDW', 1, NULL, '2024-05-05 00:56:41', '2024-05-05 00:57:07'), ('IDCUST43749', 'fathur', '1111', NULL, 'jalan cempaka no.7', '101.45126789999999', '3.1381862999999997', 'fathurrahmandk02@gmail.com', '$2y$10$LBBo/2CmnGO84nHWclYc/urjnCF92IINWpBByTgwjMmhjiK8.efaG', 1, NULL, '2024-05-20 06:45:44', '2024-05-20 06:45:44'), ('IDCUST57444', 'romani', '08988556663', NULL, 'jalan Mastrip Krajan timur, sumbersari, kecamatan sumbersari', '113.7195483', '-8.1600407', 'romani@gmail.com', '$2y$10$PIVCNC3h4CfDSD9wErcp4eQM7Knxq7yh8zb/kXC2nxpNJ7Dusk/ty', 1, NULL, '2024-05-21 02:15:59', '2024-05-21 02:15:59'), ('IDCUST84169', 'rayhan', '082229474403', 'k5fMr3kTno0p1p2L1VMTyGABUTR8y8vZNoqFMznAKAAQ1uGw567b87xj1eNLh5BRDVDAM6LmmRFqRyLsRVjfXIs186U2W28wsAUwYdCp2FaZI5lzKa66xooUPgFmiynuTPhrAOGqWMosngHIJyRos0RQYZWqSnTjCyW2z1aIELVLVAKwEZu5DqNUyzllpwUcmMaH0Ec6', 'Jl kapuas bangsalsari jember', '-8.2004184', '113.5390862', 'rayhan@gmail.com', '$2y$10$nrVYwCWxYvGFsLWp5WfwNuMCJQR1jlHga9aJd7jyVpwp6DkAHoo.K', 1, NULL, '2024-04-30 17:26:06', '2024-05-19 14:38:29'), ('PEG001', 'Pegawai A', '082345678900', 'C2e7LxPSQHyP5lzdAIbOyhvLjwOcXAK0E7r5Kp8zabUj5tJWlk73H8Z6a2rYJHvGZYqAqH640imuiathRKNRV2RpsUw3jtMDoVReNEhkuIb9z5sHagpKMGClQgGckCF5Q9uwJ9TmsdEbrkFIZV3705zOw3E9R3E3g319fmfvmeSYEykHbd540qmF1EAw1SxDveYMCryJ', 'Jalan Lain No. 456', '113.702994', '-8.151839', 'pegawai@gmail.com', '$2y$10$YD8f1WfRordCPlsIAHZjH.Twm7jtm0yW0QNOoIntzKLq6IksRCtN6', 2, NULL, '2024-03-27 06:43:01', '2024-06-30 22:51:09'), ('PEG002', 'Pegawai B', '082345678900', 'njkm7Pg2vbHcBMVg6w2ZMa61uYbXBtZwxU8sxTCmoCqsoKGuNCQC8E3cKaHRSDJjFYz9fBhwMQjsKtmPULNfFFdcLXUT6rq5jXFdebX8rjRMfnAED8GwnErmxQLEVNndbRsD8JNJRcg0OzGa3dpE9PeaxbVFUIq18bOCUISqBwN7tkz8UCY2DWnib3hDpWpTwgkZFD5S', 'Jalan Lain No. 2', '113.682691', '-8.162770', 'pegawai2@gmail.com', '$2y$10$YD8f1WfRordCPlsIAHZjH.Twm7jtm0yW0QNOoIntzKLq6IksRCtN6', 2, NULL, '2024-03-27 06:43:01', '2024-05-09 20:53:35'), ('PEG003', 'Pegawai C', '082345678922', 's2KED7K05gmusSr8nLnj3oUNwM0TIhXpqqaxiHrR6T37iBVI62EKtBddZOthWjDr4cnhwiKlivaLK54CWkVjeylG1hl6bDvaQDVa2H3anpIa56RivgkNLOnJgXGqhFn31DcdKW8vgiP8aopP0gr93geVVnsj8snPklRRU6dEJtW2k9atsnX1cU37jg1RJHPgo53E5CYX', 'Jl kapuas bangsalsari jember', '113.5363862', '-8.2013853', 'pegawai3@gmail.com', '$2y$10$YD8f1WfRordCPlsIAHZjH.Twm7jtm0yW0QNOoIntzKLq6IksRCtN6', 2, NULL, '2024-03-27 06:43:01', '2024-05-10 01:36:08'); -- -- Indexes for dumped tables -- -- -- Indexes for table `checkbox_options` -- ALTER TABLE `checkbox_options` ADD PRIMARY KEY (`id`), ADD KEY `kode_pu` (`kode_pu`); -- -- Indexes for table `detail` -- ALTER TABLE `detail` ADD KEY `detail_kode_detail_foreign` (`kode_detail`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- 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 `pickup` -- ALTER TABLE `pickup` ADD PRIMARY KEY (`kode_pu`), ADD KEY `pickup_id_customer_foreign` (`id_customer`), ADD KEY `pickup_id_pegawai_foreign` (`id_pegawai`); -- -- Indexes for table `role` -- ALTER TABLE `role` ADD PRIMARY KEY (`id_role`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id_user`), ADD KEY `user_id_role_foreign` (`id_role`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `checkbox_options` -- ALTER TABLE `checkbox_options` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=323; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `role` -- ALTER TABLE `role` MODIFY `id_role` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Constraints for dumped tables -- -- -- Constraints for table `checkbox_options` -- ALTER TABLE `checkbox_options` ADD CONSTRAINT `checkbox_options_ibfk_1` FOREIGN KEY (`kode_pu`) REFERENCES `pickup` (`kode_pu`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `detail` -- ALTER TABLE `detail` ADD CONSTRAINT `detail_kode_detail_foreign` FOREIGN KEY (`kode_detail`) REFERENCES `pickup` (`kode_pu`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `pickup` -- ALTER TABLE `pickup` ADD CONSTRAINT `pickup_id_customer_foreign` FOREIGN KEY (`id_customer`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `pickup_id_pegawai_foreign` FOREIGN KEY (`id_pegawai`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `user` -- ALTER TABLE `user` ADD CONSTRAINT `user_id_role_foreign` FOREIGN KEY (`id_role`) REFERENCES `role` (`id_role`) 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 */;