

DROP TABLE IF EXISTS `T_WITHDRAW_ORDER`;
CREATE TABLE `T_WITHDRAW_ORDER` (
`UUID`  varchar(32) NOT NULL ,
`PARTY_ID`  varchar(32) NOT NULL ,
`ORDER_NO`  varchar(32) ,
`AMOUNT` double,
`VOLUME` double,
`AMOUNT_FEE` double,
`METHOD`  varchar(32)  ,
`BANK`  varchar(256) , 
`ACCOUNT`  varchar(256) ,
`QDCODE`  varchar(64),
`DEPOSIT_BANK`  varchar(256) ,
`USERNAME`  varchar(256),
`FAILURE_MSG`  varchar(512)  ,
`CREATE_TIME`  datetime  ,
`TIME_SETTLE`  datetime  ,
`SUCCEEDED` int(11) DEFAULT NULL,
`CHAIN_ADDRESS`  varchar(128)  ,
`CURRENCY`  varchar(32)  ,
PRIMARY KEY (`UUID`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

create index INDEX_WITHDRAWORDER_PARTY_ID on T_WITHDRAW_ORDER (
   PARTY_ID,CREATE_TIME
);
create index INDEX_WITHDRAWORDER_SUCCEEDED on T_WITHDRAW_ORDER (
   SUCCEEDED,CREATE_TIME
);

