/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : dawei

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

Date: 2019-05-15 18:40:19
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sn_about
-- ----------------------------
DROP TABLE IF EXISTS `sn_about`;
CREATE TABLE `sn_about` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `modify_time` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='关于我们';

-- ----------------------------
-- Records of sn_about
-- ----------------------------
INSERT INTO `sn_about` VALUES ('1', '测试', '测试', '1557887464', '1557887464');

-- ----------------------------
-- Table structure for sn_admin
-- ----------------------------
DROP TABLE IF EXISTS `sn_admin`;
CREATE TABLE `sn_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `status` tinyint(1) DEFAULT '0' COMMENT '电话号码',
  `time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理列表';

-- ----------------------------
-- Records of sn_admin
-- ----------------------------
INSERT INTO `sn_admin` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '1', '1545804969');

-- ----------------------------
-- Table structure for sn_admin_login
-- ----------------------------
DROP TABLE IF EXISTS `sn_admin_login`;
CREATE TABLE `sn_admin_login` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(11) DEFAULT '1',
  `name` varchar(100) COLLATE utf8_bin DEFAULT '' COMMENT '管理员id',
  `password` varchar(100) COLLATE utf8_bin DEFAULT '' COMMENT '登录密码',
  `ip` varchar(100) COLLATE utf8_bin DEFAULT '' COMMENT '登陆ip',
  `status` tinyint(1) DEFAULT '0',
  `remark` varchar(100) COLLATE utf8_bin DEFAULT '' COMMENT '备注信息',
  `time` int(11) DEFAULT '0' COMMENT '登陆时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='管理登录记录';

-- ----------------------------
-- Records of sn_admin_login
-- ----------------------------
INSERT INTO `sn_admin_login` VALUES ('1', '1', 'admin', '123456', '127.0.0.1', '0', '登录记录', '1557820037');
INSERT INTO `sn_admin_login` VALUES ('2', '1', 'admin', '123456', '127.0.0.1', '0', '登录记录', '1557820050');
INSERT INTO `sn_admin_login` VALUES ('3', '1', 'admin', '123456', '127.0.0.1', '0', '登录记录', '1557881212');

-- ----------------------------
-- Table structure for sn_email_log
-- ----------------------------
DROP TABLE IF EXISTS `sn_email_log`;
CREATE TABLE `sn_email_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT '0' COMMENT '用户id',
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '明称',
  `email` varchar(14) COLLATE utf8_bin DEFAULT '' COMMENT '手机号码',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1成功 0失败',
  `ip` varchar(32) COLLATE utf8_bin DEFAULT '' COMMENT '客户端ip',
  `type` tinyint(1) DEFAULT '0' COMMENT '类型  0注册',
  `content` text COLLATE utf8_bin COMMENT '内容',
  `time` int(11) DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='短信|发送记录';

-- ----------------------------
-- Records of sn_email_log
-- ----------------------------
INSERT INTO `sn_email_log` VALUES ('1', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x393935363630, '1557735745');
INSERT INTO `sn_email_log` VALUES ('2', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x393539313330, '1557735782');
INSERT INTO `sn_email_log` VALUES ('3', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x313136303637, '1557735817');
INSERT INTO `sn_email_log` VALUES ('4', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x373031363636, '1557735986');
INSERT INTO `sn_email_log` VALUES ('5', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x393236373438, '1557736149');
INSERT INTO `sn_email_log` VALUES ('6', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x333035363336, '1557736158');
INSERT INTO `sn_email_log` VALUES ('7', '0', '注册', '2421516320@qq.', '1', '127.0.0.1', '1', 0x393033323932, '1557740304');
INSERT INTO `sn_email_log` VALUES ('8', '0', '注册', '2421516320@qq.', '1', '127.0.0.1', '1', 0x383232343630, '1557740479');
INSERT INTO `sn_email_log` VALUES ('9', '0', '注册', '2421516320@qq.', '1', '127.0.0.1', '1', 0x343037353334, '1557740577');

-- ----------------------------
-- Table structure for sn_flow_log
-- ----------------------------
DROP TABLE IF EXISTS `sn_flow_log`;
CREATE TABLE `sn_flow_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT '0' COMMENT '用户id',
  `order` varchar(255) COLLATE utf8_bin DEFAULT '0' COMMENT '订单编号',
  `number` decimal(11,2) DEFAULT '0.00' COMMENT '数量',
  `balance` decimal(11,2) DEFAULT '0.00' COMMENT '剩余',
  `type` tinyint(1) DEFAULT '0' COMMENT '类型 ',
  `mold` tinyint(1) DEFAULT '0' COMMENT '类型 0 加钱 1减钱',
  `time` int(11) unsigned DEFAULT '0' COMMENT '时间',
  `agent` int(11) unsigned DEFAULT '0' COMMENT '代理id',
  `staff` int(11) unsigned DEFAULT '0' COMMENT '员工id',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT '' COMMENT '备注',
  `fee` decimal(10,2) DEFAULT '0.00' COMMENT '手续费',
  `phone` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '转账用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='资金流水';

