-- -------------------------------------------------------- -- 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 database structure for crud-two CREATE DATABASE IF NOT EXISTS `crud-two` /*!40100 DEFAULT CHARACTER SET latin1 */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `crud-two`; -- Dumping structure for table crud-two.attendances CREATE TABLE IF NOT EXISTS `attendances` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` int unsigned NOT NULL DEFAULT '0', `emp_id` int unsigned NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '0', `attendance_time` time NOT NULL DEFAULT '06:57:39', `attendance_date` date NOT NULL DEFAULT '2024-02-26', `status` tinyint(1) NOT NULL DEFAULT '1', `type` tinyint unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `attendances_emp_id_foreign` (`emp_id`), CONSTRAINT `attendances_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.attendances: ~0 rows (approximately) /*!40000 ALTER TABLE `attendances` DISABLE KEYS */; /*!40000 ALTER TABLE `attendances` ENABLE KEYS */; -- Dumping structure for table crud-two.attendance_info CREATE TABLE IF NOT EXISTS `attendance_info` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `id_number` int NOT NULL, `attendance_number` int NOT NULL, `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `attendance_date_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `device_serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=53574 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.attendance_info: ~0 rows (approximately) /*!40000 ALTER TABLE `attendance_info` DISABLE KEYS */; INSERT INTO `attendance_info` (`id`, `id_number`, `attendance_number`, `state`, `attendance_date_time`, `type`, `device_serial_number`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 101192697, 443, '15', '2024-02-26 17:01:50', '1', 'CJKT212060009\0', '2024-02-26 13:33:28', '2024-02-26 13:33:28', NULL), (2, 101192697, 444, '15', '2024-02-27 08:01:40', '1', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL), (3, 101192697, 445, '15', '2024-02-27 08:04:08', '0', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL), (4, 101192697, 446, '15', '2024-02-27 08:04:14', '1', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL), (5, 101192697, 447, '15', '2024-02-27 08:04:22', '2', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL), (6, 101192697, 448, '15', '2024-02-27 08:04:29', '3', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL), (7, 101192697, 449, '15', '2024-02-27 08:05:22', '6', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL), (8, 104181252, 450, '15', '2024-02-27 08:15:37', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL), (9, 101192697, 451, '15', '2024-02-27 08:15:40', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL), (10, 104181252, 452, '15', '2024-02-27 08:21:33', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL), (11, 104181252, 453, '15', '2024-02-27 08:21:40', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL), (12, 101192697, 454, '15', '2024-02-27 08:28:18', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL), (13, 101192697, 455, '15', '2024-02-27 10:26:43', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (14, 101192697, 456, '15', '2024-02-27 10:26:54', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (15, 101192697, 457, '15', '2024-02-27 10:33:21', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (16, 101192697, 458, '15', '2024-02-27 10:38:15', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (17, 101192697, 459, '15', '2024-02-27 10:38:43', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (18, 101192697, 460, '15', '2024-02-27 11:39:42', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (19, 101192697, 461, '15', '2024-02-27 11:40:24', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (20, 101192697, 462, '15', '2024-02-27 11:40:33', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (21, 101192697, 463, '15', '2024-02-27 11:40:41', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (22, 101192697, 464, '15', '2024-02-27 12:27:32', '2', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (23, 101192697, 465, '15', '2024-02-27 13:00:46', '3', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (24, 101192697, 466, '15', '2024-02-27 13:07:12', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (25, 101192697, 467, '15', '2024-02-27 13:07:23', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (26, 104181252, 468, '15', '2024-02-27 13:10:23', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (27, 104181252, 469, '15', '2024-02-27 13:10:37', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (28, 104181252, 470, '15', '2024-02-27 13:34:12', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (29, 104181252, 471, '15', '2024-02-27 13:49:33', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (30, 104181252, 472, '15', '2024-02-27 13:54:34', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (31, 104181252, 473, '15', '2024-02-27 13:54:47', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (32, 104181252, 474, '15', '2024-02-27 14:13:43', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (33, 101192697, 475, '15', '2024-02-27 14:19:20', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (34, 101192697, 476, '15', '2024-02-27 14:20:02', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (35, 104181252, 477, '15', '2024-02-27 14:21:27', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (36, 101192697, 478, '15', '2024-02-27 14:53:06', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL), (37, 101192697, 479, '15', '2024-02-27 15:49:02', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (38, 101192697, 480, '15', '2024-02-27 16:48:10', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (39, 104181252, 481, '15', '2024-02-27 16:50:54', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (40, 104181252, 482, '15', '2024-02-27 16:51:11', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (41, 104181252, 483, '15', '2024-02-27 16:54:15', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (42, 104181252, 484, '15', '2024-02-27 16:58:23', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (43, 104181252, 485, '15', '2024-02-27 16:59:17', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (44, 104181252, 486, '15', '2024-02-27 16:59:24', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (45, 101192697, 487, '15', '2024-02-28 09:09:32', '1', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (46, 101192697, 488, '15', '2024-02-28 09:15:16', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (47, 101192697, 489, '15', '2024-02-28 09:26:39', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (48, 101192697, 490, '15', '2024-02-28 09:26:45', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (49, 101192697, 491, '15', '2024-02-28 09:30:26', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (50, 101192697, 492, '15', '2024-02-28 09:30:31', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (51, 101192697, 493, '15', '2024-02-28 09:44:20', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (52, 101192697, 494, '15', '2024-02-28 09:44:42', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (53, 101192697, 495, '15', '2024-02-28 09:44:50', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (54, 101192697, 496, '15', '2024-02-28 09:45:07', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (55, 101192697, 497, '15', '2024-03-04 11:10:49', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (56, 101192697, 498, '15', '2024-03-11 09:27:07', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL), (57, 101192697, 499, '15', '2024-03-11 10:47:50', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (58, 101192697, 500, '15', '2024-03-11 10:47:55', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (59, 101192697, 501, '15', '2024-03-11 11:16:07', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (60, 101192697, 502, '15', '2024-03-11 12:59:39', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (61, 101192697, 503, '15', '2024-03-11 13:06:48', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (62, 104181252, 504, '15', '2024-03-11 13:06:57', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (63, 101192697, 505, '15', '2024-03-11 13:07:00', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (64, 101192697, 506, '15', '2024-03-11 13:29:21', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (65, 101192697, 507, '15', '2024-03-11 14:49:00', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (66, 101192697, 508, '15', '2024-03-11 15:04:50', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (67, 101192697, 509, '15', '2024-03-11 15:04:57', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (68, 101192697, 510, '15', '2024-03-11 15:05:04', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (69, 101192697, 511, '15', '2024-03-11 15:05:13', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL), (70, 101192697, 512, '15', '2024-03-11 15:35:35', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (71, 101192697, 513, '15', '2024-03-11 15:44:33', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (72, 101192697, 514, '15', '2024-03-11 15:44:45', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (73, 101192697, 515, '15', '2024-03-11 15:56:44', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (74, 101192697, 516, '15', '2024-03-11 16:00:50', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (75, 101192697, 517, '15', '2024-03-11 16:32:32', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (76, 101192697, 518, '15', '2024-03-11 16:43:08', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (77, 101192697, 519, '15', '2024-03-11 16:43:13', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (78, 101192697, 520, '15', '2024-03-12 09:52:58', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (79, 101192697, 521, '15', '2024-03-12 09:53:17', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (80, 101192697, 522, '15', '2024-03-12 09:53:30', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (81, 101192697, 523, '15', '2024-03-12 09:53:48', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (82, 101192697, 524, '15', '2024-03-12 10:06:24', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (83, 101192697, 525, '15', '2024-03-12 10:06:29', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (84, 101192697, 526, '15', '2024-03-12 10:11:50', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (85, 101192697, 527, '15', '2024-03-12 10:11:57', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (86, 101192697, 528, '15', '2024-03-12 10:48:39', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (87, 101192697, 529, '15', '2024-03-12 10:49:33', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (88, 101192697, 530, '15', '2024-03-12 11:02:03', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (89, 101192697, 531, '15', '2024-03-12 11:22:43', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (90, 101192697, 532, '15', '2024-03-12 11:57:48', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (91, 101192697, 533, '15', '2024-03-12 12:04:41', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (92, 101192697, 534, '15', '2024-03-12 12:04:46', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (93, 101192697, 535, '15', '2024-03-12 13:02:19', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (94, 101192697, 536, '15', '2024-03-12 13:04:12', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (95, 109132354, 537, '15', '2024-03-12 13:05:32', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (96, 109132354, 538, '15', '2024-03-12 13:05:45', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (97, 101192697, 539, '15', '2024-03-12 13:06:26', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (98, 101192697, 540, '15', '2024-03-12 13:06:35', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (99, 101192697, 541, '15', '2024-03-12 13:07:57', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (100, 101192697, 542, '15', '2024-03-12 13:30:05', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (101, 101192697, 543, '15', '2024-03-12 13:36:40', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (102, 101192697, 544, '15', '2024-03-12 14:37:27', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (103, 101192697, 545, '15', '2024-03-12 14:46:34', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (104, 101192697, 546, '15', '2024-03-12 15:54:16', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (105, 101192697, 547, '15', '2024-03-12 16:13:11', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (106, 109132354, 548, '15', '2024-03-12 16:36:18', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (107, 101192697, 549, '15', '2024-03-12 16:41:30', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (108, 101192697, 550, '15', '2024-03-12 16:41:36', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (109, 109132354, 551, '15', '2024-03-12 16:48:13', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (110, 109132354, 552, '15', '2024-03-12 16:48:22', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (111, 109132354, 553, '15', '2024-03-12 16:48:30', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (112, 109132354, 554, '15', '2024-03-12 16:48:35', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (113, 109132354, 555, '15', '2024-03-12 16:48:41', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (114, 109132354, 556, '15', '2024-03-12 16:48:46', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (115, 109132354, 557, '15', '2024-03-12 16:48:59', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (116, 101192697, 558, '15', '2024-03-12 16:58:51', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (117, 101192697, 559, '15', '2024-03-12 17:03:55', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (118, 101192697, 560, '15', '2024-03-12 17:09:21', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (119, 101192697, 561, '15', '2024-03-12 17:09:57', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (120, 109132354, 562, '15', '2024-03-12 17:09:59', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (121, 101192697, 563, '15', '2024-03-14 11:41:44', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL), (53570, 101192697, 564, '15', '2024-03-14 12:31:14', '6', 'CJKT212060009\0', '2024-03-14 12:54:35', '2024-03-14 12:54:35', NULL), (53571, 101192697, 565, '15', '2024-03-14 13:40:25', '7', 'CJKT212060009\0', '2024-03-14 12:54:35', '2024-03-14 12:54:35', NULL), (53572, 101192697, 566, '15', '2024-03-14 15:10:00', '7', 'CJKT212060009\0', '2024-03-14 12:54:35', '2024-03-14 12:54:35', NULL), (53573, 101192697, 567, '15', '2024-03-15 10:36:07', '6', 'CJKT212060009\0', '2024-03-15 07:24:26', '2024-03-15 07:24:26', NULL); /*!40000 ALTER TABLE `attendance_info` ENABLE KEYS */; -- Dumping structure for table crud-two.checks CREATE TABLE IF NOT EXISTS `checks` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `emp_id` int unsigned NOT NULL, `attendance_time` datetime NOT NULL, `leave_time` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `checks_emp_id_foreign` (`emp_id`), CONSTRAINT `checks_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.checks: ~0 rows (approximately) /*!40000 ALTER TABLE `checks` DISABLE KEYS */; /*!40000 ALTER TABLE `checks` ENABLE KEYS */; -- Dumping structure for table crud-two.employees CREATE TABLE IF NOT EXISTS `employees` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pin_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `email_verified_at` timestamp NULL DEFAULT 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 `employees_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.employees: ~0 rows (approximately) /*!40000 ALTER TABLE `employees` DISABLE KEYS */; /*!40000 ALTER TABLE `employees` ENABLE KEYS */; -- Dumping structure for table crud-two.employee_infos CREATE TABLE IF NOT EXISTS `employee_infos` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `device_serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.employee_infos: ~0 rows (approximately) /*!40000 ALTER TABLE `employee_infos` DISABLE KEYS */; INSERT INTO `employee_infos` (`id`, `uid`, `user_id`, `name`, `role`, `password`, `card_no`, `device_serial_number`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, '2', '101176697', 'ElmerMarcos', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (2, '3', '101180471', 'rogelio', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (3, '4', '101180507', 'ericne pomuceno', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (4, '6', '101204486', 'Angela Grace Tolentino', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (5, '7', '101204487', 'john allen rizaldo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (6, '8', '101204575', 'Elyzel Tugano', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (7, '9', '101217370', 'analyn misolas', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (8, '10', '101217384', 'CalixtoPoquitaJr', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (9, '11', '101217432', 'NenaMaeEcleo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (10, '12', '101217435', 'princess mae aguila', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:23', '2024-02-26 13:21:23', NULL), (11, '13', '101217511', 'Rafael Mapoy', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (12, '14', '101220584', 'CarolinaLlanto', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (13, '15', '101220585', 'JennyLibanan', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (14, '16', '101220586', 'lovely joy catahum', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (15, '17', '101220605', 'CollinsPatindol', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (16, '18', '101220736', 'joram ruffy', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (17, '19', '101220737', 'jo ann babelonia', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (18, '20', '101232924', 'nixon kadtong', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (19, '21', '101232949', 'nadialynne lampos', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (20, '22', '101232985', 'kim pastidio', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (21, '23', '101232986', 'angelo genovea', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (22, '24', '101232993', 'daniel cruz', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (23, '25', '101233012', 'karen cabaliw', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (24, '26', '101233053', 'Christian Bautista', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (25, '27', '102070004', 'Renel Bautista', '14', '12142008 ', '0012075591 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (26, '28', '102080605', 'Maan Baga', '0', '', '0005944275 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (27, '29', '102080608', 'Marjorie E. Acejo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (28, '30', '102132138', 'EVAN FADRIQUELA', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (29, '31', '102164639', 'JAMILLE IRIS TORRES', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (30, '32', '102164669', 'Rashin C. Carranza', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (31, '33', '102180563', 'Marilyn Garciano', '14', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (32, '34', '102204736', 'carl philip naceno', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (33, '35', '102204856', 'Daniella Figuroa', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (34, '36', '102217661', 'jaquilyn matampale', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (35, '37', '102220753', 'charisse cabunoc', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (36, '38', '102233188', 'terry esperida', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (37, '40', '103205128', 'Angelito Sta. Ana', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (38, '41', '103205129', 'Ermeo Jose Banquillo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (39, '42', '103205130', 'alyzha bernardo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (40, '43', '103205397', 'Zyra Mae Dayo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (41, '44', '103205452', 'gerald genabe', '14', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (42, '45', '103220945', 'melody areja', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (43, '46', '103233241', 'anne mits racsa', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (44, '47', '103233301', 'stephanie reondanga', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (45, '48', '104050160', 'Antoine Avendaño', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (46, '49', '104050169', 'Ana Mylene Avendaño', '0', '1830', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (47, '50', '104154000', 'JANINENISPEROS', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (48, '51', '104181252', 'ark unisa', '14', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (49, '52', '104181440', 'Lorenzo Martin', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (50, '53', '104193037', 'Marvin Dizon', '14', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (51, '54', '104221221', 'archie galvo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (52, '55', '104221236', 'venus rabino', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (53, '56', '104221337', 'michael almueda', '14', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (54, '57', '104221344', 'chriscella ramoso', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (55, '58', '104233539', 'jemelyn mamaril', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (56, '59', '105111268', 'JOANA TALUCOD', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (57, '60', '105218677', 'khalil kerr madali', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (58, '61', '105233581', 'earl adrian de vera', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (59, '62', '105233618', 'jasmin faye serrano', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (60, '63', '105233711', 'Jiselle Bigueras', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (61, '64', '106080657', 'Wendie V. Belen', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (62, '65', '106143166', 'Angelo Sherwin Borja', '14', '123456', '0011035472 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (63, '66', '106218995', 'Janine Tinga', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (64, '67', '106221643', 'aisha monique avendano', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (65, '68', '106233800', 'shaira dacillo', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (66, '69', '106233801', 'jethro flores', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (67, '70', '107101066', 'maria fe castano', '0', '1831', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (68, '71', '107121890', 'Ian F. Flores', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (69, '72', '107182015', 'KAILA ANGELICA CRUZ', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (70, '73', '107219303', 'john vicdel santos', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (71, '74', '107233963', 'Jachelle', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (72, '75', '107233964', 'Iglesia', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (73, '76', '107233965', 'Capa', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (74, '77', '107233966', 'Soza', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (75, '78', '107233967', 'Rafael', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (76, '79', '107233968', 'Corres,Joseph', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (77, '80', '107233973', 'Roda,Khazyl', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (78, '81', '107233974', 'Kimberly Quejada', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (79, '82', '108030001', 'Ellen Talucod', '0', '', '0008709765 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (80, '83', '108030004', 'Nelia A. Navarro', '0', '', '0002498515 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (81, '84', '108121914', 'Roberto Tan', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (82, '85', '108165782', 'JENNYLYN LARIBA', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (83, '86', '108193557', 'yrra go', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (84, '87', '108221936', 'jun anthony abanero', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (85, '88', '109132354', 'Janelle A. Conferido', '14', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (86, '89', '109179513', 'Adelinda Cordero', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (87, '90', '109182249', 'Abraham R Geneta', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (88, '91', '109193836', 'Manuel Tan', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (89, '92', '109222133', 'lemuel espina', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (90, '93', '110170003', 'phoebe aguilar', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (91, '94', '110222201', 'ruby anne costales', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (92, '95', '111143644', 'liby', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (93, '96', '111194253', 'MarkJaySantiago', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (94, '97', '111194311', 'aezel labaco', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (95, '98', '111206968', 'julie anne yabes', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (96, '99', '111206969', 'Briant Al Gabriel Castr', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (97, '100', '111210210', 'jessa rose bantolinao', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (98, '101', '111222330', 'eric john shimura', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (99, '102', '112090906', 'Madonna O. Maure', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (100, '103', '112170402', 'Jorish Bautista', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (101, '104', '112194341', 'shaira junsay', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (102, '105', '112194342', 'gerramie ella', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (103, '106', '112207061', 'macy ruth de asis', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (104, '107', '123011117', 'jamaica oben', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (105, '108', '1111', 'Technical', '0', '', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (106, '112', '101192697', 'benedict', '14', '123456', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (107, '115', '115', 'asd', '14', '14', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:21:24', '2024-02-26 13:21:24', NULL), (111, '116', '116', 'test sept', '123', '15', '0000000000 ', 'CJKT212060009\0', '2024-02-26 13:28:59', '2024-02-26 13:28:59', NULL), (112, '117', '1176692', 'Solana Akia L. Aquino', '0', '96', '0000000000 ', 'CJKT212060009\0', '2024-02-27 11:26:03', '2024-02-27 11:26:03', NULL), (113, '1', '108234363', 'norielyn villarta', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (114, '2', '108234239', 'Princess Bondoc', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (115, '3', '110234501', 'Jaydelyn Batusan', '14', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (116, '4', '101244997', 'Tamayo, Clarence T.', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (117, '5', '101245014', 'Ricablanca, Christine M', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (118, '6', '101245037', 'Vallar, Jared Michael', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (119, '7', '124011798', 'De Guzman, Dionalyn D.', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (120, '8', '110234598', 'Kryzschl Shaylyn Melad', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (121, '9', '111234637', 'AngelitoSalamat', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (122, '10', '111234707', 'Gabriel, Juan Carlos S.', '14', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (123, '11', '111234733', 'Ladao, Jaryll Manilhig', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (124, '12', '111234766', 'Bañares, Veronica Mae', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (125, '13', '124011805', 'Bernardo, Arnold', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (126, '14', '111234768', 'Lagaña, Janna Marie', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (127, '15', '101244887', 'Cortez, Roseann C', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (128, '16', '101244888', 'Pagaduan, Kristine Faye', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (129, '17', '101244889', 'Tabora, Kimberly I.', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (130, '18', '101244928', 'Languido, Princess Ann', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (131, '19', '101244985', 'Asuncion, Aimee Jhen O.', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (132, '20', '101245086', 'Reyes, Denise Anne', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (133, '21', '101245088', 'Conte, Andrei Sam', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (134, '22', '12121212', 'ATTYCELESTINO MIRANDA', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (135, '23', '102245325', 'Eugenio, Dominador', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (136, '24', '103245345', 'Aguilar, Marbie', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (137, '25', '103245346', 'Damaso, Aries', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (138, '26', '103245347', 'Soriano, Earl Daniel', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (139, '27', '124031867', 'Esteban, Sheena Claire', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (140, '28', '103245385', 'Baluran, Jeric G.', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (141, '29', '103245386', 'Barcelona, Shalmia N.', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (142, '30', '103245387', 'Mella, Erwin Jan V', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (143, '31', '103245407', 'Tiraña, Yellow Rose R.', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (144, '489', '101232986', 'angelo genovea', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (145, '490', '104221236', 'venus rabino', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (146, '491', '104221344', 'chriscella ramoso', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (147, '492', '111194253', 'MarkJaySantiago', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (148, '494', '101164521', 'leniza ferrer', '0', '28270202 ', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (149, '496', '101192697', 'Benedict', '14', '123456', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (150, '499', '101217435', 'princess mae aguila', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (151, '500', '101220736', 'joram ruffy', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (152, '501', '101220737', 'jo ann babelonia', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (153, '502', '101232949', 'nadialynne lampos', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (154, '503', '102070004', 'Renel Bautista', '14', '12142008 ', '0011046750 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (155, '505', '102220753', 'charisse cabunoc', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (156, '506', '103192998', 'jake melendrez', '14', '', '0010909795 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (157, '507', '103205128', 'Angelito Sta. Ana', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (158, '508', '103205129', 'Ermeo Jose Banquillo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (159, '509', '103220945', 'melody areja', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (160, '510', '103233301', 'stephanie reondanga', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (161, '512', '104181252', 'ark unisa', '14', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (162, '513', '104193037', 'Marvin Dizon', '14', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (163, '514', '104221337', 'michael almueda', '14', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (164, '515', '104233539', 'jemelyn mamaril', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (165, '517', '106143166', 'Angelo Sherwin Borja', '14', '123456', '0008937940 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (166, '519', '109040086', 'Alona Isla', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (167, '520', '109132354', 'Janelle A. Conferido', '14', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (168, '521', '109154249', 'Alvin Portin', '0', '28270202 ', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (169, '522', '109182249', 'Abraham R Geneta', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (170, '523', '110170003', 'phoebe aguilar', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (171, '524', '111140003', 'Reena Eloisa Bautista', '0', '1830', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (172, '525', '111143644', 'liby', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (173, '526', '111194311', 'aezel labaco', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (174, '527', '111206968', 'julie anne yabes', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (175, '528', '111210210', 'jessa rose bantolinao', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (176, '529', '112194342', 'gerramie ella', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (177, '530', '101180507', 'ericne pomuceno', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (178, '531', '102204856', 'Daniella Figuroa', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (179, '532', '107193417', 'kris bryan bandong', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (180, '533', '112194341', 'shaira junsay', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (181, '534', '104121626', 'ARNEL DOMINGO', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (182, '536', '112090906', 'Madonna O. Maure', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (183, '537', '103181100', 'Erwin Bariso', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (184, '538', '107121890', 'Ian F. Flores', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (185, '539', '110222201', 'ruby anne costales', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (186, '540', '108221936', 'jun anthony abanero', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (187, '541', '101176697', 'ElmerMarcos', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (188, '542', '101220585', 'JennyLibanan', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (189, '543', '101220584', 'CarolinaLlanto', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (190, '544', '104181440', 'Lorenzo Martin', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (191, '546', '108193557', 'yrra go', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (192, '547', '102132138', 'EVAN FADRIQUELA', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (193, '548', '107182015', 'KAILA ANGELICA CRUZ', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (194, '549', '106233800', 'shaira dacillo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (195, '550', '106233801', 'jethro flores', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (196, '551', '102142664', 'Nina Usi', '0', '1830', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (197, '552', '111222330', 'eric john shimura', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (198, '553', '102080608', 'Marjorie E. Acejo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (199, '554', '112194339', 'diana rose conselado', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (200, '555', '101220605', 'CollinsPatindol', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (201, '556', '101232985', 'kim pastidio', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (202, '557', '123011117', 'jamaica oben', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (203, '558', '101217370', 'analyn misolas', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (204, '559', '101217432', 'NenaMaeEcleo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (205, '560', '102233188', 'terry esperida', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (206, '561', '104221221', 'archie galvo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (207, '562', '107101066', 'maria fe castano', '0', '1831', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (208, '563', '107233965', 'Capa', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (209, '564', '104154000', 'JANINENISPEROS', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (210, '565', '103233241', 'anne mits racsa', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (211, '566', '2', 'Technical', '14', '0143', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (212, '568', '108030004', 'Nelia A. Navarro', '0', '', '0002498515 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (213, '569', '101217384', 'CalixtoPoquitaJr', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (214, '570', '103180896', 'Diosdado Cajes', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (215, '571', '103205452', 'gerald genabe', '14', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (216, '572', '106080657', 'Wendie V. Belen', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (217, '573', '106132244', 'Chelo Legaspi', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (218, '574', '106165438', 'Michael Reguyal', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (219, '575', '101180471', 'rogelio', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (220, '576', '102080605', 'Maan Baga', '0', '', '0005944275 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (221, '577', '102217661', 'jaquilyn matampale', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (222, '579', '112080052', 'Collie Barbaso', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (223, '580', '112207061', 'macy ruth de asis', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:02', '2024-03-14 08:35:02', NULL), (224, '581', '103205397', 'Zyra Mae Dayo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (225, '582', '108030001', 'Ellen Talucod', '0', '', '0008709765 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (226, '583', '101232993', 'daniel cruz', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (227, '584', '101233053', 'Christian Bautista', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (228, '585', '10123392', '10123392', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (229, '587', '111206969', 'Briant Al Gabriel Castr', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (230, '588', '101232924', 'nixon kadtong', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (231, '589', '105218677', 'khalil kerr madali', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (232, '590', '107233967', 'Rafael', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (233, '592', '107233973', 'Roda,Khazyl', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (234, '593', '101204487', 'john allen rizaldo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (235, '595', '109222133', 'lemuel espina', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (236, '596', '102164669', 'Rashin C. Carranza', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (237, '597', '104050169', 'Ana Mylene Avenda駉', '0', '1830', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (238, '598', '101153831', 'Angela Sedillo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (239, '599', '101176644', 'Lavinia Gatmaitan', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (240, '600', '104050160', 'Antoine Avenda駉', '0', '', '0007181386 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (241, '601', '112170402', 'Jorish Bautista', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (242, '602', '103205130', 'alyzha bernardo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (243, '603', '107233966', 'Soza', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (244, '604', '108165782', 'JENNYLYN LARIBA', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (245, '605', '103164719', 'rose angelene gonzales', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (246, '606', '107233963', 'Jachelle', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (247, '607', '101220586', 'lovely joy catahum', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (248, '608', '107233964', 'Iglesia', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (249, '609', '112194414', 'camille lopez', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (250, '610', '100000001', 'ETT', '0', '', '0014522525 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (251, '614', '1234', 'NAN', '0', '', '0007383742 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (252, '615', '102245306', 'Hernalyn Buising', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL), (253, '616', '102245305', 'Mikaela Mariz Leonardo', '0', '', '0000000000 ', 'AF39211260005\0', '2024-03-14 08:35:03', '2024-03-14 08:35:03', NULL); /*!40000 ALTER TABLE `employee_infos` ENABLE KEYS */; -- Dumping structure for table crud-two.failed_jobs CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` bigint 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 crud-two.failed_jobs: ~0 rows (approximately) /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; -- Dumping structure for table crud-two.finger_devices CREATE TABLE IF NOT EXISTS `finger_devices` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `serialNumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `finger_devices_serialnumber_unique` (`serialNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.finger_devices: ~0 rows (approximately) /*!40000 ALTER TABLE `finger_devices` DISABLE KEYS */; INSERT INTO `finger_devices` (`id`, `name`, `ip`, `serialNumber`, `created_at`, `updated_at`, `deleted_at`) VALUES (2, 'Room E', '192.168.0.17', 'AF39211260005\0', '2024-02-26 08:15:36', '2024-03-14 11:44:44', '2024-03-14 11:44:44'), (3, 'bio test', '192.168.0.63', '3394171100244\0', '2024-03-15 09:46:43', '2024-03-15 09:46:43', NULL); /*!40000 ALTER TABLE `finger_devices` ENABLE KEYS */; -- Dumping structure for table crud-two.latetimes CREATE TABLE IF NOT EXISTS `latetimes` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `emp_id` int unsigned NOT NULL, `duration` time NOT NULL, `latetime_date` date NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `latetimes_emp_id_foreign` (`emp_id`), CONSTRAINT `latetimes_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.latetimes: ~0 rows (approximately) /*!40000 ALTER TABLE `latetimes` DISABLE KEYS */; /*!40000 ALTER TABLE `latetimes` ENABLE KEYS */; -- Dumping structure for table crud-two.leaves CREATE TABLE IF NOT EXISTS `leaves` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `uid` int unsigned NOT NULL DEFAULT '0', `emp_id` int unsigned NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '0', `leave_time` time NOT NULL DEFAULT '06:57:39', `leave_date` date NOT NULL DEFAULT '2024-02-26', `status` tinyint(1) NOT NULL DEFAULT '1', `type` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `leaves_emp_id_foreign` (`emp_id`), CONSTRAINT `leaves_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.leaves: ~0 rows (approximately) /*!40000 ALTER TABLE `leaves` DISABLE KEYS */; /*!40000 ALTER TABLE `leaves` ENABLE KEYS */; -- Dumping structure for table crud-two.migrations CREATE TABLE IF NOT EXISTS `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.migrations: ~15 rows (approximately) /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (17, '2014_10_12_000000_create_users_table', 1), (18, '2014_10_12_100000_create_password_resets_table', 1), (19, '2019_08_19_000000_create_failed_jobs_table', 1), (20, '2019_11_25_113026_create_employees_table', 1), (21, '2019_12_02_141403_create_roles_table', 1), (22, '2019_12_03_044741_create_schedules_table', 1), (23, '2019_12_03_045452_create_attendances_table', 1), (24, '2019_12_03_045912_create_latetimes_table', 1), (25, '2019_12_03_045930_create_overtimes_table', 1), (26, '2019_12_03_050030_create_leaves_table', 1), (27, '2019_12_14_000001_create_personal_access_tokens_table', 1), (28, '2019_12_22_183558_create_checks_table', 1), (29, '2021_06_05_110414_create_finger_devices_table', 1), (30, '2023_09_14_112323_create_employee_infos_table', 1), (31, '2024_02_23_051750_attendance_info', 1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; -- Dumping structure for table crud-two.overtimes CREATE TABLE IF NOT EXISTS `overtimes` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `emp_id` int unsigned NOT NULL, `duration` time NOT NULL, `overtime_date` date NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `overtimes_emp_id_foreign` (`emp_id`), CONSTRAINT `overtimes_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.overtimes: ~0 rows (approximately) /*!40000 ALTER TABLE `overtimes` DISABLE KEYS */; /*!40000 ALTER TABLE `overtimes` ENABLE KEYS */; -- Dumping structure for table crud-two.password_resets CREATE TABLE IF NOT EXISTS `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 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 structure for table crud-two.personal_access_tokens CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `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, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 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 structure for table crud-two.roles CREATE TABLE IF NOT EXISTS `roles` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.roles: ~0 rows (approximately) /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` (`id`, `slug`, `name`, `permissions`, `created_at`, `updated_at`) VALUES (1, 'admin', 'Adminstrator', NULL, '2024-02-26 06:58:47', '2024-02-26 06:58:47'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; -- Dumping structure for table crud-two.role_users CREATE TABLE IF NOT EXISTS `role_users` ( `user_id` int unsigned NOT NULL, `role_id` int unsigned NOT NULL, PRIMARY KEY (`user_id`,`role_id`), KEY `role_users_role_id_foreign` (`role_id`), CONSTRAINT `role_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE, CONSTRAINT `role_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.role_users: ~0 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 structure for table crud-two.schedules CREATE TABLE IF NOT EXISTS `schedules` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `time_in` time NOT NULL, `time_out` time NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `schedules_slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table crud-two.schedules: ~0 rows (approximately) /*!40000 ALTER TABLE `schedules` DISABLE KEYS */; /*!40000 ALTER TABLE `schedules` ENABLE KEYS */; -- Dumping structure for table crud-two.schedule_employees CREATE TABLE IF NOT EXISTS `schedule_employees` ( `emp_id` int unsigned NOT NULL, `schedule_id` int unsigned NOT NULL, KEY `schedule_employees_emp_id_foreign` (`emp_id`), KEY `schedule_employees_schedule_id_foreign` (`schedule_id`), CONSTRAINT `schedule_employees_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE, CONSTRAINT `schedule_employees_schedule_id_foreign` FOREIGN KEY (`schedule_id`) REFERENCES `schedules` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 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 structure for table crud-two.users CREATE TABLE IF NOT EXISTS `users` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pin_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `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 crud-two.users: ~0 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@gmail.com', NULL, NULL, NULL, '$2y$10$uuwMvMzeruBxtWBBxqou/OelCBTV9C6rgi15RmbH0KiY0.lR7u6BW', NULL, '2024-02-26 06:58:47', '2024-02-26 06:58:47'); /*!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) */;