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

MySQL:更新表 · pythonzz/APIJSON@a54385c · GitHub

  1. pythonzz
  2. APIJSON

Repository navigation

Commit a54385c

Browse files
TommyLemon
committed
MySQL:更新表
1 parent 096c902 commit a54385c

15 files changed

Lines changed: 53 additions & 53 deletions

‎MySQL/sys_Access.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -24,7 +24,7 @@ DROP TABLE IF EXISTS `Access`;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Access` (
2626
`id` bigint(15) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
27-
`schema` varchar(20) NOT NULL DEFAULT 'sys',
27+
`schema` varchar(20) NOT NULL DEFAULT 'sys' COMMENT '集合空间',
2828
`name` varchar(50) NOT NULL COMMENT '实际表名，例如 apijson_user',
2929
`alias` varchar(20) DEFAULT NULL COMMENT '外部调用的表别名，例如 User',
3030
`get` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 get 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]\n用 JSON 类型不能设置默认值，反正权限对应的需求是明确的，也不需要自动转 JSONArray。',
@@ -34,7 +34,7 @@ CREATE TABLE `Access` (
3434
`post` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 post 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
3535
`put` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 put 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
3636
`delete` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 delete 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
37-
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
37+
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
3838
PRIMARY KEY (`id`),
3939
UNIQUE KEY `name_UNIQUE` (`name`)
4040
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='权限配置';
@@ -59,4 +59,4 @@ UNLOCK TABLES;
5959
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6060
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6161

62-
-- Dump completed on 2018-11-29 0:48:55
62+
-- Dump completed on 2018-12-10 23:39:35

‎MySQL/sys_Comment.sql‎

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

‎MySQL/sys_Document.sql‎

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

‎MySQL/sys_Function.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
22
--
3-
-- Host: localhost Database: sys
3+
-- Host: 47.98.196.224 Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.17
5+
-- Server version 5.7.19-log
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -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 2018-11-11 4:18:27
56+
-- Dump completed on 2018-12-10 23:39:30

‎MySQL/sys_Login.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
22
--
3-
-- Host: localhost Database: sys
3+
-- Host: 47.98.196.224 Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.17
5+
-- Server version 5.7.19-log
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -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 2018-11-11 4:18:31
53+
-- Dump completed on 2018-12-10 23:39:39

‎MySQL/sys_Moment.sql‎

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

‎MySQL/sys_Praise.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
22
--
3-
-- Host: localhost Database: sys
3+
-- Host: 47.98.196.224 Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.17
5+
-- Server version 5.7.19-log
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -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 2018-11-11 4:18:30
53+
-- Dump completed on 2018-12-10 23:39:37

‎MySQL/sys_Request.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
22
--
3-
-- Host: localhost Database: sys
3+
-- Host: 47.98.196.224 Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.17
5+
-- Server version 5.7.19-log
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -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 2018-11-11 4:18:29
56+
-- Dump completed on 2018-12-10 23:39:34

‎MySQL/sys_Response.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
22
--
3-
-- Host: localhost Database: sys
3+
-- Host: 47.98.196.224 Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.17
5+
-- Server version 5.7.19-log
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -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 2018-11-11 4:18:32
56+
-- Dump completed on 2018-12-10 23:39:40

‎MySQL/sys_Test.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
22
--
3-
-- Host: localhost Database: sys
3+
-- Host: 47.98.196.224 Database: sys
44
-- ------------------------------------------------------
5-
-- Server version 5.7.17
5+
-- Server version 5.7.19-log
66

77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
88
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -47,4 +47,4 @@ UNLOCK TABLES;
4747
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4848
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
4949

50-
-- Dump completed on 2018-11-11 4:18:31
50+
-- Dump completed on 2018-12-10 23:39:38

0 commit comments

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