alter table cms_news_log add AUTHOR VARCHAR2(255);
alter table cms_news_log add Channels VARCHAR2(255);

comment on column cms_news_log.AUTHOR is '作者';
comment on column cms_news_log.Channels is '渠道';


alter TABLE Wx_SzzyOrder_HandGift ADD  auditType number DEFAULT 0;

alter TABLE Wx_SzzyOrder_HandGift ADD saledeptid number DEFAULT 0 ;

comment on column Wx_SzzyOrder_HandGift.auditType is '审核类型 标注1为业务审核';
comment on column Wx_SzzyOrder_HandGift.saledeptid is '事业线id';


alter table  RES_RESOURCETYPE add sourceType VARCHAR2(255);
comment on column RES_RESOURCETYPE.sourceType is '资源池类型,配置项(sourceTypeSetting):用到contains,尽量比较复杂,xdzyc(新单活动)';