在idea中通过sql文件书写数据库表格

 

 

create database if not exists protege;
use protege;

create table if not exists `class_management`
(
    `id`          int unsigned                                            NOT NULL AUTO_INCREMENT COMMENT 'id',
    `ClassName`   varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类名',
    `projectName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类关联的工程名',
    `iconPath`    varchar(100)                                            NOT NULL COMMENT '类的图标路径',
    `description` varchar(200)                                            NOT NULL COMMENT '类的描述',
    `create_time` timestamp                                               NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp                                               NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `project_management_name_uindex` (`ClassName`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;