soooner_hotel_base.sql

/*
 Navicat Premium Data Transfer

 Source Server         : vsdn-192.168.200.24
 Source Server Type    : MySQL
 Source Server Version : 100136
 Source Host           : 192.168.200.24:3306
 Source Schema         : soooner_hotel_base

 Target Server Type    : MySQL
 Target Server Version : 100136
 File Encoding         : 65001

 Date: 05/12/2019 13:58:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for action_log
-- ----------------------------
DROP TABLE IF EXISTS `action_log`;
CREATE TABLE `action_log` (
  `VAL_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `VAL_LOGINID` varchar(145) NOT NULL COMMENT '用户',
  `VAL_TIME` datetime NOT NULL COMMENT '在什么时间',
  `VAL_MODEL_RESOURCE` varchar(255) NOT NULL COMMENT '在什么地方',
  `VAL_ACTION` varchar(45) NOT NULL COMMENT '动作类型：添加、修改、删除、禁用|启用、选择；如：点播资源分配增加、模块选择资源等',
  `VAL_OBJECT` text NOT NULL COMMENT '内容对象',
  `VAL_IP` varchar(45) NOT NULL COMMENT '操作地址',
  `VAL_COMMAND_NAME` varchar(45) NOT NULL COMMENT '命令标志，Add、Delete、Edit、Forbid等',
  PRIMARY KEY (`VAL_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Table structure for login_valid
-- ----------------------------
DROP TABLE IF EXISTS `login_valid`;
CREATE TABLE `login_valid` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ip` varchar(128) DEFAULT NULL COMMENT '客户端ip',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `login_num` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ip` (`ip`) USING BTREE COMMENT 'ip索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for rbac_access
-- ----------------------------
DROP TABLE IF EXISTS `rbac_access`;
CREATE TABLE `rbac_access` (
  `role_id` smallint(6) unsigned NOT NULL,
  `menu_id` smallint(6) unsigned NOT NULL,
  KEY `groupId` (`role_id`) USING BTREE,
  KEY `nodeId` (`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单关联表';

-- ----------------------------
-- Records of rbac_access
-- ----------------------------
BEGIN;
INSERT INTO `rbac_access` VALUES (35, 1);
INSERT INTO `rbac_access` VALUES (35, 116);
INSERT INTO `rbac_access` VALUES (35, 2);
INSERT INTO `rbac_access` VALUES (35, 122);
INSERT INTO `rbac_access` VALUES (35, 123);
INSERT INTO `rbac_access` VALUES (35, 124);
INSERT INTO `rbac_access` VALUES (35, 125);
INSERT INTO `rbac_access` VALUES (35, 132);
INSERT INTO `rbac_access` VALUES (35, 140);
INSERT INTO `rbac_access` VALUES (35, 141);
INSERT INTO `rbac_access` VALUES (35, 142);
INSERT INTO `rbac_access` VALUES (35, 119);
INSERT INTO `rbac_access` VALUES (35, 166);
INSERT INTO `rbac_access` VALUES (35, 167);
INSERT INTO `rbac_access` VALUES (35, 168);
INSERT INTO `rbac_access` VALUES (35, 169);
INSERT INTO `rbac_access` VALUES (35, 171);
INSERT INTO `rbac_access` VALUES (35, 174);
INSERT INTO `rbac_access` VALUES (35, 7);
INSERT INTO `rbac_access` VALUES (35, 8);
INSERT INTO `rbac_access` VALUES (35, 9);
INSERT INTO `rbac_access` VALUES (35, 10);
INSERT INTO `rbac_access` VALUES (37, 1);
INSERT INTO `rbac_access` VALUES (37, 116);
INSERT INTO `rbac_access` VALUES (37, 122);
INSERT INTO `rbac_access` VALUES (37, 123);
INSERT INTO `rbac_access` VALUES (37, 124);
INSERT INTO `rbac_access` VALUES (37, 125);
INSERT INTO `rbac_access` VALUES (37, 132);
INSERT INTO `rbac_access` VALUES (37, 140);
INSERT INTO `rbac_access` VALUES (37, 141);
INSERT INTO `rbac_access` VALUES (37, 142);
INSERT INTO `rbac_access` VALUES (37, 158);
INSERT INTO `rbac_access` VALUES (37, 162);
INSERT INTO `rbac_access` VALUES (37, 163);
INSERT INTO `rbac_access` VALUES (37, 164);
INSERT INTO `rbac_access` VALUES (37, 165);
INSERT INTO `rbac_access` VALUES (37, 170);
INSERT INTO `rbac_access` VALUES (37, 173);
INSERT INTO `rbac_access` VALUES (37, 118);
INSERT INTO `rbac_access` VALUES (37, 146);
INSERT INTO `rbac_access` VALUES (37, 149);
INSERT INTO `rbac_access` VALUES (37, 152);
INSERT INTO `rbac_access` VALUES (37, 155);
INSERT INTO `rbac_access` VALUES (37, 147);
INSERT INTO `rbac_access` VALUES (37, 150);
INSERT INTO `rbac_access` VALUES (37, 153);
INSERT INTO `rbac_access` VALUES (37, 156);
INSERT INTO `rbac_access` VALUES (37, 148);
INSERT INTO `rbac_access` VALUES (37, 151);
INSERT INTO `rbac_access` VALUES (37, 154);
INSERT INTO `rbac_access` VALUES (37, 157);
INSERT INTO `rbac_access` VALUES (37, 119);
INSERT INTO `rbac_access` VALUES (37, 166);
INSERT INTO `rbac_access` VALUES (37, 167);
INSERT INTO `rbac_access` VALUES (37, 168);
INSERT INTO `rbac_access` VALUES (37, 169);
INSERT INTO `rbac_access` VALUES (37, 171);
INSERT INTO `rbac_access` VALUES (37, 174);
INSERT INTO `rbac_access` VALUES (37, 120);
INSERT INTO `rbac_access` VALUES (37, 183);
INSERT INTO `rbac_access` VALUES (37, 184);
INSERT INTO `rbac_access` VALUES (5, 1);
INSERT INTO `rbac_access` VALUES (5, 187);
INSERT INTO `rbac_access` VALUES (5, 189);
INSERT INTO `rbac_access` VALUES (5, 191);
INSERT INTO `rbac_access` VALUES (5, 193);
INSERT INTO `rbac_access` VALUES (5, 195);
INSERT INTO `rbac_access` VALUES (5, 116);
INSERT INTO `rbac_access` VALUES (5, 122);
INSERT INTO `rbac_access` VALUES (5, 123);
INSERT INTO `rbac_access` VALUES (5, 124);
INSERT INTO `rbac_access` VALUES (5, 125);
INSERT INTO `rbac_access` VALUES (5, 132);
INSERT INTO `rbac_access` VALUES (5, 140);
INSERT INTO `rbac_access` VALUES (5, 141);
INSERT INTO `rbac_access` VALUES (5, 142);
INSERT INTO `rbac_access` VALUES (5, 133);
INSERT INTO `rbac_access` VALUES (5, 143);
INSERT INTO `rbac_access` VALUES (5, 144);
INSERT INTO `rbac_access` VALUES (5, 145);
INSERT INTO `rbac_access` VALUES (5, 117);
INSERT INTO `rbac_access` VALUES (5, 126);
INSERT INTO `rbac_access` VALUES (5, 127);
INSERT INTO `rbac_access` VALUES (5, 128);
INSERT INTO `rbac_access` VALUES (5, 129);
INSERT INTO `rbac_access` VALUES (5, 130);
INSERT INTO `rbac_access` VALUES (5, 134);
INSERT INTO `rbac_access` VALUES (5, 135);
INSERT INTO `rbac_access` VALUES (5, 136);
INSERT INTO `rbac_access` VALUES (5, 131);
INSERT INTO `rbac_access` VALUES (5, 137);
INSERT INTO `rbac_access` VALUES (5, 138);
INSERT INTO `rbac_access` VALUES (5, 139);
INSERT INTO `rbac_access` VALUES (5, 158);
INSERT INTO `rbac_access` VALUES (5, 162);
INSERT INTO `rbac_access` VALUES (5, 163);
INSERT INTO `rbac_access` VALUES (5, 164);
INSERT INTO `rbac_access` VALUES (5, 165);
INSERT INTO `rbac_access` VALUES (5, 170);
INSERT INTO `rbac_access` VALUES (5, 173);
INSERT INTO `rbac_access` VALUES (5, 118);
INSERT INTO `rbac_access` VALUES (5, 146);
INSERT INTO `rbac_access` VALUES (5, 149);
INSERT INTO `rbac_access` VALUES (5, 152);
INSERT INTO `rbac_access` VALUES (5, 155);
INSERT INTO `rbac_access` VALUES (5, 147);
INSERT INTO `rbac_access` VALUES (5, 150);
INSERT INTO `rbac_access` VALUES (5, 153);
INSERT INTO `rbac_access` VALUES (5, 156);
INSERT INTO `rbac_access` VALUES (5, 148);
INSERT INTO `rbac_access` VALUES (5, 151);
INSERT INTO `rbac_access` VALUES (5, 154);
INSERT INTO `rbac_access` VALUES (5, 157);
INSERT INTO `rbac_access` VALUES (5, 119);
INSERT INTO `rbac_access` VALUES (5, 166);
INSERT INTO `rbac_access` VALUES (5, 167);
INSERT INTO `rbac_access` VALUES (5, 168);
INSERT INTO `rbac_access` VALUES (5, 169);
INSERT INTO `rbac_access` VALUES (5, 171);
INSERT INTO `rbac_access` VALUES (5, 174);
INSERT INTO `rbac_access` VALUES (5, 120);
INSERT INTO `rbac_access` VALUES (5, 183);
INSERT INTO `rbac_access` VALUES (5, 184);
INSERT INTO `rbac_access` VALUES (5, 121);
INSERT INTO `rbac_access` VALUES (5, 179);
INSERT INTO `rbac_access` VALUES (5, 181);
INSERT INTO `rbac_access` VALUES (5, 180);
INSERT INTO `rbac_access` VALUES (5, 182);
INSERT INTO `rbac_access` VALUES (5, 197);
INSERT INTO `rbac_access` VALUES (5, 199);
INSERT INTO `rbac_access` VALUES (5, 2);
INSERT INTO `rbac_access` VALUES (5, 3);
INSERT INTO `rbac_access` VALUES (5, 4);
INSERT INTO `rbac_access` VALUES (5, 5);
INSERT INTO `rbac_access` VALUES (5, 6);
INSERT INTO `rbac_access` VALUES (5, 7);
INSERT INTO `rbac_access` VALUES (5, 8);
INSERT INTO `rbac_access` VALUES (5, 9);
INSERT INTO `rbac_access` VALUES (5, 10);
INSERT INTO `rbac_access` VALUES (5, 11);
INSERT INTO `rbac_access` VALUES (5, 12);
INSERT INTO `rbac_access` VALUES (5, 13);
INSERT INTO `rbac_access` VALUES (5, 14);
INSERT INTO `rbac_access` VALUES (5, 15);
INSERT INTO `rbac_access` VALUES (5, 16);
INSERT INTO `rbac_access` VALUES (5, 17);
INSERT INTO `rbac_access` VALUES (5, 18);
INSERT INTO `rbac_access` VALUES (5, 114);
INSERT INTO `rbac_access` VALUES (5, 115);
INSERT INTO `rbac_access` VALUES (5, 175);
INSERT INTO `rbac_access` VALUES (5, 176);
INSERT INTO `rbac_access` VALUES (5, 177);
INSERT INTO `rbac_access` VALUES (5, 178);
INSERT INTO `rbac_access` VALUES (31, 1);
INSERT INTO `rbac_access` VALUES (31, 187);
INSERT INTO `rbac_access` VALUES (31, 189);
INSERT INTO `rbac_access` VALUES (31, 191);
INSERT INTO `rbac_access` VALUES (31, 193);
INSERT INTO `rbac_access` VALUES (31, 195);
INSERT INTO `rbac_access` VALUES (31, 116);
INSERT INTO `rbac_access` VALUES (31, 122);
INSERT INTO `rbac_access` VALUES (31, 123);
INSERT INTO `rbac_access` VALUES (31, 124);
INSERT INTO `rbac_access` VALUES (31, 125);
INSERT INTO `rbac_access` VALUES (31, 132);
INSERT INTO `rbac_access` VALUES (31, 140);
INSERT INTO `rbac_access` VALUES (31, 141);
INSERT INTO `rbac_access` VALUES (31, 142);
INSERT INTO `rbac_access` VALUES (31, 133);
INSERT INTO `rbac_access` VALUES (31, 143);
INSERT INTO `rbac_access` VALUES (31, 144);
INSERT INTO `rbac_access` VALUES (31, 145);
INSERT INTO `rbac_access` VALUES (31, 117);
INSERT INTO `rbac_access` VALUES (31, 126);
INSERT INTO `rbac_access` VALUES (31, 127);
INSERT INTO `rbac_access` VALUES (31, 128);
INSERT INTO `rbac_access` VALUES (31, 129);
INSERT INTO `rbac_access` VALUES (31, 130);
INSERT INTO `rbac_access` VALUES (31, 134);
INSERT INTO `rbac_access` VALUES (31, 135);
INSERT INTO `rbac_access` VALUES (31, 136);
INSERT INTO `rbac_access` VALUES (31, 131);
INSERT INTO `rbac_access` VALUES (31, 137);
INSERT INTO `rbac_access` VALUES (31, 138);
INSERT INTO `rbac_access` VALUES (31, 139);
INSERT INTO `rbac_access` VALUES (31, 158);
INSERT INTO `rbac_access` VALUES (31, 162);
INSERT INTO `rbac_access` VALUES (31, 163);
INSERT INTO `rbac_access` VALUES (31, 164);
INSERT INTO `rbac_access` VALUES (31, 165);
INSERT INTO `rbac_access` VALUES (31, 170);
INSERT INTO `rbac_access` VALUES (31, 173);
INSERT INTO `rbac_access` VALUES (31, 118);
INSERT INTO `rbac_access` VALUES (31, 146);
INSERT INTO `rbac_access` VALUES (31, 149);
INSERT INTO `rbac_access` VALUES (31, 152);
INSERT INTO `rbac_access` VALUES (31, 155);
INSERT INTO `rbac_access` VALUES (31, 147);
INSERT INTO `rbac_access` VALUES (31, 150);
INSERT INTO `rbac_access` VALUES (31, 153);
INSERT INTO `rbac_access` VALUES (31, 156);
INSERT INTO `rbac_access` VALUES (31, 148);
INSERT INTO `rbac_access` VALUES (31, 151);
INSERT INTO `rbac_access` VALUES (31, 154);
INSERT INTO `rbac_access` VALUES (31, 157);
INSERT INTO `rbac_access` VALUES (31, 119);
INSERT INTO `rbac_access` VALUES (31, 166);
INSERT INTO `rbac_access` VALUES (31, 167);
INSERT INTO `rbac_access` VALUES (31, 168);
INSERT INTO `rbac_access` VALUES (31, 169);
INSERT INTO `rbac_access` VALUES (31, 171);
INSERT INTO `rbac_access` VALUES (31, 174);
INSERT INTO `rbac_access` VALUES (31, 120);
INSERT INTO `rbac_access` VALUES (31, 183);
INSERT INTO `rbac_access` VALUES (31, 184);
INSERT INTO `rbac_access` VALUES (31, 121);
INSERT INTO `rbac_access` VALUES (31, 179);
INSERT INTO `rbac_access` VALUES (31, 181);
INSERT INTO `rbac_access` VALUES (31, 180);
INSERT INTO `rbac_access` VALUES (31, 182);
INSERT INTO `rbac_access` VALUES (31, 197);
INSERT INTO `rbac_access` VALUES (31, 199);
INSERT INTO `rbac_access` VALUES (31, 2);
INSERT INTO `rbac_access` VALUES (31, 3);
INSERT INTO `rbac_access` VALUES (31, 4);
INSERT INTO `rbac_access` VALUES (31, 5);
INSERT INTO `rbac_access` VALUES (31, 6);
INSERT INTO `rbac_access` VALUES (31, 7);
INSERT INTO `rbac_access` VALUES (31, 8);
INSERT INTO `rbac_access` VALUES (31, 9);
INSERT INTO `rbac_access` VALUES (31, 10);
INSERT INTO `rbac_access` VALUES (31, 11);
INSERT INTO `rbac_access` VALUES (31, 12);
INSERT INTO `rbac_access` VALUES (31, 13);
INSERT INTO `rbac_access` VALUES (31, 14);
INSERT INTO `rbac_access` VALUES (31, 15);
INSERT INTO `rbac_access` VALUES (31, 16);
INSERT INTO `rbac_access` VALUES (31, 17);
INSERT INTO `rbac_access` VALUES (31, 18);
INSERT INTO `rbac_access` VALUES (31, 114);
INSERT INTO `rbac_access` VALUES (31, 115);
INSERT INTO `rbac_access` VALUES (31, 175);
INSERT INTO `rbac_access` VALUES (31, 176);
INSERT INTO `rbac_access` VALUES (31, 177);
INSERT INTO `rbac_access` VALUES (31, 178);
INSERT INTO `rbac_access` VALUES (30, 1);
INSERT INTO `rbac_access` VALUES (30, 187);
INSERT INTO `rbac_access` VALUES (30, 189);
INSERT INTO `rbac_access` VALUES (30, 191);
INSERT INTO `rbac_access` VALUES (30, 193);
INSERT INTO `rbac_access` VALUES (30, 195);
INSERT INTO `rbac_access` VALUES (30, 117);
INSERT INTO `rbac_access` VALUES (30, 126);
INSERT INTO `rbac_access` VALUES (30, 127);
INSERT INTO `rbac_access` VALUES (30, 128);
INSERT INTO `rbac_access` VALUES (30, 129);
INSERT INTO `rbac_access` VALUES (30, 130);
INSERT INTO `rbac_access` VALUES (30, 134);
INSERT INTO `rbac_access` VALUES (30, 135);
INSERT INTO `rbac_access` VALUES (30, 136);
INSERT INTO `rbac_access` VALUES (30, 131);
INSERT INTO `rbac_access` VALUES (30, 137);
INSERT INTO `rbac_access` VALUES (30, 138);
INSERT INTO `rbac_access` VALUES (30, 139);
INSERT INTO `rbac_access` VALUES (30, 116);
INSERT INTO `rbac_access` VALUES (30, 122);
INSERT INTO `rbac_access` VALUES (30, 123);
INSERT INTO `rbac_access` VALUES (30, 124);
INSERT INTO `rbac_access` VALUES (30, 125);
INSERT INTO `rbac_access` VALUES (30, 132);
INSERT INTO `rbac_access` VALUES (30, 140);
INSERT INTO `rbac_access` VALUES (30, 141);
INSERT INTO `rbac_access` VALUES (30, 142);
INSERT INTO `rbac_access` VALUES (30, 133);
INSERT INTO `rbac_access` VALUES (30, 143);
INSERT INTO `rbac_access` VALUES (30, 144);
INSERT INTO `rbac_access` VALUES (30, 145);
INSERT INTO `rbac_access` VALUES (30, 158);
INSERT INTO `rbac_access` VALUES (30, 162);
INSERT INTO `rbac_access` VALUES (30, 163);
INSERT INTO `rbac_access` VALUES (30, 164);
INSERT INTO `rbac_access` VALUES (30, 165);
INSERT INTO `rbac_access` VALUES (30, 170);
INSERT INTO `rbac_access` VALUES (30, 173);
INSERT INTO `rbac_access` VALUES (30, 118);
INSERT INTO `rbac_access` VALUES (30, 146);
INSERT INTO `rbac_access` VALUES (30, 149);
INSERT INTO `rbac_access` VALUES (30, 152);
INSERT INTO `rbac_access` VALUES (30, 155);
INSERT INTO `rbac_access` VALUES (30, 147);
INSERT INTO `rbac_access` VALUES (30, 150);
INSERT INTO `rbac_access` VALUES (30, 153);
INSERT INTO `rbac_access` VALUES (30, 156);
INSERT INTO `rbac_access` VALUES (30, 148);
INSERT INTO `rbac_access` VALUES (30, 151);
INSERT INTO `rbac_access` VALUES (30, 154);
INSERT INTO `rbac_access` VALUES (30, 157);
INSERT INTO `rbac_access` VALUES (30, 119);
INSERT INTO `rbac_access` VALUES (30, 166);
INSERT INTO `rbac_access` VALUES (30, 167);
INSERT INTO `rbac_access` VALUES (30, 168);
INSERT INTO `rbac_access` VALUES (30, 169);
INSERT INTO `rbac_access` VALUES (30, 171);
INSERT INTO `rbac_access` VALUES (30, 174);
INSERT INTO `rbac_access` VALUES (30, 120);
INSERT INTO `rbac_access` VALUES (30, 183);
INSERT INTO `rbac_access` VALUES (30, 184);
INSERT INTO `rbac_access` VALUES (30, 121);
INSERT INTO `rbac_access` VALUES (30, 179);
INSERT INTO `rbac_access` VALUES (30, 181);
INSERT INTO `rbac_access` VALUES (30, 180);
INSERT INTO `rbac_access` VALUES (30, 182);
INSERT INTO `rbac_access` VALUES (30, 197);
INSERT INTO `rbac_access` VALUES (30, 199);
INSERT INTO `rbac_access` VALUES (30, 2);
INSERT INTO `rbac_access` VALUES (30, 3);
INSERT INTO `rbac_access` VALUES (30, 4);
INSERT INTO `rbac_access` VALUES (30, 5);
INSERT INTO `rbac_access` VALUES (30, 6);
INSERT INTO `rbac_access` VALUES (30, 7);
INSERT INTO `rbac_access` VALUES (30, 8);
INSERT INTO `rbac_access` VALUES (30, 9);
INSERT INTO `rbac_access` VALUES (30, 10);
INSERT INTO `rbac_access` VALUES (30, 11);
INSERT INTO `rbac_access` VALUES (30, 12);
INSERT INTO `rbac_access` VALUES (30, 13);
INSERT INTO `rbac_access` VALUES (30, 14);
INSERT INTO `rbac_access` VALUES (30, 15);
INSERT INTO `rbac_access` VALUES (30, 16);
INSERT INTO `rbac_access` VALUES (30, 17);
INSERT INTO `rbac_access` VALUES (30, 18);
INSERT INTO `rbac_access` VALUES (30, 114);
INSERT INTO `rbac_access` VALUES (30, 115);
INSERT INTO `rbac_access` VALUES (30, 175);
INSERT INTO `rbac_access` VALUES (30, 176);
INSERT INTO `rbac_access` VALUES (30, 177);
INSERT INTO `rbac_access` VALUES (30, 178);
COMMIT;

-- ----------------------------
-- Table structure for rbac_menu
-- ----------------------------
DROP TABLE IF EXISTS `rbac_menu`;
CREATE TABLE `rbac_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL COMMENT '菜单标题',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
  `image` varchar(100) DEFAULT NULL COMMENT '菜单图片',
  `url` varchar(100) DEFAULT NULL COMMENT '菜单url，分组及模块为空',
  `style` varchar(15) DEFAULT NULL COMMENT '菜单样式',
  `js` varchar(100) DEFAULT NULL COMMENT 'js',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0目录，1页面，2权限',
  `entitle` varchar(45) NOT NULL COMMENT '英文标题',
  `remark` varchar(100) DEFAULT ' ' COMMENT '备注',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0禁用，1启用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8 COMMENT='菜单表';

-- ----------------------------
-- Records of rbac_menu
-- ----------------------------
BEGIN;
INSERT INTO `rbac_menu` VALUES (1, '后台', 0, ' ', ' ', '', '', 0, '后台管理', '根目录', 0, 1);
INSERT INTO `rbac_menu` VALUES (2, '系统配置', 1, NULL, '', NULL, NULL, 0, '角色权限', '角色权限分组', 99, 1);
INSERT INTO `rbac_menu` VALUES (3, '角色管理', 2, '', '/System/role/rolelist', '', '', 1, '角色管理', '入口页面', 1, 1);
INSERT INTO `rbac_menu` VALUES (4, '浏览权限', 3, '', '', '', '', 2, '浏览权限', '绑定相应权限', 1, 1);
INSERT INTO `rbac_menu` VALUES (5, '添加修改权限', 3, '', '', '', '', 2, '添加权限', '绑定相应添加修改权限', 2, 1);
INSERT INTO `rbac_menu` VALUES (6, '删除权限', 3, '', '', '', '', 2, '删除权限', '绑定删除权限', 3, 1);
INSERT INTO `rbac_menu` VALUES (7, '权限管理', 2, NULL, '/System/node/nodelist', NULL, NULL, 1, '权限管理', '入口页面', 2, 1);
INSERT INTO `rbac_menu` VALUES (8, '浏览权限', 7, NULL, '', NULL, NULL, 2, '浏览权限', '绑定页面浏览权限包括添加修改页面', 1, 1);
INSERT INTO `rbac_menu` VALUES (9, '添加修改权限', 7, NULL, '', NULL, NULL, 2, '添加修改权限', '绑定添加修改处理操作权限', 2, 1);
INSERT INTO `rbac_menu` VALUES (10, '删除权限', 7, NULL, '', NULL, NULL, 2, '删除权限', '绑定删除权限', 3, 1);
INSERT INTO `rbac_menu` VALUES (11, '用户管理', 2, NULL, '/System/user/userlist', NULL, NULL, 1, '用户管理', '入口页面', 3, 1);
INSERT INTO `rbac_menu` VALUES (12, '浏览权限', 11, NULL, '', NULL, NULL, 2, '浏览权限', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (13, '添加修改权限', 11, NULL, '', NULL, NULL, 2, '添加修改权限', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (14, '删除权限', 11, NULL, '', NULL, NULL, 2, '删除权限', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (15, '菜单管理', 2, NULL, '/System/menu/menulist', NULL, NULL, 1, '菜单管理', '入口页面', 4, 1);
INSERT INTO `rbac_menu` VALUES (16, '浏览权限', 15, NULL, '', NULL, NULL, 2, '浏览权限', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (17, '添加修改权限', 15, NULL, '', NULL, NULL, 2, '添加修改权限', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (18, '删除权限', 15, NULL, '', NULL, NULL, 2, '删除权限', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (114, '日志管理', 2, NULL, '/system/log/loglist', NULL, NULL, 1, '日志管理', '', 5, 1);
INSERT INTO `rbac_menu` VALUES (115, '浏览权限', 114, NULL, '', NULL, NULL, 2, '浏览权限', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (116, '酒店管理', 1, NULL, '', NULL, NULL, 0, 'hotel', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (117, '合作方管理', 1, NULL, '', NULL, NULL, 0, 'sp', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (118, '内容管理', 1, NULL, '', NULL, NULL, 0, 'text', '', 4, 1);
INSERT INTO `rbac_menu` VALUES (119, '播控管理', 1, NULL, '', NULL, NULL, 0, 'bokong', '', 5, 1);
INSERT INTO `rbac_menu` VALUES (120, '监控告警', 1, NULL, '', NULL, NULL, 0, 'jiankong', '', 6, 1);
INSERT INTO `rbac_menu` VALUES (121, '日志管理', 1, NULL, '', NULL, NULL, 0, 'log', '', 7, 1);
INSERT INTO `rbac_menu` VALUES (122, '酒店管理', 116, NULL, '/Hotel/Hotel/index', NULL, NULL, 1, 'hotel', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (123, '浏览权限', 122, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (124, '添加修改权限', 122, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (125, '删除权限', 122, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (126, '合作方', 117, NULL, '/Sp/Sp/index', NULL, NULL, 1, 'sp', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (127, '浏览权限', 126, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (128, '添加修改权限', 126, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (129, '删除权限', 126, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (130, '配置管理', 117, NULL, '/Sp/Conf/index', NULL, NULL, 1, 'sp_conf', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (131, '类型管理', 117, NULL, '/Sp/Type/index', NULL, NULL, 1, 'sp_type', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (132, '分前端', 116, NULL, '/Hotel/Front/index', NULL, NULL, 1, 'front', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (133, '酒店区域', 116, NULL, '/Hotel/Region/index', NULL, NULL, 1, 'region', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (134, '浏览权限', 130, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (135, '添加修改权限', 130, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (136, '删除权限', 130, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (137, '浏览权限', 131, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (138, '添加修改权限', 131, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (139, '删除权限', 131, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (140, '浏览权限', 132, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (141, '添加修改权限', 132, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (142, '删除权限', 132, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (143, '浏览权限', 133, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (144, '添加修改权限', 133, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (145, '删除权限', 133, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (146, '云端片库', 118, NULL, '/Media/Cloud/index', NULL, NULL, 1, 'cloud_media', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (147, '酒店片库', 118, NULL, '/Media/Hotel/index', NULL, NULL, 1, 'hotel_media', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (148, '播单管理', 118, NULL, '/Media/Playlist/index', NULL, NULL, 1, 'playlist', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (149, '浏览权限', 146, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (150, '浏览权限', 147, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (151, '浏览权限', 148, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (152, '添加修改权限', 146, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (153, '添加修改权限', 147, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (154, '添加修改权限', 148, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (155, '删除权限', 146, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (156, '删除权限', 147, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (157, '删除权限', 148, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (158, '媒资注入', 1, NULL, '', NULL, NULL, 0, 'media_push', '', 4, 1);
INSERT INTO `rbac_menu` VALUES (162, '媒资注入', 158, NULL, '/Inject/Inject/index', NULL, NULL, 1, 'inject', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (163, '浏览权限', 162, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (164, '添加修改权限', 162, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (165, '删除权限', 162, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (166, '播控管理', 119, NULL, '/PlayCtrl/PlayCtrl/index', NULL, NULL, 1, 'play_ctrl', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (167, '浏览权限', 166, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (168, '添加修改权限', 166, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (169, '删除权限', 166, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (170, '注入日志', 158, NULL, '/Inject/InjectLog/index', NULL, NULL, 1, 'Inject_log', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (171, '播控日志', 119, NULL, '/PlayCtrl/PlayCtrlLog/index', NULL, NULL, 1, 'play_ctrl_log', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (173, '浏览权限', 170, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (174, '浏览权限', 171, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (175, '中心配置', 2, NULL, '/System/CenterConfig/index', NULL, NULL, 1, 'CenterConfig', '', 6, 1);
INSERT INTO `rbac_menu` VALUES (176, '浏览权限', 175, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (177, '添加修改权限', 175, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (178, '删除权限', 175, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (179, '播放日志', 121, NULL, '/Log/PlayLog/index', NULL, NULL, 1, 'PlayLog', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (180, '推送日志', 121, NULL, '/Log/PushLog/index', NULL, NULL, 1, 'PushLog', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (181, '浏览权限', 179, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (182, '浏览权限', 180, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (183, '设备监控', 120, NULL, '/Monitor/Device/index', NULL, NULL, 1, 'device', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (184, '浏览权限', 183, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (187, '站点管理', 1, NULL, '', NULL, NULL, 0, 'site', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (189, '站点管理', 187, NULL, '/Site/Site/index', NULL, NULL, 1, 'site', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (191, '浏览权限', 189, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
INSERT INTO `rbac_menu` VALUES (193, '添加修改权限', 189, NULL, '', NULL, NULL, 2, 'add', '', 2, 1);
INSERT INTO `rbac_menu` VALUES (195, '删除权限', 189, NULL, '', NULL, NULL, 2, 'delete', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (197, '拉取日志', 121, NULL, '/Log/PullLog/index', NULL, NULL, 1, 'PullLog', '', 3, 1);
INSERT INTO `rbac_menu` VALUES (199, '浏览权限', 197, NULL, '', NULL, NULL, 2, 'index', '', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for rbac_menu_node
-- ----------------------------
DROP TABLE IF EXISTS `rbac_menu_node`;
CREATE TABLE `rbac_menu_node` (
  `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `node_id` int(10) unsigned NOT NULL COMMENT '权限ID',
  KEY `Index_1` (`menu_id`) USING BTREE,
  KEY `Index_2` (`node_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8 COMMENT='菜单权限关联表';

-- ----------------------------
-- Records of rbac_menu_node
-- ----------------------------
BEGIN;
INSERT INTO `rbac_menu_node` VALUES (4, 63);
INSERT INTO `rbac_menu_node` VALUES (4, 62);
INSERT INTO `rbac_menu_node` VALUES (5, 65);
INSERT INTO `rbac_menu_node` VALUES (6, 99);
INSERT INTO `rbac_menu_node` VALUES (5, 77);
INSERT INTO `rbac_menu_node` VALUES (4, 76);
INSERT INTO `rbac_menu_node` VALUES (8, 75);
INSERT INTO `rbac_menu_node` VALUES (8, 64);
INSERT INTO `rbac_menu_node` VALUES (9, 101);
INSERT INTO `rbac_menu_node` VALUES (9, 66);
INSERT INTO `rbac_menu_node` VALUES (10, 103);
INSERT INTO `rbac_menu_node` VALUES (12, 72);
INSERT INTO `rbac_menu_node` VALUES (12, 71);
INSERT INTO `rbac_menu_node` VALUES (13, 73);
INSERT INTO `rbac_menu_node` VALUES (14, 100);
INSERT INTO `rbac_menu_node` VALUES (16, 107);
INSERT INTO `rbac_menu_node` VALUES (16, 111);
INSERT INTO `rbac_menu_node` VALUES (16, 106);
INSERT INTO `rbac_menu_node` VALUES (17, 110);
INSERT INTO `rbac_menu_node` VALUES (17, 108);
INSERT INTO `rbac_menu_node` VALUES (18, 109);
INSERT INTO `rbac_menu_node` VALUES (115, 231);
INSERT INTO `rbac_menu_node` VALUES (115, 232);
INSERT INTO `rbac_menu_node` VALUES (13, 244);
INSERT INTO `rbac_menu_node` VALUES (13, 105);
INSERT INTO `rbac_menu_node` VALUES (123, 247);
INSERT INTO `rbac_menu_node` VALUES (124, 248);
INSERT INTO `rbac_menu_node` VALUES (124, 249);
INSERT INTO `rbac_menu_node` VALUES (124, 251);
INSERT INTO `rbac_menu_node` VALUES (125, 250);
INSERT INTO `rbac_menu_node` VALUES (127, 254);
INSERT INTO `rbac_menu_node` VALUES (128, 255);
INSERT INTO `rbac_menu_node` VALUES (128, 256);
INSERT INTO `rbac_menu_node` VALUES (128, 258);
INSERT INTO `rbac_menu_node` VALUES (129, 257);
INSERT INTO `rbac_menu_node` VALUES (134, 273);
INSERT INTO `rbac_menu_node` VALUES (135, 274);
INSERT INTO `rbac_menu_node` VALUES (135, 275);
INSERT INTO `rbac_menu_node` VALUES (135, 277);
INSERT INTO `rbac_menu_node` VALUES (136, 276);
INSERT INTO `rbac_menu_node` VALUES (137, 278);
INSERT INTO `rbac_menu_node` VALUES (138, 279);
INSERT INTO `rbac_menu_node` VALUES (138, 280);
INSERT INTO `rbac_menu_node` VALUES (138, 282);
INSERT INTO `rbac_menu_node` VALUES (139, 281);
INSERT INTO `rbac_menu_node` VALUES (143, 268);
INSERT INTO `rbac_menu_node` VALUES (144, 269);
INSERT INTO `rbac_menu_node` VALUES (144, 270);
INSERT INTO `rbac_menu_node` VALUES (144, 272);
INSERT INTO `rbac_menu_node` VALUES (145, 271);
INSERT INTO `rbac_menu_node` VALUES (140, 263);
INSERT INTO `rbac_menu_node` VALUES (141, 264);
INSERT INTO `rbac_menu_node` VALUES (141, 265);
INSERT INTO `rbac_menu_node` VALUES (141, 267);
INSERT INTO `rbac_menu_node` VALUES (142, 266);
INSERT INTO `rbac_menu_node` VALUES (149, 287);
INSERT INTO `rbac_menu_node` VALUES (152, 290);
INSERT INTO `rbac_menu_node` VALUES (152, 293);
INSERT INTO `rbac_menu_node` VALUES (152, 299);
INSERT INTO `rbac_menu_node` VALUES (155, 296);
INSERT INTO `rbac_menu_node` VALUES (156, 297);
INSERT INTO `rbac_menu_node` VALUES (151, 289);
INSERT INTO `rbac_menu_node` VALUES (154, 292);
INSERT INTO `rbac_menu_node` VALUES (154, 295);
INSERT INTO `rbac_menu_node` VALUES (154, 301);
INSERT INTO `rbac_menu_node` VALUES (157, 298);
INSERT INTO `rbac_menu_node` VALUES (164, 305);
INSERT INTO `rbac_menu_node` VALUES (164, 306);
INSERT INTO `rbac_menu_node` VALUES (165, 307);
INSERT INTO `rbac_menu_node` VALUES (169, 313);
INSERT INTO `rbac_menu_node` VALUES (173, 315);
INSERT INTO `rbac_menu_node` VALUES (174, 317);
INSERT INTO `rbac_menu_node` VALUES (176, 319);
INSERT INTO `rbac_menu_node` VALUES (177, 320);
INSERT INTO `rbac_menu_node` VALUES (177, 321);
INSERT INTO `rbac_menu_node` VALUES (177, 323);
INSERT INTO `rbac_menu_node` VALUES (178, 322);
INSERT INTO `rbac_menu_node` VALUES (182, 328);
INSERT INTO `rbac_menu_node` VALUES (184, 332);
INSERT INTO `rbac_menu_node` VALUES (184, 331);
INSERT INTO `rbac_menu_node` VALUES (168, 311);
INSERT INTO `rbac_menu_node` VALUES (168, 312);
INSERT INTO `rbac_menu_node` VALUES (168, 333);
INSERT INTO `rbac_menu_node` VALUES (153, 291);
INSERT INTO `rbac_menu_node` VALUES (153, 294);
INSERT INTO `rbac_menu_node` VALUES (153, 300);
INSERT INTO `rbac_menu_node` VALUES (153, 335);
INSERT INTO `rbac_menu_node` VALUES (191, 345);
INSERT INTO `rbac_menu_node` VALUES (193, 347);
INSERT INTO `rbac_menu_node` VALUES (193, 349);
INSERT INTO `rbac_menu_node` VALUES (193, 353);
INSERT INTO `rbac_menu_node` VALUES (195, 351);
INSERT INTO `rbac_menu_node` VALUES (199, 357);
INSERT INTO `rbac_menu_node` VALUES (181, 327);
INSERT INTO `rbac_menu_node` VALUES (181, 359);
INSERT INTO `rbac_menu_node` VALUES (150, 361);
INSERT INTO `rbac_menu_node` VALUES (150, 288);
INSERT INTO `rbac_menu_node` VALUES (163, 363);
INSERT INTO `rbac_menu_node` VALUES (163, 304);
INSERT INTO `rbac_menu_node` VALUES (167, 364);
INSERT INTO `rbac_menu_node` VALUES (167, 310);
COMMIT;

-- ----------------------------
-- Table structure for rbac_node
-- ----------------------------
DROP TABLE IF EXISTS `rbac_node`;
CREATE TABLE `rbac_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `remark` varchar(255) DEFAULT NULL,
  `sort` smallint(5) unsigned DEFAULT NULL,
  `pid` smallint(6) unsigned NOT NULL,
  `level` tinyint(1) unsigned DEFAULT NULL,
  `type` tinyint(1) DEFAULT '0',
  `module` varchar(25) DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `level` (`level`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE,
  KEY `status` (`status`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=365 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rbac_node
-- ----------------------------
BEGIN;
INSERT INTO `rbac_node` VALUES (60, 'System', '系统管理', 1, '', 1, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (62, 'addRole', '角色添加/修改', 1, '', 2, 211, 3, 0, '');
INSERT INTO `rbac_node` VALUES (63, 'roleList', '角色管理', 1, '', 1, 211, 3, 0, '');
INSERT INTO `rbac_node` VALUES (64, 'addNode', '权限添加', 1, '该功能只有sysadmin可以操作', 2, 212, 3, 0, '');
INSERT INTO `rbac_node` VALUES (65, 'addRoleHandle', '角色添加/修改处理', 1, '', 3, 211, 3, 0, '');
INSERT INTO `rbac_node` VALUES (66, 'addNodeHandle', '权限添加处理', 1, '该功能只有sysadmin可以操作', 3, 212, 3, 0, '');
INSERT INTO `rbac_node` VALUES (71, 'userList', '用户管理', 1, '', 1, 213, 3, 0, '');
INSERT INTO `rbac_node` VALUES (72, 'addUser', '用户添加/修改', 1, '', 2, 213, 3, 0, '');
INSERT INTO `rbac_node` VALUES (73, 'addUserHandle', '用户添加/修改处理', 1, '', 4, 213, 3, 0, '');
INSERT INTO `rbac_node` VALUES (75, 'nodelist', '权限管理', 1, '该功能只有sysadmin可以操作', 1, 212, 3, 0, '');
INSERT INTO `rbac_node` VALUES (76, 'access', '权限配置', 1, '', 5, 211, 3, 0, '');
INSERT INTO `rbac_node` VALUES (77, 'setAccessHandle', '权限配置处理', 1, '', 6, 211, 3, 0, '');
INSERT INTO `rbac_node` VALUES (99, 'deleteRoleHandle', '角色删除处理', 1, '', 4, 211, 3, 0, '');
INSERT INTO `rbac_node` VALUES (100, 'deleteUserHandle', '用户删除处理', 1, '', 5, 213, 3, 0, '');
INSERT INTO `rbac_node` VALUES (101, 'updateNodeAjaxHandle', '权限修改-ajax处理', 1, '该功能只有sysadmin可以操作', 4, 212, 3, 0, '');
INSERT INTO `rbac_node` VALUES (103, 'deleteNodeHandle', '权限删除处理', 1, '该功能只有sysadmin可以操作', 5, 212, 3, 0, '');
INSERT INTO `rbac_node` VALUES (105, 'updateUserAjaxHandle', '用户修改-ajax处理', 1, '', 3, 213, 3, 0, '');
INSERT INTO `rbac_node` VALUES (106, 'menulist', '菜单管理', 1, '', 1, 214, 3, 0, '');
INSERT INTO `rbac_node` VALUES (107, 'addMenu', '菜单添加/修改', 1, '', 2, 214, 3, 0, '');
INSERT INTO `rbac_node` VALUES (108, 'addMenuHandle', '菜单添加/修改处理', 1, '', 3, 214, 3, 0, '');
INSERT INTO `rbac_node` VALUES (109, 'deleteMenuHandle', '菜单删除处理', 1, '', 5, 214, 3, 0, '');
INSERT INTO `rbac_node` VALUES (110, 'updateMenuAjaxHandle', '菜单修改-ajax处理', 1, '', 4, 214, 3, 0, '');
INSERT INTO `rbac_node` VALUES (111, 'getMenuListJson', '菜单添加/修改-获取父级json列表', 1, '浏览权限', 6, 214, 3, 0, '');
INSERT INTO `rbac_node` VALUES (211, 'Role', '角色管理', 1, '', 1, 60, 2, 0, '');
INSERT INTO `rbac_node` VALUES (212, 'Node', '权限管理', 1, '', 2, 60, 2, 0, '');
INSERT INTO `rbac_node` VALUES (213, 'User', '用户管理', 1, '', 3, 60, 2, 0, '');
INSERT INTO `rbac_node` VALUES (214, 'Menu', '菜单管理', 1, '', 4, 60, 2, 0, '');
INSERT INTO `rbac_node` VALUES (230, 'Log', '日志管理', 1, '', 5, 60, 2, 0, '');
INSERT INTO `rbac_node` VALUES (231, 'loglist', '操作日志', 1, '', 1, 230, 3, 0, '');
INSERT INTO `rbac_node` VALUES (232, 'logdetails', '日志详细', 1, '', 2, 230, 3, 0, '');
INSERT INTO `rbac_node` VALUES (244, 'checkloginname', '用户名验证', 1, '', 6, 213, 3, 0, '');
INSERT INTO `rbac_node` VALUES (245, 'Hotel', '酒店管理', 1, '', 2, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (246, 'Hotel', '酒店管理', 1, '', 1, 245, 2, 0, '');
INSERT INTO `rbac_node` VALUES (247, 'index', '酒店管理', 1, '', 1, 246, 3, 0, '');
INSERT INTO `rbac_node` VALUES (248, 'add', '酒店添加/修改', 1, '', 2, 246, 3, 0, '');
INSERT INTO `rbac_node` VALUES (249, 'addHandle', '酒店添加/修改处理', 1, '', 3, 246, 3, 0, '');
INSERT INTO `rbac_node` VALUES (250, 'deleteHandle', '酒店删除处理', 1, '', 4, 246, 3, 0, '');
INSERT INTO `rbac_node` VALUES (251, 'updateStatusAjaxHandle', '酒店禁用/启用处理', 1, '', 5, 246, 3, 0, '');
INSERT INTO `rbac_node` VALUES (252, 'Sp', '合作方管理', 1, '', 3, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (253, 'Sp', '合作方管理', 1, '', 1, 252, 2, 0, '');
INSERT INTO `rbac_node` VALUES (254, 'index', '合作方管理', 1, '', 1, 253, 3, 0, '');
INSERT INTO `rbac_node` VALUES (255, 'add', '合作方添加/修改', 1, '', 2, 253, 3, 0, '');
INSERT INTO `rbac_node` VALUES (256, 'addHandle', '合作方添加/修改处理', 1, '', 3, 253, 3, 0, '');
INSERT INTO `rbac_node` VALUES (257, 'deleteHandle', '合作方删除处理', 1, '', 4, 253, 3, 0, '');
INSERT INTO `rbac_node` VALUES (258, 'updateStatusAjaxHandle', '合作方禁用/启用处理', 1, '', 5, 253, 3, 0, '');
INSERT INTO `rbac_node` VALUES (259, 'Front', '分前端管理', 1, '', 2, 245, 2, 0, '');
INSERT INTO `rbac_node` VALUES (260, 'Region', '酒店区域管理', 1, '', 3, 245, 2, 0, '');
INSERT INTO `rbac_node` VALUES (261, 'Conf', '合作方配置管理', 1, '', 2, 252, 2, 0, '');
INSERT INTO `rbac_node` VALUES (262, 'Type', '合作方类型管理', 1, '', 3, 252, 2, 0, '');
INSERT INTO `rbac_node` VALUES (263, 'index', '分前端管理', 1, '', 1, 259, 3, 0, '');
INSERT INTO `rbac_node` VALUES (264, 'add', '分前端添加/修改', 1, '', 2, 259, 3, 0, '');
INSERT INTO `rbac_node` VALUES (265, 'addHandle', '分前端添加/修改处理', 1, '', 3, 259, 3, 0, '');
INSERT INTO `rbac_node` VALUES (266, 'deleteHandle', '分前端删除处理', 1, '', 4, 259, 3, 0, '');
INSERT INTO `rbac_node` VALUES (267, 'updateStatusAjaxHandle', '分前端禁用/启用处理', 1, '', 5, 259, 3, 0, '');
INSERT INTO `rbac_node` VALUES (268, 'index', '酒店区域管理', 1, '', 1, 260, 3, 0, '');
INSERT INTO `rbac_node` VALUES (269, 'add', '酒店区域添加/修改', 1, '', 2, 260, 3, 0, '');
INSERT INTO `rbac_node` VALUES (270, 'addHandle', '酒店区域添加/修改处理', 1, '', 3, 260, 3, 0, '');
INSERT INTO `rbac_node` VALUES (271, 'deleteHandle', '酒店区域删除处理', 1, '', 4, 260, 3, 0, '');
INSERT INTO `rbac_node` VALUES (272, 'updateStatusAjaxHandle', '酒店区域禁用/启用处理', 1, '', 5, 260, 3, 0, '');
INSERT INTO `rbac_node` VALUES (273, 'index', '合作方配置管理', 1, '', 1, 261, 3, 0, '');
INSERT INTO `rbac_node` VALUES (274, 'add', '合作方配置添加/修改', 1, '', 2, 261, 3, 0, '');
INSERT INTO `rbac_node` VALUES (275, 'addHandle', '合作方配置添加/修改处理', 1, '', 3, 261, 3, 0, '');
INSERT INTO `rbac_node` VALUES (276, 'deleteHandle', '合作方配置删除处理', 1, '', 4, 261, 3, 0, '');
INSERT INTO `rbac_node` VALUES (277, 'updateStatusAjaxHandle', '合作方配置禁用/启用处理', 1, '', 5, 261, 3, 0, '');
INSERT INTO `rbac_node` VALUES (278, 'index', '合作方类型管理', 1, '', 1, 262, 3, 0, '');
INSERT INTO `rbac_node` VALUES (279, 'add', '合作方类型添加/修改', 1, '', 2, 262, 3, 0, '');
INSERT INTO `rbac_node` VALUES (280, 'addHandle', '合作方类型添加/修改处理', 1, '', 3, 262, 3, 0, '');
INSERT INTO `rbac_node` VALUES (281, 'deleteHandle', '合作方类型删除处理', 1, '', 4, 262, 3, 0, '');
INSERT INTO `rbac_node` VALUES (282, 'updateStatusAjaxHandle', '合作方类型禁用/启用处理', 1, '', 5, 262, 3, 0, '');
INSERT INTO `rbac_node` VALUES (283, 'Media', '内容管理', 1, '', 4, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (284, 'Cloud', '云端片库', 1, '', 1, 283, 2, 0, '');
INSERT INTO `rbac_node` VALUES (285, 'Hotel', '酒店片库', 1, '', 2, 283, 2, 0, '');
INSERT INTO `rbac_node` VALUES (286, 'Playlist', '播单管理', 1, '', 3, 283, 2, 0, '');
INSERT INTO `rbac_node` VALUES (287, 'index', '云端片库管理', 1, '', 1, 284, 3, 0, '');
INSERT INTO `rbac_node` VALUES (288, 'index', '酒店片库管理', 1, '', 1, 285, 3, 0, '');
INSERT INTO `rbac_node` VALUES (289, 'index', '播单管理', 1, '', 1, 286, 3, 0, '');
INSERT INTO `rbac_node` VALUES (290, 'add', '云端片库添加/修改', 1, '', 2, 284, 3, 0, '');
INSERT INTO `rbac_node` VALUES (291, 'add', '酒店片库添加/修改', 1, '', 2, 285, 3, 0, '');
INSERT INTO `rbac_node` VALUES (292, 'add', '播单添加/修改', 1, '', 2, 286, 3, 0, '');
INSERT INTO `rbac_node` VALUES (293, 'addHandle', '云端片库添加/修改处理', 1, '', 3, 284, 3, 0, '');
INSERT INTO `rbac_node` VALUES (294, 'addHandle', '酒店片库添加/修改处理', 1, '', 3, 285, 3, 0, '');
INSERT INTO `rbac_node` VALUES (295, 'addHandle', '播单添加/修改处理', 1, '', 3, 286, 3, 0, '');
INSERT INTO `rbac_node` VALUES (296, 'deleteHandle', '云端片库删除处理', 1, '', 4, 284, 3, 0, '');
INSERT INTO `rbac_node` VALUES (297, 'deleteHandle', '酒店片库删除处理', 1, '', 4, 285, 3, 0, '');
INSERT INTO `rbac_node` VALUES (298, 'deleteHandle', '播单删除处理', 1, '', 4, 286, 3, 0, '');
INSERT INTO `rbac_node` VALUES (299, 'updateStatusAjaxHandle', '云端片库禁用/启用处理', 1, '', 5, 284, 3, 0, '');
INSERT INTO `rbac_node` VALUES (300, 'updateStatusAjaxHandle', '酒店片库禁用/启用处理', 1, '', 5, 285, 3, 0, '');
INSERT INTO `rbac_node` VALUES (301, 'updateStatusAjaxHandle', '播单禁用/启用处理', 1, '', 5, 286, 3, 0, '');
INSERT INTO `rbac_node` VALUES (302, 'Inject', '媒资注入', 1, '', 4, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (303, 'Inject', '媒资注入', 1, '', 1, 302, 2, 0, '');
INSERT INTO `rbac_node` VALUES (304, 'index', '媒资注入管理', 1, '', 1, 303, 3, 0, '');
INSERT INTO `rbac_node` VALUES (305, 'add', '媒资注入添加/修改', 1, '', 2, 303, 3, 0, '');
INSERT INTO `rbac_node` VALUES (306, 'addHandle', '媒资注入添加/修改处理', 1, '', 3, 303, 3, 0, '');
INSERT INTO `rbac_node` VALUES (307, 'deleteHandle', '媒资注入删除处理', 1, '', 4, 303, 3, 0, '');
INSERT INTO `rbac_node` VALUES (308, 'PlayCtrl', '播控管理', 1, '', 5, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (309, 'PlayCtrl', '播控管理', 1, '', 1, 308, 2, 0, '');
INSERT INTO `rbac_node` VALUES (310, 'index', '播控管理', 1, '', 1, 309, 3, 0, '');
INSERT INTO `rbac_node` VALUES (311, 'add', '播控添加/修改', 1, '', 2, 309, 3, 0, '');
INSERT INTO `rbac_node` VALUES (312, 'addHandle', '播控添加/修改处理', 1, '', 3, 309, 3, 0, '');
INSERT INTO `rbac_node` VALUES (313, 'deleteHandle', '播控删除处理', 1, '', 4, 309, 3, 0, '');
INSERT INTO `rbac_node` VALUES (314, 'InjectLog', '媒资注入日志', 1, '', 2, 302, 2, 0, '');
INSERT INTO `rbac_node` VALUES (315, 'index', '媒资注入日志管理', 1, '', 1, 314, 3, 0, '');
INSERT INTO `rbac_node` VALUES (316, 'PlayCtrlLog', '播控日志管理', 1, '', 2, 308, 2, 0, '');
INSERT INTO `rbac_node` VALUES (317, 'index', '播控日志管理', 1, '', 1, 316, 3, 0, '');
INSERT INTO `rbac_node` VALUES (318, 'CenterConfig', '中心配置', 1, '', 6, 60, 2, 0, '');
INSERT INTO `rbac_node` VALUES (319, 'index', '中心配置管理', 1, '', 1, 318, 3, 0, '');
INSERT INTO `rbac_node` VALUES (320, 'add', '中心配置添加/修改', 1, '', 2, 318, 3, 0, '');
INSERT INTO `rbac_node` VALUES (321, 'addHandle', '中心配置添加/修改处理', 1, '', 3, 318, 3, 0, '');
INSERT INTO `rbac_node` VALUES (322, 'deleteHandle', '中心配置删除处理', 1, '', 4, 318, 3, 0, '');
INSERT INTO `rbac_node` VALUES (323, 'updateStatusAjaxHandle', '中心配置禁用/启用处理', 1, '', 5, 318, 3, 0, '');
INSERT INTO `rbac_node` VALUES (324, 'Log', '日志管理', 1, '', 6, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (325, 'PlayLog', '播放日志', 1, '', 1, 324, 2, 0, '');
INSERT INTO `rbac_node` VALUES (326, 'PushLog', '推送日志', 1, '', 2, 324, 2, 0, '');
INSERT INTO `rbac_node` VALUES (327, 'index', '播放日志管理', 1, '', 1, 325, 3, 0, '');
INSERT INTO `rbac_node` VALUES (328, 'index', '推送日志管理', 1, '', 1, 326, 3, 0, '');
INSERT INTO `rbac_node` VALUES (329, 'Monitor', '监控告警', 1, '', 7, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (330, 'Device', '设备监控', 1, '', 1, 329, 2, 0, '');
INSERT INTO `rbac_node` VALUES (331, 'index', '设备监控', 1, '', 1, 330, 3, 0, '');
INSERT INTO `rbac_node` VALUES (332, 'details', '监控详情', 1, '', 2, 330, 3, 0, '');
INSERT INTO `rbac_node` VALUES (333, 'updateStatusAjaxHandle', '播控禁用/启用处理', 1, '', 5, 309, 3, 0, '');
INSERT INTO `rbac_node` VALUES (335, 'updateStatusInjectAjaxHandle', '重新注入处理', 1, '', 6, 285, 3, 0, '');
INSERT INTO `rbac_node` VALUES (341, 'Site', '站点管理', 1, '', 3, 0, 1, 0, '');
INSERT INTO `rbac_node` VALUES (343, 'Site', '站点管理', 1, '', 1, 341, 2, 0, '');
INSERT INTO `rbac_node` VALUES (345, 'index', '站点管理', 1, '', 1, 343, 3, 0, '');
INSERT INTO `rbac_node` VALUES (347, 'add', '站点添加/修改', 1, '', 2, 343, 3, 0, '');
INSERT INTO `rbac_node` VALUES (349, 'addhandle', '站点添加/修改处理', 1, '', 3, 343, 3, 0, '');
INSERT INTO `rbac_node` VALUES (351, 'deleteHandle', '站点删除处理', 1, '', 4, 343, 3, 0, '');
INSERT INTO `rbac_node` VALUES (353, 'updateStatusAjaxHandle', '站点禁用/启用处理', 1, '', 5, 343, 3, 0, '');
INSERT INTO `rbac_node` VALUES (355, 'PullLog', '拉取日志', 1, '', 3, 324, 2, 0, '');
INSERT INTO `rbac_node` VALUES (357, 'index', '拉取日志管理', 1, '', 1, 355, 3, 0, '');
INSERT INTO `rbac_node` VALUES (359, 'details', '播放日志详情', 1, '', 2, 325, 3, 0, '');
INSERT INTO `rbac_node` VALUES (361, 'injectLog', '注入日志详情', 1, '', 6, 285, 3, 0, '');
INSERT INTO `rbac_node` VALUES (363, 'lists', '媒资注入列表', 1, '', 6, 303, 3, 0, '');
INSERT INTO `rbac_node` VALUES (364, 'lists', '播控列表', 1, '', 5, 309, 3, 0, '');
COMMIT;

-- ----------------------------
-- Table structure for rbac_role
-- ----------------------------
DROP TABLE IF EXISTS `rbac_role`;
CREATE TABLE `rbac_role` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `ename` varchar(40) DEFAULT NULL,
  `create_time` int(11) unsigned NOT NULL,
  `update_time` int(11) unsigned NOT NULL,
  `create_by` varchar(45) NOT NULL DEFAULT ' ' COMMENT '创建者账号',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型：0：系统预置，1：自定义',
  `grade` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '等级：1:soooner,2:网络服务商,3:SP',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `vdgo_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属运营商ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ename` (`ename`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rbac_role
-- ----------------------------
BEGIN;
INSERT INTO `rbac_role` VALUES (5, '系统管理员', '系统管理权限', '系统管理员', 0, 1568026532, 'sysadmin', 0, 0, 1, 0, 0);
INSERT INTO `rbac_role` VALUES (30, 'SOOONER', 'SOOONER角色', 'soooner', 1385362987, 1566202199, 'sysadmin', 0, 1, 1, 0, 0);
INSERT INTO `rbac_role` VALUES (31, '华数管理员', '华数管理员角色', '华数管理员', 1564048160, 1568026544, 'sysadmin', 0, 1, 1, 0, 0);
INSERT INTO `rbac_role` VALUES (35, '吴瑞华数测试1', '1111', 'wuruitest1', 1566270155, 1566458110, 'admin', 1, 1, 1, 0, 0);
INSERT INTO `rbac_role` VALUES (37, '合作方角色', '', '合作方角色', 1566440401, 1566548926, 'sysadmin', 0, 3, 1, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for rbac_role_user
-- ----------------------------
DROP TABLE IF EXISTS `rbac_role_user`;
CREATE TABLE `rbac_role_user` (
  `role_id` mediumint(9) unsigned DEFAULT NULL,
  `user_id` char(32) DEFAULT NULL,
  KEY `group_id` (`role_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rbac_role_user
-- ----------------------------
BEGIN;
INSERT INTO `rbac_role_user` VALUES (5, '36');
INSERT INTO `rbac_role_user` VALUES (30, '31');
INSERT INTO `rbac_role_user` VALUES (30, '37');
INSERT INTO `rbac_role_user` VALUES (31, '38');
INSERT INTO `rbac_role_user` VALUES (30, '39');
INSERT INTO `rbac_role_user` VALUES (30, '43');
INSERT INTO `rbac_role_user` VALUES (35, '47');
INSERT INTO `rbac_role_user` VALUES (37, '49');
INSERT INTO `rbac_role_user` VALUES (35, '41');
INSERT INTO `rbac_role_user` VALUES (35, '51');
INSERT INTO `rbac_role_user` VALUES (30, '53');
INSERT INTO `rbac_role_user` VALUES (37, '55');
COMMIT;

-- ----------------------------
-- Table structure for rbac_user
-- ----------------------------
DROP TABLE IF EXISTS `rbac_user`;
CREATE TABLE `rbac_user` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(64) NOT NULL DEFAULT '',
  `nickname` varchar(50) NOT NULL DEFAULT '',
  `password` char(32) NOT NULL DEFAULT '',
  `last_login_time` int(11) unsigned DEFAULT '0',
  `last_login_ip` varchar(40) DEFAULT '',
  `login_count` mediumint(8) unsigned DEFAULT '0',
  `email` varchar(50) NOT NULL DEFAULT '',
  `remark` varchar(255) NOT NULL DEFAULT '',
  `create_time` int(11) unsigned NOT NULL,
  `update_time` int(11) unsigned NOT NULL,
  `status` tinyint(1) DEFAULT '0',
  `create_by` varchar(45) DEFAULT ' ',
  `grade` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '等级：1:SOOONER,2:网络服务商,3:SP',
  `tel` varchar(45) NOT NULL DEFAULT '' COMMENT '电话',
  `secret` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'GA秘钥',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `unq_account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rbac_user
-- ----------------------------
BEGIN;
INSERT INTO `rbac_user` VALUES (31, 'superadmin', '超级管理员', 'd3900f8a564af809627cba142b141e8c', 1564040536, '59.108.46.205', 527, '', '', 1382518991, 1564577690, 1, 'sysadmin', 1, '', 'FQLAFVKVFN7HBLIG');
INSERT INTO `rbac_user` VALUES (36, 'sysadmin', '系统管理员', 'd3900f8a564af809627cba142b141e8c', 1574819818, '59.108.46.205', 1358, '', '', 1384850751, 1394440727, 1, 'sysadmin', 0, '', '');
INSERT INTO `rbac_user` VALUES (37, 'root', 'root', 'd3900f8a564af809627cba142b141e8c', 1418786402, '59.108.46.205', 126, '', '', 1385367162, 1564577697, 1, 'sysadmin', 1, '', 'JLYNJK2FGRSCAJJC');
INSERT INTO `rbac_user` VALUES (38, 'admin', 'admin', '7e31f0d7d7a866f48a4f286e50e10aff', 1575508478, '58.100.228.253', 301, '', '', 1564049825, 1564577701, 1, 'sysadmin', 1, '', '667TUJ35OKFIFLWA');
INSERT INTO `rbac_user` VALUES (39, 'wuxinde', 'xd.5', '924f8116781411c1bd52d7a235de806b', 1575362952, '59.108.46.205', 55, '', '', 1564591261, 1564591261, 1, 'sysadmin', 1, '', 'IP43VXXFRVRVR6SD');
INSERT INTO `rbac_user` VALUES (41, 'wurui', 'wurui', '670b14728ad9902aecba32e22fa4f6bd', 1566458126, '58.100.228.253', 5, 'wurui', '', 1565335962, 1566457759, 1, 'admin', 1, '18668406985', 'MDVJ6N3SPYJTDSUI');
INSERT INTO `rbac_user` VALUES (43, 'test', 'test', 'ceb6c970658f31504a901b89dcd3e461', 1565336206, '127.0.0.1', 0, 'admin', '', 1565336206, 1565336206, 1, 'admin', 1, '', '2LZOGACB4BQJBKYY');
INSERT INTO `rbac_user` VALUES (47, 'wuruitest', 'wuruitest', '7e31f0d7d7a866f48a4f286e50e10aff', 1566292305, '127.0.0.1', 0, 'admin', '', 1566292305, 1566292585, 1, 'admin', 1, '18668406985', 'NLLRS2YQQHIKL757');
INSERT INTO `rbac_user` VALUES (49, 'xiaoshuai', '小帅', '8becb54631fdd15f11461bec9c7d997d', 1575007273, '36.110.54.250', 40, 'admin@xiaoshuai.com', '', 1566440479, 1566440479, 1, 'sysadmin', 3, '', 'VDGFHS5FLPQZW545');
INSERT INTO `rbac_user` VALUES (51, 'wuruitest1', '吴瑞测试3', '7e31f0d7d7a866f48a4f286e50e10aff', 1566541553, '127.0.0.1', 0, 'admin', '', 1566541553, 1566541570, 1, 'admin', 1, '11', 'EO22HQ7EICXRCUUM');
INSERT INTO `rbac_user` VALUES (53, 'wenkaiqi', 'wen', 'c91f242542c064b93e82c9c8a9f4ab25', 1575363253, '59.108.46.205', 4, '', '', 1571034326, 1571034326, 1, 'sysadmin', 1, '', 'CACMWV7GINPCU4YV');
INSERT INTO `rbac_user` VALUES (55, 'yuandong', '圆动', '2d569da323f8c0fd99070c4ee5775082', 1571724748, '59.108.46.205', 1, '--', '', 1571724724, 1571724724, 1, 'wuxinde', 3, '--', 'GWPABWESNQ7IYOO3');
COMMIT;

-- ----------------------------
-- Table structure for sh_hotel
-- ----------------------------
DROP TABLE IF EXISTS `sh_hotel`;
CREATE TABLE `sh_hotel` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sp_id` int(11) NOT NULL COMMENT '合作方id',
  `region_id` int(11) DEFAULT NULL COMMENT '区域id',
  `name` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '酒店名称',
  `code` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '合作方酒店标识',
  `rooms` int(10) DEFAULT '0' COMMENT '房间个数',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx` (`id`,`sp_id`,`code`,`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='合作方酒店信息表';

-- ----------------------------
-- Table structure for sh_hotel_device
-- ----------------------------
DROP TABLE IF EXISTS `sh_hotel_device`;
CREATE TABLE `sh_hotel_device` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属酒店id',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型：0master，1slave',
  `code` varchar(16) COLLATE utf8_bin NOT NULL COMMENT '分前端code标识',
  `name` varchar(40) COLLATE utf8_bin NOT NULL COMMENT '分前端名称',
  `ip` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '分前端IP',
  `port` int(11) NOT NULL DEFAULT '8088' COMMENT '分前端PORT',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `virtual_ip` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '192.168.1.200' COMMENT '虚拟IP',
  `netcard` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT 'eth0' COMMENT '服务网卡名称',
  `licence` varchar(50) COLLATE utf8_bin DEFAULT '' COMMENT '分前端授权码',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_code` (`code`),
  KEY `idx` (`id`,`hotel_id`,`code`,`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='分前端信息表';

-- ----------------------------
-- Table structure for sh_hotel_device_storage
-- ----------------------------
DROP TABLE IF EXISTS `sh_hotel_device_storage`;
CREATE TABLE `sh_hotel_device_storage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `device_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属设备',
  `path` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '/data1' COMMENT '存储根路径',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `size` int(11) NOT NULL DEFAULT '500' COMMENT '存储大小，单位GB',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0有效，1无效，2删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='分前端设备存储路径配置';

-- ----------------------------
-- Table structure for sh_hotel_media_map
-- ----------------------------
DROP TABLE IF EXISTS `sh_hotel_media_map`;
CREATE TABLE `sh_hotel_media_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒资id',
  `hotel_id` int(11) NOT NULL DEFAULT '0' COMMENT '酒店id',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '播控状态：0删除，1上线，2下线',
  `status_inject` tinyint(4) NOT NULL DEFAULT '0' COMMENT '注入状态：0未注入，1已注入，2注入失败,3-已删除',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `media_code` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '媒资标识（冗余字段，给分前端用于更新注入状态）',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_media_hotel` (`media_id`,`hotel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='酒店片库映射表';

-- ----------------------------
-- Table structure for sh_log_play
-- ----------------------------
DROP TABLE IF EXISTS `sh_log_play`;
CREATE TABLE `sh_log_play` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  `hotel_id` int(11) NOT NULL DEFAULT '0' COMMENT '酒店id',
  `stb_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '-' COMMENT '机顶盒id',
  `order_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '-' COMMENT '订单id',
  `media_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资id',
  `http_code` smallint(3) NOT NULL DEFAULT '0' COMMENT 'http响应码',
  `err_code` smallint(4) NOT NULL DEFAULT '0' COMMENT '错误码，1001, "arg error";1002, "front conf error";1003, "url expired";1004, "sign arg error";1005, "sign error";1006, "no media"',
  `starttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始播放时间',
  `duration` decimal(10,3) NOT NULL DEFAULT '0.000' COMMENT '时长 0.001=1毫秒',
  `tradeid` char(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '单次播放标识',
  `range` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '-' COMMENT 'http request range',
  `body_bytes_sent` bigint(20) NOT NULL DEFAULT '0' COMMENT 'response body_bytes_sent',
  `cache_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '命中状态 1:HIT,0:MISS',
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据入库时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='播放记录表';

-- ----------------------------
-- Table structure for sh_log_pull
-- ----------------------------
DROP TABLE IF EXISTS `sh_log_pull`;
CREATE TABLE `sh_log_pull` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `push_mode` tinyint(4) NOT NULL DEFAULT '0' COMMENT '运营模式',
  `newsId` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资标识',
  `newsName` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资名称',
  `jsonUrl` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资详情地址',
  `nodeId` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '栏目id',
  `nodeName` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '栏目名称',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '处理状态：0未处理，1已处理',
  `code` int(11) NOT NULL DEFAULT '0' COMMENT '同步状态：直接显示',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT '站点id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='拉取日志表';

-- ----------------------------
-- Table structure for sh_log_push
-- ----------------------------
DROP TABLE IF EXISTS `sh_log_push`;
CREATE TABLE `sh_log_push` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  `starttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '变更开始时间',
  `endtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '变更结束时间',
  `page` int(11) NOT NULL DEFAULT '0' COMMENT '变更页码',
  `req_json` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '请求json',
  `resp_json` text COLLATE utf8_bin NOT NULL COMMENT '响应json',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '推送状态：0未推送，1已推送，2推送失败',
  `code` int(11) NOT NULL DEFAULT '1' COMMENT '结果代码：0成功，1001服务端错误，2001合作方接口错误',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='推送记录表（暂时只记录推送失败记录，可进行重新推送）';

-- ----------------------------
-- Table structure for sh_media_wasu
-- ----------------------------
DROP TABLE IF EXISTS `sh_media_wasu`;
CREATE TABLE `sh_media_wasu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `code` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资唯一标识',
  `title` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资名称',
  `description` varchar(400) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资描述',
  `url_play` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '云存储地址',
  `url_pic` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '海报图片地址',
  `year` varchar(4) COLLATE utf8_bin DEFAULT '' COMMENT '年份',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '类型：电影，电视剧，新闻，综艺等',
  `score` decimal(2,1) NOT NULL DEFAULT '0.0' COMMENT '评分',
  `region` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '国家/地区：内地，港台',
  `actor` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '演员',
  `director` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '导演',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '上下线状态（wasu）：1上线，2下线',
  `md5` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '文件MD5',
  `_starttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间（wasu）',
  `_updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间（wasu）',
  `programType` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '节目类型',
  `nodeId` int(11) NOT NULL DEFAULT '0' COMMENT '媒资所在栏目id',
  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  `nodeName` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '栏目名称',
  `newsImage_1` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '海报1（圆动，互动新增字段）',
  `newsImage_2` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '海报2（圆动，互动新增字段）',
  `newsImage_3` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '海报3（圆动，互动新增字段）',
  `englishTitle` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '英文标题（圆动，互动新增字段）',
  `nodeImg` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '栏目海报',
  `nodeStruct` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '栏目层级，从上一级栏目到当前栏目，用 # 连接',
  PRIMARY KEY (`id`),
  KEY `idx` (`code`,`id`,`site_id`) USING BTREE,
  KEY `idx_spid` (`site_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='云端片库表';

-- ----------------------------
-- Table structure for sh_region
-- ----------------------------
DROP TABLE IF EXISTS `sh_region`;
CREATE TABLE `sh_region` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `code` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `level` tinyint(2) NOT NULL,
  `postcode` int(11) NOT NULL DEFAULT '0',
  `remark` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0有效，1无效',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `temp_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='区域信息配置表\r\n来源ip2region：http://git.oschina.net/lionsoul/ip2regi';

-- ----------------------------
-- Table structure for sh_site
-- ----------------------------
DROP TABLE IF EXISTS `sh_site`;
CREATE TABLE `sh_site` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '站点名称',
  `status` tinyint(1) NOT NULL COMMENT '状态：0正常，1禁用，2删除',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `pull_api` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '增量媒资拉取地址',
  `offline_key` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '实时下线接口秘钥',
  `check_seconds` int(11) NOT NULL DEFAULT '3600' COMMENT '拉取频率',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='站点信息表';

-- ----------------------------
-- Table structure for sh_sp
-- ----------------------------
DROP TABLE IF EXISTS `sh_sp`;
CREATE TABLE `sh_sp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '合作方名称',
  `code` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '代码',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `email` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'email',
  `mobile` varchar(11) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '手机号',
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `push_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否推送媒资变更：0不推送，1推送',
  `push_offset` timestamp NOT NULL DEFAULT '2019-07-01 08:00:00' COMMENT '推送位置',
  `site_id` int(11) NOT NULL DEFAULT '0' COMMENT '关联站点id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_code` (`code`),
  KEY `idx_id` (`id`,`code`,`status`,`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='合作方';

-- ----------------------------
-- Table structure for sh_sp_config
-- ----------------------------
DROP TABLE IF EXISTS `sh_sp_config`;
CREATE TABLE `sh_sp_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  `type_code` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置类型code',
  `name` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置名称',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `v` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置值',
  PRIMARY KEY (`id`),
  KEY `idx` (`id`,`sp_id`,`type_code`,`status`) USING BTREE,
  KEY `index_sp_id` (`sp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='合作方配置表（合作方接口，私钥等配置）';

-- ----------------------------
-- Table structure for sh_sp_config_type
-- ----------------------------
DROP TABLE IF EXISTS `sh_sp_config_type`;
CREATE TABLE `sh_sp_config_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置类型',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `code` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置类型代码',
  `v` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置值（用于初始化）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='合作方配置类型表';

-- ----------------------------
-- Records of sh_sp_config_type
-- ----------------------------
BEGIN;
INSERT INTO `sh_sp_config_type` VALUES (1, '媒资增量变更通知接口', 0, '', '2019-06-24 21:53:38', '2019-06-28 00:43:05', 'api_push', '');
INSERT INTO `sh_sp_config_type` VALUES (2, '通讯秘钥', 0, '与合作方通讯私钥', '2019-06-24 21:54:26', '2019-07-04 19:59:06', 'api_key', '');
INSERT INTO `sh_sp_config_type` VALUES (3, '分前端通讯秘钥', 0, '用于分前端鉴权调度sign加密', '2019-07-04 19:57:36', '2019-07-10 02:36:12', 'front_api_key', '');
INSERT INTO `sh_sp_config_type` VALUES (4, '中心媒资增量变更检测频率', 0, '间隔', '2019-07-04 22:20:09', '2019-07-10 02:36:37', 'push_check_seconds', '60s');
INSERT INTO `sh_sp_config_type` VALUES (5, '分前端配置刷新间隔', 0, '单位秒', '2019-07-04 22:57:56', '2019-07-16 23:30:58', 'front_config_check_seconds', '60');
INSERT INTO `sh_sp_config_type` VALUES (6, '分前端媒资同步间隔', 0, '单位秒', '2019-07-09 23:55:34', '2019-07-16 23:31:18', 'front_media_sync_seconds', '300');
INSERT INTO `sh_sp_config_type` VALUES (7, '分前端鉴权调度过期时间', 0, '单位秒', '2019-07-10 00:00:00', '2019-07-10 02:18:07', 'front_gslb_expire_seconds', '600');
INSERT INTO `sh_sp_config_type` VALUES (8, '分前端播放过期时间', 0, '单位秒', '2019-07-10 00:00:21', '2019-07-10 02:18:12', 'front_play_expire_seconds', '21600');
INSERT INTO `sh_sp_config_type` VALUES (9, '分前端媒资回源限速', 0, '单位Kbps', '2019-07-10 00:10:20', '2019-07-10 02:18:17', 'front_media_inject_limit', '5120');
INSERT INTO `sh_sp_config_type` VALUES (10, '分前端媒资回源并发', 0, '并发个数', '2019-07-10 00:10:27', '2019-07-10 02:18:31', 'front_media_inject_concurrent', '1');
INSERT INTO `sh_sp_config_type` VALUES (11, '分前端鉴权调度模式', 0, '0:本地鉴权，1实时鉴权（中心鉴权调度）', '2019-07-16 18:45:08', '2019-08-09 14:13:35', 'front_gslb_mode', '0');
INSERT INTO `sh_sp_config_type` VALUES (12, '分前端日志上报频率', 0, '秒', '2019-07-17 01:55:07', '2019-07-17 01:55:07', 'front_log_report_interval', '60');
INSERT INTO `sh_sp_config_type` VALUES (13, '华数增量媒资拉取接口', 1, '每个合作方一个接口，每个合作方的云端片库是独立的。', '2019-07-31 11:46:24', '2019-09-12 10:15:32', 'wasu_api_incrementList', 'http://115.29.7.64:8092/XmlData/incrementList');
INSERT INTO `sh_sp_config_type` VALUES (15, '华数增量媒资推送模式', 0, '人工运营模式：需要运营人员登陆后台手工选择媒资列表和酒店列表进行推送\r\n自动转推模式：由中心服务自动拉取并推送给合作方相应酒店（推荐）', '2019-07-31 12:11:46', '2019-07-31 12:11:46', 'wasu_incrementList_push_mode', '0：人工运营模式，1：自动转推模式');
INSERT INTO `sh_sp_config_type` VALUES (17, '华数增量媒资检测频率', 1, '单位说明\r\ns : 秒，m : 分，h : 小时，d : 天', '2019-07-31 15:06:10', '2019-09-12 10:15:45', 'wasu_check_seconds', '60m');
INSERT INTO `sh_sp_config_type` VALUES (39, '分前端回源重试次数', 0, '分前端下载重试次数，单位次', '2019-10-10 12:06:56', '2019-10-10 12:06:56', 'front_media_inject_retry', '10');
COMMIT;

-- ----------------------------
-- Table structure for sh_sp_playlist
-- ----------------------------
DROP TABLE IF EXISTS `sh_sp_playlist`;
CREATE TABLE `sh_sp_playlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '播单名称',
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属合作方id',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remark` varchar(100) COLLATE utf8_bin DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='合作方播单';

-- ----------------------------
-- Table structure for sh_sp_playlist_media_map
-- ----------------------------
DROP TABLE IF EXISTS `sh_sp_playlist_media_map`;
CREATE TABLE `sh_sp_playlist_media_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒资id',
  `playlist_id` int(11) NOT NULL DEFAULT '0' COMMENT '播单id',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='合作方播单媒资映射表';

-- ----------------------------
-- Table structure for sh_sp_user_map
-- ----------------------------
DROP TABLE IF EXISTS `sh_sp_user_map`;
CREATE TABLE `sh_sp_user_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'rbac_user id',
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT 'sh_sp id',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0有效，1无效，2删除',
  `remark` varchar(100) CHARACTER SET utf8 DEFAULT '' COMMENT '备注',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户与SP关系绑定表';

-- ----------------------------
-- Table structure for sh_system_config
-- ----------------------------
DROP TABLE IF EXISTS `sh_system_config`;
CREATE TABLE `sh_system_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置名称',
  `k` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置键',
  `v` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '配置值',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态：0正常，1禁用，2删除',
  `remark` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '备注',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx` (`id`,`k`,`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='系统配置表（系统接口，私钥等配置）';

-- ----------------------------
-- Records of sh_system_config
-- ----------------------------
BEGIN;
INSERT INTO `sh_system_config` VALUES (1, '华数增量媒资列表接口', 'wasu_api_incrementList', 'http://115.29.7.64:8092/XmlData/incrementList', 1, '弃用，自动转推改造将该配置放到合作方配置里了', '2019-06-25 01:10:58', '2019-09-12 12:43:34');
INSERT INTO `sh_system_config` VALUES (2, '华数增量媒资检测频率', 'wasu_check_seconds', '60m', 1, '弃用，自动转推改造将该配置放到合作方配置里了', '2019-06-29 01:57:23', '2019-09-12 12:43:38');
INSERT INTO `sh_system_config` VALUES (3, '系统配置更新频率', 'config_system_check_seconds', '60s', 0, '5分钟', '2019-06-29 01:59:19', '2019-09-12 12:50:47');
INSERT INTO `sh_system_config` VALUES (4, '合作方配置更新频率', 'config_sp_check_seconds', '60s', 0, '10分钟', '2019-06-29 02:00:09', '2019-09-12 12:50:53');
INSERT INTO `sh_system_config` VALUES (5, '中心媒资信息更新接口', 'center_api_media_update', 'http://127.0.0.1/api/center/media_update', 0, '更新云端片库媒资信息', '2019-07-01 19:01:20', '2019-12-05 13:57:34');
INSERT INTO `sh_system_config` VALUES (6, '分前端媒资增量变更列表接口', 'front_api_incrementList', 'http://127.0.0.1/api/front/incrementList', 0, '分前端获取媒资增量变更列表，参数：hid,spid,start,end,page', '2019-07-02 22:54:04', '2019-12-05 13:57:40');
INSERT INTO `sh_system_config` VALUES (7, '中心媒资增量变更列表接口', 'center_api_incrementList', 'http://127.0.0.1/api/center/incrementList', 0, '(暂时不用)中心服务获取增量媒资变更列表，参数：spid,start,end,page', '2019-07-03 00:28:46', '2019-12-05 13:57:45');
INSERT INTO `sh_system_config` VALUES (8, '中心媒资增量变更检测接口', 'center_api_incrementCheck', 'http://127.0.0.1/api/center/incrementCheck', 0, '中心服务检测媒资变更接口：参数：spid,start,end,page', '2019-07-03 22:25:50', '2019-12-05 13:57:52');
INSERT INTO `sh_system_config` VALUES (9, '中心媒资增量变更推送接口', 'center_api_incrementPush', 'http://127.0.0.1/api/center/incrementPush', 0, '中心服务推送媒资增量变更：参数：spid,start,end,page', '2019-07-03 22:27:27', '2019-12-05 13:58:00');
COMMIT;

-- ----------------------------
-- Table structure for sh_task_ctrl
-- ----------------------------
DROP TABLE IF EXISTS `sh_task_ctrl`;
CREATE TABLE `sh_task_ctrl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '播控任务名称',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '播控状态：1上线，2下线',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='播控任务表';

-- ----------------------------
-- Table structure for sh_task_ctrl_log
-- ----------------------------
DROP TABLE IF EXISTS `sh_task_ctrl_log`;
CREATE TABLE `sh_task_ctrl_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '播控任务id',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒资id',
  `hotel_id` int(11) NOT NULL DEFAULT '0' COMMENT '酒店id',
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '播控状态：1上线，2下线',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='播控日志表';

-- ----------------------------
-- Table structure for sh_task_inject
-- ----------------------------
DROP TABLE IF EXISTS `sh_task_inject`;
CREATE TABLE `sh_task_inject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '注入任务名称',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '注入状态：0未注入，1注入成功，2注入失败',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remark` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '备注',
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='注入任务表';

-- ----------------------------
-- Table structure for sh_task_inject_log
-- ----------------------------
DROP TABLE IF EXISTS `sh_task_inject_log`;
CREATE TABLE `sh_task_inject_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '注入任务id',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒资id',
  `hotel_id` int(11) NOT NULL DEFAULT '0' COMMENT '酒店id',
  `sp_id` int(11) NOT NULL DEFAULT '0' COMMENT '合作方id',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '注入状态：0未注入，1注入成功，2注入失败',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='注入日志表';

SET FOREIGN_KEY_CHECKS = 1;