CRM/crm_mt4_deposit_log.sql

/*
 Navicat Premium Data Transfer

 Source Server         : berger
 Source Server Type    : MySQL
 Source Server Version : 50628
 Source Host           : 15.165.74.227:3306
 Source Schema         : bergermkt_crm

 Target Server Type    : MySQL
 Target Server Version : 50628
 File Encoding         : 65001

 Date: 26/12/2019 20:17:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for crm_mt4_deposit_log
-- ----------------------------
DROP TABLE IF EXISTS `crm_mt4_deposit_log`;
CREATE TABLE `crm_mt4_deposit_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `type` smallint(4) NOT NULL DEFAULT 1 COMMENT '类型 1入金 2出金',
  `mt4_id` int(11) NOT NULL DEFAULT 0 COMMENT 'mt4 id',
  `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `mt4_order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'mt4订单号',
  `usd_money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '操作金额 美元',
  `err_code` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '错误码',
  `err_msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '错误信息',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `log_id` int(11) NOT NULL DEFAULT 0 COMMENT '出入金的id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of crm_mt4_deposit_log
-- ----------------------------
INSERT INTO `crm_mt4_deposit_log` VALUES (1, 1, 30100402, 'Deposit', '27231', 100.29, '0', 'RET_OK|正确', 1577241361, 13346);
INSERT INTO `crm_mt4_deposit_log` VALUES (2, 2, 30100402, 'Withdraw', '27232', 100.29, '0', 'RET_OK|正确', 1577259920, 1);
INSERT INTO `crm_mt4_deposit_log` VALUES (3, 1, 30100405, 'Deposit', '27233', 1000.47, '0', 'RET_OK|正确', 1577351823, 13362);
INSERT INTO `crm_mt4_deposit_log` VALUES (4, 1, 30100408, 'Deposit', '27234', 10000.24, '0', 'RET_OK|正确', 1577351859, 13370);
INSERT INTO `crm_mt4_deposit_log` VALUES (5, 1, 30100413, 'Deposit', '27235', 7143.52, '0', 'RET_OK|正确', 1577351876, 13373);
INSERT INTO `crm_mt4_deposit_log` VALUES (6, 1, 30100450, 'Deposit', '27238', 1000.55, '0', 'RET_OK|正确', 1577356121, 13389);
INSERT INTO `crm_mt4_deposit_log` VALUES (7, 1, 30100450, 'Deposit', '27239', 1000.18, '0', 'RET_OK|正确', 1577356127, 13390);
INSERT INTO `crm_mt4_deposit_log` VALUES (8, 1, 30100424, 'Deposit', '27240', 10000.37, '0', 'RET_OK|正确', 1577356142, 13382);
INSERT INTO `crm_mt4_deposit_log` VALUES (9, 1, 30100413, 'Deposit', '27241', 7140.22, '0', 'RET_OK|正确', 1577356175, 13380);
INSERT INTO `crm_mt4_deposit_log` VALUES (10, 1, 30100438, 'Deposit', '27242', 4200.48, '0', 'RET_OK|正确', 1577356192, 13381);
INSERT INTO `crm_mt4_deposit_log` VALUES (11, 1, 30100438, 'Deposit', '27243', 2857.13, '0', 'RET_OK|正确', 1577356217, 13384);
INSERT INTO `crm_mt4_deposit_log` VALUES (12, 1, 30100413, 'Deposit', '27244', 7142.14, '0', 'RET_OK|正确', 1577356261, 13375);
INSERT INTO `crm_mt4_deposit_log` VALUES (13, 1, 30100418, 'Deposit', '27245', 7000.64, '0', 'RET_OK|正确', 1577356268, 13391);
INSERT INTO `crm_mt4_deposit_log` VALUES (14, 1, 30100410, 'Deposit', '27246', 5000.62, '0', 'RET_OK|正确', 1577357885, 13371);
INSERT INTO `crm_mt4_deposit_log` VALUES (15, 1, 30100412, 'Deposit', '27248', 7000.39, '0', 'RET_OK|正确', 1577360935, 13399);
INSERT INTO `crm_mt4_deposit_log` VALUES (16, 1, 30100433, 'Deposit', '27249', 1428.24, '0', 'RET_OK|正确', 1577360948, 13400);
INSERT INTO `crm_mt4_deposit_log` VALUES (17, 1, 30100430, 'Deposit', '27250', 6000.25, '0', 'RET_OK|正确', 1577360968, 13401);
INSERT INTO `crm_mt4_deposit_log` VALUES (18, 1, 30100405, 'Deposit', '27251', 2000.13, '0', 'RET_OK|正确', 1577360987, 13412);

SET FOREIGN_KEY_CHECKS = 1;