FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

MySQL：更新表 · APIJSON/APIJSON-Demo@67ae977 · GitHub

/ APIJSON-Demo Public

Commit 67ae977

Browse files
TommyLemon
committed
MySQL：更新表
1 parent 318f5ae commit 67ae977

19 files changed

Lines changed: 69 additions & 169 deletions

‎MySQL/single/sys_Access.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -26,7 +26,7 @@ CREATE TABLE `Access` (
2626
`id` bigint(15) NOT NULL AUTO_INCREMENT,
2727
`debug` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否为调试表，只允许在开发环境使用，测试和线上环境禁用',
2828
`name` varchar(50) NOT NULL COMMENT '实际表名，例如 apijson_user',
29-
`alias` varchar(20) DEFAULT NULL COMMENT '外部调用的表别名，例如 User',
29+
`alias` varchar(20) DEFAULT NULL COMMENT '外部调用的表别名，例如 User，前端传参示例 { "User":{} }',
3030
`get` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 get 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]\n用 JSON 类型不能设置默认值，反正权限对应的需求是明确的，也不需要自动转 JSONArray。\nTODO: 直接 LOGIN,CONTACT,CIRCLE,OWNER 更简单，反正是开发内部用，不需要复杂查询。',
3131
`head` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 head 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
3232
`gets` varchar(100) NOT NULL DEFAULT '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 gets 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
@@ -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 2021-10-23 23:52:28
64+
-- Dump completed on 2022-01-05 1:40:51

‎MySQL/single/sys_Comment.sql‎

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

‎MySQL/single/sys_Document.sql‎

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

‎MySQL/single/sys_Function.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -58,4 +58,4 @@ UNLOCK TABLES;
5858
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5959
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6060

61-
-- Dump completed on 2021-10-23 23:51:50
61+
-- Dump completed on 2022-01-05 1:40:03

‎MySQL/single/sys_Login.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -50,4 +50,4 @@ UNLOCK TABLES;
5050
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5151
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5252

53-
-- Dump completed on 2021-10-23 23:52:32
53+
-- Dump completed on 2022-01-05 1:41:17

‎MySQL/single/sys_Method.sql‎

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

‎MySQL/single/sys_Moment.sql‎

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

‎MySQL/single/sys_Praise.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -50,4 +50,4 @@ UNLOCK TABLES;
5050
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5151
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5252

53-
-- Dump completed on 2021-10-23 23:52:29
53+
-- Dump completed on 2022-01-05 1:40:55

‎MySQL/single/sys_Random.sql‎

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

‎MySQL/single/sys_Request.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -53,4 +53,4 @@ UNLOCK TABLES;
5353
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5454
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5555

56-
-- Dump completed on 2021-10-23 23:52:27
56+
-- Dump completed on 2022-01-05 1:40:45

0 commit comments

Comments
 (0)
Back | FazBrowse Home | New Git URL