--
-- Host: localhost    Database: easy_iclock
-- ------------------------------------------------------


--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subject_id` bigint unsigned DEFAULT NULL,
  `causer_type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `causer_id` bigint unsigned DEFAULT NULL,
  `properties` text COLLATE utf8mb3_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject_type`,`subject_id`),
  KEY `causer` (`causer_type`,`causer_id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `activity_log`
--


--
-- Table structure for table `auto_numbers`
--

CREATE TABLE `auto_numbers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8mb3_unicode_ci NOT NULL,
  `number` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `auto_numbers`
--


--
-- Table structure for table `commands`
--

CREATE TABLE `commands` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `device_id` bigint unsigned NOT NULL,
  `command` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` tinyint DEFAULT '1',
  `return_command` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expired_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `commands_device_id_foreign` (`device_id`),
  CONSTRAINT `commands_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `commands`
--

INSERT INTO `commands` VALUES (1,2,'CLEAR LOG',1,NULL,'2023-02-09 08:48:39','2023-02-09 08:48:39',NULL),(2,2,'CLEAR DATA',1,NULL,'2023-02-09 08:49:04','2023-02-09 08:49:04',NULL),(3,2,'LOG',1,NULL,'2023-02-09 08:49:11','2023-02-09 08:49:11',NULL),(4,2,'DATA QUERY ATTLOG StartTime=09 Feb 2023 EndTime=09 Feb 2023',1,NULL,'2023-02-09 08:56:13','2023-02-09 08:56:13',NULL),(5,2,'INFO',1,NULL,'2023-02-09 08:57:56','2023-02-09 08:57:56','2023-02-09 16:57:56'),(6,1,'DATA QUERY ATTLOG StartTime=2023-02-10 01:00:00 EndTime=10 Feb 2023 19:00:00',1,NULL,'2023-02-10 00:52:30','2023-02-10 00:52:30','2023-02-10 08:52:30'),(7,1,'LOG',1,NULL,'2023-02-10 00:53:52','2023-02-10 00:53:52','2023-02-10 08:53:52'),(8,1,'DATA QUERY ATTLOG StartTime=2023-02-10 02:30:00 EndTime=10 Feb 2023 23:59:00',1,NULL,'2023-02-10 00:55:20','2023-02-10 00:55:20','2023-02-10 08:55:20'),(9,1,'DATA QUERY ATTLOG StartTime=2023-02-10 02:30:00 EndTime=10 Feb 2023 23:59:00',1,NULL,'2023-02-10 00:55:58','2023-02-10 00:55:58','2023-02-10 08:55:58'),(10,1,'DATA QUERY ATTLOG StartTime=2023-02-10 02:00:50 EndTime=2023-02-10 23:59:59',1,NULL,'2023-02-10 00:56:31','2023-02-10 00:56:31','2023-02-10 08:56:31'),(11,1,'DATA QUERY ATTLOG StartTime=2023-02-10 02:30:00 EndTime=10 Feb 2023 23:59:00',1,NULL,'2023-02-10 01:55:53','2023-02-10 01:55:53','2023-02-10 09:55:53'),(12,1,'DATA QUERY ATTLOG StartTime=2023-02-10 02:30:00 EndTime=10 Feb 2023 23:59:00',1,NULL,'2023-02-10 01:56:22','2023-02-10 01:56:22','2023-02-10 09:56:22'),(13,1,'CHECK',1,NULL,'2023-02-10 01:56:41','2023-02-10 01:56:41','2023-02-10 09:56:41'),(14,1,'CHECK',1,NULL,'2023-02-10 02:07:57','2023-02-10 02:07:57','2023-02-10 10:07:57'),(15,1,'CHECK',1,NULL,'2023-02-10 02:08:32','2023-02-10 02:08:32','2023-02-10 10:08:32'),(16,1,'CHECK',1,NULL,'2023-02-10 02:09:18','2023-02-10 02:09:18','2023-02-10 10:09:18'),(17,1,'LOG',1,NULL,'2023-02-10 02:09:29','2023-02-10 02:09:29','2023-02-10 10:09:29');

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `serial_number` varchar(40) COLLATE utf8mb3_unicode_ci NOT NULL,
  `additional_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attlog_stamp` int DEFAULT NULL,
  `operlog_stamp` int DEFAULT NULL,
  `attphotolog_stamp` int DEFAULT NULL,
  `error_delay` int DEFAULT '30',
  `delay` int DEFAULT '30',
  `trans_times` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT '00:00;14:05',
  `trans_interval` int DEFAULT '1',
  `trans_flag` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT '1111111100',
  `timezone` int DEFAULT '7',
  `realtime` tinyint DEFAULT '1',
  `encrypt` tinyint DEFAULT '0',
  `server_version` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `table_name_stamp` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `devices_serial_number_unique` (`serial_number`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `devices`
--

INSERT INTO `devices` VALUES (1,'03161446800308','Ver 2.0.12-20150625,0,09,192.168.1.254,107.150.111',10002,NULL,NULL,30,30,'00:00;14:05',1,'1111111100',7,1,0,'2.2.14',NULL,'2023-01-25 04:10:13','2023-05-05 12:52:56','Mesin 1'),(2,'CKEB221060250','Ver 8.0.4.2-20200723,153,316,39279,192.168.1.203,10,-1,0,0,101',9999,NULL,NULL,30,30,'00:00;14:05',1,'1111111100',7,1,0,'2.4.1',NULL,'2023-01-25 04:42:07','2023-01-27 03:42:32','Mesin Padding Kanan'),(3,'0316144680030888',NULL,10002,NULL,NULL,30,30,'00:00;14:05',1,'1111111100',7,1,0,NULL,NULL,'2023-01-26 07:27:36','2023-01-27 03:43:43','Mesin 2');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `menu_permissions`
--

CREATE TABLE `menu_permissions` (
  `menu_id` bigint unsigned NOT NULL,
  `permission_id` bigint unsigned NOT NULL,
  `status` char(1) COLLATE utf8mb3_unicode_ci DEFAULT '1',
  PRIMARY KEY (`menu_id`,`permission_id`),
  KEY `fk_menu_permission_permissions` (`permission_id`),
  CONSTRAINT `fk_menu_permission_menus` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`),
  CONSTRAINT `fk_menu_permission_permissions` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `menu_permissions`