-- ----------------------------
-- Records of sn_flow_log
-- ----------------------------
INSERT INTO `sn_flow_log` VALUES ('1', '3', '201905151534506672236', '9.70', '0.00', '0', '0', '1557905690', '0', '0', '收款', '0.30', null);
INSERT INTO `sn_flow_log` VALUES ('2', '3', '201905151534507852928', '-10.00', '0.00', '0', '1', '1557905690', '0', '0', '转账', '0.00', null);

-- ----------------------------
-- Table structure for sn_notice
-- ----------------------------
DROP TABLE IF EXISTS `sn_notice`;
CREATE TABLE `sn_notice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公告标题',
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '公告内容',
  `time` int(10) DEFAULT NULL COMMENT '发布时间',
  `modify_time` int(10) DEFAULT '0' COMMENT '修改时间',
  `status` int(1) DEFAULT '0' COMMENT '状态 0启用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='公告管理';

-- ----------------------------
-- Records of sn_notice
-- ----------------------------
INSERT INTO `sn_notice` VALUES ('1', '测试公告111', '测试111', '1557882544', '1557885625', '1');

-- ----------------------------
-- Table structure for sn_price_minute
-- ----------------------------
DROP TABLE IF EXISTS `sn_price_minute`;
CREATE TABLE `sn_price_minute` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(100) CHARACTER SET utf8 DEFAULT '' COMMENT '代码',
  `open` decimal(10,2) DEFAULT '0.00' COMMENT '开盘价格',
  `close` decimal(10,2) DEFAULT '0.00' COMMENT '关盘价格',
  `highest` decimal(10,2) DEFAULT '0.00' COMMENT '最高价',
  `lowest` decimal(10,2) DEFAULT '0.00' COMMENT '最低价',
  `volume` int(10) DEFAULT '0' COMMENT '交易数量',
  `time` int(11) DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='自主股票价位信息';

-- ----------------------------
-- Records of sn_price_minute
-- ----------------------------

-- ----------------------------
-- Table structure for sn_price_set
-- ----------------------------
DROP TABLE IF EXISTS `sn_price_set`;
CREATE TABLE `sn_price_set` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_bin DEFAULT '' COMMENT '名字',
  `code` varchar(100) CHARACTER SET utf8 DEFAULT '' COMMENT '代码',
  `short` varchar(100) COLLATE utf8_bin DEFAULT '' COMMENT '短码',
  `open` decimal(10,2) DEFAULT '0.00' COMMENT '开盘',
  `wave` int(10) DEFAULT '0' COMMENT '波动价格',
  `highest` decimal(10,0) DEFAULT '0' COMMENT '最高价格',
  `lowest` decimal(10,0) DEFAULT '0' COMMENT '最低价格',
  `height_num` int(11) DEFAULT '0' COMMENT '最高销量',
  `low_num` int(11) DEFAULT '0' COMMENT '最低销量',
  `yesterday` decimal(11,0) DEFAULT '0' COMMENT '昨日收盘价（不展示）',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态设置',
  `time` int(11) DEFAULT '0' COMMENT '修改时间',
  `turnover` decimal(14,2) DEFAULT NULL COMMENT '市盈率',
  `change` float(14,2) DEFAULT NULL COMMENT '换手率',
  `market` float(14,2) DEFAULT NULL COMMENT '市盈率',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='自主股票价格设置';

-- ----------------------------
-- Records of sn_price_set
-- ----------------------------
INSERT INTO `sn_price_set` VALUES ('1', 'rino基金', '500888', 'sz500888', '30.00', '1', '90', '20', '600', '100', '0', '1', '1557899840', '0.00', '0.00', '0.00');

-- ----------------------------
-- Table structure for sn_protocol
-- ----------------------------
DROP TABLE IF EXISTS `sn_protocol`;
CREATE TABLE `sn_protocol` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_bin DEFAULT '' COMMENT '协议名称',
  `content` text COLLATE utf8_bin COMMENT '内容',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态',
  `time` int(11) unsigned DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='系统常规信息';

-- ----------------------------
-- Records of sn_protocol
-- ----------------------------

-- ----------------------------
-- Table structure for sn_recharge
-- ----------------------------
DROP TABLE IF EXISTS `sn_recharge`;
CREATE TABLE `sn_recharge` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL COMMENT '用户',
  `order` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '订单号',
  `number` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '数量',
  `fee` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '手续费',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '充值状态 0审核 1完成 2打回',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '充值接口类型',
  `pay_type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '支付类型',
  `time` int(11) NOT NULL DEFAULT '0' COMMENT '时间',
  `pay_time` int(11) NOT NULL DEFAULT '0' COMMENT '支付回调时间',
  `money_type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '币种',
  `md5info` text COLLATE utf8_bin COMMENT '加密',
  `remark` text COLLATE utf8_bin COMMENT '备注',
  `agent` int(11) unsigned DEFAULT '0' COMMENT '代理id',
  `staff` int(11) unsigned DEFAULT '0' COMMENT '员工id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='充值记录';

-- ----------------------------
-- Records of sn_recharge
-- ----------------------------
INSERT INTO `sn_recharge` VALUES ('1', '3', '201905141536127154835', '10.00', '0.00', '0', '0', '0', '1557819372', '0', '0', null, '', '0', '0');
INSERT INTO `sn_recharge` VALUES ('2', '3', '201905151040529204050', '10.00', '0.00', '0', '0', '0', '1557888052', '0', '0', null, '', '0', '0');

-- ----------------------------
-- Table structure for sn_service
-- ----------------------------
DROP TABLE IF EXISTS `sn_service`;
CREATE TABLE `sn_service` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '客服名称',
  `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系方式',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态',
  `time` int(10) DEFAULT NULL COMMENT '创建时间',
  `modify_time` int(10) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='客服管理';

