iframe-proxy | Sunbelt Computer Software

57 lines (47 loc) · 1.81 KB

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
create database 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;

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

init.sql

Latest commit

History

init.sql

File metadata and controls