--

INSERT INTO `menu_permissions` VALUES (4,1,'1'),(5,5,'1'),(6,9,'1'),(7,13,'1'),(9,29,'1'),(12,21,'1'),(13,25,'1'),(14,33,'1'),(15,37,'1'),(16,41,'1');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `icon` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `route` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `_lft` int unsigned DEFAULT NULL,
  `_rgt` int unsigned DEFAULT NULL,
  `seq_number` tinyint DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'Master Data','Header menu master','1','2021-08-09 08:10:07','2023-01-27 10:31:45','cil-address-book',NULL,NULL,19,28,1),(4,'Menu','Manage menu','1','2021-08-09 08:10:07','2023-01-27 10:31:45','cil-address-book','base/menus',1,20,21,1),(5,'User','Manage users','1','2021-08-09 08:10:07','2023-01-27 10:31:45','cil-address-book','base/users',1,22,23,2),(6,'Role','Manage role','1','2021-08-09 08:10:07','2023-01-27 10:31:45','cil-address-book','base/roles',1,24,25,3),(7,'Permission','Manage permissions','1','2021-08-09 08:10:07','2023-01-27 10:31:45','cil-address-book','base/permissions',1,26,27,1),(8,'Attendance','Header attendance','1','2023-01-25 13:52:21','2023-01-27 10:31:45','cil-address-book',NULL,NULL,7,18,2),(9,'Log Finger','Attendance Logfinger','1','2023-01-25 13:53:48','2023-01-27 10:31:45','cil-list','attendanceLogs',8,16,17,1),(10,'Utility','Utility for administrator','1','2023-01-25 14:08:29','2023-01-25 14:12:14','cil-settings',NULL,NULL,1,6,2),(11,'Clear Cache','Clear cache application','1','2023-01-25 14:09:11','2023-01-25 14:12:14','cil-trash','artisan/clear_cache',10,4,5,1),(12,'Fingerprint Device','List device','1','2023-01-25 14:10:34','2023-01-27 10:31:45','cil-devices','devices',8,14,15,2),(13,'User Device','User in device','1','2023-01-25 14:11:08','2023-01-27 10:31:45','cil-user','userDevices',8,12,13,3),(14,'Command','Command to devices','1','2023-01-25 14:11:40','2023-01-27 10:31:45','cil-command','commands',8,10,11,4),(15,'Setting','Setting application','1','2023-01-25 14:12:14','2023-01-25 14:12:14','cil-settings','settings',10,2,3,2),(16,'Webhook Device','Set url to forward data from device','1','2023-01-27 10:31:45','2023-01-27 10:31:45','cil-media-skip-forward','webhooks',8,8,9,5);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (123,'2014_10_12_000000_create_users_table',1),(124,'2014_10_12_100000_create_password_resets_table',1),(125,'2017_08_03_055212_create_auto_numbers',1),(126,'2019_08_19_000000_create_failed_jobs_table',1),(127,'2019_12_14_000001_create_personal_access_tokens_table',1),(128,'2021_07_07_080836_create_permission_tables',1),(129,'2021_08_06_225424_create_menus_table',1),(130,'2021_08_06_225434_create_menu_permissions_table',1),(131,'2021_09_08_054823_create_activity_log_table',1),(132,'2021_09_09_152314_alter_user_add_deleted_at',1),(133,'2023_01_24_132050_create_devices',1),(134,'2023_01_24_132146_create_attendance_logs',1),(135,'2023_01_24_132233_create_user_devices',1),(136,'2023_01_24_132305_create_commands',1),(137,'2023_01_24_132643_create_settings',1),(138,'2023_01_24_135831_create_template_fingerprint_devices',1),(139,'2023_01_26_151048_create_webhooks',2),(141,'2023_01_27_103335_add_name_column_device',3),(143,'2023_02_09_112611_add_command_return',4);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\Base\\User',1);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'menus-index','web',NULL,NULL),(2,'menus-create','web',NULL,NULL),(3,'menus-update','web',NULL,NULL),(4,'menus-delete','web',NULL,NULL),(5,'users-index','web',NULL,NULL),(6,'users-create','web',NULL,NULL),(7,'users-update','web',NULL,NULL),(8,'users-delete','web',NULL,NULL),(9,'roles-index','web',NULL,NULL),(10,'roles-create','web',NULL,NULL),(11,'roles-update','web',NULL,NULL),(12,'roles-delete','web',NULL,NULL),(13,'permissions-index','web',NULL,NULL),(14,'permissions-create','web',NULL,NULL),(15,'permissions-update','web',NULL,NULL),(16,'permissions-delete','web',NULL,NULL),(17,'template_fingerprint_devices-index','web',NULL,NULL),(18,'template_fingerprint_devices-create','web',NULL,NULL),(19,'template_fingerprint_devices-update','web',NULL,NULL),(20,'template_fingerprint_devices-delete','web',NULL,NULL),(21,'devices-index','web',NULL,NULL),(22,'devices-create','web',NULL,NULL),(23,'devices-update','web',NULL,NULL),(24,'devices-delete','web',NULL,NULL),(25,'user_devices-index','web',NULL,NULL),(26,'user_devices-create','web',NULL,NULL),(27,'user_devices-update','web',NULL,NULL),(28,'user_devices-delete','web',NULL,NULL),(29,'attendance_logs-index','web',NULL,NULL),(30,'attendance_logs-create','web',NULL,NULL),(31,'attendance_logs-update','web',NULL,NULL),(32,'attendance_logs-delete','web',NULL,NULL),(33,'commands-index','web',NULL,NULL),(34,'commands-create','web',NULL,NULL),(35,'commands-update','web',NULL,NULL),(36,'commands-delete','web',NULL,NULL),(37,'settings-index','web',NULL,NULL),(38,'settings-create','web',NULL,NULL),(39,'settings-update','web',NULL,NULL),(40,'settings-delete','web',NULL,NULL),(41,'webhooks-index','web','2023-01-27 03:27:28','2023-01-27 03:27:28'),(42,'webhooks-create','web','2023-01-27 03:27:28','2023-01-27 03:27:28'),(43,'webhooks-update','web','2023-01-27 03:27:28','2023-01-27 03:27:28'),(44,'webhooks-delete','web','2023-01-27 03:27:28','2023-01-27 03:27:28');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'administrator','web','2021-10-26 15:21:21','2021-10-26 15:21:21');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `settings`
--


--
-- Table structure for table `webhooks`
--

CREATE TABLE `webhooks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `device_id` bigint unsigned NOT NULL,
  `url` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `webhooks_device_id_unique` (`device_id`),
  CONSTRAINT `webhooks_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `webhooks`
--

INSERT INTO `webhooks` VALUES (1,2,'https://fssafafa.ssds.comfdsb','2023-01-27 04:06:53','2023-01-27 04:06:53'),(2,1,'http://127.0.0.1:8001/iclock/webhook?deviceId=3','2023-01-27 06:20:27','2023-01-27 07:43:10');

--
-- Dumping routines for database 'easy_iclock'
--


