Skip to content

Commit 9e260e7

Browse files
TommyLemonTommyLemon
committed
MySQL：更新表
1 parent 645c32f commit 9e260e7

20 files changed

Lines changed: 151 additions & 94 deletions

‎MySQL/single/Auto/UIGO/sys_Device.sql‎

Lines changed: 4 additions & 4 deletions
Large diffs are not rendered by default.

‎MySQL/single/Auto/UIGO/sys_Flow.sql‎

Lines changed: 17 additions & 6 deletions
Large diffs are not rendered by default.

‎MySQL/single/Auto/UIGO/sys_Input.sql‎

Lines changed: 27 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
-- MySQL dump 10.13 Distrib 8.0.42, for macos15 (arm64)
1+
-- MySQL dump 10.13 Distrib 8.0.31, for macos12 (x86_64)
22
--
33
-- Host: apijson.cn Database: sys
44
-- ------------------------------------------------------
@@ -28,6 +28,8 @@ CREATE TABLE `Input` (
2828
`userId` bigint NOT NULL,
2929
`disable` tinyint NOT NULL DEFAULT '0',
3030
`step` int NOT NULL,
31+
`chainGroupId` bigint NOT NULL DEFAULT '0',
32+
`chainId` bigint NOT NULL DEFAULT '0',
3133
`flowId` bigint NOT NULL COMMENT '操作流程 id',
3234
`name` varchar(100) DEFAULT NULL,
3335
`tagName` varchar(100) DEFAULT NULL,
@@ -78,6 +80,7 @@ CREATE TABLE `Input` (
7880
`contentHeight` double NOT NULL DEFAULT '0',
7981
`pointerCount` int NOT NULL DEFAULT '1',
8082
`pointerIds` text,
83+
`pointers` json DEFAULT NULL,
8184
`metaState` int NOT NULL DEFAULT '0',
8285
`xPrecision` double NOT NULL DEFAULT '1',
8386
`yPrecision` double NOT NULL DEFAULT '1',
@@ -93,23 +96,28 @@ CREATE TABLE `Input` (
9396
`format` varchar(45) DEFAULT NULL,
9497
`host` varchar(45) DEFAULT NULL,
9598
`url` varchar(1000) DEFAULT NULL,
99+
`query` text,
96100
`header` text,
97101
`request` text,
102+
`reqHeader` text,
103+
`status` varchar(100) DEFAULT NULL,
98104
`response` longtext,
105+
`resHeader` text,
99106
`compare` json DEFAULT NULL,
100107
`standard` text,
101108
`when` int DEFAULT NULL,
102109
`text` text,
103110
`hint` varchar(100) DEFAULT NULL,
104111
`start` int DEFAULT NULL,
105-
`count` int DEFAULT NULL,
112+
`length` int DEFAULT NULL,
106113
`after` int DEFAULT NULL,
107114
`edit` int DEFAULT NULL,
108115
`s` text,
109116
`target` text,
110117
`targetId` int DEFAULT NULL,
111118
`targetIdName` varchar(100) DEFAULT NULL,
112119
`targetWebId` varchar(100) DEFAULT NULL,
120+
`targetType` varchar(100) DEFAULT NULL,
113121
`childIndex` int DEFAULT NULL,
114122
`childCount` int DEFAULT NULL,
115123
`isSplit2Show` tinyint DEFAULT NULL,
@@ -122,11 +130,13 @@ CREATE TABLE `Input` (
122130
`focusId` int DEFAULT NULL,
123131
`focusIdName` varchar(100) DEFAULT NULL,
124132
`focusWebId` varchar(100) DEFAULT NULL,
133+
`focusType` varchar(100) DEFAULT NULL,
125134
`focusChildIndex` int DEFAULT NULL,
126135
`focusChildCount` int DEFAULT NULL,
127136
`parentId` int DEFAULT NULL,
128137
`parentIdName` varchar(100) DEFAULT NULL,
129138
`parentWebId` varchar(100) DEFAULT NULL,
139+
`parentType` varchar(100) DEFAULT NULL,
130140
`parentChildIndex` int DEFAULT NULL,
131141
`parentChildCount` int DEFAULT NULL,
132142
`timeout` bigint DEFAULT NULL COMMENT '等待超时时间',
@@ -139,6 +149,7 @@ CREATE TABLE `Input` (
139149
`dialogY` double DEFAULT NULL,
140150
`dialogWidth` double DEFAULT NULL,
141151
`dialogHeight` double DEFAULT NULL,
152+
`popupWindow` varchar(100) DEFAULT NULL,
142153
`textIndex` int DEFAULT NULL,
143154
`leftText` text,
144155
`rightText` text,
@@ -152,10 +163,22 @@ CREATE TABLE `Input` (
152163
`throw` varchar(100) DEFAULT NULL,
153164
`exception` varchar(1000) DEFAULT NULL,
154165
`routeParams` json DEFAULT NULL,
166+
`popupWindowX` double DEFAULT NULL,
167+
`popupWindowY` double DEFAULT NULL,
168+
`popupWindowWidth` double DEFAULT NULL,
169+
`popupWindowHeight` double DEFAULT NULL,
170+
`count` int DEFAULT NULL,
171+
`config` varchar(5000) DEFAULT NULL COMMENT '配置',
172+
`img` longtext,
173+
`file` varchar(200) DEFAULT NULL,
174+
`fileSize` bigint NOT NULL DEFAULT '0',
175+
`width` int DEFAULT NULL,
176+
`height` int DEFAULT NULL,
177+
`rank` bigint NOT NULL DEFAULT '0',
155178
PRIMARY KEY (`id`),
156179
KEY `index_time` (`time`),
157180
KEY `index_flowId` (`flowId`)
158-
) ENGINE=InnoDB AUTO_INCREMENT=1711339080683 DEFAULT CHARSET=utf8mb3 COMMENT='输入事件，包括 屏幕触摸事件 MotionEvent, 按键事件 KeyEvent，界面切换, HTTP 请求';
181+
) ENGINE=InnoDB AUTO_INCREMENT=1711339086158 DEFAULT CHARSET=utf8mb3 COMMENT='输入事件，包括 屏幕触摸事件 MotionEvent, 按键事件 KeyEvent，界面切换, HTTP 请求';
159182
/*!40101 SET character_set_client = @saved_cs_client */;
160183
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
161184

@@ -167,4 +190,4 @@ CREATE TABLE `Input` (
167190
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
168191
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
169192

170-
-- Dump completed on 2026-02-22 3:41:18
193+
-- Dump completed on 2026-05-11 6:54:41

‎MySQL/single/Auto/UIGO/sys_Output.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
-- MySQL dump 10.13 Distrib 8.0.42, for macos15 (arm64)
1+
-- MySQL dump 10.13 Distrib 8.0.31, for macos12 (x86_64)
22
--
33
-- Host: apijson.cn Database: sys
44
-- ------------------------------------------------------
@@ -64,4 +64,4 @@ UNLOCK TABLES;
6464
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6565
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6666

67-
-- Dump completed on 2026-02-22 3:17:23
67+
-- Dump completed on 2026-05-11 6:11:13

‎MySQL/single/Auto/UIGO/sys_System.sql‎

Lines changed: 4 additions & 4 deletions
Large diffs are not rendered by default.

‎MySQL/single/Auto/UnitAuto/sys_Method.sql‎

Lines changed: 4 additions & 4 deletions
Large diffs are not rendered by default.

‎MySQL/single/Auto/sys_Chain.sql‎

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
-- MySQL dump 10.13 Distrib 8.0.42, for macos15 (arm64)
1+
-- MySQL dump 10.13 Distrib 8.0.31, for macos12 (x86_64)
22
--
33
-- Host: apijson.cn Database: sys
44
-- ------------------------------------------------------
@@ -25,6 +25,7 @@ DROP TABLE IF EXISTS `Chain`;
2525
CREATE TABLE `Chain` (
2626
`id` bigint NOT NULL AUTO_INCREMENT,
2727
`userId` bigint NOT NULL,
28+
`project` varchar(20) NOT NULL DEFAULT '',
2829
`host` varchar(100) DEFAULT NULL,
2930
`testAccountId` varchar(45) NOT NULL DEFAULT '0',
3031
`toGroupId` bigint NOT NULL DEFAULT '0',
@@ -52,7 +53,7 @@ CREATE TABLE `Chain` (
5253

5354
LOCK TABLES `Chain` WRITE;
5455
/*!40000 ALTER TABLE `Chain` DISABLE KEYS */;
55-
INSERT INTO `Chain` VALUES (11,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',0,NULL,0,NULL,0,'2024-05-02 13:12:36','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(12,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1648334213866,NULL,0,NULL,0,'2024-05-02 13:15:49','[\"Chat\", \"Tommy\"]','','','{}'),(13,82001,NULL,'82002',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1546414179257,NULL,0,NULL,0,'2024-05-02 13:16:02','[\"Chat\", \"Tommy\"]','Jan','13000082002','{\"id\": 82002, \"name\": \"Jan\", \"phone\": \"13000082002\", \"account\": \"13000082002\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 0, \"remember\": false, \"blueCount\": 0, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 18, \"whiteCount\": 18, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(15,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1704192205562,NULL,0,NULL,0,'2024-05-02 13:21:29','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(16,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1704192205563,NULL,0,NULL,0,'2024-05-02 13:21:54','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(17,82001,NULL,'82003',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1511969630372,NULL,0,NULL,0,'2024-05-02 13:22:10','[\"Chat\", \"Tommy\"]','Wechat','13000082003','{\"id\": 82003, \"name\": \"Wechat\", \"phone\": \"13000082003\", \"account\": \"13000082003\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 0, \"remember\": false, \"blueCount\": 0, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 0, \"whiteCount\": 0, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(48,1704867025040,NULL,'',0,1742784526673,'查询动态列表','2025-03-24 02:48:46',0,NULL,0,NULL,0,'2025-03-24 02:48:46',NULL,NULL,NULL,NULL),(49,82001,NULL,'',0,1742784526673,'查询动态列表','2025-03-24 06:05:56',1704192205420,NULL,0,NULL,0,'2025-03-24 06:05:56','[\"Moment\", \"Lemon\"]','','','{}'),(59,82001,NULL,'',0,1742784526673,'查询动态列表','2025-08-08 04:09:57',1564483634841,NULL,0,NULL,0,'2025-08-08 04:09:58','[\"Moment\", \"Lemon\"]','','','{}'),(1759994627546,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2025-10-09 07:23:47',1546414192830,NULL,0,NULL,0,'2025-10-09 07:23:47','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(1761204465097,82001,NULL,'82001',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2025-10-23 07:27:45',1704192205420,NULL,0,NULL,0,'2025-10-23 07:27:45','[\"Chat\", \"Tommy\"]','Test User','13000082001','{\"id\": 82001, \"name\": \"Test User\", \"phone\": \"13000082001\", \"account\": \"13000082001\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 7, \"remember\": false, \"blueCount\": 13, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 26, \"whiteCount\": 6, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(1761204465098,82001,NULL,'',0,1742784526673,'查询动态列表','2025-10-27 03:14:19',1522905895591,NULL,0,NULL,0,'2025-10-27 03:14:20','[\"Moment\", \"Lemon\"]','','','{}'),(1761204465117,82001,NULL,'',0,1742784526673,'查询动态列表','2025-11-30 10:43:35',1511796155276,'获取验证码',0,NULL,0,'2025-11-30 10:43:35','[\"Moment\", \"Lemon\"]',NULL,NULL,NULL),(1761204465119,82001,NULL,'0',0,1765128460243,'test chain','2025-12-07 17:27:40',0,NULL,0,NULL,0,'2025-12-07 17:27:40','[\"tets\"]',NULL,NULL,NULL),(1765722250311,82001,NULL,'0',0,1765128460243,'test chain','2025-12-14 14:24:10',1546414192830,'获取用户列表',0,NULL,0,'2025-12-14 14:24:10',NULL,NULL,NULL,NULL),(1765725895387,82003,NULL,'0',0,1765128460243,'test chain','2025-12-14 15:24:55',1560737118846,'获取单个用户信息2 12:05',0,NULL,0,'2025-12-14 15:24:55',NULL,NULL,NULL,NULL);
56+
INSERT INTO `Chain` VALUES (11,82001,'',NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',0,NULL,0,NULL,0,'2024-05-02 13:12:36','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(12,82001,'',NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1648334213866,NULL,0,NULL,0,'2024-05-02 13:15:49','[\"Chat\", \"Tommy\"]','','','{}'),(13,82001,'',NULL,'82002',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1546414179257,NULL,0,NULL,0,'2024-05-02 13:16:02','[\"Chat\", \"Tommy\"]','Jan','13000082002','{\"id\": 82002, \"name\": \"Jan\", \"phone\": \"13000082002\", \"account\": \"13000082002\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 0, \"remember\": false, \"blueCount\": 0, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 18, \"whiteCount\": 18, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(15,82001,'',NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1704192205562,NULL,0,NULL,0,'2024-05-02 13:21:29','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(16,82001,'',NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1704192205563,NULL,0,NULL,0,'2024-05-02 13:21:54','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(17,82001,'',NULL,'82003',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1511969630372,NULL,0,NULL,0,'2024-05-02 13:22:10','[\"Chat\", \"Tommy\"]','Wechat','13000082003','{\"id\": 82003, \"name\": \"Wechat\", \"phone\": \"13000082003\", \"account\": \"13000082003\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 0, \"remember\": false, \"blueCount\": 0, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 0, \"whiteCount\": 0, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(48,1704867025040,'',NULL,'',0,1742784526673,'查询动态列表','2025-03-24 02:48:46',0,NULL,0,NULL,0,'2025-03-24 02:48:46',NULL,NULL,NULL,NULL),(49,82001,'',NULL,'',0,1742784526673,'查询动态列表','2025-03-24 06:05:56',1704192205420,NULL,0,NULL,0,'2025-03-24 06:05:56','[\"Moment\", \"Lemon\"]','','','{}'),(59,82001,'',NULL,'',0,1742784526673,'查询动态列表','2025-08-08 04:09:57',1564483634841,NULL,0,NULL,0,'2025-08-08 04:09:58','[\"Moment\", \"Lemon\"]','','','{}'),(1759994627546,82001,'',NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2025-10-09 07:23:47',1546414192830,NULL,0,NULL,0,'2025-10-09 07:23:47','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(1761204465097,82001,'',NULL,'82001',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2025-10-23 07:27:45',1704192205420,NULL,0,NULL,0,'2025-10-23 07:27:45','[\"Chat\", \"Tommy\"]','Test User','13000082001','{\"id\": 82001, \"name\": \"Test User\", \"phone\": \"13000082001\", \"account\": \"13000082001\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 7, \"remember\": false, \"blueCount\": 13, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 26, \"whiteCount\": 6, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(1761204465098,82001,'',NULL,'',0,1742784526673,'查询动态列表','2025-10-27 03:14:19',1522905895591,NULL,0,NULL,0,'2025-10-27 03:14:20','[\"Moment\", \"Lemon\"]','','','{}'),(1761204465117,82001,'',NULL,'',0,1742784526673,'查询动态列表','2025-11-30 10:43:35',1511796155276,'获取验证码',0,NULL,0,'2025-11-30 10:43:35','[\"Moment\", \"Lemon\"]',NULL,NULL,NULL),(1761204465119,82001,'',NULL,'0',0,1765128460243,'test chain','2025-12-07 17:27:40',0,NULL,0,NULL,0,'2025-12-07 17:27:40','[\"tets\", \"Tommy\"]',NULL,NULL,NULL),(1765722250311,82001,'',NULL,'0',0,1765128460243,'test chain','2025-12-14 14:24:10',1546414192830,'获取用户列表',0,NULL,0,'2025-12-14 14:24:10','[\"tets\", \"Tommy\"]',NULL,NULL,NULL),(1765725895387,82003,'',NULL,'0',0,1765128460243,'test chain','2025-12-14 15:24:55',1560737118846,'获取单个用户信息2 12:05',0,NULL,0,'2025-12-14 15:24:55',NULL,NULL,NULL,NULL);
5657
/*!40000 ALTER TABLE `Chain` ENABLE KEYS */;
5758
UNLOCK TABLES;
5859
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -65,4 +66,4 @@ UNLOCK TABLES;
6566
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6667
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6768

68-
-- Dump completed on 2026-02-22 3:16:24
69+
-- Dump completed on 2026-05-11 5:56:40

‎MySQL/single/Auto/sys_Random.sql‎

Lines changed: 6 additions & 5 deletions
Large diffs are not rendered by default.

‎MySQL/single/Auto/sys_Script.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
-- MySQL dump 10.13 Distrib 8.0.42, for macos15 (arm64)
1+
-- MySQL dump 10.13 Distrib 8.0.31, for macos12 (x86_64)
22
--
33
-- Host: apijson.cn Database: sys
44
-- ------------------------------------------------------
@@ -61,4 +61,4 @@ UNLOCK TABLES;
6161
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6262
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6363

64-
-- Dump completed on 2026-02-22 3:16:14
64+
-- Dump completed on 2026-05-11 5:56:46

‎MySQL/single/Auto/sys_TestRecord.sql‎

Lines changed: 38 additions & 18 deletions
Large diffs are not rendered by default.

0 commit comments

Comments
 (0)