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


-- Dumping data for table crud-two.attendances: ~0 rows (approximately)

-- Dumping data for table crud-two.checks: ~0 rows (approximately)

-- Dumping data for table crud-two.employees: ~0 rows (approximately)

-- Dumping data for table crud-two.employee_infos: ~0 rows (approximately)

-- Dumping data for table crud-two.failed_jobs: ~0 rows (approximately)

-- Dumping data for table crud-two.finger_devices: ~4 rows (approximately)
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);

-- Dumping data for table crud-two.latetimes: ~0 rows (approximately)

-- Dumping data for table crud-two.leaves: ~0 rows (approximately)

-- Dumping data for table crud-two.migrations: ~14 rows (approximately)
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);

-- Dumping data for table crud-two.overtimes: ~0 rows (approximately)

-- Dumping data for table crud-two.password_resets: ~0 rows (approximately)

-- Dumping data for table crud-two.personal_access_tokens: ~0 rows (approximately)

-- Dumping data for table crud-two.roles: ~1 rows (approximately)
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');

-- Dumping data for table crud-two.role_users: ~1 rows (approximately)
INSERT INTO `role_users` (`user_id`, `role_id`) VALUES
	(1, 1);

-- Dumping data for table crud-two.schedules: ~1 rows (approximately)
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');

-- Dumping data for table crud-two.schedule_employees: ~0 rows (approximately)

