GeezerVison

The World Wide Web, restored to 800 pixels of glory.

GeezerVison is showing github.com — Server: 打包 apijson-orm-3.6.5.jar；MySQL: 更新表把单个表文件单独放到 single 目录，避免和 s… · anonymousch/APIJSON@d265e07

File tree

Expand file treeCollapse file tree

Open diff view settings

Filter options

APIJSON-Java-Server/APIJSONBoot/libs
- apijson-orm-3.6.5.jar
MySQL

Expand file treeCollapse file tree

Open diff view settings

Collapse file

`‎…r/APIJSONBoot/libs/apijson-orm-3.6.1.jar‎ ‎…r/APIJSONBoot/libs/apijson-orm-3.6.5.jar‎APIJSON-Java-Server/APIJSONBoot/libs/apijson-orm-3.6.1.jar renamed to APIJSON-Java-Server/APIJSONBoot/libs/apijson-orm-3.6.5.jar` APIJSON-Java-Server/APIJSONBoot/libs/apijson-orm-3.6.1.jar renamed to APIJSON-Java-Server/APIJSONBoot/libs/apijson-orm-3.6.5.jar

Copy file name to clipboard

256 KB

Binary file not shown.

Collapse file

`‎MySQL/single/sys_Access.sql‎`

Copy file name to clipboard

+64Lines changed: 64 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,64 @@`
	`1`	`+-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)`
	`2`	`+--`
	`3`	`+-- Host: 47.98.196.224 Database: sys`
	`4`	`+-- ------------------------------------------------------`
	`5`	`+-- Server version 5.7.19-log`
	`6`	`+`
	`7`	`+/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;`
	`8`	`+/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;`
	`9`	`+/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;`
	`10`	`+/!40101 SET NAMES utf8 /;`
	`11`	`+/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;`
	`12`	`+/!40103 SET TIME_ZONE='+00:00' /;`
	`13`	`+/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;`
	`14`	`+/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;`
	`15`	`+/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;`
	`16`	`+/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;`
	`17`	`+`
	`18`	`+--`
	`19`	+-- Table structure for table `Access`
	`20`	`+--`
	`21`	`+`
	`22`	+DROP TABLE IF EXISTS `Access`;
	`23`	`+/!40101 SET @saved_cs_client = @@character_set_client /;`
	`24`	`+/!40101 SET character_set_client = utf8 /;`
	`25`	+CREATE TABLE `Access` (
	`26`	+ `id` bigint(15) NOT NULL AUTO_INCREMENT,
	`27`	+ `debug` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否为调试表，只允许在开发环境使用，测试和线上环境禁用',
	`28`	+ `schema` varchar(20) NOT NULL DEFAULT 'sys' COMMENT '集合空间',
	`29`	+ `name` varchar(50) NOT NULL COMMENT '实际表名，例如 apijson_user',
	`30`	+ `alias` varchar(20) DEFAULT NULL COMMENT '外部调用的表别名，例如 User',
	`31`	+ `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 更简单，反正是开发内部用，不需要复杂查询。',
	`32`	+ `head` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 head 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
	`33`	+ `gets` varchar(100) NOT NULL DEFAULT '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 gets 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
	`34`	+ `heads` varchar(100) NOT NULL DEFAULT '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 heads 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
	`35`	+ `post` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 post 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
	`36`	+ `put` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 put 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
	`37`	+ `delete` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 delete 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
	`38`	+ `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	`39`	+ PRIMARY KEY (`id`),
	`40`	+ UNIQUE KEY `name_UNIQUE` (`name`),
	`41`	+ UNIQUE KEY `alias_UNIQUE` (`alias`)
	`42`	`+) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='权限配置';`
	`43`	`+/!40101 SET character_set_client = @saved_cs_client /;`
	`44`	`+`
	`45`	`+--`
	`46`	+-- Dumping data for table `Access`
	`47`	`+--`
	`48`	`+`
	`49`	+LOCK TABLES `Access` WRITE;
	`50`	+/!40000 ALTER TABLE `Access` DISABLE KEYS /;
	`51`	+INSERT INTO `Access` VALUES (1,1,'sys','Access',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[]','[]','[]','2019-07-21 12:21:36'),(2,1,'sys','Table',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[]','[]','[]','2018-11-28 16:38:14'),(3,1,'sys','Column',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[]','[]','[]','2018-11-28 16:38:14'),(4,1,'sys','Function',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[]','[]','[]','2018-11-28 16:38:15'),(5,1,'sys','Request',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[]','[]','[]','2018-11-28 16:38:14'),(6,1,'sys','Response',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[]','[]','[]','2018-11-28 16:38:15'),(7,1,'sys','Document',NULL,'[\"LOGIN\", \"ADMIN\"]','[\"LOGIN\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','2018-11-28 16:38:15'),(8,1,'sys','TestRecord',NULL,'[\"LOGIN\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','2018-11-28 16:38:15'),(9,0,'sys','Test',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[]','[]','[]','2018-11-28 16:38:15'),(10,0,'sys','Login',NULL,'[]','[]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[ \"ADMIN\"]','[ \"ADMIN\"]','[\"ADMIN\"]','2018-11-28 16:29:48'),(11,0,'sys','Verify',NULL,'[]','[]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[ \"ADMIN\"]','[\"ADMIN\"]','2018-11-28 16:29:48'),(12,0,'sys','apijson_user','User','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','2018-11-28 16:28:53'),(13,0,'sys','apijson_privacy','Privacy','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','2018-11-28 16:29:48'),(14,0,'sys','Moment',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','2018-11-28 16:29:19'),(15,0,'sys','Comment',NULL,'[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','[\"OWNER\", \"ADMIN\"]','2018-11-28 16:29:19');
	`52`	+/!40000 ALTER TABLE `Access` ENABLE KEYS /;
	`53`	`+UNLOCK TABLES;`
	`54`	`+/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;`
	`55`	`+`
	`56`	`+/!40101 SET SQL_MODE=@OLD_SQL_MODE /;`
	`57`	`+/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;`
	`58`	`+/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;`
	`59`	`+/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;`
	`60`	`+/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;`
	`61`	`+/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;`
	`62`	`+/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;`
	`63`	`+`
	`64`	`+-- Dump completed on 2019-07-24 0:42:48`

Collapse file

`‎MySQL/sys_Comment.sql‎ ‎MySQL/single/sys_Comment.sql‎MySQL/sys_Comment.sql renamed to MySQL/single/sys_Comment.sql`

Copy file name to clipboardExpand all lines: MySQL/single/sys_Comment.sql

+2-2Lines changed: 2 additions & 2 deletions

Large diffs are not rendered by default.

Collapse file

`‎MySQL/sys_Document.sql‎ ‎MySQL/single/sys_Document.sql‎MySQL/sys_Document.sql renamed to MySQL/single/sys_Document.sql`

Copy file name to clipboardExpand all lines: MySQL/single/sys_Document.sql

+1-1Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -54,4 +54,4 @@ UNLOCK TABLES;`
`54`	`54`	`/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;`
`55`	`55`	`/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;`
`56`	`56`
`57`		`--- Dump completed on 2019-06-09 23:28:22`
	`57`	`+-- Dump completed on 2019-07-24 0:42:53`

