# 后台菜单表 ~~~ DROP TABLE IF EXISTS `jz_menu`; CREATE TABLE `jz_menu` ( `id` int(11) NOT NULL, `pid` int(11) NOT NULL, `title` varchar(45) NOT NULL COMMENT '模块名称', `url` varchar(50) NOT NULL, `icon` varchar(30) NOT NULL, `sort` tinyint(4) NOT NULL COMMENT '排序等级', `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态', `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ~~~