spring-boot-shiro-2.0
/
common.sql

/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50552
Source Host           : 127.0.0.1:3306
Source Database       : common

Target Server Type    : MYSQL
Target Server Version : 50552
File Encoding         : 65001

Date: 2018-09-21 17:43:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `name` varchar(100) NOT NULL COMMENT '部门名称',
  `leader` varchar(100) DEFAULT NULL COMMENT '领导',
  `contacter` varchar(100) DEFAULT NULL COMMENT '联系人',
  `address` varchar(200) DEFAULT NULL COMMENT '地址',
  `telephone` varchar(100) DEFAULT NULL COMMENT '电话',
  `fax` varchar(100) DEFAULT NULL COMMENT '传真',
  `email` varchar(100) DEFAULT NULL COMMENT '邮件',
  `note` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `inst_id` int(11) NOT NULL COMMENT '单位id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('1', '部门一', '李芳', null, null, null, null, null, null, '2018-02-26 16:51:24', '1');
INSERT INTO `department` VALUES ('2', '部门二', '黄佳', null, null, null, null, null, null, '2018-02-26 16:51:38', '1');

-- ----------------------------
-- Table structure for event_last_time
-- ----------------------------
DROP TABLE IF EXISTS `event_last_time`;
CREATE TABLE `event_last_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(2) NOT NULL COMMENT '类型：0-qq；1-微信',
  `eid` int(11) NOT NULL COMMENT '事件ID',
  `last_time` datetime NOT NULL COMMENT '数据最后进入时间',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `type+eid` (`type`,`eid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='事件时间最新时间记录表';

-- ----------------------------
-- Records of event_last_time
-- ----------------------------
INSERT INTO `event_last_time` VALUES ('1', '1', '1', '2018-07-06 20:21:37', '2018-07-06 19:33:31');
INSERT INTO `event_last_time` VALUES ('5', '2', '1', '2018-07-06 22:01:59', '2018-07-06 22:01:27');

-- ----------------------------
-- Table structure for institution
-- ----------------------------
DROP TABLE IF EXISTS `institution`;
CREATE TABLE `institution` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '单位id',
  `name` varchar(100) DEFAULT NULL COMMENT '单位名称',
  `leader` varchar(100) DEFAULT NULL COMMENT '负责人',
  `contacter` varchar(100) DEFAULT NULL COMMENT '联系人',
  `telephone` varchar(100) DEFAULT NULL COMMENT '电话',
  `fax` varchar(100) DEFAULT NULL COMMENT '传真',
  `address` varchar(200) DEFAULT NULL COMMENT '地址',
  `zip_code` varchar(200) DEFAULT NULL COMMENT '邮编',
  `email` varchar(100) DEFAULT NULL COMMENT '电子邮件',
  `web` varchar(100) DEFAULT NULL COMMENT '网站',
  `note` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of institution
-- ----------------------------
INSERT INTO `institution` VALUES ('1', '单位一', null, null, null, null, null, null, null, null, null, '2018-02-26 16:51:50');

