Files
dpm-account/db/DDL_account_20180118.sql
2023-03-28 13:54:33 +08:00

4 lines
278 B
SQL

alter table dpm.tb_title_daily add (INITIAL_DEBIT_BALANCE NUMBER(19,4));
alter table dpm.tb_title_daily add (INITIAL_CREDIT_BALANCE NUMBER(19,4));
alter table dpm.dbajobconf add (LAST_JOB_LOG_ID NUMBER(15));
alter table dpm.dbajobconf rename column JOBSTATUS to ACCOUNT_DATE;