Collapse file

`‎MySQL/sys_Function.sql‎ ‎MySQL/single/sys_Function.sql‎MySQL/sys_Function.sql renamed to MySQL/single/sys_Function.sql`

Copy file name to clipboardExpand all lines: MySQL/single/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 2019-06-09 23:28:09`
	`56`	`+-- Dump completed on 2019-07-24 0:42:43`

Collapse file

`‎MySQL/sys_Login.sql‎ ‎MySQL/single/sys_Login.sql‎MySQL/sys_Login.sql renamed to MySQL/single/sys_Login.sql`

Copy file name to clipboardExpand all lines: MySQL/single/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 2019-06-09 23:28:21`
	`53`	`+-- Dump completed on 2019-07-24 0:42:52`

Collapse file

`‎MySQL/single/sys_Moment.sql‎`

Copy file name to clipboardExpand all lines: MySQL/single/sys_Moment.sql

+56Lines changed: 56 additions & 0 deletions

Large diffs are not rendered by default.

Collapse file

`‎MySQL/sys_Praise.sql‎ ‎MySQL/single/sys_Praise.sql‎MySQL/sys_Praise.sql renamed to MySQL/single/sys_Praise.sql`

Copy file name to clipboardExpand all lines: MySQL/single/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 2019-06-09 23:28:18`
	`53`	`+-- Dump completed on 2019-07-24 0:42:50`

Collapse file

`‎MySQL/sys_Request.sql‎ ‎MySQL/single/sys_Request.sql‎MySQL/sys_Request.sql renamed to MySQL/single/sys_Request.sql`

Copy file name to clipboardExpand all lines: MySQL/single/sys_Request.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 2019-06-09 23:28:14`
	`56`	`+-- Dump completed on 2019-07-24 0:42:47`

Collapse file

`‎MySQL/sys_Response.sql‎ ‎MySQL/single/sys_Response.sql‎MySQL/sys_Response.sql renamed to MySQL/single/sys_Response.sql`

Copy file name to clipboardExpand all lines: MySQL/single/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 2019-06-09 23:28:22`
	`56`	`+-- Dump completed on 2019-07-24 0:42:54`

0 commit comments

Comments

0 (0)

You are visitor 01402520 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.