TRS.WCM.Developer/贵州项目6个WCM节点迁移到海云/迁移前每个节点的特殊处理/city2/00_alter_metadata.sql

-- 大表删除、修改某些字段以便添加默认字段能够顺利进行
DELETE FROM xwcmdbfieldinfo WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'planpubtime';
DELETE FROM xwcmviewfieldinfo WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'planpubtime';
DELETE FROM xwcmdbfieldinfo WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'CMyCrUser';
DELETE FROM xwcmviewfieldinfo WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'CMyCrUser';
DELETE FROM xwcmdbfieldinfo WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'STATUSFORBS';
DELETE FROM xwcmviewfieldinfo WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'STATUSFORBS';

alter table wcmmetatableGovInfo drop column planpubtime,
                                drop column CMyCrUser,
																drop column STATUSFORBS