-- -------------------------------------------------------- -- 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) */;