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


-- Dumping structure for table rental.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 rental.cache: ~2 rows (approximately)
INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
	('livewire-rate-limiter:a17961fa74e9275d529f489537f179c05d50c2f3', 'i:1;', 1755682019),
	('livewire-rate-limiter:a17961fa74e9275d529f489537f179c05d50c2f3:timer', 'i:1755682019;', 1755682019);

-- Dumping structure for table rental.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 rental.cache_locks: ~0 rows (approximately)

-- Dumping structure for table rental.customers
CREATE TABLE IF NOT EXISTS `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nik` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emergency_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `social_media_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `colleague_info` text COLLATE utf8mb4_unicode_ci,
  `category` enum('karyawan','mahasiswa','wisatawan') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','blacklisted') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customers_nik_unique` (`nik`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.customers: ~1 rows (approximately)
INSERT INTO `customers` (`id`, `name`, `nik`, `phone`, `emergency_number`, `address`, `gender`, `birth_date`, `social_media_link`, `colleague_info`, `category`, `status`, `created_at`, `updated_at`) VALUES
	(2, 'Kresna Prasmadewa', '3373040807940001', '085943417766', '087766600283', 'Jl. Test', 'male', '2025-08-07', '@kresnaprasma', NULL, 'mahasiswa', 'active', '2025-08-07 16:25:48', '2025-08-07 16:25:48');

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

-- Dumping structure for table rental.financial_reports
CREATE TABLE IF NOT EXISTS `financial_reports` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_date` datetime NOT NULL,
  `type` enum('debit','credit') COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `financial_reports_source_type_source_id_index` (`source_type`,`source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.financial_reports: ~0 rows (approximately)

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

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

-- Dumping structure for table rental.maintenances
CREATE TABLE IF NOT EXISTS `maintenances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `motorcycle_id` bigint(20) unsigned NOT NULL,
  `maintenance_date` date NOT NULL,
  `maintenance_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `total_cost` decimal(12,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `maintenances_motorcycle_id_foreign` (`motorcycle_id`),
  CONSTRAINT `maintenances_motorcycle_id_foreign` FOREIGN KEY (`motorcycle_id`) REFERENCES `motorcycles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.maintenances: ~0 rows (approximately)
INSERT INTO `maintenances` (`id`, `motorcycle_id`, `maintenance_date`, `maintenance_type`, `description`, `total_cost`, `created_at`, `updated_at`) VALUES
	(1, 1, '2025-08-10', 'Servis Ringan', 'Ganti Oli', 50000.00, '2025-08-10 08:39:02', '2025-08-10 08:39:02');

-- Dumping structure for table rental.media
CREATE TABLE IF NOT EXISTS `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint(20) unsigned NOT NULL,
  `manipulations` json NOT NULL,
  `custom_properties` json NOT NULL,
  `generated_conversions` json NOT NULL,
  `responsive_images` json NOT NULL,
  `order_column` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `media_uuid_unique` (`uuid`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.media: ~4 rows (approximately)
INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'App\\Models\\Customer', 2, '5df147ae-784d-41be-b98e-e156bf000be3', 'ktp', '26fc7554ec1ac9eef3b828eb8a027958', '01K22NMQF211PGR8SQJ4SSMB9G.jpg', 'image/jpeg', 'public', 'public', 14838, '[]', '[]', '[]', '[]', 1, '2025-08-07 16:25:48', '2025-08-07 16:25:48', NULL),
	(6, 'App\\Models\\Customer', 2, 'f9be37bc-2e34-4d43-bdb1-ece4abb07aa5', 'sim', '7e7e82df542379afe64b50032f0a7387', '7e7e82df542379afe64b50032f0a7387.jpg', 'image/jpeg', 'public', 'public', 8588, '[]', '[]', '[]', '[]', 2, '2025-08-07 16:25:48', '2025-08-07 16:25:48', NULL),
	(7, 'App\\Models\\Customer', 2, '6094cd37-d83e-4be2-af61-98eba3229533', 'ktm', '050ff29dbc198d28744841af2384768f', '01K22NMQH5RCE34V0XGS9KH0EM.jpg', 'image/jpeg', 'public', 'public', 33877, '[]', '[]', '[]', '[]', 3, '2025-08-07 16:25:48', '2025-08-07 16:25:48', NULL),
	(8, 'App\\Models\\Customer', 2, 'f3de6bf3-38db-4afe-b740-8b16bd411dd7', 'kos', 'aed584eb87f01cda2bad559bcfbe7547', '01K22NMQHSZW9P5XHKT1STVPXS.jpg', 'image/jpeg', 'public', 'public', 38216, '[]', '[]', '[]', '[]', 4, '2025-08-07 16:25:48', '2025-08-07 16:25:48', NULL),
	(9, 'App\\Models\\Motorcycle', 1, 'c1dae4e9-a6db-43ca-8d09-4e3752fef14d', 'motorcycles', 'piston-logo-5FA07FCDB3-seeklogo.com', '01K24B2N6ZNASH16Y2W07NHPZK.png', 'image/png', 'public', 'public', 14154, '[]', '[]', '[]', '[]', 1, '2025-08-08 07:59:40', '2025-08-08 07:59:40', NULL);

-- Dumping structure for table rental.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=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.migrations: ~11 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '0001_01_01_000000_create_users_table', 1),
	(2, '0001_01_01_000001_create_cache_table', 1),
	(3, '0001_01_01_000002_create_jobs_table', 1),
	(5, '2025_08_07_103721_create_customers_table', 2),
	(6, '2025_08_07_134339_create_media_table', 3),
	(7, '2025_08_08_041901_create_motorcycles_table', 4),
	(8, '2025_08_08_073433_create_maintenances_table', 4),
	(9, '2025_08_10_124842_create_rentals_table', 5),
	(10, '2025_08_12_063718_alter_start_end_date_to_rentals', 6),
	(11, '2025_08_14_083855_create_payments_table', 7),
	(12, '2025_08_14_083907_create_financial_reports_table', 7),
	(13, '2025_08_15_024952_add_proof_file_to_payments_table', 8);

-- Dumping structure for table rental.motorcycles
CREATE TABLE IF NOT EXISTS `motorcycles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `plate_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cc` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Tersedia','Disewa','Maintenance') COLLATE utf8mb4_unicode_ci NOT NULL,
  `oil_date` date NOT NULL,
  `stnk_date` date NOT NULL,
  `daily_price` decimal(12,2) NOT NULL,
  `weekly_price` decimal(12,2) NOT NULL,
  `monthly_price` decimal(12,2) NOT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `motorcycles_plate_number_unique` (`plate_number`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.motorcycles: ~0 rows (approximately)
INSERT INTO `motorcycles` (`id`, `plate_number`, `brand`, `type`, `cc`, `year`, `color`, `status`, `oil_date`, `stnk_date`, `daily_price`, `weekly_price`, `monthly_price`, `photo`, `created_at`, `updated_at`) VALUES
	(1, 'H6693GK', 'Honda', 'Vario 150 PGM-Fi', 150, 2016, 'Navy Dove', 'Tersedia', '2025-08-12', '2025-08-31', 50000.00, 250000.00, 800000.00, NULL, '2025-08-08 07:59:39', '2025-08-08 07:59:39');

-- Dumping structure for table rental.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 rental.password_reset_tokens: ~0 rows (approximately)

-- Dumping structure for table rental.payments
CREATE TABLE IF NOT EXISTS `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rental_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_date` datetime NOT NULL,
  `payment_type` enum('DP','Pelunasan','Denda') COLLATE utf8mb4_unicode_ci NOT NULL,
  `proof_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method` enum('Cash','Transfer','E-Wallet') COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payments_rental_id_foreign` (`rental_id`),
  CONSTRAINT `payments_rental_id_foreign` FOREIGN KEY (`rental_id`) REFERENCES `rentals` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.payments: ~0 rows (approximately)

-- Dumping structure for table rental.rentals
CREATE TABLE IF NOT EXISTS `rentals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rental_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` bigint(20) unsigned NOT NULL,
  `motorcycle_id` bigint(20) unsigned NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `actual_return_date` date DEFAULT NULL,
  `price_per_day` decimal(12,2) NOT NULL,
  `total_price` decimal(12,2) NOT NULL,
  `status` enum('booked','ongoing','completed','late','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'booked',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rentals_rental_number_unique` (`rental_number`),
  KEY `rentals_customer_id_foreign` (`customer_id`),
  KEY `rentals_motorcycle_id_foreign` (`motorcycle_id`),
  CONSTRAINT `rentals_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `rentals_motorcycle_id_foreign` FOREIGN KEY (`motorcycle_id`) REFERENCES `motorcycles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.rentals: ~0 rows (approximately)
INSERT INTO `rentals` (`id`, `rental_number`, `customer_id`, `motorcycle_id`, `start_date`, `end_date`, `actual_return_date`, `price_per_day`, `total_price`, `status`, `notes`, `created_at`, `updated_at`) VALUES
	(3, 'RENT-689D91C209D02', 2, 1, '2025-08-14 00:00:00', '2025-08-16 00:00:00', NULL, 50000.00, 100000.00, 'completed', NULL, '2025-08-14 07:35:30', '2025-08-20 09:44:26');

-- Dumping structure for table rental.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 rental.sessions: ~1 rows (approximately)
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('wb5pwCVxYEPRu8W4gCFlY1OjLOM7WRPkAVM8wm4b', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiclpuQmJqNWdUYVZ5U2UzazE5TlpZVDlzRjNPbThmVnJjVGhxeG4wNCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM1OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvYWRtaW4vcmVudGFscyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7czoxNzoicGFzc3dvcmRfaGFzaF93ZWIiO3M6NjA6IiQyeSQxMiRpMGY4blVSMzk2Li44d1NLUm9HeE5lSDdYTVhTWmJTYVBoMXA3b1I3ZVNja1U0R29MRktlNiI7czo4OiJmaWxhbWVudCI7YTowOnt9fQ==', 1755684237);

-- Dumping structure for table rental.stnk_dates
CREATE TABLE IF NOT EXISTS `stnk_dates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `motorcycle_id` bigint(20) unsigned NOT NULL,
  `stnk_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stnk_dates_motorcycle_id_foreign` (`motorcycle_id`),
  CONSTRAINT `stnk_dates_motorcycle_id_foreign` FOREIGN KEY (`motorcycle_id`) REFERENCES `motorcycles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.stnk_dates: ~0 rows (approximately)
INSERT INTO `stnk_dates` (`id`, `motorcycle_id`, `stnk_date`, `created_at`, `updated_at`) VALUES
	(1, 1, '2025-08-19', '2025-08-10 08:39:34', '2025-08-10 08:39:34');

-- Dumping structure for table rental.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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rental.users: ~0 rows (approximately)
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
	(1, 'admin', 'admin@rentalmotordisemarang.com', NULL, '$2y$12$i0f8nUR396..8wSKRoGxNeH7XMXSZbSaPh1p7oR7eSckU4GoLFKe6', NULL, '2025-08-07 08:52:39', '2025-08-07 08:52:39');