-- ----------------------------
-- Records of sn_service
-- ----------------------------
INSERT INTO `sn_service` VALUES ('1', '测试', '13300000001', '1', '1557885403', '1557885989');

-- ----------------------------
-- Table structure for sn_sms_log
-- ----------------------------
DROP TABLE IF EXISTS `sn_sms_log`;
CREATE TABLE `sn_sms_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT '0' COMMENT '用户id',
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '名称',
  `phone` varchar(14) COLLATE utf8_bin DEFAULT '' COMMENT '手机号码',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1成功 0失败',
  `ip` varchar(32) COLLATE utf8_bin DEFAULT '' COMMENT '客户端ip',
  `type` tinyint(1) DEFAULT '0' COMMENT '类型  0注册',
  `content` text COLLATE utf8_bin COMMENT '内容',
  `time` int(11) DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='短信|发送记录';

-- ----------------------------
-- Records of sn_sms_log
-- ----------------------------
INSERT INTO `sn_sms_log` VALUES ('1', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x393935363630, '1557735745');
INSERT INTO `sn_sms_log` VALUES ('2', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x393539313330, '1557735782');
INSERT INTO `sn_sms_log` VALUES ('3', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x313136303637, '1557735817');
INSERT INTO `sn_sms_log` VALUES ('4', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x373031363636, '1557735986');
INSERT INTO `sn_sms_log` VALUES ('5', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x393236373438, '1557736149');
INSERT INTO `sn_sms_log` VALUES ('6', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x333035363336, '1557736158');
INSERT INTO `sn_sms_log` VALUES ('7', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x383135343032, '1557740392');
INSERT INTO `sn_sms_log` VALUES ('8', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x343932333736, '1557740422');
INSERT INTO `sn_sms_log` VALUES ('9', '0', '注册', '15238905182', '1', '127.0.0.1', '1', 0x363538343632, '1557740927');

-- ----------------------------
-- Table structure for sn_system
-- ----------------------------
DROP TABLE IF EXISTS `sn_system`;
CREATE TABLE `sn_system` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `turn_fee` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT '转账手续费',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='系统设置';

-- ----------------------------
-- Records of sn_system
-- ----------------------------
INSERT INTO `sn_system` VALUES ('1', '0.0300');

-- ----------------------------
-- Table structure for sn_user
-- ----------------------------
DROP TABLE IF EXISTS `sn_user`;
CREATE TABLE `sn_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8_bin DEFAULT '' COMMENT '用户昵称',
  `number` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户编号',
  `real_name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '真实名称',
  `password` varchar(35) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密码',
  `safety_password` varchar(35) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '安全密码',
  `phone` varchar(13) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '手机号码',
  `card_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '证件类型 0为身份证 1为护照 2台胞证 3港澳台同行证',
  `card` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '身份证号',
  `email` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '邮箱',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户状态 0为正常 1为禁用',
  `create_time` int(11) DEFAULT '0' COMMENT '注册时间',
  `ip` varchar(50) COLLATE utf8_bin DEFAULT '' COMMENT '注册ip',
  `token` varchar(50) COLLATE utf8_bin DEFAULT '' COMMENT 'token',
  `update_time` int(11) unsigned DEFAULT '0' COMMENT '修改时间',
  `login_time` int(11) DEFAULT '0' COMMENT '登录时间',
  `login_ip` varchar(30) COLLATE utf8_bin DEFAULT '' COMMENT '登录ip',
  `reid` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户表';

