-- 创建数据库
CREATE DATABASE IF NOT EXISTS `database1`; 
USE `database1`;
drop table if exists table1, table2, table3, table4;

-- 创建表 table1
CREATE TABLE `table1` (
  `col1` char(18) NOT NULL COMMENT ' ',
  `col2` char(7) NOT NULL COMMENT ' ',
  `col3` char(8) NOT NULL COMMENT ' ',
  `col4` datetime DEFAULT NULL COMMENT ' ',
  `col5` char(6) DEFAULT NULL COMMENT ' ',
  `col6` datetime DEFAULT NULL COMMENT ' ',
  `col7` char(6) DEFAULT NULL COMMENT ' ',
  `col8` char(9) NOT NULL COMMENT ' ',
  `col9` decimal(5,4) DEFAULT NULL COMMENT ' ',
  `col10` varchar(10) NOT NULL COMMENT ' ',
  `col11` varchar(600) DEFAULT NULL COMMENT ' ',
  `col12` char(2) DEFAULT NULL COMMENT ' ',
  `col13` char(9) DEFAULT NULL COMMENT ' ',
  `col14` datetime DEFAULT NULL COMMENT ' ',
  `col15` char(9) DEFAULT NULL COMMENT ' ',
  `col16` char(8) DEFAULT NULL COMMENT ' ',
  `col17` char(25) DEFAULT NULL COMMENT ' ',
  `col18` datetime DEFAULT NULL COMMENT ' ',
  `col19` char(6) DEFAULT NULL COMMENT ' ',
  `col20` char(5) DEFAULT NULL COMMENT ' ',
  `col21` char(6) DEFAULT NULL COMMENT ' ',
  `col22` char(6) DEFAULT NULL COMMENT ' ',
  `col23` datetime DEFAULT NULL COMMENT ' ',
  `col24` char(6) DEFAULT NULL COMMENT ' ',
  `col25` char(5) DEFAULT NULL COMMENT ' ',
  `col26` datetime DEFAULT NULL COMMENT ' ',
  `col27` datetime DEFAULT NULL COMMENT ' ',
  `col28` char(2) DEFAULT NULL COMMENT ' ',
  PRIMARY KEY (`col1`,`col2`,`col3`,`col10`,`col8`) /*T![clustered_index] NONCLUSTERED */,
  KEY `index1` (`col8`,`col2`),
  KEY `index2` (`col3`),
  KEY `index3` (`col13`),
  KEY `index4` (`col25`),
  KEY `index5` (`col2`),
  KEY `index6` (`col23`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- 创建表 table2
CREATE TABLE `table2` (
  `col1` datetime NOT NULL COMMENT ' ',
  `col2` char(18) NOT NULL COMMENT ' ',
  `col3` char(9) NOT NULL COMMENT ' ',
  `col4` char(5) NOT NULL COMMENT ' ',
  `col5` varchar(150) DEFAULT NULL COMMENT ' ',
  `col6` varchar(600) DEFAULT NULL COMMENT ' ',
  `col7` decimal(19,3) DEFAULT NULL COMMENT ' ',
  `col8` varchar(5) DEFAULT NULL COMMENT ' ',
  `col9` char(1) DEFAULT NULL COMMENT ' ',
  `col10` decimal(17,2) DEFAULT NULL COMMENT ' ',
  `col11` decimal(17,2) DEFAULT NULL COMMENT ' ',
  `col12` decimal(15,2) DEFAULT NULL COMMENT ' ',
  `col13` decimal(19,8) DEFAULT NULL COMMENT ' ',
  `col14` decimal(17,2) DEFAULT NULL COMMENT ' ',
  `col15` datetime DEFAULT NULL COMMENT ' ',
  `col16` varchar(100) DEFAULT NULL COMMENT ' ',
  `col17` datetime DEFAULT NULL COMMENT ' ',
  PRIMARY KEY (`col2`,`col3`,`col4`,`col1`) /*T![clustered_index] NONCLUSTERED */,
  KEY `index1` (`col3`,`col11`,`col9`,`col2`,`col4`),
  KEY `index2` (`col5`),
  KEY `index3` (`col6`),
  KEY `index4` (`col10`),
  KEY `index5` (`col11`),
  KEY `index6` (`col12`),
  KEY `index7` (`col7`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- 创建表 table3
CREATE TABLE `table3` (
  `col1` char(9) NOT NULL COMMENT ' ',
  `col2` varchar(1500) DEFAULT NULL COMMENT ' ',
  `col3` char(9) DEFAULT NULL COMMENT ' ',
  `col4` varchar(900) DEFAULT NULL COMMENT ' ',
  `col5` char(1) DEFAULT NULL COMMENT ' ',
  `col6` char(9) DEFAULT NULL COMMENT ' ',
  `col7` char(1) DEFAULT NULL COMMENT ' ',
  `col8` varchar(240) DEFAULT NULL COMMENT ' ',
  `col9` char(9) DEFAULT NULL COMMENT ' ',
  `col10` char(9) DEFAULT NULL COMMENT ' ',
  `col11` char(9) DEFAULT NULL COMMENT ' ',
  `col12` char(9) DEFAULT NULL COMMENT ' ',
  `col13` char(9) DEFAULT NULL COMMENT ' ',
  `col14` char(9) DEFAULT NULL COMMENT ' ',
  `col15` varchar(100) DEFAULT NULL COMMENT ' ',
  `col16` datetime DEFAULT NULL COMMENT ' ',
  `col17` datetime DEFAULT NULL COMMENT ' ',
  `col18` char(2) DEFAULT NULL COMMENT ' ',
  `col19` char(4) DEFAULT NULL COMMENT ' ',
  `col20` varchar(600) DEFAULT NULL COMMENT ' ',
  `col21` varchar(600) DEFAULT NULL COMMENT ' ',
  `col22` char(2) DEFAULT NULL COMMENT ' ',
  `col23` varchar(1500) DEFAULT NULL COMMENT ' ',
  `col24` char(1) DEFAULT NULL COMMENT ' ',
  `col25` varchar(90) DEFAULT NULL COMMENT ' ',
  `col26` datetime DEFAULT NULL COMMENT ' ',
  `col27` char(9) DEFAULT NULL COMMENT ' ',
  `col28` char(5) DEFAULT NULL COMMENT ' ',
  `col29` datetime DEFAULT NULL COMMENT ' ',
  `col30` datetime DEFAULT NULL COMMENT ' ',
  `col31` varchar(240) DEFAULT NULL COMMENT ' ',
  `col32` char(8) DEFAULT NULL COMMENT ' ',
  `col33` varchar(1500) DEFAULT NULL COMMENT ' ',
  PRIMARY KEY (`col1`) /*T![clustered_index] NONCLUSTERED */,
  KEY `index1` (`col3`),
  KEY `index2` (`col10`),
  KEY `index3` (`col27`),
  KEY `index4` (`col11`),
  KEY `index5` (`col12`),
  KEY `index6` (`col13`),
  KEY `index7` (`col14`),
  KEY `index8` (`col14`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- 创建表 table4
CREATE TABLE `table4` (
  `col1` varchar(120) NOT NULL COMMENT ' ',
  `col2` char(18) DEFAULT NULL COMMENT ' ',
  `col3` varchar(21) DEFAULT NULL COMMENT ' ',
  `col4` char(9) DEFAULT NULL COMMENT ' ',
  `col5` datetime(3) DEFAULT NULL COMMENT ' ',
  `col6` datetime DEFAULT NULL COMMENT ' ',
  `col7` char(5) DEFAULT NULL COMMENT ' ',
  `col8` datetime DEFAULT NULL COMMENT ' ',
  `col9` char(6) DEFAULT NULL COMMENT ' ',
  `col10` char(2) DEFAULT NULL COMMENT ' ',
  PRIMARY KEY (`col1`) /*T![clustered_index] NONCLUSTERED */,
  KEY `index1` (`col2`),
  KEY `index2` (`col3`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;