SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

create database test;
use test;

-- ----------------------------
-- Table structure for lcn_demo
-- ----------------------------
DROP TABLE IF EXISTS `lcn_demo`;
CREATE TABLE `lcn_demo` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `module` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

SET FOREIGN_KEY_CHECKS = 1;


-- 删除语句分析测试样例
DROP TABLE IF EXISTS `lcn_sql_parse_test1`;
CREATE TABLE `lcn_sql_parse_test1` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL comment '姓名',
  `sex` varchar(10)  DEFAULT NULL comment '性别',
  `job` varchar(32) DEFAULT NULL comment '工作',
  `home_address` varchar(128) default null comment '家庭住址',
  `age` int default null comment '年龄',
   `dept_id`     int default 0 not null comment '部门编号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

SET FOREIGN_KEY_CHECKS = 1;

DROP TABLE IF EXISTS `lcn_sql_parse_test2`;
CREATE TABLE `lcn_sql_parse_test2` (
    `id`        int(12) AUTO_INCREMENT ,
    `dept_name` varchar(32) null comment '部门名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

SET FOREIGN_KEY_CHECKS = 1;

DROP TABLE IF EXISTS `lcn_sql_parse_test3`;
create table `lcn_sql_parse_test3` (
    `id`           varbinary(32) not null,
    `name`         varchar(30)   null comment '姓名',
    `sex`          varchar(10)   null comment '性别',
    `job`          varchar(32)   null comment '工作',
    `home_address` varchar(128)  null comment '家庭住址',
    `age`          int           null comment '年龄',
    `dept_id`      int default 0 not null comment '部门编号',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

SET FOREIGN_KEY_CHECKS = 1;