-- ----------------------------
-- Table structure for ip_info
-- ----------------------------
DROP TABLE IF EXISTS `ip_info`;
CREATE TABLE `ip_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `ip` varchar(10) NOT NULL COMMENT 'ip',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ip_info
-- ----------------------------
INSERT INTO `ip_info` VALUES ('69', '127.0.0.1', '2');
INSERT INTO `ip_info` VALUES ('70', '127.0.0.1', '2');
INSERT INTO `ip_info` VALUES ('71', '127.0.0.1', '1');
INSERT INTO `ip_info` VALUES ('72', '127.0.0.1', '1');
INSERT INTO `ip_info` VALUES ('73', '127.0.0.1', '1');
INSERT INTO `ip_info` VALUES ('74', '127.0.0.1', '1');

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `frame` text NOT NULL COMMENT '权限',
  `dep_id` int(11) NOT NULL COMMENT '部门id',
  `user_id` int(11) NOT NULL COMMENT '用户id，-1-部门权限',
  `inst_id` int(11) DEFAULT NULL COMMENT '单位id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES ('1', '[{s:\'manage\',n:\'管理系统\',m:[{id:\'1\',n:\'首页\',m:[]},{id:\'2\',n:\'用户管理\',m:[]},{id:\'3\',n:\'部门管理\',m:[]},{id:\'4\',n:\'单位管理\',m:[]},{id:\'7\',n:\'ukey管理\',m:[]}]},{s:\'dispose\',n:\'我的工作台\',m:[{id:\'1\',n:\'我的任务\',m:[{id:\'1\',n:\'首页\',m:[]}]},{id:\'2\',n:\'信息上报\',m:[{id:\'1\',n:\'首页\',m:[]}]},{id:\'3\',n:\'工作排班\',m:[{id:\'1\',n:\'首页\',m:[]}]}]}]', '-1', '1', '-1');
INSERT INTO `permission` VALUES ('2', '[{s:\'manage\',n:\'管理系统\',m:[{id:\'1\',n:\'首页\',m:[]},{id:\'5\',n:\'系统登录轨迹\',m:[]},{id:\'6\',n:\'用户行为跟踪\',m:[]}]}]', '-1', '2', '-1');
INSERT INTO `permission` VALUES ('119', '[{s:\'navi\',n:\'首页系统\',m:[{id:\'1\',n:\'首页\',m:[]}]},{s:\'monitor\',n:\'监测预警\',m:[{id:\'1\',n:\'信息查询\',m:[{id:\'1\',n:\'首页\',m:[]}]},{id:\'2\',n:\'预警详情\',m:[{id:\'1\',n:\'线索预警\',m:[]},{id:\'2\',n:\'图片预警\',m:[]},{id:\'3\',n:\'专题预警\',m:[]},{id:\'4\',n:\'重点人预警\',m:[]},{id:\'5\',n:\'关注账号预警\',m:[]}]}]},{s:\'event\',n:\'事件分析\',m:[{id:\'1\',n:\'事件专题\',m:[{id:\'1\',n:\'事件概况研判\',m:[]},{id:\'2\',n:\'信息汇总与综合查询\',m:[]},{id:\'3\',n:\'统计分析\',m:[]},{id:\'4\',n:\'参与群体推荐\',m:[]},{id:\'5\',n:\'参与人员推荐\',m:[]},{id:\'6\',n:\'行动性线索\',m:[]},{id:\'7\',n:\'溯源分析\',m:[]},{id:\'8\',n:\'扩线分析\',m:[]},{id:\'9\',n:\'新群推荐\',m:[]},{id:\'10\',n:\'专题档案\',m:[]}]},{id:\'4\',n:\'历史专题\',m:[{id:\'1\',n:\'事件概况研判\',m:[]},{id:\'2\',n:\'信息汇总与综合查询\',m:[]},{id:\'3\',n:\'统计分析\',m:[]},{id:\'4\',n:\'参与群体推荐\',m:[]},{id:\'5\',n:\'参与人员推荐\',m:[]},{id:\'6\',n:\'行动性线索\',m:[]},{id:\'7\',n:\'溯源分析\',m:[]},{id:\'8\',n:\'扩线分析\',m:[]},{id:\'10\',n:\'专题档案\',m:[]}]},{id:\'3\',n:\'专题配置\',m:[{id:\'1\',n:\'专题配置\',m:[]},{id:\'2\',n:\'线索预警关键词配置\',m:[]},{id:\'3\',n:\'事件类型配置\',m:[]},{id:\'4\',n:\'事件数据管控\',m:[]}]}]},{s:\'data\',n:\'数据中心\',m:[{id:\'1\',n:\'首页\',m:[{id:\'1\',n:\'首页\',m:[]}]},{id:\'2\',n:\'一键搜\',m:[{id:\'1\',n:\'首页\',m:[]}]},{id:\'3\',n:\'人员分析\',m:[{id:\'1\',n:\'首页\',m:[]},{id:\'2\',n:\'账号资料\',m:[]},{id:\'3\',n:\'信息检索\',m:[]},{id:\'4\',n:\'行为分析\',m:[]},{id:\'5\',n:\'组织分析\',m:[]},{id:\'6\',n:\'马甲分析\',m:[]},{id:\'7\',n:\'地域分析\',m:[]}]},{id:\'4\',n:\'圈群分析\',m:[{id:\'1\',n:\'首页\',m:[]},{id:\'2\',n:\'档案资料\',m:[]},{id:\'3\',n:\'信息检索\',m:[]},{id:\'4\',n:\'分析与研判\',m:[]},{id:\'5\',n:\'热点云\',m:[]},{id:\'6\',n:\'成员分析\',m:[]}]},{id:\'5\',n:\'扩线分析\',m:[{id:\'1\',n:\'首页\',m:[]},{id:\'2\',n:\'扩线分析\',m:[]}]},{id:\'6\',n:\'溯源分析\',m:[{id:\'1\',n:\'首页\',m:[]},{id:\'2\',n:\'溯源分析\',m:[]}]},{id:\'7\',n:\'IP分析\',m:[{id:\'1\',n:\'首页\',m:[]}]}]},{s:\'people\',n:\'重点人分析\',m:[{id:\'1\',n:\'首页\',m:[{id:\'1\',n:\'首页\',m:[]}]},{id:\'2\',n:\'重点人列表\',m:[{id:\'1\',n:\'首页\',m:[]},{id:\'2\',n:\'人物详情\',m:[]},{id:\'3\',n:\'网上言论\',m:[]},{id:\'4\',n:\'网络活动\',m:[]},{id:\'5\',n:\'关系分析\',m:[]},{id:\'6\',n:\'行为分析\',m:[]},{id:\'7\',n:\'轨迹分析\',m:[]},{id:\'8\',n:\'档案管理\',m:[]}]},{id:\'3\',n:\'配置管理\',m:[{id:\'1\',n:\'批量导入\',m:[]},{id:\'2\',n:\'导入历史\',m:[]},{id:\'1\',n:\'标签配置\',m:[]},{id:\'2\',n:\'类别配置\',m:[]}]}]},{s:\'dispose\',n:\'我的工作台\',m:[{id:\'1\',n:\'首页\',m:[{id:\'1\',n:\'首页\',m:[]}]},{id:\'2\',n:\'审批处置\',m:[{id:\'1\',n:\'首页\',m:[]}]}]},{s:\'manage\',n:\'系统管理\',m:[{id:\'1\',n:\'首页\',m:[]}]}]', '-1', '115', '6');

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `name` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `id` int(11) NOT NULL,
  `pubdate` date NOT NULL,
  `deltime` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of test
-- ----------------------------

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '用户密码',
  `dep_id` int(11) NOT NULL COMMENT '部门id',
  `sys_grade` int(11) NOT NULL COMMENT '级别：1-系统，2-单位，3-部门；',
  `role` int(11) DEFAULT NULL COMMENT '角色：1-管理员，2-审计员，3-业务用户；',
  `inst_id` int(11) NOT NULL COMMENT '单位id，-1为系统级别',
  `super_view` int(11) DEFAULT NULL COMMENT '超级访问级别：0-关闭、2-单位、3-部门',
  `real_name` varchar(100) DEFAULT NULL COMMENT '真实姓名',
  `telephone` varchar(100) DEFAULT NULL COMMENT '电话',
  `email` varchar(100) DEFAULT NULL COMMENT '邮件',
  `note` varchar(100) DEFAULT NULL COMMENT '备注',
  `deadline` timestamp NULL DEFAULT NULL COMMENT '失效时间',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '账号是否有效，0-无效；1-有效；默认1',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `idx_dep_id` (`dep_id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES ('1', 'adminsuper', 'NTEwMiVzYQ==', '-1', '1', '1', '-1', null, '超级管理员', null, null, null, null, '1', '2018-01-15 15:38:23');
INSERT INTO `user_info` VALUES ('2', 'web', 'ODEwMiViZXc=', '1', '2', '1', '1', null, '单位一管理员', null, null, null, null, '1', '2018-01-15 20:02:44');
INSERT INTO `user_info` VALUES ('115', 'webtest', 'ODEwMiViZXc=', '2', '3', '1', '1', null, '部门二管理员', null, null, null, null, '0', '2018-01-16 11:33:37');