erd-apis: erd-apis为ERD-ONLINE配套的服务，采用的是spring-boot开发，部署简单。https://gitee.com/MARTIN-88/erd-online

# erd-apis
erd-apis为[ERD-ONLINE](https://gitee.com/MARTIN-88/erd-online)配套的服务，采用的是spring-boot开发，部署简单。

详细使用方法请见：https://gitee.com/MARTIN-88/erd-online

## 快速启动
#### 依赖jar包安装
由于使用到的pdman-v1.0.0.jar，在中央仓库不存在，所以建议手动安装在本地maven仓库中。
安装脚本为：
```
mvn install:install-file -Dfile=/home/lyf/git/erd-apis/pdman-v1.0.0.jar -DgroupId=gcn.fisok -DartifactId=pdman -Dversion=v1.0.0 -Dpackaging=jar
```
#### 执行编译打包
```
mvn clean install 
```

#### 数据库配置
1. 在mysql中创建名字为erd数据库
```
CREATE SCHEMA `erd` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ;
```
2. 在创建好的erd库上执行初始化sql语句（项目根目录下erd-apis.sql）
```
--
-- Table structure for table `db_change`
--
DROP TABLE IF EXISTS `db_change`;

CREATE TABLE `db_change` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `baseVersion` bit(1) DEFAULT NULL,
  `changes` longblob COMMENT '版本变动',
  `projectId` varchar(64) DEFAULT NULL COMMENT 'project主键',
  `projectJSON` longblob COMMENT 'project配置',
  `version` varchar(20) DEFAULT NULL COMMENT '版本号',
  `versionDate` varchar(20) DEFAULT NULL COMMENT '版本创建时间',
  `versionDesc` varchar(500)  DEFAULT NULL COMMENT '版本描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  ROW_FORMAT=DYNAMIC COMMENT='版本表';

INSERT INTO `db_change` VALUES ('70f9a4895bf54e0fb0a683c953c3e85c',_binary '',_binary '[]','9f1705901517de8b86a176971d895696',_binary '{\"modules\":[{\"name\":\"EMR\",\"chnname\":\"电子病历\",\"entities\":[{\"title\":\"emr_user\",\"fields\":[{\"name\":\"REVISION\",\"type\":\"Integer\",\"remark\":\"\",\"chnname\":\"乐观锁\"},{\"name\":\"CREATED_BY\",\"type\":\"IdOrKey\",\"remark\":\"\",\"chnname\":\"创建人\"},{\"name\":\"CREATED_TIME\",\"type\":\"DateTime\",\"remark\":\"\",\"chnname\":\"创建时间\"},{\"name\":\"UPDATED_BY\",\"type\":\"IdOrKey\",\"remark\":\"\",\"chnname\":\"更新人\"},{\"name\":\"UPDATED_TIME\",\"type\":\"DateTime\",\"remark\":\"\",\"chnname\":\"更新时间\"},{\"name\":\"pkid\",\"type\":\"BigInt\",\"remark\":\"\",\"chnname\":\"自增主键\",\"pk\":true,\"notNull\":true,\"autoIncrement\":true},{\"name\":\"id\",\"type\":\"DefaultString\",\"remark\":\"雪花算法\",\"chnname\":\"业务主键\",\"notNull\":true}],\"indexs\":[],\"headers\":[{\"fieldName\":\"chnname\",\"relationNoShow\":false},{\"fieldName\":\"name\",\"relationNoShow\":false},{\"fieldName\":\"type\",\"relationNoShow\":false},{\"fieldName\":\"dataType\",\"relationNoShow\":true},{\"fieldName\":\"remark\",\"relationNoShow\":true},{\"fieldName\":\"pk\",\"relationNoShow\":false},{\"fieldName\":\"notNull\",\"relationNoShow\":true},{\"fieldName\":\"autoIncrement\",\"relationNoShow\":true},{\"fieldName\":\"defaultValue\",\"relationNoShow\":true},{\"fieldName\":\"relationNoShow\",\"relationNoShow\":true},{\"fieldName\":\"uiHint\",\"relationNoShow\":true}],\"chnname\":\"患者表\",\"remark\":\"患者基本信息\"}],\"graphCanvas\":{\"nodes\":[],\"edges\":[]},\"associations\":[]},{\"name\":\"EHR\",\"chnname\":\"健康档案\",\"entities\":[],\"graphCanvas\":{\"edges\":[]}}]}','V1.0.0','2021/10/1 23:47:51','初始版本号');
--
-- Table structure for table `db_version`
--
DROP TABLE IF EXISTS `db_version`;

CREATE TABLE `db_version` (
  `id` varchar(64) NOT NULL,
  `db_version` varchar(256) DEFAULT NULL,
  `version_desc` varchar(1024) DEFAULT NULL,
  `created_time` varchar(32) DEFAULT NULL,
  `project_id` varchar(64) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `db_version_project_uk` (`db_version`,`project_id`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;

CREATE TABLE `project` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `configJSON` blob COMMENT '配置JSON',
  `projectJSON` longblob COMMENT '项目JSON',
  `project_name` varchar(128) NOT NULL COMMENT '项目名称',
  `REVISION` int DEFAULT NULL COMMENT '乐观锁',
  `CREATED_BY` varchar(32) DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `UPDATED_BY` varchar(32) DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime DEFAULT NULL COMMENT '更新时间',
  `description` varchar(300) DEFAULT '在线多人协作数据库建模' COMMENT '项目介绍',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `project_project_name_uindex` (`project_name`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='PDMan全局配置表';

INSERT INTO `project` VALUES ('9f1705901517de8b86a176971d895696',_binary '{\"synchronous\":{\"upgradeType\":\"rebuild\",\"readDBType\":\"read\",\"sqlPath\":\"\"},\"exportSqlDefault\":{\"deleteTable\":false,\"createTable\":false,\"createIndex\":false,\"updateComment\":false}}',_binary '{\"modules\":[{\"name\":\"EMR\",\"chnname\":\"电子病历\",\"entities\":[{\"title\":\"emr_user\",\"fields\":[{\"name\":\"pkid\",\"type\":\"BigInt\",\"remark\":\"\",\"chnname\":\"自增主键\",\"pk\":true,\"notNull\":true,\"autoIncrement\":true},{\"name\":\"id\",\"type\":\"DefaultString\",\"remark\":\"雪花算法\",\"chnname\":\"业务主键\",\"notNull\":true},{\"name\":\"REVISION\",\"type\":\"Integer\",\"remark\":\"\",\"chnname\":\"乐观锁\"},{\"name\":\"CREATED_BY\",\"type\":\"IdOrKey\",\"remark\":\"\",\"chnname\":\"创建人\"},{\"name\":\"CREATED_TIME\",\"type\":\"DateTime\",\"remark\":\"\",\"chnname\":\"创建时间\"},{\"name\":\"UPDATED_BY\",\"type\":\"IdOrKey\",\"remark\":\"\",\"chnname\":\"更新人\"},{\"name\":\"UPDATED_TIME\",\"type\":\"DateTime\",\"remark\":\"\",\"chnname\":\"更新时间\"}],\"indexs\":[],\"headers\":[{\"fieldName\":\"chnname\",\"relationNoShow\":false},{\"fieldName\":\"name\",\"relationNoShow\":false},{\"fieldName\":\"type\",\"relationNoShow\":false},{\"fieldName\":\"dataType\",\"relationNoShow\":true},{\"fieldName\":\"remark\",\"relationNoShow\":true},{\"fieldName\":\"pk\",\"relationNoShow\":false},{\"fieldName\":\"notNull\",\"relationNoShow\":true},{\"fieldName\":\"autoIncrement\",\"relationNoShow\":true},{\"fieldName\":\"defaultValue\",\"relationNoShow\":true},{\"fieldName\":\"relationNoShow\",\"relationNoShow\":true},{\"fieldName\":\"uiHint\",\"relationNoShow\":true}],\"chnname\":\"患者表\",\"remark\":\"患者基本信息\"}],\"graphCanvas\":{\"nodes\":[],\"edges\":[]},\"associations\":[]},{\"name\":\"EHR\",\"chnname\":\"健康档案\",\"entities\":[],\"graphCanvas\":{\"edges\":[]}}],\"dataTypeDomains\":{\"datatype\":[{\"name\":\"默认字串\",\"code\":\"DefaultString\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"VARCHAR(32)\"},\"ORACLE\":{\"type\":\"NVARCHAR2(32)\"},\"SQLServer\":{\"type\":\"NVARCHAR(32)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(32)\"}}},{\"name\":\"标识号\",\"code\":\"IdOrKey\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"ORACLE\":{\"type\":\"VARCHAR2(32)\"},\"MYSQL\":{\"type\":\"VARCHAR(32)\"},\"SQLServer\":{\"type\":\"VARCHAR(32)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(32)\"}}},{\"name\":\"标识号-长\",\"code\":\"LongKey\",\"apply\":{\"MYSQL\":{\"type\":\"VARCHAR(64)\"},\"ORACLE\":{\"type\":\"VARCHAR2(64)\"},\"JAVA\":{\"type\":\"String\"},\"SQLServer\":{\"type\":\"VARCHAR(64)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(64)\"}}},{\"name\":\"名称\",\"code\":\"Name\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"VARCHAR(128)\"},\"ORACLE\":{\"type\":\"NVARCHAR2(128)\"},\"SQLServer\":{\"type\":\"NVARCHAR(128)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(128)\"}}},{\"name\":\"备注说明\",\"code\":\"Intro\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"VARCHAR(512)\"},\"ORACLE\":{\"type\":\"NVARCHAR2(512)\"},\"SQLServer\":{\"type\":\"NVARCHAR(512)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(512)\"}}},{\"name\":\"字串-短\",\"code\":\"ShortString\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"VARCHAR(128)\"},\"ORACLE\":{\"type\":\"NVARCHAR2(128)\"},\"SQLServer\":{\"type\":\"NVARCHAR(128)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(128)\"}}},{\"name\":\"字串-中\",\"code\":\"MiddleString\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"VARCHAR(1024)\"},\"ORACLE\":{\"type\":\"NVARCHAR2(1024)\"},\"SQLServer\":{\"type\":\"NVARCHAR(1024)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(1024)\"}}},{\"name\":\"字串-长\",\"code\":\"LongString\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"ORACLE\":{\"type\":\"NVARCHAR2(3072)\"},\"MYSQL\":{\"type\":\"VARCHAR(3072)\"},\"SQLServer\":{\"type\":\"NVARCHAR(3072)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(3072)\"}}},{\"name\":\"大文本\",\"code\":\"LongText\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"TEXT\"},\"ORACLE\":{\"type\":\"CLOB\"},\"SQLServer\":{\"type\":\"NTEXT\"},\"PostgreSQL\":{\"type\":\"TEXT\"}}},{\"name\":\"小数\",\"code\":\"Double\",\"apply\":{\"JAVA\":{\"type\":\"Double\"},\"MYSQL\":{\"type\":\"DECIMAL(32,10)\"},\"ORACLE\":{\"type\":\"NUMBER(32,10)\"},\"SQLServer\":{\"type\":\"DECIMAL(32,10)\"},\"PostgreSQL\":{\"type\":\"DECIMAL(32,10)\"}}},{\"name\":\"比例\",\"code\":\"Ratio\",\"apply\":{\"MYSQL\":{\"type\":\"DECIMAL(4,2)\"},\"JAVA\":{\"type\":\"Double\"},\"ORACLE\":{\"type\":\"NUMBER(4,2)\"},\"SQLServer\":{\"type\":\"DECIMAL(4,2)\"},\"PostgreSQL\":{\"type\":\"DECIMAL(4,2)\"}}},{\"name\":\"整数\",\"code\":\"Integer\",\"apply\":{\"JAVA\":{\"type\":\"Integer\"},\"MYSQL\":{\"type\":\"INT\"},\"ORACLE\":{\"type\":\"INT\"},\"SQLServer\":{\"type\":\"INT\"},\"PostgreSQL\":{\"type\":\"INT\"}}},{\"name\":\"大整数\",\"code\":\"BigInt\",\"apply\":{\"MYSQL\":{\"type\":\"BIGINT\"},\"JAVA\":{\"type\":\"Long\"},\"ORACLE\":{\"type\":\"NUMBER\"},\"SQLServer\":{\"type\":\"BIGINT\"},\"PostgreSQL\":{\"type\":\"BIGINT\"}}},{\"name\":\"金额\",\"code\":\"Money\",\"apply\":{\"JAVA\":{\"type\":\"Double\"},\"MYSQL\":{\"type\":\"DECIMAL(32,8)\"},\"ORACLE\":{\"type\":\"NUMBER(32,8)\"},\"SQLServer\":{\"type\":\"DECIMAL(32,8)\"},\"PostgreSQL\":{\"type\":\"DECIMAL(32,8)\"}}},{\"name\":\"是否\",\"code\":\"YesNo\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"VARCHAR(1)\"},\"ORACLE\":{\"type\":\"VARCHAR2(1)\"},\"SQLServer\":{\"type\":\"VARCHAR(1)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(1)\"}}},{\"name\":\"数据字典\",\"code\":\"Dict\",\"apply\":{\"JAVA\":{\"type\":\"String\"},\"MYSQL\":{\"type\":\"VARCHAR(32)\"},\"ORACLE\":{\"type\":\"VARCHAR2(32)\"},\"SQLServer\":{\"type\":\"VARCHAR(32)\"},\"PostgreSQL\":{\"type\":\"VARCHAR(32)\"}}},{\"name\":\"日期\",\"code\":\"Date\",\"apply\":{\"JAVA\":{\"type\":\"Date\"},\"MYSQL\":{\"type\":\"DATE\"},\"ORACLE\":{\"type\":\"DATE\"},\"SQLServer\":{\"type\":\"DATE\"},\"PostgreSQL\":{\"type\":\"DATE\"}}},{\"name\":\"日期时间\",\"code\":\"DateTime\",\"apply\":{\"JAVA\":{\"type\":\"Date\"},\"MYSQL\":{\"type\":\"DATETIME\"},\"ORACLE\":{\"type\":\"DATE\"},\"SQLServer\":{\"type\":\"DATE\"},\"PostgreSQL\":{\"type\":\"DATE\"}}},{\"name\":\"单字符\",\"code\":\"Char\",\"apply\":{\"MYSQL\":{\"type\":\"CHAR(1)\"},\"ORACLE\":{\"type\":\"CHAR(1)\"},\"JAVA\":{\"type\":\"String\"},\"SQLServer\":{\"type\":\"CHAR(1)\"},\"PostgreSQL\":{\"type\":\"CHAR(1)\"}}},{\"name\":\"INT_10\",\"code\":\"INT_10\",\"apply\":{\"MYSQL\":{\"type\":\"INT(10)\"}}},{\"name\":\"VARCHAR_45\",\"code\":\"VARCHAR_45\",\"apply\":{\"MYSQL\":{\"type\":\"VARCHAR(45)\"}}}],\"database\":[{\"code\":\"MYSQL\",\"template\":\"DROP TABLE {{=it.entity.title}};\\n$blankline\\nCREATE TABLE {{=it.entity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.entity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}} {{= field.pk ? \'NOT NULL\' : \'\' }} COMMENT \'{{=it.func.join(field.chnname,field.remark,\';\')}}\' {{= index < it.entity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n) COMMENT = \'{{=it.func.join(it.entity.chnname,it.entity.remark,\';\') }}\'\",\"fileShow\":true,\"defaultDatabase\":true,\"createTableTemplate\":\"CREATE TABLE {{=it.entity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.entity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}} {{= field.notNull ? \'NOT NULL\' : \'\' }} {{= field.autoIncrement ? \'AUTO_INCREMENT\' : \'\' }} {{= field.defaultValue ? it.func.join(\'DEFAULT\',field.defaultValue,\' \') : \'\' }} COMMENT \'{{=it.func.join(field.chnname,field.remark,\' \')}}\' {{= index < it.entity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n) COMMENT = \'{{=it.func.join(it.entity.chnname,it.entity.remark,\' \') }}\';{{=it.separator}}\\n$blankline\\n\",\"deleteTableTemplate\":\"DROP TABLE {{=it.entity.title}};{{=it.separator}}/*SkipError*/\",\"rebuildTableTemplate\":\"create table ERD_UP_{{=it.oldEntity.title}}\\nas select * from {{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\n\\ndrop table {{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\n\\nCREATE TABLE {{=it.newEntity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.newEntity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}} {{= field.notNull ? \'NOT NULL\' : \'\' }} COMMENT \'{{=it.func.join(field.chnname,field.remark,\';\')}}\' {{= index < it.newEntity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n) COMMENT = \'{{=it.func.join(it.newEntity.chnname,it.newEntity.remark,\';\') }}\';{{=it.separator}}\\n$blankline\\n\\n{{ sameCols = it.func.intersect(it.newEntity.fields,it.oldEntity.fields) ;}}\\ninsert into {{=it.newEntity.title}}(\\n{{~sameCols:field:index}}\\n    {{=field.name}}{{? index<sameCols.length-1}},{{?}}\\n{{~}}\\n) \\nselect \\n{{~sameCols:field:index}}\\n    {{=field.name}}{{? index<sameCols.length-1}},{{?}}\\n{{~}}\\nfrom ERD_UP_{{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\n\\ndrop table ERD_UP_{{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\n{{~it.newEntity.indexs:index}}\\nALTER TABLE {{=it.newEntity.title}} ADD {{? index.isUnique}}UNIQUE{{??}}INDEX{{?}} {{=index.name}}({{=it.func.join(...index.fields,\',\')}});{{=it.separator}}\\n{{~}}\",\"createFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} ADD COLUMN {{=it.field.name}} {{=it.field.type}} {{? it.field.notNull}}NOT NULL{{?}} {{? it.field.defaultValue}}DEFAULT {{? null==it.field.defaultValue}}NULL{{??}}\'{{=it.field.defaultValue}}\'{{?}}{{?}} {{? it.field.autoIncrement}}AUTO_INCREMENT{{?}} {{? it.field.pk}}PRIMARY KEY{{?}} {{? it.field.chnname}}COMMENT \'{{=it.field.chnname}}\'{{?}} {{? it.field.addAfter}}AFTER {{=it.field.addAfter}}{{?}};{{=it.separator}}\",\"updateFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} MODIFY COLUMN {{=it.field.name}} {{=it.field.type}} {{? it.field.notNull}}NOT NULL{{?}} {{? it.field.defaultValue}}DEFAULT {{? null==it.field.defaultValue}}NULL{{??}}\'{{=it.field.defaultValue}}\'{{?}}{{?}} {{? it.field.autoIncrement}}AUTO_INCREMENT{{?}} {{? it.field.chnname}}COMMENT \'{{=it.field.chnname}}\'{{?}};{{=it.separator}}\",\"deleteFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} DROP {{=it.field.name}};{{=it.separator}}\",\"deleteIndexTemplate\":\"ALTER TABLE {{=it.entity.title}} DROP INDEX {{=it.index.name}};{{=it.separator}}\",\"createIndexTemplate\":\"ALTER TABLE {{=it.entity.title}} ADD {{? it.index.isUnique}}UNIQUE{{??}}INDEX{{?}} {{=it.index.name}}({{=it.func.join(...it.index.fields,\',\')}});{{=it.separator}}\",\"updateTableComment\":\"ALTER TABLE {{=it.entity.title}} COMMENT \'{{=it.entity.chnname}}\';{{=it.separator}}\"},{\"code\":\"ORACLE\",\"template\":\"DROP TABLE {{=it.entity.title}};{{=it.separator}}\\n$blankline\\nCREATE TABLE {{=it.entity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.entity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}}  {{= field.pk ? \'NOT NULL\' : \'\' }} {{= index < it.entity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n);{{=it.separator}}\\n$blankline\\nCOMMENT ON TABLE {{=it.entity.title}} IS \'{{=it.func.join(it.entity.chnname,it.entity.remark,\';\') }}\';{{=it.separator}}\\n{{~it.entity.fields:field:index}}\\nCOMMENT ON COLUMN {{=it.entity.title}}.{{=field.name}} IS \'{{=it.func.join(field.chnname,field.remark,\';\')}}\';{{=it.separator}}\\n{{~}}\",\"createTableTemplate\":\"CREATE TABLE {{=it.entity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.entity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}}{{? field.defaultValue}} DEFAULT {{=field.defaultValue}}{{?}}{{= field.notNull ? \' NOT NULL\' : \'\' }}{{= index < it.entity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n);{{=it.separator}}\\n$blankline\\n{{? it.entity.chnname || it.entity.remark}}COMMENT ON TABLE {{=it.entity.title}} IS {{? it.entity.remark}}\'{{=it.entity.remark}}\'{{??}}\'{{=it.entity.chnname}}\'{{?}};{{=it.separator}}{{?}}\\n{{~it.entity.fields:field:index}}\\n{{? field.chnname || field.remark}}COMMENT ON COLUMN {{=it.entity.title}}.{{=field.name}} IS {{? field.remark}}\'{{=field.remark}}\'{{??}}\'{{=field.chnname}}\'{{?}};{{=it.separator}}{{?}}\\n{{~}}\",\"deleteTableTemplate\":\"DROP TABLE {{=it.entity.title}};{{=it.separator}}/*SkipError*/\\r\\n$blankline\",\"rebuildTableTemplate\":\"CREATE TABLE ERD_UP_{{=it.oldEntity.title}}\\nAS SELECT * FROM {{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\nDROP TABLE {{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\nCREATE TABLE {{=it.newEntity.title}}(\\n{{ pkList = [] ; }}{{~it.newEntity.fields:field:index}}{{? field.pk }}{{ pkList.push(field.name) }}{{?}}    {{=field.name}} {{=field.type}}{{? field.defaultValue}} DEFAULT {{=field.defaultValue}}{{?}}{{= field.notNull ? \' NOT NULL\' : \'\' }}{{= index < it.newEntity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}{{? pkList.length >0 }}    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}}){{?}}\\n);{{=it.separator}}\\n$blankline\\n{{? it.newEntity.chnname || it.newEntity.remark}}COMMENT ON TABLE {{=it.newEntity.title}} IS {{? it.newEntity.remark}}\'{{=it.entity.remark}}\'{{??}}\'{{=it.newEntity.chnname}}\'{{?}};{{?}}{{=it.separator}}\\n{{~it.newEntity.fields:field:index}}\\n{{? field.chnname || field.remark}}COMMENT ON COLUMN {{=it.newEntity.title}}.{{=field.name}} IS {{? field.remark}}\'{{=field.remark}}\'{{??}}\'{{=field.chnname}}\'{{?}};{{?}}{{=it.separator}}\\n{{~}}\\n{{ sameCols = it.func.intersect(it.newEntity.fields,it.oldEntity.fields) ;}}\\n$blankline\\nINSERT INTO {{=it.newEntity.title}}(\\n{{~sameCols:field:index}}   {{=field.name}}{{? index<sameCols.length-1}},{{?}}\\n{{~}}) \\nSELECT\\n{{~sameCols:field:index}}   {{=field.name}}{{? index<sameCols.length-1}},{{?}}\\n{{~}}FROM ERD_UP_{{=it.oldEntity.title}};{{=it.separator}}\\n\\nDROP TABLE ERD_UP_{{=it.oldEntity.title}};{{=it.separator}}\\n{{~it.newEntity.indexs:index}}\\nCREATE{{? index.isUnique}} UNIQUE{{?}} INDEX {{=index.name}} ON {{=it.newEntity.title}}({{=it.func.join(index.fields,\',\')}});{{=it.separator}}\\n{{~}}\",\"createFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} ADD({{=it.field.name}} {{=it.field.type}}{{? it.field.defaultValue}} DEFAULT {{=it.field.defaultValue}}{{?}}{{? it.field.notNull}} NOT NULL{{?}});{{=it.separator}}\\r\\n{{? it.field.chnname || it.field.remark}}COMMENT ON COLUMN {{=it.entity.title}}.{{=it.field.name}} IS {{? it.field.remark}}\'{{=it.field.remark}}\'{{??}}\'{{=it.field.chnname}}\'{{?}};{{=it.separator}}{{?}}\\r\\n$blankline\",\"updateFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} MODIFY({{=it.field.name}} {{=it.field.type}}{{? it.field.defaultValue}} DEFAULT {{=it.field.defaultValue}}{{?}}{{? it.field.notNull}} NOT NULL{{?}});{{=it.separator}}\\r\\n{{? it.field.chnname || it.field.remark}}COMMENT ON COLUMN {{=it.entity.title}}.{{=it.field.name}} IS {{? it.field.remark}}\'{{=it.field.remark}}\'{{??}}\'{{=it.field.chnname}}\'{{?}};{{=it.separator}}{{=it.separator}}{{?}}\\r\\n$blankline\",\"deleteFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} DROP({{=it.field.name}});{{=it.separator}}\\r\\n$blankline\",\"deleteIndexTemplate\":\"DROP INDEX {{=it.entity.title}}.{{=it.index.name}};{{=it.separator}}\\r\\n$blankline\",\"createIndexTemplate\":\"CREATE{{? it.index.isUnique}} UNIQUE{{?}} INDEX {{=it.index.name}} ON {{=it.entity.title}}({{=it.func.join(it.index.fields,\',\')}});{{=it.separator}}\\r\\n$blankline\",\"updateTableComment\":\"{{? it.entity.chnname || it.entity.remark}}COMMENT ON TABLE {{=it.entity.title}} IS {{? it.entity.remark}}\'{{=it.entity.remark}}\'{{??}}\'{{=it.entity.chnname}}\'{{?}};{{=it.separator}}{{?}}\\r\\n$blankline\"},{\"code\":\"SQLServer\",\"createTableTemplate\":\"CREATE TABLE {{=it.entity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.entity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}} {{= field.notNull ? \'NOT NULL\' : \'\' }} {{= field.autoIncrement ? \'IDENTITY(1,1)\' : \'\' }} {{= field.defaultValue ? it.func.join(\'DEFAULT\',field.defaultValue,\' \') : \'\' }}  {{= index < it.entity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    CONSTRAINT PK_{{=it.entity.title}} PRIMARY KEY CLUSTERED ({{~pkList:pkName:i}}{{= pkName }} ASC {{= i<pkList.length-1 ? \',\' : \'\' }}{{~}}) ON [PRIMARY] \\n{{?}}\\n) ;{{=it.separator}}\\n\\n$blankline\\nEXECUTE sp_addextendedproperty N\'MS_Description\', \'{{= it.entity.chnname || it.entity.remark}}\', N\'user\', N\'dbo\', N\'table\', N\'{{=it.entity.title}}\', NULL, NULL;{{=it.separator}}\\n{{~it.entity.fields:field:index}}\\n{{? field.chnname || field.remark}}EXECUTE sp_addextendedproperty N\'MS_Description\', {{? field.remark}}\'{{=field.remark}}\'{{??}}\'{{=field.chnname}}\'{{?}}, N\'user\', N\'dbo\', N\'table\', N\'{{=it.entity.title}}\', N\'column\', N\'{{=field.name}}\';{{=it.separator}}{{?}}\\n{{~}}\\n\"},{\"code\":\"PostgreSQL\",\"template\":\"DROP TABLE {{=it.entity.title}};\\n$blankline\\nCREATE TABLE {{=it.entity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.entity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}} {{= field.pk ? \'NOT NULL\' : \'\' }} COMMENT \'{{=it.func.join(field.chnname,field.remark,\';\')}}\' {{= index < it.entity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n) COMMENT = \'{{=it.func.join(it.entity.chnname,it.entity.remark,\';\') }}\'\",\"createTableTemplate\":\"CREATE TABLE {{=it.entity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.entity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}}{{? field.defaultValue}} DEFAULT {{=field.defaultValue}}{{?}}{{= field.notNull ? \' NOT NULL\' : \'\' }}{{= index < it.entity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n);{{=it.separator}}\\n$blankline\\n{{? it.entity.chnname || it.entity.remark}}COMMENT ON TABLE {{=it.entity.title}} IS {{? it.entity.remark}}\'{{=it.entity.remark}}\'{{??}}\'{{=it.entity.chnname}}\'{{?}};{{=it.separator}}{{?}}\\n{{~it.entity.fields:field:index}}\\n{{? field.chnname || field.remark}}COMMENT ON COLUMN {{=it.entity.title}}.{{=field.name}} IS {{? field.remark}}\'{{=field.remark}}\'{{??}}\'{{=field.chnname}}\'{{?}};{{=it.separator}}{{?}}\\n{{~}}\",\"deleteTableTemplate\":\"DROP TABLE {{=it.entity.title}};{{=it.separator}}/*SkipError*/\",\"rebuildTableTemplate\":\"create table ERD_UP_{{=it.oldEntity.title}}\\nas select * from {{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\n\\ndrop table {{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\n\\nCREATE TABLE {{=it.newEntity.title}}(\\n{{ pkList = [] ; }}\\n{{~it.newEntity.fields:field:index}}\\n    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}\\n    {{=field.name}} {{=field.type}} {{= field.notNull ? \'NOT NULL\' : \'\' }} COMMENT \'{{=it.func.join(field.chnname,field.remark,\';\')}}\' {{= index < it.newEntity.fields.length-1 ? \',\' : ( pkList.length>0 ? \',\' :\'\' ) }}\\n{{~}}\\n{{? pkList.length >0 }}\\n    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? \',\' : \'\' }}{{~}})\\n{{?}}\\n) COMMENT = \'{{=it.func.join(it.newEntity.chnname,it.newEntity.remark,\';\') }}\';{{=it.separator}}\\n$blankline\\n\\n{{ sameCols = it.func.intersect(it.newEntity.fields,it.oldEntity.fields) ;}}\\ninsert into {{=it.newEntity.title}}(\\n{{~sameCols:field:index}}\\n    {{=field.name}}{{? index<sameCols.length-1}},{{?}}\\n{{~}}\\n) \\nselect \\n{{~sameCols:field:index}}\\n    {{=field.name}}{{? index<sameCols.length-1}},{{?}}\\n{{~}}\\nfrom ERD_UP_{{=it.oldEntity.title}};{{=it.separator}}\\n$blankline\\n\\ndrop table ERD_UP_{{=it.oldEntity.title}};{{=it.separator}}\",\"createFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} ADD COLUMN {{=it.field.name}} {{=it.field.type}} {{? it.field.notNull}}NOT NULL{{?}} {{? it.field.defaultValue}}DEFAULT {{? null==it.field.defaultValue}}NULL{{??}}\'{{=it.field.defaultValue}}\'{{?}}{{?}} {{? it.field.autoIncrement}}AUTO_INCREMENT{{?}} {{? it.field.pk}}PRIMARY KEY{{?}} {{? it.field.chnname}}COMMENT \'{{=it.field.chnname}}\'{{?}} {{? it.field.addAfter}}AFTER {{=it.field.addAfter}}{{?}};{{=it.separator}}\",\"updateFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} MODIFY COLUMN {{=it.field.name}} {{=it.field.type}} {{? it.field.notNull}}NOT NULL{{?}} {{? it.field.defaultValue}}DEFAULT {{? null==it.field.defaultValue}}NULL{{??}}\'{{=it.field.defaultValue}}\'{{?}}{{?}} {{? it.field.autoIncrement}}AUTO_INCREMENT{{?}} {{? it.field.chnname}}COMMENT \'{{=it.field.chnname}}\'{{?}};{{=it.separator}}\",\"deleteFieldTemplate\":\"ALTER TABLE {{=it.entity.title}} DROP {{=it.field.name}};{{=it.separator}}\",\"deleteIndexTemplate\":\"ALTER TABLE {{=it.entity.title}} DROP INDEX {{=it.index.name}};{{=it.separator}}\",\"createIndexTemplate\":\"ALTER TABLE {{=it.entity.title}} ADD {{? it.index.isUnique}}UNIQUE{{??}}INDEX{{?}} {{=it.index.name}}({{=it.func.join(...it.index.fields,\',\')}});{{=it.separator}}\",\"updateTableComment\":\"ALTER TABLE {{=it.entity.title}} COMMENT \'{{=it.entity.chnname}}\';{{=it.separator}}\"},{\"code\":\"JAVA\",\"template\":\"package group.rober.erd.{{=it.module.name}}.entity;\\n$blankline\\nimport javax.persistence.*;\\nimport java.io.Serializable;\\nimport java.util.Date;\\n$blankline\\n$blankline\\n\\n/** {{=it.entity.chnname}} */\\n@Table(name=\\\"{{=it.entity.title}}\\\")\\npublic class {{=it.func.camel(it.entity.title,true) }} implements Serializable,Cloneable{\\n{{~it.entity.fields:field:index}}\\n    /** {{=it.func.join(field.chnname,field.remark,\';\')}} */\\n    {{? field.pk }}\\n    @Id\\n    @GeneratedValue\\n    {{?}}\\n    private {{=field.type}} {{=it.func.camel(field.name,false)}} ;\\n{{~}}\\n$blankline\\n{{~it.entity.fields:field:index}}\\n    /** {{=it.func.join(field.chnname,field.remark,\';\')}} */\\n    public {{=field.type}} get{{=it.func.camel(field.name,true)}}(){\\n        return this.{{=it.func.camel(field.name,false)}};\\n    }\\n    /** {{=it.func.join(field.chnname,field.remark,\';\')}} */\\n    public void set{{=it.func.camel(field.name,true)}}({{=field.type}} {{= it.func.camel(field.name,false) }}){\\n        this.{{=it.func.camel(field.name,false)}} = {{= it.func.camel(field.name,false) }};\\n    }\\n{{~}}\\n}\",\"createTableTemplate\":\"package group.rober.erd.{{=it.module.name}}.entity;\\n$blankline\\nimport javax.persistence.*;\\nimport java.io.Serializable;\\nimport java.util.Date;\\n$blankline\\n$blankline\\n@Table(name=\\\"{{=it.entity.title}}\\\")\\npublic class {{=it.func.camel(it.entity.title,true) }} implements Serializable,Cloneable{\\n{{~it.entity.fields:field:index}}\\n    /** {{=it.func.join(field.chnname,field.remark,\';\')}} */\\n    {{? field.pk }}\\n    @Id\\n    @GeneratedValue\\n    {{?}}\\n    private {{=field.type}} {{=it.func.camel(field.name,false)}} ;\\n{{~}}\\n$blankline\\n{{~it.entity.fields:field:index}}\\n    /** {{=it.func.join(field.chnname,field.remark,\';\')}} */\\n    public {{=field.type}} get{{=it.func.camel(field.name,true)}}(){\\n        return this.{{=it.func.camel(field.name,false)}};\\n    }\\n    /** {{=it.func.join(field.chnname,field.remark,\';\')}} */\\n    public void set{{=it.func.camel(field.name,true)}}({{=field.type}} {{= it.func.camel(field.name,false) }}){\\n        this.{{=it.func.camel(field.name,false)}} = {{= it.func.camel(field.name,false) }};\\n    }\\n{{~}}\\n}\",\"deleteTableTemplate\":\"\",\"rebuildTableTemplate\":\"\",\"createFieldTemplate\":\"\",\"updateFieldTemplate\":\"\",\"deleteFieldTemplate\":\"\",\"deleteIndexTemplate\":\"\",\"createIndexTemplate\":\"\",\"updateTableComment\":\"\"}]},\"profile\":{\"defaultFields\":[{\"name\":\"REVISION\",\"type\":\"Integer\",\"remark\":\"\",\"chnname\":\"乐观锁\"},{\"name\":\"CREATED_BY\",\"type\":\"IdOrKey\",\"remark\":\"\",\"chnname\":\"创建人\"},{\"name\":\"CREATED_TIME\",\"type\":\"DateTime\",\"remark\":\"\",\"chnname\":\"创建时间\"},{\"name\":\"UPDATED_BY\",\"type\":\"IdOrKey\",\"remark\":\"\",\"chnname\":\"更新人\"},{\"name\":\"UPDATED_TIME\",\"type\":\"DateTime\",\"remark\":\"\",\"chnname\":\"更新时间\"}],\"defaultFieldsType\":\"1\",\"sqlConfig\":\"/*SQL@Run*/\",\"dbs\":[{\"name\":\"local-mysql\",\"defaultDB\":true,\"properties\":{\"driver_class_name\":\"com.mysql.jdbc.Driver\",\"url\":\"jdbc:mysql://127.0.0.1:3306/test?characterEncoding=UTF-8&useSSL=false&useUnicode=true&serverTimezone=UTC\",\"password\":\"123456\",\"username\":\"root\"}}],\"wordTemplateConfig\":\"\"}}','全民健康信息平台',NULL,NULL,NULL,NULL,NULL,'在线多人协作数据库建模');
--
-- Table structure for table `sys_log`
--

CREATE TABLE `sys_log` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` int DEFAULT NULL COMMENT '日志类型',
  `title` varchar(255) DEFAULT '' COMMENT '日志标题',
  `remote_addr` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
  `user_agent` varchar(1000)  DEFAULT NULL COMMENT '用户代理',
  `request_uri` varchar(255)  DEFAULT NULL COMMENT '请求URI',
  `method` varchar(10) DEFAULT NULL COMMENT '操作方式',
  `params` text  COMMENT '操作提交的数据',
  `body` varchar(400) DEFAULT NULL COMMENT '请求body体',
  `time` bigint DEFAULT NULL COMMENT '执行时间(ms)',
  `exception` text  COMMENT '异常信息',
  `tenant_id` int DEFAULT '0' COMMENT '所属租户',
  `del_flag` char(1)  DEFAULT '0' COMMENT '删除标识（0-正常,1-删除）',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `creator` varchar(45) DEFAULT NULL COMMENT '创建人',
  `updater` varchar(45) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sys_log_type` (`type`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='系统日志';
--
-- Table structure for table `sys_permission`
--

DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` varchar(64)  NOT NULL,
  `name` varchar(200) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `url` varchar(200)  NOT NULL,
  `pid` bigint DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `sys_permission_name_uindex` (`name`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `sys_permission` VALUES ('d96ea750-2ed0-11eb-b763-025041000001','ROLE_SYS_USER_ADD','USER_ADD','/sysUser/add',NULL),('d9724720-2ed0-11eb-b763-025041000001','ROLE_SYS_USER_DELETE','USER_DELETE','/sysUser/delete',NULL),('d9773434-2ed0-11eb-b763-025041000001','ROLE_SYS_USER_UPDATE','USER_UPDATE','/sysUser/update',NULL),('d97bfd05-2ed0-11eb-b763-025041000001','ROLE_SYS_USER_GET','USER_GET','/sysUser/get',NULL),('d9854338-2ed0-11eb-b763-025041000001','ROLE_SYS_USER_PAGE','USER_PAGE','/sysUser/page',NULL),('d989d558-2ed0-11eb-b763-025041000001','ROLE_SYS_USER_BIND_ROLE','USER_USER_BIND_ROLE','/sysUser/bindRole',NULL),('d98d767d-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_ADD','ROLE_ADD','/sysRole/add',NULL),('d991dba5-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_DELETE','ROLE_DELETE','/sysRole/delete',NULL),('d9957eb6-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_UPDATE','ROLE_UPDATE','/sysRole/update',NULL),('d9996d40-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_GET','ROLE_GET','/sysRole/get',NULL),('d99c6041-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_PAGE','ROLE_PAGE','/sysRole/page',NULL),('d99fcdc4-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_BIND_ROLE','ROLE_ROLE_BIND_ROLE','/sysRole/bindRole',NULL),('d9a34a0d-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_ALL','ROLE_ROLE_ALL','/sysRole/all',NULL),('d9a6dee8-2ed0-11eb-b763-025041000001','ROLE_SYS_ROLE_SAVE_PERMISSION','ROLE_ROLE_SAVE_PERMISSION','/sysRole/savePermission',NULL),('d9ab28a7-2ed0-11eb-b763-025041000001','ROLE_SYS_PERMISSION_ADD','PERMISSION_ADD','/sysPermission/add',NULL),('d9b02755-2ed0-11eb-b763-025041000001','ROLE_SYS_PERMISSION_DELETE','PERMISSION_DELETE','/sysPermission/delete',NULL),('d9b2fdff-2ed0-11eb-b763-025041000001','ROLE_SYS_PERMISSION_UPDATE','PERMISSION_UPDATE','/sysPermission/update',NULL),('d9b69505-2ed0-11eb-b763-025041000001','ROLE_SYS_PERMISSION_GET','PERMISSION_GET','/sysPermission/get',NULL),('d9b956f4-2ed0-11eb-b763-025041000001','ROLE_SYS_PERMISSION_PAGE','PERMISSION_PAGE','/sysPermission/page',NULL),('d9bd0c7c-2ed0-11eb-b763-025041000001','ROLE_SYS_PERMISSION_FETCH_PERMISSION','PERMISSION_FETCH_PERMISSION','/sysPermission/fetchPermission',NULL);

--
-- Table structure for table `sys_permission_role`
--

DROP TABLE IF EXISTS `sys_permission_role`;

CREATE TABLE `sys_permission_role` (
  `id` varchar(64) NOT NULL,
  `role_id` varchar(64) NOT NULL,
  `permission_id` varchar(64)  NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  ROW_FORMAT=DYNAMIC;

INSERT INTO `sys_permission_role` VALUES ('6cdeca87-2ee9-11eb-b763-025041000001','1','d9ab28a7-2ed0-11eb-b763-025041000001'),('6cded495-2ee9-11eb-b763-025041000001','1','d9b02755-2ed0-11eb-b763-025041000001'),('6cded4fe-2ee9-11eb-b763-025041000001','1','d9bd0c7c-2ed0-11eb-b763-025041000001'),('6cded52d-2ee9-11eb-b763-025041000001','1','d9b69505-2ed0-11eb-b763-025041000001'),('6cded557-2ee9-11eb-b763-025041000001','1','d9b956f4-2ed0-11eb-b763-025041000001'),('6cded577-2ee9-11eb-b763-025041000001','1','d9b2fdff-2ed0-11eb-b763-025041000001'),('6cded598-2ee9-11eb-b763-025041000001','1','d98d767d-2ed0-11eb-b763-025041000001'),('6cded5ba-2ee9-11eb-b763-025041000001','1','d9a34a0d-2ed0-11eb-b763-025041000001'),('6cded5db-2ee9-11eb-b763-025041000001','1','d99fcdc4-2ed0-11eb-b763-025041000001'),('6cded5fe-2ee9-11eb-b763-025041000001','1','d991dba5-2ed0-11eb-b763-025041000001'),('6cded61c-2ee9-11eb-b763-025041000001','1','d9996d40-2ed0-11eb-b763-025041000001'),('6cded63a-2ee9-11eb-b763-025041000001','1','d99c6041-2ed0-11eb-b763-025041000001'),('6cded658-2ee9-11eb-b763-025041000001','1','d9a6dee8-2ed0-11eb-b763-025041000001'),('6cded676-2ee9-11eb-b763-025041000001','1','d9957eb6-2ed0-11eb-b763-025041000001'),('6cded693-2ee9-11eb-b763-025041000001','1','d96ea750-2ed0-11eb-b763-025041000001'),('6cded6b1-2ee9-11eb-b763-025041000001','1','d989d558-2ed0-11eb-b763-025041000001'),('6cded6cf-2ee9-11eb-b763-025041000001','1','d9724720-2ed0-11eb-b763-025041000001'),('6cded6ed-2ee9-11eb-b763-025041000001','1','d9854338-2ed0-11eb-b763-025041000001'),('6cded70c-2ee9-11eb-b763-025041000001','1','d9773434-2ed0-11eb-b763-025041000001'),('6cded72e-2ee9-11eb-b763-025041000001','1','d97bfd05-2ed0-11eb-b763-025041000001'),('76632cf6-2eeb-11eb-b763-025041000001','2','d9996d40-2ed0-11eb-b763-025041000001'),('76639ec2-2eeb-11eb-b763-025041000001','2','d9b956f4-2ed0-11eb-b763-025041000001'),('76639f20-2eeb-11eb-b763-025041000001','2','d9854338-2ed0-11eb-b763-025041000001'),('76639f4c-2eeb-11eb-b763-025041000001','2','d97bfd05-2ed0-11eb-b763-025041000001'),('76639f92-2eeb-11eb-b763-025041000001','2','d99c6041-2ed0-11eb-b763-025041000001'),('76639fbb-2eeb-11eb-b763-025041000001','2','d9b69505-2ed0-11eb-b763-025041000001'),('76639fde-2eeb-11eb-b763-025041000001','2','d9a34a0d-2ed0-11eb-b763-025041000001'),('7a81b30f-2eeb-11eb-b763-025041000001','46614245-7e7f-4dff-83c7-48878eca10a8','d9b956f4-2ed0-11eb-b763-025041000001'),('7a81b422-2eeb-11eb-b763-025041000001','46614245-7e7f-4dff-83c7-48878eca10a8','d99c6041-2ed0-11eb-b763-025041000001'),('7a81b45d-2eeb-11eb-b763-025041000001','46614245-7e7f-4dff-83c7-48878eca10a8','d9854338-2ed0-11eb-b763-025041000001'),('7a81b487-2eeb-11eb-b763-025041000001','46614245-7e7f-4dff-83c7-48878eca10a8','d9a34a0d-2ed0-11eb-b763-025041000001');
--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(64) NOT NULL,
  `name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `sys_role_name_uindex` (`name`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `sys_role` VALUES ('1','ADMIN'),('2','DBA'),('46614245-7e7f-4dff-83c7-48878eca10a8','DEV');
--
-- Table structure for table `sys_role_user`
--

DROP TABLE IF EXISTS `sys_role_user`;

CREATE TABLE `sys_role_user` (
  `id` varchar(64) NOT NULL,
  `sys_user_id` varchar(64) NOT NULL,
  `sys_role_id` varchar(64) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `sys_role_user` VALUES ('4c1f36f9-22d4-11ec-b906-64006a7f3c9e','5bec4b35-c70c-4229-8d02-4eaee0c7dcd2','1'),('ada85dc5-2e2c-11eb-b763-025041000001','2','2'),('b9b551b8-22d3-11ec-b906-64006a7f3c9e','c0345a99-2a79-4e68-a5b4-1126d3c1c9a1','1'),('c0e9da59-22d3-11ec-b906-64006a7f3c9e','8b7535ac-5706-4d96-a947-73bc724f2f95','1'),('c858c9a6-22d3-11ec-b906-64006a7f3c9e','4e2cab43-ac69-4e2b-b5d1-b24da797ab06','1'),('f9196740-2ece-11eb-b763-025041000001','1','1'),('f94a9c26-2e2d-11eb-b763-025041000001','7154fe03-b09f-474b-876c-8d1a5330fd4a','46614245-7e7f-4dff-83c7-48878eca10a8');
--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user` (
  `id` varchar(64) NOT NULL,
  `username` varchar(200)  NOT NULL,
  `password` varchar(200)  NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `sys_user_username_uindex` (`username`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `sys_user` VALUES ('1','admin','{noop}admin'),('2','dba','{noop}dba'),('4e2cab43-ac69-4e2b-b5d1-b24da797ab06','liuyf3','{noop}erd'),('5bec4b35-c70c-4229-8d02-4eaee0c7dcd2','zhuwp','{noop}erd'),('7154fe03-b09f-474b-876c-8d1a5330fd4a','dev','{noop}dev');

```
3. 修改项目配置文件application.yml,主要调整数据源配置项
```
spring:
  application:
    name: erd-apis
  datasource:
    ## 这里的url地址修改为自己数据库的连接地址即可
    url: jdbc:mysql://127.0.0.1:3306/erd?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8
    type: com.zaxxer.hikari.HikariDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root ## 修改为自己的数据库用户名
    password: 123456 ## 修改为自己数据库的密码
```

木木/erd-apis

简介

发行版

贡献者

近期动态

木木/erd-apis .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

木木/erd-apis