~~~ ALTER TABLE `menu` ADD UNIQUE INDEX idx_pid_m_order(pid,m_order); ~~~ 表设计 ~~~ CREATE TABLE `menu` ( `id` smallint(4) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `m_text` varchar(60) NOT NULL DEFAULT '' COMMENT '中文名称', `iconcls` varchar(60) NOT NULL DEFAULT '' COMMENT '图标', `cname` varchar(60) NOT NULL DEFAULT '' COMMENT '类名', `pid` smallint(6) DEFAULT NULL COMMENT '父节点ID', `m_order` tinyint(4) NOT NULL DEFAULT '1' COMMENT '层级ID', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '删除标记', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `idx_pid_m_order` (`pid`,`m_order`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; ~~~