shebao-server/docs/sql/db/system/shebao_admin_data20151014_sys_menu.sql

/*
SQLyog Ultimate v11.11 (64 bit)
MySQL - 5.6.24 : Database - shebao_admin
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`shebao_admin` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `shebao_admin`;

/*Table structure for table `sys_menu` */

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
  `label` varchar(30) DEFAULT NULL COMMENT '标签',
  `title` varchar(100) NOT NULL COMMENT '显示标题',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT 'URL链接地址',
  `target` varchar(10) DEFAULT NULL COMMENT '打开连接方式，_blank or _self',
  `parent_id` int(11) DEFAULT NULL COMMENT '父节点',
  `level` int(1) NOT NULL DEFAULT '0' COMMENT '等级',
  `seq` int(11) NOT NULL DEFAULT '0' COMMENT '顺序',
  `enabled` int(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='菜单表';

/*Data for the table `sys_menu` */

insert  into `sys_menu`(`id`,`name`,`label`,`title`,`url`,`target`,`parent_id`,`level`,`seq`,`enabled`) values (4,'MENU_USER_MANAGE',NULL,'用户管理','/sba/user/querypage',NULL,NULL,1,1,1),(5,'MENU_EMPLOYEE_MANAGE',NULL,'员工管理','/sba/user/querypage',NULL,NULL,1,2,1),(6,'MENU_ORDER_MANAGE',NULL,'订单管理','/sba/order/querypageby',NULL,NULL,1,3,1),(7,'MENU_PARAMETER_MANAGE',NULL,'参数调整','javascript:;',NULL,NULL,1,4,1),(8,'MENU_NEWS_MANAGE',NULL,'群发消息','/sba/news/list',NULL,NULL,1,5,1),(9,'MENU_EMPLOYEE_AGENCY_MANAGE',NULL,'代理员工','/sba/employee/queryagencypage',NULL,5,2,1,1),(10,'MENU_EMPLOYEE_CHANGE_MANAGE',NULL,'增减员','/sba/employee/querychangepage',NULL,5,2,2,1),(11,'MENU_PARAMETER_SB_MANAGE',NULL,'社保参数','/sba/sb/list',NULL,7,2,1,1),(12,'MENU_PARAMETER_FUND_MANAGE',NULL,'公积金参数','/sba/fund/list',NULL,7,2,2,1),(13,'MENU_SYSTEM_MANAGE',NULL,'系统管理','javascript:;',NULL,NULL,1,6,1),(14,'MENU_SYSTEM_USER_MANAGE',NULL,'系统用户管理','/sba/system/user/querypageby',NULL,13,2,1,1),(15,' 	MENU_SYSTEM_ROLE_MANAGE',NULL,'系统角色管理','/sba/system/role/querypageby',NULL,13,2,2,1),(16,'MENU_SYSTEM_PRIVILEGE_MANAGE',NULL,'系统权限管理','/sba/system/privilege/querypageby',NULL,13,2,3,1),(17,' 	MENU_SYSTEM_MENU_MANAGE',NULL,'系统菜单管理','/sba/system/menu/querypageby',NULL,13,2,4,1);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;