-- ----------------------------
-- Records of sn_user
-- ----------------------------
INSERT INTO `sn_user` VALUES ('3', '', '64O82H7', '小张嘎', '3862119ed0624608c49fe8274c843328', '3862119ed0624608c49fe8274c843328', '15238905182', '127', '1', '2421516320@qq.com', '0', '1557742264', '127.0.0.1', 'e705517aa9ddb8e4557ef813e7fbb66a', '0', '1557815718', '127.0.0.1', '0');

-- ----------------------------
-- Table structure for sn_user_account
-- ----------------------------
DROP TABLE IF EXISTS `sn_user_account`;
CREATE TABLE `sn_user_account` (
  `uid` int(11) NOT NULL,
  `account` decimal(11,2) DEFAULT '0.00' COMMENT '账号余额',
  `withdraw` decimal(11,2) DEFAULT '0.00' COMMENT '可提现',
  `regular` decimal(11,2) DEFAULT '0.00' COMMENT '定期',
  `current` decimal(11,2) DEFAULT '0.00' COMMENT '活期',
  `rec_total` decimal(11,2) DEFAULT '0.00' COMMENT '充值总额',
  `wit_total` decimal(11,2) DEFAULT '0.00' COMMENT '提现总额',
  `wit_fee` decimal(11,2) DEFAULT '0.00' COMMENT '提现手续费',
  `trade_total` decimal(11,2) DEFAULT '0.00' COMMENT '交易总额',
  `manage_total` decimal(11,2) DEFAULT '0.00' COMMENT '管理费',
  `deferred_total` decimal(11,2) DEFAULT '0.00' COMMENT '递延费',
  `push_total` decimal(11,2) DEFAULT '0.00' COMMENT '用户推广费',
  `server_total` decimal(11,2) DEFAULT '0.00' COMMENT '用户服务费',
  `trade_fee_total` decimal(11,2) DEFAULT '0.00' COMMENT '交易总佣金',
  `buy_fee_total` decimal(11,2) DEFAULT '0.00' COMMENT '购买股票佣金',
  `sell_fee_total` decimal(11,2) DEFAULT '0.00' COMMENT '出售股票佣金',
  `change_total` decimal(11,2) DEFAULT '0.00' COMMENT '过户费',
  `stamp_total` decimal(11,2) DEFAULT '0.00' COMMENT '印花税',
  `capital_total` decimal(11,2) DEFAULT '0.00',
  `fee_total` decimal(11,2) DEFAULT '0.00',
  `profit_total` decimal(11,2) DEFAULT '0.00' COMMENT '结算盈亏',
  `reid` int(11) DEFAULT '0' COMMENT '推荐人编号',
  `agent` int(11) DEFAULT '0' COMMENT '代理编号',
  `staff` int(11) DEFAULT '0' COMMENT '员工编号',
  `mother` int(11) DEFAULT '0' COMMENT '证券编号',
  `time` int(11) DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='账户信息';

-- ----------------------------
-- Records of sn_user_account
-- ----------------------------
INSERT INTO `sn_user_account` VALUES ('3', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for sn_withdraw
-- ----------------------------
DROP TABLE IF EXISTS `sn_withdraw`;
CREATE TABLE `sn_withdraw` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned DEFAULT '0' COMMENT '用户ID',
  `order` varchar(100) COLLATE utf8_bin DEFAULT '0' COMMENT '订单',
  `number` decimal(11,2) unsigned DEFAULT '0.00' COMMENT '金额',
  `balance` decimal(11,2) DEFAULT '0.00' COMMENT '余额',
  `fee` decimal(11,2) DEFAULT '0.00' COMMENT '手续费',
  `status` tinyint(3) unsigned DEFAULT '0' COMMENT '状态',
  `time` int(11) unsigned DEFAULT '0' COMMENT '时间',
  `name` varchar(20) COLLATE utf8_bin DEFAULT '' COMMENT '姓名',
  `card` varchar(50) COLLATE utf8_bin DEFAULT '' COMMENT '卡号',
  `pay_time` int(11) unsigned DEFAULT '0' COMMENT '支付日期',
  `pay_order` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `callback` text COLLATE utf8_bin,
  `refer_to` text COLLATE utf8_bin,
  `agent` int(11) unsigned DEFAULT '0' COMMENT '代理id',
  `staff` int(11) unsigned DEFAULT '0' COMMENT '员工id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='财务提现';

-- ----------------------------
-- Records of sn_withdraw
-- ----------------------------
INSERT INTO `sn_withdraw` VALUES ('1', '3', '201905141711255959231', '21.00', '0.00', '0.00', '0', '1557825085', '张三', '21', '0', null, null, null, '0', '0');