WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool CON_CONTRACT.log

PROMPT
PROMPT CREATING TABLE TRAIN_CONFIG
PROMPT ============================
PROMPT
WHENEVER SQLERROR CONTINUE
 DROP TABLE CON_CONTRACT;
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

alter table CON_CONTRACT add (OBJECT_HANDINGO varchar2(2000));
alter table CON_CONTRACT add (RECOVERY_MATHOD_GOL varchar2(2000));
alter table CON_CONTRACT add (SUBJECT_MATTER_RESCISSIO varchar2(2000));
alter table CON_CONTRACT add (REPURCHASE_TYPES   varchar2(2000));
alter table CON_CONTRACT add (REPURCHASE_CONTRACT_NUMBER   varchar2(2000));
ALTER TABLE CSH_TRANSACTION ADD (CONFIRMED_FLAG VARCHAR2(100));
ALTER TABLE CSH_TRANSACTION ADD (CONFIRMED_DATE DATE);
ALTER TABLE CSH_TRANSACTION ADD (CONFIRMED_BY NUMBER);
alter table CSH_TRANSACTION add (PAID_BYOTHER_FLAG varchar2(10));
alter table CON_CONTRACT add (LAST_RENT_DUE_DATE date);
alter table CON_CONTRACT add (REPURCHASE_DATE date);
alter table CON_CONTRACT add (PAYMENGT_DEADLINEDATE date);
comment on column CSH_TRANSACTION.PAID_BYOTHER_FLAG is '代付';
COMMENT ON column CSH_TRANSACTION.CONFIRMED_DATE
  IS '确认时间';
COMMENT ON column CSH_TRANSACTION.CONFIRMED_FLAG
  IS '单据状态';
COMMENT ON column CSH_TRANSACTION.CONFIRMED_BY
  IS '确认人';
comment on column CON_CONTRACT.REPURCHASE_CONTRACT_NUMBER
  is '回购合同编号';
comment on column CON_CONTRACT.OBJECT_HANDINGO
  is '物件处理';
comment on column CON_CONTRACT.RECOVERY_MATHOD_GOL
  is '解约金回收方法';
comment on column CON_CONTRACT.SUBJECT_MATTER_RESCISSIO
  is '解约事由';
comment on column CON_CONTRACT.REPURCHASE_TYPES
  is '回购类型';
comment on column CON_CONTRACT.LAST_RENT_DUE_DATE is '前期租金支付约定日';
comment on column CON_CONTRACT.REPURCHASE_DATE is '解约回购日';
comment on column CON_CONTRACT.PAYMENGT_DEADLINEDATE is '支付预定期限(第1期)';

SPOOL OFF

EXIT