-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.30 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping data for table crud-two.attendances: ~0 rows (approximately)
/*!40000 ALTER TABLE `attendances` DISABLE KEYS */;
/*!40000 ALTER TABLE `attendances` ENABLE KEYS */;

-- Dumping data for table crud-two.checks: ~0 rows (approximately)
/*!40000 ALTER TABLE `checks` DISABLE KEYS */;
/*!40000 ALTER TABLE `checks` ENABLE KEYS */;

-- Dumping data for table crud-two.employees: ~0 rows (approximately)
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;

-- Dumping data for table crud-two.employee_infos: ~0 rows (approximately)
/*!40000 ALTER TABLE `employee_infos` DISABLE KEYS */;
/*!40000 ALTER TABLE `employee_infos` ENABLE KEYS */;

-- Dumping data for table crud-two.failed_jobs: ~0 rows (approximately)
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;

-- Dumping data for table crud-two.finger_devices: ~4 rows (approximately)
/*!40000 ALTER TABLE `finger_devices` DISABLE KEYS */;
INSERT INTO `finger_devices` (`id`, `name`, `ip`, `serialNumber`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(8, 'uface 802', '192.168.0.253', 'AF4C231060233\0', '2023-09-05 06:12:38', '2023-09-07 06:00:00', '2023-09-07 06:00:00'),
	(9, 'room a', '192.168.0.144', '1106020920007\0', '2023-09-05 06:12:55', '2023-09-05 07:19:53', '2023-09-05 07:19:53'),
	(12, 'room e', '192.168.0.17', 'AF39211260005\0', '2023-09-06 07:00:14', '2024-01-16 07:54:28', '2024-01-16 07:54:28'),
	(14, 'HORUS', '192.168.0.4', 'CJKT212060009\0', '2024-01-16 07:56:43', '2024-01-16 07:56:43', NULL);
/*!40000 ALTER TABLE `finger_devices` ENABLE KEYS */;

-- Dumping data for table crud-two.latetimes: ~0 rows (approximately)
/*!40000 ALTER TABLE `latetimes` DISABLE KEYS */;
/*!40000 ALTER TABLE `latetimes` ENABLE KEYS */;

-- Dumping data for table crud-two.leaves: ~0 rows (approximately)
/*!40000 ALTER TABLE `leaves` DISABLE KEYS */;
/*!40000 ALTER TABLE `leaves` ENABLE KEYS */;

-- Dumping data for table crud-two.migrations: ~14 rows (approximately)
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
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, '2019_08_19_000000_create_failed_jobs_table', 1),
	(4, '2019_11_25_113026_create_employees_table', 1),
	(5, '2019_12_02_141403_create_roles_table', 1),
	(6, '2019_12_03_044741_create_schedules_table', 1),
	(7, '2019_12_03_045452_create_attendances_table', 1),
	(8, '2019_12_03_045912_create_latetimes_table', 1),
	(9, '2019_12_03_045930_create_overtimes_table', 1),
	(10, '2019_12_03_050030_create_leaves_table', 1),
	(11, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(12, '2019_12_22_183558_create_checks_table', 1),
	(13, '2021_06_05_110414_create_finger_devices_table', 1),
	(14, '2023_09_14_112323_create_employee_infos_table', 2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;

-- Dumping data for table crud-two.overtimes: ~0 rows (approximately)
/*!40000 ALTER TABLE `overtimes` DISABLE KEYS */;
/*!40000 ALTER TABLE `overtimes` ENABLE KEYS */;

-- Dumping data for table crud-two.password_resets: ~0 rows (approximately)
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;

-- Dumping data for table crud-two.personal_access_tokens: ~0 rows (approximately)
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;

-- Dumping data for table crud-two.roles: ~1 rows (approximately)
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` (`id`, `slug`, `name`, `permissions`, `created_at`, `updated_at`) VALUES
	(1, 'admin', 'Adminstrator', NULL, '2023-08-30 13:11:25', '2023-08-30 13:11:25');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;

-- Dumping data for table crud-two.role_users: ~1 rows (approximately)
/*!40000 ALTER TABLE `role_users` DISABLE KEYS */;
INSERT INTO `role_users` (`user_id`, `role_id`) VALUES
	(1, 1);
/*!40000 ALTER TABLE `role_users` ENABLE KEYS */;

-- Dumping data for table crud-two.schedules: ~1 rows (approximately)
/*!40000 ALTER TABLE `schedules` DISABLE KEYS */;
INSERT INTO `schedules` (`id`, `slug`, `time_in`, `time_out`, `created_at`, `updated_at`) VALUES
	(1, 'asdasdasdas', '08:00:00', '17:00:00', '2023-08-31 06:11:12', '2023-08-31 06:11:12');
/*!40000 ALTER TABLE `schedules` ENABLE KEYS */;

-- Dumping data for table crud-two.schedule_employees: ~0 rows (approximately)
/*!40000 ALTER TABLE `schedule_employees` DISABLE KEYS */;
/*!40000 ALTER TABLE `schedule_employees` ENABLE KEYS */;

-- Dumping data for table crud-two.users: ~1 rows (approximately)
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `name`, `email`, `pin_code`, `permissions`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
	(1, 'Admin', 'admin@ams.com', NULL, NULL, NULL, '$2y$10$B9iTlf5fSdDIV.vHZ7QCYeMD7w8G0n2OJwhDHcsmazAriLyHIDyIm', NULL, '2023-08-30 13:11:25', '2023-08-30 13:11:25');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
