33 lines
802 B
SQL
Executable File
33 lines
802 B
SQL
Executable File
|
|
|
|
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
|
|
);
|
|
|