/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50547
Source Host           : localhost:3306
Source Database       : xinjingonghe

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

Date: 2018-08-11 16:47:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tp_admin_access`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_access`;
CREATE TABLE `tp_admin_access` (
  `role_id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `node_id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0',
  KEY `groupId` (`role_id`),
  KEY `nodeId` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tp_admin_access
-- ----------------------------

-- ----------------------------
-- Table structure for `tp_admin_group`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_group`;
CREATE TABLE `tp_admin_group` (
  `id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'icon小图标',
  `sort` int(11) unsigned NOT NULL DEFAULT '50',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `remark` varchar(255) NOT NULL DEFAULT '',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tp_admin_group
-- ----------------------------
INSERT INTO `tp_admin_group` VALUES ('1', '系统管理', '', '2', '1', '', '0', '1450752856', '1481180175');
INSERT INTO `tp_admin_group` VALUES ('2', '工具', '', '3', '1', '', '0', '1476016712', '1481180175');

-- ----------------------------
-- Table structure for `tp_admin_node`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_node`;
CREATE TABLE `tp_admin_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `group_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `remark` varchar(255) NOT NULL DEFAULT '',
  `level` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '节点类型，1-控制器 | 0-方法',
  `sort` smallint(6) unsigned NOT NULL DEFAULT '50',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `level` (`level`),
  KEY `pid` (`pid`),
  KEY `status` (`status`),
  KEY `name` (`name`),
  KEY `isdelete` (`isdelete`),
  KEY `sort` (`sort`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tp_admin_node
-- ----------------------------
INSERT INTO `tp_admin_node` VALUES ('1', '0', '1', 'Admin', '后台管理', '后台管理，不可更改', '1', '1', '1', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('2', '1', '1', 'AdminGroup', '分组管理', ' ', '2', '1', '1', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('3', '1', '1', 'AdminNode', '节点管理', ' ', '2', '1', '2', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('4', '1', '1', 'AdminRole', '角色管理', ' ', '2', '1', '3', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('5', '1', '1', 'AdminUser', '用户管理', '', '2', '1', '4', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('6', '1', '0', 'Index', '首页', '', '2', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('7', '6', '0', 'welcome', '欢迎页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('8', '6', '0', 'index', '未定义', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('9', '1', '2', 'Generate', '代码自动生成', '', '2', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('10', '1', '2', 'Demo/excel', 'Excel一键导出', '', '2', '0', '2', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('11', '1', '2', 'Demo/download', '下载', '', '2', '0', '3', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('12', '1', '2', 'Demo/downloadImage', '远程图片下载', '', '2', '0', '4', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('13', '1', '2', 'Demo/mail', '邮件发送', '', '2', '0', '5', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('14', '1', '2', 'Demo/qiniu', '七牛上传', '', '2', '0', '6', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('15', '1', '2', 'Demo/hashids', 'ID加密', '', '2', '0', '7', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('16', '1', '2', 'Demo/layer', '丰富弹层', '', '2', '0', '8', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('17', '1', '2', 'Demo/tableFixed', '表格溢出', '', '2', '0', '9', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('18', '1', '2', 'Demo/ueditor', '百度编辑器', '', '2', '0', '10', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('19', '1', '2', 'Demo/imageUpload', '图片上传', '', '2', '0', '11', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('20', '1', '2', 'Demo/qrcode', '二维码生成', '', '2', '0', '12', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('21', '1', '1', 'NodeMap', '节点图', '', '2', '1', '5', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('22', '1', '1', 'WebLog', '操作日志', '', '2', '1', '6', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('23', '1', '1', 'LoginLog', '登录日志', '', '2', '1', '7', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('59', '1', '2', 'one.two.three.Four/index', '多级节点', '', '2', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('24', '23', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('25', '22', '0', 'index', '列表', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('26', '22', '0', 'detail', '详情', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('27', '21', '0', 'load', '自动导入', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('28', '21', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('29', '5', '0', 'add', '添加', '', '3', '0', '51', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('30', '21', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('31', '21', '0', 'deleteForever', '永久删除', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('32', '9', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('33', '9', '0', 'generate', '生成方法', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('34', '5', '0', 'password', '修改密码', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('35', '5', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('36', '5', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('37', '5', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('38', '4', '0', 'user', '用户列表', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('39', '4', '0', 'access', '授权', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('40', '4', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('41', '4', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('42', '4', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('43', '4', '0', 'forbid', '默认禁用操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('44', '4', '0', 'resume', '默认恢复操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('45', '3', '0', 'load', '节点快速导入测试', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('46', '3', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('47', '3', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('48', '3', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('49', '3', '0', 'forbid', '默认禁用操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('50', '3', '0', 'resume', '默认恢复操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('51', '2', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('52', '2', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('53', '2', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('54', '2', '0', 'forbid', '默认禁用操作', '', '3', '0', '51', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('55', '2', '0', 'resume', '默认恢复操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('56', '1', '2', 'one', '一级菜单', '', '2', '1', '13', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('60', '56', '2', 'two', '二级', '', '3', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('61', '60', '2', 'three', '三级菜单', '', '4', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('62', '61', '2', 'Four', '四级菜单', '', '5', '1', '50', '1', '0');

-- ----------------------------
-- Table structure for `tp_admin_node_load`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_node_load`;
CREATE TABLE `tp_admin_node_load` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='节点快速导入';

-- ----------------------------
-- Records of tp_admin_node_load
-- ----------------------------
INSERT INTO `tp_admin_node_load` VALUES ('4', '编辑', 'edit', '1');
INSERT INTO `tp_admin_node_load` VALUES ('5', '添加', 'add', '1');
INSERT INTO `tp_admin_node_load` VALUES ('6', '首页', 'index', '1');
INSERT INTO `tp_admin_node_load` VALUES ('7', '删除', 'delete', '1');

-- ----------------------------
-- Table structure for `tp_admin_role`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_role`;
CREATE TABLE `tp_admin_role` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parentId` (`pid`),
  KEY `status` (`status`),
  KEY `isdelete` (`isdelete`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tp_admin_role
-- ----------------------------
INSERT INTO `tp_admin_role` VALUES ('1', '0', '领导组', ' ', '1', '0', '1208784792', '1254325558');
INSERT INTO `tp_admin_role` VALUES ('2', '0', '网编组', ' ', '0', '0', '1215496283', '1454049929');

-- ----------------------------
-- Table structure for `tp_admin_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_role_user`;
CREATE TABLE `tp_admin_role_user` (
  `role_id` mediumint(9) unsigned DEFAULT NULL,
  `user_id` char(32) DEFAULT NULL,
  KEY `group_id` (`role_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of tp_admin_role_user
-- ----------------------------

-- ----------------------------
-- Table structure for `tp_admin_user`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_user`;
CREATE TABLE `tp_admin_user` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `account` char(32) NOT NULL DEFAULT '',
  `realname` varchar(255) NOT NULL DEFAULT '',
  `password` char(32) NOT NULL DEFAULT '',
  `last_login_time` int(11) unsigned NOT NULL DEFAULT '0',
  `last_login_ip` char(15) NOT NULL DEFAULT '',
  `login_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `email` varchar(50) NOT NULL DEFAULT '',
  `mobile` char(11) NOT NULL DEFAULT '',
  `remark` varchar(255) NOT NULL DEFAULT '',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '50',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `accountpassword` (`account`,`password`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tp_admin_user
-- ----------------------------
INSERT INTO `tp_admin_user` VALUES ('1', 'admin', '超级管理员', 'e10adc3949ba59abbe56e057f20f883e', '1533805997', '192.168.1.211', '387', 'tianpian0805@gmail.com', '13121126169', '我是超级管理员', '1', '0', '1222907803', '1451033528');
INSERT INTO `tp_admin_user` VALUES ('2', 'demo', '测试', 'e10adc3949ba59abbe56e057f20f883e', '1481206367', '127.0.0.1', '5', '', '', '', '1', '0', '1476777133', '1477399793');

-- ----------------------------
-- Table structure for `tp_file`
-- ----------------------------
DROP TABLE IF EXISTS `tp_file`;
CREATE TABLE `tp_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cate` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '文件类型，1-image | 2-file',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
  `original` varchar(255) NOT NULL DEFAULT '' COMMENT '原文件名',
  `domain` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT '',
  `size` int(10) unsigned NOT NULL DEFAULT '0',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_file
-- ----------------------------

-- ----------------------------
-- Table structure for `tp_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `tp_login_log`;
CREATE TABLE `tp_login_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `login_ip` char(15) NOT NULL DEFAULT '',
  `login_location` varchar(255) NOT NULL DEFAULT '',
  `login_browser` varchar(255) NOT NULL DEFAULT '',
  `login_os` varchar(255) NOT NULL DEFAULT '',
  `login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_login_log
-- ----------------------------
INSERT INTO `tp_login_log` VALUES ('1', '1', '192.168.1.211', '局域网 局域网  ', 'Chrome(64.0.3282.186)', 'Windows 7', '2018-08-09 10:26:03');
INSERT INTO `tp_login_log` VALUES ('2', '1', '192.168.1.211', '局域网 局域网  ', 'Chrome(64.0.3282.186)', 'Windows 7', '2018-08-09 17:13:18');

-- ----------------------------
-- Table structure for `tp_node_map`
-- ----------------------------
DROP TABLE IF EXISTS `tp_node_map`;
CREATE TABLE `tp_node_map` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(255) NOT NULL DEFAULT '' COMMENT '模块',
  `controller` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器',
  `action` varchar(255) NOT NULL DEFAULT '' COMMENT '方法',
  `method` char(6) NOT NULL DEFAULT '' COMMENT '请求方式',
  `comment` varchar(255) NOT NULL DEFAULT '' COMMENT '节点图描述',
  PRIMARY KEY (`id`),
  KEY `map` (`method`,`module`,`controller`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='节点图';

-- ----------------------------
-- Records of tp_node_map
-- ----------------------------

-- ----------------------------
-- Table structure for `tp_one_two_three_four`
-- ----------------------------
DROP TABLE IF EXISTS `tp_one_two_three_four`;
CREATE TABLE `tp_one_two_three_four` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '四级控制器主键',
  `field1` varchar(255) DEFAULT NULL COMMENT '字段一',
  `option` varchar(255) DEFAULT NULL COMMENT '选填',
  `select` varchar(255) DEFAULT NULL COMMENT '下拉框',
  `radio` varchar(255) DEFAULT NULL COMMENT '单选',
  `checkbox` varchar(255) DEFAULT NULL COMMENT '复选框',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `textarea` varchar(255) DEFAULT NULL COMMENT '文本域',
  `date` varchar(255) DEFAULT NULL COMMENT '日期',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `sort` smallint(5) DEFAULT '50' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，1-正常 | 0-禁用',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态，1-删除 | 0-正常',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `sort` (`sort`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='四级控制器';

-- ----------------------------
-- Records of tp_one_two_three_four
-- ----------------------------
INSERT INTO `tp_one_two_three_four` VALUES ('1', 'yuan1994', 'tpadmin', '2', '1', null, '2222', 'https://github.com/yuan1994/tpadmin', '2016-12-07', '13012345678', 'tianpian0805@gmail.com', '50', '1', '0', '1481947278', '1481947353');

-- ----------------------------
-- Table structure for `tp_sdk_login`
-- ----------------------------
DROP TABLE IF EXISTS `tp_sdk_login`;
CREATE TABLE `tp_sdk_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `head` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`,`openid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_sdk_login
-- ----------------------------
INSERT INTO `tp_sdk_login` VALUES ('1', 'QQ', '深圳掌邦科技', '深圳掌邦科技', 'http://qzapp.qlogo.cn/qzapp/101496008/3922469857CEBD040A2F285D43D2C5A8/100', '3922469857CEBD040A2F285D43D2C5A8');

-- ----------------------------
-- Table structure for `tp_upload_file`
-- ----------------------------
DROP TABLE IF EXISTS `tp_upload_file`;
CREATE TABLE `tp_upload_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` int(11) DEFAULT NULL,
  `url` char(255) DEFAULT NULL,
  `path` char(255) DEFAULT NULL,
  `filename` char(255) DEFAULT NULL,
  `mimetype` char(255) DEFAULT NULL,
  `width` char(255) DEFAULT NULL,
  `height` char(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=635 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_upload_file
-- ----------------------------
INSERT INTO `tp_upload_file` VALUES ('458', '1533714807', '/upload/default/f803c12c54b6bef5dccd38adf0bafdbd.jpg', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('459', '1533714828', '/upload/default/38243b3d1b916f3cc298e521b24f57f7.jpg', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('460', '1533714954', '/upload/default/d8fdb5fdffbcc5675ba56f4de2055d3b.jpg', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('461', '1533716663', '/upload/default/2a90a1237b75ace621098b789484021b.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('462', '1533717203', '/upload/default/17d9a3dadf49fd681153518faed060ce.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('463', '1533717211', '/upload/default/a6b8e343033f000da70951f1e3ac7d7c.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('464', '1533717251', '/upload/default/bb86cd0bfdfe67518755899982904852.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('465', '1533717252', '/upload/default/bfe7bbf28cd522b6dccd126080a20c25.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('466', '1533717252', '/upload/default/112a42818be592ba19bb71a2f54ee70a.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('467', '1533717649', '/upload/default/335e99016507665386ae93b33321d2a2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('468', '1533717675', '/upload/default/596fc23bc7b9caa6d4a20bdef05045ff.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('469', '1533717707', '/upload/default/80977ef90fef01250bafa49bcd7df27f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('470', '1533717762', '/upload/default/89a6814568d9ded9af7cb17e645fe3da.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('471', '1533717777', '/upload/default/637462bd209b59bcee77eec1aeb427e5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('472', '1533717850', '/upload/default/9eb28b1edfb67bf43ef37e64397bdf7c.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('473', '1533717876', '/upload/default/d8e193ba0d04916c87f4566f02cfc948.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('474', '1533717946', '/upload/default/3494efd91d87da6a67fbac211c3b7f7c.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('475', '1533718034', '/upload/default/45fb61cbf5b81f6b1620f9ed86ef694e.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('476', '1533718065', '/upload/default/65b7fb7526faacd499df41f214640b01.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('477', '1533718205', '/upload/default/019f59bf1e22e02f9315f1369e8d26a2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('478', '1533718236', '/upload/default/15db4352a48274ff3a3d46a142952a65.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('479', '1533718497', '/upload/default/35afba2bf80c87adcf1e916b266eddac.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('480', '1533718536', '/upload/default/ea5ea2a4c7e520065241c7f7876936c9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('481', '1533718578', '/upload/default/8ec357a1bc84260fca63728e471a45c5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('482', '1533718582', '/upload/default/45a4462d73bc79ce19b55a263821acd5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('483', '1533718586', '/upload/default/326797d1fbf17f11676077c38ad02c86.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('484', '1533718682', '/upload/default/212c655e70df540d563758feee827d41.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('485', '1533718691', '/upload/default/417f7c9a63c7b199008a52790aa366b9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('486', '1533718790', '/upload/default/380fc7c8c0c03f132976cf342a3ee86f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('487', '1533718804', '/upload/default/ed8f5f62bc289b3e771576a131e665d7.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('488', '1533718838', '/upload/default/ca199a7289cc33d1223f97dddf20a82f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('489', '1533719029', '/upload/default/8fc37cb00dc95333c6092ed1027a2814.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('490', '1533719635', '/upload/default/4bf9d510cd861f1e6e8f81d6d23414c4.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('491', '1533719637', '/upload/default/32a38042806ec93df081aa5df90834f9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('492', '1533719647', '/upload/default/a3e75a498a6bd5b756dab98b1c2e6b56.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('493', '1533719653', '/upload/default/e691e67d16ee6941e60dd4cb3a6a6193.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('494', '1533719655', '/upload/default/f12ad7a6dfa5f339abcc3c286a100425.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('495', '1533719664', '/upload/default/02a19c6f5ccf728f61acf687972542a5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('496', '1533719671', '/upload/default/911c13227415a40e04bc3474e594f694.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('497', '1533719910', '/upload/default/a9c30ed587fdbc2f6adf830a044b90e5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('498', '1533722007', '/upload/default/b0a5a9456be5c9744e5107e33734b804.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('499', '1533722011', '/upload/default/e7528a899c25f3dd23908e6374f2fb18.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('500', '1533722088', '/upload/default/bed22a81b6011bbc6bd791f8e8653345.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('501', '1533722096', '/upload/default/0e9204ce3a41159635051279941785d2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('502', '1533722098', '/upload/default/7b277d7fab27fb5287785b8a45c9efa5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('503', '1533722162', '/upload/default/9977fa1d84b42e4ba8d35f5c85b2b127.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('504', '1533722164', '/upload/default/cab42c7f329ef8d20aa7abcb3d008c01.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('505', '1533722172', '/upload/default/657d14011250df0f56fa91561e5f7aff.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('506', '1533722174', '/upload/default/774fbfec5741ca74d74fdd37294bfe8c.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('507', '1533722184', '/upload/default/99fc7e7353d2d872100d1fbe797ccf1b.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('508', '1533722201', '/upload/default/e862a92169d95e53ea08c8bcda2cfbb9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('509', '1533722205', '/upload/default/bda3e8379b2b40617b65ea4598d2838f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('510', '1533722476', '/upload/default/3886cb6cf225bf62d8eeb67ae6497441.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('511', '1533722476', '/upload/default/49f7194bc1a7dfefbf5da0b03f3cf534.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('512', '1533722889', '/upload/default/6d1bc3e81399bb97012ff231332f5392.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('513', '1533722894', '/upload/default/37bc466b01bb21cd0f50337f7442b6c5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('514', '1533722917', '/upload/default/f549b9b370307bb96b23c08c84b1f994.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('515', '1533722936', '/upload/default/eb9a6ab723c8bf5f8f7308034c5aba51.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('516', '1533722990', '/upload/default/c4ba9d3a3a93b24467bc2612ecfbb790.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('517', '1533723023', '/upload/default/e19fb5e8b748ae2a6c14b2a5f3b13c5e.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('518', '1533723323', '/upload/default/8334d85083bf0575f441792a5d553be2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('519', '1533723373', '/upload/default/333b5da80e89b34478f99d3312fc7a19.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('520', '1533723406', '/upload/default/03fa7668820772409f32f6cfbec173bf.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('521', '1533723438', '/upload/default/8ff42828b527e721986b793c1ec8a012.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('522', '1533723483', '/upload/default/a8b39ef0f9dc208e93b1778cc24bd936.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('523', '1533723542', '/upload/default/16365cf3d66941ff432ccc49bac96a82.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('524', '1533723554', '/upload/default/2506fa095c46654751b4ca4b4692e9d6.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('525', '1533723613', '/upload/default/1d7b41c2eb4353a22965d8c2da534d1f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('526', '1533724043', '/upload/default/7b75000e3e039b4c97266fc7d4a96442.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('527', '1533724590', '/upload/default/b9e0a3de5ce97ec6b15fcd10df4b715c.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('528', '1533724634', '/upload/default/1d5dc5f4d3095ea1a45b0fbf965194f0.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('529', '1533724645', '/upload/default/c4faa1081a2a232e9afc7296690cfab9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('530', '1533724676', '/upload/default/0de235fd42ac4098d4d9e98b3c5e5241.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('531', '1533724687', '/upload/default/f545605c982b1a8994adf9e145c62f6a.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('532', '1533724714', '/upload/default/9f4c1547656ceee4d0af3cfbc50bd4d8.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('533', '1533724718', '/upload/default/7764b0ff0382d94e84faa5cffb46ce59.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('534', '1533724768', '/upload/default/5c543c071ae64bb6597e9e2e1f37e60b.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('535', '1533724797', '/upload/default/adaeb9139f32b94adc8fd7cba669c7ca.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('536', '1533724814', '/upload/default/98c3aa7f54b912e3bc802cf53d582e60.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('537', '1533724841', '/upload/default/2f45fd8d9d86e1e4d7b125ee00dc9576.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('538', '1533725242', '/upload/default/35bd219a8545ea12a81a5598fec1bcd7.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('539', '1533725244', '/upload/default/4cf8833dfbff209c85fe3c08285bd067.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('540', '1533725453', '/upload/default/63d6bfe8ae5906916d4b398dab1bc304.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('541', '1533725478', '/upload/default/538e88a932d349ef64c7f6f8f3b13493.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('542', '1533725532', '/upload/default/6c9b930f6e5ceca1d34b2de7ccf98356.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('543', '1533725595', '/upload/default/3029bbbc8007087e886f6ac19113250f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('544', '1533725619', '/upload/default/c9678f6b203f3b61ea0e55c01495a9c2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('545', '1533725643', '/upload/default/709272b6ddcb5dd09556f39f8a3aa8ac.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('546', '1533725664', '/upload/default/02de54a5e8ddc674e03ecc32ae35a0cf.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('547', '1533725667', '/upload/default/1335352da1ca61ac7a47bfc287a089cd.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('548', '1533725820', '/upload/default/e7640f28382a34bb37ae7dd6838c52d3.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('549', '1533726459', '/upload/default/34e5e6a13fe202b99b1bb9fff1590547.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('550', '1533726505', '/upload/default/f0d26455882ce913bd585c9b9cba1fb6.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('551', '1533726606', '/upload/default/6e4ea11e2f59307c803beb5f6af377da.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('552', '1533726650', '/upload/default/1e7ffc75424e4c9f60e15693e821f5e1.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('553', '1533726689', '/upload/default/bad5fe3dd1cef2a6d355080f5ce22a71.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('554', '1533726711', '/upload/default/7264139d1a7643285cae9ef307c58604.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('555', '1533726847', '/upload/default/e4c19f9531d3d31eed6015206f8b1d17.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('556', '1533727509', '/upload/default/a35aa1b35319f8ea9c300cf3cda231d9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('557', '1533727586', '/upload/default/0ca8487495bee33d3e1e36bb78da0c22.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('558', '1533727883', '/upload/default/004b69d682c4ec649af8006a2a239a1f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('559', '1533727888', '/upload/default/f12762d216fbe127e301e5d597dddddb.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('560', '1533727914', '/upload/default/88d017ce92f779e3b68cfa091b2ca2d8.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('561', '1533727918', '/upload/default/8dc00a763b185fdc5b607de5d50218ab.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('562', '1533727962', '/upload/default/093074a1b85f90e57a68f2fa8de61fb0.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('563', '1533728058', '/upload/default/fb9cabcf36e50bfb74b76d51df4a5118.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('564', '1533728079', '/upload/default/0a71f7209d13f96885d2ca6030c3e452.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('565', '1533728574', '/upload/default/d2806410eecc815cb303f8ea448fc9c4.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('566', '1533728592', '/upload/default/889ef80e1d63b2494ed11c126652c70a.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('567', '1533728649', '/upload/default/34eb0c82353c59c51ccee2736126ce49.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('568', '1533728822', '/upload/default/e4cf7ccd1d25e6284c318cd4493b4f31.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('569', '1533728827', '/upload/default/658d2d00c55e68de44e3260ea754cd23.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('570', '1533728902', '/upload/default/275ec701f0f80118ac7dc7d905793774.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('571', '1533728958', '/upload/default/fd886c48221a0a85fdb5e1d7c943ee83.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('572', '1533728962', '/upload/default/5f74f3a0931da8ea7b0e764ee0ca2e2f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('573', '1533730059', '/upload/default/c222ab70783c434658993d4fcc232984.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('574', '1533730116', '/upload/default/bd7bc4bae80c7a5c926b02f2c10d5a83.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('575', '1533730172', '/upload/default/32a7b7c7e0e83a247465bed9f9e47db1.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('576', '1533730205', '/upload/default/bfa0eafefb82edf5686595d32a4c8d31.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('577', '1533730404', '/upload/default/73789082bca296a5e687622a89cc836a.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('578', '1533730472', '/upload/default/0db284e2442122527d8ff23d5ee6db90.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('579', '1533730508', '/upload/default/5b3c550956bb226db27d406926a3539d.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('580', '1533730711', '/upload/default/6dac45fa896b68b0cde2727874f9f97b.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('581', '1533731615', '/upload/default/888037e85b3a7ecb798da8f787a6c34f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('582', '1533731630', '/upload/default/b466fbccfd9be88b6ad263c49a619123.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('583', '1533731638', '/upload/default/67b9b2384687af34566669a77a0913c6.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('584', '1533731807', '/upload/default/15956ac3d5f19ef4cef3f1cc0a5b2f42.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('585', '1533780337', '/upload/default/041eb7f37190c2e49690a32512f89b2d.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('586', '1533780552', '/upload/default/b3f78296732a0fae1e79f450092031ba.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('587', '1533781082', '/upload/default/0575bb362753d6c7e2884c05054e5abe.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('588', '1533781094', '/upload/default/c8d7f28c3804657df858af9b123fec57.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('589', '1533781100', '/upload/default/38a20e46d57a45b8625b946cd4a5ad5e.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('590', '1533781117', '/upload/default/6952cc5431967b4cbcfd7a37af1e36be.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('591', '1533781129', '/upload/default/2e4f10027089eb0dbf0ebb93f83fb0cf.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('592', '1533781136', '/upload/default/03e7cb4bcb731b47b9a80f51ff3053a5.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('593', '1533782400', '/upload/default/3ef925acf778a4bf85943a24bef7a699.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('594', '1533782482', '/upload/default/0371ab40014da72c3101d91e9fac332a.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('595', '1533783736', '/upload/default/c440aadddcb75448be981c3362c53352.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('596', '1533783739', '/upload/default/f04c342fa0c10271f4dab985a19a6a8b.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('597', '1533783760', '/upload/default/26967f1d909bebff1cb9b0372e066094.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('598', '1533783763', '/upload/default/7457ea989c7d9245cdc79022e85095be.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('599', '1533783767', '/upload/default/09f0477f9f16295bc188aab4a9102290.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('600', '1533783874', '/upload/default/3776de6fe854fdbcdacb36686c9d31b3.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('601', '1533783966', '/upload/default/7a01376ce5f651429cc308bd8c3bb071.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('602', '1533784074', '/upload/default/8a5da665e64a200ed5953a60304b92f6.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('603', '1533784076', '/upload/default/ec3c70f6de6103bdd070ed8e9962f5bb.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('604', '1533784081', '/upload/default/b810d28917962d23b77a7407a4ff9ed7.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('605', '1533784241', '/upload/default/48532f6398acccb2490a70d6df758ee3.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('606', '1533784253', '/upload/default/56b4287616e5bd99eb49ae78168dd080.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('607', '1533784261', '/upload/default/fa9e912e080fef677f2d0b47c015f3ba.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('608', '1533784287', '/upload/default/2f310878251bb8f54b0e09fa8f23f4bc.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('609', '1533784320', '/upload/default/3b97ea27b1ba2d1232ca5a2e3ae275bf.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('610', '1533784553', '/upload/default/ce8f0474abf351fdd975395bc473bc81.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('611', '1533785355', '/upload/default/4556154a8223636364164f8eaf9ba7cc.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('612', '1533785357', '/upload/default/c9af60b77b489fed04bdc99fcc6564c2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('613', '1533785367', '/upload/default/5d1acee8607176537604c1a09f3869eb.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('614', '1533785370', '/upload/default/bdeaf43978fcbf41b066f6393c2f8f06.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('615', '1533785377', '/upload/default/e2a55d5f2ade2dd2e19f7858df470d6b.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('616', '1533785417', '/upload/default/2c1c7dddd66211daa0b65585f367b45a.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('617', '1533785420', '/upload/default/4f71b8387fd9214c5cc764c465eb6103.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('618', '1533785466', '/upload/default/e741ef9e597109d1dc5bc5345887855a.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('619', '1533785473', '/upload/default/2724ecf1c78bb7596ac5252ba06f059e.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('620', '1533786281', '/upload/default/2532ef143f4eb28935794459e4c7db15.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('621', '1533786285', '/upload/default/7490cbe12df6ef53769b8ff192ff82ed.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('622', '1533788233', '/upload/default/e52a5319346f6f5ecb48735119c478b9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('623', '1533788235', '/upload/default/fc6b77425cf8a72fcee1e10706a3dd81.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('624', '1533788240', '/upload/default/17916055d38c64ae09d9a5748e4058ce.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('625', '1533795438', '/upload/default/6edaef768e30e4451725438b45ea42f9.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('626', '1533796979', '/upload/default/01924c912ecdf447313c4e1f822b8593.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('627', '1533796981', '/upload/default/0275b6ce119bee2bfc8e49b6def9386e.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('628', '1533798121', '/upload/default/3b12a81393c1bae44c4b9175154c346f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('629', '1533798130', '/upload/default/5b4f967862668accedf4671b44144ec2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('630', '1533798252', '/upload/default/524c290869df445406db6b9f216f574f.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('631', '1533798254', '/upload/default/5ac66213dff98d05cce16d595e7d42e6.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('632', '1533798255', '/upload/default/add5557cd8bf49e5dcaf1641c835c218.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('633', '1533798265', '/upload/default/8afb3d88ae704030b48172c94d465ae2.png', null, null, null, null, null);
INSERT INTO `tp_upload_file` VALUES ('634', '1533798267', '/upload/default/f8f2d64522372f0f47da97a9e3f8f5e4.png', null, null, null, null, null);

-- ----------------------------
-- Table structure for `tp_user`
-- ----------------------------
DROP TABLE IF EXISTS `tp_user`;
CREATE TABLE `tp_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(255) DEFAULT NULL COMMENT '昵称',
  `point_value` int(11) DEFAULT NULL COMMENT '会员积分',
  `signature` varchar(255) DEFAULT NULL COMMENT '个性签名',
  `head_img_id` int(11) DEFAULT NULL COMMENT '头像',
  `sex` enum('女','男') DEFAULT NULL COMMENT '性别',
  `hometown` varchar(255) DEFAULT NULL COMMENT '家乡',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机',
  `verification_code` varchar(255) DEFAULT NULL COMMENT '验证码',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_user
-- ----------------------------

-- ----------------------------
-- Table structure for `tp_web_log_001`
-- ----------------------------
DROP TABLE IF EXISTS `tp_web_log_001`;
CREATE TABLE `tp_web_log_001` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `uid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `ip` char(15) NOT NULL DEFAULT '' COMMENT '访客ip',
  `location` varchar(255) NOT NULL DEFAULT '' COMMENT '访客地址',
  `os` varchar(255) NOT NULL DEFAULT '' COMMENT '操作系统',
  `browser` varchar(255) NOT NULL DEFAULT '' COMMENT '浏览器',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'url',
  `module` varchar(255) NOT NULL DEFAULT '' COMMENT '模块',
  `controller` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器',
  `action` varchar(255) NOT NULL DEFAULT '' COMMENT '方法',
  `method` char(6) NOT NULL DEFAULT '' COMMENT '请求方式',
  `data` text COMMENT '请求的param数据，serialize后的',
  `create_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `ip` (`ip`),
  KEY `create_at` (`create_at`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='网站日志';

-- ----------------------------
-- Records of tp_web_log_001
-- ----------------------------

-- ----------------------------
-- Table structure for `tp_web_log_all`
-- ----------------------------
DROP TABLE IF EXISTS `tp_web_log_all`;
CREATE TABLE `tp_web_log_all` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `uid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `ip` char(15) NOT NULL DEFAULT '' COMMENT '访客ip',
  `location` varchar(255) NOT NULL DEFAULT '' COMMENT '访客地址',
  `os` varchar(255) NOT NULL DEFAULT '' COMMENT '操作系统',
  `browser` varchar(255) NOT NULL DEFAULT '' COMMENT '浏览器',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'url',
  `module` varchar(255) NOT NULL DEFAULT '' COMMENT '模块',
  `controller` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器',
  `action` varchar(255) NOT NULL DEFAULT '' COMMENT '方法',
  `method` char(6) NOT NULL DEFAULT '' COMMENT '请求方式',
  `data` text COMMENT '请求的param数据，serialize后的',
  `create_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`) USING BTREE,
  KEY `ip` (`ip`) USING BTREE,
  KEY `create_at` (`create_at`) USING BTREE
) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC INSERT_METHOD=LAST UNION=(`tp_web_log_001`) COMMENT='网站日志';

-- ----------------------------
-- Records of tp_web_log_all
-- ----------------------------