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