/*
Navicat MySQL Data Transfer

Source Server         : 本地连接
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : authadmin

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

Date: 2018-06-20 10:52:09
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `zp_admin`
-- ----------------------------
DROP TABLE IF EXISTS `zp_admin`;
CREATE TABLE `zp_admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `group_id` smallint(6) NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `password` varchar(80) NOT NULL COMMENT '登录密码',
  `salt` char(6) NOT NULL COMMENT 'salt加密',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1 正常；0 禁用 ; 2 异常',
  `login_count` smallint(6) DEFAULT '0' COMMENT '登录次数',
  `login_ip` varchar(20) DEFAULT '000.000.000.000' COMMENT '登录IPod',
  `login_time` int(10) DEFAULT '0' COMMENT '登录 时间',
  PRIMARY KEY (`admin_id`),
  KEY `admin_id` (`admin_id`),
  KEY `username` (`username`),
  KEY `status` (`status`),
  KEY `login_count` (`login_count`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';

-- ----------------------------
-- Records of zp_admin
-- ----------------------------
INSERT INTO `zp_admin` VALUES ('1', '1', 'admin', 'administrators', 'ee5435be932de37800b092796de043e7', '2k74PQ', '1', '70', '127.0.0.1', '1529462877');

-- ----------------------------
-- Table structure for `zp_admin_group`
-- ----------------------------
DROP TABLE IF EXISTS `zp_admin_group`;
CREATE TABLE `zp_admin_group` (
  `admin_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(30) NOT NULL COMMENT '权限名称',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态：1 正常；0 禁用',
  `describe` varchar(255) NOT NULL COMMENT '权限描述',
  `rules` text COMMENT '节点',
  PRIMARY KEY (`admin_group_id`),
  KEY `admin_group_id` (`admin_group_id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='管理员用户组权限';

-- ----------------------------
-- Records of zp_admin_group
-- ----------------------------
INSERT INTO `zp_admin_group` VALUES ('1', '超级管理员', '1', '管理全部权限', null);
INSERT INTO `zp_admin_group` VALUES ('2', '普通管理员', '1', '除了超级管理员权限之外，管理所有权限', '1,2,3,4,5,12,13,15,16,17,14');

-- ----------------------------
-- Table structure for `zp_admin_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `zp_admin_login_log`;
CREATE TABLE `zp_admin_login_log` (
  `admin_login_log_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `admin_username` varchar(50) DEFAULT NULL COMMENT '管理员用户名',
  `login_time` int(10) NOT NULL DEFAULT '0' COMMENT '登录时间',
  `login_ip` varchar(200) DEFAULT '000.000.000.000' COMMENT '登录IP地址',
  PRIMARY KEY (`admin_login_log_id`),
  KEY `admin_login_log_id` (`admin_login_log_id`),
  KEY `admin_id` (`admin_id`),
  KEY `admin_username` (`admin_username`),
  KEY `login_time` (`login_time`)
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COMMENT='管理员登录记录';

-- ----------------------------
-- Records of zp_admin_login_log
-- ----------------------------
INSERT INTO `zp_admin_login_log` VALUES ('1', '1', 'admin', '1505441081', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('2', '1', 'admin', '1505462775', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('3', '1', 'admin', '1505468340', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('4', '1', 'admin', '1505468464', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('5', '1', 'admin', '1505696193', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('6', '1', 'admin', '1505699691', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('7', '1', 'admin', '1505727847', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('8', '1', 'admin', '1505782627', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('9', '1', 'admin', '1505871763', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('10', '1', 'admin', '1506049847', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('11', '1', 'admin', '1506050013', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('12', '1', 'admin', '1507517036', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('13', '1', 'admin', '1507528423', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('14', '1', 'admin', '1507711721', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('15', '1', 'admin', '1507713257', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('16', '1', 'admin', '1508134249', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('17', '1', 'admin', '1508137394', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('18', '1', 'admin', '1508140819', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('19', '1', 'admin', '1508145447', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('20', '1', 'admin', '1508206357', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('21', '1', 'admin', '1508206662', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('22', '1', 'admin', '1508210089', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('23', '1', 'admin', '1508288163', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('24', '1', 'admin', '1508312478', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('25', '1', 'admin', '1508313682', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('26', '1', 'admin', '1508314222', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('27', '1', 'admin', '1508314284', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('28', '1', 'admin', '1508320197', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('29', '1', 'admin', '1508486032', '192.168.2.234');
INSERT INTO `zp_admin_login_log` VALUES ('30', '1', 'admin', '1508490024', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('31', '1', 'admin', '1508724338', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('32', '1', 'admin', '1508815968', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('33', '1', 'admin', '1508823750', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('34', '1', 'admin', '1508924076', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('35', '1', 'admin', '1509002825', '::1');
INSERT INTO `zp_admin_login_log` VALUES ('36', '1', 'admin', '1509003776', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('37', '1', 'admin', '1509327919', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('38', '1', 'admin', '1513924557', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('39', '1', 'admin', '1513925727', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('40', '1', 'admin', '1513925791', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('41', '1', 'admin', '1513928683', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('42', '1', 'admin', '1513939738', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('43', '1', 'admin', '1513939761', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('44', '1', 'admin', '1513941721', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('45', '1', 'admin', '1513941780', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('46', '1', 'admin', '1513941809', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('47', '1', 'admin', '1515484571', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('48', '1', 'admin', '1515566371', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('49', '1', 'admin', '1516263346', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('50', '1', 'admin', '1516772665', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('51', '1', 'admin', '1518161803', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('52', '1', 'admin', '1518229721', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('53', '1', 'admin', '1519462302', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('54', '1', 'admin', '1519610152', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('55', '1', 'admin', '1519694184', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('56', '1', 'admin', '1519781234', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('57', '1', 'admin', '1519955170', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('58', '1', 'admin', '1520230188', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('59', '1', 'admin', '1520472415', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('60', '1', 'admin', '1520558765', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('61', '1', 'admin', '1520817799', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('62', '1', 'admin', '1520904501', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('63', '1', 'admin', '1520904541', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('64', '1', 'admin', '1520992025', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('65', '1', 'admin', '1521084349', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('66', '1', 'admin', '1522219475', '127.0.0.1');
INSERT INTO `zp_admin_login_log` VALUES ('67', '1', 'admin', '1529462877', '127.0.0.1');

-- ----------------------------
-- Table structure for `zp_integral_log`
-- ----------------------------
DROP TABLE IF EXISTS `zp_integral_log`;
CREATE TABLE `zp_integral_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` int(10) DEFAULT '0' COMMENT '操作管理员',
  `member_id` int(10) DEFAULT '0' COMMENT '操作会员',
  `integral` bigint(20) DEFAULT '0' COMMENT '操作金额',
  `plusless` tinyint(1) DEFAULT '1' COMMENT '1 加；2 减',
  `inputtime` int(10) DEFAULT '0' COMMENT '操作时间',
  `describe` varchar(255) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`),
  KEY `admin_id` (`admin_id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='积分记录表';

-- ----------------------------
-- Records of zp_integral_log
-- ----------------------------
INSERT INTO `zp_integral_log` VALUES ('1', '1', '8', '15', '1', '1519627069', '管理员添加会员，赠送积分');
INSERT INTO `zp_integral_log` VALUES ('2', '1', '9', '10', '1', '1519627180', '管理员添加会员，赠送积分');

-- ----------------------------
-- Table structure for `zp_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `zp_login_log`;
CREATE TABLE `zp_login_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `login_time` int(10) NOT NULL DEFAULT '0' COMMENT '登录时间',
  `login_ip` varchar(200) DEFAULT '000.000.000.000' COMMENT '登录IP地址',
  PRIMARY KEY (`log_id`),
  KEY `member_id` (`member_id`),
  KEY `login_time` (`login_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='用户登录记录';

-- ----------------------------
-- Records of zp_login_log
-- ----------------------------

-- ----------------------------
-- Table structure for `zp_members`
-- ----------------------------
DROP TABLE IF EXISTS `zp_members`;
CREATE TABLE `zp_members` (
  `member_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` varchar(80) DEFAULT NULL COMMENT '登录密码',
  `salt` char(6) DEFAULT NULL COMMENT '加密密钥',
  `phone` char(15) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `name` varchar(30) DEFAULT NULL COMMENT '用户名',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1 正常；0 禁用；2 其他',
  `is_check` tinyint(1) DEFAULT '0' COMMENT '审核：0 未审核；1 已审核',
  `check_time` int(10) DEFAULT '0' COMMENT '审核时间',
  `register_ip` varchar(100) DEFAULT '000.000.000.000' COMMENT '注册IP地址',
  `register_time` int(10) DEFAULT '0' COMMENT '注册时间',
  `login_ip` varchar(100) DEFAULT '000.000.000.000' COMMENT '登录IP地址',
  `login_time` int(10) DEFAULT '0' COMMENT '登录时间',
  `login_count` smallint(6) DEFAULT '0' COMMENT '登录次数',
  `open_id` varchar(150) DEFAULT '0' COMMENT '微信OPEN_ID',
  `balance` bigint(20) NOT NULL DEFAULT '0' COMMENT '余额(分)',
  `integral` bigint(20) DEFAULT '0' COMMENT '积分（点）',
  PRIMARY KEY (`member_id`),
  KEY `member_id` (`member_id`),
  KEY `username` (`username`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of zp_members
-- ----------------------------
INSERT INTO `zp_members` VALUES ('1', 'test', '34d3f101231aca8ec80c8a1bb2faf578', 'SWD9dc', '13800138000', '13800138000@qq.com', '测试w', '1', '0', '0', '127.0.0.1', '1505371271', '000.000.000.000', '0', '0', '0', '0', '0');
INSERT INTO `zp_members` VALUES ('2', '3344eess', 'be78ef6f040d2b4330e29ee936d0317e', 'Fi6cfP', null, null, '3344eess', '1', '0', '0', '127.0.0.1', '1505378397', '000.000.000.000', '0', '0', '0', '0', '0');
INSERT INTO `zp_members` VALUES ('3', 'te5412', '97725460bbbef368faefe6bb298eee6d', 'P8dGC1', '', '', 'te5412', '1', '0', '0', '127.0.0.1', '1505381078', '000.000.000.000', '0', '0', '0', '0', '0');
INSERT INTO `zp_members` VALUES ('4', 'te5488', 'c6ea55ab24035408c74de56324358ff1', 'lQTIA6', '', '', 'te5488', '1', '0', '0', '127.0.0.1', '1505381089', '000.000.000.000', '0', '0', '0', '0', '0');
INSERT INTO `zp_members` VALUES ('5', 'fg5412', '57f86c2602335e428cec9135b189a25b', 'BwsJmI', '', '', 'fg5412', '1', '0', '0', '127.0.0.1', '1505381101', '000.000.000.000', '0', '0', '0', '0', '0');
INSERT INTO `zp_members` VALUES ('6', 'hjs5487', 'a042c006778fa7c80382767dc70d0537', 'lfgjcY', '', '', 'hjs5487', '1', '0', '0', '127.0.0.1', '1505381120', '000.000.000.000', '0', '0', '0', '0', '0');
INSERT INTO `zp_members` VALUES ('7', 'tys548', 'cb7cb1857d6bdd834b3d936877362e9a', '7hOtxi', '', '', 'tys548', '1', '0', '0', '127.0.0.1', '1505381130', '000.000.000.000', '0', '0', '0', '0', '0');
INSERT INTO `zp_members` VALUES ('8', 'usjsnam', 'd8e737080d48a60a067afaaf3ba1de22', 'uxOgw8', '', '', '夺', '1', '0', '0', '127.0.0.1', '1519627069', '000.000.000.000', '0', '0', '0', '0', '15');
INSERT INTO `zp_members` VALUES ('9', 'usyts', '439ab8088f92ec4b8dedffefa2ebce47', 'AxhcfJ', '', '', '蝇', '1', '0', '0', '127.0.0.1', '1519627180', '000.000.000.000', '0', '0', '0', '800', '10');

-- ----------------------------
-- Table structure for `zp_menu`
-- ----------------------------
DROP TABLE IF EXISTS `zp_menu`;
CREATE TABLE `zp_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父级id',
  `title` varchar(50) NOT NULL COMMENT '菜单名称',
  `name` varchar(80) NOT NULL COMMENT '操作控制或方法',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：1 正常；0 禁用;',
  `is_display` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示：1 显示；0 隐藏',
  `list_order` smallint(6) NOT NULL DEFAULT '0' COMMENT '排序',
  `inputtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`menu_id`),
  KEY `pid` (`pid`),
  KEY `status` (`status`),
  KEY `is_display` (`is_display`)
) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COMMENT='后台菜单';

-- ----------------------------
-- Records of zp_menu
-- ----------------------------
INSERT INTO `zp_menu` VALUES ('1', '0', '我的面板', 'index/sidebar', '1', '1', '0', '1505291739');
INSERT INTO `zp_menu` VALUES ('2', '1', '个人信息', 'index/group', '1', '1', '0', '1505291763');
INSERT INTO `zp_menu` VALUES ('3', '2', '修改资料', 'manager/updatelogin', '1', '1', '0', '1505291790');
INSERT INTO `zp_menu` VALUES ('4', '2', '修改密码', 'manager/passwordlogin', '1', '1', '0', '1505291815');
INSERT INTO `zp_menu` VALUES ('5', '0', '系统', 'index/sidebar', '1', '1', '0', '1505291866');
INSERT INTO `zp_menu` VALUES ('6', '5', '菜单管理', 'auth/group', '1', '1', '0', '1505291896');
INSERT INTO `zp_menu` VALUES ('7', '6', '菜单列表', 'auth/index', '1', '1', '0', '1505291915');
INSERT INTO `zp_menu` VALUES ('8', '6', '添加菜单', 'auth/add', '1', '1', '0', '1505291935');
INSERT INTO `zp_menu` VALUES ('9', '7', '删除菜单', 'auth/delete', '1', '0', '0', '1505294825');
INSERT INTO `zp_menu` VALUES ('10', '7', '编辑菜单', 'auth/update', '1', '0', '0', '1505294844');
INSERT INTO `zp_menu` VALUES ('11', '7', '排序', 'auth/listorder', '1', '0', '0', '1505296602');
INSERT INTO `zp_menu` VALUES ('12', '5', '管理员管理', 'manager/group', '1', '1', '0', '1505297407');
INSERT INTO `zp_menu` VALUES ('13', '12', '管理员列表', 'manager/index', '1', '1', '0', '1505297425');
INSERT INTO `zp_menu` VALUES ('14', '12', '添加管理员', 'manager/add', '1', '1', '0', '1505297456');
INSERT INTO `zp_menu` VALUES ('15', '13', '编辑管理员', 'manager/update', '1', '0', '0', '1505297479');
INSERT INTO `zp_menu` VALUES ('16', '13', '删除管理员', 'manager/delete', '1', '0', '0', '1505297517');
INSERT INTO `zp_menu` VALUES ('17', '13', '状态', 'manager/status', '1', '0', '0', '1505297551');
INSERT INTO `zp_menu` VALUES ('18', '5', '权限管理', 'group/group', '1', '1', '0', '1505356878');
INSERT INTO `zp_menu` VALUES ('19', '18', '权限列表', 'group/index', '1', '1', '0', '1505356898');
INSERT INTO `zp_menu` VALUES ('20', '18', '添加权限', 'group/add', '1', '1', '0', '1505356932');
INSERT INTO `zp_menu` VALUES ('21', '0', '用户', 'index/sidebar', '1', '1', '0', '1505374335');
INSERT INTO `zp_menu` VALUES ('22', '21', '用户管理', 'member/group', '1', '1', '0', '1505374374');
INSERT INTO `zp_menu` VALUES ('23', '22', '用户列表', 'member/index', '1', '1', '0', '1505374391');
INSERT INTO `zp_menu` VALUES ('24', '22', '添加用户', 'member/add', '1', '1', '0', '1505374404');
INSERT INTO `zp_menu` VALUES ('25', '23', '编辑用户', 'member/update', '1', '1', '0', '1505374432');
INSERT INTO `zp_menu` VALUES ('26', '23', '删除用户', 'member/delete', '1', '1', '0', '1505374463');
INSERT INTO `zp_menu` VALUES ('27', '0', '配置', 'index/sidebar', '1', '1', '0', '1505375988');
INSERT INTO `zp_menu` VALUES ('28', '27', '系统配置', 'system/group', '1', '1', '0', '1505376027');
INSERT INTO `zp_menu` VALUES ('29', '28', '系统配置', 'system/index', '1', '1', '0', '1505376041');
INSERT INTO `zp_menu` VALUES ('30', '19', '修改权限', 'group/update', '1', '1', '0', '1518231360');
INSERT INTO `zp_menu` VALUES ('31', '19', '删除权限', 'group/delete', '1', '1', '0', '1518231427');
INSERT INTO `zp_menu` VALUES ('32', '23', '修改余额', 'member/updateprice', '1', '1', '0', '1518242630');
INSERT INTO `zp_menu` VALUES ('33', '23', '积分记录', 'member/integrallog', '1', '1', '0', '1518252361');
INSERT INTO `zp_menu` VALUES ('34', '23', '登录记录', 'member/loginlog', '1', '1', '0', '1518253672');
INSERT INTO `zp_menu` VALUES ('35', '2', '登录日记', 'manager/log', '1', '1', '0', '1519615178');
INSERT INTO `zp_menu` VALUES ('36', '27', '相册管理', 'photos/group', '1', '1', '0', '1519700716');
INSERT INTO `zp_menu` VALUES ('37', '36', '相册列表', 'photos/index', '1', '1', '0', '1519700732');
INSERT INTO `zp_menu` VALUES ('38', '37', '删除相册', 'photos/delete', '1', '0', '0', '1519701826');
INSERT INTO `zp_menu` VALUES ('39', '27', '滚动条管理', 'scroll/group', '1', '1', '0', '1519713114');
INSERT INTO `zp_menu` VALUES ('40', '39', '滚动条', 'scroll/column', '1', '1', '0', '1519713481');
INSERT INTO `zp_menu` VALUES ('41', '39', '添加栏目', 'scroll/addcolumn', '1', '1', '0', '1519713510');
INSERT INTO `zp_menu` VALUES ('42', '40', '编辑栏目', 'scroll/updatecolumn', '1', '0', '0', '1519715120');
INSERT INTO `zp_menu` VALUES ('43', '40', '删除栏目', 'scroll/deletecolumn', '1', '0', '0', '1519715133');
INSERT INTO `zp_menu` VALUES ('44', '40', '信息列表', 'scroll/index', '1', '0', '0', '1519718712');
INSERT INTO `zp_menu` VALUES ('45', '44', '删除信息', 'scroll/delete', '1', '0', '0', '1519724032');
INSERT INTO `zp_menu` VALUES ('46', '44', '编辑信息', 'scroll/update', '1', '0', '0', '1519724059');
INSERT INTO `zp_menu` VALUES ('47', '44', '添加信息', 'scroll/add', '1', '0', '0', '1519724075');
INSERT INTO `zp_menu` VALUES ('48', '23', '批量审核', 'member/allcheck', '1', '0', '0', '1519787388');
INSERT INTO `zp_menu` VALUES ('49', '27', '系统公告', 'notice/group', '1', '1', '0', '1519800624');
INSERT INTO `zp_menu` VALUES ('50', '49', '公告列表', 'notice/index', '1', '1', '0', '1519800645');
INSERT INTO `zp_menu` VALUES ('51', '49', '添加公告', 'notice/add', '1', '1', '0', '1519800659');
INSERT INTO `zp_menu` VALUES ('52', '50', '编辑公告', 'notice/update', '1', '0', '0', '1519801594');
INSERT INTO `zp_menu` VALUES ('53', '50', '删除公告', 'notice/delete', '1', '0', '0', '1519801618');

-- ----------------------------
-- Table structure for `zp_notice`
-- ----------------------------
DROP TABLE IF EXISTS `zp_notice`;
CREATE TABLE `zp_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT '0' COMMENT '管理员id',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `inputtime` int(10) DEFAULT '0' COMMENT '添加时间',
  `updatetime` int(10) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `admin_id` (`admin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='公告';

-- ----------------------------
-- Records of zp_notice
-- ----------------------------
INSERT INTO `zp_notice` VALUES ('1', '1', '系统公告', '系统公告', '1519801040', '1519801562');

-- ----------------------------
-- Table structure for `zp_photos`
-- ----------------------------
DROP TABLE IF EXISTS `zp_photos`;
CREATE TABLE `zp_photos` (
  `id` bigint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `images_name` varchar(100) DEFAULT NULL COMMENT '图片名称',
  `images_url` varchar(250) CHARACTER SET utf8 DEFAULT NULL COMMENT '图片URL',
  `images_base` mediumtext COMMENT 'base64位',
  `images_size` varchar(30) DEFAULT '0' COMMENT '图片大小',
  `images_type` varchar(30) DEFAULT NULL COMMENT '图片类型',
  `inputtime` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COMMENT='图片库';

-- ----------------------------
-- Records of zp_photos
-- ----------------------------
INSERT INTO `zp_photos` VALUES ('22', 'file_icon_2.png', '/public/uploads/20180312\\1a13e30997aaac14603075ccd103bf1d.png', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJYAAACWCAYAAAA8AXHiAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMy1jMDExIDY2LjE0NTY2MSwgMjAxMi8wMi8wNi0xNDo1NjoyNyAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNiAoV2luZG93cykiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6N0E3Q0JGRkIyNUJCMTFFOEJDQzBDNzdBMEM1MzhGMEUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6N0E3Q0JGRkMyNUJCMTFFOEJDQzBDNzdBMEM1MzhGMEUiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo3QTdDQkZGOTI1QkIxMUU4QkNDMEM3N0EwQzUzOEYwRSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo3QTdDQkZGQTI1QkIxMUU4QkNDMEM3N0EwQzUzOEYwRSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PrVrYK4AAAqsSURBVHja7J1diCRXFcfPuVXz0eNksqtuYowvIUp8MJBEBAkJeRCDkeyDX4iCeU6QIJIHQ4IEAmZN9EEhJIgR8Sko+PHkswpqHvzAqCwmgoIrgeism7DTm5npusdzq7tnp3vqu6tuVXX/D9ypnpmuqq46v/7f//2oKhYRQiDqDoNTgABYCICFAFgIBMBCACwEwEIg6o1w+uLUc39PfRNz/PMeJvs4E9/Z5QMSogvC9A22/AMWGRVekScFkXVuSQI9SVYpkPSTdfGhm66ClbPF+w3Li3rmt7t+8Hq4t7DQC/qhb9RfnwQOLVeFloO08jZD8i19y3bPju0JPbpb4yMsUqBWzYDFYtPKzVoX3tS7I2MyKt13yVTCUwuGtBr1WJx+frc0SbaXRl/kdD6AkKpGwcqoC4T6+63O/eDAqmmwjFQQBPq9JuZP+jJo6fNHSsYZXZ5NFiNg0z5YNiMJKdAJ8Y908Qy3pmi6Z8u3sbFnk8EXAnAtm/eqYcVhxa1AZcW4fZfaOaDqB1g8hct3OKjK2iRA1SPFOjI7YjxCVd7SAaqegjWFSwAVghrom4p9T0N0SXmoriDFPexuoNi3n1zPum7v5H9Vh8qYcTs0qXEqqUr1oC4+ijTXFr/S8qyWvcJgZVQWkuncU1fiNBAqAMxUsUvjlklB1NIOp4+TtfcLBZ/XfPyrEFgZDbvUnLp1stIt7AbsFlAut/0gv7bmCON93uASvkuz8tSe2Xgga0im8aacXcA4i+G8EWTCGHIbIZ8aEb/dDXskldmqMMoYK0zxX+zMVE4fllszUriCeBy7xEd3zBebpseYB+u9SlzbGQ1v0Je7+VVh5nbSoZFilCjJhkxMYu1dCgadCf4lK6LsSaJhISdexb0nATOFSzI8lZOfctsdajmPSrF+eLRcp+VMcq6yuxFC35/W9XPFXRFJHDg/ZqhsC/BVrTLvBQf1g6WNr0c0F18u2VkwB5ZUUKaK5jnu5+Lahq4PtVwAB400ui6m+6DsxLdmeyczE5DB7kLlslO5RgtbPQBtUZr5qloI0zo7ANWi0WpDnY09Ka/WEuGeXb2GqlXFMsZmSdlYujh+IzLeM6haUywuOsYT967aMWgQseaafw1MK/KuWJlKldUCcSXujoAB67JStQJWJajmAYsmgMX3WgBkXVMq72AtDNUJBSPcyKODSuUVrFqhSgBMAFfnooh5d2kLMv7XDlSIxRpQxVpDaXwEebkvoliOjLcS3us2PErnTQBVD+CKR23dDN3kvsPDSY7n/3kolD0P6thYYepUlVdI7Kcn9B7fwZqu8+ekeojZUq0T3hFN0hWXyJzMv8L2wzCKXp4TELeGHQXyzxPOJAksNqOxznBAMjvp75KWnxf6jDFQtng/FaJ9ruKp4xLnzLKZbym+Mim5EYgZ+yUzP4OUx3PTRcEwQaS+OHTzJrKdsRxb10SEXsx+Axa46Xs0Vq+8rgiZVGGBylGojERWlzyeuZLpsZij+EJPB1caW9OxvlipEEsTgY2OwErL/bqbQDCZFS5ZVWEal5nVWsGpxoh+Kli2OefM6XgY4UVUijzTk6ZYpwh92ohynF3KAusGFbhHaHyHvBBuHFGww+JAG4M/0aW7u/Z/5sG6Ud/yotatd0OsEKXpYnlMZeh2ffUF/XX3uMd6SMvdOEWIBbTrPhL53Lx5x11ZEDW4LblvBiz1VgOcFUQNhuvMvGKhlxNRR9hZ855y2ZUIvaF/fwktRMQxUrQRKHcqMNckATMLVtqwDdN5fevHcD4Rc/FHLbclATNfFaa3JFu+sBXRNR8la5TTJ2WKbwyBKH7DlrDcRq9WsoiVa+2VyjwGoRElPHvxCKvTC+WCUkGxEJ6UqhawYOhh1BtTLMAFqBqrCgEXoKrFvMPQw6jDvCMaN+qNKhaUC0oFxUI0plSNgwVDvzpG3btiAa7VhMpLVQi4Vg+qRsw7DP3qGXWYd4S3r3fo/9sC5VpmpYJiQamWDywY+uUy6p1SLMC1vFC1XhUCruWEyrt5h6FfTqMO8w6jvjqKBeVaLqWCYkGpVgssGPr+GfXeKBbg6jdUna4KAVd/oeqUeYeh769R7x1YiAR7zkyjoFxF4/ALraXAWoAF5ZoNazh+3K6t+LB1mT5DWwRgIcZAOIWq48HgNmaLc5+Ts3Jg8QqpVqxQE5WqFVRPjaPeKdaywxVXdwE3+pT5qfo1qVy9rAqXES4fQPlUrt56rGUx9Iua8q4qF8x7y90G0nJPcFPK1Xuw+qZcbSqUT+WCYvWw26Ax5aqxK2JpwOqyoR+Fxpsp70q1uFSKxR0kyylUH6Cqu1pcnol+GKmu9VQuejoNoEKkKdciftAAKkQTgTnviJwmEa8YWHUYAURhM1+WHdNbqBCelWsm3Ayc0XKBBajaMfJudr3QtERaHtaXL+WDlZawY1trvyDJ7YkWHz2Wd6Jhvx5x8BFNyTP661szvFCBZ0JTVzr3ANWijbR3a9maVGNF679dLRdnWJjtOB3qb1/R5W/1H88z8bumvPSj573HULke7PVRpIdQ30Fw+Yu+to3Qd3X54RJnUz+6PK3Lr5/k7cQmfqZ/uaDLH/MYXgxC+4GrmU4AKbfKaS2nSu5qq7gPo99Fhs6GET06C5akVIfSplzgstUaY1RhHVvmy2OJX768HjzcbY8FT1Xoaycd2rP7a8S8293uBkDVA03nzL8aQAW4qu83PVkhoEK1WHWHodgTqZPOKRag6o1yJdluo3sPlLNg0tjD7IYlhIs9QzUNB9XOwagjVSGUqj/QcvF0GkCFarEuqGarRkAFuGqGqj2wAJVvuN6gaj3vw6r94yGg6l28T8uXtKyXgMu99/0VlOqzunhvydX+oeVcCKg8HXd9puc9Wr7o6ZPfMSll4rwDC90Nvqok4Xi6Sw3hqrQrHT7UN/15LFz4sHKKbXAy/SsXwAJUgKtzYAGqlYbLAKqlMPQrABagwvkizG6AcnUeLHQpQLlqBwtAwdDXDhag8g2XG4YbdPgQtqcfElB1EC5Jv8r1dS0/1bJRYpMuzx+i8UWrZeLVSSkTf1sMLEDlTbliyNxc8vEclr9q+WTZVOmav9DFPaXWE/qe7vJpf1UhoPILmRYbrle6Kn2yxrUVRWRQ9UJ4dDf0Qr2E9q65nvYHp/W19b7/KnCVfwYs1KoluIiGO2dof/MUGTvKvQ973akqC1dYGCkA1XKMbzy3t3M9SRDS2v5lWju8Qtb4m6t51ebVBRaw6hRfw+13kNm8ltYOhrS1919iGx1lXDoCV+5tjETkZib+Pk0eKYzMeg/Nkfxb2HxNz/6b01zZMKT9cIcOBjs02Pufll2ynrJTBK7c2xgx8zt18QDy26JIiaHNvYuXDvbDcwehPSZL49tyDAP9sUa0OfJngfPgCudatYhOOnemjf3LX5VD+eXBRvSbpLfsq9fa9NzIz4IrvFoT8j7I6nAYMwhZvrM5MveqBLzGc00109I4YxpcR4gLyx+QvU57dgqEP7A14m8PDk0wOGQ6Xjai9nqCkroijsDaC+VZlngcCtHpapE+o+WbatRDJ1JHJS3DCbkutbeKcB1VhQrVXyKhT+iWzqm0fRAZ7DJb8iCNry18QsthQcEbOv0ouauDqtWiu5c3MoWo3xLiFCCaiP8LMAC8BKMweuZujAAAAABJRU5ErkJggg==', '3640', 'image/png', '1520847273');
INSERT INTO `zp_photos` VALUES ('21', 'file_icon_1.png', '/public/uploads/20180312\\e30419083e06e4adb218485ab1164892.png', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJYAAACWCAYAAAA8AXHiAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMy1jMDExIDY2LjE0NTY2MSwgMjAxMi8wMi8wNi0xNDo1NjoyNyAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNiAoV2luZG93cykiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODI5RUVFNDgyNUJCMTFFODk1N0I4OTBFMENERkUwM0EiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODI5RUVFNDkyNUJCMTFFODk1N0I4OTBFMENERkUwM0EiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo4MjlFRUU0NjI1QkIxMUU4OTU3Qjg5MEUwQ0RGRTAzQSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4MjlFRUU0NzI1QkIxMUU4OTU3Qjg5MEUwQ0RGRTAzQSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PpFlnLIAABuUSURBVHja7F1drCTHVT6numfu3bV3bePEMQo2WMIJSAlJhIRQlPiR8ILCgwVIkQApkSMgEsJINkgEMAiBeAjCxFaiAIIQECB4iIKQEIpCIvFC8pDgOCGRgmMn4J9ge7273nvvdFcdzqk6Pd13bvfMdHXP3L8qbe+9d2a6p36++s5vVSERQSqpjF1M6oJUErBSScBKJQErlVQSsFJJwEolASuVVBKwUknASiUBK5VUErBSScBKJQErlVQSsFJJwEolASuVVBKwUknASiUBK5VUErBSOaEl9/9/4vXhL0SAnR0AB0CEgLngjnaBSn7R/BrZ/AMIlv+2/NkT3CpphzEODH6NG/IIlPCvcNfODShtCc+XANNM2iWNDHMLqykmDcfwXnURf9bY8J6bhHvkM4YvdP3nptMrqv+qhS89b5Y6O+pfV1OG+6T5wP2QO32e9pHL6noZV993/zcUWN2gewPf9AhYc7/0BsIsql1bL9KR1kqHvJnr+g++Uyw9xE34S373O40RSmXLovASX+/nwXkSyvL+MMVgYTxw9YUrrnU/1/eqqurZRf5gkP3PjT+E52dPQob3JxVgW6LwcLmDr99jML0PDq05NB4ElIloyAI1dtE10uFB7vycfyI/KotnJqD6e/xPngTWBcYqbfhJ+hmi14Czfw+Z+SX+4EegnjGpbAZYc9l9iX99lIh+Gud6hmGRKirWlD+dBRB0ChIeRMNv5vlyMHhA8ZhOshXgWwEkr+s1QFwBFPW/gnWEG3sAewcBZPKZkr8X7WP83Tv8vD9KENgksMykGpDfrkElf8vAXwygykRBMwCtK6cpTH4BVTbp+EwFKtbVhPyyvAGWFfoquaAs+z8EIPyATJTu/PCzq2eR/icT4RaW6hd2Aa5eB9gvArgKz2IfgomZ8cceSzDYFLAmuzLU97H19yDKICpTgbmJ2WoSAGOCKATHg2P3a9NGBlMGebIbQNVGZ3KP2+MxtYHNxKooV6DJqUgVQJF+V57VwGm7X+rKRDS3LiqwTfk7b7sM8Mo1ZrCD8F7ppeCHITdMafDnCQqbABY5gc6HalAxZzGoeESCqe1FjMx0Hpjd1wDceR/feVEHnD+//zQP2lcEoUe/obzB99wGePs7+e2b1zDIqHYFCD48M+FR26HtvhvfBLjG9cguLABbwS/sJaDe22+Ayz7OYlFe+JsEh7GBhfS93Plvq2f+lPufGcgULA3zACp7A/DWHwB4w3sBXveOMHjV4N/4FsDT/wj01Mf5iQ3wMLPh5TcAvPEXAW7/Eb7nYtCL1vHXzK3GHp6BV78B8K1PADz3Sa7HpcP3zsF1U6j3/iw8vrRMcfQY7E6u8cc/lSAxqvKODyHYWq9inQqzUq0/DHqN/Lz35wHu+okW54SA5wPMWk/w9dXwDBF/Ozy43/+zzHA/tp3WXHoTwD0fCKy1/+3DOlgFLhHFtzL4rzD7HhQKLncrzIrHYWquMrg+m2Axlh/L4U/VZCFWIHd+hkFJlllveXbfwmx121uWQPQi4GvfHgAlIhKZ7S59H9/zw9tt0Q6L6ss/xHVm1ckW4SqrnzxZiiIw162Xg+5VsW7hvgcO7Ef597cnWIzmILU3zXElYPJKsoFDIQQ3C9cy8eWNQ7b6cg0H+UeU222RgFrqP+Evn3ZcmXL1pd3w2aqZJb0RZvYj3Nw3JWiMAqw6SINi/ZkF31LGSvwrX2Px8eXuJ9kDoGc/DbgzDYwgLopr/w3w0ue32yL7KsDLLM3y3WDJGnVNzH9iHRu8yOrVHZcDCOfGhnszFPQx1vHuSvAYCixyc3wRZu0fMznQ1x8HePZfjr5dsGryxO+wzvIUD+ik1tUcG1tP/xXAC5/eTmv2+Pu//htcn5dhZdSmcqqKOHzt5cPe/8L+KAPsb8HHSlOJKei3ivy7e4ogHLijJxeAxJXQEIMoTiORGDIQE5aak9tYjNwbfEbX2BKbvQRoXwp62ZEINQULcvJavufucD8tiaT4SLz4u5Rh1i03uB4F16F8Ja4nxGn6/BXNAtAywS9Clr8fjP2PlN0Qld1Qm/WSLnPIymcdibyDNK/9UgWLm71n9X3xhPM1nXQ0mF+bsQVm+XLfXu49EEBJ2ycxsUOrLrjI+LJ8pzDXC6/UdSzorVynz8AuPMqvfbABi1TWczcsQbqM06HYXxVcDo5MlFk7nS4BSxnYRwZuWfhGrDYRS6an76oproem8+zw5LjzVoDvXA8WpK+XuwjX4WFuw4Mwob/gV36frxcbIDvLQJO2lTEDkq/UwDJcoqbwd04mS4BpRZx0B65JWUpqsTvpIQ1o0eRot1Cb+tTazMWVeR0z10sMrr1ZrQ1YN2W96wEG2AMsoq/w84Wy/5e/6Lna0bdW/UnrFjEN5jpEP1qeb41Nfb6TtI2f4+tL2ulX+breA1jUGANSYnFBbpq2oDKBd6jmkyX9I2Y/Bj2JluhSU7XYVs4d9TfJT+dqyw4V/Kgi3EdpXPhZgdBbh1mdPrOqSJ1FLF5n4+PaXsiMcCHUFVJyHNMayPWD50CqPTzXjQj+mn/5A76eUZCtAlZDx6p+R9Wr2sQXTxyaZjxG2D2xfKZD1/0qInfzbmDOQaRgKNVLLvdkebtOqzqmF73N50hM8GAW/qjYc2W+GJfLbMTcvAvwyo0QvJa6lK52qp5Kcy3mBs0qsfAeHtj3QEZ/xi88ytd/ri8KSTX8vEt8ueD87BoUYZNcU1ZaQUVBRO5Mlou7QvPMBaQiJi/sLGSFrmE8Vb8LY4nPynvYGdAHmnrTzJjoaouU77oZ4JaLQTTe0NyuOev2FLVHWDhGIlIsSur+W+d7qZEQMFclhbHhvdx/P8d//Cpfj6kqsAJYqGzVFgAWUJklGZ9OmaoTlFrBad5pQAYxphmgF/JgGFTMNaRUHSp1v5mBOisCwEoVpcZ0A9Zqpwo4hcEq811EeSH1rcQ59SMCmTwO+1uypMwZk2Ht+xfXBCUF6cTtRJEwPv1J1RCyOePkj3mwb+e/Hlk0YhZ0LPJtJNGd3IKxQ+q36coOrZjOx986xKMAttOVoBmfHpj8500XGv6XsW0dzV6VukryX+XHmuTLLVe/SKPxvojkjJ81c8qMPd0kol96Zja9mYuEJEqqmXdtc82ESetwPWBiUC98t5TM1sUBv1TMQQdof5M/cEVFo4XD1gUeUsuPdi6GmF+2pANEvK1iqnyJS0CCwwK8nTz4xJxbnV06iMFUFIlIluVgAuiijGBBVJ3O1nVe9/IDLQZB2e8+uXwslmpxte5VGTl97qm+I5+GPDyzW2PGG6qlKPRvXXQoNMx3bFXI0etVEqXpQLh0TN6hDPvOtoEhfDZoGwuoy+HCmunKowJMv0v0uKyqb1/9FtVPZ6G33iMiVPpurTy1BY0lz4IfsW97Teat/4iGesSQEX31QgNcJAl8H+KH7lYYOMxY1DGmqCZ7K3BILbGsW/mbmHYdxhsbNnSsMMdxrvarUpgz6j3INbhMcPT2ZU6/qMTFgdK7Wqh3XSnTce3V6ZoqLgtsjIT9pk0CuY8f+LaqDQuMBYrkRdcBLHFylqqbtHQYKejaFmH4RQ1FcKBOzHZZalnHyQQRoJex7GOCUt8XXKK79gZlqC/6iUA9WSuPCxqwTod+YQ0pczVWjjv4IF8XVntwqeGAbBt4a7uVcV2R0/q+VEZSgyemWy87ziIiX/q9nPV3B3g9kuIYL8f+E8zvApD1F2vVIhjoLxLJ6BdLCnvTsUDw4/zcSYcoxEPe84DODvBk1J6BQOpQm7SARjpQnJXCVNMMTmyRusuEkphhb3BlGmuMuC8iMVJ0X4xin6zNBbXOzAu6nfdaNJzcZLFqQLco9OazrNbpEFPOLncuIrSHaqyGek4yqJrgEp2ir8tD7plinKtE+tT1BwlF3UfLx3DJfZRVzDxpCD7f3nesEIXOgwyXsRV2meCuzidfZKvZTB2SpyAmYlQxLov+rOUdgkWEnoZRLCKZv70txEpnwp46WsVaxrWI/eydNbCwRRQaHfw2n5YomfMVPG2d0wI6DyrdQijLTsd+L35CasJhaSNYy/S3ML2ulUexVlweW6WjYX/W8iJu4V6Ce2tg0YIo9E4v2xG6Ub2qi618xkKH971K5DOnKIKLqItCXERcDxUgfVkLlmfZLrFKkYq4NmLEfXOj4VBwNl8iCnF55sKyILTp0LcKVeZXJfydSNbKNBTi+rPWpGcMsWkhxlq0sRMoSl1wrfPGtPak5GTleUdoxy4BBn/JTpuYw8BWSPGpw8fKWpWe4OIGK8ayFIC4iKVzftwiLD2T9b9vSSq4ae8P18FYmk7T+h510768nmHDb3IKS2b6i/Bq/UKGcc1GgJjUGJ+BEsFYscp/Wx3zozqSWjKlXdD4MayIFuWb2lJMKET6rW3xWxUhR0t2o7GnE1dB75FkN1wv47V5nwxYcdBfTEn/F7PGfdUOiJkqzUuU8aJ/rpd3IViCYVmMuAgsCs4uWRZ/690tYYlVGQ7ucOZm876dQq2k/HTpV4v9lbt66Vef4tOZqzBKz9CL5Htlep878JuzwOxFnvjX9XktSQMSCxQlHic9J08WEgpWLIXoBywfd+KK3HEfwHe/y69sbhGoq6m/VWfDOnaIpzSnd5SJHPEQrKx2kRgMptnLAHvPAFz5PMCNp5TBTIuEwkilY+iiI9ciCv0GILJ44GoLsFI5ftaUvSduB9h9PcDFewCe/yeA6189OmGFsXxYKQLIwlojLGgzR6bHaWWU81DEKhV1RBb/TmUDvJ9kNePOVpbxxleMLyzL4qzKdazCVE6Bwuf2dMumtzAYdlt1V4y2wN0GgIWYttc/LeASRf6Wt/q9YlvBgKOhYoRHnOY1c+dRNIrOJQl3LQTh3QcxVrgZEMtVmjTrWXapnOjSkRDgMx4gMhM21uHYCaxUUgGI88IHYJkErFS6ZGy/7UOSVXg+dfyom2KTBUJCfALWOZBpcYpzLLBUhCZgnXVQmQH5WRTvz0rAOvPgMpGWPs3ZJwErlXaAxHrSB7ieErBSWcJ2MSkdmIB1fhgr3o3ef4V1AlYqqzAV46pIVuF5wkiESBtCdAlY50QYxi7kwASsVJYhBGNWR2ECViobchuQib4nAetckFYk9UTt80UJWOeGrKKARZHKWQLW+SCrY1rHmYB11s1B5xKwUtkQuKLNu/h7E7DOA67iBWm0SZmAddY1d9ryvcndcF7KgK2jYsRoihWeB8Zy8RmkEA6WTaIwlaNsUw7bg4EGxHQSsE596T7NIvro6fl92YjASsvrTxeo3Ez3k6cWVEUchTK/38YvHTsKrA0dPJnKhvRyBs7+c2Gnv8Xi7ICNhAc4VqmNsWhgEk4qWyasHYCrXwKwry6AiPqfQLb4aBp2oznCYglXp6PklwCufZWB9UU9FwkP6e1EQ84qwoXDuiKqd/SZZuWuvKkcJ0tl4ejc6/8F8MKnAIorR8YK2RqkIePnt7LKxgKWWhcF0+rsJVUK15HzBHE7SFD7Ub6nw5av8lE28Nwlz5RJX/DYXPtyANbsSqseRbJLsxkADH9wwWQkYEnOjuzx/sK/A11/kusr595MVlsVcmDTTmQlZOvnacexvidSWcZwILmFYQPXVQ66zi9asALLV9Rqy1vIZjjb+K3DB86Zo7smF1cB9vb5N8u64c7qKKZnOQbXdBpHuTM9E3pywk8EQ62rq/ZDGJmt5Lg9YYkSV5hcmsOO7XuxY1ky6eVDGztcBWzXsaahI5eclXKoDtLZFHEkSHVCp/zcF+bLT+auzWJ6z6QzpuH4krGLMLfoTSMMKLmBj5G24mRwPUw3WByz7ZqHC4lYkLMIY3I0qnCUHIcioqA4YWeiSLsEVKIWbOI4PEGCHckcF8kxlK1iDoZaG1jVW2yy0rqOMgFGMbBScrSHMN9eEc7kOS7RKN8rcTapB2aNc/k2UA4sjBVZozGSRR1uGFjKWn6A1xZPWdBDBh0NguHoFWuCePRnBNLmz+AhqgO38r3OhHps0rEnE9GMJP7LEdjKK/6TMablitN4Kv1qXcHt92Jy4WChfOAsnAOMgjhCVfArqRF55NphIDWNCJ3uct5fvmEfHqqIpWwcUHH9/QHyQx/lvfVDRWmX8r7YAxVjrG216T2S8JWNQPEVwPyspPpAzdwszzU6kkrUSFqTZ5YuXELa8qw8h62U6rRZMuMZKv6gzeH1lyGj4XyFsB48jdez0FsLZj0gyGD5QRsJXE0/UnWUWnXkGrWISVP55WiB5pXqjEYX8p7HvI0CAhv8YCOBikRCiF6EA48n4wnrw0AjYT1fa4Y5ZYvpml72ClyF6ltm7LSvKoRulvhdqMM1QB2/b8lt4cN6Iw2gnIrKIpzGCL9ZN+qxyus9iQfQk4KlXo32bghhFec2HNymlmvZ68dQZOAKPRN7JFARK+xEI4DBnyqWjWqorF8rkoa4ftYZ6jGzRaXPnNMi4m/OVCMNHrl+E32ZROpl+Y8NLJ5pXoy7iJPcUQ9lLO05QxQFdaA6R3qssfOnKLtxrEqvo47LVv2A5Y/ByLhB/LNvlmm137j4hrwT9YxnqVbH7YpPj3DcgLUXgSMZAN46LmETekqEgM60MhG9jcGb773Njs7maa6VK0P0KeleNONNJG/p2rgjebv8VmROCLAwBJz9rOntDVflFVQ0SmzrLLGUXAczdXPgqFZWpVd5EQgjiEBUY2yo8k/tRlGEV03BIQ00MayjCX4+t4ivWRF8XXl2eiWk96TbxsoYsxkruNSA9Rh4FV15qJPWi/x21Sa+iuKCKNwwmveNyoPutV+OFEXdtn7uQt19V5rxWaoaQKdW4Bg+wTlbjdF+0+rbHFZLUeYPipC1OAhcDZ+XMNhpYC6ndS2wPuF0UzqjZRFY2BES+BRVkg5FIyj/kmLTsbLLHJGXvd0JkkdVjNNgn/Q3CWLFA+wEIkz0J8n2LLXtuOGlTTIePoKxRpr4ugwrmSODHauNFdgtzc9bNVDvKe/RWWYCxJ2NMenJrc9TPcUn/VHQv8wx7wbgTXwNe+CG02maE71wylTjTDJU4qDBIlss+6xTfcnbdGsvfyd9V9DkgWUmY6UXYx2x91kNRVD680acbROiZ5ElZ+pakeC32eKSOB9XHEv8VWRlPQ4QBrajcqksUf7zdopTx5mkq6wtjuRgjQxQHKDTfNwZLZXPJrVlRGo0iDU5ZnantFvCG5bqWKeZwNZLBSoYN5UH3UhiWyxBUnGK6zJWpXqJLiGd3EsEKbhER5pkm2EUbFhegqei0gsbS5bWzU2vIgjVGkEP0hzgONfq2hBXHZOpwnNLTa8ZOhFRLcrlxkrebd5WCXt9fVUYIu4HwlwMsk3rRogr1uIt0+VOmOfCqqJuRgaVU//XKLqabbBVF3i6unZuihpA6/pbZ6iNKDVnnijtCbFKr2PRh97pPLboJc2CGEdlQH4WLs1UX+u8QmYfh3Fb2vjnZ0Eci0W18ZysU1jmy+wkVIOasDeyi8W6JezS31XhU7eWwmbtPUhNiKTH7pck+pCAs3DnMG1mBZNIf/hESLOZNYssLbzCPko0QJiKwr6kuBZq1mEejQ3GOizReL3Lh5VKDd3gOaUvDBKA2MDxbL4pS8GG1BqCkbIrHK3BVn3VV43pYWnjK4lh5sgyJRJLrijPIUnx4HC7Q5IejpemfNQKCBJptK2o1PLuseeW6QMMv4pjaKIeBovCu6IK29/Lf2pZytY71dCGgtVzQwBgPJ+Jbh/q+sVCe2WQBlDkfkeTwUqrX1bGYLUae4MzmPiHGk/j9lGhu+yh2WA7SZX1ccWr9wys7aoIkMp7V9zrS7l65vMROl63JWTxiDQb32t/bGLP+WC616Eo28KkoUaYZUygahvWllLRJ1NodqR0VlmMOLOD116UWi8yTm1avPOZsZ6hYMPpNE0QF278NGOnmRB9nmmajBWVQo1eLHpw5WM59cKm9T6/i8GFVbbptpa/D9FrfMgEQtQBx1/1svS7Cxp/z1gPKuivC6pbKq91nkggkGxfxCJsMh2xVQqwilkPLE963UYxO0Gb7vpUGhtM8Cq2t00p7oPVGwCV91lJu+IJYyQqmI6cMnPUkvSDJ+GEUk9hqJhsmwq/Fzml7m2bHQ6Ib13iVkvANjDRZLK4fNAkWRCFVMf1+uo4OPGDThsdbKyj/j6zwbHC7xokZzRnilY+Z/ln1Jpz6g6h4CKgKsnvWG0L3YTYGthIFN1pJCB6DA22ikKi+E3OfP6QiIfM1CtxNlrM4UxImcHe3Lb6zerCaOqQ2AAWNQ2S6ldU0abL1CA7OQcr8LigsAltCFR+5xrq4QOjo0Yd0v4cWD6HCkIcz596LpWP0mV01Y2P0tuw9SMew4xmVqMjfrOWvuj0sZ1Q94XkaW3KdeFB64IrqZeOTYcPzHTlV+buBvSacd3x8nC0ZXxP+8CzhoDSoU8jWJyqpMOm1IyKCfOIabyQWGDsZ5t+rBcbioumR2TBhI6ODaqnudSsBnIJJJEshZbGs7PaxFkZByof5hN9rwJXENFfqIFVukebSq33gIucFQVxILjEapHUDd85bkAQ+7yxVLVHgzObydOqQGV1tU3U7azLUiO8h/k1oHBMSQDWzD5W55HLRqn7SnEKLjeMbciHgbIQHE3stYYbQdwqesKp2XBcMdoClOziPdAFliFb46aXfwtu/r+9Glh5ts9f8KfzvV/5w+T26lwsyZemEdgGdTm9rL+0ZWNf0HNeqs3PSt1KkswI6/5WiFire5dGWZcYDt+kgxoTmM0YVB+DSy+WNbAOJiVcz34X9vWoE+953Q+WI+rMKWHw4Yp1hoQcTGB0M7ZCRSaeT0A53e3QYWMVzUblrKbBmHhQsfhD9ypo0pdiy/yKyL75p7zf6plL4NGzn/8Cff72P8HczulOznghcyH8zqxFOSuTYy3c9IylDlm/fXcOcd7Z0waoav8EbJwEsY2JpToVxSyx1/oxS6G7oRKscl+ZT/J1P+y8GgKm735OTY27r4NX7fezD+MX7ngTkXs/hn0h+d9eUObNDvfDLj80ACxsOzSwM6rzCqnajZlByxdl+RllMJwHq8NE3ZLnFZviL4tiKmRAkZupYddYpoPmOR6rRzyN7d88//xhG7P0uTy/jgYzHuv3YbXTMIWzbRD3uC8moWJuAxuLyXaUXlzaADDEMwOw+Z4Jc9GxzXap+OsNZNIohtWf1bZV+gyTPcX/PcCI+5I2sgNYobzM14N8wxcZnh8OlFeFQKrYHM6Pttj0RDszS8ZoewJvIxVvjkrQk/+Zf3mIgfBk211dXrFrfH2U3/4cISv1ZN+Nh1bW0PG1K5VjhJisOs+/yf//Mlj8N37patdnl7lbxQ58gtH0M6wD7bBO9S5+6sNsxdzLX7EbTgVK5eybrWZGrEehcR9nSLAEQ9be6dVVUx6JEiWkMn75fwEGAOoV5TTjzgIhAAAAAElFTkSuQmCC', '7968', 'image/png', '1520838632');
INSERT INTO `zp_photos` VALUES ('64', 'fight_10.jpg', '/public/uploads/20180314\\3644e45f6bc65075eed8e3eb3b0f1c77.jpg', 'data:image/jpeg;base64,/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QMraHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjMtYzAxMSA2Ni4xNDU2NjEsIDIwMTIvMDIvMDYtMTQ6NTY6MjcgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLyIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bXA6Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDUzYgKFdpbmRvd3MpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOjRFNDEyRjA1RkNCODExRTdCNThCOEMzQzE1QUIyRjgyIiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOjRFNDEyRjA2RkNCODExRTdCNThCOEMzQzE1QUIyRjgyIj4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6NEU0MTJGMDNGQ0I4MTFFN0I1OEI4QzNDMTVBQjJGODIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6NEU0MTJGMDRGQ0I4MTFFN0I1OEI4QzNDMTVBQjJGODIiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz7/7gAOQWRvYmUAZMAAAAAB/9sAhAAGBAQEBQQGBQUGCQYFBgkLCAYGCAsMCgoLCgoMEAwMDAwMDBAMDg8QDw4MExMUFBMTHBsbGxwfHx8fHx8fHx8fAQcHBw0MDRgQEBgaFREVGh8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx//wAARCABkAGQDAREAAhEBAxEB/8QAkAAAAQQDAQEAAAAAAAAAAAAABgMEBQcBAggACQEAAwEBAQAAAAAAAAAAAAAAAQIDAAQFEAABAgQDBAYHBgQHAQAAAAABAgMAEQQFITESQVETBmFxgSIyFJGhQiMzFQexwVJiohbh8YJT8NFyQyQlFwgRAQEBAQADAQEBAAMAAAAAAAABEQIhEgMxQVFhcRP/2gAMAwEAAhEDEQA/AA9x9Hga+EnxqyKjuhr1puOJzEJX3NPHKUScfGMji22PxLl6hDaNpFqnUtCn3lkJWe+6rxrP4QNifywdElUltsanlBhqXgHxFDsy6hDENQKuok3TNmnaOSdOp1U9stnbBZ5630tMnVVPobX7SSQt31TAgzotRz9fSCZp0cQjDiKnB9gMl1VW6qUhpz24SjWgf0aHEJFSkgLG6ciDmJHrg8log5d5sv8AY6g1Fjr3aEnFbSFEoJJzKDNJ7RFM0li+vp7/APQNDcltUHMik0FaQAirVM0rsz7WJLZPo6YHXzl/Cfi3FVCXW0qbCVNkayEjVqCsQUqnljMRKc416/0Ef+X8s/uf57oTw+F8Hbxv73DlLX09ueMU3wTI5ar7q7UTZpRwacDFZzAG3qjj/r1KRtNIag8VIJpUKk2j2nF7STv9Qg0uF7heA3UJp2AKivVNLYT4EAZlPVtUYxozQ2xayaqqdEh3nKgiYH+gHMwdDCV2vTFK2WKNJYTLvqzWZ7zvMYbA/T0VfcKhK1zS17Kc1EdPTAlTnKaY5VqlCak6VdUu2D7D6nK+XXmUklpUpEFUp5jbDykvJqpgU6dASAnTMDLGKyp2GTSAKwpTkcFJGfZFJSlUrV3VpJJmQcZSlB5oYtr6VfWWos3CtV6dU5agrQ3UYldPqyUMcWzPEbNkN1lJ1yvv5rR6PM8ROWvxDh8LTPiapy0y2wnqk4uTTm5VJo2FFFAydVbUDNahkhPbHDPx6lnnEhda9VO23QULfvlpDaW07EjZ0DfvhbT54Ys1nYYBW+rW8vvVL2w/lH5Rs3wZS+jW6XkrcCWgA2kSZb9QH8YGiXsPJVTcXePVJKgozAlh6IF6GcrR5f8ApuzoCgjSkQmq+sEp5Pp229PCSoylKWfWI2h6wPcwcsNJYUG29K5HT1jZDTst4VNejMAFMi3qQrYZpwxjp+fWuf6c4hmgPNTBxA1Y746I527alEOpURmVA9I/lBZ5twoJJw1JIPZjG0JNEX775j/av7W8z/1fE1Sl3+HnwtX9ueOmD7h6eTV9+ktFubDR92kTaJHecUcOIobzs3R59d3PhrbaZ1lpdbVj/kPkJQ1Pwz72me+WKjsjSjSVXXFRDLZ1JPecI9pQBl/SNkLaMS/KPKNRXVIfdTOePR1CFtPIvDlvlRmnZSVJkABgIURSltDaAhCQB9kZmqm0AbzvOcZkPdqJp5lcvRGZzt9RqV23XdSRgzUkuIG4ykofZF/j15S+s8IRpozW4U4DQmfWP4x13pyWE0/HUMidQPbPCDvgGgkRpyIy7RKDvgCetfldU8ZaZ9EDfApBDvzGvTUvq0UzM1IKsu77Z6E+sxwa7KRr7uuqWGmgU06BpRsVpJmSrpVtjMIeTuW6i6VKXnUHhT27sonesWnC+uWLNYaFlCVvt8VIEx7I7Y0uj64L222SkcMgp3jKDgUk42UzlGA0eVpB6c4B5EVVPAgg+uA2Kk+r9oFZajUNj31MoOJ6QD3h6Ipx4S+kA1WyW2FKR4XFIUmfVHTOnJYipgPTH4h24RSfgZGiVSU50YT7Jw0LYYcb3ej88v1ZQ2AUqKh14+XYJ4EwlQAxWU5IA3DOPN13ZbRvyT9N7hcH23qttSGz7JH2wt7V5+eOjuULTYbJTpZ92H9GqRl4QQJ9UDny3aWu9PZrgwAAgzxStMgrEbxsh7CTuz9V65e6/lSvDVStT9tcVgtRnpB2zxygRX/kYUd7pK2mS8y4FIUJgjGNaGaSqH0kGRnLGBg4hqt4lRG2NgWhLmtCHqCpSvEFtY/SYaJ9VV14cphT04QvAlMkiWEpfeIt83P0HtXfSdsyY6Yj/SYMm3FzlOfqAEFqacMadWzXOXbB0MdX8q/QrlawNIdW2a6tAxqHRh/SNkePNr1/E8CSosrKUFtpIbGUkADDshvVPVM8/cm82M3ymFrujifMqW3TIcVIJ7pWWtQEzq0yTPbFfmn9KB2fqBzjYKxhm4lx5lk6JkkpMu7goTylKLern/8ATyObXznS80UK0ugA4p4asTlmYj9OM8xb5961s1bcuX63y4KnLe6e5jMIgS6fbo5prqmpaSpM5Ef4nAUlJ1D/AHDOMWhPmmoUi1Vi8yllZ/SYaEqj6i4E8MEz0S/zi3Dm7YVUgKCp+zOOnUmDUJLASDgRL1xtYnq73Bn3uFxP1ThdF9A6kBLUh2x570eb5DtW+G1lRyyjDeQ5zO1T3Gh4ajpWhQWhwDFK04pPZBneBePDn7mH6dvKurrji0KaWtbi3u9qmskqMk55xad657M/hlY7W9Q8zhu3ku06UAqGrTgMJ5GD1fGBzz5WvRNM1LBbcE8MI5rXTJp4xTrYSUpOByJgy0GXXT7RnBChXnF8fKatI2tL+ww0KoF99QBIw70U5rm6jV2rmwr8RAAPTOK2p483VkFCCrYBBlbG/nk+c43Tp7JaZeiDrY+ileoJRLZ644XoQMXFJXMgemCog6ileUDpM+iBkLoYulnfWsngqBzmnEQZ4Coak5SU1XKqWWSl15OhaQJDxT1dcPb4TkHFFymyzR8RzB3M9cSsUnSGuryKQlEwfugxrQ3U3TE96DpLQvzNcW3KF9IWCShQlPohoEqknld1Y/N9sUkc3V8m7kwmQ3gQ2lbf7hP4MuuCxHX7vt++NrPoZX3hKiTq/pji93p88IZ67Nk4nsMNKPXJubk0snvDog6T1SNBRrqRrlNJ9EGEp8m0oSvVIfdGwKYX+rDFKUBUgBDcwNVDzBd5PKAmroGMJRnkMvP1KxqAMjBnNHZA1erfVrZW4zgCMUbDDzwl1lVwtJClA56jMdUUiFhJwYjry7IMK1JmlRG0ygsxp91KWO6Fxnat2uZTORjgk17VuQOVFyfWshIM8sIecp+yZ5UsVyvVQoKUWmGvGraScgI2B7LKtzbdEgUqG5BIxWSSTLpMPEOv1tU1KGkqUrdgIeBVb833VTq1toVFL4KA6ijUsrWAC5KaSoTE+qBIHSvOY0XRhrVdqxxIcdU2jyqAEJSElQITNMzMSkTF5mObu0J0XMlzZWG3VqW3vVPEb8YXI22Eay2PVL3mKRsqaWZrkfCTnCmvlFV9M7TuFDgkQZ+qNKWzCDZCkzltn6IYGdO2e2cAXWzTq7pWBlrwz7yo4J4er1RTS8sUbSApwalYGHSta3Gnu1JRuCzOoadJ1ScBKQZZkCUL3zVflYIeWbvVu2hpd1QhquKPfBCtaNYwJSfwqzEHjr/U/rz58Iy/X1kIUkKx3R0cdRO8q+rqguvLUdp2w3dI8im1NE7YEahu/wBtaq2HKaoTNtzMHeMiNxG+NuF9dVtzFQM22ldpBSKK1yCameue7q7IedRPr5015TeeCXUPp0pSSO9hPCB2Hy/Q/wA0VQVXlLcpjPqgcD9f1FoKRJO1W2KJFuF3OiALp3kr5n+40fKtXldJ855rTon7PCl3tW/ZHDXqTP6tpXwvf/F2aPD2wYl1n8Rj3HkvRnLbFOi8/vgwY+ZfLVcOU+Ivrl/OIV1fwIVnzLjq42WzdFfmh0ZVk9KJT1ahOLVJLUU+EJ+H1xuWMrn5OR4nZGaA+6fLsOJ4JnTqyhR/7Dlb5D3vk/jaTr05S6dkbyW5/FW3XifMXdec8OrZnFOXP3ukW88ZdEOWH3cn0aYDP//Z', '3933', 'image/jpeg', '1521009131');

-- ----------------------------
-- Table structure for `zp_scroll_column`
-- ----------------------------
DROP TABLE IF EXISTS `zp_scroll_column`;
CREATE TABLE `zp_scroll_column` (
  `scroll_column_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '管理员id',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `list_order` smallint(6) NOT NULL DEFAULT '0' COMMENT '排序',
  `inputtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`scroll_column_id`),
  KEY `admin_id` (`admin_id`),
  KEY `title` (`title`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='滚动条栏目';

-- ----------------------------
-- Records of zp_scroll_column
-- ----------------------------

-- ----------------------------
-- Table structure for `zp_scroll_info`
-- ----------------------------
DROP TABLE IF EXISTS `zp_scroll_info`;
CREATE TABLE `zp_scroll_info` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '管理员id',
  `scroll_column_id` int(11) NOT NULL DEFAULT '0' COMMENT '滚动栏目id',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `url` varchar(255) DEFAULT NULL COMMENT 'url',
  `thumb` varchar(255) DEFAULT NULL COMMENT '缩略图',
  `inputtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `list_order` smallint(6) DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  KEY `admin_id` (`admin_id`),
  KEY `zp_scroll_info_ibfk_1` (`scroll_column_id`),
  CONSTRAINT `zp_scroll_info_ibfk_1` FOREIGN KEY (`scroll_column_id`) REFERENCES `zp_scroll_column` (`scroll_column_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='滚动条信息';

-- ----------------------------
-- Records of zp_scroll_info
-- ----------------------------

-- ----------------------------
-- Table structure for `zp_systems`
-- ----------------------------
DROP TABLE IF EXISTS `zp_systems`;
CREATE TABLE `zp_systems` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `web_title` varchar(255) DEFAULT NULL COMMENT '网站标题',
  `web_keywords` text COMMENT '网站关键词',
  `web_description` text COMMENT '网站描述',
  `website_close` tinyint(1) DEFAULT '1' COMMENT '是否关闭网站：0 关闭；1运行中',
  `website_close_content` text COMMENT '关闭网站原因',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='系统配置';

-- ----------------------------
-- Records of zp_systems
-- ----------------------------
INSERT INTO `zp_systems` VALUES ('1', 'auth后台管理权限', 'auth后台管理权限', 'auth后台管理权限', '1', '系统暂时关闭，至2018-04-08开启');

-- ----------------------------
-- Table structure for `zp_update_balance`
-- ----------------------------
DROP TABLE IF EXISTS `zp_update_balance`;
CREATE TABLE `zp_update_balance` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` int(10) DEFAULT '0' COMMENT '操作管理员',
  `member_id` int(10) DEFAULT '0' COMMENT '操作会员',
  `balance` bigint(20) DEFAULT '0' COMMENT '操作金额',
  `plusless` tinyint(1) DEFAULT '1' COMMENT '1 加；2 减',
  `inputtime` int(10) DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `admin_id` (`admin_id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='操作余额';

-- ----------------------------
-- Records of zp_update_balance
-- ----------------------------
INSERT INTO `zp_update_balance` VALUES ('1', '1', '9', '1000', '1', '1519806843');
INSERT INTO `zp_update_balance` VALUES ('2', '1', '9', '200', '2', '1519808055');