Skip to content

Commit 4289b81

Browse files
TommyLemonTommyLemon
committed
MySQL: 更新表
1 parent 22bfaea commit 4289b81

20 files changed

+382
-318
lines changed

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

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

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

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

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

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

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

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

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

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

‎MySQL/single/Auto/sys_Chain.sql‎

Lines changed: 29 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
1-
-- MySQL dump 10.13 Distrib 8.0.31, for macos12 (x86_64)
1+
-- MySQL dump 10.13 Distrib 8.0.42, for macos15 (arm64)
22
--
33
-- Host: apijson.cn Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.43-log
5+
-- Server version 8.4.5
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -16,31 +16,45 @@
1616
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1717

1818
--
19-
-- Table structure for table `Chain`
19+
-- Table structure for table `chain`
2020
--
2121

22-
DROP TABLE IF EXISTS `Chain`;
22+
DROP TABLE IF EXISTS `chain`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!50503 SET character_set_client = utf8mb4 */;
25-
CREATE TABLE `Chain` (
26-
`id` bigint(20) NOT NULL AUTO_INCREMENT,
27-
`userId` bigint(20) NOT NULL,
25+
CREATE TABLE `chain` (
26+
`id` bigint NOT NULL AUTO_INCREMENT,
27+
`userId` bigint NOT NULL,
2828
`host` varchar(100) DEFAULT NULL,
29-
`testAccountId` bigint(20) NOT NULL DEFAULT '0',
30-
`toGroupId` bigint(20) NOT NULL DEFAULT '0',
31-
`groupId` bigint(20) NOT NULL,
29+
`testAccountId` varchar(45) NOT NULL DEFAULT '0',
30+
`toGroupId` bigint NOT NULL DEFAULT '0',
31+
`groupId` bigint NOT NULL,
3232
`groupName` varchar(100) NOT NULL,
3333
`rank` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34-
`documentId` bigint(20) NOT NULL DEFAULT '0',
34+
`documentId` bigint NOT NULL DEFAULT '0',
3535
`documentName` varchar(100) DEFAULT NULL,
36-
`randomId` bigint(20) NOT NULL DEFAULT '0',
36+
`randomId` bigint NOT NULL DEFAULT '0',
3737
`randomName` varchar(100) DEFAULT NULL,
38-
`scriptId` bigint(20) NOT NULL DEFAULT '0',
38+
`scriptId` bigint NOT NULL DEFAULT '0',
3939
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
40+
`tagList` json DEFAULT NULL COMMENT '标签列表',
41+
`testName` varchar(45) DEFAULT NULL COMMENT '测试用户名称',
42+
`testAccount` varchar(45) DEFAULT NULL COMMENT '测试用户账号，一般是手机号、邮箱等',
43+
`testInfo` json DEFAULT NULL COMMENT '测试用户信息',
4044
PRIMARY KEY (`id`),
4145
UNIQUE KEY `idnew_table_UNIQUE` (`id`)
42-
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='多接口串联的场景链路用例';
46+
) ENGINE=InnoDB AUTO_INCREMENT=1761204465119 DEFAULT CHARSET=utf8mb3 COMMENT='多接口串联的场景链路用例';
4347
/*!40101 SET character_set_client = @saved_cs_client */;
48+
49+
--
50+
-- Dumping data for table `chain`
51+
--
52+
53+
LOCK TABLES `chain` WRITE;
54+
/*!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','[\"Moment\"]',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','[\"Moment\"]','','','{}'),(13,82001,NULL,'82002',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1546414179257,NULL,0,NULL,0,'2024-05-02 13:16:02','[\"Moment\"]','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','[\"Moment\"]',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','[\"Moment\"]',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','[\"Moment\"]','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\", \"Tommy\"]','','','{}'),(54,1681451084123,NULL,'',0,1751529769988,'查询','2025-07-03 08:02:50',0,NULL,0,NULL,0,'2025-07-03 08:02:50',NULL,NULL,NULL,NULL),(59,82001,NULL,'',0,1742784526673,'查询动态列表','2025-08-08 04:09:57',1564483634841,NULL,0,NULL,0,'2025-08-08 04:09:58','[\"Moment\", \"Tommy\"]','','','{}'),(1759994627546,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2025-10-09 07:23:47',1546414192830,NULL,0,NULL,0,'2025-10-09 07:23:47','[\"Moment\"]',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','[\"Moment\"]','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\", \"Tommy\"]','','','{}'),(1761204465117,82001,NULL,'',0,1742784526673,'查询动态列表','2025-11-30 10:43:35',1511796155276,'获取验证码',0,NULL,0,'2025-11-30 10:43:35','[\"Moment\", \"Tommy\"]',NULL,NULL,NULL),(1761204465118,82001,NULL,'0',0,1765106927698,'test chain case','2025-12-07 11:28:47',0,NULL,0,NULL,0,'2025-12-07 11:28:47','[\"test\"]',NULL,NULL,NULL);
56+
/*!40000 ALTER TABLE `chain` ENABLE KEYS */;
57+
UNLOCK TABLES;
4458
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4559

4660
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
@@ -51,4 +65,4 @@ CREATE TABLE `Chain` (
5165
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5266
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5367

54-
-- Dump completed on 2025-08-03 19:46:04
68+
-- Dump completed on 2025-12-07 19:38:58

‎MySQL/single/Auto/sys_Random.sql‎

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

‎MySQL/single/Auto/sys_Script.sql‎

Lines changed: 22 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
1-
-- MySQL dump 10.13 Distrib 8.0.31, for macos12 (x86_64)
1+
-- MySQL dump 10.13 Distrib 8.0.42, for macos15 (arm64)
22
--
3-
-- Host: 47.122.25.116 Database: sys
3+
-- Host: apijson.cn Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.43-log
5+
-- Server version 8.4.5
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -16,39 +16,40 @@
1616
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1717

1818
--
19-
-- Table structure for table `Script`
19+
-- Table structure for table `script`
2020
--
2121

22-
DROP TABLE IF EXISTS `Script`;
22+
DROP TABLE IF EXISTS `script`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!50503 SET character_set_client = utf8mb4 */;
25-
CREATE TABLE `Script` (
26-
`id` bigint(20) NOT NULL AUTO_INCREMENT,
27-
`userId` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id',
28-
`testAccountId` bigint(20) NOT NULL DEFAULT '0' COMMENT '测试账号 id',
29-
`chainGroupId` bigint(20) NOT NULL DEFAULT '0',
30-
`chainId` bigint(20) NOT NULL DEFAULT '0',
31-
`documentId` bigint(20) NOT NULL DEFAULT '0' COMMENT '测试用例 id',
32-
`simple` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否为可直接执行的简单代码段：0-否 1-是',
33-
`ahead` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否为前置脚本',
25+
CREATE TABLE `script` (
26+
`id` bigint NOT NULL AUTO_INCREMENT,
27+
`userId` bigint NOT NULL DEFAULT '0' COMMENT '用户 id',
28+
`testAccountId` bigint NOT NULL DEFAULT '0' COMMENT '测试账号 id',
29+
`chainGroupId` bigint NOT NULL DEFAULT '0',
30+
`chainId` bigint NOT NULL DEFAULT '0',
31+
`documentId` bigint NOT NULL DEFAULT '0' COMMENT '测试用例 id',
32+
`simple` tinyint NOT NULL DEFAULT '0' COMMENT '是否为可直接执行的简单代码段：0-否 1-是',
33+
`ahead` tinyint NOT NULL DEFAULT '0' COMMENT '是否为前置脚本',
3434
`title` varchar(100) DEFAULT NULL COMMENT '函数名',
3535
`name` varchar(100) NOT NULL COMMENT '名称',
3636
`script` text NOT NULL,
3737
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
3838
`detail` varchar(1000) DEFAULT NULL,
39+
`randomId` bigint NOT NULL DEFAULT '0',
3940
PRIMARY KEY (`id`),
4041
UNIQUE KEY `id_UNIQUE` (`id`)
41-
) ENGINE=InnoDB AUTO_INCREMENT=1680660620760 DEFAULT CHARSET=utf8 COMMENT='脚本，前置预处理脚本、后置断言和恢复脚本等';
42+
) ENGINE=InnoDB AUTO_INCREMENT=1738490404343 DEFAULT CHARSET=utf8mb3 COMMENT='脚本，前置预处理脚本、后置断言和恢复脚本等';
4243
/*!40101 SET character_set_client = @saved_cs_client */;
4344

4445
--
45-
-- Dumping data for table `Script`
46+
-- Dumping data for table `script`
4647
--
4748

48-
LOCK TABLES `Script` WRITE;
49-
/*!40000 ALTER TABLE `Script` DISABLE KEYS */;
50-
INSERT INTO `Script` VALUES (1,0,0,0,0,0,0,0,NULL,'getType','function getType(curObj, key) {\n var val = curObj == null ? null : curObj[key];\n return val instanceof Array ? \"array\" : typeof val;\n}','2022-11-16 16:01:23',NULL),(2,0,0,0,0,0,0,0,NULL,'isContain','function isContain(curObj, arrKey, valKey) {\n var arr = curObj == null ? null : curObj[arrKey];\n var val = curObj == null ? null : curObj[valKey];\n return arr != null && arr.indexOf(val) >=0;\n}','2022-11-16 16:02:48',NULL),(3,0,0,0,0,0,1,0,NULL,'init','var i = 1;\n\"init done \" + i;','2022-11-16 16:41:35',NULL),(4,0,0,0,0,0,0,0,NULL,'length','function length(curObj, key) {\n var val = curObj == null ? null : curObj[key];\n return val == null ? 0 : val.length;\n}','2022-11-16 17:18:43',NULL),(1670877914051,82001,0,0,0,0,1,1,'执行脚本 2022-12-13 04:44','','function assert(assertion, msg) {\n if (assertion === true) {\n return\n }\n if (msg == null) {\n msg = \'assert failed! assertion = \' + assertion\n }\n\n if (isTest) {\n console.log(msg)\n alert(msg)\n } else {\n throw new Error(msg)\n } \n} \n\nif (isTest) {\n assert(true)\n assert(false)\n assert(true, \'ok\')\n assert(false, \'data.User shoule not be null!\') \n}\n\nfunction getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:45:14',NULL),(1670878495619,82001,82002,0,0,0,1,0,'执行脚本 2022-12-13 04:54','','function getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:54:55',NULL),(1670878529042,82001,82001,0,0,0,1,1,'执行脚本 2022-12-13 04:55','','function getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:55:29',NULL),(1670878622401,82001,82003,0,0,0,1,0,'执行脚本 2022-12-13 04:57','','if (isPre) {\n header[\'my-header\'] = \'test\'\n}','2022-12-12 20:57:02',NULL),(1670885503909,82001,0,0,0,1657045372046,1,1,'执行脚本 2022-12-13 06:51','','if (isPre) {\n req.User.id = 82005\n}','2022-12-12 22:51:43',NULL),(1670887211207,82001,0,0,0,1657045372046,1,0,'执行脚本 2022-12-13 07:20','','','2022-12-12 23:20:11',NULL),(1676368454070,82001,0,0,0,1546414192830,1,0,NULL,'casePost1546414192830','','2023-02-14 09:54:14',NULL),(1679282174670,82001,0,0,0,0,1,1,NULL,'到店系统查询','','2023-03-20 03:16:14',NULL),(1680660620759,82001,0,0,0,1511796155276,1,1,NULL,'casePre1511796155276','if (isPre) {\n console.log(\'test pre script 4 /post/verify\') \n}\n','2024-05-03 03:55:14',NULL);
51-
/*!40000 ALTER TABLE `Script` ENABLE KEYS */;
49+
LOCK TABLES `script` WRITE;
50+
/*!40000 ALTER TABLE `script` DISABLE KEYS */;
51+
INSERT INTO `script` VALUES (1,0,0,0,0,0,0,0,NULL,'getType','function getType(curObj, key) {\n var val = curObj == null ? null : curObj[key];\n return val instanceof Array ? \"array\" : typeof val;\n}','2022-11-16 16:01:23',NULL,0),(2,0,0,0,0,0,0,0,NULL,'isContain','function isContain(curObj, arrKey, valKey) {\n var arr = curObj == null ? null : curObj[arrKey];\n var val = curObj == null ? null : curObj[valKey];\n return arr != null && arr.indexOf(val) >=0;\n}','2022-11-16 16:02:48',NULL,0),(3,0,0,0,0,0,1,0,NULL,'init','var i = 1;\n\"init done \" + i;','2022-11-16 16:41:35',NULL,0),(4,0,0,0,0,0,0,0,NULL,'length','function length(curObj, key) {\n var val = curObj == null ? null : curObj[key];\n return val == null ? 0 : val.length;\n}','2022-11-16 17:18:43',NULL,0),(1670877914051,82001,0,0,0,0,1,1,'执行脚本 2022-12-13 04:44','','function assert(assertion, msg) {\n if (assertion === true) {\n return\n }\n if (msg == null) {\n msg = \'assert failed! assertion = \' + assertion\n }\n\n if (isTest) {\n console.log(msg)\n alert(msg)\n } else {\n throw new Error(msg)\n } \n} \n\nif (isTest) {\n assert(true)\n assert(false)\n assert(true, \'ok\')\n assert(false, \'data.User shoule not be null!\') \n}\n\nfunction getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:45:14',NULL,0),(1670878495619,82001,82002,0,0,0,1,0,'执行脚本 2022-12-13 04:54','','function getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:54:55',NULL,0),(1670878529042,82001,82001,0,0,0,1,1,'执行脚本 2022-12-13 04:55','','function getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:55:29',NULL,0),(1670878622401,82001,82003,0,0,0,1,0,'执行脚本 2022-12-13 04:57','','if (isPre) {\n header[\'my-header\'] = \'test\'\n}','2022-12-12 20:57:02',NULL,0),(1670885503909,82001,0,0,0,1657045372046,1,1,'执行脚本 2022-12-13 06:51','','if (isPre) {\n req.User.id = 82005\n}','2022-12-12 22:51:43',NULL,0),(1670887211207,82001,0,0,0,1657045372046,1,0,'执行脚本 2022-12-13 07:20','','','2022-12-12 23:20:11',NULL,0),(1676368454070,82001,0,0,0,1546414192830,1,0,NULL,'casePost1546414192830','','2023-02-14 09:54:14',NULL,0),(1679282174670,82001,0,0,0,0,1,1,NULL,'到店系统查询','','2023-03-20 03:16:14',NULL,0),(1680660620759,82001,0,0,0,1511796155276,1,1,NULL,'casePre1511796155276','if (isPre) {\n console.log(\'test pre script 4 /post/verify\') \n}\n','2024-05-03 03:55:14',NULL,0),(1680660620760,82001,0,1716706529846,42,1511970009072,1,1,NULL,'casePre1511970009072','if (isPre) { console.log(\"test pre script\") }','2024-09-08 16:00:15',NULL,0),(1680660620761,82001,0,1716706529846,42,1511970009072,1,0,NULL,'casePost1511970009072','console.log(\'run post script\')','2024-09-08 16:00:32',NULL,0),(1680660620762,82001,0,1714209723275,2,1546414192830,1,1,NULL,'casePre1546414192830','','2024-11-28 02:10:39',NULL,0),(1738490311550,0,0,0,0,1560244940013,1,0,NULL,'casePost1560244940013','','2025-02-02 09:58:32',NULL,0),(1738490327734,0,0,0,0,0,1,0,NULL,'globalPost0','if (data != null) {\n delete data[\"sql:generate|cache|execute|maxExecute\"]\n}\n','2025-02-02 09:58:48',NULL,0),(1738490404341,0,0,0,0,0,1,1,NULL,'globalPre0','req[\'@explain\'] = true','2025-02-02 10:00:04',NULL,0),(1738490404342,82001,0,0,0,0,1,1,NULL,'','','2025-03-11 08:54:24',NULL,0);
52+
/*!40000 ALTER TABLE `script` ENABLE KEYS */;
5253
UNLOCK TABLES;
5354
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
5455

@@ -60,4 +61,4 @@ UNLOCK TABLES;
6061
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6162
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6263

63-
-- Dump completed on 2024-06-16 0:37:30
64+
-- Dump completed on 2025-12-07 19:38:59

0 commit comments

Comments
 (0)