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