CREATE TABLE TB_WYX_COLUMN_SUBLOG
(
  id VARCHAR2(32) NOT NULL ,
  create_datetime   VARCHAR2(20),
  table_name        VARCHAR2(64),
  column_name   VARCHAR2(64),
  from_id VARCHAR2(32), 
  old_value  VARCHAR2(1024),
  new_value  VARCHAR2(1024),
  status  VARCHAR2(2)
)tablespace TBS_WXPTQS;
--主键
ALTER TABLE  TB_WYX_COLUMN_SUBLOG
  ADD CONSTRAINT  key_TB_WYX_COLUMN_SUBLOG PRIMARY KEY (id);
--索引
create index idx_TB_WYX_COLUMN_SUBLOG on TB_WYX_COLUMN_SUBLOG(status,from_id) TABLESPACE TBS_WXPTQS_IDX;
comment on column TB_WYX_COLUMN_SUBLOG.id
  is '唯一ID';
comment on column TB_WYX_COLUMN_SUBLOG.create_datetime
  is '记录时间';
comment on column TB_WYX_COLUMN_SUBLOG.table_name
  is '表名';
comment on column TB_WYX_COLUMN_SUBLOG.column_name
  is '字段名';
comment on column TB_WYX_COLUMN_SUBLOG.from_id
  is '对应的记录';
comment on column TB_WYX_COLUMN_SUBLOG.old_value
  is '原记录';
comment on column TB_WYX_COLUMN_SUBLOG.new_value
  is '截取后的记录';
comment on column TB_WYX_COLUMN_SUBLOG.status
  is '状态 ，1是新增，2是处理过的记录';

alter table TB_DDMX_INTERF modify(MERCH_TYPE VARCHAR2(8));
alter table T_JKXX_INFO add FILENAME varchar2(64) ;