-- MySQL dump 10.13  Distrib 8.0.42, for Win64 (x86_64)
--
-- Host: 13.124.190.96    Database: serverDB_JI
-- ------------------------------------------------------
-- 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 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 `game_data_file_info`
--

DROP TABLE IF EXISTS `game_data_file_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `game_data_file_info` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `game_data_url` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `game_data_checksum` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `uploaded_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`),
  KEY `version` (`version`) /*!80000 INVISIBLE */,
  KEY `version_createTime` (`version` DESC,`create_time` DESC)
) ENGINE=InnoDB AUTO_INCREMENT=4283 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `game_data_file_info`
--

LOCK TABLES `game_data_file_info` WRITE;
/*!40000 ALTER TABLE `game_data_file_info` DISABLE KEYS */;
INSERT INTO `game_data_file_info` VALUES (4178,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/bc7nBtAddwl0fjb0Y9IUtdvKPKkAirLSzp1PJXwZ97zhj1wq1w','ea6ce1bd-ab2c-11f0-9fb9-02f6df36a903','2025-10-17 16:43:05','chang'),(4179,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/2QCfqLm1jXeU774cwDoA2z2eWxZDlWXrhI8p1PFqT3IMbNnI7k','81880f1e-ab2d-11f0-9fb9-02f6df36a903','2025-10-17 16:47:18','cho'),(4180,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/GrCuxaC1ca0cOCVimGtoBMKcVOQpw9JeZ2vog9wjqmUZPIrY1v','1b90a3bd-ad54-11f0-9fb9-02f6df36a903','2025-10-20 10:28:40','chang'),(4181,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/UMORBSjduMfM6ahbhSqEF1Y8i1Om8MalZH5m70OiR3VLsimd5G','76f9ad16-ad58-11f0-9fb9-02f6df36a903','2025-10-20 10:59:51','chang'),(4182,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/otzH21K2ylFz6NmI6eE9wf2F6N8ykr3P7fwUFMwtASKsTrmvKJ','6c3eaf1a-add6-11f0-9fb9-02f6df36a903','2025-10-21 02:01:30','cho'),(4183,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/W6A1ijk9zOW0OMFd4UE6mMXWmzKplmJdAP8QRDgMuRIilFT1P3','6bb36f30-ae1c-11f0-9fb9-02f6df36a903','2025-10-21 10:22:33','chang'),(4184,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/kf21abIqVJSs3fA9tRg7VqW4XLVNUsHViYEHEi3pTMsa8hig5N','fd7cf3e4-ae1e-11f0-9fb9-02f6df36a903','2025-10-21 10:40:57','chang'),(4185,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/YUi3VwarPzmN6bgSRHWcWf3A9W1smdAXRRc0DSdHTholyI4r0P','788d1976-ae25-11f0-9fb9-02f6df36a903','2025-10-21 11:27:21','chang'),(4186,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/nd4mba1s1u0BJ2tMJ0p3ArMhCKbIkpZb8RLiALrIAzhy0vJBZa','76435f0f-ae29-11f0-9fb9-02f6df36a903','2025-10-21 11:55:55','chang'),(4187,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/TRmhdozmCOtzQuyxr0r7LS3qUaMRVA9FKuD5zU1rP3i3uDVcY9','c2f49f21-ae38-11f0-bffb-02f6df36a903','2025-10-21 13:45:26','cho'),(4188,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/stGTUAWkwseVqcK3BhThm15oCEiTTWZS546csw2Pl3Wy1JWlnb','3f2e255a-ae39-11f0-bffb-02f6df36a903','2025-10-21 13:48:54','chang'),(4189,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/Om43sevc7KZTAe2meGkTwHIWGzPwByAjMbOfJIjsuVvHMEkpZK','635be493-aee8-11f0-bffb-02f6df36a903','2025-10-22 10:42:37','chang'),(4190,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/sWt5eqZL04nsV52z0lTkdWRWQgZakLYFcNw9IKSwIYlhilztjF','53a4bd9c-af07-11f0-bffb-02f6df36a903','2025-10-22 14:24:05','cho'),(4191,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/QsoiCIca9wA4F4d8AYu9HKQAH7nsbRZ30m8VuaLzcXE0iOYe4V','7aa0030a-af0e-11f0-bffb-02f6df36a903','2025-10-22 15:15:17','cho'),(4192,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/vN2iBdmhcudmdgIbwK81OlbCqYn9S8FlMshrNtNWJkx2uCWphH','2a55c25f-afb7-11f0-bffb-02f6df36a903','2025-10-23 11:22:47','chang'),(4193,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/bYQCRKsObgtZgtnh0QVtblzfsuEo65bdxpOLCo4PHONK0mubBz','ba33ab3c-afe1-11f0-bffb-02f6df36a903','2025-10-23 16:27:27','cho'),(4194,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/ifdsLRFxcAttzAFhYuswndb0m6tFxpJvJWUaFgmTBIKm83SXqk','342d5b56-aff5-11f0-bffb-02f6df36a903','2025-10-23 18:46:52','chang'),(4195,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/ESbogjKonwNPbzICCmT1lNmP1cMDwoosQHpcsV361Ia7f89rxX','113ed7df-aff6-11f0-bffb-02f6df36a903','2025-10-23 18:53:03','chang'),(4196,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/vrJjubxZuqbyZNqQvxO6ZdUB66P6Syc2TUfin0H6IvfCwwNjky','3a0ba376-b02d-11f0-bffb-02f6df36a903','2025-10-24 01:27:54','cho'),(4197,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/XmT4BygDfCTAwYdCLUwRLM9yAfMaotcXLwbNIG90sPhbp3kPYl','9f0365f2-b02d-11f0-bffb-02f6df36a903','2025-10-24 01:30:43','cho'),(4198,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/5kffRStnXjRLUQIDzLHbuHz9ifCpt3U67SQSVQq80f0phZsd5g','ef48815c-b02d-11f0-bffb-02f6df36a903','2025-10-24 01:32:58','cho'),(4199,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/dRdYqikOUam1PLs5zME31CPUJrrMC39i33a5d36prFI0PKj5dB','02ae2fa9-b02e-11f0-bffb-02f6df36a903','2025-10-24 01:33:30','cho'),(4200,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/iSgo0wllawl96RJsm4dMkq73Tw2FHX6eLHp4HIyVq9TjsLr8yU','49bfb4e9-b079-11f0-bffb-02f6df36a903','2025-10-24 10:32:22','chang'),(4201,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/fOqPrwCYym3v0QJvp8MI5cQ7ed7T934X20ZdlrXJ2ieswo3akS','0bcbd0da-b090-11f0-bffb-02f6df36a903','2025-10-24 13:15:17','cho'),(4202,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/YjDX7ef3IEF8o0fO2rG9IhYowclaURfFRu7L9VVPjR92F5fAyc','37efaeb4-b090-11f0-bffb-02f6df36a903','2025-10-24 13:16:31','cho'),(4203,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/aBtoHQtBbiA1OlQKR9ocSwWg55AxQhQhJw4kbOjfXYYPOwXuOD','feeed2c3-b090-11f0-bffb-02f6df36a903','2025-10-24 13:22:04','cho'),(4204,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/sD8RfJwCWB7c0jLpsOJA34XywWn0giBxGcSnanxrxCu04ioyCR','94473159-b092-11f0-bffb-02f6df36a903','2025-10-24 13:33:24','cho'),(4205,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/Ifeo5jmUlTM5qzC3itSH2UkmimwAvNv6SpO7fd07FK58vJJP5d','cf657c93-b092-11f0-bffb-02f6df36a903','2025-10-24 13:35:04','cho'),(4206,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/JfzwoDDWwdYI7Yjbn2pFXHKT7amxr4VmpxXz6ED0H0rMq1HG0D','99f40f7a-b095-11f0-bffb-02f6df36a903','2025-10-24 13:55:02','cho'),(4207,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/0KTfwod5JuBaHBAbBG4l5WDaL9R72ypVSsBeyWHPEqm06Hninn','6c53338f-b099-11f0-bffb-02f6df36a903','2025-10-24 14:22:24','cho'),(4208,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/mdpPXArjcW6reelZXGQlCf8clwZaFh4A2pbsJ55SGcgYFsAHcU','4f54c5e8-b09a-11f0-bffb-02f6df36a903','2025-10-24 14:28:45','cho'),(4209,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/MXdm4e3PCueFQYMWIr29jv4o8fSgWVWtPExrn4sE6JcEQllR3C','ca96a594-b09f-11f0-bffb-02f6df36a903','2025-10-24 15:07:59','cho'),(4210,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/mCmow3y87ZUDwUi4fdCBYoHYJiAbrmWbOPMbxWcnEPLYn2YRYa','f8a70b6e-b09f-11f0-bffb-02f6df36a903','2025-10-24 15:09:16','cho'),(4211,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/W6qU2virTGZYZjd2qG5B1LlYDzTTDQy7AJcV8f1KDyv6k8JFAn','85645fdf-b0a0-11f0-bffb-02f6df36a903','2025-10-24 15:13:12','cho'),(4212,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/sx2ml9lkWBoa45q7CoTOArhhkJXAWx688B3AuwSrcyu3496Jj0','779ee0d4-b0a4-11f0-bffb-02f6df36a903','2025-10-24 15:41:27','cho'),(4213,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/VljFFl4dlkSRjgNayVJWsoDouKdRsYhm3Mxr64icDquU4Mlk5r','10a0b074-b0a5-11f0-bffb-02f6df36a903','2025-10-24 15:45:44','cho'),(4214,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/SAbKAILhWAZJSBKwwybMH35t5kWmpVayqiNx4JNbWDiXTAfnNi','d4f10cd0-b0a5-11f0-bffb-02f6df36a903','2025-10-24 15:51:13','cho'),(4215,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/M3c9zaYXfgBh6KDb3HJqLl2u5nfORBVbyK6gOnnsVgQRJONL8a','c5cd0d10-b0a8-11f0-bffb-02f6df36a903','2025-10-24 16:12:16','cho'),(4216,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/WVnI2U4ZZTUlCg60n4LMVqI2iPAt5RwqRwbF8gna8x3NdxPzsV','41aeb7a9-b0a9-11f0-bffb-02f6df36a903','2025-10-24 16:15:44','cho'),(4217,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/LBNLrqlzKNzHDvPFXLkhLXJuvr4qoZWDFTYOwIakzG4elI09VX','60caefe1-b0b0-11f0-bffb-02f6df36a903','2025-10-24 17:06:43','cho'),(4218,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/kWhyqEp62QpS31ELhpPo0Mu7HkX7Bnc9lZJo0iF5YHbGS5x994','36148b5c-b0bb-11f0-bffb-02f6df36a903','2025-10-24 18:24:16','cho'),(4219,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/STd9dfQbzvoTfZpWlcJZ2h7VQgTzwbMizEP60Hegb5W9gBDOS0','e8a96974-b0c4-11f0-bffb-02f6df36a903','2025-10-24 19:33:41','cho'),(4220,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/x7wapnrqbNY1dwLkR0VVI1j4qDdY75ybMvwbTGSW3oPT1lMhyO','2afb079d-b0c7-11f0-bffb-02f6df36a903','2025-10-24 19:49:51','cho'),(4221,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/ybV6xt82zWfrhBwhabkFyJaCjq6cpd9xVT3x1UcHYMQH6JQzNv','957c68de-b0c7-11f0-bffb-02f6df36a903','2025-10-24 19:52:50','cho'),(4222,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/euOjdteuxyaMY6rN1riDCLQS9QFH6y0tgRgfIN7q001HHPayW7','75615be9-b0fc-11f0-bffb-02f6df36a903','2025-10-25 02:11:19','chang'),(4223,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/bTTG8yQ87jDLFJ39joKN7cqEQrX90smpH67eZnqS5bP5eMrdT5','e4b56b6c-b17c-11f0-bffb-02f6df36a903','2025-10-25 17:30:42','cho'),(4224,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/Vlx6kESXdA4dgihslMrjM38ikS2qeHBwR6cVLyxqwTyjIDOcon','ee763697-b183-11f0-bffb-02f6df36a903','2025-10-25 18:21:05','cho'),(4225,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/lIS6smJ3AyF1hWPshfNVFrwSMHfsXONYhDf7WLIxv0eE4nPRaY','1c3c087d-b185-11f0-bffb-02f6df36a903','2025-10-25 18:29:31','cho'),(4226,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/Gjddr3fv97XkNqorg3tUmWPp2rseUVtji1hDErHD2mkbBFKVUv','75be220b-b18f-11f0-bffb-02f6df36a903','2025-10-25 19:43:36','cho'),(4227,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/AbXJB9eitudxZgFQPq7S4h2juWTulu9h8bORdO9bUWh33BYLlW','473e7cea-b192-11f0-bffb-02f6df36a903','2025-10-25 20:03:46','cho'),(4228,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/FqXv5Dd1xqCAj0V3xdhhwK0eUmXrOTyDH4WNU9P6TlfaE8HI0N','6bddf0c0-b197-11f0-bffb-02f6df36a903','2025-10-25 20:40:35','cho'),(4229,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/ApC6tScLBTWG82mXQgG6ESrseUbflHrbpxCImsqqlsML8eqfwZ','4358424d-b198-11f0-bffb-02f6df36a903','2025-10-25 20:46:37','cho'),(4230,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/u9CN0bdFraPkSWctBJv95nHV3atVsehFLOwdTJ1Orwzo84UbHd','58c617c8-b198-11f0-bffb-02f6df36a903','2025-10-25 20:47:13','cho'),(4231,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/gMWn4HA2NWCwYwTCph2xy5hPTxQweKj7EZ5rG1drmerFYllWtE','7aa801c9-b1a3-11f0-bffb-02f6df36a903','2025-10-25 22:06:54','cho'),(4232,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/2vUicWfd67KpW5qN8CZLeqqJfgS0lpuCTVHXObLyYyF9aEEVtV','8f49c993-b1a3-11f0-bffb-02f6df36a903','2025-10-25 22:07:29','cho'),(4233,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/ymDzrT8VeQiwMYrIchHAivL8UtQrydNBqEJ01PKrj9gM4REY3W','e61c6c0c-b1a3-11f0-bffb-02f6df36a903','2025-10-25 22:09:54','cho'),(4234,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/PxRZDOxdmmO11p0pGLuqUZhdyJTMVNi1imagoU4AnnU8xfRY4M','061bb2d4-b1a9-11f0-bffb-02f6df36a903','2025-10-25 22:46:36','cho'),(4235,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/s1J8hLLBeI1mVPVtFxzkcPUv4v8hT1ABBGY93ibMBDGvhZVOpS','06a16f48-b1b5-11f0-bffb-02f6df36a903','2025-10-26 00:12:30','cho'),(4236,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/aTvCBMCpy1CPbxRPPyVxpcswZ8hCoKNcLEvAqfO74UdnL8qq6q','839545b3-b1b7-11f0-bffb-02f6df36a903','2025-10-26 00:30:19','cho'),(4237,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/cjwcFTTQRf8bSx60Rzp9F2mXE0uauLDZiMpQkBjcPWZa6PBGlt','fe34f4b1-b1b7-11f0-bffb-02f6df36a903','2025-10-26 00:33:45','chang'),(4238,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/4jed86HOKt0G66Nu0P35VLCu1eDwCF51V3bjrclfrVJzDgsnWE','ae467120-b1ba-11f0-bffb-02f6df36a903','2025-10-26 00:52:59','cho'),(4239,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/02ReJShqpuZoOP09Z0sabGoNOCfMtb7ibGcKF0iJVFurji0XJK','a17e4811-b1bb-11f0-bffb-02f6df36a903','2025-10-26 00:59:47','cho'),(4240,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/0oixvT2fiAgy6dAM00vZw6SLY2BFGAfSYKpjGdav9F6G59qChn','198099e0-b233-11f0-bffb-02f6df36a903','2025-10-26 15:14:59','cho'),(4241,'0.9.8','https://dk09qqd9w46ur.cloudfront.net/TestServer/cugqre4XXHrJJfOLmEM5szHSJyGlWk1GUsHmnnN0mLtKg8JozZ','9ccda14e-b2d5-11f0-bc95-02f6df36a903','2025-10-27 10:38:18','cho'),(4242,'0.9.9','https://dk09qqd9w46ur.cloudfront.net/TestServer/NMxtIrklzGofr1T2HxzpLWEZ5rlLBZHPHpr649YagSLNS7IwaJ','d44874aa-b2dc-11f0-984f-02f6df36a903','2025-10-27 11:29:57','cho'),(4243,'0.9.9','https://dk09qqd9w46ur.cloudfront.net/TestServer/UZNCTattQ8i2pH4JRrNIwgLIhBsrh6vnGYlyXiyYnWXFnToKFY','4c0d7b03-b2de-11f0-984f-02f6df36a903','2025-10-27 11:40:27','chang'),(4244,'0.9.9','https://dk09qqd9w46ur.cloudfront.net/TestServer/mD4em3PiZL01eiafL26jdPljpaPcZrkjgq0DjcftROWDPAT2im','d266b87f-b2f8-11f0-984f-02f6df36a903','2025-10-27 14:50:20','cho'),(4245,'0.9.9','https://dk09qqd9w46ur.cloudfront.net/TestServer/LrHmTfXCm5DYL1pS99UYeSZpbdmWKJklWZlOLPvmQVBA6xXhOn','37561c22-b30d-11f0-984f-02f6df36a903','2025-10-27 17:16:19','cho'),(4246,'0.9.9','https://dk09qqd9w46ur.cloudfront.net/TestServer/UI5M45IanvItRvBzXvJVCRSf2C4f1PQ2kbTX3f7ql3RFNHmGRX','bafe6098-b30d-11f0-984f-02f6df36a903','2025-10-27 17:20:00','cho'),(4247,'0.9.9','https://dk09qqd9w46ur.cloudfront.net/TestServer/V4Wz3i9T5gLEhYdDx6tJWI1B777jQHxEUrc1bOZjoKCizQ15TH','f9920e03-b313-11f0-984f-02f6df36a903','2025-10-27 18:04:42','jang'),(4248,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/PxJlMQ1vpAG5jpaPuOMlW2S0CJTQIH7JvfyAYfV6Z7302WGSxW','565585bf-b39f-11f0-984f-02f6df36a903','2025-10-28 10:42:17','cho'),(4249,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/tdfVsSqRFlQKgxtUJYzi599qYVy7PSRYDb7FM0Vd75EEH5b3h0','bc174b9d-b3bb-11f0-984f-02f6df36a903','2025-10-28 14:05:34','jang'),(4250,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/536GCAAPROkgf3aKU6VqTMxMZ1LLtmEShs4SZ55VtYS4luIhdi','4d2b7fc0-b3be-11f0-984f-02f6df36a903','2025-10-28 14:23:57','cho'),(4251,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/o3r3ZGXjiZs0si7Xp349Zj7Ygvjb5NWprLcxRa42xSf0LI5Hhp','dedaf79b-b3be-11f0-984f-02f6df36a903','2025-10-28 14:28:01','jang'),(4252,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/aqGCsklqOcKZRQDylJ2f7tzTShG6ZsJ0S6uudWxg9tjudkuBVM','587c8282-b3bf-11f0-984f-02f6df36a903','2025-10-28 14:31:25','jang'),(4253,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/mE9cRvEZPCnkxEnySSnGzauhI4yv8loq5uZLB0Zw5HnYUn50lQ','46f392b2-b3c1-11f0-984f-02f6df36a903','2025-10-28 14:45:15','jang'),(4254,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/SH55OAwi8LIDzCJ0q3QTZVzkcIjvoOLBnfKRr0BR7GsuyqITYB','68532b25-b3c1-11f0-984f-02f6df36a903','2025-10-28 14:46:11','cho'),(4255,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/CMRhKH6qVos1Zb3UdFVdxaglJJEFQKYQMGWVp1uwuilWynQRG0','ae311ab1-b3c3-11f0-984f-02f6df36a903','2025-10-28 15:02:27','jang'),(4256,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/bR7Itaz9kOpzhFEeUXSybTrJz7aoP8R4FE1RsZR30U6E1Cl91m','f12459e7-b3c4-11f0-984f-02f6df36a903','2025-10-28 15:11:29','jang'),(4257,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/vyiLjzvpbethXonJVwHJW07jTlNiJYkVKEgCRyuoBnTn3LTC3H','39cd0871-b3c5-11f0-984f-02f6df36a903','2025-10-28 15:13:30','jang'),(4258,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/6qrhv7aloli7uTHsCLMDavAzrbX76Yiu5u1eTj54VOFpFRFcLu','020ad48d-b3c8-11f0-984f-02f6df36a903','2025-10-28 15:33:25','jang'),(4259,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/laMqQ4ndtR1QA58vfnlixydE2KP9cs97LfYZJdXjbzPmU53XJf','e0ce8bbe-b3ca-11f0-984f-02f6df36a903','2025-10-28 15:53:58','jang'),(4260,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/WGr9vKvhf9IgMva7YrhW1pQOCOvVhpB0Y69Vc1LBb4fgKbNcac','0a447fdf-b3cc-11f0-984f-02f6df36a903','2025-10-28 16:02:17','jang'),(4261,'0.9.11','https://dk09qqd9w46ur.cloudfront.net/TestServer/PFMSAiZ7Ska309RL8y8hrvnsiiLqXL3KBIt4icFp2WsOFE0yYv','93a6f4c8-b3cd-11f0-984f-02f6df36a903','2025-10-28 16:13:17','jang'),(4262,'0.9.11','https://dk09qqd9w46ur.cloudfront.net/TestServer/igU8YDoirU0eQWV8NaL0DkW0mnF0Ym5anVrGcDgY8la9CGypDj','d7fdcd4a-b3cf-11f0-984f-02f6df36a903','2025-10-28 16:29:31','jang'),(4263,'0.9.11','https://dk09qqd9w46ur.cloudfront.net/TestServer/dNbtQiel0z95iumlb0LwDxpxPoBZkFS8r1b9lX774YDvk9FtqY','4c614c99-b3df-11f0-984f-02f6df36a903','2025-10-28 18:20:09','jang'),(4264,'0.9.11','https://dk09qqd9w46ur.cloudfront.net/TestServer/xqhL4sgBoH21sGn2fyqrEU1D1uEvIfr0T93a6VNlb4CQw6LIVs','a3bebfbc-b3df-11f0-984f-02f6df36a903','2025-10-28 18:22:35','jang'),(4265,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/8soPga6A5oxfA77vGl0PrOdWDXHUTDryhSmEYAqe3IYZUwhGxG','9702b2c7-b3e9-11f0-984f-02f6df36a903','2025-10-28 19:33:49','jang'),(4266,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/BkqvVqBBSkacAli8IQrKKM5Xv5T7UNkwELXCUIuU6gmD8PdOnM','5eae66ca-b3ea-11f0-984f-02f6df36a903','2025-10-28 19:39:24','jang'),(4267,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/0k2ZMSOgZiOeVCrxTIJjMup7OguwAAm3kCrJ6IB9RhAKHfEGUz','cc1d53ad-b46f-11f0-984f-02f6df36a903','2025-10-29 11:34:30','jang'),(4268,'0.9.10','https://dk09qqd9w46ur.cloudfront.net/TestServer/43YQpWcMvslRSXWwXkZx7nUAU1Fa2pwNaKl6P5oR3HyZQiVzYv','aafadfc0-b4a0-11f0-984f-02f6df36a903','2025-10-29 17:24:20','chang'),(4269,'1.0.0','https://dk09qqd9w46ur.cloudfront.net/TestServer/ef33B4uEJ4pp7EQjLNJeUFYjvhEkw3Da4LzJFISQw6sM2xXMjt','5cef4fdc-b52d-11f0-984f-02f6df36a903','2025-10-30 10:11:28','jang'),(4270,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/2MWoti1CcUyZi4Xl8pQ9Fa2kvkRPhUgOk0mBQIwNX5Zw293aiV','c5546381-b52d-11f0-984f-02f6df36a903','2025-10-30 10:14:23','jang'),(4271,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/KHsqrfJxeIoI7fSHq1QHJejAPvSxh1cqobRgH1L5CacWUCEn7k','3442e198-b530-11f0-984f-02f6df36a903','2025-10-30 10:31:49','jang'),(4272,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/53CsdCBimw2KA13CR1BIfiUnMUxt8LfZpO7ug04LiAdXLtlXfZ','525a8c52-b531-11f0-984f-02f6df36a903','2025-10-30 10:39:48','jang'),(4273,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/P9Ca6TZEGb7aTvrlkTZ53WFVp5K3BULbN0XpMR2BirYlIw1bWe','3f275e63-b543-11f0-984f-02f6df36a903','2025-10-30 12:48:07','jang'),(4274,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/8HNcw0lAeBF4COHmS8gUeE1RNPoIWV9LxgEEyX4uI3aRDILRfl','4aeac8a7-b54c-11f0-984f-02f6df36a903','2025-10-30 13:52:52','jang'),(4275,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/AQ748U0HAudUcHwAtgLBZ8yVmbXf8T7bS1JBXdNWbmzz4uvhje','dda97f83-b555-11f0-984f-02f6df36a903','2025-10-30 15:01:24','jang'),(4276,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/9CoV2m1jKszjhKRxzn5atOa6jrRFnlMptcbAhHpt1UHWAg7owX','e74e31ff-b557-11f0-984f-02f6df36a903','2025-10-30 15:15:59','jang'),(4277,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/vZfMvcdsw2g5qrMhx6qBunm67mqlCVEL7oFuUrkjy3D220spDs','bf12f409-b55d-11f0-984f-02f6df36a903','2025-10-30 15:57:49','jang'),(4278,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/uP3PRTuOtNwDwm5MnwnSS50noShYxhqWTyQABllRdt7mzYi4Tz','389f1f46-b600-11f0-984f-02f6df36a903','2025-10-31 11:20:51','jang'),(4279,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/lrHH5yVqJdmaXNDkIb70r2Tw7xMKDpNaUY9BfeYym1cymh3OYY','51b72740-b605-11f0-984f-02f6df36a903','2025-10-31 11:57:21','chang'),(4280,'0.9.12','https://dk09qqd9w46ur.cloudfront.net/TestServer/LaN6zLieEJ7x2ylJNOPbPQzcTvY6unff47Ef0c44ssNaU2pwsY','cd6024eb-b63a-11f0-984f-02f6df36a903','2025-10-31 18:20:12','chang'),(4281,'0.9.13','https://dk09qqd9w46ur.cloudfront.net/TestServer/QqV5uac0eJyDDb6xcHyWPMpWW6Iyls2O9me0LRO27gQKPaG9zF','8ca77fc2-b63e-11f0-984f-02f6df36a903','2025-10-31 18:47:01','jang'),(4282,'0.9.13','https://dk09qqd9w46ur.cloudfront.net/TestServer/Lt7mFgi0cqogUl6xkIJGFoMYrMXBLmJXUhTQTsZ1xpf1UBmaiQ','e08834af-b66e-11f0-984f-02f6df36a903','2025-11-01 00:32:57','jang');
/*!40000 ALTER TABLE `game_data_file_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `game_data_version_info`
--

