40 lines
1.6 KiB
MySQL
40 lines
1.6 KiB
MySQL
|
ALTER TABLE REC_LOAN_LAST.credit_prd_info ADD query_total BIGINT;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.credit_user_info ADD query_total BIGINT;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.credit_prd_config DROP COLUMN unit_price;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.credit_prd_config ADD unit_price VARCHAR(256);
|
||
|
|
ALTER TABLE REC_LOAN_LAST.credit_prd_config ADD query_flag VARCHAR(2);
|
||
|
|
ALTER TABLE REC_LOAN_LAST.credit_prd_config ADD unit_price_flag VARCHAR(2);
|
||
|
|
ALTER TABLE REC_LOAN_LAST.bth_credit_month_report ADD query_total BIGINT;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.credit_eff_price_config ADD unit_price_flag VARCHAR(2);
|
||
|
|
ALTER TABLE REC_LOAN_LAST.sys_credit_info_log ADD prd_price DECIMAL;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.sys_credit_info_log ADD user_name VARCHAR(64);
|
||
|
|
ALTER TABLE REC_LOAN_LAST.sys_credit_info_log MODIFY create_time TIMESTAMP
|
||
|
|
|
||
|
|
ALTER TABLE REC_LOAN_LAST.sys_credit_info_log ADD query_total BIGINT;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.sys_credit_info_log ADD send_total BIGINT;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.sys_credit_info_log ADD back_total BIGINT;
|
||
|
|
ALTER TABLE REC_LOAN_LAST.sys_credit_info_log ADD credit_channel VARCHAR(10);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
CREATE TABLE REC_LOAN_LAST.credit_eff_price_config (
|
||
|
|
id VARCHAR(64) NOT NULL,
|
||
|
|
prd_no VARCHAR(128),
|
||
|
|
prd_name VARCHAR(256),
|
||
|
|
credit_channel VARCHAR(10),
|
||
|
|
update_rate VARCHAR(10),
|
||
|
|
update_user VARCHAR(50),
|
||
|
|
effective_date DATE,
|
||
|
|
create_date DATE,
|
||
|
|
create_time TIMESTAMP,
|
||
|
|
update_date DATE,
|
||
|
|
update_time TIMESTAMP,
|
||
|
|
effective_price VARCHAR(8188),
|
||
|
|
unit_price_flag VARCHAR(8188),
|
||
|
|
CONSTRAINT credit_eff_price_config PRIMARY KEY (id)
|
||
|
|
);
|
||
|
|
CREATE UNIQUE INDEX INDEX335625384 ON REC_LOAN_LAST.credit_eff_price_config (id);
|
||
|
|
|
||
|
|
|
||
|
|
|