CREATE TABLE `teps_newlaptop_test_result_t`
(
`result_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id（自增）',
`test_type` varchar(10) NOT NULL COMMENT '检测分类，NFF或者FT',
`package_id` int(11) DEFAULT NULL COMMENT '检测套餐的ID',
`model_name` varchar(64) DEFAULT '' COMMENT '产品型号',
`sn` varchar(100) NOT NULL DEFAULT '' COMMENT 'SN',
`build_number` varchar(100) DEFAULT '' COMMENT '设备版本号',
`tool_ver` varchar(50) NOT NULL DEFAULT '' COMMENT '软件版本号',
`connection_type` varchar(10) DEFAULT '' COMMENT '连接方式，USB,WAN,LAN',
`test_equipment` varchar(30) DEFAULT '' COMMENT '检测设备',
`total_time` int(11) DEFAULT NULL COMMENT '检测总时间，单位：毫秒',
`total_result` varchar(10) DEFAULT '' COMMENT '检测总结果',
`report_flag` int(11) NOT NULL DEFAULT '0' COMMENT '报告标志位，0：无报告，1：有报告',
`intercept` varchar(1000) DEFAULT '' COMMENT '故障拦截',
`na_fault_code` varchar(1000) DEFAULT '' COMMENT 'NA状态的故障小类编码',
`pass_fault_code` varchar(1000) DEFAULT '' COMMENT 'PASS状态的故障小类编码',
`fail_fault_code` varchar(1000) DEFAULT '' COMMENT 'FAIL的状态的故障小类编码',
`nff_fault_code` varchar(1000) DEFAULT '' COMMENT 'NFF状态的故障小类编码',
`created_by` varchar(64) NOT NULL COMMENT '创建人',
`creation_date` datetime NOT NULL COMMENT '创建时间',
`last_updated_by` varchar(64) NOT NULL COMMENT '最后修改人',
`last_update_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后修改时间',
`field01` varchar(200) DEFAULT '' COMMENT '预留字段',
PRIMARY KEY (`result_id`, `creation_date`) USING BTREE,
KEY `sn` (`sn`) USING BTREE,
KEY `created_by` (`created_by`) USING BTREE,
KEY `creationDate` (`creation_date`),
KEY `modelName` (`model_name`),
KEY `connectionType` (`connection_type`)
) ENGINE=InnoDB AUTO_INCREMENT=13841 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='鸿蒙PC检测结果表'
PARTITION BY RANGE (to_days(`creation_date`))
(
PARTITION P202501 VALUES LESS THAN (739648) ENGINE = InnoDB,
PARTITION P202502 VALUES LESS THAN (739676) ENGINE = InnoDB,
PARTITION P202503 VALUES LESS THAN (739707) ENGINE = InnoDB,
PARTITION P202504 VALUES LESS THAN (739737) ENGINE = InnoDB,
PARTITION P202505 VALUES LESS THAN (739768) ENGINE = InnoDB,
PARTITION P202506 VALUES LESS THAN (739798) ENGINE = InnoDB,
PARTITION P202507 VALUES LESS THAN (739829) ENGINE = InnoDB,
PARTITION P202508 VALUES LESS THAN (739860) ENGINE = InnoDB,
PARTITION P202509 VALUES LESS THAN (739890) ENGINE = InnoDB,
PARTITION P202510 VALUES LESS THAN (739921) ENGINE = InnoDB,
PARTITION P202511 VALUES LESS THAN (739951) ENGINE = InnoDB,
PARTITION P202512 VALUES LESS THAN (739982) ENGINE = InnoDB,
PARTITION P202601 VALUES LESS THAN (740013) ENGINE = InnoDB,
PARTITION P202602 VALUES LESS THAN (740041) ENGINE = InnoDB,
PARTITION P202603 VALUES LESS THAN (740072) ENGINE = InnoDB,
PARTITION P202604 VALUES LESS THAN (740102) ENGINE = InnoDB,
PARTITION P202605 VALUES LESS THAN (740133) ENGINE = InnoDB,
PARTITION P202606 VALUES LESS THAN (740163) ENGINE = InnoDB,
PARTITION P202607 VALUES LESS THAN (740194) ENGINE = InnoDB,
PARTITION P202608 VALUES LESS THAN (740225) ENGINE = InnoDB,
PARTITION P202609 VALUES LESS THAN (740255) ENGINE = InnoDB,
PARTITION P202610 VALUES LESS THAN (740286) ENGINE = InnoDB,
PARTITION P202611 VALUES LESS THAN (740316) ENGINE = InnoDB,
PARTITION P202612 VALUES LESS THAN (740347) ENGINE = InnoDB,
PARTITION P202701 VALUES LESS THAN (740378) ENGINE = InnoDB,
PARTITION P202702 VALUES LESS THAN (740406) ENGINE = InnoDB,
PARTITION P202703 VALUES LESS THAN (740437) ENGINE = InnoDB,
PARTITION P202704 VALUES LESS THAN (740467) ENGINE = InnoDB,
PARTITION P202705 VALUES LESS THAN (740498) ENGINE = InnoDB,
PARTITION P202706 VALUES LESS THAN (740528) ENGINE = InnoDB,
PARTITION P202707 VALUES LESS THAN (740559) ENGINE = InnoDB,
PARTITION P202708 VALUES LESS THAN (740590) ENGINE = InnoDB,
PARTITION P202709 VALUES LESS THAN (740620) ENGINE = InnoDB,
PARTITION P202710 VALUES LESS THAN (740651) ENGINE = InnoDB,
PARTITION P202711 VALUES LESS THAN (740681) ENGINE = InnoDB,
PARTITION P202712 VALUES LESS THAN (740712) ENGINE = InnoDB,
PARTITION P202801 VALUES LESS THAN (740743) ENGINE = InnoDB,
PARTITION P202802 VALUES LESS THAN (740772) ENGINE = InnoDB,
PARTITION P202803 VALUES LESS THAN (740803) ENGINE = InnoDB,
PARTITION P202804 VALUES LESS THAN (740833) ENGINE = InnoDB,
PARTITION P202805 VALUES LESS THAN (740864) ENGINE = InnoDB,
PARTITION P202806 VALUES LESS THAN (740894) ENGINE = InnoDB,
PARTITION P202807 VALUES LESS THAN (740925) ENGINE = InnoDB,
PARTITION P202808 VALUES LESS THAN (740956) ENGINE = InnoDB,
PARTITION P202809 VALUES LESS THAN (740986) ENGINE = InnoDB,
PARTITION P202810 VALUES LESS THAN (741017) ENGINE = InnoDB,
PARTITION P202811 VALUES LESS THAN (741047) ENGINE = InnoDB,
PARTITION P202812 VALUES LESS THAN (741078) ENGINE = InnoDB);对这个建表脚本的分区解析
最新发布
本文介绍了一个常见的MySQL配置错误，即使用了不支持的type关键字。文章提供了简单的解决方案，即将type改为ENGINE。
扫一扫
1055
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
