/*
Navicat MySQL Data Transfer

Source Server         : milibangong.cn
Source Server Version : 50557
Source Host           : 103.74.193.69:3306
Source Database       : qmjz

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

Date: 2019-01-05 13:41:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for a_bank
-- ----------------------------
DROP TABLE IF EXISTS `a_bank`;
CREATE TABLE `a_bank` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '银行表',
  `bank` char(30) NOT NULL COMMENT '银行',
  `num` int(5) NOT NULL COMMENT '银行编号',
  `desc` varchar(20) DEFAULT NULL COMMENT '代码',
  `bg_img` varchar(255) DEFAULT NULL COMMENT '银行卡背景图',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of a_bank
-- ----------------------------
INSERT INTO `a_bank` VALUES ('1', '中国工商银行', '1001', 'ICBC', null);
INSERT INTO `a_bank` VALUES ('2', '中国农业银行', '1002', 'ABC', null);
INSERT INTO `a_bank` VALUES ('3', '中国银行', '1003', 'BOC', '');
INSERT INTO `a_bank` VALUES ('4', '中国建设银行', '1004', 'CCB', null);
INSERT INTO `a_bank` VALUES ('5', '交通银行', '1005', 'BOCOM', null);
INSERT INTO `a_bank` VALUES ('6', '中国民生银行', '1006', 'CMBC', null);

-- ----------------------------
-- Table structure for a_config
-- ----------------------------
DROP TABLE IF EXISTS `a_config`;
CREATE TABLE `a_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置表',
  `ci` int(11) unsigned NOT NULL COMMENT '每天领取任务次数',
  `price` decimal(10,2) NOT NULL COMMENT '一条任务价格',
  `s1` decimal(10,2) NOT NULL COMMENT '一条任务上层用户获得钱',
  `s2` decimal(10,2) NOT NULL COMMENT '上上层用户获得钱',
  `t1` decimal(10,2) NOT NULL COMMENT '被推荐，上层用户获得钱',
  `t2` decimal(10,2) NOT NULL COMMENT '上上层用户获得的钱',
  `level` tinyint(2) NOT NULL COMMENT '用户等级',
  `l1` tinyint(2) DEFAULT NULL COMMENT '上家等级',
  `l2` tinyint(2) DEFAULT NULL COMMENT '上上家等级',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of a_config
-- ----------------------------
INSERT INTO `a_config` VALUES ('1', '2', '4.00', '2.00', '1.00', '8.00', '8.00', '1', '1', '1');
INSERT INTO `a_config` VALUES ('2', '2', '4.00', '2.00', '1.00', '8.00', '8.00', '1', '2', '1');
INSERT INTO `a_config` VALUES ('3', '2', '4.00', '2.00', '1.00', '8.00', '8.00', '1', '2', '2');
INSERT INTO `a_config` VALUES ('4', '2', '20.00', '2.00', '1.00', '8.00', '8.00', '2', '1', '1');
INSERT INTO `a_config` VALUES ('5', '2', '20.00', '10.00', '5.00', '80.00', '80.00', '2', '2', '2');
INSERT INTO `a_config` VALUES ('6', '2', '4.00', '2.00', '1.00', '8.00', '8.00', '1', '1', '2');
INSERT INTO `a_config` VALUES ('7', '2', '20.00', '2.00', '5.00', '8.00', '80.00', '2', '1', '2');
INSERT INTO `a_config` VALUES ('8', '2', '20.00', '10.00', '5.00', '80.00', '8.00', '2', '2', '1');

-- ----------------------------
-- Table structure for a_fenxiao_config
-- ----------------------------
DROP TABLE IF EXISTS `a_fenxiao_config`;
CREATE TABLE `a_fenxiao_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` tinyint(4) DEFAULT NULL COMMENT '会员等级',
  `title` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `price` decimal(10,2) DEFAULT '0.00' COMMENT '支付金额',
  `one_1` decimal(10,2) DEFAULT NULL COMMENT '上1级 的会员1级 佣金',
  `one_2` decimal(10,2) DEFAULT NULL COMMENT '上1级 的会员2级 佣金',
  `two_1` decimal(10,2) DEFAULT NULL COMMENT '上2级 的会员1级 佣金',
  `two_2` decimal(10,2) DEFAULT NULL COMMENT '上2级 的会员2级 佣金',
  `ci` int(11) DEFAULT '0' COMMENT '每天领取任务次数',
  `image` varchar(255) DEFAULT NULL COMMENT '封面图',
  `logo` varchar(255) DEFAULT NULL COMMENT 'logo',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of a_fenxiao_config
-- ----------------------------
INSERT INTO `a_fenxiao_config` VALUES ('1', '1', '99Vip', '99.00', '8.00', '4.00', '8.00', '4.00', '2', '/images/vip_image.png', null);
INSERT INTO `a_fenxiao_config` VALUES ('2', '2', '999Vip', '999.00', '8.00', '4.00', '80.00', '20.00', '2', '/images/vip_image.png', null);

-- ----------------------------
-- Table structure for a_notice
-- ----------------------------
DROP TABLE IF EXISTS `a_notice`;
CREATE TABLE `a_notice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '公告表',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `time` int(11) NOT NULL COMMENT '时间',
  `article` text NOT NULL COMMENT '文字内容',
  `content` text,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示',
  `cat` int(11) DEFAULT '0' COMMENT 'cat：1公告',
  `vari` varchar(255) DEFAULT NULL COMMENT '变量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of a_notice
-- ----------------------------
INSERT INTO `a_notice` VALUES ('9', '微客天下欢迎大家入驻平台', '1544229305', '各位用户须知：您现在注册之后是游客身份，如需领取任务赚佣金，需要升级为会员或者高级会员才能赚取佣金。', '各位用户须知：您现在注册之后是游客身份，如需领取任务赚佣金，需要升级为会员或者高级会员才能赚取佣金。', '0', '0', 'wei');
INSERT INTO `a_notice` VALUES ('11', '如何赚佣', '0', '', '/api/images/02.jpg', '0', '0', 'zy');

-- ----------------------------
-- Table structure for a_system_config
-- ----------------------------
DROP TABLE IF EXISTS `a_system_config`;
CREATE TABLE `a_system_config` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL,
  `group` varchar(15) NOT NULL DEFAULT '' COMMENT '组类',
  `vari` varchar(32) NOT NULL COMMENT '变量',
  `status` tinyint(4) DEFAULT '1' COMMENT '1开启0关闭',
  `give_day` int(11) DEFAULT '0' COMMENT '注册赠送天数，单位（天）',
  `give_level` tinyint(4) DEFAULT '1' COMMENT '赠送会员等级1vip 2 高级会员（999会员）',
  PRIMARY KEY (`id`),
  UNIQUE KEY `vari` (`vari`),
  KEY `keyword` (`group`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置表';

-- ----------------------------
-- Records of a_system_config
-- ----------------------------
INSERT INTO `a_system_config` VALUES ('1', '注册送VIP', 'site', 'reg', '1', '7', '1');

-- ----------------------------
-- Table structure for a_sz
-- ----------------------------
DROP TABLE IF EXISTS `a_sz`;
CREATE TABLE `a_sz` (
  `jin` decimal(10,2) NOT NULL COMMENT '提现金额打底',
  `sxf` int(11) NOT NULL COMMENT '手续费/100',
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of a_sz
-- ----------------------------
INSERT INTO `a_sz` VALUES ('100.00', '5', '1');

-- ----------------------------
-- Table structure for a_user
-- ----------------------------
DROP TABLE IF EXISTS `a_user`;
CREATE TABLE `a_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台用户表',
  `username` varchar(20) NOT NULL COMMENT '登录账号',
  `password` varchar(20) NOT NULL COMMENT '登录密码',
  `level` tinyint(2) unsigned NOT NULL COMMENT '等级',
  `log_ip` varchar(20) DEFAULT NULL COMMENT '登录ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of a_user
-- ----------------------------
INSERT INTO `a_user` VALUES ('1', 'admin', 'qq123456', '0', '42.55.202.33');

-- ----------------------------
-- Table structure for u_ad
-- ----------------------------
DROP TABLE IF EXISTS `u_ad`;
CREATE TABLE `u_ad` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告表',
  `title` varchar(30) NOT NULL COMMENT '广告标题',
  `ad` text NOT NULL COMMENT '广告内容',
  `time` int(11) NOT NULL COMMENT '时间',
  `num` int(11) unsigned NOT NULL COMMENT '数量',
  `price` decimal(10,2) unsigned NOT NULL COMMENT '一条的价格',
  `zj` decimal(10,2) unsigned NOT NULL COMMENT '数量乘单价',
  `wc` int(11) unsigned NOT NULL COMMENT '已接单的用户数量',
  `level` tinyint(2) NOT NULL COMMENT '广告等级0，游客，1，会员，2，高级会员',
  `uname` varchar(20) NOT NULL COMMENT '发布人',
  `uid` int(11) unsigned NOT NULL COMMENT '发布人id',
  `img` varchar(255) DEFAULT NULL COMMENT '任务图片',
  `img2` varchar(255) DEFAULT NULL,
  `pics_json` text COMMENT '多张图片json数组',
  `if_url` tinyint(1) DEFAULT '0' COMMENT '是否是链接：1是2不是。链接需要拼接标题+用户id',
  `use_time` int(11) DEFAULT '0' COMMENT '有效期（天）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of u_ad
-- ----------------------------
INSERT INTO `u_ad` VALUES ('27', '全民兼职', '20181202\r\n微客天下诚招app推广员50000名，名额有限，简单分享朋友圈，轻松赚取佣金，各大朋友圈奔走相告，赶快扫下方二维码报名吧', '1544405097', '10000', '4.00', '40000.00', '6', '1', '微客天下', '0', '/upload/20181210/6098b1d431aa958ff0dd95560e5c6d63.jpg', '/upload/20181210/e6361068f20f6b7e88823b370299f1e0.jpg', null, '0', '0');
INSERT INTO `u_ad` VALUES ('28', '全民兼职', '20181202\r\n微客天下诚招app推广员50000名，名额有限，简单分享朋友圈，轻松赚取佣金，各大朋友圈奔走相告，赶快扫下方二维码报名吧', '1544405144', '10000', '20.00', '200000.00', '2', '2', '微客天下', '0', '/upload/20181210/3ad481b41326f8d576ffb0508f76d1f3.jpg', '/upload/20181210/ec72b6249624864c90232a4b771ba3d2.jpg', null, '0', '0');
INSERT INTO `u_ad` VALUES ('29', '全民兼职诚招app推广员', '微客天下诚招app推广员50000名，名额有限，简单分享朋友圈，轻松赚取佣金，各大朋友圈奔走相告，赶快扫下方二维码报名吧', '1544416393', '1000', '4.00', '4000.00', '4', '1', '微客天下', '0', '/upload/20181210/533c155a8f47abd482a1c94c8f1b737a.jpg', '/upload/20181210/f731f6ace654061db3c8620fb742eb8a.jpg', null, '0', '0');
INSERT INTO `u_ad` VALUES ('30', '全民兼职诚招app推广员', '微客天下诚招app推广员50000名，名额有限，简单分享朋友圈，轻松赚取佣金，各大朋友圈奔走相告，赶快扫下方二维码报名吧', '1544416429', '1000', '20.00', '20000.00', '2', '2', '微客天下诚招app推广员', '0', '/upload/20181210/f5113ce31221195c0ef3a96608c31428.jpg', '/upload/20181210/63504c21b713bda7ce41f275f87f3f5c.jpg', null, '0', '0');
INSERT INTO `u_ad` VALUES ('31', '测试', '4456', '1544579561', '100', '4.00', '400.00', '100', '1', '111', '0', '/uploads/20181212/91cddc3ad080a97a0d250d0da0cf70b4.png', '/uploads/20181212/0700349fccd2ab0848d933b0fac5e3a2.png', null, '0', '0');
INSERT INTO `u_ad` VALUES ('32', '任务天下全民兼职', 'https://s.taobao.com/search?spm=a230r.1.0.0.5f242899nzW8e7&q=%E9%94%AE%E7%9B%98&spu_title=%E6%83%A0%E6%99%AE+GK100&app=detailproduct&pspuid=1437931&cat=110210&from_pos=20_110210.default_0_1_1437931&spu_style=grid', '1545022425', '100', '2.00', '200.00', '1', '0', '12', '111', null, null, '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]', '1', '0');
INSERT INTO `u_ad` VALUES ('33', '123', '456', '1545022901', '100', '2.00', '200.00', '1', '0', '12', '111', null, null, '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]', '0', '0');
INSERT INTO `u_ad` VALUES ('34', '123', '456', '1545022902', '100', '2.00', '200.00', '1', '0', '12', '111', null, null, '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]', '0', '0');
INSERT INTO `u_ad` VALUES ('35', '123', '456', '1545022931', '100', '2.00', '200.00', '1', '0', '12', '111', null, null, '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]', '0', '0');
INSERT INTO `u_ad` VALUES ('36', '123', '456', '1545023000', '100', '2.00', '200.00', '10', '0', '12', '111', null, null, '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]', '0', '0');

-- ----------------------------
-- Table structure for u_article
-- ----------------------------
DROP TABLE IF EXISTS `u_article`;
CREATE TABLE `u_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '文章标题',
  `image` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL COMMENT '文章描述',
  `content` text COMMENT '内容',
  `sort` int(11) DEFAULT '50' COMMENT '排序',
  `cat_id` int(11) DEFAULT '0',
  `vari` varchar(255) DEFAULT NULL,
  `add_time` int(11) DEFAULT '0' COMMENT '发布时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='文章表';

-- ----------------------------
-- Records of u_article
-- ----------------------------
INSERT INTO `u_article` VALUES ('1', '快手兼职', '/api/images/01.jpg', '快手描述', '快手内容', '50', '1', null, '1544164909');
INSERT INTO `u_article` VALUES ('2', '快手兼职2', '/api/images/01.jpg', '快手描述2', '快手内容2', '50', '1', null, '1544165909');
INSERT INTO `u_article` VALUES ('3', '安卓下载地址', null, null, 'http://www.hiapk.com/', '50', '2', 'android', '0');
INSERT INTO `u_article` VALUES ('4', '苹果下载地址', null, null, 'https://www.apple.com/cn/', '50', '2', 'ios', '0');

-- ----------------------------
-- Table structure for u_banner
-- ----------------------------
DROP TABLE IF EXISTS `u_banner`;
CREATE TABLE `u_banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(80) NOT NULL COMMENT '标题',
  `image` varchar(255) NOT NULL COMMENT '图片路径',
  `link` varchar(80) DEFAULT NULL COMMENT '跳转地址',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1启用2禁用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='首页幻灯片表';

-- ----------------------------
-- Records of u_banner
-- ----------------------------
INSERT INTO `u_banner` VALUES ('1', 'banner1', '/api/images/01.jpg', null, '0', '1');
INSERT INTO `u_banner` VALUES ('2', 'banner2', '/api/images/02.jpg', null, '0', '1');

-- ----------------------------
-- Table structure for u_cz
-- ----------------------------
DROP TABLE IF EXISTS `u_cz`;
CREATE TABLE `u_cz` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '充值记录表',
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `price` decimal(10,2) NOT NULL COMMENT '充值金额',
  `time` int(11) NOT NULL COMMENT '时间',
  `cz_order` char(50) NOT NULL COMMENT '订单号',
  `cz_is_play` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '默认为0  0是钱未支付  1是已支付',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of u_cz
-- ----------------------------
INSERT INTO `u_cz` VALUES ('2', '42', '99.00', '1544247490', '31f19f43', '0');
INSERT INTO `u_cz` VALUES ('3', '42', '99.00', '1544247491', '31f19f43', '0');
INSERT INTO `u_cz` VALUES ('4', '42', '99.00', '1544247494', '31f19f43', '0');
INSERT INTO `u_cz` VALUES ('5', '42', '99.00', '1544247515', '9a467748', '0');
INSERT INTO `u_cz` VALUES ('6', '42', '99.00', '1544256437', '7e7af1f6', '0');
INSERT INTO `u_cz` VALUES ('7', '42', '99.00', '1544259389', 'cf008476', '0');
INSERT INTO `u_cz` VALUES ('8', '42', '99.00', '1544279154', '56e4d3a8', '0');
INSERT INTO `u_cz` VALUES ('9', '42', '99.00', '1544279159', '56e4d3a8', '0');
INSERT INTO `u_cz` VALUES ('10', '42', '999.00', '1544279189', 'd06094ea', '0');
INSERT INTO `u_cz` VALUES ('11', '42', '999.00', '1544279208', 'd06094ea', '0');
INSERT INTO `u_cz` VALUES ('12', '92', '99.00', '1544323337', '28259f3b', '0');
INSERT INTO `u_cz` VALUES ('13', '92', '99.00', '1544323360', '23795cdb', '0');
INSERT INTO `u_cz` VALUES ('14', '92', '99.00', '1544323434', 'ecb99c32', '0');
INSERT INTO `u_cz` VALUES ('15', '92', '99.00', '1544323465', 'ecb99c32', '0');
INSERT INTO `u_cz` VALUES ('16', '92', '99.00', '1544323511', 'f4decfa8', '0');
INSERT INTO `u_cz` VALUES ('17', '92', '99.00', '1544323824', '7dbe6464', '0');
INSERT INTO `u_cz` VALUES ('18', '92', '99.00', '1544324048', '5f94aeac', '0');
INSERT INTO `u_cz` VALUES ('19', '92', '99.00', '1544324093', '8cf990df', '0');
INSERT INTO `u_cz` VALUES ('20', '92', '99.00', '1544324210', 'c73f27c0', '0');
INSERT INTO `u_cz` VALUES ('21', '42', '99.00', '1544408606', '31a3e4b5', '0');
INSERT INTO `u_cz` VALUES ('22', '100', '99.00', '1544409794', 'aa10ccf1', '0');
INSERT INTO `u_cz` VALUES ('23', '100', '99.00', '1544409819', '946c234e', '0');
INSERT INTO `u_cz` VALUES ('24', '100', '99.00', '1544409865', '3e6bced4', '0');
INSERT INTO `u_cz` VALUES ('25', '100', '99.00', '1544418774', 'ce3ffea3', '0');
INSERT INTO `u_cz` VALUES ('26', '111', '999.00', '1545791405', '6098495f', '0');

-- ----------------------------
-- Table structure for u_file
-- ----------------------------
DROP TABLE IF EXISTS `u_file`;
CREATE TABLE `u_file` (
  `file_id` int(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(250) DEFAULT NULL,
  `original` varchar(250) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `ext` varchar(250) DEFAULT NULL,
  `size` int(10) DEFAULT NULL,
  `time` int(10) DEFAULT NULL,
  PRIMARY KEY (`file_id`),
  KEY `ext` (`ext`),
  KEY `time` (`time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COMMENT='上传文件';

-- ----------------------------
-- Records of u_file
-- ----------------------------
INSERT INTO `u_file` VALUES ('1', '/uploads/home/20181217/4f0bbea5d784bafaafa87f88705041fe.jpg', '/uploads/home/20181217/4f0bbea5d784bafaafa87f88705041fe.jpg', null, 'jpg', '20441', '1545015937');
INSERT INTO `u_file` VALUES ('2', '/uploads/home/20181217/772a7f0154cf271e7dbda09b3a4d650a.jpg', '/uploads/home/20181217/772a7f0154cf271e7dbda09b3a4d650a.jpg', null, 'jpg', '20441', '1545015958');
INSERT INTO `u_file` VALUES ('3', '/uploads/home/20181217/a033a1128f527f881b85643c75671907.jpg', '/uploads/home/20181217/a033a1128f527f881b85643c75671907.jpg', null, 'jpg', '20441', '1545015994');
INSERT INTO `u_file` VALUES ('4', '/uploads/home/20181217/90618231b349322b9afcea38437cd0c2.jpg', '/uploads/home/20181217/90618231b349322b9afcea38437cd0c2.jpg', null, 'jpg', '20441', '1545016006');
INSERT INTO `u_file` VALUES ('5', '/uploads/home/20181217/2d0866ec298b9a9a890890711bebf6a1.jpg', '/uploads/home/20181217/2d0866ec298b9a9a890890711bebf6a1.jpg', null, 'jpg', '20441', '1545016065');
INSERT INTO `u_file` VALUES ('6', '/uploads/home/20181217/8c862b81a302eafd90c8d5ecd5ed5d38.jpg', '/uploads/home/20181217/8c862b81a302eafd90c8d5ecd5ed5d38.jpg', null, 'jpg', '20441', '1545016141');
INSERT INTO `u_file` VALUES ('7', '/uploads/home/20181217/622df1b1e1d69d1148c27aba0e90b1db.jpg', '/uploads/home/20181217/622df1b1e1d69d1148c27aba0e90b1db.jpg', null, 'jpg', '20441', '1545018696');
INSERT INTO `u_file` VALUES ('8', '/uploads/home/20190101/1d79a0d385e5e24b7c127a9464adb14f.png', '/uploads/home/20190101/1d79a0d385e5e24b7c127a9464adb14f.png', null, 'png', '307686', '1546314336');
INSERT INTO `u_file` VALUES ('9', '/uploads/home/20190101/ace51d0749823086f9e14c83444025c5.png', '/uploads/home/20190101/ace51d0749823086f9e14c83444025c5.png', null, 'png', '998364', '1546314397');
INSERT INTO `u_file` VALUES ('10', '/uploads/home/20190101/d9cbc96b7107434bd8c0bf0e7491698b.png', '/uploads/home/20190101/d9cbc96b7107434bd8c0bf0e7491698b.png', null, 'png', '101964', '1546343138');
INSERT INTO `u_file` VALUES ('11', '/uploads/home/20190102/3e33937beec9aa9b5dbf15224da9d59c.png', '/uploads/home/20190102/3e33937beec9aa9b5dbf15224da9d59c.png', null, 'png', '101964', '1546388166');
INSERT INTO `u_file` VALUES ('12', '/uploads/home/20190102/6796dff73e3452f74adeaa22efe953cb.png', '/uploads/home/20190102/6796dff73e3452f74adeaa22efe953cb.png', null, 'png', '101964', '1546391371');
INSERT INTO `u_file` VALUES ('13', '/uploads/home/20190102/e668839d1f54689dc1b6561c49ed51e4.png', '/uploads/home/20190102/e668839d1f54689dc1b6561c49ed51e4.png', null, 'png', '101964', '1546391382');
INSERT INTO `u_file` VALUES ('14', '/uploads/home/20190102/c0bf9c639476eb034bdd1a3c681510fd.png', '/uploads/home/20190102/c0bf9c639476eb034bdd1a3c681510fd.png', null, 'png', '101964', '1546391389');
INSERT INTO `u_file` VALUES ('15', '/uploads/home/20190102/49e6df0e8f5283c5cbb3a0894d6a8827.png', '/uploads/home/20190102/49e6df0e8f5283c5cbb3a0894d6a8827.png', null, 'png', '62720', '1546391398');
INSERT INTO `u_file` VALUES ('16', '/uploads/home/20190102/b56afbd19ecc5047cded42b0a5749aaa.png', '/uploads/home/20190102/b56afbd19ecc5047cded42b0a5749aaa.png', null, 'png', '95016', '1546391489');
INSERT INTO `u_file` VALUES ('17', '/uploads/home/20190102/e963314a967134cd349607f72b123193.png', '/uploads/home/20190102/e963314a967134cd349607f72b123193.png', null, 'png', '101964', '1546391588');
INSERT INTO `u_file` VALUES ('18', '/uploads/home/20190102/efb702a2d43a2a4b4bf905efb2cdd055.png', '/uploads/home/20190102/efb702a2d43a2a4b4bf905efb2cdd055.png', null, 'png', '101964', '1546391700');
INSERT INTO `u_file` VALUES ('19', '/uploads/home/20190102/60cf66aca3a601910f9f83d931caec4e.png', '/uploads/home/20190102/60cf66aca3a601910f9f83d931caec4e.png', null, 'png', '101964', '1546419145');
INSERT INTO `u_file` VALUES ('20', '/uploads/home/20190102/19a13e66760e1cabfe1a158eff1b908e.png', '/uploads/home/20190102/19a13e66760e1cabfe1a158eff1b908e.png', null, 'png', '95016', '1546419153');
INSERT INTO `u_file` VALUES ('21', '/uploads/home/20190102/7c8cf7b13f24aafd89c05255d1d88004.png', '/uploads/home/20190102/7c8cf7b13f24aafd89c05255d1d88004.png', null, 'png', '101964', '1546419270');
INSERT INTO `u_file` VALUES ('22', '/uploads/home/20190102/9973ae1f9476751eaf6c9c958536afbf.png', '/uploads/home/20190102/9973ae1f9476751eaf6c9c958536afbf.png', null, 'png', '95016', '1546419282');
INSERT INTO `u_file` VALUES ('23', '/uploads/home/20190102/d7c777de54feb3496eb516ac9d505b2f.png', '/uploads/home/20190102/d7c777de54feb3496eb516ac9d505b2f.png', null, 'png', '1689779', '1546437874');
INSERT INTO `u_file` VALUES ('24', '/uploads/home/20190103/bedeb12c30ed96da39ad2661c132a02b.jpg', '/uploads/home/20190103/bedeb12c30ed96da39ad2661c132a02b.jpg', null, 'jpg', '236619', '1546518923');
INSERT INTO `u_file` VALUES ('25', '/uploads/home/20190103/53f9dfe6ab562f60b98e21dd1d84f167.jpg', '/uploads/home/20190103/53f9dfe6ab562f60b98e21dd1d84f167.jpg', null, 'jpg', '236619', '1546519080');
INSERT INTO `u_file` VALUES ('26', '/uploads/home/20190103/37b669febe2728aa6f98ab879444d4c9.jpg', '/uploads/home/20190103/37b669febe2728aa6f98ab879444d4c9.jpg', null, 'jpg', '236619', '1546519111');
INSERT INTO `u_file` VALUES ('27', '/uploads/home/20190103/21242850aa9b46bad6632ed9e930b909.jpg', '/uploads/home/20190103/21242850aa9b46bad6632ed9e930b909.jpg', null, 'jpg', '236619', '1546519122');
INSERT INTO `u_file` VALUES ('28', '/uploads/home/20190103/7ac6bbc8f9ffeb5ee197bf4e1960b5d9.jpg', '/uploads/home/20190103/7ac6bbc8f9ffeb5ee197bf4e1960b5d9.jpg', null, 'jpg', '236619', '1546519122');
INSERT INTO `u_file` VALUES ('29', '/uploads/home/20190103/580a91dff25888f84ee4e6a9af59bc66.jpg', '/uploads/home/20190103/580a91dff25888f84ee4e6a9af59bc66.jpg', null, 'jpg', '236619', '1546519149');
INSERT INTO `u_file` VALUES ('30', '/uploads/home/20190104/53810b5b0ca02cc8d007f06e2b6fe738.png', '/uploads/home/20190104/53810b5b0ca02cc8d007f06e2b6fe738.png', null, 'png', '101964', '1546563635');
INSERT INTO `u_file` VALUES ('31', '/uploads/home/20190104/c148f7254b610152d7e10c6090573706.png', '/uploads/home/20190104/c148f7254b610152d7e10c6090573706.png', null, 'png', '101964', '1546563659');
INSERT INTO `u_file` VALUES ('32', '/uploads/home/20190104/a6cc08a773f6e03f6b974258915e08b9.png', '/uploads/home/20190104/a6cc08a773f6e03f6b974258915e08b9.png', null, 'png', '62715', '1546563666');
INSERT INTO `u_file` VALUES ('33', '/uploads/home/20190104/21fd44298499ae99b2e5135b774fcc17.png', '/uploads/home/20190104/21fd44298499ae99b2e5135b774fcc17.png', null, 'png', '58689', '1546563673');
INSERT INTO `u_file` VALUES ('34', '/uploads/home/20190104/71148dbf65cf9f146fa2929443f429c4.png', '/uploads/home/20190104/71148dbf65cf9f146fa2929443f429c4.png', null, 'png', '62715', '1546563804');
INSERT INTO `u_file` VALUES ('35', '/uploads/home/20190104/ec55f76234c3bcb5c41f9802014ab220.png', '/uploads/home/20190104/ec55f76234c3bcb5c41f9802014ab220.png', null, 'png', '101964', '1546563846');
INSERT INTO `u_file` VALUES ('36', '/uploads/home/20190104/0897d79f387661556d01219b0b159714.png', '/uploads/home/20190104/0897d79f387661556d01219b0b159714.png', null, 'png', '95016', '1546563971');
INSERT INTO `u_file` VALUES ('37', '/uploads/home/20190104/a3e0fadf50dfff557b08eea5155474f7.png', '/uploads/home/20190104/a3e0fadf50dfff557b08eea5155474f7.png', null, 'png', '101964', '1546564145');
INSERT INTO `u_file` VALUES ('38', '/uploads/home/20190104/6a268c8d0edbd8fa00ce5d0f5b9c55e7.png', '/uploads/home/20190104/6a268c8d0edbd8fa00ce5d0f5b9c55e7.png', null, 'png', '95016', '1546564156');
INSERT INTO `u_file` VALUES ('39', '/uploads/home/20190104/73d9908755295d20ccdcdadf9dc4ea5a.jpg', '/uploads/home/20190104/73d9908755295d20ccdcdadf9dc4ea5a.jpg', null, 'jpg', '22485', '1546564684');
INSERT INTO `u_file` VALUES ('40', '/uploads/home/20190104/8b5d1e81c58b7ead31a068241e8dab6b.png', '/uploads/home/20190104/8b5d1e81c58b7ead31a068241e8dab6b.png', null, 'png', '95016', '1546565637');
INSERT INTO `u_file` VALUES ('41', '/uploads/home/20190104/746391b06f638780e42b2163153267af.png', '/uploads/home/20190104/746391b06f638780e42b2163153267af.png', null, 'png', '144954', '1546565648');
INSERT INTO `u_file` VALUES ('42', '/uploads/home/20190104/10e2364c046c3b82b0ebf158992e7a2f.png', '/uploads/home/20190104/10e2364c046c3b82b0ebf158992e7a2f.png', null, 'png', '290551', '1546606466');
INSERT INTO `u_file` VALUES ('43', '/uploads/home/20190104/0b155c349e2d108c5c468764e6b14778.jpg', '/uploads/home/20190104/0b155c349e2d108c5c468764e6b14778.jpg', null, 'jpg', '85545', '1546606548');
INSERT INTO `u_file` VALUES ('44', '/uploads/home/20190104/c54d7dd6c9ff425841b9254e4207fc3e.png', '/uploads/home/20190104/c54d7dd6c9ff425841b9254e4207fc3e.png', null, 'png', '34261', '1546606554');
INSERT INTO `u_file` VALUES ('45', '/uploads/home/20190104/46adebb1d3e322d8bde8a65a2c3f24e9.png', '/uploads/home/20190104/46adebb1d3e322d8bde8a65a2c3f24e9.png', null, 'png', '34261', '1546606689');
INSERT INTO `u_file` VALUES ('46', '/uploads/home/20190104/07aa77bb9fe3b0816c48953fe3afe1f1.png', '/uploads/home/20190104/07aa77bb9fe3b0816c48953fe3afe1f1.png', null, 'png', '290551', '1546606873');
INSERT INTO `u_file` VALUES ('47', '/uploads/home/20190104/8868063a1cee1246ca177622d2dd0f88.jpg', '/uploads/home/20190104/8868063a1cee1246ca177622d2dd0f88.jpg', null, 'jpg', '85545', '1546606912');
INSERT INTO `u_file` VALUES ('48', '/uploads/home/20190104/6e545be0d00af6cd138a87a50537c856.png', '/uploads/home/20190104/6e545be0d00af6cd138a87a50537c856.png', null, 'png', '34261', '1546606917');
INSERT INTO `u_file` VALUES ('49', '/uploads/home/20190104/0143e679d980a8c97ca4ff1662fcd224.png', '/uploads/home/20190104/0143e679d980a8c97ca4ff1662fcd224.png', null, 'png', '290551', '1546610392');
INSERT INTO `u_file` VALUES ('50', '/uploads/home/20190104/57cc55b181b08c66be26162110608b95.jpg', '/uploads/home/20190104/57cc55b181b08c66be26162110608b95.jpg', null, 'jpg', '162318', '1546610479');
INSERT INTO `u_file` VALUES ('51', '/uploads/home/20190104/245952d0a06b2d7e8b7548caad5b2579.png', '/uploads/home/20190104/245952d0a06b2d7e8b7548caad5b2579.png', null, 'png', '290551', '1546610561');
INSERT INTO `u_file` VALUES ('52', '/uploads/home/20190104/adf4ec1fb7e1bfabca4fbb8a5371a7ca.jpg', '/uploads/home/20190104/adf4ec1fb7e1bfabca4fbb8a5371a7ca.jpg', null, 'jpg', '162318', '1546616447');
INSERT INTO `u_file` VALUES ('53', '/uploads/home/20190104/513e5e7aa38acb2f6f75533ffaa0d551.jpg', '/uploads/home/20190104/513e5e7aa38acb2f6f75533ffaa0d551.jpg', null, 'jpg', '85545', '1546616453');
INSERT INTO `u_file` VALUES ('54', '/uploads/home/20190104/e2f6be3e917e2e8247e6a3debe616fca.png', '/uploads/home/20190104/e2f6be3e917e2e8247e6a3debe616fca.png', null, 'png', '290551', '1546616719');
INSERT INTO `u_file` VALUES ('55', '/uploads/home/20190104/fb8e5775dcfa0a2ccf8d5c43e3080fc5.jpg', '/uploads/home/20190104/fb8e5775dcfa0a2ccf8d5c43e3080fc5.jpg', null, 'jpg', '85545', '1546616723');
INSERT INTO `u_file` VALUES ('56', '/uploads/home/20190105/9462ca2de006f93fd825025263f3d900.jpg', '/uploads/home/20190105/9462ca2de006f93fd825025263f3d900.jpg', null, 'jpg', '133067', '1546662306');
INSERT INTO `u_file` VALUES ('57', '/uploads/home/20190105/058ef8a2a4b668273bc4ad7959fa9bcf.jpg', '/uploads/home/20190105/058ef8a2a4b668273bc4ad7959fa9bcf.jpg', null, 'jpg', '133067', '1546662346');
INSERT INTO `u_file` VALUES ('58', '/uploads/home/20190105/66da715fa339b486a03727aab7da3db8.jpg', '/uploads/home/20190105/66da715fa339b486a03727aab7da3db8.jpg', null, 'jpg', '133067', '1546662520');
INSERT INTO `u_file` VALUES ('59', '/uploads/home/20190105/e1fb2c5f069ed127e1b5feb9540fec38.png', '/uploads/home/20190105/e1fb2c5f069ed127e1b5feb9540fec38.png', null, 'png', '290551', '1546662525');
INSERT INTO `u_file` VALUES ('60', '/uploads/home/20190105/99da43b8dea593d31a33930f8d07d2b1.jpg', '/uploads/home/20190105/99da43b8dea593d31a33930f8d07d2b1.jpg', null, 'jpg', '85545', '1546662533');
INSERT INTO `u_file` VALUES ('61', '/uploads/home/20190105/b836f4aa691af71f69f92fa66ed1c14b.jpg', '/uploads/home/20190105/b836f4aa691af71f69f92fa66ed1c14b.jpg', null, 'jpg', '133067', '1546662624');
INSERT INTO `u_file` VALUES ('62', '/uploads/home/20190105/fd35b4eabe55e79ffd7e6f1ae6ab7ea6.jpg', '/uploads/home/20190105/fd35b4eabe55e79ffd7e6f1ae6ab7ea6.jpg', null, 'jpg', '162318', '1546665698');
INSERT INTO `u_file` VALUES ('63', '/uploads/home/20190105/0a68a45c7764160aecf1490faf7f5a7f.png', '/uploads/home/20190105/0a68a45c7764160aecf1490faf7f5a7f.png', null, 'png', '290551', '1546665821');
INSERT INTO `u_file` VALUES ('64', '/uploads/home/20190105/25c23aff0be1019d009ae946960758b7.jpg', '/uploads/home/20190105/25c23aff0be1019d009ae946960758b7.jpg', null, 'jpg', '85545', '1546665828');
INSERT INTO `u_file` VALUES ('65', '/uploads/home/20190105/6a249f0eb05ec052f2a9c16cfc694846.jpg', '/uploads/home/20190105/6a249f0eb05ec052f2a9c16cfc694846.jpg', null, 'jpg', '162318', '1546666227');
INSERT INTO `u_file` VALUES ('66', '/uploads/home/20190105/2bb37dc94cde9b7fa906e73b76e9036a.png', '/uploads/home/20190105/2bb37dc94cde9b7fa906e73b76e9036a.png', null, 'png', '290551', '1546666230');
INSERT INTO `u_file` VALUES ('67', '/uploads/home/20190105/e9e6803f5554ffa00162e120308971fc.jpg', '/uploads/home/20190105/e9e6803f5554ffa00162e120308971fc.jpg', null, 'jpg', '85545', '1546666234');

-- ----------------------------
-- Table structure for u_level
-- ----------------------------
DROP TABLE IF EXISTS `u_level`;
CREATE TABLE `u_level` (
  `uid` int(11) unsigned NOT NULL COMMENT '手底下的会员等级汇总表',
  `y0` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下层会员游客数量',
  `y1` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下层会员一级会员数量',
  `y2` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下层会员二级数量',
  `e0` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下下层会员一级会员数量',
  `e1` int(11) unsigned NOT NULL DEFAULT '0',
  `e2` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of u_level
-- ----------------------------
INSERT INTO `u_level` VALUES ('1', '40', '0', '0', '60', '0', '0');
INSERT INTO `u_level` VALUES ('26', '6', '0', '0', '3', '0', '0');
INSERT INTO `u_level` VALUES ('27', '2', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('28', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('29', '5', '0', '0', '2', '0', '0');
INSERT INTO `u_level` VALUES ('30', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('31', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('32', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('33', '1', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('34', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('35', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('36', '4', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('37', '2', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('38', '1', '0', '0', '13', '0', '0');
INSERT INTO `u_level` VALUES ('39', '13', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('40', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('41', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('42', '1', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('43', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('44', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('45', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('46', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('47', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('48', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('49', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('50', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('51', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('52', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('53', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('54', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('55', '1', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('56', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('57', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('58', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('59', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('60', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('61', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('62', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('63', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('64', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('65', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('66', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('67', '1', '0', '0', '2', '0', '0');
INSERT INTO `u_level` VALUES ('68', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('69', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('70', '2', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('71', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('72', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('73', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('74', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('75', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('76', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('77', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('78', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('79', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('80', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('81', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('82', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('83', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('84', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('85', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('86', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('87', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('88', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('89', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('90', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('91', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('93', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('94', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('95', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('96', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('97', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('98', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('99', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('100', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('101', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('102', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('103', '0', '0', '0', '11', '0', '0');
INSERT INTO `u_level` VALUES ('104', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('105', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('111', '11', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('125', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('126', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('127', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('128', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('134', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('135', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('136', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('142', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('144', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('148', '0', '0', '0', '0', '0', '0');
INSERT INTO `u_level` VALUES ('151', '0', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for u_liuyan
-- ----------------------------
DROP TABLE IF EXISTS `u_liuyan`;
CREATE TABLE `u_liuyan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `description` varchar(255) NOT NULL COMMENT '问题描述',
  `phone` varchar(20) NOT NULL,
  `type` tinyint(1) DEFAULT '1' COMMENT '1问题反馈',
  `add_time` int(11) DEFAULT '0' COMMENT '提交时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='问题反馈表';

-- ----------------------------
-- Records of u_liuyan
-- ----------------------------
INSERT INTO `u_liuyan` VALUES ('1', '111', '123123', '13478576995', '1', '0');
INSERT INTO `u_liuyan` VALUES ('2', '111', '我有一个新问题', '13478576995', '1', '0');
INSERT INTO `u_liuyan` VALUES ('3', '127', '请输入问题内容(最多150字符)134', '13413413413', '1', '0');
INSERT INTO `u_liuyan` VALUES ('4', '111', '不行不行', '13624395766', '1', '0');

-- ----------------------------
-- Table structure for u_log
-- ----------------------------
DROP TABLE IF EXISTS `u_log`;
CREATE TABLE `u_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志表',
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `type` tinyint(40) NOT NULL COMMENT '1=收入，2=支出',
  `doller` int(11) NOT NULL COMMENT '金钱',
  `username` varchar(30) NOT NULL COMMENT '用户账号',
  `desc` varchar(30) NOT NULL COMMENT '大致说明',
  `time` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of u_log
-- ----------------------------
INSERT INTO `u_log` VALUES ('54', '1', '1', '3333', '111', '广告任务收益', '1544356844');
INSERT INTO `u_log` VALUES ('55', '39', '1', '4', 'yuese', '广告任务收益', '1544356878');
INSERT INTO `u_log` VALUES ('56', '67', '1', '4', '18012403426', '广告任务收益', '1544502310');
INSERT INTO `u_log` VALUES ('57', '36', '1', '20', 'zr0301', '广告任务收益', '1544502315');
INSERT INTO `u_log` VALUES ('58', '67', '1', '4', '18012403426', '广告任务收益', '1544502326');
INSERT INTO `u_log` VALUES ('59', '1', '2', '400', '111', '投入广告400', '1544579561');
INSERT INTO `u_log` VALUES ('62', '111', '2', '200', '12', '投入广告200', '1545022425');
INSERT INTO `u_log` VALUES ('63', '111', '2', '200', '12', '投入广告200', '1545022901');
INSERT INTO `u_log` VALUES ('64', '111', '2', '200', '12', '投入广告200', '1545022902');
INSERT INTO `u_log` VALUES ('65', '111', '2', '200', '12', '投入广告200', '1545022931');
INSERT INTO `u_log` VALUES ('66', '111', '2', '200', '12', '投入广告200', '1545023000');
INSERT INTO `u_log` VALUES ('67', '1', '1', '2', '111', '提现实际到账2', '1545884484');
INSERT INTO `u_log` VALUES ('68', '1', '1', '100', '111', '提现100实际到账95', '1545884504');
INSERT INTO `u_log` VALUES ('69', '111', '0', '20', '红开', '提现20实际到账20', '1546526316');
INSERT INTO `u_log` VALUES ('70', '111', '0', '20', '红开', '提现20实际到账20', '1546527453');
INSERT INTO `u_log` VALUES ('71', '111', '0', '20', '红开', '提现20实际到账20', '1546527463');
INSERT INTO `u_log` VALUES ('72', '111', '0', '20', '红开', '提现20实际到账20', '1546528108');
INSERT INTO `u_log` VALUES ('73', '111', '0', '200', '红开', '提现200实际到账200', '1546528821');
INSERT INTO `u_log` VALUES ('74', '111', '0', '200', '红开', '提现200实际到账200', '1546528826');
INSERT INTO `u_log` VALUES ('75', '111', '0', '200', '红开', '提现200实际到账200', '1546563907');
INSERT INTO `u_log` VALUES ('76', '127', '0', '10', '22222', '提现10实际到账10', '1546565409');
INSERT INTO `u_log` VALUES ('77', '127', '0', '200', '22222', '提现200实际到账200', '1546565518');
INSERT INTO `u_log` VALUES ('78', '127', '0', '90', '22222', '提现90实际到账90', '1546565659');

-- ----------------------------
-- Table structure for u_order_vip
-- ----------------------------
DROP TABLE IF EXISTS `u_order_vip`;
CREATE TABLE `u_order_vip` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) DEFAULT NULL,
  `order_status` tinyint(4) DEFAULT '0' COMMENT '0未支付1已支付',
  `user_id` int(11) DEFAULT '0' COMMENT '下单用户id',
  `level_id` int(11) DEFAULT '0' COMMENT '会员id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `total` decimal(10,2) DEFAULT '0.00' COMMENT '订单总价',
  `pay_name` varchar(255) DEFAULT NULL COMMENT '支付名称',
  `pay_time` int(11) DEFAULT '0',
  `add_time` int(11) DEFAULT '0' COMMENT '下单时间',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='会员订单表';

-- ----------------------------
-- Records of u_order_vip
-- ----------------------------
INSERT INTO `u_order_vip` VALUES ('4', '2019010414522517', '0', '111', '1', '99Vip', '99.00', null, '0', '1546584727');
INSERT INTO `u_order_vip` VALUES ('5', '2019010414585879', '0', '111', '1', '99Vip', '99.00', null, '0', '1546585130');
INSERT INTO `u_order_vip` VALUES ('6', '2019010414586719', '0', '111', '1', '99Vip', '99.00', null, '0', '1546585132');
INSERT INTO `u_order_vip` VALUES ('7', '2019010415021900', '0', '111', '1', '99Vip', '99.00', null, '0', '1546585367');
INSERT INTO `u_order_vip` VALUES ('8', '2019010415291666', '0', '127', '2', '999Vip', '999.00', null, '0', '1546586967');
INSERT INTO `u_order_vip` VALUES ('9', '2019010415345384', '0', '127', '1', '99Vip', '99.00', null, '0', '1546587254');
INSERT INTO `u_order_vip` VALUES ('10', '2019010415365944', '0', '127', '1', '99Vip', '99.00', null, '0', '1546587365');
INSERT INTO `u_order_vip` VALUES ('11', '2019010415367716', '0', '127', '2', '999Vip', '999.00', null, '0', '1546587406');
INSERT INTO `u_order_vip` VALUES ('12', '2019010415372601', '0', '127', '2', '999Vip', '999.00', null, '0', '1546587424');
INSERT INTO `u_order_vip` VALUES ('13', '2019010415458309', '0', '127', '2', '999Vip', '999.00', null, '0', '1546587945');
INSERT INTO `u_order_vip` VALUES ('14', '2019010415526427', '0', '127', '2', '999Vip', '999.00', null, '0', '1546588374');
INSERT INTO `u_order_vip` VALUES ('15', '2019010416109497', '0', '127', '2', '999Vip', '999.00', null, '0', '1546589452');
INSERT INTO `u_order_vip` VALUES ('16', '2019010416117578', '0', '127', '2', '999Vip', '999.00', null, '0', '1546589486');
INSERT INTO `u_order_vip` VALUES ('17', '2019010416114957', '0', '127', '2', '999Vip', '999.00', null, '0', '1546589488');
INSERT INTO `u_order_vip` VALUES ('18', '2019010416115852', '0', '127', '2', '999Vip', '999.00', null, '0', '1546589489');

-- ----------------------------
-- Table structure for u_relation
-- ----------------------------
DROP TABLE IF EXISTS `u_relation`;
CREATE TABLE `u_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '关系表',
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `dwid` int(11) unsigned NOT NULL COMMENT '下家id',
  `upid` int(11) unsigned NOT NULL COMMENT '上家id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of u_relation
-- ----------------------------
INSERT INTO `u_relation` VALUES ('1', '1', '1', '1');
INSERT INTO `u_relation` VALUES ('26', '1', '26', '1');
INSERT INTO `u_relation` VALUES ('27', '1', '27', '1');
INSERT INTO `u_relation` VALUES ('28', '1', '28', '1');
INSERT INTO `u_relation` VALUES ('29', '1', '29', '1');
INSERT INTO `u_relation` VALUES ('30', '1', '30', '1');
INSERT INTO `u_relation` VALUES ('31', '1', '31', '1');
INSERT INTO `u_relation` VALUES ('32', '1', '32', '1');
INSERT INTO `u_relation` VALUES ('33', '1', '33', '1');
INSERT INTO `u_relation` VALUES ('34', '1', '34', '1');
INSERT INTO `u_relation` VALUES ('35', '26', '35', '1');
INSERT INTO `u_relation` VALUES ('36', '1', '36', '1');
INSERT INTO `u_relation` VALUES ('37', '26', '37', '1');
INSERT INTO `u_relation` VALUES ('38', '26', '38', '1');
INSERT INTO `u_relation` VALUES ('39', '38', '39', '26');
INSERT INTO `u_relation` VALUES ('40', '33', '40', '1');
INSERT INTO `u_relation` VALUES ('41', '1', '41', '1');
INSERT INTO `u_relation` VALUES ('42', '29', '42', '1');
INSERT INTO `u_relation` VALUES ('43', '1', '43', '1');
INSERT INTO `u_relation` VALUES ('44', '29', '44', '1');
INSERT INTO `u_relation` VALUES ('45', '42', '45', '29');
INSERT INTO `u_relation` VALUES ('46', '29', '46', '1');
INSERT INTO `u_relation` VALUES ('47', '39', '47', '38');
INSERT INTO `u_relation` VALUES ('48', '39', '48', '38');
INSERT INTO `u_relation` VALUES ('49', '39', '49', '38');
INSERT INTO `u_relation` VALUES ('50', '39', '50', '38');
INSERT INTO `u_relation` VALUES ('51', '26', '51', '1');
INSERT INTO `u_relation` VALUES ('52', '39', '52', '38');
INSERT INTO `u_relation` VALUES ('53', '26', '53', '1');
INSERT INTO `u_relation` VALUES ('54', '1', '54', '1');
INSERT INTO `u_relation` VALUES ('55', '29', '55', '1');
INSERT INTO `u_relation` VALUES ('56', '55', '56', '29');
INSERT INTO `u_relation` VALUES ('57', '1', '57', '1');
INSERT INTO `u_relation` VALUES ('58', '26', '58', '1');
INSERT INTO `u_relation` VALUES ('59', '39', '59', '38');
INSERT INTO `u_relation` VALUES ('60', '27', '60', '1');
INSERT INTO `u_relation` VALUES ('61', '1', '61', '1');
INSERT INTO `u_relation` VALUES ('62', '1', '62', '1');
INSERT INTO `u_relation` VALUES ('63', '1', '63', '1');
INSERT INTO `u_relation` VALUES ('64', '39', '64', '38');
INSERT INTO `u_relation` VALUES ('65', '36', '65', '1');
INSERT INTO `u_relation` VALUES ('66', '1', '66', '1');
INSERT INTO `u_relation` VALUES ('67', '1', '67', '1');
INSERT INTO `u_relation` VALUES ('68', '39', '68', '38');
INSERT INTO `u_relation` VALUES ('69', '1', '69', '1');
INSERT INTO `u_relation` VALUES ('70', '67', '70', '1');
INSERT INTO `u_relation` VALUES ('71', '70', '71', '67');
INSERT INTO `u_relation` VALUES ('72', '1', '72', '1');
INSERT INTO `u_relation` VALUES ('73', '37', '73', '26');
INSERT INTO `u_relation` VALUES ('74', '39', '74', '38');
INSERT INTO `u_relation` VALUES ('75', '39', '75', '38');
INSERT INTO `u_relation` VALUES ('76', '39', '76', '38');
INSERT INTO `u_relation` VALUES ('77', '36', '77', '1');
INSERT INTO `u_relation` VALUES ('78', '37', '78', '26');
INSERT INTO `u_relation` VALUES ('79', '1', '79', '1');
INSERT INTO `u_relation` VALUES ('80', '1', '80', '1');
INSERT INTO `u_relation` VALUES ('81', '1', '81', '1');
INSERT INTO `u_relation` VALUES ('82', '1', '82', '1');
INSERT INTO `u_relation` VALUES ('83', '36', '83', '1');
INSERT INTO `u_relation` VALUES ('84', '39', '84', '38');
INSERT INTO `u_relation` VALUES ('85', '1', '85', '1');
INSERT INTO `u_relation` VALUES ('86', '1', '86', '1');
INSERT INTO `u_relation` VALUES ('87', '1', '87', '1');
INSERT INTO `u_relation` VALUES ('88', '1', '88', '1');
INSERT INTO `u_relation` VALUES ('89', '39', '89', '38');
INSERT INTO `u_relation` VALUES ('90', '1', '90', '1');
INSERT INTO `u_relation` VALUES ('91', '1', '91', '1');
INSERT INTO `u_relation` VALUES ('93', '1', '93', '1');
INSERT INTO `u_relation` VALUES ('94', '36', '94', '1');
INSERT INTO `u_relation` VALUES ('95', '27', '95', '1');
INSERT INTO `u_relation` VALUES ('96', '1', '96', '1');
INSERT INTO `u_relation` VALUES ('97', '1', '97', '1');
INSERT INTO `u_relation` VALUES ('98', '1', '98', '1');
INSERT INTO `u_relation` VALUES ('99', '1', '99', '1');
INSERT INTO `u_relation` VALUES ('100', '1', '100', '1');
INSERT INTO `u_relation` VALUES ('101', '1', '101', '1');
INSERT INTO `u_relation` VALUES ('102', '70', '102', '67');
INSERT INTO `u_relation` VALUES ('103', '29', '103', '1');
INSERT INTO `u_relation` VALUES ('104', '1', '104', '1');
INSERT INTO `u_relation` VALUES ('105', '1', '105', '1');
INSERT INTO `u_relation` VALUES ('106', '1', '111', '1');
INSERT INTO `u_relation` VALUES ('107', '111', '125', '103');
INSERT INTO `u_relation` VALUES ('108', '111', '126', '103');
INSERT INTO `u_relation` VALUES ('109', '111', '127', '103');
INSERT INTO `u_relation` VALUES ('110', '111', '128', '103');
INSERT INTO `u_relation` VALUES ('111', '111', '134', '103');
INSERT INTO `u_relation` VALUES ('112', '111', '135', '103');
INSERT INTO `u_relation` VALUES ('113', '111', '136', '103');
INSERT INTO `u_relation` VALUES ('114', '111', '142', '103');
INSERT INTO `u_relation` VALUES ('115', '111', '144', '103');
INSERT INTO `u_relation` VALUES ('116', '111', '148', '103');
INSERT INTO `u_relation` VALUES ('117', '111', '151', '103');

-- ----------------------------
-- Table structure for u_sms
-- ----------------------------
DROP TABLE IF EXISTS `u_sms`;
CREATE TABLE `u_sms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '短信id',
  `mobile` char(11) NOT NULL COMMENT '手机号',
  `time` int(11) unsigned NOT NULL COMMENT '时间',
  `code` char(8) DEFAULT NULL COMMENT '验证码',
  `type` tinyint(1) DEFAULT '0' COMMENT '验证码类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of u_sms
-- ----------------------------
INSERT INTO `u_sms` VALUES ('1', '15542848579', '1543217733', '4404', '0');
INSERT INTO `u_sms` VALUES ('2', '13998551688', '1544059253', '8031', '0');
INSERT INTO `u_sms` VALUES ('3', '13998551688', '1544156152', '2552', '0');
INSERT INTO `u_sms` VALUES ('4', '13889595813', '1544156703', '2892', '0');
INSERT INTO `u_sms` VALUES ('5', '13998551688', '1544157632', '3563', '0');
INSERT INTO `u_sms` VALUES ('6', '13998551688', '1544157705', '1467', '0');
INSERT INTO `u_sms` VALUES ('7', '13998551688', '1544157707', '8978', '0');
INSERT INTO `u_sms` VALUES ('8', '13998551688', '1544157708', '5963', '0');
INSERT INTO `u_sms` VALUES ('9', '13998551688', '1544157710', '7767', '0');
INSERT INTO `u_sms` VALUES ('10', '13998551688', '1544157711', '6766', '0');
INSERT INTO `u_sms` VALUES ('11', '13998551688', '1544157711', '2098', '0');
INSERT INTO `u_sms` VALUES ('12', '13998551688', '1544157712', '1041', '0');
INSERT INTO `u_sms` VALUES ('13', '13998551688', '1544157713', '3046', '0');
INSERT INTO `u_sms` VALUES ('14', '18640136686', '1544160174', '4726', '0');
INSERT INTO `u_sms` VALUES ('15', '15638827794', '1544161110', '9750', '0');
INSERT INTO `u_sms` VALUES ('16', '17797518405', '1544161325', '8042', '0');
INSERT INTO `u_sms` VALUES ('17', '17693284997', '1544161393', '3535', '0');
INSERT INTO `u_sms` VALUES ('18', '15553462736', '1544162545', '6844', '0');
INSERT INTO `u_sms` VALUES ('19', '15354734880', '1544162605', '3412', '0');
INSERT INTO `u_sms` VALUES ('20', '15967257612', '1544163407', '6938', '0');
INSERT INTO `u_sms` VALUES ('21', '15967257612', '1544163409', '2328', '0');
INSERT INTO `u_sms` VALUES ('22', '15557808520', '1544164103', '9684', '0');
INSERT INTO `u_sms` VALUES ('23', '18909852211', '1544164313', '7000', '0');
INSERT INTO `u_sms` VALUES ('24', '18940888881', '1544165892', '6013', '0');
INSERT INTO `u_sms` VALUES ('25', '15638155112', '1544166230', '4029', '0');
INSERT INTO `u_sms` VALUES ('26', '17606722557', '1544170227', '5540', '0');
INSERT INTO `u_sms` VALUES ('27', '19943510867', '1544173285', '5793', '0');
INSERT INTO `u_sms` VALUES ('28', '15831030911', '1544174985', '6427', '0');
INSERT INTO `u_sms` VALUES ('29', '17338480652', '1544175068', '5758', '0');
INSERT INTO `u_sms` VALUES ('30', '13526652226', '1544176451', '3887', '0');
INSERT INTO `u_sms` VALUES ('31', '13526652226', '1544176862', '5638', '0');
INSERT INTO `u_sms` VALUES ('32', '13526652226', '1544176925', '7845', '0');
INSERT INTO `u_sms` VALUES ('33', '13027605423', '1544177891', '3605', '0');
INSERT INTO `u_sms` VALUES ('34', '18638258897', '1544178111', '8662', '0');
INSERT INTO `u_sms` VALUES ('35', '17385052044', '1544178319', '9315', '0');
INSERT INTO `u_sms` VALUES ('36', '17759138957', '1544178660', '6917', '0');
INSERT INTO `u_sms` VALUES ('37', '15274604088', '1544180569', '8903', '0');
INSERT INTO `u_sms` VALUES ('38', '13181109322', '1544181508', '9857', '0');
INSERT INTO `u_sms` VALUES ('39', '15530098550', '1544182481', '5280', '0');
INSERT INTO `u_sms` VALUES ('40', '18932700981', '1544182931', '1001', '0');
INSERT INTO `u_sms` VALUES ('41', '15100068896', '1544183767', '3395', '0');
INSERT INTO `u_sms` VALUES ('42', '15912672946', '1544184645', '5280', '0');
INSERT INTO `u_sms` VALUES ('43', '15630376717', '1544185257', '4750', '0');
INSERT INTO `u_sms` VALUES ('44', '17600509558', '1544185787', '5253', '0');
INSERT INTO `u_sms` VALUES ('45', '15019465258', '1544187900', '7722', '0');
INSERT INTO `u_sms` VALUES ('46', '18533932997', '1544188119', '3026', '0');
INSERT INTO `u_sms` VALUES ('47', '13180528862', '1544190013', '6801', '0');
INSERT INTO `u_sms` VALUES ('48', '15968214075', '1544190701', '9534', '0');
INSERT INTO `u_sms` VALUES ('49', '15328437295', '1544195107', '7496', '0');
INSERT INTO `u_sms` VALUES ('50', '13403305432', '1544195118', '7366', '0');
INSERT INTO `u_sms` VALUES ('51', '15811926678', '1544231134', '6519', '0');
INSERT INTO `u_sms` VALUES ('52', '15670251202', '1544231334', '5218', '0');
INSERT INTO `u_sms` VALUES ('53', '18339907380', '1544233553', '5525', '0');
INSERT INTO `u_sms` VALUES ('54', '18503227581', '1544233571', '4419', '0');
INSERT INTO `u_sms` VALUES ('55', '18617557227', '1544235002', '3715', '0');
INSERT INTO `u_sms` VALUES ('56', '18732013146', '1544238660', '9402', '0');
INSERT INTO `u_sms` VALUES ('57', '17662656662', '1544240092', '5551', '0');
INSERT INTO `u_sms` VALUES ('58', '18830001071', '1544240391', '3875', '0');
INSERT INTO `u_sms` VALUES ('59', '18012403426', '1544240617', '8547', '0');
INSERT INTO `u_sms` VALUES ('60', '18012403426', '1544240680', '5560', '0');
INSERT INTO `u_sms` VALUES ('61', '17712446842', '1544241009', '6594', '0');
INSERT INTO `u_sms` VALUES ('62', '18012403426', '1544241236', '4312', '0');
INSERT INTO `u_sms` VALUES ('63', '15852461585', '1544241419', '5616', '0');
INSERT INTO `u_sms` VALUES ('64', '18533932997', '1544242065', '5740', '0');
INSERT INTO `u_sms` VALUES ('65', '13100297366', '1544242375', '8383', '0');
INSERT INTO `u_sms` VALUES ('66', '13100297366', '1544242434', '3881', '0');
INSERT INTO `u_sms` VALUES ('67', '18779610941', '1544246390', '2855', '0');
INSERT INTO `u_sms` VALUES ('68', '18978352320', '1544247376', '8551', '0');
INSERT INTO `u_sms` VALUES ('69', '18978352320', '1544247690', '8820', '0');
INSERT INTO `u_sms` VALUES ('70', '18978352320', '1544247891', '2886', '0');
INSERT INTO `u_sms` VALUES ('71', '13764958610', '1544248384', '8566', '0');
INSERT INTO `u_sms` VALUES ('72', '15184260912', '1544250478', '2961', '0');
INSERT INTO `u_sms` VALUES ('73', '13315055770', '1544250652', '2057', '0');
INSERT INTO `u_sms` VALUES ('74', '13315055770', '1544250701', '7307', '0');
INSERT INTO `u_sms` VALUES ('75', '13315055770', '1544250742', '6789', '0');
INSERT INTO `u_sms` VALUES ('76', '16619716172', '1544250931', '7417', '0');
INSERT INTO `u_sms` VALUES ('77', '15980679588', '1544251583', '8830', '0');
INSERT INTO `u_sms` VALUES ('78', '15980679588', '1544251671', '2672', '0');
INSERT INTO `u_sms` VALUES ('79', '18907790673', '1544252767', '1234', '0');
INSERT INTO `u_sms` VALUES ('80', '13322253991', '1544253311', '7402', '0');
INSERT INTO `u_sms` VALUES ('81', '15980679588', '1544254516', '1649', '0');
INSERT INTO `u_sms` VALUES ('82', '17327585881', '1544258884', '9448', '0');
INSERT INTO `u_sms` VALUES ('83', '15133530393', '1544261365', '4340', '0');
INSERT INTO `u_sms` VALUES ('84', '15133530393', '1544261482', '7962', '0');
INSERT INTO `u_sms` VALUES ('85', '17640298816', '1544261730', '8305', '0');
INSERT INTO `u_sms` VALUES ('86', '13027629745', '1544262588', '2538', '0');
INSERT INTO `u_sms` VALUES ('87', '15373114820', '1544263840', '3396', '0');
INSERT INTO `u_sms` VALUES ('88', '15373114820', '1544264043', '6815', '0');
INSERT INTO `u_sms` VALUES ('89', '15373114820', '1544264100', '6707', '0');
INSERT INTO `u_sms` VALUES ('90', '15373114820', '1544264164', '4120', '0');
INSERT INTO `u_sms` VALUES ('91', '15373114820', '1544264524', '8206', '0');
INSERT INTO `u_sms` VALUES ('92', '15373114820', '1544264586', '1134', '0');
INSERT INTO `u_sms` VALUES ('93', '18236670235', '1544264710', '5991', '0');
INSERT INTO `u_sms` VALUES ('94', '15373114820', '1544264947', '4984', '0');
INSERT INTO `u_sms` VALUES ('95', '15373114820', '1544265657', '8472', '0');
INSERT INTO `u_sms` VALUES ('96', '15530098550', '1544265796', '1550', '0');
INSERT INTO `u_sms` VALUES ('97', '18012403426', '1544265901', '5988', '0');
INSERT INTO `u_sms` VALUES ('98', '15133530393', '1544270158', '2056', '0');
INSERT INTO `u_sms` VALUES ('99', '15831626417', '1544270543', '6146', '0');
INSERT INTO `u_sms` VALUES ('100', '17606036184', '1544274425', '7866', '0');
INSERT INTO `u_sms` VALUES ('101', '18850970979', '1544279147', '4865', '0');
INSERT INTO `u_sms` VALUES ('102', '13181109322', '1544304496', '2499', '0');
INSERT INTO `u_sms` VALUES ('103', '18241172058', '1544316540', '7364', '0');
INSERT INTO `u_sms` VALUES ('104', '18241172058', '1544317218', '1106', '0');
INSERT INTO `u_sms` VALUES ('105', '18339907380', '1544317586', '7685', '0');
INSERT INTO `u_sms` VALUES ('106', '18236670235', '1544319664', '8793', '0');
INSERT INTO `u_sms` VALUES ('107', '13595191242', '1544322979', '7845', '0');
INSERT INTO `u_sms` VALUES ('108', '15127066881', '1544343297', '8880', '0');
INSERT INTO `u_sms` VALUES ('109', '15831030911', '1544344141', '1838', '0');
INSERT INTO `u_sms` VALUES ('110', '18806581020', '1544348745', '8338', '0');
INSERT INTO `u_sms` VALUES ('111', '18806581020', '1544349073', '8630', '0');
INSERT INTO `u_sms` VALUES ('112', '13062749538', '1544351638', '1143', '0');
INSERT INTO `u_sms` VALUES ('113', '17377103251', '1544368735', '1982', '0');
INSERT INTO `u_sms` VALUES ('114', '17377103251', '1544368939', '9356', '0');
INSERT INTO `u_sms` VALUES ('115', '17377103251', '1544368985', '4650', '0');
INSERT INTO `u_sms` VALUES ('116', '13562070261', '1544403191', '2689', '0');
INSERT INTO `u_sms` VALUES ('117', '13562070261', '1544403224', '6604', '0');
INSERT INTO `u_sms` VALUES ('118', '15669623550', '1544407378', '6917', '0');
INSERT INTO `u_sms` VALUES ('119', '15669623550', '1544407448', '4492', '0');
INSERT INTO `u_sms` VALUES ('120', '15669623550', '1544407515', '7036', '0');
INSERT INTO `u_sms` VALUES ('121', '15638896634', '1544409429', '4337', '0');
INSERT INTO `u_sms` VALUES ('122', '15570238218', '1544412290', '1347', '0');
INSERT INTO `u_sms` VALUES ('123', '15570238218', '1544412457', '3045', '0');
INSERT INTO `u_sms` VALUES ('124', '13633204060', '1544420484', '2363', '0');
INSERT INTO `u_sms` VALUES ('125', '13953016397', '1544430223', '4577', '0');
INSERT INTO `u_sms` VALUES ('126', '13026697232', '1544432516', '4584', '0');
INSERT INTO `u_sms` VALUES ('127', '13026697232', '1544432593', '3233', '0');
INSERT INTO `u_sms` VALUES ('128', '18503227581', '1544445188', '8508', '0');
INSERT INTO `u_sms` VALUES ('129', '15980679588', '1544445689', '1521', '0');
INSERT INTO `u_sms` VALUES ('130', '13045785462', '1544506053', '8344', '0');
INSERT INTO `u_sms` VALUES ('131', '13045785462', '1544506189', '1922', '0');
INSERT INTO `u_sms` VALUES ('132', '18735388243', '1544572364', '8323', '0');
INSERT INTO `u_sms` VALUES ('133', '13478576995', '1544578550', '9068', '0');
INSERT INTO `u_sms` VALUES ('134', '13478576995', '1544622178', '3255', '0');
INSERT INTO `u_sms` VALUES ('135', '13478576995', '1544630053', '3420', '0');
INSERT INTO `u_sms` VALUES ('136', '13354005489', '1545033964', '9118', '1');
INSERT INTO `u_sms` VALUES ('137', '15566661884', '1545615324', '2078', '1');
INSERT INTO `u_sms` VALUES ('138', '15566661884', '1545616347', '9686', '1');
INSERT INTO `u_sms` VALUES ('139', '15040597837', '1545891613', '5013', '1');
INSERT INTO `u_sms` VALUES ('140', '15040597837', '1545893766', '1837', '1');
INSERT INTO `u_sms` VALUES ('141', '15040597837', '1545896858', '5817', '1');
INSERT INTO `u_sms` VALUES ('142', '15040597837', '1545902141', '4580', '1');
INSERT INTO `u_sms` VALUES ('143', '15040597837', '1545902940', '1614', '1');
INSERT INTO `u_sms` VALUES ('144', '15040597837', '1545903229', '2136', '1');
INSERT INTO `u_sms` VALUES ('145', '13624393950', '1545903323', '4877', '1');
INSERT INTO `u_sms` VALUES ('146', '18624393950', '1545903370', '1442', '1');
INSERT INTO `u_sms` VALUES ('147', '18624393950', '1545903490', '8944', '1');
INSERT INTO `u_sms` VALUES ('148', '18624393950', '1545903499', '2151', '1');
INSERT INTO `u_sms` VALUES ('149', '18624393950', '1545904196', '2942', '1');
INSERT INTO `u_sms` VALUES ('150', '18624393950', '1545917383', '9939', '1');
INSERT INTO `u_sms` VALUES ('151', '15566661884', '1545961554', '7233', '1');
INSERT INTO `u_sms` VALUES ('152', '15566661884', '1545961741', '5105', '1');
INSERT INTO `u_sms` VALUES ('153', '15566661884', '1545961771', '2638', '1');
INSERT INTO `u_sms` VALUES ('154', '15040597837', '1546184386', '4026', '1');
INSERT INTO `u_sms` VALUES ('155', '18624393950', '1546185572', '1578', '2');
INSERT INTO `u_sms` VALUES ('156', '15566661884', '1546562770', '1959', '4');
INSERT INTO `u_sms` VALUES ('157', '15566661884', '1546562922', '6485', '4');
INSERT INTO `u_sms` VALUES ('158', '15566661884', '1546563043', '9374', '4');
INSERT INTO `u_sms` VALUES ('159', '15566661884', '1546563149', '1451', '4');
INSERT INTO `u_sms` VALUES ('160', '15566661884', '1546563171', '8350', '4');
INSERT INTO `u_sms` VALUES ('161', '15566661884', '1546563329', '6389', '4');
INSERT INTO `u_sms` VALUES ('162', '15566661884', '1546563369', '5105', '4');
INSERT INTO `u_sms` VALUES ('163', '13478576995', '1546567445', '5678', '0');
INSERT INTO `u_sms` VALUES ('164', '13354005489', '1546568115', '4762', '0');
INSERT INTO `u_sms` VALUES ('165', '13354005489', '1546568398', '5740', '0');

-- ----------------------------
-- Table structure for u_team_log
-- ----------------------------
DROP TABLE IF EXISTS `u_team_log`;
CREATE TABLE `u_team_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '团队佣金表',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `username` varchar(30) NOT NULL COMMENT '用户名',
  `doller` decimal(10,2) NOT NULL COMMENT '金钱',
  `desc` varchar(30) DEFAULT NULL COMMENT '描述',
  `time` int(11) NOT NULL COMMENT '时间',
  `type` char(2) NOT NULL COMMENT '正负',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of u_team_log
-- ----------------------------
INSERT INTO `u_team_log` VALUES ('1', '1', '111', '2.00', '下级广告分红收益', '1544088641', '+');
INSERT INTO `u_team_log` VALUES ('2', '1', '111', '1.00', '下级广告分红收益', '1544088641', '+');
INSERT INTO `u_team_log` VALUES ('3', '1', '111', '2.00', '下级广告分红收益', '1544356845', '+');
INSERT INTO `u_team_log` VALUES ('4', '1', '111', '1.00', '下级广告分红收益', '1544356845', '+');
INSERT INTO `u_team_log` VALUES ('5', '1', '111', '2.00', '下级广告分红收益', '1544502310', '+');
INSERT INTO `u_team_log` VALUES ('6', '1', '111', '1.00', '下级广告分红收益', '1544502310', '+');
INSERT INTO `u_team_log` VALUES ('7', '1', '111', '2.00', '下级广告分红收益', '1544502315', '+');
INSERT INTO `u_team_log` VALUES ('8', '1', '111', '1.00', '下级广告分红收益', '1544502315', '+');
INSERT INTO `u_team_log` VALUES ('9', '1', '111', '2.00', '下级广告分红收益', '1544502326', '+');
INSERT INTO `u_team_log` VALUES ('10', '1', '111', '1.00', '下级广告分红收益', '1544502326', '+');

-- ----------------------------
-- Table structure for u_tk
-- ----------------------------
DROP TABLE IF EXISTS `u_tk`;
CREATE TABLE `u_tk` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '任务表',
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `aid` int(11) unsigned NOT NULL COMMENT '任务id',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态：\r\n0待提交\r\n1待审核\r\n2已完成\r\n3不合格\r\n5已驳回',
  `price` decimal(10,2) NOT NULL COMMENT '领取金额',
  `ltime` int(11) NOT NULL COMMENT '领取时间',
  `ttime` int(11) DEFAULT NULL COMMENT '提交时间',
  `img` varchar(255) NOT NULL COMMENT '任务截图',
  `reg` tinyint(2) NOT NULL COMMENT '是否封禁',
  `tj_pics_json` text COMMENT '多张图片json数组',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of u_tk
-- ----------------------------
INSERT INTO `u_tk` VALUES ('0', '0', '0', '0', '0.00', '0', '0', '', '0', '');
INSERT INTO `u_tk` VALUES ('15', '21', '14', '2', '4.00', '1544088622', '1544088634', '/uploads/20181206/cc012ad0a47e7c5e95544fbbbf7c9c31.png', '0', null);
INSERT INTO `u_tk` VALUES ('16', '1', '18', '2', '3333.00', '1544088893', '1544314558', '/uploads/20181209/9faa519f6a9ba18f74a969dfa9e6057e.png', '0', null);
INSERT INTO `u_tk` VALUES ('17', '67', '25', '2', '4.00', '1544310505', '1544417213', '/uploads/20181210/cba3b197fc97f0617275e087e3b7a769.png', '0', null);
INSERT INTO `u_tk` VALUES ('18', '36', '26', '1', '20.00', '1544327303', '1544523703', '/uploads/20181211/fdbbae32888c303b425b79279c887c27.jpg', '0', null);
INSERT INTO `u_tk` VALUES ('19', '39', '25', '2', '4.00', '1544332978', '1544344261', '/uploads/20181209/d7646ef7e2d50b85d097606d9c72b8d1.jpg', '0', null);
INSERT INTO `u_tk` VALUES ('20', '27', '25', '0', '4.00', '1544334284', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('21', '1', '25', '0', '4.00', '1544347160', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('22', '37', '25', '0', '4.00', '1544349613', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('23', '36', '28', '2', '20.00', '1544406347', '1544422178', '/uploads/20181210/93df390b0f29a30308fac955414b9a70.jpg', '0', null);
INSERT INTO `u_tk` VALUES ('24', '67', '27', '2', '4.00', '1544407156', '1544417195', '/uploads/20181210/c14520d2f04dea2d51dd9c327167d7e0.png', '0', null);
INSERT INTO `u_tk` VALUES ('25', '99', '27', '0', '4.00', '1544412956', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('26', '39', '27', '0', '4.00', '1544412962', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('27', '1', '29', '0', '4.00', '1544419650', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('28', '39', '29', '0', '4.00', '1544421422', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('29', '27', '27', '0', '4.00', '1544422193', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('30', '1', '27', '0', '4.00', '1544425736', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('31', '36', '30', '1', '20.00', '1544504017', '1544523668', '/uploads/20181211/c109d49ecc1c7e516f6d1fa64276366c.jpg', '0', null);
INSERT INTO `u_tk` VALUES ('32', '67', '29', '1', '4.00', '1544504558', '1544512241', '/uploads/20181211/61a2e7e208ace64e744b92e6bb30b8d3.png', '0', null);
INSERT INTO `u_tk` VALUES ('33', '29', '30', '0', '20.00', '1544573792', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('34', '29', '28', '0', '20.00', '1544573805', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('35', '67', '31', '0', '4.00', '1544589342', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('36', '111', '27', '2', '4.00', '1544942580', '1546519083', '', '0', '/uploads/home/20190103/53f9dfe6ab562f60b98e21dd1d84f167.jpg');
INSERT INTO `u_tk` VALUES ('37', '111', '36', '2', '2.00', '1545024525', '1545227271', '', '0', '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]');
INSERT INTO `u_tk` VALUES ('38', '111', '36', '1', '2.00', '1545024525', '1545227271', '', '0', '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]');
INSERT INTO `u_tk` VALUES ('39', '111', '36', '5', '2.00', '1545024525', '1545227271', '', '0', '[\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\",\"\\/uploads\\/20181206\\/cc012ad0a47e7c5e95544fbbbf7c9c31.png\"]');
INSERT INTO `u_tk` VALUES ('40', '111', '36', '0', '2.00', '1545726592', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('41', '111', '36', '0', '2.00', '1545726650', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('42', '111', '29', '0', '4.00', '1545784243', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('43', '111', '36', '0', '2.00', '1545784276', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('44', '111', '36', '0', '2.00', '1545983020', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('45', '111', '32', '0', '2.00', '1545984360', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('46', '111', '36', '0', '2.00', '1546144517', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('47', '111', '36', '0', '2.00', '1546144527', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('48', '111', '35', '0', '2.00', '1546342114', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('49', '111', '36', '0', '2.00', '1546351856', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('50', '111', '36', '0', '2.00', '1546392004', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('51', '111', '33', '0', '2.00', '1546392009', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('52', '111', '36', '0', '2.00', '1546516732', null, '', '0', null);
INSERT INTO `u_tk` VALUES ('53', '111', '34', '0', '2.00', '1546519258', null, '', '0', null);

-- ----------------------------
-- Table structure for u_tx
-- ----------------------------
DROP TABLE IF EXISTS `u_tx`;
CREATE TABLE `u_tx` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '提现表',
  `user_id` int(11) unsigned NOT NULL COMMENT '用户id',
  `price` decimal(10,2) NOT NULL COMMENT '提现数量',
  `add_time` int(11) NOT NULL COMMENT '时间',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0=未审核，1=审核',
  `type` tinyint(1) DEFAULT '0' COMMENT '提现类型1支付宝2微信3银行卡',
  `pay_img` varchar(255) DEFAULT NULL COMMENT '支付宝或微信收款二维码图片url',
  `bank_name` varchar(255) DEFAULT NULL COMMENT '所属行',
  `bank_number` varchar(255) DEFAULT NULL COMMENT '银行卡号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
-- Records of u_tx
-- ----------------------------
INSERT INTO `u_tx` VALUES ('29', '111', '20.00', '1546526316', '0', '1', 'zhifubaoimg', null, null);
INSERT INTO `u_tx` VALUES ('30', '111', '20.00', '1546527453', '0', '2', 'weixinimg', null, null);
INSERT INTO `u_tx` VALUES ('31', '111', '20.00', '1546527463', '0', '2', 'weixinimg', null, null);
INSERT INTO `u_tx` VALUES ('32', '111', '20.00', '1546528108', '0', '2', 'weixinimg', null, null);
INSERT INTO `u_tx` VALUES ('33', '111', '200.00', '1546528821', '0', '2', 'weixinimg', null, null);
INSERT INTO `u_tx` VALUES ('34', '111', '200.00', '1546528826', '0', '2', 'weixinimg', null, null);
INSERT INTO `u_tx` VALUES ('35', '111', '200.00', '1546563907', '0', '2', 'weixinimg', null, null);
INSERT INTO `u_tx` VALUES ('36', '127', '10.00', '1546565409', '0', '1', '/uploads/home/20190104/6a268c8d0edbd8fa00ce5d0f5b9c55e7.png', null, null);
INSERT INTO `u_tx` VALUES ('37', '127', '200.00', '1546565518', '0', '1', '/uploads/home/20190104/6a268c8d0edbd8fa00ce5d0f5b9c55e7.png', null, null);
INSERT INTO `u_tx` VALUES ('38', '127', '90.00', '1546565659', '0', '1', '/uploads/home/20190104/746391b06f638780e42b2163153267af.png', null, null);

-- ----------------------------
-- Table structure for u_user
-- ----------------------------
DROP TABLE IF EXISTS `u_user`;
CREATE TABLE `u_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户数据表',
  `username` varchar(30) NOT NULL COMMENT '登录账号',
  `password` varchar(255) NOT NULL COMMENT '登录密码',
  `password_old_copy` varchar(255) DEFAULT NULL,
  `phone` varchar(11) NOT NULL COMMENT '手机号码',
  `upid` int(11) unsigned NOT NULL COMMENT '上家ID',
  `rec_code` varchar(40) DEFAULT NULL COMMENT '推荐码',
  `bank` varchar(20) DEFAULT NULL COMMENT '银行',
  `bankcard` varchar(40) DEFAULT NULL,
  `bankphone` varchar(20) DEFAULT NULL,
  `banknum` varchar(20) DEFAULT NULL COMMENT '银行卡号',
  `banktype` varchar(20) DEFAULT NULL,
  `bankxi` varchar(20) DEFAULT NULL COMMENT '具体支行',
  `bankname` varchar(20) DEFAULT NULL COMMENT '持卡人姓名',
  `banksheng` varchar(20) DEFAULT NULL COMMENT '开户省份',
  `bankshi` varchar(20) DEFAULT NULL COMMENT '开户市区',
  `total_sy` decimal(10,2) DEFAULT NULL,
  `sy` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '余额',
  `sy_yj` int(11) DEFAULT '0' COMMENT '收益-佣金',
  `sy_rw` int(11) DEFAULT '0' COMMENT '收益-任务',
  `alipay` varchar(40) DEFAULT NULL COMMENT '支付宝账号',
  `tx` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '总提现',
  `level` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '会员等级',
  `ip` varchar(20) DEFAULT NULL COMMENT '登录ip',
  `login_time` int(11) DEFAULT '0',
  `time` int(11) NOT NULL COMMENT '注册时间',
  `reg` varchar(20) NOT NULL DEFAULT '1' COMMENT '是否封禁',
  `name` varchar(20) DEFAULT NULL COMMENT '昵称',
  `qnum` int(11) NOT NULL DEFAULT '0' COMMENT '推荐人数',
  `user_is_true` int(1) NOT NULL DEFAULT '0' COMMENT '默认为0 为1已经通过签约认证',
  `user_sfz` bigint(19) NOT NULL COMMENT '用户身份证号',
  `user_sj_yhk` bigint(30) NOT NULL COMMENT '用户开银行卡所留手机号',
  `bankhanghao` varchar(20) DEFAULT NULL COMMENT '银行编号',
  `bank_yh_dm` char(20) NOT NULL COMMENT '银行代码',
  `status` tinyint(1) DEFAULT '1' COMMENT '用户状态：1正常2禁用',
  `head_img` varchar(255) DEFAULT NULL,
  `sex` tinyint(1) DEFAULT '0' COMMENT '1男2女3保密',
  `location` varchar(80) DEFAULT NULL COMMENT '坐标地址',
  `location_x` varchar(80) DEFAULT NULL COMMENT '坐标x',
  `location_y` varchar(80) DEFAULT NULL COMMENT '坐标Y',
  `wechat_number` varchar(80) DEFAULT NULL COMMENT '微信号',
  `address` varchar(255) DEFAULT NULL COMMENT '收货地址',
  `alipay_img` varchar(255) DEFAULT NULL COMMENT '支付宝收款图片',
  `wechat_img` varchar(255) DEFAULT NULL COMMENT '微信收款图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of u_user
-- ----------------------------
INSERT INTO `u_user` VALUES ('1', '111', '698d51a19d8a121ce581499d7b701668', '111', '11111111111', '0', 'QMSCU8TS46', '中国农业银行', null, null, '1', null, '4', '2', '3', '5', null, '2869.00', '1024', '1945', null, '275.00', '1', '61.243.165.7', '1544836576', '1544156248', '1', '老大', '40', '1', '0', '0', '1002', '', '1', '234234', '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('26', 'zjy', 'dc483e80a7a0bd9ef71d8cf973673924', 'a123456', '13998551688', '1', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '2', '175.163.244.113', '0', '1544156248', '1', null, '6', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('27', '16161818', '5fa3155d8ae6bbadac774a7d42bb41c5', 'wang198788', '13889595813', '1', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '1', '223.104.176.198', '0', '1544156720', '1', null, '2', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('28', '045045', '446026658e95ecf02fe4cd9b7ffb69ba', 'wzx045', '18640136686', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '175.167.138.203', '0', '1544160204', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('29', 'xmd88888', 'c1ae11c4b3e718b5d9090d29a429431e', 'xmd99818xmd', '15638827794', '1', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '2', '117.136.24.186', '0', '1544161134', '1', null, '5', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('30', '17693284997', '552008cb6e6460ce6591f6547abfbd17', 'wwww123456', '17693284997', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '180.95.131.49', '0', '1544161405', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('31', '15553462736', 'b2e75931dcc8ff3556b17482319d7438', 'wang121212', '15553462736', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '112.224.32.161', '0', '1544162554', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('32', 'qhl578578', 'b33c81da1b5ac339242be324c05ad105', 'quhongliang888', '15354734880', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '222.168.201.157', '0', '1544162621', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('33', 'xmm1688', '772a0f9a5983db416434c4b55ed7dbdf', 'xmm0508', '15557808520', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '223.104.246.234', '0', '1544164115', '1', null, '1', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('34', 'ChenJixu6', '1d4f903cff68c93f3b775f6783d7e1c4', 'Ss666666', '18909852211', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '42.248.33.206', '0', '1544164326', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('35', 'zjy-1', 'dc483e80a7a0bd9ef71d8cf973673924', 'a123456', '18940888881', '26', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '2', '42.249.9.162', '0', '1544165909', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('36', 'zr0301', '14e1a0f21b9db349a2438f07ade3e470', 'zr0301', '15638155112', '1', null, '', null, null, '', null, '', '', '', '', null, '20.00', '0', '0', null, '0.00', '2', '61.158.149.202', '0', '1544166246', '1', '郑锐', '4', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('37', 'G1999', '635092b43f6daab6e117b2429f5e6236', '123456987', '17606722557', '26', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '1', '223.90.152.130', '0', '1544170239', '1', '', '2', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('38', 'lichao001', 'fe9ea64f545ac1ea83002bf8ccab9335', 'nijiadianhua', '19943510867', '26', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '101.28.211.50', '0', '1544173306', '1', null, '1', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('39', 'yuese', 'fe9ea64f545ac1ea83002bf8ccab9335', 'nijiadianhua', '15831030911', '38', null, '', null, null, '', null, '', '', '', '', null, '4.00', '0', '0', null, '0.00', '1', '36.98.128.238', '0', '1544174999', '1', null, '13', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('40', 'yuandexia', '0c32bfac89446b4718e9e2a83aad489f', 'ydx19980909', '17338480652', '33', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '36.17.46.127', '0', '1544175081', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('41', 'mwf159753', '0c2a89e9d2732ec4bee83c53e83ccfbc', 'mwf159753', '13526652226', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '182.119.211.229', '0', '1544176465', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('42', 'wx16888', 'e17b496ee6e2c742f0fe61f3d8dce130', '880110', '13027605423', '29', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '0', '223.88.77.79', '0', '1544177937', '1', '吴霞', '1', '1', '522632198202191567', '17759138957', '1004', '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('43', 'mwf574839', 'e3ff30b23739406ae42f3dfcdde18fb3', 'mwf574839', '18638258897', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '182.119.211.229', '0', '1544178128', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('44', '1314520ysw', '968517faf67dd2655097be7c836d98bb', '1314520ysw', '17385052044', '29', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '221.13.63.32', '0', '1544178334', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('45', 'lym16888', 'e17b496ee6e2c742f0fe61f3d8dce130', '880110', '17759138957', '42', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '223.88.77.134', '0', '1544178686', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('46', 'zrz88888', '25f9e794323b453885f5181f1b624d0b', '123456789', '15274604088', '29', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '117.136.24.51', '0', '1544180598', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('47', 'yxtk', 'e1420b17647b2cd7b86c340a14f70bdd', '813912', '13181109322', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '119.180.179.237', '0', '1544181519', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('48', 'gong15530098550', '1c3f07c9ab2cab12f4da3d1769caa528', 'zxcv369!', '15530098550', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '120.9.194.14', '0', '1544182490', '1', '龚路伟', '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('49', 'cj84451390', 'fcb967a7a6644bb5341756d15110aee3', 'cj125281983', '18932700981', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '106.119.30.237', '0', '1544182944', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('50', '139300ss', '05c1e23fcfeb3042a3317a03c601ce0c', '139300ss', '15100068896', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '36.98.156.205', '0', '1544183785', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('51', 'abc485672', '4f3bb080626e464464178a9ccb5fdeeb', 'abc485672', '15912672946', '26', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '39.130.21.48', '0', '1544184657', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('52', '哈哈', 'e10adc3949ba59abbe56e057f20f883e', '123456', '15630376717', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '106.119.68.124', '0', '1544185313', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('53', '484171261', 'd7b88432fc34f19a3bd83014ae6ed409', 'tgh666666', '17600509558', '26', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '61.148.244.231', '0', '1544185823', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('54', '871216', 'd467f2b5bb9f878ad9744505c921dc06', '871216', '15019465258', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '183.39.18.210', '0', '1544187914', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('55', '18533932997jie', '35c5c26f4d534e700d6314eb833f4164', '136225jie', '18533932997', '29', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '221.192.178.30', '0', '1544188134', '1', null, '1', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('56', '8862chao', '47b5642848f817c66501189c9f1facb7', '288622', '13180528862', '55', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '117.44.172.253', '0', '1544190029', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('57', 'hyx198719', 'f3da5c4e5d347d646060f492500a1dda', 'erwa198700', '15968214075', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '183.248.45.142', '0', '1544190713', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('58', '3244883921', '85d8a788ab2b7bce039e83d68217de37', 'jf5201314', '15328437295', '26', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '182.129.49.6', '0', '1544195120', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('59', 'aiaiaini', 'e10adc3949ba59abbe56e057f20f883e', '123456', '13403305432', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '223.104.101.225', '0', '1544195129', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('60', 'WGT6789', '8f54173d6e0c1a06467ae62c26d21344', 'wgt890319', '15811926678', '27', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '1', '117.61.143.83', '0', '1544231154', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('61', 'W1634018537', 'c8e6efe15060d67f209541465c984e36', 'wang1997', '15670251202', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '61.158.148.1', '0', '1544231350', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('62', 'a451251', '800e309ecaa5b3cc522246ef97b704a2', '4159878', '18339907380', '1', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '0', '121.31.251.52', '0', '1544233563', '1', '孟庆亚', '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('63', '18503227581', 'fcea920f7412b5da7be0cf42b8c93759', '1234567', '18503227581', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '183.198.47.92', '0', '1544233582', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('64', '759482yws', '3c5790dc242c5d8a31f13d5769a93de3', '759482', '18617557227', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '101.28.209.78', '0', '1544235019', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('65', 'a191839369', '187280789a585458e902a6a9702e4c38', 'lijiawei', '18732013146', '36', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '110.248.39.196', '0', '1544238670', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('66', 'as000518', '4326ff5c86670b87096e89616f2de248', 'Dl158520', '17662656662', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '112.224.2.73', '0', '1544240104', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('67', '18012403426', 'f574232ce5830fad4e375cc8e8c5f19d', '18012403426', '18012403426', '1', null, '', null, null, '', null, '', '', '', '', null, '8.00', '0', '0', null, '0.00', '1', '49.90.19.150', '0', '0', '1', null, '1', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('69', '751227jhx', '6332792b92ac0942fe63767426729a6c', 'jhx751227', '18830001071', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '221.192.178.42', '0', '1544240405', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('70', '17712446842', 'f644ff082e0417c29b6cfa218bb1859a', 'chunlin0719', '17712446842', '67', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '49.90.43.169', '0', '1544241021', '1', null, '2', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('71', '15852461585', 'f644ff082e0417c29b6cfa218bb1859a', 'chunlin0719', '15852461585', '70', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '49.90.43.169', '0', '1544241497', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('72', 'ad', '92687e0d99474b4f9bae88423384761a', 'my888888', '13100297366', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '49.119.233.123', '0', '1544242391', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('73', 'QQ7715301', 'a0181cb5653d5a8b43c7f147693bab2a', '495218', '18779610941', '37', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '118.212.199.224', '0', '1544246399', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('74', 'zhj15295983258', '6f944e76fc2b94a358f193cc57703af6', '15295983258zhj', '18978352320', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '171.104.253.71', '0', '1544247392', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('75', '13764958610', 'ef82b2953c4140406b23bc6d01e85431', 'yzx325111', '13764958610', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '116.228.231.99', '0', '1544248396', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('76', 'tf0912', 'a2907e2044b1f10b889019a0e4c8eec5', 'mic2255880', '15184260912', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '112.41.207.149', '0', '1544250507', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('77', '123456', '427842179036a6279df7f9b3084361de', 'aiziji', '13315055770', '36', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '106.117.177.43', '0', '1544250759', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('78', 'c3191866609', 'd30b6a4d9e94cbb9db971c6283cfcd9e', 'chen123', '16619716172', '37', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '114.246.0.228', '0', '1544250945', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('79', '15980679588', 'bc1ae9624a706b383ec251d7a8b6225e', '5566wwll1314520', '15980679588', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '114.97.60.21', '0', '1544251686', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('80', 'wulincai762', '87d663a14553aef4523177b83b6008a0', 'wulincai587', '18907790673', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '171.109.147.213', '0', '1544252782', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('81', '威客天下1207', 'c02354d7f4c5acc4ce6c91b28226db16', '6816557nm', '13322253991', '1', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '1', '175.163.244.113', '0', '1544253417', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('82', '10000', '52575b05ebbbc88c96c9bb775f8dd04e', 'zhululu123', '17327585881', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '49.89.152.35', '0', '1544258902', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('83', 'G17081100075', 'c58597b3edddd459f3198968192afc2c', 'guozeyin183', '15133530393', '36', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '223.104.101.134', '0', '1544261378', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('84', 'cy910209', 'e6bab77a321381b319b8466a80a3f4ad', '910209', '17640298816', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '175.167.146.230', '0', '1544261746', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('85', 'ADC5Sha', '82ba56553c24b6e6bc4389cbcbcb3c59', 'HfG520', '13027629745', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '61.158.149.29', '0', '1544262608', '1', '黄凤高', '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('86', '15373114820.', '0326920934fafb1dfa588a38f2190530', '15373114820', '15373114820', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '183.198.230.73', '0', '1544263853', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('87', '李木子', 'd59e5e50ab822b520d0bf39e0595606e', 'xkk15995737012', '18236670235', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '117.136.104.227', '0', '1544264722', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('88', '', 'bcfaacab12d1fab4a912de13d99f9569', '900128', '15831626417', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '117.136.47.170', '0', '1544270557', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('89', 'r17606036184', '19f3010d80c37dd456a46482c3e72015', 'lfb184030', '17606036184', '39', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '117.24.104.201', '0', '1544274440', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('90', 'wktxwz', '09cc378274e55a2544e1ebf56587b797', 'ai18850920603', '18850970979', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '49.72.234.224', '0', '1544279159', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('93', 'yuwang05273', 'df7c775d46408bb7867de69d858a230c', '973973', '13595191242', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '120.194.80.147', '0', '1544323005', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('94', 'zww258258', '5a83a28bcfb05849ca51e1a9ed75b079', 'zww258258', '15127066881', '36', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '183.199.190.139', '0', '1544343323', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('95', 'ww889900', 'fdf4825762ef2817affa1ca44c61bc16', '417417ww', '18806581020', '27', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '36.27.8.32', '0', '1544348768', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('96', '805838822', 'ae9f486196eed0d3bf7b35214bb11e39', 'kk536383', '13062749538', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '112.64.68.24', '0', '1544351679', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('97', ' a874431568', '3c80617f52a959ce8f08c06bd922e692', 'q874431568', '17377103251', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '113.70.103.73', '0', '1544368771', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('98', 'xfwagyy', '78ac16793bc97d6bd006038ad38c3aa4', 'xfwagyy', '15669623550', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '223.104.4.81', '0', '1544407393', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('99', '15669623550', 'bbf6d63fdc6582db56d95e6734e3b514', '15669623550', '15669623550', '1', null, '', null, null, '', null, '', '', '', '', null, '0.00', '0', '0', null, '0.00', '1', '223.104.147.72', '0', '0', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('100', '38896634', '81df3083098d268b9429ee1e2ac76728', '930223930723', '15638896634', '1', null, null, null, null, '6228480719513590070', null, null, '罗坤', null, null, null, '0.00', '0', '0', null, '0.00', '0', '120.228.130.27', '0', '1544409448', '1', null, '0', '1', '431223199303152018', '15638896634', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('101', '12530', '1104959d53dc3b60f2d40cd4a47d79e7', '520520', '15570238218', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '118.212.212.17', '0', '1544412299', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('102', 'wlc906649950', 'ca6f5ac5d95aafa1b1cafaf0fd3c2f14', 'wlc464482549', '13953016397', '70', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '101.20.143.53', '0', '1544430243', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('103', 'HomeJun', '25f9e794323b453885f5181f1b624d0b', '123456789', '13026697232', '29', null, null, null, null, null, null, null, null, null, null, null, '24.00', '8', '0', null, '0.00', '2', '112.97.59.174', '0', '1544432529', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('104', '123456mm', 'bbb84446ef908c677bf8c86187acdf02', '123456mm', '13045785462', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '39.75.3.221', '0', '1544506071', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('105', '1789379505', '3a924a3b1de33150c78dad32bb070d89', 'mihuipeng', '18735388243', '1', null, null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '218.26.55.172', '0', '1544572383', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('111', '12', 'e10adc3949ba59abbe56e057f20f883e', null, '13478576995', '103', 'QME8ATT326', '中国工商银行', '1', '2', '6226220704222628', '5', '辽宁', '王洪凯', '辽宁', '大连', null, '100016.00', '70016', '30000', '', '1180.00', '1', '42.55.201.205', '1544777309', '1544630219', '1', '年休假', '11', '1', '210381199107091315', '13478576995', '1001', '', '1', '/uploads/home/20190105/6a249f0eb05ec052f2a9c16cfc694846.jpg', '1', '', '', '', '5327508962', '大连', '/uploads/home/20190105/e9e6803f5554ffa00162e120308971fc.jpg', '/uploads/home/20190105/2bb37dc94cde9b7fa906e73b76e9036a.png');
INSERT INTO `u_user` VALUES ('126', '', 'e10adc3949ba59abbe56e057f20f883e', null, '13354005488', '111', 'QM8HKID073', null, null, null, null, null, null, null, null, null, null, '2000.00', '1500', '500', null, '0.00', '0', '175.146.94.130', '0', '1545222743', '1', '洪2', '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('127', '', 'e10adc3949ba59abbe56e057f20f883e', null, '15566661884', '111', 'QM9L8SNS71', null, null, null, null, null, null, null, null, null, null, '2000.00', '1500', '500', 'alipay', '300.00', '0', '175.167.146.32', '1546582626', '1545619163', '1', '22222', '0', '0', '0', '0', null, '', '1', '/uploads/home/20190104/53810b5b0ca02cc8d007f06e2b6fe738.png', '2', '2222', null, null, '77673816', '2222', '/uploads/home/20190104/746391b06f638780e42b2163153267af.png', '/uploads/home/20190104/8b5d1e81c58b7ead31a068241e8dab6b.png');
INSERT INTO `u_user` VALUES ('128', '', '25d55ad283aa400af464c76d713c07ad', null, '18624393950', '111', 'QM723NJO24', null, null, null, null, null, null, null, null, null, null, '2000.00', '1500', '500', null, '0.00', '0', '119.109.41.58', '1546666201', '1545917419', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);
INSERT INTO `u_user` VALUES ('151', '', 'e10adc3949ba59abbe56e057f20f883e', null, '13354005489', '111', 'QM47DRQM80', null, null, null, null, null, null, null, null, null, null, '0.00', '0', '0', null, '0.00', '0', '61.243.165.7', '0', '1546588675', '1', null, '0', '0', '0', '0', null, '', '1', null, '0', null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for u_user_bank
-- ----------------------------
DROP TABLE IF EXISTS `u_user_bank`;
CREATE TABLE `u_user_bank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `bank_card` varchar(40) DEFAULT NULL COMMENT '身份证号',
  `bank_phone` varchar(40) DEFAULT NULL COMMENT '预留手机号',
  `bank_id` int(11) DEFAULT NULL COMMENT '所属行',
  `bank_num` varchar(40) DEFAULT NULL COMMENT '银行卡号',
  `bank_type` varchar(40) DEFAULT '1' COMMENT '卡类型',
  `add_time` int(11) DEFAULT '0',
  `is_delete` varchar(255) DEFAULT '0' COMMENT '0未删除 1已删除',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='用户银行卡表';

-- ----------------------------
-- Records of u_user_bank
-- ----------------------------
INSERT INTO `u_user_bank` VALUES ('3', '111', '1', '13478576995', '3', '4', '借记卡', '0', '1');
INSERT INTO `u_user_bank` VALUES ('2', '111', '1', '13478576995', '2', '3', '储蓄卡', '0', '0');
INSERT INTO `u_user_bank` VALUES ('4', '127', '2222', '15566661884', '3', '123', '借记卡', '1546397683', '0');
INSERT INTO `u_user_bank` VALUES ('5', '127', '123123', '15566561884', '4', '123123', '借记卡', '1546397847', '0');
INSERT INTO `u_user_bank` VALUES ('6', '127', '3333', '15566661234', '3', '2222', '借记卡', '1546401500', '0');

-- ----------------------------
-- Table structure for u_user_give_vip
-- ----------------------------
DROP TABLE IF EXISTS `u_user_give_vip`;
CREATE TABLE `u_user_give_vip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0' COMMENT '用户id',
  `give_day` int(11) DEFAULT '0' COMMENT '赠送天数',
  `give_level` tinyint(4) DEFAULT '1' COMMENT '赠送等级',
  `add_time` int(11) DEFAULT '0' COMMENT '赠送时间',
  `end_time` int(11) DEFAULT '0' COMMENT '到期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='赠送VIP';

-- ----------------------------
-- Records of u_user_give_vip
-- ----------------------------
INSERT INTO `u_user_give_vip` VALUES ('93', '126', '7', '1', '1545222743', '1545827543');
INSERT INTO `u_user_give_vip` VALUES ('94', '127', '7', '1', '1545619163', '1546223963');
INSERT INTO `u_user_give_vip` VALUES ('95', '128', '7', '1', '1545917419', '1546522219');
INSERT INTO `u_user_give_vip` VALUES ('97', '131', '7', '1', '1546566908', '1547171708');
INSERT INTO `u_user_give_vip` VALUES ('98', '132', '7', '1', '1546568149', '1547172949');
INSERT INTO `u_user_give_vip` VALUES ('99', '133', '7', '1', '1546568425', '1547173225');
INSERT INTO `u_user_give_vip` VALUES ('113', '148', '7', '1', '1546588243', '1547193043');
INSERT INTO `u_user_give_vip` VALUES ('116', '151', '7', '1', '1546588675', '1547193475');

-- ----------------------------
-- Table structure for u_user_relation_vip_log
-- ----------------------------
DROP TABLE IF EXISTS `u_user_relation_vip_log`;
CREATE TABLE `u_user_relation_vip_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(11) DEFAULT '0' COMMENT '关系等级',
  `user_id` int(11) DEFAULT '0' COMMENT '会员id',
  `child_id` int(11) DEFAULT '0' COMMENT '下级id',
  `add_time` int(11) DEFAULT '0' COMMENT '邀请时间',
  `money` decimal(10,2) DEFAULT '0.00' COMMENT '佣金提成金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of u_user_relation_vip_log
-- ----------------------------
INSERT INTO `u_user_relation_vip_log` VALUES ('17', '1', '111', '126', '1545222743', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('18', '1', '111', '127', '1545619163', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('19', '1', '111', '128', '1545917419', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('21', '1', '1', '131', '1546566908', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('22', '1', '1', '132', '1546568149', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('23', '1', '1', '133', '1546568425', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('24', '1', '111', '148', '1546588243', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('25', '2', '103', '148', '1546588243', '4.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('26', '1', '111', '151', '1546588675', '8.00');
INSERT INTO `u_user_relation_vip_log` VALUES ('27', '2', '103', '151', '1546588675', '4.00');