/*表结构：*/
CREATE TABLE `eb_order_ali_20` (
  `TXTYPE` varchar(20) DEFAULT NULL,
  `STATUS` varchar(20) DEFAULT NULL,
  `TOTAL_FEE` int(11) DEFAULT NULL,
  `TXDATE` varchar(20) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `TILLID` varchar(50) DEFAULT NULL,
  `MALLID` varchar(50) DEFAULT NULL,
  `CRC` varchar(40) DEFAULT NULL,
  `CASHIERNO` varchar(50) DEFAULT NULL,
  `LAST_MODIFY_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `STORECODE` varchar(50) DEFAULT NULL,
  `SHOPCODE` varchar(50) DEFAULT NULL,
  `BUYER_LOGIN_ID` varchar(100) DEFAULT NULL,
  `BUYER_USER_ID` varchar(100) DEFAULT NULL,
  `OUT_TRADE_NO` varchar(100) DEFAULT NULL,
  `TRADE_NO` varchar(100) DEFAULT NULL,
  `OUT_REQUEST_NO` varchar(100) DEFAULT NULL,
  `ALIPAY_REFUND_NO` varchar(100) DEFAULT NULL,
  `SELLER_ID` varchar(100) DEFAULT NULL,
  `TERMINAL_TYPE` varchar(10) DEFAULT NULL,
  `APPID_ALI` varchar(100) DEFAULT NULL,
  `MERCHANT_PRIVATE_KEY` varchar(500) DEFAULT NULL,
  `RESULTEXTOBJ` varchar(2000) DEFAULT NULL,
  `COUPONFEE` int(11) DEFAULT '0',
  `ACTUALFEE` int(11) DEFAULT '0',
  `ALI_SHOPID` varchar(100) DEFAULT NULL,
  `ALI_TOKEN` varchar(100) DEFAULT NULL
) ;

CREATE TABLE `eb_order_ali_oversea` (
  `TXTYPE` varchar(20) DEFAULT NULL,
  `STATUS` varchar(20) DEFAULT NULL,
  `TOTAL_FEE` int(11) DEFAULT NULL,
  `TXDATE` varchar(20) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `TILLID` varchar(50) DEFAULT NULL,
  `MALLID` varchar(50) DEFAULT NULL,
  `CRC` varchar(40) DEFAULT NULL,
  `CASHIERNO` varchar(50) DEFAULT NULL,
  `LAST_MODIFY_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `STORECODE` varchar(50) DEFAULT NULL,
  `SHOPCODE` varchar(50) DEFAULT NULL,
  `BUYER_LOGIN_ID` varchar(100) DEFAULT NULL,
  `BUYER_USER_ID` varchar(100) DEFAULT NULL,
  `OUT_TRADE_NO` varchar(100) DEFAULT NULL,
  `TRADE_NO` varchar(100) DEFAULT NULL,
  `OUT_REQUEST_NO` varchar(100) DEFAULT NULL,
  `ALIPAY_REFUND_NO` varchar(100) DEFAULT NULL,
  `SELLER_ID` varchar(100) DEFAULT NULL,
  `TERMINAL_TYPE` varchar(10) DEFAULT NULL,
  `PARTNER_OVERSEA` varchar(100) DEFAULT NULL,
  `KEY_OVERSEA` varchar(100) DEFAULT NULL,
  `RESULTEXTOBJ` varchar(2000) DEFAULT NULL,
  `FEE_TYPE` varchar(20) DEFAULT NULL,
  `COUPONFEE` int(11) DEFAULT '0',
  `ACTUALFEE` int(11) DEFAULT '0'
);

