beego mysql 生成_beego 代码生成工具体验

# beego 代码生成工具体验

## 设计 MySQL 数据库

1. 通过 MySQL Workbench EER Digram 设计表和关系


2. 设置 MySQL Workbench 默认目标版本和 MySQL 服务器版本一致


3. 同步模型到数据库


```

-- MySQL Workbench Synchronization

-- Generated: 2020-06-26 12:07

-- Model: New Model

-- Version: 1.0

-- Project: Name of the project

-- Author: medea

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

CREATE TABLE IF NOT EXISTS `dotblog`.`users` (

`id` INT(11) NOT NULL COMMENT '用户ID',

`name` VARCHAR(255) NOT NULL COMMENT '用户名称',

`password` VARCHAR(255) NOT NULL COMMENT '用户密码',

`email` VARCHAR(255) NOT NULL COMMENT '用户邮箱',

`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '用户创建时间',

`avatar` MEDIUMTEXT NULL DEFAULT NULL COMMENT '用户头像',

PRIMARY KEY (`id`),

UNIQUE INDEX `username_UNIQUE` (`name` ASC),

UNIQUE INDEX `email_UNIQUE` (`email` ASC))

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8mb4

COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF N