GeezerVison is showing github.com — MySQL:更新表 · Caesarxp/APIJSON@5785a0e
File tree
Expand file treeCollapse file tree
Open diff view settings
Expand file treeCollapse file tree
Open diff view settings
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Access.sql +1-1Lines changed: 1 addition & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -59,4 +59,4 @@ UNLOCK TABLES; |
59 | 59 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
60 | 60 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
61 | 61 |
|
62 | | --- Dump completed on 2018-12-10 23:39:35 |
| 62 | +-- Dump completed on 2018-12-27 23:20:18 |
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Comment.sql +3-3Lines changed: 3 additions & 3 deletions Large diffs are not rendered by default.
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Document.sql +2-2Lines changed: 2 additions & 2 deletions Large diffs are not rendered by default.
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Function.sql +1-1Lines changed: 1 addition & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -53,4 +53,4 @@ UNLOCK TABLES; |
53 | 53 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
54 | 54 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
55 | 55 |
|
56 | | --- Dump completed on 2018-12-10 23:39:30 |
| 56 | +-- Dump completed on 2018-12-27 23:20:14 |
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Login.sql +1-1Lines changed: 1 addition & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -50,4 +50,4 @@ UNLOCK TABLES; |
50 | 50 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
51 | 51 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
52 | 52 |
|
53 | | --- Dump completed on 2018-12-10 23:39:39 |
| 53 | +-- Dump completed on 2018-12-27 23:20:21 |
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Moment.sql +2-2Lines changed: 2 additions & 2 deletions Large diffs are not rendered by default.
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Praise.sql +1-1Lines changed: 1 addition & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -50,4 +50,4 @@ UNLOCK TABLES; |
50 | 50 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
51 | 51 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
52 | 52 |
|
53 | | --- Dump completed on 2018-12-10 23:39:37 |
| 53 | +-- Dump completed on 2018-12-27 23:20:19 |
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Request.sql +2-2Lines changed: 2 additions & 2 deletions | Original file line number | Diff line number | Diff line change |
|---|
@@ -27,7 +27,7 @@ CREATE TABLE `Request` ( |
27 | 27 | `version` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'GET,HEAD可用任意结构访问任意开放内容,不需要这个字段。\n其它的操作因为写入了结构和内容,所以都需要,按照不同的version选择对应的structure。\n\n自动化版本管理:\nRequest JSON最外层可以传 “version”:Integer 。\n1.未传或 <= 0,用最新版。 “@order”:”version-“\n2.已传且 > 0,用version以上的可用版本的最低版本。 “@order”:”version+”, “version{}”:”>={version}”', |
28 | 28 | `method` varchar(10) DEFAULT 'GETS' COMMENT '只限于GET,HEAD外的操作方法。', |
29 | 29 | `tag` varchar(20) NOT NULL COMMENT '标签', |
30 | | - `structure` json NOT NULL COMMENT '结构', |
| 30 | + `structure` json NOT NULL COMMENT '结构。\nTODO 里面的 PUT 改为 UPDATE,避免和请求 PUT 搞混。', |
31 | 31 | `detail` varchar(10000) DEFAULT NULL COMMENT '详细说明', |
32 | 32 | `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期', |
33 | 33 | PRIMARY KEY (`id`) |
@@ -53,4 +53,4 @@ UNLOCK TABLES; |
53 | 53 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
54 | 54 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
55 | 55 |
|
56 | | --- Dump completed on 2018-12-10 23:39:34 |
| 56 | +-- Dump completed on 2018-12-27 23:20:17 |
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Response.sql +1-1Lines changed: 1 addition & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -53,4 +53,4 @@ UNLOCK TABLES; |
53 | 53 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
54 | 54 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
55 | 55 |
|
56 | | --- Dump completed on 2018-12-10 23:39:40 |
| 56 | +-- Dump completed on 2018-12-27 23:20:22 |
Collapse file
Copy file name to clipboardExpand all lines: MySQL/sys_Test.sql +1-1Lines changed: 1 addition & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -47,4 +47,4 @@ UNLOCK TABLES; |
47 | 47 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
48 | 48 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
49 | 49 |
|
50 | | --- Dump completed on 2018-12-10 23:39:38 |
| 50 | +-- Dump completed on 2018-12-27 23:20:20 |