CREATE TABLE `eb_order_wx` (
  `TXTYPE` varchar(20) DEFAULT NULL,
  `STATUS` varchar(20) DEFAULT NULL,
  `TOTAL_FEE` int(11) DEFAULT NULL,
  `TXDATE` varchar(20) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `TILLID` varchar(50) DEFAULT NULL,
  `MALLID` varchar(50) DEFAULT NULL,
  `CRC` varchar(40) DEFAULT NULL,
  `CASHIERNO` varchar(50) DEFAULT NULL,
  `LAST_MODIFY_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `STORECODE` varchar(50) DEFAULT NULL,
  `SHOPCODE` varchar(50) DEFAULT NULL,
  `OUT_TRADE_NO` varchar(100) DEFAULT NULL,
  `TRADE_NO` varchar(100) DEFAULT NULL,
  `TERMINAL_TYPE` varchar(10) DEFAULT NULL,
  `OUT_REFUND_NO` varchar(100) DEFAULT NULL,
  `REFUND_ID` varchar(100) DEFAULT NULL,
  `OPENID` varchar(100) DEFAULT NULL,
  `BODY` varchar(200) DEFAULT NULL,
  `APPID` varchar(100) DEFAULT NULL,
  `APPKEY` varchar(500) DEFAULT NULL,
  `PARTNERKEY` varchar(100) DEFAULT NULL,
  `PARTNERID` varchar(100) DEFAULT NULL,
  `RESULTEXTOBJ` varchar(2000) DEFAULT NULL,
  `COUPONFEE` int(11) DEFAULT '0',
  `ACTUALFEE` int(11) DEFAULT '0',
  `USER_ID` varchar(50) DEFAULT NULL,
  `MCH_ID` varchar(50) DEFAULT NULL
);

CREATE TABLE `eb_order_wx_oversea` (
  `TXTYPE` varchar(20) DEFAULT NULL,
  `STATUS` varchar(20) DEFAULT NULL,
  `TOTAL_FEE` int(11) DEFAULT NULL,
  `TXDATE` varchar(20) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `TILLID` varchar(50) DEFAULT NULL,
  `MALLID` varchar(50) DEFAULT NULL,
  `CRC` varchar(40) DEFAULT NULL,
  `CASHIERNO` varchar(50) DEFAULT NULL,
  `LAST_MODIFY_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `STORECODE` varchar(50) DEFAULT NULL,
  `SHOPCODE` varchar(50) DEFAULT NULL,
  `OUT_TRADE_NO` varchar(100) DEFAULT NULL,
  `TRADE_NO` varchar(100) DEFAULT NULL,
  `TERMINAL_TYPE` varchar(10) DEFAULT NULL,
  `OUT_REFUND_NO` varchar(100) DEFAULT NULL,
  `REFUND_ID` varchar(100) DEFAULT NULL,
  `OPENID` varchar(100) DEFAULT NULL,
  `BODY` varchar(200) DEFAULT NULL,
  `APPID` varchar(100) DEFAULT NULL,
  `APPKEY` varchar(500) DEFAULT NULL,
  `PARTNERKEY` varchar(100) DEFAULT NULL,
  `PARTNERID` varchar(100) DEFAULT NULL,
  `RESULTEXTOBJ` varchar(2000) DEFAULT NULL,
  `COUPONFEE` int(11) DEFAULT '0',
  `ACTUALFEE` int(11) DEFAULT '0',
  `USER_ID` varchar(50) DEFAULT NULL,
  `MCH_ID` varchar(50) DEFAULT NULL,
  `FEE_TYPE` varchar(20) DEFAULT NULL
) ;


CREATE TABLE `eb_params` (
  `STR_KEY` varchar(40) NOT NULL,
  `STR_VALUE` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`STR_KEY`)
);

