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 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 csh_transaction add (MKT_CONFIRMED_DATE date); alter table csh_transaction add (ACC_CONFIRMED_DATE date); alter table csh_transaction add (MKT_CONFIRMED_BY varchar2(100)); alter table csh_transaction add (ACC_CONFIRMED_BY varchar2(100)); comment on column csh_transaction.MKT_CONFIRMED_DATE is '营业确认时间'; comment on column csh_transaction.ACC_CONFIRMED_DATE is '会计确认时间'; comment on column csh_transaction.MKT_CONFIRMED_BY is '营业确认人'; comment on column csh_transaction.ACC_CONFIRMED_BY is '会计确认人 '; comment on column CSH_TRANSACTION.PAID_BYOTHER_FLAG is '代付'; --将营业确认人改为债权确认人 ALTER TABLE csh_transaction RENAME COLUMN MKT_CONFIRMED_DATE TO DEBT_CONFIRMED_DATE; ALTER TABLE csh_transaction RENAME COLUMN MKT_CONFIRMED_BY TO DEBT_CONFIRMED_BY; comment on column csh_transaction.DEBT_CONFIRMED_DATE is '债权确认时间'; comment on column csh_transaction.DEBT_CONFIRMED_BY 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 '确认人'; SPOOL OFF EXIT