mysql创建表-包括多种类型数据及索引

drop table if exists tt_info;
CREATE TABLE `tt_info` (
  `tt_info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id(自增主键）',
  `tt_info_serial_no` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '交易号',
  `serial_no` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流水号',
  `account_amt` decimal(18,4) DEFAULT '0.0000' COMMENT '金额',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `version_val` int(11) DEFAULT NULL COMMENT '版本',
  `record_ind` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '逻辑删除标志',
  PRIMARY KEY (`tt_info_id`) USING BTREE,
  UNIQUE KEY `idx_tt_info_serial_no` (`tt_info_serial_no`),
  KEY `idx_aai_serial_no` (`serial_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='tt表';