/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50505
Source Host           : localhost:33060
Source Database       : yike

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

Date: 2018-12-28 13:04:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `fs_user`
-- ----------------------------
DROP TABLE IF EXISTS `fs_user`;
CREATE TABLE `fs_user` (
  `id` int(13) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `user_id` varchar(20) NOT NULL COMMENT '隐藏id',
  `agent` varchar(20) DEFAULT NULL COMMENT '代理',
  `register_time` datetime DEFAULT NULL,
  `balance` decimal(12,2) DEFAULT 0.00 COMMENT '余额',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_charge_time` datetime DEFAULT NULL COMMENT '最后入款时间',
  `last_refund_time` datetime DEFAULT NULL COMMENT '最后出款时间',
  `ip` varchar(20) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `lev` varchar(20) DEFAULT NULL COMMENT '级层',
  `true_name` varchar(30) DEFAULT NULL COMMENT '本人姓名',
  `true_id` varchar(30) DEFAULT NULL COMMENT '本人身份证',
  `phone_num` varchar(20) DEFAULT NULL,
  `qq` varchar(30) DEFAULT NULL,
  `mail` varchar(50) DEFAULT NULL,
  `province` varchar(30) DEFAULT NULL,
  `city` varchar(30) DEFAULT NULL,
  `bank_name` varchar(20) DEFAULT NULL,
  `bank_num` varchar(30) DEFAULT NULL,
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `site_id` int(20) DEFAULT NULL COMMENT '该用户属所网站的id',
  `deposit_count` decimal(12,2) DEFAULT 0.00 COMMENT '存款次数',
  `deposit_max` decimal(12,2) DEFAULT 0.00 COMMENT '最大存款额度',
  `deposit_total` decimal(12,2) DEFAULT 0.00 COMMENT '存款总额',
  `withdrawal_count` decimal(12,2) DEFAULT 0.00 COMMENT '提款次数',
  `withdrawal_total` decimal(12,2) DEFAULT 0.00 COMMENT '提款总数',
  `multiple` decimal(8,4) DEFAULT 0.0000 COMMENT '倍数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_number` (`username`,`site_id`) USING BTREE,
  KEY `index_agent` (`agent`) USING BTREE,
  KEY `index_uername` (`username`) USING BTREE,
  KEY `index_name` (`deposit_total`,`multiple`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of fs_user
-- ----------------------------
INSERT INTO `fs_user` VALUES ('51', 'Jamarcus', '1', '上海平台1', '2017-05-06 07:46:10', '10000.00', '2017-05-06 07:46:10', '2017-05-06 07:46:10', '2017-05-06 07:46:10', '', '', '', 'Mrs. Jade Thiel V', '', '+8618911392274', '', '', '', '', '', '', '', null, '73.00', '6756.00', '5723.00', '2.00', '810.00', '0.0000');
INSERT INTO `fs_user` VALUES ('52', 'Horace', '4', '北京平台2', '2008-12-19 06:04:25', '10000.00', '2008-12-19 06:04:25', '2008-12-19 06:04:25', '2008-12-19 06:04:25', '', '', '', 'Nicole King I', '', '+8618911392274', '', '', '', '', '', '', '', null, '80.00', '8003.00', '8570.00', '1.00', '107.00', '0.0000');
INSERT INTO `fs_user` VALUES ('53', 'Josefa', '2', '上海平台1', '1970-07-24 20:55:46', '10000.00', '1970-07-24 20:55:46', '1970-07-24 20:55:46', '1970-07-24 20:55:46', '', '', '', 'Miss Yvette Adams', '', '+8618911392274', '', '', '', '', '', '', '', null, '92.00', '304.00', '1707.00', '2.00', '58.00', '0.0000');
INSERT INTO `fs_user` VALUES ('54', 'Neil', '2', '广州平台4', '2013-05-08 18:32:07', '10000.00', '2013-05-08 18:32:07', '2013-05-08 18:32:07', '2013-05-08 18:32:07', '', '', '', 'Eulalia Hahn Sr.', '', '+8618911392274', '', '', '', '', '', '', '', null, '37.00', '2161.00', '5583.00', '4.00', '154.00', '0.0000');
INSERT INTO `fs_user` VALUES ('55', 'Emelie', '2', '上海平台1', '1970-10-01 04:20:16', '10000.00', '1970-10-01 04:20:16', '1970-10-01 04:20:16', '1970-10-01 04:20:16', '', '', '', 'Johan Miller', '', '+8618911392274', '', '', '', '', '', '', '', null, '48.00', '2370.00', '9852.00', '4.00', '176.00', '0.0000');
INSERT INTO `fs_user` VALUES ('56', 'Ana', '4', '广州平台4', '2013-01-12 15:46:38', '10000.00', '2013-01-12 15:46:38', '2013-01-12 15:46:38', '2013-01-12 15:46:38', '', '', '', 'Hillary Larson', '', '+8618911392274', '', '', '', '', '', '', '', null, '35.00', '9801.00', '5157.00', '2.00', '128.00', '0.0000');
INSERT INTO `fs_user` VALUES ('57', 'Madelynn', '2', '上海平台1', '1974-01-13 04:09:09', '10000.00', '1974-01-13 04:09:09', '1974-01-13 04:09:09', '1974-01-13 04:09:09', '', '', '', 'Mrs. Hettie Weber', '', '+8618911392274', '', '', '', '', '', '', '', null, '53.00', '9736.00', '6196.00', '2.00', '633.00', '0.0000');
INSERT INTO `fs_user` VALUES ('58', 'Mitchell', '1', '深圳平台5', '1978-12-26 17:27:18', '10000.00', '1978-12-26 17:27:18', '1978-12-26 17:27:18', '1978-12-26 17:27:18', '', '', '', 'Edgar Barrows', '', '+8618911392274', '', '', '', '', '', '', '', null, '45.00', '579.00', '3877.00', '1.00', '690.00', '0.0000');
INSERT INTO `fs_user` VALUES ('59', 'Dena', '1', '广州平台4', '2005-09-07 06:54:28', '10000.00', '2005-09-07 06:54:28', '2005-09-07 06:54:28', '2005-09-07 06:54:28', '', '', '', 'Prof. Mina Ryan III', '', '+8618911392274', '', '', '', '', '', '', '', null, '57.00', '3284.00', '9655.00', '3.00', '800.00', '0.0000');
INSERT INTO `fs_user` VALUES ('60', 'Christelle', '4', '广州平台4', '2004-01-03 11:34:32', '10000.00', '2004-01-03 11:34:32', '2004-01-03 11:34:32', '2004-01-03 11:34:32', '', '', '', 'Dr. Wendell Mohr DVM', '', '+8618911392274', '', '', '', '', '', '', '', null, '64.00', '1265.00', '5303.00', '3.00', '785.00', '0.0000');
INSERT INTO `fs_user` VALUES ('61', 'Dejon', '4', '深圳平台5', '1973-09-02 01:45:14', '10000.00', '1973-09-02 01:45:14', '1973-09-02 01:45:14', '1973-09-02 01:45:14', '', '', '', 'Dr. Chandler Schiller II', '', '+8618911392274', '', '', '', '', '', '', '', null, '36.00', '3378.00', '441.00', '2.00', '771.00', '0.0000');
INSERT INTO `fs_user` VALUES ('62', 'Macy', '4', '北京平台2', '2000-11-17 23:24:20', '10000.00', '2000-11-17 23:24:20', '2000-11-17 23:24:20', '2000-11-17 23:24:20', '', '', '', 'Alexandria Senger', '', '+8618911392274', '', '', '', '', '', '', '', null, '63.00', '4572.00', '5805.00', '3.00', '446.00', '0.0000');
INSERT INTO `fs_user` VALUES ('63', 'Kelvin', '3', '广州平台4', '1983-03-29 17:32:00', '10000.00', '1983-03-29 17:32:00', '1983-03-29 17:32:00', '1983-03-29 17:32:00', '', '', '', 'Mrs. Lacey Reynolds V', '', '+8618911392274', '', '', '', '', '', '', '', null, '11.00', '3133.00', '8310.00', '1.00', '358.00', '0.0000');
INSERT INTO `fs_user` VALUES ('64', 'Abelardo', '2', '广州平台4', '1984-03-02 09:04:32', '10000.00', '1984-03-02 09:04:32', '1984-03-02 09:04:32', '1984-03-02 09:04:32', '', '', '', 'Mr. Verner Labadie PhD', '', '+8618911392274', '', '', '', '', '', '', '', null, '8.00', '6864.00', '4193.00', '3.00', '339.00', '0.0000');
INSERT INTO `fs_user` VALUES ('65', 'Jabari', '3', '广州平台4', '1974-10-15 18:53:32', '10000.00', '1974-10-15 18:53:32', '1974-10-15 18:53:32', '1974-10-15 18:53:32', '', '', '', 'Dr. Arjun Corkery MD', '', '+8618911392274', '', '', '', '', '', '', '', null, '53.00', '6921.00', '8899.00', '2.00', '509.00', '0.0000');
INSERT INTO `fs_user` VALUES ('66', 'Davonte', '3', '上海平台1', '2009-03-28 22:38:11', '10000.00', '2009-03-28 22:38:11', '2009-03-28 22:38:11', '2009-03-28 22:38:11', '', '', '', 'Julie Doyle', '', '+8618911392274', '', '', '', '', '', '', '', null, '30.00', '4973.00', '9229.00', '0.00', '745.00', '0.0000');
INSERT INTO `fs_user` VALUES ('67', 'Loy', '1', '上海平台1', '1973-11-09 02:29:17', '10000.00', '1973-11-09 02:29:17', '1973-11-09 02:29:17', '1973-11-09 02:29:17', '', '', '', 'Mrs. Ozella Mertz', '', '+8618911392274', '', '', '', '', '', '', '', null, '82.00', '6383.00', '8735.00', '4.00', '259.00', '0.0000');
INSERT INTO `fs_user` VALUES ('68', 'Karlie', '4', '广州平台4', '2010-07-25 09:07:25', '10000.00', '2010-07-25 09:07:25', '2010-07-25 09:07:25', '2010-07-25 09:07:25', '', '', '', 'Corrine Schulist', '', '+8618911392274', '', '', '', '', '', '', '', null, '3.00', '4860.00', '4687.00', '4.00', '343.00', '0.0000');
INSERT INTO `fs_user` VALUES ('69', 'Micah', '3', '深圳平台5', '1999-12-26 19:41:35', '10000.00', '1999-12-26 19:41:35', '1999-12-26 19:41:35', '1999-12-26 19:41:35', '', '', '', 'Mr. Jerome Ankunding', '', '+8618911392274', '', '', '', '', '', '', '', null, '6.00', '9266.00', '3400.00', '2.00', '701.00', '0.0000');
INSERT INTO `fs_user` VALUES ('70', 'Elvera', '3', '北京平台2', '1989-02-03 05:45:09', '10000.00', '1989-02-03 05:45:09', '1989-02-03 05:45:09', '1989-02-03 05:45:09', '', '', '', 'Aleen Dare Jr.', '', '+8618911392274', '', '', '', '', '', '', '', null, '26.00', '2001.00', '4030.00', '4.00', '985.00', '0.0000');
INSERT INTO `fs_user` VALUES ('71', 'Brian', '2', '武汉平台3', '1977-04-13 04:02:50', '10000.00', '1977-04-13 04:02:50', '1977-04-13 04:02:50', '1977-04-13 04:02:50', '', '', '', 'Andres Franecki MD', '', '+8618911392274', '', '', '', '', '', '', '', null, '63.00', '8062.00', '2455.00', '3.00', '169.00', '0.0000');
INSERT INTO `fs_user` VALUES ('72', 'Hailie', '2', '上海平台1', '2008-05-02 14:38:30', '10000.00', '2008-05-02 14:38:30', '2008-05-02 14:38:30', '2008-05-02 14:38:30', '', '', '', 'Emile Barrows', '', '+8618911392274', '', '', '', '', '', '', '', null, '62.00', '7586.00', '5542.00', '4.00', '209.00', '0.0000');
INSERT INTO `fs_user` VALUES ('73', 'Christopher', '4', '深圳平台5', '2000-01-12 18:18:35', '10000.00', '2000-01-12 18:18:35', '2000-01-12 18:18:35', '2000-01-12 18:18:35', '', '', '', 'Mrs. Emilia Fritsch', '', '+8618911392274', '', '', '', '', '', '', '', null, '47.00', '7533.00', '8368.00', '4.00', '429.00', '0.0000');
INSERT INTO `fs_user` VALUES ('74', 'Lera', '3', '广州平台4', '1986-11-24 14:02:57', '10000.00', '1986-11-24 14:02:57', '1986-11-24 14:02:57', '1986-11-24 14:02:57', '', '', '', 'Ms. Oceane Lang', '', '+8618911392274', '', '', '', '', '', '', '', null, '11.00', '6148.00', '6645.00', '1.00', '81.00', '0.0000');
INSERT INTO `fs_user` VALUES ('75', 'Cooper', '1', '武汉平台3', '1999-09-19 09:09:19', '10000.00', '1999-09-19 09:09:19', '1999-09-19 09:09:19', '1999-09-19 09:09:19', '', '', '', 'Miss Rosalia Kutch', '', '+8618911392274', '', '', '', '', '', '', '', null, '85.00', '4887.00', '7690.00', '3.00', '802.00', '0.0000');
INSERT INTO `fs_user` VALUES ('76', 'Josefina', '1', '上海平台1', '1987-01-21 10:30:22', '10000.00', '1987-01-21 10:30:22', '1987-01-21 10:30:22', '1987-01-21 10:30:22', '', '', '', 'Domenic Hartmann', '', '+8618911392274', '', '', '', '', '', '', '', null, '25.00', '9061.00', '1895.00', '3.00', '282.00', '0.0000');
INSERT INTO `fs_user` VALUES ('77', 'Carolyn', '4', '武汉平台3', '1987-10-15 08:04:32', '10000.00', '1987-10-15 08:04:32', '1987-10-15 08:04:32', '1987-10-15 08:04:32', '', '', '', 'Noel Turcotte V', '', '+8618911392274', '', '', '', '', '', '', '', null, '19.00', '1632.00', '8316.00', '4.00', '688.00', '0.0000');
INSERT INTO `fs_user` VALUES ('78', 'Loyce', '2', '武汉平台3', '2016-11-01 07:25:10', '10000.00', '2016-11-01 07:25:10', '2016-11-01 07:25:10', '2016-11-01 07:25:10', '', '', '', 'Arnold Macejkovic', '', '+8618911392274', '', '', '', '', '', '', '', null, '13.00', '7655.00', '9696.00', '0.00', '32.00', '0.0000');
INSERT INTO `fs_user` VALUES ('79', 'Kathleen', '2', '深圳平台5', '1971-08-24 13:07:13', '10000.00', '1971-08-24 13:07:13', '1971-08-24 13:07:13', '1971-08-24 13:07:13', '', '', '', 'Prof. Josiah Kassulke', '', '+8618911392274', '', '', '', '', '', '', '', null, '49.00', '5414.00', '3634.00', '4.00', '408.00', '0.0000');
INSERT INTO `fs_user` VALUES ('80', 'Jaime', '4', '广州平台4', '1977-07-01 05:19:11', '10000.00', '1977-07-01 05:19:11', '1977-07-01 05:19:11', '1977-07-01 05:19:11', '', '', '', 'Odie McClure DDS', '', '+8618911392274', '', '', '', '', '', '', '', null, '95.00', '7723.00', '8396.00', '1.00', '154.00', '0.0000');
INSERT INTO `fs_user` VALUES ('81', 'Maureen', '4', '北京平台2', '1983-10-10 05:54:17', '10000.00', '1983-10-10 05:54:17', '1983-10-10 05:54:17', '1983-10-10 05:54:17', '', '', '', 'Valentine Kuhlman', '', '+8618911392274', '', '', '', '', '', '', '', null, '26.00', '8084.00', '109.00', '3.00', '128.00', '0.0000');
INSERT INTO `fs_user` VALUES ('82', 'Iva', '3', '广州平台4', '2000-01-06 14:01:59', '10000.00', '2000-01-06 14:01:59', '2000-01-06 14:01:59', '2000-01-06 14:01:59', '', '', '', 'Kristina Schaefer V', '', '+8618911392274', '', '', '', '', '', '', '', null, '7.00', '1834.00', '3825.00', '4.00', '415.00', '0.0000');
INSERT INTO `fs_user` VALUES ('83', 'Anissa', '3', '北京平台2', '1986-09-11 19:10:13', '10000.00', '1986-09-11 19:10:13', '1986-09-11 19:10:13', '1986-09-11 19:10:13', '', '', '', 'Elbert Klocko', '', '+8618911392274', '', '', '', '', '', '', '', null, '51.00', '3585.00', '2282.00', '3.00', '505.00', '0.0000');
INSERT INTO `fs_user` VALUES ('84', 'Casandra', '4', '深圳平台5', '2009-07-07 19:14:30', '10000.00', '2009-07-07 19:14:30', '2009-07-07 19:14:30', '2009-07-07 19:14:30', '', '', '', 'Judson Heathcote II', '', '+8618911392274', '', '', '', '', '', '', '', null, '60.00', '9602.00', '7434.00', '2.00', '464.00', '0.0000');
INSERT INTO `fs_user` VALUES ('85', 'Kirstin', '4', '北京平台2', '2002-10-27 15:20:32', '10000.00', '2002-10-27 15:20:32', '2002-10-27 15:20:32', '2002-10-27 15:20:32', '', '', '', 'Ayana Braun Sr.', '', '+8618911392274', '', '', '', '', '', '', '', null, '82.00', '4279.00', '5665.00', '0.00', '347.00', '0.0000');
INSERT INTO `fs_user` VALUES ('86', 'Brigitte', '4', '上海平台1', '2017-02-25 00:57:25', '10000.00', '2017-02-25 00:57:25', '2017-02-25 00:57:25', '2017-02-25 00:57:25', '', '', '', 'Tyrese Stokes', '', '+8618911392274', '', '', '', '', '', '', '', null, '12.00', '4479.00', '3693.00', '0.00', '256.00', '0.0000');
INSERT INTO `fs_user` VALUES ('87', 'Aiyana', '4', '深圳平台5', '2016-09-13 22:41:32', '10000.00', '2016-09-13 22:41:32', '2016-09-13 22:41:32', '2016-09-13 22:41:32', '', '', '', 'Citlalli Rau', '', '+8618911392274', '', '', '', '', '', '', '', null, '23.00', '6225.00', '9151.00', '1.00', '122.00', '0.0000');
INSERT INTO `fs_user` VALUES ('88', 'Sarina', '4', '武汉平台3', '1980-11-10 05:10:11', '10000.00', '1980-11-10 05:10:11', '1980-11-10 05:10:11', '1980-11-10 05:10:11', '', '', '', 'Garfield Hackett', '', '+8618911392274', '', '', '', '', '', '', '', null, '8.00', '6530.00', '1885.00', '4.00', '930.00', '0.0000');
INSERT INTO `fs_user` VALUES ('89', 'Ramon', '3', '上海平台1', '1970-04-05 04:35:27', '10000.00', '1970-04-05 04:35:27', '1970-04-05 04:35:27', '1970-04-05 04:35:27', '', '', '', 'Dr. Meagan Blanda', '', '+8618911392274', '', '', '', '', '', '', '', null, '86.00', '3213.00', '1309.00', '2.00', '512.00', '0.0000');
INSERT INTO `fs_user` VALUES ('90', 'Milan', '1', '上海平台1', '1992-01-15 08:08:51', '10000.00', '1992-01-15 08:08:51', '1992-01-15 08:08:51', '1992-01-15 08:08:51', '', '', '', 'Mr. Ernest Johns Sr.', '', '+8618911392274', '', '', '', '', '', '', '', null, '74.00', '2286.00', '7140.00', '3.00', '611.00', '0.0000');
INSERT INTO `fs_user` VALUES ('91', 'Rachel', '4', '北京平台2', '2012-07-31 15:09:10', '10000.00', '2012-07-31 15:09:10', '2012-07-31 15:09:10', '2012-07-31 15:09:10', '', '', '', 'Della Schroeder', '', '+8618911392274', '', '', '', '', '', '', '', null, '77.00', '4517.00', '9487.00', '4.00', '320.00', '0.0000');
INSERT INTO `fs_user` VALUES ('92', 'Erik', '4', '广州平台4', '1981-04-21 23:33:26', '10000.00', '1981-04-21 23:33:26', '1981-04-21 23:33:26', '1981-04-21 23:33:26', '', '', '', 'Kian Schulist', '', '+8618911392274', '', '', '', '', '', '', '', null, '26.00', '7048.00', '6836.00', '2.00', '130.00', '0.0000');
INSERT INTO `fs_user` VALUES ('93', 'Charity', '3', '深圳平台5', '2005-03-18 21:42:48', '10000.00', '2005-03-18 21:42:48', '2005-03-18 21:42:48', '2005-03-18 21:42:48', '', '', '', 'Elbert Lynch', '', '+8618911392274', '', '', '', '', '', '', '', null, '39.00', '5863.00', '4845.00', '1.00', '162.00', '0.0000');
INSERT INTO `fs_user` VALUES ('94', 'Alvina', '1', '广州平台4', '1989-12-16 09:26:50', '10000.00', '1989-12-16 09:26:50', '1989-12-16 09:26:50', '1989-12-16 09:26:50', '', '', '', 'Liza Koss', '', '+8618911392274', '', '', '', '', '', '', '', null, '35.00', '4736.00', '5395.00', '3.00', '360.00', '0.0000');
INSERT INTO `fs_user` VALUES ('95', 'Adella', '4', '深圳平台5', '1975-10-16 09:00:58', '10000.00', '1975-10-16 09:00:58', '1975-10-16 09:00:58', '1975-10-16 09:00:58', '', '', '', 'Ms. Octavia D\'Amore', '', '+8618911392274', '', '', '', '', '', '', '', null, '23.00', '5420.00', '3593.00', '1.00', '236.00', '0.0000');
INSERT INTO `fs_user` VALUES ('96', 'Retta', '4', '武汉平台3', '2018-03-30 10:35:52', '10000.00', '2018-03-30 10:35:52', '2018-03-30 10:35:52', '2018-03-30 10:35:52', '', '', '', 'Mr. Remington Grimes', '', '+8618911392274', '', '', '', '', '', '', '', null, '98.00', '4164.00', '1964.00', '2.00', '100.00', '0.0000');
INSERT INTO `fs_user` VALUES ('97', 'Ewell', '2', '广州平台4', '1993-06-26 16:06:58', '10000.00', '1993-06-26 16:06:58', '1993-06-26 16:06:58', '1993-06-26 16:06:58', '', '', '', 'Kaci Tromp', '', '+8618911392274', '', '', '', '', '', '', '', null, '22.00', '8148.00', '3697.00', '2.00', '13.00', '0.0000');
INSERT INTO `fs_user` VALUES ('98', 'Francisco', '1', '广州平台4', '1993-08-18 17:07:07', '10000.00', '1993-08-18 17:07:07', '1993-08-18 17:07:07', '1993-08-18 17:07:07', '', '', '', 'Kianna Sporer', '', '+8618911392274', '', '', '', '', '', '', '', null, '61.00', '2083.00', '8438.00', '1.00', '275.00', '0.0000');
INSERT INTO `fs_user` VALUES ('99', 'Joel', '1', '广州平台4', '2005-11-07 03:20:22', '10000.00', '2005-11-07 03:20:22', '2005-11-07 03:20:22', '2005-11-07 03:20:22', '', '', '', 'Dr. Vaughn Maggio III', '', '+8618911392274', '', '', '', '', '', '', '', null, '92.00', '2972.00', '3323.00', '1.00', '192.00', '0.0000');
INSERT INTO `fs_user` VALUES ('100', 'Ebony', '1', '武汉平台3', '1986-04-20 07:42:17', '10000.00', '1986-04-20 07:42:17', '1986-04-20 07:42:17', '1986-04-20 07:42:17', '', '', '', 'Karl Kuhlman III', '', '+8618911392274', '', '', '', '', '', '', '', null, '82.00', '150.00', '3930.00', '3.00', '14.00', '0.0000');