13 lines
688 B
SQL
13 lines
688 B
SQL
alter table CAPSIGINF add cus_nam varchar2(180);
|
|
alter table CAPSIGINF add PayNo varchar2(30);
|
|
alter table CAPSIGINF add SEND_STS varchar2(2);
|
|
alter table CAPSIGINF drop column SIG_STS ;
|
|
alter table CAPSIGINF drop constraint CAPSIGINF_PK;
|
|
alter table CAPSIGINF add constraint CAPSIGINF_PK primary key (CUS_NAM,CRD_NO,PAYNO);
|
|
alter table CAPSIGINF modify TM_SMP default to_char(SYSDATE,'yyyymmddhh24miss');
|
|
alter table CAPICBCPERD modify IRETMSG VARCHAR2(300);
|
|
alter table CAPICBCPERD modify BANKREM VARCHAR2(300);
|
|
alter table CAPICBCPERD modify PAYACCNAMEEN VARCHAR2(180);
|
|
alter table CAPICBCPERD modify USECN VARCHAR2(300);
|
|
alter table CAPICBCPERD modify CUS_NAM VARCHAR2(180);
|