-- MySQL dump 10.13 Distrib 8.0.36, for Win64 (x86_64) -- -- Host: 64.31.43.162 Database: techwork_dump_simpleclock -- ------------------------------------------------------ -- Server version 5.5.5-10.6.17-MariaDB-cll-lve /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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 */; -- -- Table structure for table `attendances` -- DROP TABLE IF EXISTS `attendances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `attendances` ( `id` int(11) NOT NULL AUTO_INCREMENT, `employee_id` int(11) NOT NULL, `date` date NOT NULL, `clock_in_time` time DEFAULT NULL, `clock_out_time` time DEFAULT NULL, `server_ip` varchar(255) NOT NULL, `working_time` time NOT NULL DEFAULT '00:00:00', `last_clock_in` datetime DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`), CONSTRAINT `attendances_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendances` -- LOCK TABLES `attendances` WRITE; /*!40000 ALTER TABLE `attendances` DISABLE KEYS */; INSERT INTO `attendances` VALUES (1,5,'2024-05-30','13:09:47',NULL,'127.0.0.1','00:00:00','2024-05-30 13:09:47','2024-05-30 13:09:47','2024-05-30 13:09:47'),(2,4,'2024-05-30','16:05:26',NULL,'127.0.0.1','00:00:00','2024-05-30 16:05:26','2024-05-30 16:05:26','2024-05-30 16:05:26'),(3,4,'2024-05-31','07:05:08','12:34:44','39.35.163.67','00:00:01','2024-05-31 07:05:08','2024-05-31 07:05:08','2024-05-31 12:34:44'),(4,5,'2024-05-31','12:58:54','15:44:43','39.35.163.67','00:00:00','2024-05-31 12:58:54','2024-05-31 12:58:54','2024-05-31 15:44:43'),(5,8,'2024-05-31','14:01:42',NULL,'39.35.163.67','00:00:00','2024-05-31 14:01:42','2024-05-31 14:01:42','2024-05-31 14:01:42'),(6,5,'2024-06-02','06:47:53','07:34:14','103.12.197.153','00:00:00','2024-06-02 06:47:53','2024-06-02 06:47:53','2024-06-02 07:34:14'),(7,4,'2024-06-02','07:55:51','09:27:13','103.12.197.153','00:00:00','2024-06-02 07:55:51','2024-06-02 07:55:51','2024-06-02 09:27:13'),(8,4,'2024-06-03','06:05:18','07:26:49','103.12.197.153','00:00:00','2024-06-03 06:05:18','2024-06-03 06:05:18','2024-06-03 07:26:49'),(9,9,'2024-06-03','06:22:33','23:59:00','39.35.139.76','00:00:01','2024-06-03 06:22:33','2024-06-03 06:22:33','2024-06-03 06:30:26'),(10,5,'2024-06-03','08:05:05','13:36:48','103.12.197.153','00:00:00','2024-06-03 08:05:05','2024-06-03 08:05:05','2024-06-03 13:36:48'),(11,90,'2024-06-03','10:12:39','23:59:00','127.0.0.1','00:00:00','2024-06-03 10:12:39','2024-06-03 10:12:39','2024-06-03 23:59:08'),(12,10,'2024-06-03','13:58:26','14:44:18','103.12.197.157','00:00:00','2024-06-03 13:58:26','2024-06-03 13:58:26','2024-06-03 14:44:18'),(13,4,'2024-06-04','03:25:28','05:37:25','37.111.149.238','00:00:00','2024-06-04 03:25:28','2024-06-04 03:25:28','2024-06-04 05:37:25'),(14,10,'2024-06-04','05:45:46','06:13:09','37.111.149.238','00:00:00','2024-06-04 05:45:46','2024-06-04 05:45:46','2024-06-04 06:13:09'),(15,5,'2024-06-04','06:30:33','08:17:55','37.111.149.238','00:00:00','2024-06-04 06:30:33','2024-06-04 06:30:33','2024-06-04 08:17:55'),(16,9,'2024-06-04','07:09:22','23:59:00','127.0.0.1','00:00:00','2024-06-04 07:09:22','2024-06-04 07:09:22','2024-06-04 23:59:03'),(17,58,'2024-06-04','09:02:52','09:13:25','37.111.149.238','00:00:00','2024-06-04 09:02:52','2024-06-04 09:02:52','2024-06-04 09:13:25'),(18,59,'2024-06-04','09:16:41','09:37:56','37.111.149.238','00:00:00','2024-06-04 09:16:41','2024-06-04 09:16:41','2024-06-04 09:37:56'),(19,63,'2024-06-04','09:42:03','12:52:51','37.111.149.238','00:00:00','2024-06-04 09:42:03','2024-06-04 09:42:03','2024-06-04 12:52:51'),(20,62,'2024-06-04','12:57:50','13:17:54','37.111.147.50','00:00:00','2024-06-04 12:57:50','2024-06-04 12:57:50','2024-06-04 13:17:54'),(21,61,'2024-06-04','13:19:04','13:29:56','103.12.197.158','00:00:00','2024-06-04 13:19:04','2024-06-04 13:19:04','2024-06-04 13:29:56'),(22,60,'2024-06-04','13:31:43','13:35:23','103.12.197.158','00:00:00','2024-06-04 13:31:43','2024-06-04 13:31:43','2024-06-04 13:35:23'),(23,15,'2024-06-04','13:43:47','13:44:38','103.12.197.158','00:00:00','2024-06-04 13:43:47','2024-06-04 13:43:47','2024-06-04 13:44:38'),(24,17,'2024-06-04','13:54:29','23:59:00','103.12.197.158','00:00:00','2024-06-04 13:54:29','2024-06-04 13:54:29','2024-06-04 23:59:03'),(25,16,'2024-06-04','14:06:35','23:59:00','154.80.16.121','00:00:00','2024-06-04 14:06:35','2024-06-04 14:06:35','2024-06-04 23:59:03'),(26,15,'2024-06-05','05:58:12','07:09:24','103.12.197.158','00:00:00','2024-06-05 05:58:12','2024-06-05 05:58:12','2024-06-05 07:09:24'),(27,4,'2024-06-05','07:13:12','07:15:00','103.12.197.153','00:00:00','2024-06-05 07:13:12','2024-06-05 07:13:12','2024-06-05 07:15:00'),(28,63,'2024-06-05','07:19:28','23:59:00','103.12.197.153','00:00:00','2024-06-05 07:19:28','2024-06-05 07:19:28','2024-06-05 23:59:03'),(29,9,'2024-06-05','11:22:22','11:55:00','127.0.0.1:8000','00:00:00','2024-06-05 08:22:15','2024-06-05 08:22:15','2024-06-05 08:35:01'),(30,9,'2024-06-05','11:22:22','23:59:00','127.0.0.1:8000','00:00:00','2024-06-05 08:22:27','2024-06-05 08:22:27','2024-06-05 23:59:03'),(31,132,'2024-06-05','11:50:00','23:59:00','127.0.0.1:8000','00:00:00','2024-06-05 08:42:41','2024-06-05 08:42:41','2024-06-05 23:59:03'),(32,89,'2024-06-05','10:30:14','23:59:00','39.35.138.168','00:00:00','2024-06-05 10:30:14','2024-06-05 10:30:14','2024-06-05 23:59:03'),(33,93,'2024-06-05','14:22:00','14:42:00','127.0.0.1:8000','00:00:00','2024-06-05 10:32:22','2024-06-05 10:32:22','2024-06-05 10:33:07'),(34,110,'2024-06-05','16:22:00','17:12:00','127.0.0.1:8000','00:00:00','2024-06-05 11:41:35','2024-06-05 11:41:35','2024-06-05 11:41:55'),(35,111,'2024-06-05','20:12:00','22:25:00','127.0.0.1:8000','00:00:00','2024-06-05 20:12:00','2024-06-05 11:50:15','2024-06-05 16:32:36'),(36,83,'2024-06-05','10:00:00','23:59:00','127.0.0.1:8000','00:00:00','2024-06-05 10:00:00','2024-06-05 16:50:17','2024-06-05 23:59:03'),(37,84,'2024-06-05','10:15:00','20:15:00','127.0.0.1:8000','10:00:00','2024-06-05 10:15:00','2024-06-05 17:04:11','2024-06-05 17:08:26'),(38,83,'2024-06-06','11:38:00','18:10:00','127.0.0.1:8000','05:50:00','2024-06-06 11:38:00','2024-06-06 06:38:19','2024-06-06 06:41:51'),(39,19,'2024-06-06','07:15:37','07:42:35','103.12.197.156','00:00:00','2024-06-06 07:15:37','2024-06-06 07:15:37','2024-06-06 07:42:35'),(40,63,'2024-06-06','15:15:00','20:20:00','192.168.0.0','05:05:00','2024-06-06 15:15:00','2024-06-06 12:02:32','2024-06-06 12:07:27'),(41,32,'2024-06-06','13:13:00','23:30:00','100:92:0:0','10:17:00','2024-06-06 13:13:00','2024-06-06 12:10:35','2024-06-06 12:11:30'),(42,12,'2024-06-06','05:13:18','07:01:32','103.12.197.153','01:25:55','2024-06-06 05:13:18','2024-06-06 12:13:21','2024-06-06 14:01:35'),(43,18,'2024-06-06','08:21:19','08:35:57','103.12.197.153','00:11:19','2024-06-06 08:21:19','2024-06-06 15:21:23','2024-06-06 15:36:01'),(44,17,'2024-06-06','08:39:24','08:55:31','103.12.197.153','00:11:35','2024-06-06 08:39:24','2024-06-06 15:39:27','2024-06-06 15:55:34'),(45,16,'2024-06-06','09:29:14','09:45:48','103.12.197.154','00:10:41','2024-06-06 09:29:14','2024-06-06 16:29:25','2024-06-06 16:45:53'),(46,5,'2024-06-06','09:54:51','10:05:55','103.12.197.154','00:09:06','2024-06-06 09:54:51','2024-06-06 16:54:56','2024-06-06 17:05:59'),(47,12,'2024-06-07','11:24:15','11:27:47','103.12.197.156','00:03:08','2024-06-07 11:24:15','2024-06-07 06:24:17','2024-06-07 06:27:49'),(48,32,'2024-06-07','11:33:06','11:35:09','103.12.197.156','00:02:03','2024-06-07 11:33:06','2024-06-07 06:33:09','2024-06-07 06:35:11'),(49,19,'2024-06-07','11:44:13','11:46:16','103.12.197.156','00:02:03','2024-06-07 11:44:13','2024-06-07 06:44:16','2024-06-07 06:46:18'),(50,83,'2024-06-07','12:12:14','12:17:04','103.12.197.156','00:02:53','2024-06-07 12:12:14','2024-06-07 07:12:16','2024-06-07 07:17:06'),(51,18,'2024-06-07','12:17:40','12:26:29','103.12.197.156','00:02:04','2024-06-07 12:17:40','2024-06-07 07:17:42','2024-06-07 07:26:31'),(52,17,'2024-06-07','12:55:13','03:11:51','103.12.197.156','-09:57:57','2024-06-07 12:55:13','2024-06-07 07:55:15','2024-06-07 10:11:55'),(53,16,'2024-06-07','03:28:10','23:59:00','103.12.197.154','00:00:00','2024-06-07 03:28:10','2024-06-07 10:28:14','2024-06-07 23:59:05'),(54,244,'2024-06-07','16:16:49','16:36:50','103.12.197.154','00:08:32','2024-06-07 16:16:49','2024-06-07 11:16:53','2024-06-07 11:36:53'),(55,5,'2024-06-07','17:19:29','23:59:00','103.12.197.153','00:00:00','2024-06-07 17:19:29','2024-06-07 12:19:32','2024-06-07 23:59:05'),(56,12,'2024-06-10','11:06:01','11:16:42','103.12.197.155','00:09:05','2024-06-10 11:06:01','2024-06-10 06:06:03','2024-06-10 06:16:44'); /*!40000 ALTER TABLE `attendances` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-06-10 19:36:46