-- MySQL dump 10.13  Distrib 5.7.22, for Linux (x86_64)
--
-- Host: localhost    Database: swgk_wl
-- ------------------------------------------------------
-- Server version	5.7.22-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `swgk_node`
--

DROP TABLE IF EXISTS `swgk_node`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `swgk_node` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `pid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '节点父ID',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '节点层级',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '节点对应的方法名或者控制器名',
  `routing` varchar(50) NOT NULL DEFAULT '' COMMENT '管理端接口url',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '节点排序',
  `need_content` enum('否','是') NOT NULL DEFAULT '否' COMMENT '否-不可添加内容， 是-可添加内容',
  `typeid` varchar(10) NOT NULL DEFAULT '' COMMENT '网易云分类id',
  `icon` varchar(60) NOT NULL DEFAULT '' COMMENT '栏目图标',
  `title` varchar(22) NOT NULL DEFAULT '' COMMENT '栏目名称',
  `display` tinyint(3) NOT NULL DEFAULT '1' COMMENT '管理端是否展示 1-是 0-否',
  `urls` varchar(50) NOT NULL DEFAULT '' COMMENT '对外接口url',
  `node_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '节点类型 1-栏目节点 0-功能节点',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COMMENT='节点表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `swgk_node`
--

LOCK TABLES `swgk_node` WRITE;
/*!40000 ALTER TABLE `swgk_node` DISABLE KEYS */;
INSERT INTO `swgk_node` VALUES (1,0,0,'SystemConfig','',2,'否','','','栏目节点管理',1,'',1),(2,1,1,'','SystemConfig/systemNodeManage',0,'否','','','节点配置',1,'',1),(3,1,1,'','SystemConfig/powerSetting',2,'否','','','节点权限配置',1,'',1),(5,2,2,'','SystemConfig/addSystemNode',0,'否','','','栏目添加',0,'',0),(6,2,2,'','SystemConfig/updateSystemNode',2,'否','','','栏目修改',0,'',0),(7,3,2,'','SystemConfig/grantRole',0,'否','','','权限配置',0,'',0),(8,0,0,'SystemConfig','',4,'否','','','系统配置',1,'',1),(9,8,1,'','SystemConfig/safe',0,'否','','','密码安全',1,'',1),(10,8,1,'','SystemConfig/configSet',2,'否','','','通用配置',1,'',1),(11,8,1,'','SystemConfig/holidays',4,'否','','','节假日配置',1,'',1),(12,0,0,'SystemConfig','',6,'否','','','积分配置',0,'',1),(13,12,1,'','SystemConfig/CIVPointManage',0,'否','','','文明积分配置',1,'',1),(16,0,0,'SystemConfig','',10,'否','','','区域管理',1,'',1),(17,16,1,'','SystemConfig/regionManage',10,'否','','','区域管理',1,'',1),(34,0,0,'UserManage','',20,'否','','','用户管理',1,'',1),(40,34,1,'/UserManage/getRoleList','UserManage/manRoleManage',2,'否','','','角色管理',1,'',1),(41,40,2,'/UserManage/addRole','',0,'否','','','新增角色',0,'',0),(42,40,2,'/UserManage/editRole','',0,'否','','','编辑角色',0,'',0),(44,34,1,'/BasePeople/getList','/Basicinfo/people',0,'否','','','人口信息管理',1,'',1),(48,12,1,'','SystemConfig/readPointManage',4,'否','','','读书积分配置',1,'',1),(56,44,2,'/BasePeople/addPeopleBaseInfo','',0,'否','','','新增人口信息',0,'',0),(57,44,2,'/BasePeople/editPeopleBaseInfo','',0,'否','','','修改人口信息',0,'',0),(87,12,1,'','SystemConfig/partyPointManage',2,'否','','','党员积分配置',1,'',1),(105,0,0,'','',2,'否','','','媒资管理',1,'',1),(106,105,1,'','/media/type',0,'否','','','资产分类管理',1,'',1),(107,105,1,'','/media/docManage',0,'否','','','资产文件管理',1,'',1),(109,0,0,'','',2,'否','','','内容管理',1,'',1),(110,109,1,'','contentManage/collectContent',0,'否','','','内容采集',1,'',1),(112,109,1,'','contentManage/releaseContent',0,'否','','','内容审核',1,'',1),(113,109,1,'','LevalMessage/collectMessage',0,'否','','','评论查看',1,'',1),(114,109,1,'','LevalMessage/auditMessage',0,'否','','','评论审核（取消）',0,'',1),(115,109,1,'','LevalMessage/releaseMessage',0,'否','','','评论审核',1,'',1),(116,40,2,'/UserManage/getPermissions','',0,'否','','','获取栏目节点树',0,'',0),(117,40,2,'/UserManage/changeRoleStatus','',0,'否','','','启用/禁用',0,'',0),(119,34,1,'/UserManage/getGridUserList','UserManage/grider',0,'否','','','网格员管理',0,'',1),(128,34,1,'/UserManage/getDepartmentUserList','UserManage/departmentUser',0,'否','','','部门人员管理',0,'',1),(129,0,1,'MeetingRoom','',22,'否','','','监控管理',1,'',1),(132,34,1,'/UserManage/getLeadUserList','UserManage/leadUser',0,'否','','','角色人员管理',1,'',1),(152,0,0,'','',2,'是','','','三务公开',1,'',1),(153,152,1,'','contentManage/contentEdit',0,'是','','','党务',1,'',1),(154,152,1,'','contentManage/contentEdit',0,'是','','','村务',1,'',1),(155,152,1,'','contentManage/contentEdit',0,'是','','','财务',1,'',1),(220,0,0,'BossManage/boss','',0,'否','','','电视端管理',1,'',1),(221,220,1,'/BossManage/getCardList','Boss/card',0,'否','','','CA卡号管理',1,'',1),(222,221,2,'/BossManage/addCard','',0,'否','','','录入CA卡',0,'',0),(223,221,2,'/BossManage/editCard','',0,'否','','','修改CA卡',0,'',0),(224,221,2,'/BossManage/deleteCard','',0,'否','','','删除CA卡',0,'',0),(225,221,2,'/BossManage/changeCardStatus','',0,'否','','','改变CA卡状态',0,'',0),(226,221,2,'/BossManage/importCard','',0,'否','','','批量导入CA卡',0,'',0),(232,220,2,'/BossManage/getTVidxMarquee','Boss/TVidxMarquee',0,'否','','','TV滚动条管理',1,'',1),(241,220,1,'/BossManage/getTVidxVideoFrame','Boss/TVidxVideoFrame',0,'否','','','TV首页视频管理',1,'',1),(242,129,2,'','Camera/liveManage',4,'否','','','监控管理',1,'',1);
/*!40000 ALTER TABLE `swgk_node` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-06-03 16:57:41
