30 lines
1.8 KiB
SQL
30 lines
1.8 KiB
SQL
alter table dpm.T_DPM_ACCOUNT_ENTRY drop constraint UK_ENTRY_VOUCHER_NO;
|
|
alter table dpm.t_dpm_account_entry rename column voucher_no to voucher_seq_no;
|
|
create unique index UIDX_DAE_SN_VSN ON dpm.t_dpm_account_entry (suite_no,voucher_seq_no);
|
|
|
|
drop index dpm.UIDX_IAD_VO;
|
|
alter table dpm.t_dpm_inner_account_detail rename column voucher_no to voucher_seq_no;
|
|
create unique index UIDX_DIAD_SN_VSN ON dpm.t_dpm_inner_account_detail (suite_no,voucher_seq_no);
|
|
|
|
drop index dpm.UIDX_OAD_VO;
|
|
alter table dpm.t_dpm_outer_account_detail rename column voucher_no to voucher_seq_no;
|
|
create unique index UIDX_DOAD_SN_VSN ON dpm.t_dpm_outer_account_detail (suite_no,voucher_seq_no);
|
|
|
|
drop index dpm.IDX_ACCOUNT_SUB_DTL_VOUCH;
|
|
alter table dpm.t_dpm_outer_account_sub_detail rename column voucher_no to voucher_seq_no;
|
|
create index IDX_DOAD_SN_VSN ON dpm.t_dpm_outer_account_sub_detail (suite_no,voucher_seq_no);
|
|
|
|
alter table dpm.t_dpm_buffer_detail rename column voucher_no to voucher_seq_no;
|
|
alter table dpm.t_dpm_buffer_detail_log rename column voucher_no to voucher_seq_no;
|
|
alter table dpm.t_dpm_outer_account_sub_detail add (SUITE_NO VARCHAR2(32));
|
|
alter table dpm.t_dpm_outer_account modify (MEMBER_ID VARCHAR2(32));
|
|
|
|
alter table dpm.t_dpm_outer_account modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.t_dpm_inner_account modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.t_dpm_outer_account_subset modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.t_dpm_outer_account_detail modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.T_DPM_ACCOUNT_ENTRY modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.t_dpm_buffer_detail modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.t_dpm_inner_account_detail modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.t_dpm_buffer_detail_log modify (ACCOUNT_NO VARCHAR2(64));
|
|
alter table dpm.t_dpm_buffer_rule modify (ACCOUNT_NO VARCHAR2(64)); |