CREATE TABLE `eb_paylog` (
  `REQ_TXDATE` varchar(20) DEFAULT NULL,
  `REQ_MALLID` varchar(20) DEFAULT NULL,
  `REQ_STORECODE` varchar(50) DEFAULT NULL,
  `REQ_TILLID` varchar(20) DEFAULT NULL,
  `REQ_CASHIERNO` varchar(20) DEFAULT NULL,
  `REQ_DATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `REQ_OBJ` varchar(1000) DEFAULT NULL,
  `RES_ERR` varchar(100) DEFAULT NULL,
  `RES_MSG` varchar(500) DEFAULT NULL,
  `RES_OBJ` varchar(2000) DEFAULT NULL,
  `REQ_CRC` varchar(40) DEFAULT NULL,
  `REQ_ACTION` varchar(50) DEFAULT NULL,
  `REQ_SHOP_CODE` varchar(50) DEFAULT NULL,
  `REQ_TERMINAL_TYPE` varchar(10) DEFAULT NULL,
  `REQ_TYPE` varchar(20) DEFAULT NULL,
  `REQ_ACCOUNT_MODE` varchar(5) DEFAULT NULL
) ;

CREATE TABLE `eb_seller` (
  `EB_SELLER_ID` varchar(40) NOT NULL,
  `EB_KEY` varchar(60) DEFAULT NULL,
  `EB_CREATEDATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `EB_CREATEBY` varchar(40) DEFAULT NULL,
  `EB_LASTMODIFYDATE` datetime DEFAULT CURRENT_TIMESTAMP,
  `EB_LASTMODIFYBY` varchar(40) DEFAULT NULL,
  `EB_DESC` varchar(100) DEFAULT NULL,
  `XF_CUSTOMERID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`EB_SELLER_ID`)
);

CREATE TABLE `eb_seller_ali_20` (
  `STORECODE` varchar(30) DEFAULT NULL,
  `EB_SELLER_ID` varchar(30) DEFAULT NULL,
  `APPID_ALI` varchar(50) DEFAULT NULL,
  `MERCHANT_PRIVATE_KEY` varchar(200) DEFAULT NULL,
  `SIGN` varchar(20) DEFAULT NULL,
  `SELLEREMAIL` varchar(100) DEFAULT NULL,
  `FTPPWD` varchar(50) DEFAULT NULL,
  `FTPUSER` varchar(50) DEFAULT NULL,
  `ALI_ISUNDERTT` varchar(100) DEFAULT '0',
  `ALI_SHOPID` varchar(50) DEFAULT NULL,
  `ALI_TOKEN` varchar(100) DEFAULT NULL,
  `ALI_ISKOUBEI` varchar(20) DEFAULT '0'
);

CREATE TABLE `eb_seller_ali_oversea` (
  `STORECODE` varchar(40) NOT NULL,
  `PARTNER_OVERSEA` varchar(50) DEFAULT NULL,
  `KEY_OVERSEA` varchar(100) DEFAULT NULL,
  `AGENTID` varchar(50) DEFAULT NULL,
  `EB_SELLER_ID` varchar(40) DEFAULT NULL,
`MCC_OVERSEA` varchar(40) DEFAULT NULL,
  `SIGN` varchar(100) DEFAULT NULL
);

CREATE TABLE `eb_seller_wx` (
  `STORECODE` varchar(40) NOT NULL,
  `PARTNERID` varchar(50) DEFAULT NULL,
  `PARTNERKEY` varchar(100) DEFAULT NULL,
  `APPID` varchar(50) DEFAULT NULL,
  `CERTPATH` varchar(200) DEFAULT NULL,
  `USER_ID` varchar(40) DEFAULT NULL,
  `USER_PASSWORD` varchar(40) DEFAULT NULL,
  `MCH_ID` varchar(40) DEFAULT NULL,
  `EB_SELLER_ID` varchar(40) NOT NULL,
  `CERTPWD` varchar(40) DEFAULT NULL,
  `SIGN` varchar(100) DEFAULT NULL,
  `ISUNDERTT` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`EB_SELLER_ID`)
);

CREATE TABLE `eb_seller_wx_oversea` (
  `STORECODE` varchar(40) NOT NULL,
  `PARTNERID` varchar(50) DEFAULT NULL,
  `PARTNERKEY` varchar(100) DEFAULT NULL,
  `APPID` varchar(50) DEFAULT NULL,
  `CERTPATH` varchar(100) DEFAULT NULL,
  `USER_ID` varchar(40) DEFAULT NULL,
  `USER_PASSWORD` varchar(40) DEFAULT NULL,
  `MCH_ID` varchar(40) DEFAULT NULL,
  `EB_SELLER_ID` varchar(40) DEFAULT NULL,
  `SIGN` varchar(100) DEFAULT NULL,
  `CERTPWD` varchar(200) DEFAULT NULL
);

CREATE TABLE `xf_statement` (
  `XF_TXDATE` date NOT NULL,
  `XF_TXTIME` varchar(6) NOT NULL,
  `XF_CARDNO` varchar(50) DEFAULT NULL,
  `XF_CARDTYPE` varchar(10) NOT NULL,
  `XF_ACTION` varchar(10) NOT NULL,
  `XF_REFERENCENO` varchar(70) DEFAULT NULL,
  `XF_AMOUNT` decimal(16,4) NOT NULL,
  `XF_CARDRATEAMT` decimal(16,4) NOT NULL,
  `XF_TERMINALID` varchar(50) DEFAULT NULL,
  `XF_SUPPCODE` varchar(50) DEFAULT NULL,
  `XF_STATUS` varchar(2) NOT NULL DEFAULT '10',
  `XF_CONFIRMBY` varchar(10) DEFAULT 'admin',
  `XF_CONFIRMDATE` datetime DEFAULT NULL,
  `XF_IMPORTDATE` datetime DEFAULT NULL,
  `XF_LASTMODBY` varchar(10) NOT NULL DEFAULT 'admin',
  `XF_LASTMODTIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `EB_ORDER_DATETIME` datetime DEFAULT NULL,
  `XF_TTORDERID` varchar(50) NOT NULL,
  `EB_APPID` varchar(50) DEFAULT NULL,
  `EB_MCHID` varchar(100) DEFAULT NULL,
  `XF_PREFERENTIALAMT` int(11) DEFAULT '0',
  `XF_CARDRATE` varchar(20) DEFAULT NULL
) ;
CREATE TABLE EB_SELLER_EXT 
(
  EB_SELLER_ID VARCHAR(20) NOT NULL 
, 

EB_ERRLANG VARCHAR(20) 
, EB_CURRENCY VARCHAR(20) 
, CONSTRAINT 

EB_SELLER_EXT_PK PRIMARY KEY 
  (
    EB_SELLER_ID 
  )
) ;

