~~~ 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; ~~~