text: /*
  SQLyog Ultimate v10.00 Beta1
  MySQL - 5.7.20-log : Database - distribution
  *********************************************************************
  */
  
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  CREATE DATABASE /*!32312 IF NOT EXISTS*/`distribution` /*!40100 DEFAULT CHARACTER SET utf8 */;
  
  USE `distribution`;
  
  /*Table structure for table `dis_amount_situation` */
  
  DROP TABLE IF EXISTS `dis_amount_situation`;
  
  CREATE TABLE `dis_amount_situation` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `dis_user_id` varchar(50) DEFAULT NULL COMMENT '用户id',
    `type` varchar(10) DEFAULT NULL COMMENT '(0:收入,1:支出)',
    `before_change_amount` decimal(10,2) DEFAULT '0.00' COMMENT '总账户变动之前余额',
    `after_change_amount` decimal(10,2) DEFAULT '0.00' COMMENT '总账户变动之后余额',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `specific_before_change_amount` decimal(10,2) DEFAULT '0.00' COMMENT '具体账户变动之前金额',
    `specific_after_change_amount` decimal(10,2) DEFAULT '0.00' COMMENT '具体账户变动之后金额',
    `account_type` varchar(10) DEFAULT NULL COMMENT '具体账户类型',
    `change_amount` decimal(10,2) DEFAULT NULL COMMENT '账户变动金额',
    `describe` varchar(200) DEFAULT NULL COMMENT '具体变动描述',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=333 DEFAULT CHARSET=utf8 COMMENT='账户变动表，用于记录账户变动情况';
  
  /*Data for the table `dis_amount_situation` */
  
  insert  into `dis_amount_situation`(`id`,`dis_user_id`,`type`,`before_change_amount`,`after_change_amount`,`add_time`,`specific_before_change_amount`,`specific_after_change_amount`,`account_type`,`change_amount`,`describe`) values (11,'mingchao','0','10100.00','10200.00','2018-05-31 21:43:01','10200.00','10300.00','0','100.00',NULL),(12,'dist','0','1.00','2.00','2018-05-31 21:43:02','1.00','2.00','1','1.00',NULL),(13,'admin','0','5.00','6.00','2018-05-31 21:43:02','5.00','6.00','1','1.00',NULL),(14,'mingchao','0','0.00','100.00','2018-05-31 21:45:19','0.00','100.00','0','100.00',NULL),(15,'dist','0','0.00','1.00','2018-05-31 21:45:20','0.00','1.00','1','1.00',NULL),(16,'admin','0','0.00','1.00','2018-05-31 21:45:20','0.00','1.00','1','1.00',NULL),(17,'mingchao','1','100.00','50.00','2018-06-09 02:17:57','100.00','50.00','0','50.00',NULL),(18,'mingchao','0','50.00','10050.00','2018-06-09 14:22:34','50.00','10050.00','0','10000.00','minguo的trade账户交易，根据当前费率，获得{}元，'),(19,'dist','0','1.00','2.00','2018-06-09 14:22:35','1.00','2.00','1','1.00','minguo的level账户交易，根据当前费率，获得{}元，'),(20,'admin','0','1.00','2.00','2018-06-09 14:22:35','1.00','2.00','1','1.00','minguo的level账户交易，根据当前费率，获得{}元，'),(21,'mingchao','0','10050.00','10200.00','2018-06-09 14:26:29','10050.00','10200.00','0','150.00','minguo的trade账户交易，根据当前费率，获得150.0元，'),(22,'dist','0','2.00','3.00','2018-06-09 14:26:29','2.00','3.00','1','1.00','minguo的level账户交易，根据当前费率，获得1元，'),(23,'admin','0','2.00','3.00','2018-06-09 14:26:29','2.00','3.00','1','1.00','minguo的level账户交易，根据当前费率，获得1元，'),(24,'mingchao','0','10200.00','11200.00','2018-06-09 14:32:27','10200.00','11200.00','0','1000.00','minguo的trade账户交易，根据当前费率，mingchao获得1000.0元，'),(25,'dist','0','3.00','4.00','2018-06-09 14:32:27','3.00','4.00','1','1.00','minguo的level账户交易，根据当前费率，dist获得1元，'),(26,'admin','0','3.00','4.00','2018-06-09 14:32:27','3.00','4.00','1','1.00','minguo的level账户交易，根据当前费率，admin获得1元，'),(27,'yuanchao','0','0.00','0.00','2018-05-02 20:49:07','0.00','0.00','0','0.00','账户初始化'),(28,'yuanchao','0','0.00','122.20','2018-06-09 20:03:14','0.00','122.20','0','122.20','qingchao的trade账户交易，根据当前费率，yuanchao获得122.2元，'),(29,'mingchao','0','11200.00','12422.00','2018-06-09 20:03:14','11200.00','12422.00','0','1222.00','qingchao的trade账户交易，根据当前费率，mingchao获得1222元，'),(30,'admin','0','4.00','5.00','2018-06-09 20:03:15','4.00','5.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(31,'admin','0','5.00','6.00','2018-06-09 20:03:15','5.00','6.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(32,'yuanchao','0','122.20','244.40','2018-06-09 20:11:09','122.20','244.40','0','122.20','qingchao的trade账户交易，根据当前费率，yuanchao获得122.2元，'),(33,'mingchao','0','12422.00','13644.00','2018-06-09 20:11:09','12422.00','13644.00','0','1222.00','qingchao的trade账户交易，根据当前费率，mingchao获得1222元，'),(34,'admin','0','6.00','7.00','2018-06-09 20:11:09','6.00','7.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(35,'admin','0','7.00','8.00','2018-06-09 20:11:09','7.00','8.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(36,'yuanchao','1','244.40','144.40','2018-06-09 20:16:42','244.40','144.40','0','100.00','yuanchao的trade账户提现'),(37,'yuanchao','0','144.40','244.40','2018-06-09 20:27:54','144.40','244.40','0','100.00','xiaoli的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(38,'mingchao','0','13644.00','14644.00','2018-06-09 20:27:54','13644.00','14644.00','0','1000.00','xiaoli的trade账户交易，根据当前费率，mingchao获得1000元，'),(39,'dist','0','4.00','5.00','2018-06-09 20:27:54','4.00','5.00','1','1.00','xiaoli的level账户交易，根据当前费率，dist获得1元，'),(40,'admin','0','8.00','9.00','2018-06-09 20:27:54','8.00','9.00','1','1.00','xiaoli的level账户交易，根据当前费率，admin获得1元，'),(41,'liuxiug','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(42,'liuxiug','0','0.00','1000.00','2018-06-09 20:49:19','0.00','1000.00','0','1000.00','weichao的trade账户交易，根据当前费率，liuxiug获得1000.0元，'),(43,'caocao','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(44,'caocao','0','0.00','10000.00','2018-06-09 20:49:20','0.00','10000.00','0','10000.00','weichao的trade账户交易，根据当前费率，caocao获得10000元，'),(45,'admin','0','9.00','10.00','2018-06-09 20:49:20','9.00','10.00','1','1.00','weichao的level账户交易，根据当前费率，admin获得1元，'),(46,'admin','0','10.00','11.00','2018-06-09 20:49:20','10.00','11.00','1','1.00','weichao的level账户交易，根据当前费率，admin获得1元，'),(47,'liuxiug','0','1000.00','2000.00','2018-06-09 20:50:00','1000.00','2000.00','0','1000.00','weichao的trade账户交易，根据当前费率，liuxiug获得1000.0元，'),(48,'caocao','0','10000.00','20000.00','2018-06-09 20:50:00','10000.00','20000.00','0','10000.00','weichao的trade账户交易，根据当前费率，caocao获得10000元，'),(49,'admin','0','11.00','12.00','2018-06-09 20:50:00','11.00','12.00','1','1.00','weichao的level账户交易，根据当前费率，admin获得1元，'),(50,'admin','0','12.00','13.00','2018-06-09 20:50:01','12.00','13.00','1','1.00','weichao的level账户交易，根据当前费率，admin获得1元，'),(51,'qinershi','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(52,'qinershi','0','0.00','188.80','2018-06-10 11:24:22','0.00','188.80','0','188.80','hanwudi的trade账户交易，根据当前费率，qinershi获得188.8元，'),(53,'liubang','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(54,'liubang','0','0.00','1888.00','2018-06-10 11:24:22','0.00','1888.00','0','1888.00','hanwudi的trade账户交易，根据当前费率，liubang获得1888元，'),(55,'admin','0','13.00','14.00','2018-06-10 11:24:22','13.00','14.00','1','1.00','hanwudi的level账户交易，根据当前费率，admin获得1元，'),(56,'admin','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(57,'admin','0','14.00','221.68','2018-06-10 11:24:22','0.00','207.68','0','207.68','hanwudi的trade账户交易，根据当前费率，admin获得207.68元，'),(58,'hanwudi','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(59,'hanwudi','0','0.00','180.00','2018-06-10 11:33:41','0.00','180.00','0','180.00','sunquan的trade账户交易，根据当前费率，hanwudi获得180.0元，'),(60,'liuxiug','0','2000.00','3800.00','2018-06-10 11:33:41','2000.00','3800.00','0','1800.00','sunquan的trade账户交易，根据当前费率，liuxiug获得1800元，'),(61,'admin','0','221.68','222.68','2018-06-10 11:33:41','14.00','15.00','1','1.00','sunquan的level账户交易，根据当前费率，admin获得1元，'),(62,'admin','0','222.68','282.68','2018-06-10 11:33:41','15.00','75.00','1','60.00','sunquan的level账户交易，根据当前费率，admin获得60元，'),(63,'yuanchao','0','244.40','344.40','2018-06-26 17:25:28','244.40','344.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(64,'mingchao','0','14644.00','14744.00','2018-06-26 17:25:28','14644.00','14744.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(65,'admin','0','282.68','283.68','2018-06-26 17:25:28','75.00','76.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(66,'admin','0','283.68','343.68','2018-06-26 17:25:28','76.00','136.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(67,'yuanchao','0','344.40','444.40','2018-06-26 17:28:01','344.40','444.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(68,'mingchao','0','14744.00','14844.00','2018-06-26 17:28:01','14744.00','14844.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(69,'admin','0','343.68','344.68','2018-06-26 17:28:01','136.00','137.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(70,'admin','0','344.68','404.68','2018-06-26 17:28:01','137.00','197.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(71,'yuanchao','0','444.40','544.40','2018-06-26 17:28:55','444.40','544.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(72,'mingchao','0','14844.00','14944.00','2018-06-26 17:28:55','14844.00','14944.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(73,'admin','0','404.68','405.68','2018-06-26 17:30:51','197.00','198.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(74,'admin','0','405.68','465.68','2018-06-26 17:30:51','198.00','258.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(75,'yuanchao','0','544.40','644.40','2018-06-26 17:31:33','544.40','644.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(76,'mingchao','0','14944.00','15044.00','2018-06-26 17:31:33','14944.00','15044.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(77,'admin','0','465.68','466.68','2018-06-26 17:32:47','258.00','259.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(78,'admin','0','466.68','526.68','2018-06-26 17:32:47','259.00','319.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(79,'yuanchao','0','644.40','744.40','2018-06-26 17:33:10','644.40','744.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(80,'mingchao','0','15044.00','15144.00','2018-06-26 17:33:10','15044.00','15144.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(81,'admin','0','526.68','527.68','2018-06-26 17:34:41','319.00','320.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(82,'admin','0','527.68','587.68','2018-06-26 17:34:41','320.00','380.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(83,'yuanchao','0','744.40','844.40','2018-06-26 17:34:49','744.40','844.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(84,'mingchao','0','15144.00','15244.00','2018-06-26 17:34:49','15144.00','15244.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(85,'admin','0','587.68','588.68','2018-06-26 17:34:59','380.00','381.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(86,'admin','0','588.68','648.68','2018-06-26 17:35:04','381.00','441.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(87,'yuanchao','0','844.40','944.40','2018-06-26 17:35:36','844.40','944.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(88,'mingchao','0','15244.00','15344.00','2018-06-26 17:35:36','15244.00','15344.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(89,'admin','0','648.68','649.68','2018-06-26 18:18:49','441.00','442.00','1','1.00','qingchao的level账户交易，根据当前费率，admin获得1元，'),(90,'admin','0','649.68','709.68','2018-06-26 18:18:49','442.00','502.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(91,'yuanchao','0','944.40','1044.40','2018-06-26 18:27:59','944.40','1044.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(92,'mingchao','0','15344.00','15444.00','2018-06-26 18:27:59','15344.00','15444.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(93,'admin','0','709.68','769.68','2018-06-26 18:28:28','502.00','562.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(94,'yuanchao','0','1044.40','1144.40','2018-06-26 18:28:31','1044.40','1144.40','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(95,'mingchao','0','15444.00','15544.00','2018-06-26 18:28:31','15444.00','15544.00','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(96,'admin','0','769.68','829.68','2018-06-26 18:29:25','562.00','622.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(133,'mingchao','0','15544.00','15644.00','2018-06-26 18:54:20','15544.00','15644.00','0','100.00','minguo的trade账户交易，根据当前费率，mingchao获得100.0元，'),(134,'dist','0','5.00','6.00','2018-06-26 18:54:20','5.00','6.00','1','1.00','minguo的level账户交易，根据当前费率，dist获得1元，'),(135,'yiji','2','0.00','0.00','2018-06-26 18:54:20','0.00','0.00','1','0.00','账户初始化'),(136,'yiji','0','0.00','20.00','2018-06-26 18:54:20','0.00','20.00','1','20.00','minguo的level账户交易，根据当前费率，yiji获得20元，'),(137,'admin','0','829.68','889.68','2018-06-26 18:54:20','622.00','682.00','1','60.00','minguo的level账户交易，根据当前费率，admin获得60元，'),(138,'mingchao','0','15644.00','15744.00','2018-06-26 18:58:06','15644.00','15744.00','0','100.00','minguo的trade账户交易，根据当前费率，mingchao获得100.0元，'),(139,'dist','0','6.00','7.00','2018-06-26 18:58:06','6.00','7.00','1','1.00','minguo的level账户交易，根据当前费率，dist获得1元，'),(140,'yiji','0','0.00','20.00','2018-06-26 18:58:06','0.00','20.00','1','20.00','minguo的level账户交易，根据当前费率，yiji获得20元，'),(141,'admin','0','889.68','949.68','2018-06-26 18:58:06','682.00','742.00','1','60.00','minguo的level账户交易，根据当前费率，admin获得60元，'),(142,'mingchao','0','15744.00','15844.00','2018-06-26 18:59:08','15744.00','15844.00','0','100.00','minguo的trade账户交易，根据当前费率，mingchao获得100.0元，'),(143,'dist','0','7.00','8.00','2018-06-26 18:59:08','7.00','8.00','1','1.00','minguo的level账户交易，根据当前费率，dist获得1元，'),(144,'yiji','0','20.00','40.00','2018-06-26 18:59:08','20.00','40.00','1','20.00','minguo的level账户交易，根据当前费率，yiji获得20元，'),(145,'admin','0','949.68','1009.68','2018-06-26 18:59:08','742.00','802.00','1','60.00','minguo的level账户交易，根据当前费率，admin获得60元，'),(146,'mingchao','0','15844.00','15944.00','2018-06-26 18:59:45','15844.00','15944.00','0','100.00','minguo的trade账户交易，根据当前费率，mingchao获得100.0元，'),(147,'dist','0','8.00','9.00','2018-06-26 18:59:46','8.00','9.00','1','1.00','minguo的level账户交易，根据当前费率，dist获得1元，'),(148,'yiji','0','40.00','60.00','2018-06-26 19:00:24','40.00','60.00','1','20.00','minguo的level账户交易，根据当前费率，yiji获得20元，'),(149,'admin','0','1009.68','1069.68','2018-06-26 19:00:28','802.00','862.00','1','60.00','minguo的level账户交易，根据当前费率，admin获得60元，'),(150,'yuanchao','0','1144.40','1156.60','2018-07-01 00:51:16','1144.40','1156.60','0','12.20','qingchao的trade账户交易，根据当前费率，yuanchao获得12.2元，'),(151,'mingchao','0','15944.00','15956.20','2018-07-01 00:51:16','15944.00','15956.20','0','12.20','qingchao的trade账户交易，根据当前费率，mingchao获得12.2元，'),(152,'dist','0','9.00','10.00','2018-07-01 00:51:16','9.00','10.00','1','1.00','qingchao的level账户交易，根据当前费率，dist获得1元，'),(153,'admin','0','1069.68','1129.68','2018-07-01 00:51:16','862.00','922.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(154,'dist','0','10.00','11.00','2018-07-01 01:32:34','10.00','11.00','1','1.00','fasongdao的level账户交易，根据当前费率，dist获得1元，'),(155,'admin','0','1129.68','1189.68','2018-07-01 01:32:34','922.00','982.00','1','60.00','fasongdao的level账户交易，根据当前费率，admin获得60元，'),(156,'dist','0','11.00','12.00','2018-07-01 01:34:02','11.00','12.00','1','1.00','fasongdao的level账户交易，根据当前费率，dist获得1元，'),(157,'admin','0','1189.68','1249.68','2018-07-01 01:34:02','982.00','1042.00','1','60.00','fasongdao的level账户交易，根据当前费率，admin获得60元，'),(158,'dist','0','12.00','13.00','2018-07-01 01:35:28','12.00','13.00','1','1.00','fasongdao的level账户交易，根据当前费率，dist获得1元，'),(159,'admin','0','1249.68','1309.68','2018-07-01 01:35:28','1042.00','1102.00','1','60.00','fasongdao的level账户交易，根据当前费率，admin获得60元，'),(160,'dist','0','13.00','14.00','2018-07-01 01:38:59','13.00','14.00','1','1.00','fasongdao的level账户交易，根据当前费率，dist获得1元，'),(161,'admin','0','1309.68','1369.68','2018-07-01 01:38:59','1102.00','1162.00','1','60.00','fasongdao的level账户交易，根据当前费率，admin获得60元，'),(162,'dist','0','14.00','15.00','2018-07-01 01:40:16','14.00','15.00','1','1.00','fasongdao的level账户交易，根据当前费率，dist获得1元，'),(163,'admin','0','1369.68','1429.68','2018-07-01 01:40:16','1162.00','1222.00','1','60.00','fasongdao的level账户交易，根据当前费率，admin获得60元，'),(164,'yuanchao','0','1156.60','1256.60','2018-07-23 00:24:14','1156.60','1256.60','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(165,'mingchao','0','15956.20','16056.20','2018-07-23 00:24:14','15956.20','16056.20','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(166,'dist','0','15.00','16.00','2018-07-23 00:24:14','15.00','16.00','1','1.00','qingchao的level账户交易，根据当前费率，dist获得1元，'),(167,'admin','0','1429.68','1489.68','2018-07-23 00:24:14','1222.00','1282.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(168,'yuanchao','0','1256.60','1446.60','2018-07-23 00:25:35','1256.60','1446.60','0','190.00','qingchao的trade账户交易，根据当前费率，yuanchao获得190.0元，'),(169,'mingchao','0','16056.20','16246.20','2018-07-23 00:25:35','16056.20','16246.20','0','190.00','qingchao的trade账户交易，根据当前费率，mingchao获得190.0元，'),(170,'dist','0','16.00','17.00','2018-07-23 00:25:35','16.00','17.00','1','1.00','qingchao的level账户交易，根据当前费率，dist获得1元，'),(171,'admin','0','1489.68','1549.68','2018-07-23 00:25:35','1282.00','1342.00','1','60.00','qingchao的level账户交易，根据当前费率，admin获得60元，'),(172,'mingchao','0','16246.20','16256.20','2018-07-30 12:21:27','16246.20','16256.20','0','10.00','shunzhi的trade账户交易，根据当前费率，mingchao获得10.0元，'),(173,'qingchao','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(174,'qingchao','0','0.00','10.00','2018-07-30 12:21:27','0.00','10.00','0','10.00','shunzhi的trade账户交易，根据当前费率，qingchao获得10.0元，'),(175,'dist','0','17.00','18.00','2018-07-30 12:21:28','17.00','18.00','1','1.00','shunzhi的level账户交易，根据当前费率，dist获得1元，'),(176,'admin','0','1549.68','1609.68','2018-07-30 12:21:28','1342.00','1402.00','1','60.00','shunzhi的level账户交易，根据当前费率，admin获得60元，'),(183,'yuanchao','0','1446.60','1546.60','2018-10-04 00:57:55','1446.60','1546.60','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(184,'mingchao','0','16256.20','16356.20','2018-10-04 00:57:55','16256.20','16356.20','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(185,'dist','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(186,'dist','0','18.00','19.00','2018-10-04 00:57:55','0.00','1.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(187,'admin','0','1609.68','1669.68','2018-10-04 00:57:55','207.68','267.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(188,'yuanchao','0','1546.60','1646.60','2018-10-12 23:54:46','1546.60','1646.60','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(189,'mingchao','0','16356.20','16456.20','2018-10-12 23:54:46','16356.20','16456.20','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(190,'dist','0','19.00','20.00','2018-10-12 23:54:46','1.00','2.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(191,'admin','0','1669.68','1729.68','2018-10-12 23:54:46','267.68','327.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(192,'mingchao','0','16456.20','16656.20','2018-10-13 00:08:28','16456.20','16656.20','0','200.00','demo的trade账户交易，根据当前费率，mingchao获得200.0元，'),(193,'qingchao','0','10.00','210.00','2018-10-13 00:08:28','10.00','210.00','0','200.00','demo的trade账户交易，根据当前费率，qingchao获得200.0元，'),(194,'dist','0','20.00','21.00','2018-10-13 00:08:28','2.00','3.00','0','1.00','demo的trade账户交易，根据当前费率，dist获得1元，'),(195,'admin','0','1729.68','1789.68','2018-10-13 00:08:29','327.68','387.68','0','60.00','demo的trade账户交易，根据当前费率，admin获得60元，'),(196,'mingchao','0','16656.20','17156.20','2018-10-13 00:29:53','16656.20','17156.20','0','500.00','test0001的trade账户交易，根据当前费率，mingchao获得500.0元，'),(197,'qingchao','0','210.00','710.00','2018-10-13 00:29:53','210.00','710.00','0','500.00','test0001的trade账户交易，根据当前费率，qingchao获得500.0元，'),(198,'dist','0','21.00','22.00','2018-10-13 00:29:53','3.00','4.00','0','1.00','test0001的trade账户交易，根据当前费率，dist获得1元，'),(199,'admin','0','1789.68','1849.68','2018-10-13 00:29:53','387.68','447.68','0','60.00','test0001的trade账户交易，根据当前费率，admin获得60元，'),(200,'yuanchao','0','1646.60','1846.60','2018-10-18 22:37:48','1646.60','1846.60','0','200.00','qingchao的trade账户交易，根据当前费率，yuanchao获得200.0元，'),(201,'mingchao','0','17156.20','17356.20','2018-10-18 22:37:48','17156.20','17356.20','0','200.00','qingchao的trade账户交易，根据当前费率，mingchao获得200.0元，'),(202,'dist','0','22.00','23.00','2018-10-18 22:37:48','4.00','5.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(203,'admin','0','1849.68','1909.68','2018-10-18 22:37:48','447.68','507.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(204,'qingchao','1','710.00','610.00','2018-10-18 22:38:42','710.00','610.00','1','100.00','qingchao的level账户提现'),(205,'dist','1','23.00','13.00','2018-10-20 15:36:18','18.00','8.00','1','10.00','dist的level账户提现'),(206,'dist','0','13.00','14.00','2018-12-09 21:03:29','5.00','6.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(207,'admin','0','1909.68','1969.68','2018-12-09 21:03:29','507.68','567.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(208,'yuanchao','0','1846.60','1946.60','2018-12-09 21:10:55','1846.60','1946.60','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(209,'mingchao','0','17356.20','17456.20','2018-12-09 21:10:55','17356.20','17456.20','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(210,'dist','0','14.00','15.00','2018-12-09 21:10:55','6.00','7.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(211,'admin','0','1969.68','2029.68','2018-12-09 21:10:55','567.68','627.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(212,'yuanchao','0','1946.60','2046.60','2018-12-09 21:11:18','1946.60','2046.60','0','100.00','qingchao的trade账户交易，根据当前费率，yuanchao获得100.0元，'),(213,'mingchao','0','17456.20','17556.20','2018-12-09 21:11:18','17456.20','17556.20','0','100.00','qingchao的trade账户交易，根据当前费率，mingchao获得100.0元，'),(214,'dist','0','15.00','16.00','2018-12-09 21:11:18','7.00','8.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(215,'admin','0','2029.68','2089.68','2018-12-09 21:11:18','627.68','687.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(216,'lilili','2','0.00','0.00','2018-12-09 20:27:32','0.00','0.00','1','0.00','账户初始化'),(217,'lilili','0','0.00','1.00','2019-01-06 18:06:57','0.00','1.00','1','1.00','xiaoerss的level账户交易，根据当前费率，lilili获得1元，'),(218,'admin','0','2089.68','2149.68','2019-01-06 18:06:57','687.68','747.68','0','60.00','xiaoerss的trade账户交易，根据当前费率，admin获得60元，'),(219,'yuanchao','0','2046.60','2246.50','2019-01-11 20:25:18','2046.60','2246.50','0','199.90','qingchao的trade账户交易，根据当前费率，yuanchao获得199.9元，'),(220,'mingchao','0','17556.20','17756.10','2019-01-11 20:25:18','17556.20','17756.10','0','199.90','qingchao的trade账户交易，根据当前费率，mingchao获得199.9元，'),(221,'dist','0','16.00','17.00','2019-01-11 20:25:18','8.00','9.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(222,'admin','0','2149.68','2209.68','2019-01-11 20:25:18','747.68','807.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(223,'yuanchao','0','2246.50','2446.40','2019-01-11 20:25:19','2246.50','2446.40','0','199.90','qingchao的trade账户交易，根据当前费率，yuanchao获得199.9元，'),(224,'mingchao','0','17756.10','17956.00','2019-01-11 20:25:19','17756.10','17956.00','0','199.90','qingchao的trade账户交易，根据当前费率，mingchao获得199.9元，'),(225,'dist','0','17.00','18.00','2019-01-11 20:25:19','9.00','10.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(226,'admin','0','2209.68','2269.68','2019-01-11 20:25:19','807.68','867.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(227,'yuanchao','0','2446.40','2646.30','2019-01-11 20:25:19','2446.40','2646.30','0','199.90','qingchao的trade账户交易，根据当前费率，yuanchao获得199.9元，'),(228,'mingchao','0','17956.00','18155.90','2019-01-11 20:25:19','17956.00','18155.90','0','199.90','qingchao的trade账户交易，根据当前费率，mingchao获得199.9元，'),(229,'dist','0','18.00','19.00','2019-01-11 20:25:19','10.00','11.00','0','1.00','qingchao的trade账户交易，根据当前费率，dist获得1元，'),(230,'admin','0','2269.68','2329.68','2019-01-11 20:25:19','867.68','927.68','0','60.00','qingchao的trade账户交易，根据当前费率，admin获得60元，'),(231,'minguo','2','0.00','0.00','2018-05-16 00:06:52','0.00','0.00','0','0.00','账户初始化'),(232,'minguo','0','0.00','1.00','2019-05-18 22:27:26','0.00','1.00','0','1.00','minguo的trade账户交易，根据当前费率，minguo获得1元，'),(233,'qingchao','0','610.00','630.00','2019-05-18 22:27:26','610.00','630.00','0','20.00','minguo的trade账户交易，根据当前费率，qingchao获得20元，'),(234,'dist','0','19.00','20.00','2019-05-18 22:27:26','11.00','12.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(235,'admin','0','2329.68','2389.68','2019-05-18 22:27:26','927.68','987.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(236,'minguo','0','1.00','2.00','2019-05-18 22:29:08','1.00','2.00','0','1.00','minguo的trade账户交易，根据当前费率，minguo获得1元，'),(237,'qingchao','0','630.00','650.00','2019-05-18 22:29:08','630.00','650.00','0','20.00','minguo的trade账户交易，根据当前费率，qingchao获得20元，'),(238,'dist','0','20.00','21.00','2019-05-18 22:36:50','12.00','13.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(239,'admin','0','2389.68','2449.68','2019-05-18 22:36:52','987.68','1047.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(240,'minguo','0','2.00','102.00','2019-05-18 22:39:59','2.00','102.00','0','100.00','minguo的trade账户交易，根据当前费率，minguo获得100.00元，'),(241,'qingchao','0','650.00','1650.00','2019-05-18 22:40:00','650.00','1650.00','0','1000.00','minguo的trade账户交易，根据当前费率，qingchao获得1000.0元，'),(242,'yiji','2','0.00','0.00','2018-06-26 18:58:06','0.00','0.00','0','0.00','账户初始化'),(243,'yiji','0','60.00','61.00','2019-05-18 22:40:17','0.00','1.00','0','1.00','minguo的trade账户交易，根据当前费率，yiji获得1元，'),(244,'dist','0','21.00','41.00','2019-05-18 22:40:20','13.00','33.00','0','20.00','minguo的trade账户交易，根据当前费率，dist获得20元，'),(245,'admin','0','2449.68','2509.68','2019-05-18 22:40:21','1047.68','1107.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(246,'minguo','0','102.00','202.00','2019-05-18 22:40:57','102.00','202.00','0','100.00','minguo的trade账户交易，根据当前费率，minguo获得100.00元，'),(247,'qingchao','0','1650.00','2650.00','2019-05-18 22:40:57','1650.00','2650.00','0','1000.00','minguo的trade账户交易，根据当前费率，qingchao获得1000.0元，'),(248,'yiji','0','61.00','62.00','2019-05-18 22:41:01','1.00','2.00','0','1.00','minguo的trade账户交易，根据当前费率，yiji获得1元，'),(249,'dist','0','41.00','61.00','2019-05-18 22:41:01','33.00','53.00','0','20.00','minguo的trade账户交易，根据当前费率，dist获得20元，'),(250,'admin','0','2509.68','2569.68','2019-05-18 22:41:01','1107.68','1167.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(251,'minguo','0','202.00','1202.00','2019-05-18 22:46:01','202.00','1202.00','0','1000.00','minguo的trade账户交易，根据当前费率，minguo获得1000.00元，'),(252,'qingchao','0','2650.00','12650.00','2019-05-18 22:46:01','2650.00','12650.00','0','10000.00','minguo的trade账户交易，根据当前费率，qingchao获得10000.0元，'),(253,'yiji','0','62.00','63.00','2019-05-18 22:46:06','2.00','3.00','0','1.00','minguo的trade账户交易，根据当前费率，yiji获得1元，'),(254,'dist','0','61.00','81.00','2019-05-18 22:46:06','53.00','73.00','0','20.00','minguo的trade账户交易，根据当前费率，dist获得20元，'),(255,'admin','0','2569.68','2629.68','2019-05-18 22:46:06','1167.68','1227.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(256,'minguo','0','1202.00','2202.00','2019-05-18 22:48:22','1202.00','2202.00','0','1000.00','minguo的trade账户交易，根据当前费率，minguo获得1000.00元，'),(257,'qingchao','0','12650.00','22650.00','2019-05-18 22:48:22','12650.00','22650.00','0','10000.00','minguo的trade账户交易，根据当前费率，qingchao获得10000.0元，'),(258,'yiji','0','63.00','64.00','2019-05-18 22:48:22','3.00','4.00','0','1.00','minguo的trade账户交易，根据当前费率，yiji获得1元，'),(259,'admin','0','2629.68','2689.68','2019-05-18 22:48:22','1227.68','1287.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(260,'minguo','0','2202.00','3202.00','2019-05-18 22:48:56','2202.00','3202.00','0','1000.00','minguo的trade账户交易，根据当前费率，minguo获得1000.00元，'),(261,'qingchao','0','22650.00','32650.00','2019-05-18 22:48:56','22650.00','32650.00','0','10000.00','minguo的trade账户交易，根据当前费率，qingchao获得10000.0元，'),(262,'yiji','0','64.00','65.00','2019-05-18 22:48:56','4.00','5.00','0','1.00','minguo的trade账户交易，根据当前费率，yiji获得1元，'),(263,'dist','0','81.00','101.00','2019-05-18 22:48:56','73.00','93.00','0','20.00','minguo的trade账户交易，根据当前费率，dist获得20元，'),(264,'admin','0','2689.68','2749.68','2019-05-18 22:48:56','1287.68','1347.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(265,'minguo','0','3202.00','4202.00','2019-05-18 22:49:39','3202.00','4202.00','0','1000.00','minguo的trade账户交易，根据当前费率，minguo获得1000.00元，'),(266,'qingchao','0','32650.00','42650.00','2019-05-18 22:49:39','32650.00','42650.00','0','10000.00','minguo的trade账户交易，根据当前费率，qingchao获得10000.0元，'),(267,'yiji','0','65.00','66.00','2019-05-18 22:49:39','5.00','6.00','0','1.00','minguo的trade账户交易，根据当前费率，yiji获得1元，'),(268,'dist','0','101.00','121.00','2019-05-18 22:49:39','93.00','113.00','0','20.00','minguo的trade账户交易，根据当前费率，dist获得20元，'),(269,'admin','0','2749.68','2809.68','2019-05-18 22:49:39','1347.68','1407.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(279,'minguo','0','4202.00','5202.00','2019-05-18 23:19:27','4202.00','5202.00','0','1000.00','minguo的trade账户交易，根据当前费率，minguo获得1000.00元，'),(280,'qingchao','0','42650.00','52650.00','2019-05-18 23:19:27','42650.00','52650.00','0','10000.00','minguo的trade账户交易，根据当前费率，qingchao获得10000.0元，'),(281,'yiji','0','66.00','67.00','2019-05-18 23:19:27','6.00','7.00','0','1.00','minguo的trade账户交易，根据当前费率，yiji获得1元，'),(282,'dist','0','121.00','141.00','2019-05-18 23:19:27','113.00','133.00','0','20.00','minguo的trade账户交易，根据当前费率，dist获得20元，'),(283,'admin','0','2809.68','2869.68','2019-05-18 23:19:27','1407.68','1467.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(284,'minguo','0','5202.00','6202.00','2019-05-19 10:19:11','5202.00','6202.00','0','1000.00','minguo的trade账户交易，根据当前费率，minguo获得1000.00元，'),(285,'qingchao','0','52650.00','62650.00','2019-05-19 10:19:11','52650.00','62650.00','0','10000.00','minguo的trade账户交易，根据当前费率，qingchao获得10000.0元，'),(286,'admin','0','2869.68','2929.68','2019-05-19 10:19:12','1467.68','1527.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(287,'dist','0','141.00','142.00','2019-05-19 10:19:12','133.00','134.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(288,'yiji','0','67.00','87.00','2019-05-19 10:19:12','7.00','27.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(289,'admin','0','2929.68','2989.68','2019-05-19 10:38:06','1527.68','1587.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(290,'dist','0','142.00','143.00','2019-05-19 10:38:07','134.00','135.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(291,'yiji','0','87.00','107.00','2019-05-19 10:38:07','27.00','47.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(292,'minguo','0','6202.00','7202.00','2019-05-19 10:38:07','6202.00','7202.00','0','1000.00','minguo的trade账户交易，根据当前费率，minguo获得1000.00元，'),(293,'qingchao','0','62650.00','72650.00','2019-05-19 10:38:07','62650.00','72650.00','0','10000.00','minguo的trade账户交易，根据当前费率，qingchao获得10000.0元，'),(294,'dist','0','143.00','144.00','2019-05-19 11:16:55','135.00','136.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(295,'minguo','0','7202.00','7202.09','2019-05-19 11:16:55','7202.00','7202.09','0','0.09','minguo的trade账户交易，根据当前费率，minguo获得0.09元，'),(296,'qingchao','0','72650.00','72650.89','2019-05-19 11:16:55','72650.00','72650.89','0','0.89','minguo的trade账户交易，根据当前费率，qingchao获得0.891元，'),(297,'admin','0','2989.68','3049.68','2019-05-19 11:19:30','1587.68','1647.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(298,'dist','0','144.00','145.00','2019-05-19 11:19:30','136.00','137.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(299,'yiji','0','107.00','127.00','2019-05-19 11:19:30','47.00','67.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(300,'minguo','0','7202.09','17201.28','2019-05-19 11:19:31','7202.09','17201.28','0','9999.19','minguo的trade账户交易，根据当前费率，minguo获得9999.19元，'),(301,'qingchao','0','72650.89','171642.87','2019-05-19 11:19:31','72650.89','171642.87','0','98991.98','minguo的trade账户交易，根据当前费率，qingchao获得98991.981元，'),(302,'admin','0','3049.68','3109.68','2019-05-19 11:20:00','1647.68','1707.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(303,'dist','0','145.00','146.00','2019-05-19 11:20:00','137.00','138.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(304,'yiji','0','127.00','147.00','2019-05-19 11:20:00','67.00','87.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(305,'minguo','0','17201.28','27200.47','2019-05-19 11:20:00','17201.28','27200.47','0','9999.19','minguo的trade账户交易，根据当前费率，minguo获得9999.19元，'),(306,'qingchao','0','171642.87','270634.85','2019-05-19 11:20:00','171642.87','270634.85','0','98991.98','minguo的trade账户交易，根据当前费率，qingchao获得98991.981元，'),(307,'admin','0','3109.68','3169.68','2019-05-19 11:23:28','1707.68','1767.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(308,'dist','0','146.00','147.00','2019-05-19 11:23:28','138.00','139.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(309,'yiji','0','147.00','167.00','2019-05-19 11:23:28','87.00','107.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(310,'minguo','0','27200.47','37199.66','2019-05-19 11:23:28','27200.47','37199.66','0','9999.19','minguo的trade账户交易，根据当前费率，minguo获得9999.19元，'),(311,'admin','0','3169.68','3229.68','2019-05-19 11:23:52','1767.68','1827.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(312,'dist','0','147.00','148.00','2019-05-19 11:23:52','139.00','140.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(313,'yiji','0','167.00','187.00','2019-05-19 11:23:52','107.00','127.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(314,'minguo','0','37199.66','47198.85','2019-05-19 11:23:52','37199.66','47198.85','0','9999.19','minguo的trade账户交易，根据当前费率，minguo获得9999.19元，'),(315,'admin','0','3229.68','3289.68','2019-05-19 11:25:53','1827.68','1887.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(316,'dist','0','148.00','149.00','2019-05-19 11:25:53','140.00','141.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(317,'yiji','0','187.00','207.00','2019-05-19 11:25:53','127.00','147.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(318,'minguo','0','47198.85','57198.04','2019-05-19 11:26:17','47198.85','57198.04','0','9999.19','minguo的trade账户交易，根据当前费率，minguo获得9999.19元，'),(319,'admin','0','3289.68','3349.68','2019-05-19 11:45:23','1887.68','1947.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(320,'dist','0','149.00','150.00','2019-05-19 11:45:23','141.00','142.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(321,'yiji','0','207.00','227.00','2019-05-19 11:45:23','147.00','167.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(322,'admin','0','3349.68','3409.68','2019-05-19 11:47:24','1947.68','2007.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(323,'dist','0','150.00','151.00','2019-05-19 11:47:24','142.00','143.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(324,'yiji','0','227.00','247.00','2019-05-19 11:47:24','167.00','187.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(325,'admin','0','3409.68','3469.68','2019-05-19 11:48:07','2007.68','2067.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(326,'dist','0','151.00','152.00','2019-05-19 11:48:07','143.00','144.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(327,'yiji','0','247.00','267.00','2019-05-19 11:48:09','187.00','207.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(328,'admin','0','3469.68','3529.68','2019-05-19 11:53:50','2067.68','2127.68','0','60.00','minguo的trade账户交易，根据当前费率，admin获得60元，'),(329,'dist','0','152.00','153.00','2019-05-19 11:53:50','144.00','145.00','0','1.00','minguo的trade账户交易，根据当前费率，dist获得1元，'),(330,'yiji','0','267.00','287.00','2019-05-19 11:53:51','207.00','227.00','0','20.00','minguo的trade账户交易，根据当前费率，yiji获得20元，'),(331,'qingchao','0','270634.85','280634.04','2019-05-19 11:53:51','270634.85','280634.04','0','9999.19','minguo的trade账户交易，根据当前费率，qingchao获得9999.19元，'),(332,'mingchao','0','18155.90','18165.90','2019-05-19 12:40:47','0.00','10.00','0','10.00','abc001的trade账户交易，根据当前费率，mingchao获得10元，');
  
  /*Table structure for table `dis_member_amount` */
  
  DROP TABLE IF EXISTS `dis_member_amount`;
  
  CREATE TABLE `dis_member_amount` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `dis_user_id` varchar(50) DEFAULT NULL COMMENT '用户标示id',
    `dis_user_name` varchar(20) DEFAULT NULL COMMENT '用户名称',
    `total_amount` decimal(12,2) DEFAULT '0.00' COMMENT '总金额',
    `frozen_amount` decimal(12,2) DEFAULT '0.00' COMMENT '冻结金额',
    `avaible_amount` decimal(12,2) DEFAULT '0.00' COMMENT '可用金额',
    `type` varchar(20) DEFAULT '0' COMMENT '类型（0会员 1 代理商）',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `update_time` varchar(20) DEFAULT NULL COMMENT '修改时间',
    `amount_status` varchar(10) DEFAULT '0' COMMENT '状态（0正常 1冻结）',
    `trade_total_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，交易账户总金额',
    `trade_frozen_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，交易账户冻结金额',
    `trade_avaible_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，交易账户可用金额',
    `level_total_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，等级账户总金额',
    `level_frozen_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，等级账户冻结金额',
    `level_avaible_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，等级账户可用金额',
    `invite_total_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，邀请用户总积分',
    `invite_frozen_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，邀请用户冻结积分',
    `invite_avaible_amount` decimal(12,2) DEFAULT '0.00' COMMENT '扩展字段，邀请用户可用积分',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='账户金额表';
  
  /*Data for the table `dis_member_amount` */
  
  insert  into `dis_member_amount`(`id`,`dis_user_id`,`dis_user_name`,`total_amount`,`frozen_amount`,`avaible_amount`,`type`,`add_time`,`update_time`,`amount_status`,`trade_total_amount`,`trade_frozen_amount`,`trade_avaible_amount`,`level_total_amount`,`level_frozen_amount`,`level_avaible_amount`,`invite_total_amount`,`invite_frozen_amount`,`invite_avaible_amount`) values (31,'songchao','宋朝','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(32,'yuanchao','元朝','2646.30','0.00','2646.30','0','2018-05-16 00:06:52',NULL,'0','2646.30','0.00','2646.30','0.00','0.00','0.00','0.00','0.00','0.00'),(33,'mingchao','明朝','18165.90','0.00','18165.90','0','2018-05-16 00:06:52',NULL,'0','18155.90','0.00','18155.90','0.00','0.00','0.00','10.00','0.00','10.00'),(34,'qingchao','清朝','280634.04','1.00','280633.04','0','2018-05-16 00:06:52',NULL,'0','280634.04','1.00','280633.04','0.00','0.00','0.00','0.00','0.00','0.00'),(35,'qinershi','秦二世','188.80','0.00','188.80','0','2018-05-16 00:06:52',NULL,'0','188.80','0.00','188.80','0.00','0.00','0.00','0.00','0.00','0.00'),(36,'liubang','刘邦','1888.00','0.00','1888.00','0','2018-05-16 00:06:52',NULL,'0','1888.00','0.00','1888.00','0.00','0.00','0.00','0.00','0.00','0.00'),(37,'xiangyu','项羽','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(38,'hanwudi','汉武帝','180.00','0.00','180.00','0','2018-05-16 00:06:52',NULL,'0','180.00','0.00','180.00','0.00','0.00','0.00','0.00','0.00','0.00'),(39,'liuxiug','刘秀','3800.00','2500.00','1300.00','0','2018-05-16 00:06:52',NULL,'0','3800.00','2500.00','1300.00','0.00','0.00','0.00','0.00','0.00','0.00'),(40,'minguo','民国','57198.04','0.00','57198.04','0','2018-05-16 00:06:52',NULL,'0','57198.04','0.00','57198.04','0.00','0.00','0.00','0.00','0.00','0.00'),(41,'qinshihuang','秦始皇','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(42,'liubei','刘备','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(43,'caocao','曹操','20000.00','0.00','20000.00','0','2018-05-16 00:06:52',NULL,'0','20000.00','0.00','20000.00','0.00','0.00','0.00','0.00','0.00','0.00'),(44,'sunquan','孙权','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(45,'weichao','魏朝','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(46,'suichao','隋朝','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(47,'tangchao','唐朝','0.00','0.00','0.00','0','2018-05-16 00:06:52',NULL,'0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(48,'admin','admin','3529.68','0.00','3529.68','1','2018-05-16 00:06:52',NULL,'0','2127.68','0.00','2127.68','1402.00','0.00','1402.00','0.00','0.00','0.00'),(49,'zhangsan','张三','0.00','0.00','0.00','1','2018-05-16 00:06:52','2018-05-16 00:06:52','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(50,'xiaoliuzi','小六子','0.00','0.00','0.00','0','2018-05-28 21:24:41','2018-05-28 21:24:41','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(51,'dist','dist','153.00','0.00','153.00','1','2018-05-16 00:06:52',NULL,'0','145.00','-10.00','145.00','8.00','10.00','8.00','0.00','0.00','0.00'),(52,'xiaoli','小李','0.00','0.00','0.00','0','2018-06-09 20:26:44','2018-06-09 20:26:44','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(53,'guanggaofei','???','0.00','0.00','0.00','0','2018-06-16 16:17:02','2018-06-16 16:17:02','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(54,'shishishang','???','0.00','0.00','0.00','0','2018-06-16 16:17:47','2018-06-16 16:17:47','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(55,'fafafa','???','0.00','0.00','0.00','0','2018-06-16 16:20:08','2018-06-16 16:20:08','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(56,'fafafaa','????','0.00','0.00','0.00','0','2018-06-16 16:28:19','2018-06-16 16:28:19','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(57,'zhongwenluanma','中文乱码','0.00','0.00','0.00','0','2018-06-16 16:28:54','2018-06-16 16:28:54','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(58,'sasashuisuo','洒洒水所','0.00','0.00','0.00','0','2018-06-16 17:07:49','2018-06-16 17:07:49','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(59,'fandesa','范德萨','0.00','0.00','0.00','0','2018-06-16 17:08:31','2018-06-16 17:08:31','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(60,'xiaoxiao','小小','0.00','0.00','0.00','0','2018-06-16 17:15:45','2018-06-16 17:15:45','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(61,'ouyangyiboa','欧阳一波啊','0.00','0.00','0.00','0','2018-06-20 22:27:32','2018-06-20 22:27:32','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(62,'fasongdao','发送到','0.00','0.00','0.00','0','2018-06-20 22:29:07','2018-06-20 22:29:07','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(63,'yiji','yiji','287.00','0.00','287.00','1','2018-06-26 18:58:06','2018-06-26 18:58:06','0','227.00','0.00','227.00','60.00','0.00','60.00','0.00','0.00','0.00'),(71,'sanji','三级测试','0.00','0.00','0.00','0','2018-07-18 00:42:33','2018-07-18 00:42:33','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(72,'sanji2','三级测试2','0.00','0.00','0.00','0','2018-07-18 00:42:52','2018-07-18 00:42:52','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(73,'huangpu','sss','0.00','0.00','0.00','0','2018-07-18 23:32:28','2018-07-18 23:32:28','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(74,'yaoqingjf','邀请积分','0.00','0.00','0.00','0','2018-07-23 23:28:07','2018-07-23 23:28:07','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(75,'yaoqingjf1','邀请积分1','0.00','0.00','0.00','0','2018-07-23 23:31:43','2018-07-23 23:31:43','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(76,'shunzhi','顺治','0.00','0.00','0.00','0','2018-07-30 12:21:10','2018-07-30 12:21:10','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(77,'wde','ss','0.00','0.00','0.00','0','2018-07-30 12:24:44','2018-07-30 12:24:44','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(78,'wdess','ssss','0.00','0.00','0.00','0','2018-07-30 12:24:54','2018-07-30 12:24:54','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(79,'xxxx','xxxx','0.00','0.00','0.00','0','2018-10-12 23:55:38','2018-10-12 23:55:38','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(80,'demo','demo','0.00','0.00','0.00','0','2018-10-13 00:02:32','2018-10-13 00:02:32','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(81,'test0001','test0001','0.00','0.00','0.00','0','2018-10-13 00:23:39','2018-10-13 00:23:39','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(82,'yonghu1','yonghu1','0.00','0.00','0.00','0','2018-10-18 22:34:40','2018-10-18 22:34:40','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(83,'yiji_ceshi','测试','0.00','0.00','0.00','1','2018-10-20 16:41:10','2018-10-20 16:41:10','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(84,'lilili','lilili','1.00','0.00','1.00','0','2018-12-09 20:27:32','2018-12-09 20:27:32','0','0.00','0.00','0.00','1.00','0.00','1.00','0.00','0.00','0.00'),(85,'xiaoerss','xiaoerss','0.00','0.00','0.00','0','2019-01-06 18:06:57','2019-01-06 18:06:57','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(86,'xxxx001','xxxx001','0.00','0.00','0.00','0','2019-05-19 12:10:15','2019-05-19 12:10:15','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(87,'xxxx002','xxxx002','0.00','0.00','0.00','0','2019-05-19 12:10:39','2019-05-19 12:10:39','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(88,'xxxx003','xxxx003','0.00','0.00','0.00','0','2019-05-19 12:11:28','2019-05-19 12:11:28','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(89,'xxxx004','xxxx004','0.00','0.00','0.00','0','2019-05-19 12:13:13','2019-05-19 12:13:13','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(90,'xxxx005','xxxx005','0.00','0.00','0.00','0','2019-05-19 12:13:44','2019-05-19 12:13:44','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(91,'xxxx006','xxxx006','0.00','0.00','0.00','0','2019-05-19 12:14:32','2019-05-19 12:14:32','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(92,'xxxx007','xxxx007','0.00','0.00','0.00','0','2019-05-19 12:15:43','2019-05-19 12:15:43','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(93,'xxxx008','xxxx008','0.00','0.00','0.00','0','2019-05-19 12:18:43','2019-05-19 12:18:43','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(94,'abc001','abc001','0.00','0.00','0.00','0','2019-05-19 12:40:47','2019-05-19 12:40:47','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(95,'lis','李四','0.00','0.00','0.00','1','2019-05-21 19:57:09','2019-05-21 19:57:09','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(96,'lismember','李四','0.00','0.00','0.00','0','2019-05-21 19:57:09','2019-05-21 19:57:09','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(97,'wangwu','www','0.00','0.00','0.00','1','2019-05-21 19:58:57','2019-05-21 19:58:57','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(98,'wangwumember','www','0.00','0.00','0.00','0','2019-05-21 19:58:57','2019-05-21 19:58:57','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(99,'ccc','ccc','0.00','0.00','0.00','1','2019-05-21 20:00:18','2019-05-21 20:00:18','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(100,'cccmember','ccc','0.00','0.00','0.00','0','2019-05-21 20:00:18','2019-05-21 20:00:18','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(101,'ssssssssssssssss','sssssss','0.00','0.00','0.00','0','2019-05-21 20:10:33','2019-05-21 20:10:33','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(102,'ssssssssssssssss1','sssssss1','0.00','0.00','0.00','0','2019-05-21 20:39:00','2019-05-21 20:39:00','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(103,'tccc1','tccc1','0.00','0.00','0.00','0','2019-05-21 20:50:28','2019-05-21 20:50:28','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(104,'xguo','xguo','0.00','0.00','0.00','1','2019-05-21 20:53:00','2019-05-21 20:53:00','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(105,'xguomember','xguo','0.00','0.00','0.00','0','2019-05-21 20:53:00','2019-05-21 20:53:00','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00'),(106,'xguo11','xguo11','0.00','0.00','0.00','0','2019-05-21 20:53:20','2019-05-21 20:53:20','0','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00');
  
  /*Table structure for table `dis_member_info` */
  
  DROP TABLE IF EXISTS `dis_member_info`;
  
  CREATE TABLE `dis_member_info` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `dis_platform_id` varchar(100) DEFAULT NULL COMMENT '平台',
    `dis_user_id` varchar(100) DEFAULT NULL COMMENT '用户id',
    `dis_model_id` varchar(100) DEFAULT NULL COMMENT '上级id',
    `dis_full_index` varchar(4000) DEFAULT NULL COMMENT '全路径',
    `dis_user_name` varchar(100) DEFAULT NULL COMMENT '用户名',
    `dis_level` int(11) DEFAULT NULL COMMENT '级别',
    `dis_user_type` varchar(10) DEFAULT '0' COMMENT '身份类型',
    `dis_user_rank` varchar(10) DEFAULT 'A' COMMENT '用户段位(青铜、黄金、白银等)',
    `dis_note` varchar(100) DEFAULT NULL COMMENT '备注',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `update_time` varchar(20) DEFAULT NULL COMMENT '更新时间',
    `is_delete` varchar(1) DEFAULT 'N' COMMENT '删除状态',
    `dis_plat_super` varchar(100) DEFAULT NULL COMMENT '上级代理商id',
    `dis_plat_full_index` varchar(4000) DEFAULT NULL COMMENT '代理商全路径',
    `dis_plat_level` int(11) DEFAULT NULL COMMENT '代理商等级',
    `type` varchar(10) DEFAULT '0' COMMENT '账户类型(0,会员，1：代理商)',
    `rank_integral` int(10) DEFAULT '0' COMMENT '段位积分',
    `total_rank_integral` int(10) DEFAULT '0' COMMENT '段位总积分',
    `confine_status` int(2) DEFAULT '0' COMMENT '限制状态，0为正常，1为禁止邀请用户',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='用户表';
  
  /*Data for the table `dis_member_info` */
  
  insert  into `dis_member_info`(`id`,`dis_platform_id`,`dis_user_id`,`dis_model_id`,`dis_full_index`,`dis_user_name`,`dis_level`,`dis_user_type`,`dis_user_rank`,`dis_note`,`add_time`,`update_time`,`is_delete`,`dis_plat_super`,`dis_plat_full_index`,`dis_plat_level`,`type`,`rank_integral`,`total_rank_integral`,`confine_status`) values (9,'dist','qinshihuang',NULL,'qinshihuang','秦始皇',0,'1','A','','2018-05-02 20:41:49','2018-05-02 20:41:49','N','dist','admin.dist',1,'0',0,NULL,0),(10,'dist','qinershi','qinshihuang','qinshihuang.qinershi','秦二世',1,'1','A','','2018-05-02 20:42:48','2018-05-02 20:42:48','N','dist','admin.dist',1,'0',0,NULL,0),(11,'dist','liubang','qinershi','qinshihuang.qinershi.liubang','刘邦',2,'1','A','','2018-05-02 20:43:58','2018-05-02 20:43:58','N','dist','admin.dist',1,'0',0,NULL,0),(12,'dist','xiangyu','qinershi','qinshihuang.qinershi.xiangyu','项羽',2,'1','A','','2018-05-02 20:44:27','2018-05-02 20:44:27','N','dist','admin.dist',1,'0',0,NULL,0),(13,'dist','hanwudi','liubang','qinshihuang.qinershi.liubang.hanwudi','汉武帝',3,'1','A','','2018-05-02 20:45:18','2018-05-02 20:45:18','N','dist','admin.dist',1,'0',0,NULL,0),(14,'dist','liuxiug','hanwudi','qinshihuang.qinershi.liubang.hanwudi.liuxiug','刘秀',4,'1','A','','2018-05-02 20:45:59','2018-05-02 20:45:59','N','dist','admin.dist',1,'0',0,NULL,0),(15,'dist','liubei','liuxiug','qinshihuang.qinershi.liubang.hanwudi.liuxiug.liubei','刘备',5,'1','A','','2018-05-02 20:46:36','2018-05-02 20:46:36','N','dist','admin.dist',1,'0',0,NULL,0),(16,'dist','caocao','liuxiug','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao','曹操',5,'1','A','','2018-05-02 20:46:52','2018-05-02 20:46:52','N','dist','admin.dist',1,'0',0,NULL,0),(17,'dist','sunquan','liuxiug','qinshihuang.qinershi.liubang.hanwudi.liuxiug.sunquan','孙权',5,'1','A','','2018-05-02 20:47:05','2018-05-02 20:47:05','N','dist','admin.dist',1,'0',0,NULL,0),(18,'dist','weichao','caocao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao','魏朝',6,'1','A','','2018-05-02 20:47:45','2018-05-02 20:47:45','N','dist','admin.dist',1,'0',0,NULL,0),(19,'dist','suichao','weichao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao','隋朝',7,'1','A','','2018-05-02 20:48:06','2018-05-02 20:48:06','N','dist','admin.dist',1,'0',0,NULL,0),(20,'dist','tangchao','suichao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao','唐朝',8,'1','A','','2018-05-02 20:48:25','2018-05-02 20:48:25','N','dist','admin.dist',1,'0',0,NULL,0),(21,'dist','songchao','tangchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao','宋朝',9,'1','A','','2018-05-02 20:48:46','2018-05-02 20:48:46','N','dist','admin.dist',1,'0',0,NULL,0),(22,'dist','yuanchao','songchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao','元朝',10,'1','A','','2018-05-02 20:49:07','2018-05-02 20:49:07','N','dist','admin.dist',1,'0',0,NULL,0),(23,'dist','mingchao','yuanchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao','明朝',11,'1','A','','2018-05-02 20:53:26','2018-05-02 20:53:26','N','dist','admin.dist',1,'0',1490,1490,0),(24,'dist','qingchao','mingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao','清朝',12,'1','A','','2018-05-02 20:53:46','2018-05-02 20:53:46','N','dist','admin.dist',1,'0',174880,174880,0),(29,'dist','minguo','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.minguo','民国',13,'0','A','sss','2018-05-08 00:28:05','2018-05-08 00:28:05','N','yiji','admin.dist.yiji',2,'0',348000,348000,0),(30,'admin','admin',NULL,'admin','系统管理员',0,'10000','N1',NULL,'2018-05-08 00:28:05','2018-05-08 00:28:05','N',NULL,'admin',0,'1',0,NULL,0),(31,'dist','dist','admin','admin.dist','平台商',1,'10000','N1',NULL,'2018-05-08 00:28:05','2018-05-08 00:28:05','N','admin','admin.dist',1,'1',0,NULL,0),(32,'dist','yiji','dist','admin.dist.yiji','一级代理',2,'10000','N1',NULL,'2018-05-08 00:28:05','2018-05-08 00:28:05','N','dist','admin.dist.yiji',2,'1',0,NULL,0),(33,'zhangsan','zhangsan','admin','admin.zhangsan','张三',1,'10000','N1',NULL,'2018-05-16 00:06:52','2018-05-16 00:06:52','N','admin','admin.zhangsan',1,'1',0,NULL,0),(34,'dist','xiaoliuzi','mingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.xiaoliuzi','小六子',12,'0','A','dist下的一级用户','2018-05-28 21:24:41','2018-05-28 21:24:41','N','yiji','admin.dist.yiji',2,'0',0,NULL,0),(35,'dist','xiaoli','mingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.xiaoli','小李',12,'0','A','','2018-06-09 20:26:44','2018-06-09 20:26:44','N','yiji','admin.dist.yiji',2,'0',0,NULL,0),(36,'dist','guanggaofei','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.guanggaofei','???',13,'0','A','???plug??','2018-06-16 16:17:02','2018-06-16 16:17:02','N','dist','admin.dist',1,'0',0,NULL,0),(37,'dist','shishishang','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.shishishang','???',13,'0','A','???plug??','2018-06-16 16:17:47','2018-06-16 16:17:47','N','dist','admin.dist',1,'0',0,NULL,0),(38,'dist','fafafa','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.fafafa','???',13,'0','A','???plug??','2018-06-16 16:20:08','2018-06-16 16:20:08','N','dist','admin.dist',1,'0',0,NULL,0),(39,'dist','fafafaa','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.fafafaa','????',13,'0','A','???plug??','2018-06-16 16:28:19','2018-06-16 16:28:19','N','dist','admin.dist',1,'0',0,NULL,0),(40,'dist','zhongwenluanma','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.zhongwenluanma','中文乱码',13,'0','A','来源：plug测试','2018-06-16 16:28:54','2018-06-16 16:28:54','N','dist','admin.dist',1,'0',0,NULL,0),(41,'dist','sasashuisuo','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.sasashuisuo','洒洒水所',13,'0','A','来源：plug测试','2018-06-16 17:07:49','2018-06-16 17:07:49','N','dist','admin.dist',1,'0',0,NULL,0),(42,'dist','fandesa','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.fandesa','范德萨',13,'0','A','来源：plug测试','2018-06-16 17:08:31','2018-06-16 17:08:31','N','dist','admin.dist',1,'0',0,NULL,0),(43,'dist','xiaoxiao','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.xiaoxiao','小小',13,'0','A','来源：plug测试','2018-06-16 17:15:45','2018-06-16 17:15:45','N','dist','admin.dist',1,'0',0,NULL,0),(44,'dist','ouyangyiboa','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.ouyangyiboa','欧阳一波啊',13,'0','A','来源：plug测试','2018-06-20 22:27:32','2018-06-20 22:27:32','N','dist','admin.dist',1,'0',0,NULL,0),(45,'dist','fasongdao','qingchao','qinshihuang.qinershi.liubang.hanwudi.liuxiug.caocao.weichao.suichao.tangchao.songchao.yuanchao.mingchao.qingchao.fasongdao','发送到',2,'2','A','来源：plug测试','2018-06-20 22:29:07','2018-06-20 22:29:07','N','dist','admin.dist',1,'0',0,NULL,0),(53,'dist','sanji','qingchao','mingchao.qingchao.sanji','三级测试',3,'0','A','测试','2018-07-18 00:42:32','2018-07-18 00:42:32','N','dist','admin.dist',1,'0',0,NULL,0),(54,'dist','sanji2','sanji','qingchao.sanji.sanji2','三级测试2',3,'0','A','测试2','2018-07-18 00:42:52','2018-07-18 00:42:52','N','dist','admin.dist',1,'0',0,NULL,0),(55,'dist','huangpu','qingchao','mingchao.qingchao.huangpu','sss',3,'0','A','','2018-07-18 23:32:28','2018-07-18 23:32:28','N','dist','admin.dist',1,'0',0,NULL,0),(56,'dist','yaoqingjf','qingchao','mingchao.qingchao.yaoqingjf','邀请积分',3,'0','A','积分测试','2018-07-23 23:28:07','2018-07-23 23:28:07','N','dist','admin.dist',1,'0',0,NULL,0),(57,'dist','yaoqingjf1','qingchao','mingchao.qingchao.yaoqingjf1','邀请积分1',3,'0','A','积分测试','2018-07-23 23:31:43','2018-07-23 23:31:43','N','dist','admin.dist',1,'0',0,NULL,0),(58,'dist','shunzhi','qingchao','mingchao.qingchao.shunzhi','顺治',3,'0','A','测试','2018-07-30 12:21:10','2018-07-30 12:21:10','N','dist','admin.dist',1,'0',10,NULL,0),(59,'zhangsan','wde','zhangsan','admin.zhangsan.wde','ss',2,'0','A','s','2018-07-30 12:24:44','2018-07-30 12:24:44','N','zhangsan','admin.zhangsan',1,'0',0,NULL,0),(60,'dist','wdess','zhangsan','admin.zhangsan.wdess','ssss',2,'0','A','s','2018-07-30 12:24:54','2018-07-30 12:24:54','N','dist','admin.dist',1,'0',0,NULL,0),(61,'dist','xxxx','qingchao','mingchao.qingchao.xxxx','xxxx',3,'0','A','','2018-10-12 23:55:38','2018-10-12 23:55:38','N','dist','admin.dist',1,'0',0,NULL,0),(62,'dist','demo','qingchao','mingchao.qingchao.demo','demo',3,'0','A','xxx','2018-10-13 00:02:32','2018-10-13 00:02:32','N','dist','admin.dist',1,'0',200,200,0),(63,'dist','test0001','qingchao','mingchao.qingchao.test0001','test0001',3,'0','A','','2018-10-13 00:23:39','2018-10-13 00:23:39','N','dist','admin.dist',1,'0',500,500,0),(64,'dist','yonghu1','qingchao','mingchao.qingchao.yonghu1','yonghu1',3,'0','A','1','2018-10-18 22:34:40','2018-10-18 22:34:40','N','dist','admin.dist',1,'0',0,NULL,0),(65,'dist','yiji_ceshi','dist','admin.dist.yiji_ceshi','测试',2,'10000','N1',NULL,'2018-10-20 16:41:10','2018-10-20 16:41:10','N','dist','admin.dist.yiji_ceshi',2,'1',0,NULL,0),(66,'dist','lilili','qingchao','mingchao.qingchao.lilili','lilili',3,'0','A','来源：plug测试','2018-12-09 20:27:32','2018-12-09 20:27:32','N','dist','admin.dist',1,'0',0,NULL,0),(67,'dist','xiaoerss','lilili','qingchao.lilili.xiaoerss','xiaoerss',3,'0','A','s ','2019-01-06 18:06:57','2019-01-06 18:06:57','N','dist','admin.dist',1,'0',0,NULL,0),(68,'dist','xxxx001',NULL,'xxxx001','xxxx001',0,'0','A','','2019-05-19 12:10:15','2019-05-19 12:10:15','N','admin','admin.dist',1,'0',0,0,0),(69,'dist','xxxx002',NULL,'xxxx002','xxxx002',0,'0','A','','2019-05-19 12:10:39','2019-05-19 12:10:39','N','admin','admin.dist',1,'0',0,0,0),(70,'dist','xxxx003',NULL,'xxxx003','xxxx003',0,'0','A','','2019-05-19 12:11:28','2019-05-19 12:11:28','N','admin','admin.dist',1,'0',0,0,0),(71,'dist','xxxx004',NULL,'xxxx004','xxxx004',0,'0','A','','2019-05-19 12:13:13','2019-05-19 12:13:13','N','admin','admin.dist',1,'0',0,0,0),(72,'dist','xxxx005',NULL,'xxxx005','xxxx005',0,'0','A','','2019-05-19 12:13:44','2019-05-19 12:13:44','N','admin','admin.dist',1,'0',0,0,0),(73,'dist','xxxx006',NULL,'xxxx006','xxxx006',0,'0','A','','2019-05-19 12:14:32','2019-05-19 12:14:32','N','admin','admin.dist',1,'0',0,0,0),(74,'dist','xxxx007',NULL,'xxxx007','xxxx007',0,'0','A','','2019-05-19 12:15:43','2019-05-19 12:15:43','N','admin','admin.dist',1,'0',0,0,0),(75,'dist','xxxx008',NULL,'xxxx008','xxxx008',0,'0','A','','2019-05-19 12:18:43','2019-05-19 12:18:43','N','admin','admin.dist',1,'0',0,0,0),(76,'dist','abc001','qingchao','mingchao.qingchao.abc001','abc001',3,'0','A','','2019-05-19 12:40:47','2019-05-19 12:40:47','N','admin','admin.dist',1,'0',0,0,0),(77,'lis','lis','admin','admin.lis','李四',1,'10000','N1',NULL,'2019-05-21 19:57:09','2019-05-21 19:57:09','N','admin','admin.lis',1,'1',0,0,0),(78,'lis','lismember',NULL,'lismember','李四',0,'0','A','系统自动生成，用于初始化数据','2019-05-21 19:57:09','2019-05-21 19:57:09','N','admin','admin.lis',1,'0',0,0,0),(81,'ccc','ccc','admin','admin.ccc','ccc',1,'10000','N1',NULL,'2019-05-21 20:00:18','2019-05-21 20:00:18','N','admin','admin.ccc',1,'1',0,0,0),(82,'ccc','cccmember',NULL,'cccmember','ccc',0,'0','A','系统自动生成，用于初始化数据','2019-05-21 20:00:18','2019-05-21 20:00:18','N','ccc','admin.ccc',1,'0',0,0,0),(83,'ccc','ssssssssssssssss','cccmember','cccmember.ssssssssssssssss','sssssss',1,'0','A','','2019-05-21 20:10:33','2019-05-21 20:10:33','N','ccc','admin',0,'0',0,0,0),(84,'ccc','ssssssssssssssss1','cccmember','cccmember.ssssssssssssssss1','sssssss1',1,'0','A','','2019-05-21 20:38:59','2019-05-21 20:38:59','N','ccc','admin',0,'0',0,0,0),(85,'ccc','tccc1','cccmember','cccmember.tccc1','tccc1',1,'0','A','','2019-05-21 20:50:28','2019-05-21 20:50:28','N','ccc','admin.ccc',1,'0',0,0,0),(86,'xguo','xguo','admin','admin.xguo','xguo',1,'10000','N1',NULL,'2019-05-21 20:53:00','2019-05-21 20:53:00','N','admin','admin.xguo',1,'1',0,0,0),(87,'xguo','xguomember',NULL,'xguomember','xguo',0,'0','A','系统自动生成，用于初始化数据','2019-05-21 20:53:00','2019-05-21 20:53:00','N','xguo','admin.xguo',1,'0',0,0,0),(88,'xguo','xguo11','xguomember','xguomember.xguo11','xguo11',1,'0','A','','2019-05-21 20:53:20','2019-05-21 20:53:20','N','xguo','admin.xguo',1,'0',0,0,0);
  
  /*Table structure for table `dis_profit_param` */
  
  DROP TABLE IF EXISTS `dis_profit_param`;
  
  CREATE TABLE `dis_profit_param` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `dis_platform_id` varchar(100) DEFAULT NULL COMMENT '平台id',
    `cal_model` varchar(100) NOT NULL COMMENT '计算模型，如 百分比和固定金额',
    `account_type` varchar(100) DEFAULT NULL COMMENT '账户类型，如上级发展下级分润 ，交易分润。。。。',
    `dis_pro_value` varchar(20) DEFAULT NULL COMMENT '分润值',
    `dis_pro_level` varchar(100) DEFAULT NULL COMMENT '从下往上对应的级别关系',
    `dis_user_type` varchar(10) DEFAULT NULL COMMENT '会员类型（1000：平台标示，其他为用户类型）',
    `is_delete` varchar(1) DEFAULT 'N' COMMENT '是否删除',
    `update_time` varchar(20) DEFAULT NULL COMMENT '更新时间',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `dist_trade_mode` varchar(20) DEFAULT NULL COMMENT '交易方式(分润或者提现)',
    `dis_user_rank` varchar(10) DEFAULT 'A' COMMENT '用户段位（青铜等）',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='分润参数设置';
  
  /*Data for the table `dis_profit_param` */
  
  insert  into `dis_profit_param`(`id`,`dis_platform_id`,`cal_model`,`account_type`,`dis_pro_value`,`dis_pro_level`,`dis_user_type`,`is_delete`,`update_time`,`add_time`,`dist_trade_mode`,`dis_user_rank`) values (6,'dist','1','0','1','1','10000','N',NULL,'2018-05-28 21:53:58','0','N1'),(7,'dist','0','0','0.01','1','0','N',NULL,'2018-05-30 15:46:21','0','A'),(9,'admin','1','0','60','1','10000','N',NULL,'2018-06-10 11:33:01',NULL,'N1'),(10,'dist','0','0','0.2','1','2','N',NULL,'2018-06-11 22:26:09',NULL,'A'),(11,'dist','1','1','1','1','0','N',NULL,'2018-06-11 22:26:57',NULL,'A'),(12,'dist','1','0','20','2','10000','N',NULL,'2018-06-26 17:31:30',NULL,'N1'),(13,'dist','0','0','0.1','4','0','N',NULL,'2018-07-19 22:05:44',NULL,'B'),(14,'dist','1','2','1','1','0','N',NULL,'2019-01-06 18:06:29',NULL,'A'),(15,'dist','0','0','1','2','10000','N',NULL,'2019-05-18 18:06:37',NULL,'N2'),(17,'dist','0','0','0.01','1','1','N',NULL,'2019-05-19 11:53:47',NULL,'A'),(18,'dist','1','2','10','2','1','N',NULL,'2019-05-19 12:13:03',NULL,'A');
  
  /*Table structure for table `dis_profit_record` */
  
  DROP TABLE IF EXISTS `dis_profit_record`;
  
  CREATE TABLE `dis_profit_record` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `profit_num` varchar(50) DEFAULT NULL COMMENT '收入编号',
    `dis_platform_id` varchar(100) DEFAULT NULL,
    `dis_get_user_id` varchar(100) DEFAULT NULL,
    `dis_set_user_id` varchar(100) DEFAULT NULL,
    `dis_amount` decimal(12,2) DEFAULT NULL,
    `account_type` varchar(100) DEFAULT NULL COMMENT '账户类型',
    `dis_note` varchar(400) DEFAULT NULL COMMENT '备注',
    `dis_user_type` varchar(400) DEFAULT NULL,
    `dis_order_id` varchar(20) DEFAULT NULL COMMENT '对应第三方订单编号',
    `is_delete` varchar(1) DEFAULT NULL,
    `add_time` varchar(20) DEFAULT NULL,
    `update_time` varchar(20) DEFAULT NULL,
    `type` varchar(10) DEFAULT '0' COMMENT '分类（0：用户分润 1:平台分润）',
    `before_amount` decimal(12,2) DEFAULT NULL COMMENT '交易前金额',
    `after_amount` decimal(12,2) DEFAULT NULL COMMENT '交易后金额',
    `before_pro_amount` decimal(12,2) DEFAULT NULL COMMENT '交易类型交易前金额',
    `after_pro_amount` decimal(12,2) DEFAULT NULL COMMENT '交易类型交易后金额',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=440 DEFAULT CHARSET=utf8 COMMENT='分润记录表';
  
  /*Data for the table `dis_profit_record` */
  
  insert  into `dis_profit_record`(`id`,`profit_num`,`dis_platform_id`,`dis_get_user_id`,`dis_set_user_id`,`dis_amount`,`account_type`,`dis_note`,`dis_user_type`,`dis_order_id`,`is_delete`,`add_time`,`update_time`,`type`,`before_amount`,`after_amount`,`before_pro_amount`,`after_pro_amount`) values (439,'PRO91240471803','dist','mingchao','abc001','10.00','2',NULL,'1',NULL,'N','2019-05-19 12:40:47','2019-05-19 12:40:47','0',NULL,NULL,NULL,NULL);
  
  /*Table structure for table `dis_rank_integral_record` */
  
  DROP TABLE IF EXISTS `dis_rank_integral_record`;
  
  CREATE TABLE `dis_rank_integral_record` (
    `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `dis_user_id` varchar(100) DEFAULT NULL COMMENT '用户id',
    `sys_integral` int(10) DEFAULT NULL COMMENT '系统积分',
    `is_use` varchar(2) DEFAULT 'N' COMMENT '是否使用（Y:使用,N未使用）',
    `is_expire` varchar(2) DEFAULT 'N' COMMENT '是否过期(Y:已过期，N未过期) 暂时不用',
    `before_integral` int(10) DEFAULT NULL COMMENT '使用前积分',
    `after_integral` int(10) DEFAULT NULL COMMENT '使用后积分',
    `expire_time` varchar(20) DEFAULT NULL COMMENT '到期时间（暂时不用）',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `account_type` varchar(10) DEFAULT NULL COMMENT '来源(交易、升级，下级升级)',
    `source_user_id` varchar(100) DEFAULT NULL COMMENT '来源用户id',
    `source_remak` varchar(200) DEFAULT NULL COMMENT '来源备注',
    `use_time` varchar(20) DEFAULT NULL COMMENT '使用时间',
    `use_remark` varchar(100) DEFAULT NULL COMMENT '使用备注',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='系统积分记录表';
  
  /*Data for the table `dis_rank_integral_record` */
  
  insert  into `dis_rank_integral_record`(`id`,`dis_user_id`,`sys_integral`,`is_use`,`is_expire`,`before_integral`,`after_integral`,`expire_time`,`add_time`,`account_type`,`source_user_id`,`source_remak`,`use_time`,`use_remark`) values (5,'qingchao',10,'N','N',110,120,'2021-04-18 23:31:43','2018-07-23 23:31:43','2','yaoqingjf1','您的邀请下级yaoqingjf1,您获得120积分',NULL,NULL),(6,'qingchao',10,'N','N',120,130,'2021-04-25 12:21:10','2018-07-30 12:21:10','2','shunzhi','您的邀请下级shunzhi,您获得130积分',NULL,NULL),(7,'qingchao',10,'N','N',130,140,'2021-04-25 12:21:28','2018-07-30 12:21:28','0','shunzhi','您的下级shunzhi交易100元,您获得140积分',NULL,NULL),(8,'shunzhi',10,'N','N',0,10,'2021-04-25 12:21:28','2018-07-30 12:21:28','0','shunzhi','您的下级shunzhi交易100元,您获得10积分',NULL,NULL),(9,'mingchao',100,'N','N',290,390,'2021-06-30 00:57:55','2018-10-04 00:57:55','0','qingchao','您的下级qingchao交易1000元,您获得390积分',NULL,NULL),(10,'mingchao',100,'N','N',390,490,'2021-07-08 23:54:46','2018-10-12 23:54:46','0','qingchao','您的下级qingchao交易1000元,您获得490积分',NULL,NULL),(11,'qingchao',10,'N','N',140,150,'2021-07-08 23:55:38','2018-10-12 23:55:38','2','xxxx','您的邀请下级xxxx,您获得150积分',NULL,NULL),(12,'qingchao',10,'N','N',150,160,'2021-07-09 00:02:32','2018-10-13 00:02:32','2','demo','您的邀请下级demo,您获得160积分',NULL,NULL),(13,'qingchao',200,'N','N',160,360,'2021-07-09 00:08:29','2018-10-13 00:08:29','0','demo','您的下级demo交易2000元,您获得360积分',NULL,NULL),(14,'demo',200,'N','N',0,200,'2021-07-09 00:08:29','2018-10-13 00:08:29','0','demo','您的下级demo交易2000元,您获得200积分',NULL,NULL),(15,'qingchao',10,'N','N',360,370,'2021-07-09 00:23:39','2018-10-13 00:23:39','2','test0001','您的邀请下级test0001,您获得370积分',NULL,NULL),(16,'qingchao',500,'N','N',370,870,'2021-07-09 00:29:53','2018-10-13 00:29:53','0','test0001','您的下级test0001交易5000元,您获得870积分',NULL,NULL),(17,'test0001',500,'N','N',0,500,'2021-07-09 00:29:53','2018-10-13 00:29:53','0','test0001','您的下级test0001交易5000元,您获得500积分',NULL,NULL),(18,'qingchao',10,'N','N',870,880,'2021-07-14 22:34:40','2018-10-18 22:34:40','2','yonghu1','您的邀请下级yonghu1,您获得880积分',NULL,NULL),(19,'mingchao',200,'N','N',490,690,'2021-07-14 22:37:48','2018-10-18 22:37:48','0','qingchao','您的下级qingchao交易2000元,您获得690积分',NULL,NULL),(20,'mingchao',100,'N','N',690,790,'2021-09-04 21:10:55','2018-12-09 21:10:55','0','qingchao','您的下级qingchao交易1000元,您获得790积分',NULL,NULL),(21,'mingchao',100,'N','N',790,890,'2021-09-04 21:11:18','2018-12-09 21:11:18','0','qingchao','您的下级qingchao交易1000元,您获得890积分',NULL,NULL),(22,'mingchao',200,'N','N',890,1090,'2021-10-07 20:25:18','2019-01-11 20:25:18','0','qingchao','您的下级qingchao交易1999元,您获得1090积分',NULL,NULL),(23,'mingchao',200,'N','N',1090,1290,'2021-10-07 20:25:19','2019-01-11 20:25:19','0','qingchao','您的下级qingchao交易1999元,您获得1290积分',NULL,NULL),(24,'mingchao',200,'N','N',1290,1490,'2021-10-07 20:25:19','2019-01-11 20:25:19','0','qingchao','您的下级qingchao交易1999元,您获得1490积分',NULL,NULL),(25,'qingchao',1000,'N','N',880,1880,'2022-02-11 22:27:26','2019-05-18 22:27:26','0','minguo','您的下级minguo交易10000元,您获得1880积分',NULL,NULL),(26,'minguo',2000,'N','N',0,2000,'2022-02-11 22:27:26','2019-05-18 22:27:26','0','minguo','您的下级minguo交易10000元,您获得2000积分',NULL,NULL),(27,'qingchao',1000,'N','N',1880,2880,'2022-02-11 22:36:52','2019-05-18 22:36:52','0','minguo','您的下级minguo交易10000元,您获得2880积分',NULL,NULL),(28,'minguo',2000,'N','N',2000,4000,'2022-02-11 22:36:52','2019-05-18 22:36:52','0','minguo','您的下级minguo交易10000元,您获得4000积分',NULL,NULL),(29,'qingchao',1000,'N','N',2880,3880,'2022-02-11 22:40:21','2019-05-18 22:40:21','0','minguo','您的下级minguo交易10000元,您获得3880积分',NULL,NULL),(30,'minguo',2000,'N','N',4000,6000,'2022-02-11 22:40:21','2019-05-18 22:40:21','0','minguo','您的下级minguo交易10000元,您获得6000积分',NULL,NULL),(31,'qingchao',1000,'N','N',3880,4880,'2022-02-11 22:41:01','2019-05-18 22:41:01','0','minguo','您的下级minguo交易10000元,您获得4880积分',NULL,NULL),(32,'minguo',2000,'N','N',6000,8000,'2022-02-11 22:41:01','2019-05-18 22:41:01','0','minguo','您的下级minguo交易10000元,您获得8000积分',NULL,NULL),(33,'qingchao',10000,'N','N',4880,14880,'2022-02-11 22:46:06','2019-05-18 22:46:06','0','minguo','您的下级minguo交易100000元,您获得14880积分',NULL,NULL),(34,'minguo',20000,'N','N',8000,28000,'2022-02-11 22:46:06','2019-05-18 22:46:06','0','minguo','您的下级minguo交易100000元,您获得28000积分',NULL,NULL),(35,'qingchao',10000,'N','N',14880,24880,'2022-02-11 22:48:22','2019-05-18 22:48:22','0','minguo','您的下级minguo交易100000元,您获得24880积分',NULL,NULL),(36,'minguo',20000,'N','N',28000,48000,'2022-02-11 22:48:22','2019-05-18 22:48:22','0','minguo','您的下级minguo交易100000元,您获得48000积分',NULL,NULL),(37,'qingchao',10000,'N','N',24880,34880,'2022-02-11 22:48:56','2019-05-18 22:48:56','0','minguo','您的下级minguo交易100000元,您获得34880积分',NULL,NULL),(38,'minguo',20000,'N','N',48000,68000,'2022-02-11 22:48:56','2019-05-18 22:48:56','0','minguo','您的下级minguo交易100000元,您获得68000积分',NULL,NULL),(39,'qingchao',10000,'N','N',34880,44880,'2022-02-11 22:49:39','2019-05-18 22:49:39','0','minguo','您的下级minguo交易100000元,您获得44880积分',NULL,NULL),(40,'minguo',20000,'N','N',68000,88000,'2022-02-11 22:49:39','2019-05-18 22:49:39','0','minguo','您的下级minguo交易100000元,您获得88000积分',NULL,NULL),(41,'qingchao',10000,'N','N',44880,54880,'2022-02-11 23:19:27','2019-05-18 23:19:27','0','minguo','您的下级minguo交易100000元,您获得54880积分',NULL,NULL),(42,'minguo',20000,'N','N',88000,108000,'2022-02-11 23:19:27','2019-05-18 23:19:27','0','minguo','您的下级minguo交易100000元,您获得108000积分',NULL,NULL),(43,'qingchao',10000,'N','N',54880,64880,'2022-02-12 10:19:12','2019-05-19 10:19:12','0','minguo','您的下级minguo交易100000元,您获得64880积分',NULL,NULL),(44,'minguo',20000,'N','N',108000,128000,'2022-02-12 10:19:12','2019-05-19 10:19:12','0','minguo','您的下级minguo交易100000元,您获得128000积分',NULL,NULL),(45,'qingchao',10000,'N','N',64880,74880,'2022-02-12 10:38:07','2019-05-19 10:38:07','0','minguo','您的下级minguo交易100000元,您获得74880积分',NULL,NULL),(46,'minguo',20000,'N','N',128000,148000,'2022-02-12 10:38:07','2019-05-19 10:38:07','0','minguo','您的下级minguo交易100000元,您获得148000积分',NULL,NULL),(47,'qingchao',10000,'N','N',74880,84880,'2022-02-12 11:16:56','2019-05-19 11:16:56','0','minguo','您的下级minguo交易100000元,您获得84880积分',NULL,NULL),(48,'minguo',20000,'N','N',148000,168000,'2022-02-12 11:16:56','2019-05-19 11:16:56','0','minguo','您的下级minguo交易100000元,您获得168000积分',NULL,NULL),(49,'qingchao',10000,'N','N',84880,94880,'2022-02-12 11:19:31','2019-05-19 11:19:31','0','minguo','您的下级minguo交易100000元,您获得94880积分',NULL,NULL),(50,'minguo',20000,'N','N',168000,188000,'2022-02-12 11:19:31','2019-05-19 11:19:31','0','minguo','您的下级minguo交易100000元,您获得188000积分',NULL,NULL),(51,'qingchao',10000,'N','N',94880,104880,'2022-02-12 11:20:01','2019-05-19 11:20:01','0','minguo','您的下级minguo交易100000元,您获得104880积分',NULL,NULL),(52,'minguo',20000,'N','N',188000,208000,'2022-02-12 11:20:01','2019-05-19 11:20:01','0','minguo','您的下级minguo交易100000元,您获得208000积分',NULL,NULL),(53,'qingchao',10000,'N','N',104880,114880,'2022-02-12 11:23:28','2019-05-19 11:23:28','0','minguo','您的下级minguo交易100000元,您获得114880积分',NULL,NULL),(54,'minguo',20000,'N','N',208000,228000,'2022-02-12 11:23:28','2019-05-19 11:23:28','0','minguo','您的下级minguo交易100000元,您获得228000积分',NULL,NULL),(55,'qingchao',10000,'N','N',114880,124880,'2022-02-12 11:23:52','2019-05-19 11:23:52','0','minguo','您的下级minguo交易100000元,您获得124880积分',NULL,NULL),(56,'minguo',20000,'N','N',228000,248000,'2022-02-12 11:23:52','2019-05-19 11:23:52','0','minguo','您的下级minguo交易100000元,您获得248000积分',NULL,NULL),(57,'qingchao',10000,'N','N',124880,134880,'2022-02-12 11:26:17','2019-05-19 11:26:17','0','minguo','您的下级minguo交易100000元,您获得134880积分',NULL,NULL),(58,'minguo',20000,'N','N',248000,268000,'2022-02-12 11:26:17','2019-05-19 11:26:17','0','minguo','您的下级minguo交易100000元,您获得268000积分',NULL,NULL),(59,'qingchao',10000,'N','N',134880,144880,'2022-02-12 11:45:56','2019-05-19 11:45:56','0','minguo','您的下级minguo交易100000元,您获得144880积分',NULL,NULL),(60,'minguo',20000,'N','N',268000,288000,'2022-02-12 11:45:56','2019-05-19 11:45:56','0','minguo','您的下级minguo交易100000元,您获得288000积分',NULL,NULL),(61,'qingchao',10000,'N','N',144880,154880,'2022-02-12 11:47:24','2019-05-19 11:47:24','0','minguo','您的下级minguo交易100000元,您获得154880积分',NULL,NULL),(62,'minguo',20000,'N','N',288000,308000,'2022-02-12 11:47:24','2019-05-19 11:47:24','0','minguo','您的下级minguo交易100000元,您获得308000积分',NULL,NULL),(63,'qingchao',10000,'N','N',154880,164880,'2022-02-12 11:53:13','2019-05-19 11:53:13','0','minguo','您的下级minguo交易100000元,您获得164880积分',NULL,NULL),(64,'minguo',20000,'N','N',308000,328000,'2022-02-12 11:53:13','2019-05-19 11:53:13','0','minguo','您的下级minguo交易100000元,您获得328000积分',NULL,NULL),(65,'qingchao',10000,'N','N',164880,174880,'2022-02-12 11:53:51','2019-05-19 11:53:51','0','minguo','您的下级minguo交易100000元,您获得174880积分',NULL,NULL),(66,'minguo',20000,'N','N',328000,348000,'2022-02-12 11:53:51','2019-05-19 11:53:51','0','minguo','您的下级minguo交易100000元,您获得348000积分',NULL,NULL);
  
  /*Table structure for table `dis_rank_param` */
  
  DROP TABLE IF EXISTS `dis_rank_param`;
  
  CREATE TABLE `dis_rank_param` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `dis_platform_id` varchar(100) DEFAULT NULL COMMENT '平台id',
    `cal_model` varchar(100) NOT NULL COMMENT '计算模型，如 百分比和固定金额',
    `account_type` varchar(100) DEFAULT NULL COMMENT '账户类型，如上级发展下级分润 ，交易分润。。。。',
    `dis_integral_value` varchar(20) DEFAULT NULL COMMENT '积分值',
    `dis_pro_level` varchar(100) DEFAULT NULL COMMENT '从下往上对应的级别关系',
    `dis_user_type` varchar(10) DEFAULT NULL COMMENT '会员类型（1000：平台标示，其他为用户类型）',
    `is_delete` varchar(1) DEFAULT 'N' COMMENT '是否删除',
    `update_time` varchar(20) DEFAULT NULL COMMENT '更新时间',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `dis_user_rank` varchar(10) DEFAULT 'A' COMMENT '用户段位（青铜等）',
    `dis_rank_name` varchar(50) DEFAULT NULL COMMENT '段位积分名称',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='分润参数设置';
  
  /*Data for the table `dis_rank_param` */
  
  insert  into `dis_rank_param`(`id`,`dis_platform_id`,`cal_model`,`account_type`,`dis_integral_value`,`dis_pro_level`,`dis_user_type`,`is_delete`,`update_time`,`add_time`,`dis_user_rank`,`dis_rank_name`) values (3,'dist','0','0','2','1','0','N',NULL,'2018-07-20 15:40:40','A','aaa'),(4,'dist','0','0','0.1','1','1','N',NULL,'2018-07-23 00:21:57','A','一级经理'),(5,'dist','0','0','0.2','0','0','N',NULL,'2018-07-23 00:23:47','A','自身_经理');
  
  /*Table structure for table `dis_trade_record` */
  
  DROP TABLE IF EXISTS `dis_trade_record`;
  
  CREATE TABLE `dis_trade_record` (
    `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `dis_user_id` varchar(100) DEFAULT NULL COMMENT '用户id',
    `trade_num` varchar(20) DEFAULT NULL COMMENT '第三方订单号',
    `trade_amount` decimal(12,2) DEFAULT '0.00' COMMENT '交易金额',
    `trade_time` varchar(20) DEFAULT NULL COMMENT '交易时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='交易金额记录表';
  
  /*Data for the table `dis_trade_record` */
  
  insert  into `dis_trade_record`(`id`,`dis_user_id`,`trade_num`,`trade_amount`,`trade_time`) values (1,'shunzhi','1sss','100.00','2018-07-30 12:21:28'),(2,'qingchao','333333','1000.00','2018-10-04 00:57:55'),(3,'qingchao','ssss','1000.00','2018-10-12 23:54:46'),(4,'demo','demo2018','2000.00','2018-10-13 00:08:29'),(5,'test0001','test0002018','5000.00','2018-10-13 00:29:53'),(6,'qingchao','xxxxxx','2000.00','2018-10-18 22:37:48'),(7,'qingchao','fdfasdf','1000.00','2018-12-09 21:10:55'),(8,'qingchao','3333333333333112','1000.00','2018-12-09 21:11:18'),(9,'qingchao','xxxx','1999.00','2019-01-11 20:25:18'),(10,'qingchao','xxxx','1999.00','2019-01-11 20:25:19'),(11,'qingchao','xxxx','1999.00','2019-01-11 20:25:19'),(12,'minguo','ceshi111111','10000.00','2019-05-18 22:27:26'),(13,'minguo','ceshi111111','10000.00','2019-05-18 22:36:52'),(14,'minguo','ceshi111111','10000.00','2019-05-18 22:40:21'),(15,'minguo','ceshi111111','10000.00','2019-05-18 22:41:01'),(16,'minguo','ceshi111111','100000.00','2019-05-18 22:46:06'),(17,'minguo','ceshi111111','100000.00','2019-05-18 22:48:22'),(18,'minguo','ceshi111111','100000.00','2019-05-18 22:48:56'),(19,'minguo','ceshi111111','100000.00','2019-05-18 22:49:39'),(20,'minguo','ceshi111111','100000.00','2019-05-18 23:19:27'),(21,'minguo','ceshi111111','100000.00','2019-05-19 10:19:12'),(22,'minguo','ceshi111111','100000.00','2019-05-19 10:38:07'),(23,'minguo','ceshi111111','100000.00','2019-05-19 11:16:56'),(24,'minguo','ceshi111111','100000.00','2019-05-19 11:19:31'),(25,'minguo','ceshi111111','100000.00','2019-05-19 11:20:01'),(26,'minguo','ceshi111111','100000.00','2019-05-19 11:23:28'),(27,'minguo','ceshi111111','100000.00','2019-05-19 11:23:52'),(28,'minguo','ceshi111111','100000.00','2019-05-19 11:26:17'),(29,'minguo','ceshi111111','100000.00','2019-05-19 11:45:56'),(30,'minguo','ceshi111111','100000.00','2019-05-19 11:47:24'),(31,'minguo','ceshi111111','100000.00','2019-05-19 11:53:13'),(32,'minguo','ceshi111111','100000.00','2019-05-19 11:53:51');
  
  /*Table structure for table `dis_upgrade_param` */
  
  DROP TABLE IF EXISTS `dis_upgrade_param`;
  
  CREATE TABLE `dis_upgrade_param` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `upgrade_name` varchar(100) DEFAULT NULL COMMENT '名称',
    `begin_integral` int(10) DEFAULT NULL COMMENT '开始金额',
    `end_integral` int(10) DEFAULT NULL COMMENT '结束金额',
    `dis_user_rank` varchar(10) DEFAULT NULL COMMENT '用户水平等级',
    `is_delete` varchar(2) DEFAULT 'N' COMMENT '是否删除',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `update_time` varchar(20) DEFAULT NULL COMMENT '修改时间',
    `identity_type` varchar(2) DEFAULT '0' COMMENT '0会员  1代理商',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='垂直升级配置表';
  
  /*Data for the table `dis_upgrade_param` */
  
  insert  into `dis_upgrade_param`(`id`,`upgrade_name`,`begin_integral`,`end_integral`,`dis_user_rank`,`is_delete`,`add_time`,`update_time`,`identity_type`) values (4,'23',1,2,'A','N','2018-10-19 19:09:22',NULL,'0');
  
  /*Table structure for table `dis_upgrade_record` */
  
  DROP TABLE IF EXISTS `dis_upgrade_record`;
  
  CREATE TABLE `dis_upgrade_record` (
    `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `dis_user_id` varchar(100) DEFAULT NULL COMMENT '用户id',
    `before_upgrade_level` varchar(10) DEFAULT NULL COMMENT '升级前等级',
    `after_upgrade_level` varchar(10) DEFAULT NULL COMMENT '升级后等级',
    `level_differ` varchar(2) DEFAULT NULL COMMENT '等级差额',
    `upgrade_time` varchar(20) DEFAULT NULL COMMENT '升级时间',
    `level_type` varchar(2) DEFAULT '0' COMMENT '升级类型(0:垂直升级 1：水平升级)',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户升级记录表';
  
  /*Data for the table `dis_upgrade_record` */
  
  insert  into `dis_upgrade_record`(`id`,`dis_user_id`,`before_upgrade_level`,`after_upgrade_level`,`level_differ`,`upgrade_time`,`level_type`) values (1,NULL,NULL,NULL,NULL,NULL,'0');
  
  /*Table structure for table `dis_withdraw_record` */
  
  DROP TABLE IF EXISTS `dis_withdraw_record`;
  
  CREATE TABLE `dis_withdraw_record` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `dis_user_id` varchar(50) DEFAULT NULL COMMENT '用户id',
    `withdraw_num` varchar(50) DEFAULT NULL COMMENT '提现单号',
    `total_amount` decimal(10,2) DEFAULT NULL COMMENT '提现金额',
    `fee_amount` decimal(10,2) DEFAULT NULL COMMENT '手续费',
    `real_amount` decimal(10,2) DEFAULT NULL COMMENT '实际到账金额',
    `withdraw_time` varchar(20) DEFAULT NULL COMMENT '提现时间',
    `handle_time` varchar(20) DEFAULT NULL COMMENT '处理时间',
    `withdraw_status` varchar(10) DEFAULT NULL COMMENT '处理状态',
    `account_type` varchar(10) DEFAULT NULL COMMENT '提现账户',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='提现表';
  
  /*Data for the table `dis_withdraw_record` */
  
  insert  into `dis_withdraw_record`(`id`,`dis_user_id`,`withdraw_num`,`total_amount`,`fee_amount`,`real_amount`,`withdraw_time`,`handle_time`,`withdraw_status`,`account_type`) values (2,'mingchao',NULL,'50.00','0.00','50.00','2018-05-31 21:48:19','2018-06-09 02:17:57','2','0'),(3,'mingchao',NULL,'50.00','2.00','48.00','2018-05-31 21:50:34','2018-06-09 02:18:21','3','0'),(4,'yuanchao','TX92016224444','100.00','2.00','98.00','2018-06-09 20:16:22','2018-06-09 20:16:42','2','0'),(5,'mingchao','TX10101382241','1.00','2.00','-1.00','2018-07-01 01:01:38','2018-07-01 01:02:03','3','0'),(6,'qingchao','TX01221486862','1.00','2.00','-1.00','2018-07-30 12:21:48',NULL,'1','0'),(7,'qingchao','TX82238093674','100.00','2.00','98.00','2018-10-18 22:38:09','2018-10-18 22:38:42','2','0'),(8,'liuxiug','TX82342412457','1500.00','1.00','1499.00','2018-10-18 23:42:41',NULL,'1','0'),(9,'liuxiug','TX82358127950','1000.00','2.00','998.00','2018-10-18 23:58:12',NULL,'1','0'),(10,'dist','TX01535351247','10.00','2.00','8.00','2018-10-20 15:35:35','2018-10-20 15:36:18','2','1');
  
  /*Table structure for table `dist_withdraw_param` */
  
  DROP TABLE IF EXISTS `dist_withdraw_param`;
  
  CREATE TABLE `dist_withdraw_param` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `begin_amount` decimal(10,2) DEFAULT NULL COMMENT '开始金额',
    `end_amount` decimal(10,2) DEFAULT NULL COMMENT '结束时间',
    `cal_model` varchar(10) DEFAULT NULL COMMENT '计算模型，如 百分比和固定金额',
    `dis_withdraw_value` varchar(50) DEFAULT NULL COMMENT '提现值',
    `is_delete` varchar(2) DEFAULT 'N' COMMENT '是否删除',
    `add_time` varchar(20) DEFAULT NULL COMMENT '添加时间',
    `update_time` varchar(20) DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='提现收费配置表';
  
  /*Data for the table `dist_withdraw_param` */
  
  insert  into `dist_withdraw_param`(`id`,`begin_amount`,`end_amount`,`cal_model`,`dis_withdraw_value`,`is_delete`,`add_time`,`update_time`) values (4,'0.00','1000.00','1','2','N','2018-05-31 21:50:19',NULL),(5,'1001.00','9999.00','1','1','N','2018-10-18 22:50:05',NULL);
  
  /*Table structure for table `sys_dic` */
  
  DROP TABLE IF EXISTS `sys_dic`;
  
  CREATE TABLE `sys_dic` (
    `dic_id` int(11) NOT NULL AUTO_INCREMENT,
    `dic_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `dic_notes` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `dic_order` int(11) DEFAULT NULL,
    `dic_type_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `dic_value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `is_delete` varchar(20) COLLATE utf8_bin DEFAULT 'N',
    `add_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    `ext_field` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '扩展字段',
    `ext_field2` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '扩展字段2',
    PRIMARY KEY (`dic_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10065 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='字典类型表';
  
  /*Data for the table `sys_dic` */
  
  insert  into `sys_dic`(`dic_id`,`dic_no`,`dic_notes`,`dic_order`,`dic_type_no`,`dic_value`,`is_delete`,`add_time`,`update_time`,`ext_field`,`ext_field2`) values (101,'1',NULL,NULL,'quanxianid','5','N',NULL,NULL,NULL,NULL),(102,'2',NULL,NULL,'quanxianid','7','N',NULL,NULL,NULL,NULL),(103,'3',NULL,NULL,'quanxianid','8','N',NULL,NULL,NULL,NULL),(104,'4',NULL,NULL,'quanxianid','9','N',NULL,NULL,NULL,NULL),(105,'5',NULL,NULL,'quanxianid','10','N',NULL,NULL,NULL,NULL),(10003,'1',NULL,NULL,'withdrawStatus','申请中','N',NULL,NULL,NULL,NULL),(10004,'2',NULL,NULL,'withdrawStatus','审核成功','N',NULL,NULL,NULL,NULL),(10005,'3',NULL,NULL,'withdrawStatus','审核拒绝','N',NULL,NULL,NULL,NULL),(10006,'profit','分润',NULL,'orderPrefix','PRO','N',NULL,NULL,NULL,NULL),(10007,'withdrawl','提现',NULL,'orderPrefix','TX','N',NULL,NULL,NULL,NULL),(10012,'3',NULL,NULL,'maxLevel','会员最大级别','N',NULL,NULL,NULL,NULL),(10013,'A',NULL,NULL,'disUserRank','青铜','N',NULL,NULL,NULL,NULL),(10014,'B',NULL,NULL,'disUserRank','黄金','N',NULL,NULL,NULL,NULL),(10015,'C',NULL,NULL,'disUserRank','铂金','N',NULL,NULL,NULL,NULL),(10016,'D',NULL,NULL,'disUserRank','钻石','N',NULL,NULL,NULL,NULL),(10024,'0','trade',NULL,'eventType','商品交易','N',NULL,NULL,NULL,NULL),(10025,'1','level',NULL,'eventType','升级','N',NULL,NULL,NULL,NULL),(10026,'2','invation',NULL,'eventType','邀请会员','N',NULL,NULL,NULL,NULL),(10029,'1000','单位为天，备用数据',NULL,'effectiveTime','积分有效时间','N',NULL,NULL,NULL,NULL),(10030,'Y',NULL,NULL,'isTotalIntegral','是否按照总积分计算','N',NULL,NULL,NULL,NULL),(10037,'0','即总金额*百分之比',NULL,'calModel','百分比','N',NULL,NULL,NULL,NULL),(10038,'1','固定金额',NULL,'calModel','固定金额','N',NULL,NULL,NULL,NULL),(10039,'0',NULL,NULL,'disRankLevel','自身','N',NULL,NULL,NULL,NULL),(10040,'1',NULL,NULL,'disRankLevel','一级','N',NULL,NULL,NULL,NULL),(10041,'2',NULL,NULL,'disRankLevel','二级','N',NULL,NULL,NULL,NULL),(10042,'3',NULL,NULL,'disRankLevel','三级','N',NULL,NULL,NULL,NULL),(10043,'4',NULL,NULL,'disRankLevel','四级','N',NULL,NULL,NULL,NULL),(10044,'1',NULL,NULL,'disProLevel','一级','N',NULL,NULL,NULL,NULL),(10045,'2',NULL,NULL,'disProLevel','二级','N',NULL,NULL,NULL,NULL),(10046,'3',NULL,NULL,'disProLevel','三级','N',NULL,NULL,NULL,NULL),(10047,'4',NULL,NULL,'disProLevel','四级','N',NULL,NULL,NULL,NULL),(10048,'0','trade',NULL,'accountType','交易分润','N',NULL,NULL,NULL,NULL),(10049,'1','level',NULL,'accountType','升级分润','N',NULL,NULL,NULL,NULL),(10050,'2','invite',NULL,'accountType','邀请分润','N',NULL,NULL,NULL,NULL),(10051,'N1',NULL,NULL,'agentRank','初级分销商','N',NULL,NULL,NULL,NULL),(10052,'N2',NULL,NULL,'agentRank','中级分销商','N',NULL,NULL,NULL,NULL),(10053,'N3',NULL,NULL,'agentRank','高级分销商','N',NULL,NULL,NULL,NULL),(10054,'0',NULL,NULL,'disUserType','游客','N',NULL,NULL,NULL,NULL),(10055,'1',NULL,NULL,'disUserType','经理','N',NULL,NULL,NULL,NULL),(10056,'2',NULL,NULL,'disUserType','老板','N',NULL,NULL,NULL,NULL),(10061,'0',NULL,NULL,'disUserPlatType','游客','N',NULL,NULL,NULL,NULL),(10062,'1',NULL,NULL,'disUserPlatType','经理','N',NULL,NULL,NULL,NULL),(10063,'2',NULL,NULL,'disUserPlatType','老板','N',NULL,NULL,NULL,NULL),(10064,'10000',NULL,NULL,'disUserPlatType','平台标识','N',NULL,NULL,NULL,NULL);
  
  /*Table structure for table `sys_dic_type` */
  
  DROP TABLE IF EXISTS `sys_dic_type`;
  
  CREATE TABLE `sys_dic_type` (
    `dic_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `dic_type_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `dic_type_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `dic_type_notes` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `dic_type_order` int(11) DEFAULT NULL,
    `system_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `is_delete` varchar(20) COLLATE utf8_bin DEFAULT 'N',
    `add_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`dic_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='字典表';
  
  /*Data for the table `sys_dic_type` */
  
  insert  into `sys_dic_type`(`dic_type_id`,`dic_type_name`,`dic_type_no`,`dic_type_notes`,`dic_type_order`,`system_no`,`is_delete`,`add_time`,`update_time`) values (42,'权限id','quanxianid',NULL,NULL,'pc','N',NULL,NULL),(44,'提现状态','withdrawStatus',NULL,NULL,'pc','N',NULL,NULL),(45,'订单前缀','orderPrefix',NULL,NULL,'pc','N',NULL,NULL),(47,'会员最大级别','maxLevel',NULL,NULL,'pc','N',NULL,NULL),(48,'段位','disUserRank',NULL,NULL,'pc','N',NULL,NULL),(52,'事件类型','eventType',NULL,NULL,'pc','N',NULL,NULL),(55,'积分有效时间','effectiveTime',NULL,NULL,'pc','N',NULL,NULL),(56,'是否按照总积分计算','isTotalIntegral',NULL,NULL,'pc','N',NULL,NULL),(59,'计算模型','calModel',NULL,NULL,'pc','N',NULL,NULL),(60,'积分等级','disRankLevel',NULL,NULL,'pc','N',NULL,NULL),(61,'用户等级','disProLevel',NULL,NULL,'pc','N',NULL,NULL),(62,'账户类型','accountType',NULL,NULL,'pc','N',NULL,NULL),(63,'代理级别','agentRank',NULL,NULL,'pc','N',NULL,NULL),(64,'用户类型','disUserType',NULL,NULL,'pc','N',NULL,NULL),(66,'用户平台类型','disUserPlatType',NULL,NULL,'pc','N',NULL,NULL);
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  