DROP TABLE IF EXISTS `game_data_version_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `game_data_version_info` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0',
  `isBlock` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `version` (`version`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `game_data_version_info`
--

LOCK TABLES `game_data_version_info` WRITE;
/*!40000 ALTER TABLE `game_data_version_info` DISABLE KEYS */;
INSERT INTO `game_data_version_info` VALUES (9,'0.9.8',0),(10,'0.9.9',0);
/*!40000 ALTER TABLE `game_data_version_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reportInfo`
--

DROP TABLE IF EXISTS `reportInfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reportInfo` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `reporterPlayerId` bigint NOT NULL DEFAULT '-1' COMMENT '피해자',
  `reporterNickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '피해자',
  `reportTime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '피해자',
  `playerId` bigint NOT NULL DEFAULT '-1' COMMENT '피고인',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '피고인',
  `chatId` int NOT NULL DEFAULT '-1' COMMENT '피고인',
  `message` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '피고인',
  `reason` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '피해자',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reportInfo`
--

LOCK TABLES `reportInfo` WRITE;
/*!40000 ALTER TABLE `reportInfo` DISABLE KEYS */;
/*!40000 ALTER TABLE `reportInfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `serverInfo`
--

DROP TABLE IF EXISTS `serverInfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `serverInfo` (
  `id` tinyint NOT NULL DEFAULT '0',
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `isiOSCouponOn` tinyint NOT NULL DEFAULT '0',
  `ios_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `android_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `local_summon_start_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `local_summon_end_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `cafe_link` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `s3_game_data_path` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='서버 버전, 쿠폰 On/Off';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `serverInfo`
--

LOCK TABLES `serverInfo` WRITE;
/*!40000 ALTER TABLE `serverInfo` DISABLE KEYS */;
INSERT INTO `serverInfo` VALUES (0,'0.9.8',1,'0.9.8','0.9.8','1970-01-01 00:00:00','1970-01-01 00:00:00','https://www.naver.com','TestServer/');
/*!40000 ALTER TABLE `serverInfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `versionInfo`
--

DROP TABLE IF EXISTS `versionInfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `versionInfo` (
  `uid_version` bigint NOT NULL AUTO_INCREMENT,
  `isMaintenance` tinyint NOT NULL DEFAULT '1' COMMENT '구 버전관리랑 호환을 위해 만듬 신경X',
  `os` tinyint NOT NULL DEFAULT '0' COMMENT '0 : android, 1: ios, 2 : PC',
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `version_state` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 : 접속 가능, 1 : 점검, 2 : 강제 업데이트',
  `maintenance_message` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `maintenance_message_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `maintenance_message_zhcht` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `server_check_end_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '점검 시 점검 끝나는 시각',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid_version`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `versionInfo`
--

LOCK TABLES `versionInfo` WRITE;
/*!40000 ALTER TABLE `versionInfo` DISABLE KEYS */;
INSERT INTO `versionInfo` VALUES (1,0,0,'1.0.0',0,'점검 중','maintenance_en','maintenance_cht','2024-11-14 11:15:49','2024-11-14 11:15:49','2024-11-14 11:15:49'),(2,0,1,'1.0.0',0,'점검 중','maintenance_en','maintenance_cht','2024-11-14 11:15:49','2024-11-14 11:15:49','2024-11-14 11:15:49'),(23,0,0,'0.9.8',0,'점검 중','maintenance_en','maintenance_cht','2024-11-14 11:15:49','2024-11-14 11:15:49','2025-10-29 11:28:11'),(24,0,1,'0.9.8',0,'점검 중','maintenance_en','maintenance_cht','2024-11-14 11:15:49','2024-11-14 11:15:49','2025-10-29 11:28:12');
/*!40000 ALTER TABLE `versionInfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `white_list_info`
--

DROP TABLE IF EXISTS `white_list_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `white_list_info` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `device_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `tag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `white_list_info`
--

LOCK TABLES `white_list_info` WRITE;
/*!40000 ALTER TABLE `white_list_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `white_list_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'serverDB_JI'
--

--
-- Dumping routines for database 'serverDB_JI'
--
/*!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-11-03 11:37:05
