47 lines
1.2 KiB
SQL
Executable File
47 lines
1.2 KiB
SQL
Executable File
-- ----------------------------
|
|
-- Table structure for t_wallet
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `T_EXCHANGE_RATE`;
|
|
CREATE TABLE `T_EXCHANGE_RATE` (
|
|
`UUID` varchar(32) NOT NULL DEFAULT '' COMMENT '主键',
|
|
`OUT_OR_IN` varchar(32) ,
|
|
`RATA` double ,
|
|
`CURRENCY` varchar(32) ,
|
|
`NAME` varchar(64) ,
|
|
`CURRENCY_SYMBOL` varchar(32) ,
|
|
PRIMARY KEY (`uuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
create index INDEX_EXCHANGE_OUT_OR_IN on T_EXCHANGE_RATE (
|
|
OUT_OR_IN
|
|
);
|
|
|
|
|
|
DROP TABLE IF EXISTS `T_WALLET_LOG`;
|
|
CREATE TABLE `T_WALLET_LOG` (
|
|
`UUID` varchar(32) NOT NULL DEFAULT '' COMMENT '主键',
|
|
`PARTY_ID` varchar(32) NOT NULL DEFAULT '',
|
|
`ORDER_NO` varchar(64) ,
|
|
`AMOUNT` double ,
|
|
`STATUS` int ,
|
|
`CREATE_TIME` datetime ,
|
|
`CATEGORY` varchar(32) ,
|
|
PRIMARY KEY (`uuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
create index INDEX_WALLET_LOG_PARTY_ID on T_WALLET_LOG (
|
|
PARTY_ID,CREATE_TIME
|
|
);
|
|
|
|
|
|
DROP TABLE IF EXISTS `T_USER_RATE_CONFIG`;
|
|
CREATE TABLE `t_user_rate_config` (
|
|
`UUID` varchar(64) NOT NULL,
|
|
`OUT_OR_IN` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
|
|
`CURRENCY` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
|
|
`PARTY_ID` varchar(32) DEFAULT NULL,
|
|
PRIMARY KEY (`UUID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
|