Himall3.3(删除官方授权 含演示产品图片).rar

-- MySQL dump 10.13 Distrib 5.6.23, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: himall33 -- ------------------------------------------------------ -- Server version 5.6.25-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Table structure for table `himall_account` -- DROP TABLE IF EXISTS `himall_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `himall_account` ( `Id` bigint(20) NOT NULL AUTO_INCREMENT, `ShopId` bigint(20) NOT NULL COMMENT '店铺ID', `ShopName` varchar(100) NOT NULL COMMENT '店铺名称', `AccountDate` datetime NOT NULL COMMENT '出账日期', `StartDate` datetime NOT NULL COMMENT '开始时间', `EndDate` datetime NOT NULL COMMENT '结束时间', `Status` int(11) NOT NULL COMMENT '枚举 0未结账，1已结账', `ProductActualPaidAmount` decimal(18,2) NOT NULL COMMENT '商品实付总额', `FreightAmount` decimal(18,2) NOT NULL COMMENT '运费', `CommissionAmount` decimal(18,2) NOT NULL COMMENT '佣金', `RefundCommissionAmount` decimal(18,2) NOT NULL COMMENT '退还佣金', `RefundAmount` decimal(18,2) NOT NULL COMMENT '退款金额', `AdvancePaymentAmount` decimal(18,2) NOT NULL COMMENT '预付款总额', `PeriodSettlement` decimal(18,2) NOT NULL COMMENT '本期应结', `Remark` text, `Brokerage` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '分销佣金', `ReturnBrokerage` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '退还分销佣金', PRIMARY KEY (`Id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=478 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `himall_account` -- LOCK TABLES `himall_account` WRITE; /*!40000 ALTER TABLE `himall_account` DISABLE KEYS */; INSERT INTO `himall_account` VALUES (157,0,'系统定时任务结算','2017-02-15 00:50:00','2017-02-14 00:00:00','2017-02-15 00:00:00',1,592.20,0.00,0.00,0.00,0.00,0.00,592.20,NULL,0.00,0.00),(158,0,'系统定时任务结算','2017-02-16 00:50:00','2017-02-15 00:00:00','2017-02-16 00:00:00',1,0.00,0.00,0.00,0.00,0.00,0.00,0.00,NULL,0.00,0.00),(159,0,'系统定时任务结算','2017-02-17 00:50:00','2017-02-16 00:00:00','2017-02-17 00:00:00',1,0.00,0.00,0.00,0.00,0.00,0.00,0.00,NULL,0.00,0.00),(160,0,'系统定时任务结算','2017-02-18 00:50:00','2017-02-17 00:00:00','2017-02-18 00:00:00',1,0.00,0.00,0.00,0.00,0.00,0.00,0.00,NULL,0.00,0.00),(161,0,'系统定时任务结算','2017-02-19 00:50:00','2017-02-18 00:00:00','2017-02-19 00:00:00',1,0.00,0.00,0.00,0.00,0.00,0.00,0.00,NULL,0.00,0.00),(162,0,'系统定时任务结算','2017-02-20 09:50:01','2017-02-19 00:00:00','2017-02-20 00:00:00',1,0.00,0.00,0.00,0.00,0.00,0.00,0.00,NULL,0.00,0.00); /*!40000 ALTER TABLE `himall_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `himall_accountdetail` -- DROP TABLE IF EXISTS `himall_accountdetail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `himall_accountdetail` ( `Id` bigint(20) NOT NULL AUTO_INCREMENT, `AccountId` bigint(20) NOT NULL COMMENT '结算记录外键', `ShopId` bigint(20) NOT NULL COMMENT '店铺ID', `ShopName` varchar(100) DEFAULT NULL, `Date` datetime NOT NULL COMMENT '完成日期', `OrderDate` datetime NOT NULL COMMENT '订单下单日期', `OrderFinshDate` datetime NOT NULL, `OrderType` int(11) NOT NULL COMMENT '枚举 完成订单1，退订单0', `OrderId` bigint(20) NOT NULL COMMENT '订单ID', `OrderAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额', `ProductActualPaidAmount` decimal(18,2) NOT NULL COMMENT '商品实付总额', `FreightAmount` decimal(18,2) NOT NULL COMMENT '运费金额', `TaxAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '税费', `IntegralDiscount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '积分抵扣金额', `CommissionAmount` decimal(18,2) NOT NULL COMMENT '佣金', `RefundTotalAmount` decimal(18,2) NOT NULL COMMENT '退款金额', `RefundCommisAmount` decimal(18,2) NOT NULL COMMENT '退还佣金', `OrderRefundsDates` varchar(300) NOT NULL COMMENT '退单的日期集合以;分隔', `BrokerageAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '分销佣金', `ReturnBrokerageAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '退分销佣金', `SettlementAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '结算金额', `PaymentTypeName` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`) USING BTREE, KEY `himall_accountdetails_ibfk_1` (`AccountId`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1090 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `himall_accountdetail` -- LOCK TABLES `himall_accountdetail` WRITE; /*!40000 ALTER TABLE `himall_accountdetail` DISABLE KEYS */; INSERT INTO `himall_accountdetail` VALUES (532,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:21:30',1,2017021497119677,29.90,29.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,29.90,'平台线下收款'),(533,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:20:57',1,2017021461330622,59.80,59.80,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,59.80,'平台线下收款'),(534,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:20:42',1,2017021429247711,29.90,29.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,29.90,'平台线下收款'),(535,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:20:09',1,2017021464824161,29.90,29.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,29.90,'平台线下收款'),(536,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:19:52',1,2017021489566321,29.90,29.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,29.90,'平台线下收款'),(537,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:05:46',1,2017021478928561,59.90,59.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,59.90,'平台线下收款'),(538,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:05:31',1,2017021468050488,59.90,59.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,59.90,'平台线下收款'),(539,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:05:16',1,2017021441459359,59.90,59.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,59.90,'平台线下收款'),(540,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:05:00',1,2017021468018578,59.90,59.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,59.90,'平台线下收款'),(541,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 15:04:39',1,2017021495260570,59.90,59.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,59.90,'平台线下收款'),(542,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 11:00:42',1,2017021432635793,11.90,11.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,11.90,'预付款支付'),(543,157,1,'官方自营店','2017-02-15 00:50:00','0001-01-01 00:00:00','2017-02-14 11:00:37',1,2017021495275742,29.90,29.90,0.00,0.00,0.00,0.00,0.00,0.00,'',0.00,0.00,29.90,'预付款支付'),(544,157,1,'官方自营店','2017-02-15 00