CREATE TABLE EB_LANGUAGE 
(
  SC VARCHAR(1000 ) 
, EN VARCHAR(1000 ) 
, 

EB_ERR_CODE VARCHAR(20 ) NOT NULL 
, CONSTRAINT EB_LANGUAGE_PK PRIMARY 

KEY 
  (
    EB_ERR_CODE 
  )

) ;

ALTER TABLE eb_language 
CHANGE COLUMN `SC` `SC` VARCHAR(1000) NULL 

DEFAULT '简体中文' ,
CHANGE COLUMN `EN` `EN` VARCHAR(1000) NULL DEFAULT 

'英文' ,
CHANGE COLUMN `EB_ERR_CODE` `EB_ERR_CODE` VARCHAR(20) NOT NULL 

DEFAULT '异常代码' ;

/*数据：*/
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('收单行对订单业务

处理异常','Order-processing Error(from Acquirer-side)','401');
Insert 

into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('访问收单行接口时数据合法

性或网络状态异常','Error in data legality and network status when 

accessing interface of the acquiring bank','402');
Insert into 

EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('前置机接口运行时异

常','Runtime Error(server-side)','403');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('请求的订单号与订单金额不一致','Mismatched 

OrderID and Transaction Amount','406');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('请求的订单号超过补录时间或销售店铺，收银

机终端不一致','Failure in requesting for additional recording due to 

expires, and mismatch between OrderID,record of Transaction,and record 

of POS. 
','407');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('

该收银机上，找不到匹配的退款交易','Nonexistent record of refund 

transaction (on POS)','412');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('该支付方式已禁止支付操作','Mode of 

payment has been prohibited','420');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('收单行对订单业务处理异常','Order-

processing Error(from Acquirer-side)','501');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('访问收单行接口时数据合法性或网络状态异

常','Error in data legality and network status when accessing 

interface of the acquiring bank','502');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('前置机接口运行时异常','Runtime Error

(server-side)','503');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) 

values ('请求的订单号与订单金额不一致','Mismatched OrderID and 

Transaction Amount','506');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) 

values ('请求的订单号超过补录时间或销售店铺，收银机终端不一

致','Failure in requesting for additional recording due to expires, 

and mismatch between OrderID,record of Transaction,and record of POS. 

','507');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('该收银机

上，找不到匹配的退款交易','Nonexistent record of refund transaction 

(on POS)','512');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('

该支付方式已禁止支付操作','Mode of payment has been 

prohibited','520');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values 

('收单行对订单业务处理异常','Order-processing Error(from Acquirer-

side)','601');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('访

问收单行接口时数据合法性或网络状态异常','Error in data legality and 

network status when accessing interface of the acquiring 

bank','602');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('前置

机接口运行时异常','Runtime Error(server-side)','603');
Insert into 

EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('请求的订单号与订单金额不一

致','Mismatched OrderID and Transaction Amount','606');
Insert into 

EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('请求的订单号超过补录时间或销

售店铺，收银机终端不一致','Failure in requesting for additional 

recording due to expires, and mismatch between OrderID,record of 

Transaction,and record of POS. ','607');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('该收银机上，找不到匹配的退款交

易','Nonexistent record of refund transaction (on POS)','612');
Insert 

into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('该支付方式已禁止支付操作

','Mode of payment has been prohibited','620');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('搜索订单没有匹配的记录','Nonexistent 

record of transaction','109');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('搜索订单交易流水号不能为空值','Missing 

Transaction Number (when searching)','111');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('在指定的原交易日中找不到该编号的原销售

单','Nonexistent transaction ticket in selected transaction 

date','112');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('该支

付方式暂不支持该功能','Service(Function)unavailable on the selected 

mode of payment','130');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) 

values ('CRC值重复，该请求可能是重复发送','CRC repeated,and likely 

with request being sent repeatedly','301');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('其他异常,详情请查看系统日

志','Unidentified Error,please check system log for detail','100');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) values ('数据库连接异

常','Error in Database connection','200');
Insert into EB_LANGUAGE 

(SC,EN,EB_ERR_CODE) values ('等待用户支付中（通常为等待用户输入支付密

码）','Payment processing (usually refers to waiting for consumers to 

enter password )','666');
Insert into EB_LANGUAGE (SC,EN,EB_ERR_CODE) 

values ('等待用户支付超时并已撤销该订单','Transaction canceled due to 

payment overtime','888');

/*序列：*/

DROP TABLE IF EXISTS sequence;
CREATE TABLE IF NOT EXISTS `sequence` (  
  `name` 

varchar(50) NOT NULL,  
  `current_value` int(11) NOT NULL,  
  

`increment` int(11) NOT NULL DEFAULT '1'  
) ENGINE=InnoDB DEFAULT 

CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='

序列表，命名s_[table_name]';  
INSERT INTO `sequence` (`name`, 

`current_value`, `increment`) VALUES  
('s_blog_account', 0, 1) ;

DROP FUNCTION IF EXISTS `currval`;  
DELIMITER //  
CREATE  FUNCTION 

`currval`(seq_name VARCHAR(50)) RETURNS int(11)  
    READS SQL DATA  
  

  DETERMINISTIC  
BEGIN  
DECLARE VALUE INTEGER;  
SET VALUE = 0;  
SELECT 

current_value INTO VALUE FROM sequence WHERE NAME = seq_name;  
RETURN 

VALUE;  
END//  
DELIMITER ;

DROP FUNCTION IF EXISTS `nextval`;  
DELIMITER //  
CREATE  FUNCTION `nextval`(seq_name VARCHAR(50)) RETURNS 

int(11)  
    DETERMINISTIC  
BEGIN  
UPDATE sequence SET current_value = 

current_value + increment WHERE NAME = seq_name;  
RETURN currval

(seq_name);  
END//  
DELIMITER ;