web_monitor_db_dump.sql
ファイル内容
-- MySQL dump 10.13 Distrib 8.0.42, for Linux (x86_64) -- -- Host: localhost Database: web_monitor_db_012 -- ------------------------------------------------------ -- Server version 8.0.42 /*!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 utf8mb4 */; /*!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 `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settings` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '設定ID', `key` varchar(255) NOT NULL, `value` varchar(255) NOT NULL COMMENT '設定値', PRIMARY KEY (`id`), UNIQUE KEY `key` (`key`), UNIQUE KEY `key_name` (`key`), UNIQUE KEY `key_2` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'is_cron_enabled','True'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL COMMENT '|åå‰| ユーザーå', `chatwork_api_token` varchar(255) NOT NULL COMMENT '|Chatwork APIトークン| Chatwork APIトークン（暗å·åŒ–推奨）', `chatwork_room_id` varchar(255) NOT NULL COMMENT '|ChatworkルームID| Chatworkã®é€šçŸ¥å…ˆãƒ«ãƒ¼ãƒ ID', `is_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT '|アクティブ| 通知をアクティブã«ã™ã‚‹ã‹ã©ã†ã‹', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '|作æˆæ—¥æ™‚| レコード作æˆæ—¥æ™‚', `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '|更新日時| レコード最終更新日時', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='担当者'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'テストアカウント','654a1a48c1d24f7bef57443b83cb416b','401473778',1,'2025-06-06 11:05:34','2025-06-10 02:00:21'),(8,'test','****','349161635',0,'2025-06-11 03:18:43','2025-06-12 10:33:17'),(10,'管理者','654a1a48c1d24f7bef57443b83cb416b','401473778',1,'2025-06-12 08:15:49','2025-06-12 08:15:49'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `website_checks` -- DROP TABLE IF EXISTS `website_checks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `website_checks` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `website_id` int unsigned NOT NULL COMMENT '|ホームページID| websites テーブルã¸ã®å¤–部ã‚ーå‚ç…§', `checked_at` datetime NOT NULL COMMENT '|巡回実行日時| 巡回実行日時', `http_status_code` int unsigned DEFAULT NULL COMMENT '|HTTPステータスコード| HTTPステータスコード (例: 200　403', `error_message` text COMMENT '|エラーメッセージ| エラーãŒç™ºç”Ÿã—ãŸå ´åˆã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ï¼ˆä¾‹: "Connection timed out" ãªã©ï¼‰', `is_success` tinyint(1) NOT NULL COMMENT '|æˆåŠŸãƒ•ãƒ©ã‚°| 巡回ãŒæˆåŠŸã—ãŸã‹ã©ã†ã‹ (True: æˆåŠŸã€€False: 失敗)', `is_chatwork_notified` tinyint(1) NOT NULL DEFAULT '0' COMMENT '|Chatwork通知済| Chatworkã«é€šçŸ¥ã•ã‚ŒãŸã‹ã©ã†ã‹', `retry_count` int unsigned NOT NULL DEFAULT '0' COMMENT '|å†è©¦è¡Œå›žæ•°| 今回ã®å·¡å›žãŒå‰å›žã®å¤±æ•—ã‹ã‚‰ã®ä½•å›žç›®ã®å†è©¦è¡Œã§ã‚ã‚‹ã‹', `response_time_ms` int unsigned DEFAULT NULL COMMENT '|å¿œç”時間(ms)| レスãƒãƒ³ã‚¹æ™‚間（ミリ秒', PRIMARY KEY (`id`), KEY `fk_website_id` (`website_id`), CONSTRAINT `fk_website_id` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='ãƒã‚°'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `website_checks` -- LOCK TABLES `website_checks` WRITE; /*!40000 ALTER TABLE `website_checks` DISABLE KEYS */; INSERT INTO `website_checks` VALUES (15,1,'2025-06-07 15:56:03',200,NULL,1,0,0,168),(16,2,'2025-06-07 15:56:05',404,'HTTPステータスコード: 404',0,0,0,1979),(17,2,'2025-06-07 16:02:04',404,'HTTPステータスコード: 404',0,1,1,1473),(18,2,'2025-06-07 16:08:04',404,'HTTPステータスコード: 404',0,1,2,1836),(19,2,'2025-06-07 16:14:04',404,'HTTPステータスコード: 404',0,1,3,1455),(20,2,'2025-06-07 16:20:04',404,'HTTPステータスコード: 404',0,1,4,1783),(21,2,'2025-06-07 16:26:04',404,'HTTPステータスコード: 404',0,1,5,1499),(22,2,'2025-06-07 16:32:04',404,'HTTPステータスコード: 404',0,1,6,1854),(23,2,'2025-06-07 16:38:04',404,'HTTPステータスコード: 404',0,1,7,1476),(24,2,'2025-06-07 16:44:04',404,'HTTPステータスコード: 404',0,1,8,1478),(25,2,'2025-06-07 16:50:04',404,'HTTPステータスコード: 404',0,1,9,1463),(26,2,'2025-06-07 16:56:05',404,'HTTPステータスコード: 404',0,1,10,1818),(27,1,'2025-06-07 16:57:03',200,NULL,1,0,0,168),(28,2,'2025-06-07 17:02:03',404,'HTTPステータスコード: 404',0,1,11,1456),(29,2,'2025-06-07 17:08:04',404,'HTTPステータスコード: 404',0,1,12,1768),(30,2,'2025-06-07 17:14:03',404,'HTTPステータスコード: 404',0,1,13,1439),(31,2,'2025-06-07 17:20:05',404,'HTTPステータスコード: 404',0,1,14,1882),(32,2,'2025-06-07 17:26:04',404,'HTTPステータスコード: 404',0,1,15,1418),(33,2,'2025-06-07 17:32:04',404,'HTTPステータスコード: 404',0,1,16,1866),(34,2,'2025-06-07 17:38:04',404,'HTTPステータスコード: 404',0,1,17,1470),(35,2,'2025-06-07 17:44:04',404,'HTTPステータスコード: 404',0,1,18,1912),(36,2,'2025-06-07 17:50:04',404,'HTTPステータスコード: 404',0,1,19,1424),(37,2,'2025-06-07 17:56:05',404,'HTTPステータスコード: 404',0,1,20,1801),(38,1,'2025-06-07 17:58:03',200,NULL,1,0,0,173),(39,2,'2025-06-07 18:02:04',404,'HTTPステータスコード: 404',0,1,21,1442),(40,2,'2025-06-07 18:08:04',404,'HTTPステータスコード: 404',0,1,22,1836),(41,2,'2025-06-07 18:14:04',404,'HTTPステータスコード: 404',0,1,23,1437),(42,2,'2025-06-07 18:20:05',404,'HTTPステータスコード: 404',0,1,24,1734),(43,2,'2025-06-07 18:26:04',404,'HTTPステータスコード: 404',0,1,25,1457),(44,2,'2025-06-07 18:32:05',404,'HTTPステータスコード: 404',0,1,26,1800),(45,2,'2025-06-07 18:38:04',404,'HTTPステータスコード: 404',0,1,27,1446),(46,2,'2025-06-07 18:44:04',404,'HTTPステータスコード: 404',0,1,28,1778),(47,2,'2025-06-07 18:50:04',404,'HTTPステータスコード: 404',0,1,29,1523),(48,2,'2025-06-07 18:56:05',404,'HTTPステータスコード: 404',0,1,30,1836),(49,1,'2025-06-07 18:59:02',200,NULL,1,0,0,100),(50,2,'2025-06-07 19:02:04',404,'HTTPステータスコード: 404',0,1,31,1551),(51,2,'2025-06-07 19:08:04',404,'HTTPステータスコード: 404',0,1,32,1836),(52,2,'2025-06-07 19:14:04',404,'HTTPステータスコード: 404',0,1,33,1457),(53,2,'2025-06-07 19:20:05',404,'HTTPステータスコード: 404',0,1,34,1819),(54,3,'2025-06-07 19:24:03',200,NULL,1,0,0,32),(55,2,'2025-06-07 19:26:04',404,'HTTPステータスコード: 404',0,1,35,1476),(56,2,'2025-06-07 19:32:05',404,'HTTPステータスコード: 404',0,1,36,1833),(57,2,'2025-06-07 19:38:03',200,NULL,1,0,37,431),(58,1,'2025-06-07 20:00:02',200,NULL,1,0,0,104),(59,1,'2025-06-07 21:00:03',200,NULL,1,0,0,107),(60,1,'2025-06-07 22:01:02',200,NULL,1,0,0,135),(61,1,'2025-06-07 23:01:03',200,NULL,1,0,0,118),(62,1,'2025-06-08 00:02:03',200,NULL,1,0,0,109),(63,1,'2025-06-08 01:03:02',200,NULL,1,0,0,104),(64,1,'2025-06-08 02:03:02',200,NULL,1,0,0,110),(65,1,'2025-06-08 03:03:02',200,NULL,1,0,0,103),(66,1,'2025-06-08 04:03:03',200,NULL,1,0,0,181),(67,1,'2025-06-08 05:04:02',200,NULL,1,0,0,97),(68,1,'2025-06-08 06:05:03',200,NULL,1,0,0,98),(69,1,'2025-06-08 07:06:02',200,NULL,1,0,0,101),(70,1,'2025-06-08 08:06:03',200,NULL,1,0,0,138),(71,1,'2025-06-08 09:07:03',200,NULL,1,0,0,111),(72,1,'2025-06-08 10:08:03',200,NULL,1,0,0,143),(73,1,'2025-06-08 11:09:02',200,NULL,1,0,0,113),(74,1,'2025-06-08 12:09:03',200,NULL,1,0,0,102),(75,1,'2025-06-08 13:10:02',200,NULL,1,0,0,213),(76,1,'2025-06-08 14:10:03',200,NULL,1,0,0,206),(77,1,'2025-06-08 15:11:03',200,NULL,1,0,0,173),(78,1,'2025-06-08 16:12:03',200,NULL,1,0,0,172),(79,1,'2025-06-08 17:13:03',200,NULL,1,0,0,175),(80,1,'2025-06-08 18:14:03',200,NULL,1,0,0,168),(81,1,'2025-06-08 19:15:03',200,NULL,1,0,0,111),(82,1,'2025-06-08 20:16:03',200,NULL,1,0,0,104),(83,1,'2025-06-08 21:17:03',200,NULL,1,0,0,98),(84,1,'2025-06-08 22:18:03',200,NULL,1,0,0,104),(85,1,'2025-06-08 23:19:02',200,NULL,1,0,0,111),(86,1,'2025-06-09 00:19:02',200,NULL,1,0,0,115),(87,1,'2025-06-09 01:20:02',200,NULL,1,0,0,103),(88,1,'2025-06-09 02:20:02',200,NULL,1,0,0,97),(89,1,'2025-06-09 03:20:03',200,NULL,1,0,0,97),(90,1,'2025-06-09 04:21:03',200,NULL,1,0,0,97),(91,1,'2025-06-09 05:22:03',200,NULL,1,0,0,95),(92,1,'2025-06-09 06:23:02',200,NULL,1,0,0,104),(93,1,'2025-06-09 07:23:02',200,NULL,1,0,0,103),(94,1,'2025-06-09 08:24:02',200,NULL,1,0,0,95),(95,1,'2025-06-09 09:24:03',200,NULL,1,0,0,117),(96,1,'2025-06-09 10:25:02',200,NULL,1,0,0,154),(97,1,'2025-06-09 11:25:03',200,NULL,1,0,0,119),(98,1,'2025-06-09 12:26:02',200,NULL,1,0,0,171),(99,1,'2025-06-09 13:26:03',200,NULL,1,0,0,188),(100,1,'2025-06-09 14:27:03',200,NULL,1,0,0,262),(101,1,'2025-06-09 15:28:03',200,NULL,1,0,0,194),(102,1,'2025-06-10 14:55:03',200,NULL,1,0,0,174),(103,1,'2025-06-10 15:56:02',200,NULL,1,0,0,169),(104,5,'2025-06-10 16:11:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7c23e3967d40>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(105,5,'2025-06-10 16:17:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x79df8d017ec0>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(106,2,'2025-06-10 16:52:02',200,NULL,1,0,0,38),(107,1,'2025-06-10 16:56:03',200,NULL,1,0,0,169),(108,1,'2025-06-10 17:57:03',200,NULL,1,0,0,164),(109,1,'2025-06-10 18:58:03',200,NULL,1,0,0,164),(110,1,'2025-06-10 19:59:03',200,NULL,1,0,0,164),(111,1,'2025-06-10 21:00:03',200,NULL,1,0,0,181),(112,1,'2025-06-10 22:01:02',200,NULL,1,0,0,99),(113,1,'2025-06-10 23:01:02',200,NULL,1,0,0,96),(114,1,'2025-06-11 00:01:03',200,NULL,1,0,0,146),(115,1,'2025-06-11 01:02:03',200,NULL,1,0,0,105),(116,1,'2025-06-11 02:03:02',200,NULL,1,0,0,102),(117,1,'2025-06-11 03:03:02',200,NULL,1,0,0,96),(118,1,'2025-06-11 04:03:03',200,NULL,1,0,0,99),(119,1,'2025-06-11 05:04:02',200,NULL,1,0,0,97),(120,1,'2025-06-11 06:04:02',200,NULL,1,0,0,92),(121,1,'2025-06-11 07:04:03',200,NULL,1,0,0,97),(122,1,'2025-06-11 08:05:02',200,NULL,1,0,0,100),(123,1,'2025-06-11 09:05:03',200,NULL,1,0,0,136),(124,1,'2025-06-11 10:06:03',200,NULL,1,0,0,129),(125,1,'2025-06-11 11:07:03',200,NULL,1,0,0,131),(126,1,'2025-06-11 12:08:03',200,NULL,1,0,0,297),(127,6,'2025-06-11 12:20:03',200,NULL,1,0,0,34),(128,1,'2025-06-11 13:09:03',200,NULL,1,0,0,196),(129,6,'2025-06-11 13:21:03',404,'HTTPステータスコード: 404',0,0,0,167),(130,6,'2025-06-11 13:27:03',404,'HTTPステータスコード: 404',0,1,1,620),(131,6,'2025-06-11 13:33:02',404,'HTTPステータスコード: 404',0,1,2,79),(132,6,'2025-06-11 13:39:03',404,'HTTPステータスコード: 404',0,1,3,190),(133,1,'2025-06-11 14:10:03',200,NULL,1,0,0,168),(134,5,'2025-06-11 14:38:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x70a56be63e90>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(135,5,'2025-06-11 14:44:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7c5b13963d70>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(136,1,'2025-06-11 15:11:02',200,NULL,1,0,0,172),(137,5,'2025-06-11 15:45:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x71789ba666f0>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(138,5,'2025-06-11 15:50:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7e5be4569d30>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(139,1,'2025-06-11 16:11:02',200,NULL,1,0,0,179),(140,5,'2025-06-11 16:51:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7cf445d62720>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(141,5,'2025-06-11 16:56:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x725299763f80>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(142,1,'2025-06-11 17:11:03',200,NULL,1,0,0,193),(143,1,'2025-06-11 18:12:02',200,NULL,1,0,0,172),(144,1,'2025-06-11 19:12:02',200,NULL,1,0,0,116),(145,1,'2025-06-11 20:12:03',200,NULL,1,0,0,108),(146,1,'2025-06-11 21:13:03',200,NULL,1,0,0,103),(147,1,'2025-06-11 22:14:03',200,NULL,1,0,0,103),(148,1,'2025-06-11 23:15:03',200,NULL,1,0,0,98),(149,1,'2025-06-12 00:16:03',200,NULL,1,0,0,106),(150,1,'2025-06-12 01:17:02',200,NULL,1,0,0,104),(151,1,'2025-06-12 02:17:03',200,NULL,1,0,0,151),(152,1,'2025-06-12 03:18:03',200,NULL,1,0,0,132),(153,1,'2025-06-12 04:19:02',200,NULL,1,0,0,145),(154,1,'2025-06-12 05:19:03',200,NULL,1,0,0,97),(155,1,'2025-06-12 06:20:03',200,NULL,1,0,0,97),(156,1,'2025-06-12 07:21:02',200,NULL,1,0,0,122),(157,1,'2025-06-12 08:21:03',200,NULL,1,0,0,108),(158,1,'2025-06-12 09:22:03',200,NULL,1,0,0,99),(159,1,'2025-06-12 10:23:03',200,NULL,1,0,0,99),(160,6,'2025-06-12 10:41:03',404,'HTTPステータスコード: 404',0,0,0,203),(161,6,'2025-06-12 10:47:03',404,'HTTPステータスコード: 404',0,1,1,386),(162,1,'2025-06-12 11:24:03',200,NULL,1,0,0,439),(163,6,'2025-06-12 11:48:03',404,'HTTPステータスコード: 404',0,0,0,390),(164,6,'2025-06-12 11:54:03',404,'HTTPステータスコード: 404',0,1,1,80),(165,1,'2025-06-12 12:25:03',200,NULL,1,0,0,175),(166,6,'2025-06-12 12:55:03',404,'HTTPステータスコード: 404',0,0,0,531),(167,6,'2025-06-12 13:01:02',404,'HTTPステータスコード: 404',0,1,1,163),(168,1,'2025-06-12 13:26:02',200,NULL,1,0,0,166),(169,1,'2025-06-12 14:26:03',200,NULL,1,0,0,171),(170,1,'2025-06-12 15:27:03',200,NULL,1,0,0,285),(171,1,'2025-06-12 16:28:03',200,NULL,1,0,0,171),(172,7,'2025-06-12 16:47:03',200,NULL,1,0,0,171),(173,8,'2025-06-12 16:47:05',404,'HTTPステータスコード: 404',0,0,0,2241),(174,8,'2025-06-12 16:53:04',404,'HTTPステータスコード: 404',0,1,1,1381),(175,9,'2025-06-12 17:16:03',200,NULL,1,0,0,168),(176,10,'2025-06-12 17:16:04',404,'HTTPステータスコード: 404',0,0,0,1823),(177,10,'2025-06-12 17:22:05',404,'HTTPステータスコード: 404',0,1,1,1775),(178,1,'2025-06-12 17:29:03',200,NULL,1,0,0,175),(179,11,'2025-06-12 17:35:03',200,NULL,1,0,0,180),(180,12,'2025-06-12 17:35:04',404,'HTTPステータスコード: 404',0,0,0,1778),(181,12,'2025-06-12 17:41:05',404,'HTTPステータスコード: 404',0,1,1,1809),(182,7,'2025-06-12 17:48:02',200,NULL,1,0,0,191),(183,8,'2025-06-12 17:54:04',404,'HTTPステータスコード: 404',0,0,0,1861),(184,8,'2025-06-12 18:00:04',404,'HTTPステータスコード: 404',0,1,1,1497),(185,9,'2025-06-12 18:17:03',200,NULL,1,0,0,167),(186,10,'2025-06-12 18:23:04',404,'HTTPステータスコード: 404',0,0,0,1838),(187,10,'2025-06-12 18:29:04',404,'HTTPステータスコード: 404',0,1,1,1419),(188,1,'2025-06-12 18:30:02',200,NULL,1,0,0,191),(189,11,'2025-06-12 18:36:03',200,NULL,1,0,0,171),(190,13,'2025-06-12 18:37:29',200,NULL,1,0,0,166),(191,14,'2025-06-12 18:37:29',404,'HTTPステータスコード: 404',0,0,0,1815),(192,12,'2025-06-12 18:42:04',404,'HTTPステータスコード: 404',0,0,0,1365),(193,14,'2025-06-12 18:43:04',404,'HTTPステータスコード: 404',0,1,1,1413),(194,7,'2025-06-12 18:48:02',200,NULL,1,0,0,161),(195,12,'2025-06-12 18:48:04',404,'HTTPステータスコード: 404',0,1,1,1819),(196,8,'2025-06-12 19:01:04',404,'HTTPステータスコード: 404',0,0,0,1832),(197,15,'2025-06-12 19:03:35',200,NULL,1,0,0,172),(198,16,'2025-06-12 19:03:35',404,'HTTPステータスコード: 404',0,0,0,1384),(199,8,'2025-06-12 19:07:04',404,'HTTPステータスコード: 404',0,1,1,1389),(200,16,'2025-06-12 19:09:04',404,'HTTPステータスコード: 404',0,1,1,1380),(201,17,'2025-06-12 19:09:13',200,NULL,1,0,0,167),(202,18,'2025-06-12 19:09:13',404,'HTTPステータスコード: 404',0,0,0,31),(203,19,'2025-06-12 19:10:16',200,NULL,1,0,0,169),(204,20,'2025-06-12 19:10:16',404,'HTTPステータスコード: 404',0,0,0,1416),(205,21,'2025-06-12 19:11:54',200,NULL,1,0,0,162),(206,22,'2025-06-12 19:11:55',404,'HTTPステータスコード: 404',0,0,0,1142),(207,18,'2025-06-12 19:15:04',404,'HTTPステータスコード: 404',0,1,1,1457),(208,20,'2025-06-12 19:16:04',404,'HTTPステータスコード: 404',0,1,1,1113),(209,22,'2025-06-12 19:17:05',404,'HTTPステータスコード: 404',0,1,1,1440),(210,9,'2025-06-12 19:18:03',200,NULL,1,0,0,118),(211,23,'2025-06-12 19:19:29',200,NULL,1,0,0,86),(212,24,'2025-06-12 19:19:29',404,'HTTPステータスコード: 404',0,0,0,1389),(213,24,'2025-06-12 19:25:04',404,'HTTPステータスコード: 404',0,1,1,1409),(214,1,'2025-06-15 13:23:02',200,NULL,1,0,0,166),(215,14,'2025-06-15 13:23:02',404,'HTTPステータスコード: 404',0,0,0,1879),(216,14,'2025-06-15 13:29:01',404,'HTTPステータスコード: 404',0,1,1,1431),(217,1,'2025-06-15 14:24:01',200,NULL,1,0,0,184),(218,14,'2025-06-15 14:29:01',404,'HTTPステータスコード: 404',0,0,0,1839),(219,14,'2025-06-15 14:34:01',404,'HTTPステータスコード: 404',0,1,1,1418),(220,1,'2025-06-15 15:24:01',200,NULL,1,0,0,222),(221,14,'2025-06-15 15:34:01',404,'HTTPステータスコード: 404',0,0,0,1908),(222,14,'2025-06-15 15:39:02',404,'HTTPステータスコード: 404',0,1,1,1476),(223,1,'2025-06-15 16:24:02',200,NULL,1,0,0,176),(224,14,'2025-06-15 16:39:02',404,'HTTPステータスコード: 404',0,0,0,1808),(225,14,'2025-06-15 16:45:01',404,'HTTPステータスコード: 404',0,1,1,1401),(226,1,'2025-06-15 17:25:01',200,NULL,1,0,0,181),(227,1,'2025-06-15 18:25:01',200,NULL,1,0,0,175),(228,1,'2025-06-15 19:25:01',200,NULL,1,0,0,173),(229,1,'2025-06-15 20:25:01',200,NULL,1,0,0,98),(230,1,'2025-06-15 21:25:01',200,NULL,1,0,0,179),(231,1,'2025-06-15 22:25:01',200,NULL,1,0,0,104),(232,1,'2025-06-15 23:25:01',200,NULL,1,0,0,165),(233,1,'2025-06-16 00:25:02',200,NULL,1,0,0,134),(234,1,'2025-06-16 01:26:01',200,NULL,1,0,0,140),(235,1,'2025-06-16 02:26:01',200,NULL,1,0,0,99),(236,1,'2025-06-16 03:26:01',200,NULL,1,0,0,101),(237,1,'2025-06-16 04:26:01',200,NULL,1,0,0,102),(238,1,'2025-06-16 05:26:01',200,NULL,1,0,0,137),(239,1,'2025-06-16 06:26:01',200,NULL,1,0,0,104),(240,1,'2025-06-16 07:26:02',200,NULL,1,0,0,99),(241,1,'2025-06-16 08:27:02',200,NULL,1,0,0,135),(242,1,'2025-06-16 09:27:02',200,NULL,1,0,0,105),(243,6,'2025-06-16 10:19:01',200,NULL,1,0,0,233),(244,1,'2025-06-16 10:28:01',200,NULL,1,0,0,137),(245,6,'2025-06-16 11:19:01',404,'HTTPステータスコード: 404',0,0,0,101),(246,1,'2025-06-16 11:28:01',200,NULL,1,0,0,281),(247,6,'2025-06-16 11:52:01',404,'HTTPステータスコード: 404',0,1,1,107),(248,1,'2025-06-16 12:28:01',200,NULL,1,0,0,172),(249,6,'2025-06-16 12:52:01',404,'HTTPステータスコード: 404',0,0,0,163),(250,6,'2025-06-16 12:57:01',404,'HTTPステータスコード: 404',0,1,1,78),(251,1,'2025-06-16 13:28:02',200,NULL,1,0,0,211),(252,6,'2025-06-16 13:57:02',200,NULL,1,0,0,1159),(253,1,'2025-06-16 14:29:01',200,NULL,1,0,0,196),(254,6,'2025-06-16 14:58:01',200,NULL,1,0,0,454); /*!40000 ALTER TABLE `website_checks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `websites` -- DROP TABLE IF EXISTS `websites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `websites` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL COMMENT '|ユーザーID| ã“ã®ãƒ›ãƒ¼ãƒ ページを登録ã—ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ID', `url` varchar(2048) NOT NULL COMMENT '|URL| 巡回対象ã®ãƒ›ãƒ¼ãƒ ページã®URL', `name` varchar(255) NOT NULL COMMENT '|åå‰| ホームページã®è˜åˆ¥å（例: "å…¬å¼Webサイト"', `check_interval_minutes` int unsigned NOT NULL DEFAULT '60' COMMENT '|巡回間隔(分)| 通常ã®å·¡å›žé–“隔（分）。åˆæœŸå€¤ã¯60分（1時間）。', `retry_interval_minutes` int unsigned NOT NULL DEFAULT '5' COMMENT '|å†è©¦è¡Œé–“éš”(分)| エラー時ã®å†è©¦è¡Œé–“隔（分）。åˆæœŸå€¤ã¯5分。', `max_retry_attempts` int unsigned NOT NULL DEFAULT '1' COMMENT '|最大å†è©¦è¡Œå›žæ•°| Chatwork通知ã¾ã§ã®æœ€å¤§å†è©¦è¡Œå›žæ•°ã€‚1回エラーã§å³é€šçŸ¥ãªã‚‰0', `is_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT '|アクティブ| 巡回をアクティブã«ã™ã‚‹ã‹ã©ã†ã‹ï¼ˆTrue: アクティブ', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '|作æˆæ—¥æ™‚| レコード作æˆæ—¥æ™‚', `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '|更新日時| レコード最終更新日時', PRIMARY KEY (`id`), KEY `fk_user_id` (`user_id`), CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='Webサイト'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `websites` -- LOCK TABLES `websites` WRITE; /*!40000 ALTER TABLE `websites` DISABLE KEYS */; INSERT INTO `websites` VALUES (1,1,'https://www.google.com','Google Search',60,5,1,1,'2025-06-06 11:05:34','2025-06-06 11:05:34'),(2,1,'https://www.example.com/','Non-existent Page',60,5,1,0,'2025-06-06 11:05:34','2025-06-10 07:52:49'),(3,1,'https://x162-43-39-30.static.xvps.ne.jp/','test-site',60,5,1,0,'2025-06-07 10:23:33','2025-06-07 10:48:44'),(5,1,'http://test.site.com','test',60,5,1,0,'2025-06-10 07:10:59','2025-06-11 08:03:30'),(6,8,'https://kaitorione.jp/','yahoo',60,5,1,1,'2025-06-11 03:19:22','2025-06-16 04:40:50'),(7,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 07:46:07','2025-06-12 10:28:09'),(8,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 07:46:07','2025-06-12 10:28:15'),(9,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 08:15:49','2025-06-12 10:28:21'),(10,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 08:15:49','2025-06-12 10:28:28'),(11,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 08:34:23','2025-06-12 10:28:34'),(12,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 08:34:23','2025-06-12 10:28:40'),(13,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 09:37:29','2025-06-12 10:28:45'),(14,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 09:37:29','2025-06-15 08:34:04'),(15,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:03:35','2025-06-12 10:28:58'),(16,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:03:35','2025-06-12 10:29:03'),(17,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:09:13','2025-06-12 10:29:08'),(18,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:09:13','2025-06-12 10:29:13'),(19,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:10:16','2025-06-12 10:29:19'),(20,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:10:16','2025-06-12 10:29:25'),(21,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:11:54','2025-06-12 10:29:30'),(22,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:11:54','2025-06-12 10:29:35'),(23,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:19:29','2025-06-12 10:29:39'),(24,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:19:29','2025-06-12 10:29:43'); /*!40000 ALTER TABLE `websites` 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 2025-06-16 6:20:01