数据库审核平台Yearning

create database Yearning DEFAULT CHARACTER SET utf8mb4;


create user admin identified by '7iMavUCOnI8N';
GRANT ALL PRIVILEGES ON Yearning.* TO 'admin'@'%' identified with mysql_native_password by '7iMavUCOnI8N';
flush privileges;

## 安装指南 https://guide.yearning.io

## 构建镜像
docker build -t  yearning:lts . -f Dockerfile

## 启动
docker run -d --name yearning  \
  -p11110:8000 \
  -e MYSQL_DB=Yearning \
  -e MYSQL_USER=admin -e MYSQL_ADDR=172.16.100.138:3306 -e MYSQL_PASSWORD=xxxxxx \
  yearning:lts

强制表必须拥有表注释
强制主键名称为ID
允许单个工单提交多条DDL语句
允许使用after/first
强制DML语句必须拥有where条件
DML最大影响行数 0
  
create/alter 表或字段时允许的Collate范围。多个请使用逗号进行分割  utf8mb4_general_ci