· 8 years ago · Mar 15, 2018, 08:20 AM
1SET FOREIGN_KEY_CHECKS=0;
2DROP TABLE IF EXISTS `tb_test`;
3CREATE TABLE `tb_online_disk_mgmt` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `node_name` varchar(512) NOT NULL COMMENT '节点å称',
6 `node_level` tinyint(4) NOT NULL COMMENT '节点所在层',
7 `area_code` int(11) NOT NULL COMMENT '区域代ç ',
8 PRIMARY KEY (`id`),
9 KEY `area_level_name` (`area_code`,`node_level`,`node_name`(255)) USING BTREE,
10 KEY `area_name` (`area_code`,`node_name`(255))