• Home
• io.github.behappy-project
• behappy-canal-example
• 3.0.2
• source code
• V1_1__test.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.V1_1__test.sql Maven / Gradle / Ivy

create database if not exists test;
use test;
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(255)  NOT NULL DEFAULT '' COMMENT '用户名',
  `gender` varchar(255) NOT NULL DEFAULT 'MAN' COMMENT '用户性别',
  `country_id` int(11) NOT NULL DEFAULT 0 COMMENT '国家id',
  `flag` tinyint NOT NULL DEFAULT 1 COMMENT 'flag',
  `birthday` date  NULL DEFAULT NULL COMMENT '用户出生日期',
  `logo` longblob NOT NULL COMMENT 'logo',
  `create_time` timestamp NULL  DEFAULT CURRENT_TIMESTAMP COMMENT '用户创建时间',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4;