• Home
• com.github.yogurt-dev
• sample
• 2.0.0
• source code
• V1__Create_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__Create_Test.sql Maven / Gradle / Ivy

CREATE TABLE `test` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `type` enum('N','Y') DEFAULT NULL COMMENT '类型',
  `time` datetime DEFAULT NULL COMMENT '日期',
  `creator_id` bigint NOT NULL DEFAULT '0' COMMENT '创建人ID',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifier_id` bigint DEFAULT NULL COMMENT '修改人ID',
  `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;