53 lines
1.5 KiB
SQL
Executable File
53 lines
1.5 KiB
SQL
Executable File
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
|
-- Table structure for `T_FINANCE`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `T_FINANCE`;
|
|
CREATE TABLE `T_FINANCE` (
|
|
`UUID` varchar(32) CHARACTER SET utf8 NOT NULL,
|
|
`NAME` varchar(32) DEFAULT NULL,
|
|
`IMG` varchar(64) DEFAULT NULL,
|
|
`CYCLE` varchar(32) DEFAULT NULL,
|
|
`DAILY_RATE` double DEFAULT NULL,
|
|
`TODAY_RATE` double DEFAULT NULL,
|
|
`DEFAULT_RATIO` double DEFAULT NULL,
|
|
`INVESTMENT_MIN` double DEFAULT NULL,
|
|
`INVESTMENT_MAX` double DEFAULT NULL,
|
|
`STATE` varchar(32) DEFAULT NULL,
|
|
|
|
PRIMARY KEY (`UUID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS `T_FINANCE_ORDER`;
|
|
CREATE TABLE `T_FINANCE_ORDER` (
|
|
`UUID` varchar(32) CHARACTER SET utf8 NOT NULL,
|
|
`PARTY_ID` varchar(32) ,
|
|
`ORDER_NO` varchar(64) ,
|
|
`FINANCE_ID` varchar(32) ,
|
|
`CYCLE` int ,
|
|
`AMOUNT` double ,
|
|
`EARN_TIME` datetime ,
|
|
`STOP_TIME` datetime ,
|
|
`CREATE_TIME` datetime ,
|
|
`CLOSE_TIME` datetime ,
|
|
`PROFIT` double ,
|
|
`STATE` varchar(32) DEFAULT NULL,
|
|
|
|
PRIMARY KEY (`UUID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
|
|
|
|
ALTER TABLE `T_FINANCE`
|
|
ADD COLUMN `NAME_EN` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `NAME`,
|
|
ADD COLUMN `NAME_CN` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `NAME_EN`;
|
|
ALTER TABLE `T_FINANCE`
|
|
ADD COLUMN `DAILY_RATE_MAX` double NULL DEFAULT 0;
|
|
|
|
update T_FINANCE finance set finance.DAILY_RATE_MAX = finance.DAILY_RATE
|
|
where finance.DAILY_RATE_MAX = 0 |