shebao-server/docs/sql/db/system/shebao_admin_data20151014_sys_privilege.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_privilege` */

DROP TABLE IF EXISTS `sys_privilege`;

CREATE TABLE `sys_privilege` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '权限名称',
  `url` varchar(255) DEFAULT NULL COMMENT 'url地址',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='系统权限表';

/*Data for the table `sys_privilege` */

insert  into `sys_privilege`(`id`,`name`,`url`,`description`) values (1,'SBA','/sba/','后台账号登录'),(2,'SB_LIST','/sba/sb/list','社保参数查询列表'),(3,'FUND_LIST','/sba/fund/list','公积金参数查询列表'),(4,'CHARGE_QUERYLIST','/sba/charge/querylist','服务费查询列表'),(5,'SYSTEM_USER_QUERYPAGEBY','/sba/system/user/querypageby','查询系统账号'),(6,'SYSTEM_ROLE_QUERYPAGEBY','/sba/system/role/querypageby','查询系统角色'),(7,'SYSTEM_PRIVILEGE_QUERYPAGEBY','/sba/system/privilege/querypageby','查询系统权限'),(9,'SYSTEM_USER_DELETE','/sba/system/user/delete','删除系统账号'),(10,'SYSTEM_USER_ADD','/sba/system/user/add','添加系统账号'),(11,'SYSTEM_USER_SHOWPASS','/sba/system/user/showpass','修改账号密码显示'),(12,'SYSTEM_USER_UPDATEPASS','/sba/system/user/updatepass','修改账号密码'),(13,'SYSTEM_USER_QUERYROLELIST','/sba/system/user/queryrolelist','授权账号角色查询页面'),(14,'SYSTEM_USER_GRANTROLE','/sba/system/user/grantrole','授权账号角色提交'),(15,'SYSTEM_ROLE_ADD','/sba/system/role/add','添加系统角色'),(16,'SYSTEM_ROLE_DELETE','/sba/system/role/delete','删除系统角色'),(17,'SYSTEM_ROLE_QUERYPRIVILEGELIST','/sba/system/role/queryprivilegelist','角色授权查询'),(18,'SYSTEM_ROLE_GRANTPRIVILEGE','/sba/system/role/grantprivilege','修改角色授权提交'),(19,'SYSTEM_PRIVILEGE_ADD','/sba/system/privilege/add','添加系统权限'),(20,'SYSTEM_PRIVILEGE_DELETE','/sba/system/privilege/delete','删除系统权限'),(22,'USER_QUERYPAGEBY','/sba/user/querypageby','用户查询列表'),(23,'EXCEL_EXPORTUSER','/sba/excel/exportuser','用户批量导出EXCEL'),(24,'EMPLOYEE_QUERYAGENCYPAGE','/sba/employee/queryagencypage','代理员工查询列表'),(25,'EMPLOYEE_UPDATERECON','/sba/employee/updaterecon','代理员工状态修改'),(26,'EMPLOYEE_BATCHRECON','/sba/employee/batchrecon','代理员工批量状态修改'),(27,'EMPLOYEE_QUERYAGENCYDETAILPAGE','/sba/employee/queryagencydetailpage','代理员工按月查询列表'),(28,'EXCEL_EXPORTAGENCYDETAIL','/sba/excel/exportagencydetail','代理员工批量导出EXCEL'),(29,'EXCEL_IMPORTEMPLOYEEEXCEL','/sba/excel/importEmployeeExcel','代理员工导入核对EXCEL'),(30,'EMPLOYEE_QUERYCHANGEDETAILPAGE','/sba/employee/querychangedetailpage','增减员查询增员列表'),(31,'EMPLOYEE_EXCEL_EXPORTCHANGECOMING','/sba/employee/excel/exportchangecoming','增员批量导出EXCEL'),(32,'EXCEL_IMPORTEMPLOYEEADDEXCEL','/sba/excel/importEmployeeAddExcel','导入增员卡号EXCEL'),(33,'EMPLOYEE_UPDATESBCARD','/sba/employee/updatesbcard','编辑增员卡号'),(34,'EMPLOYEE_UPDATEREASON','/sba/employee/updatereason','编辑增员失败原因'),(35,'EMPLOYEE_CHECKIDCARD','/sba/employee/checkidcard','查看增员身份证'),(36,'EMPLOYEE_DOWNLOADFILE','/sba/employee/downloadfile','增减员打包下载身份证ZIP'),(37,'EXCEL_EXPORTCHANGEGOING','/sba/excel/exportchangegoing','减员批量导出EXCEL'),(38,'ORDER_QUERYPAGEBY','/sba/order/querypageby','订单查询列表'),(39,'EXCEL_EXPORTORDER','/sba/excel/exportorder','订单批量导出EXCEL'),(40,'ORDER_QUERYDETAIL','/sba/order/querydetail','订单详情修改显示'),(41,'ORDER_MODIFY','/sba/order/modify','订单详情修改'),(42,'SB_2MODIFY','/sba/sb/2modify','社保参数增加'),(43,'SB_MOD_MAIN','/sba/sb/mod/main','社保参数提交修改'),(44,'FUND_2MODIFY','/sba/fund/2modify','公积金参数修改'),(45,'FUND_MODIFY','/sba/fund/modify','公积金参数提交修改'),(46,'NEWS_QUERYLIST','/sba/news/querylist','群发消息查询消息列表'),(47,'NEWS_ADD','/sba/news/add','群发消息保存'),(48,'NEWS_DELETE','/sba/news/delete','群发消息删除'),(49,'NEWS_BATCHDELETE','/sba/news/batchdelete','群发消息批量删除消息'),(50,'USER_QUERYPAGE','/sba/user/querypage','用户查询列表'),(51,'EMPLOYEE_QUERYCHANGEPAGE','/sba/employee/querychangepage','增减员查询列表'),(52,'NEWS_LIST','/sba/news/list','群发消息查询消息列表');

/*!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 */;