- -- 大表删除、修改某些字段以便添加默认字段能够顺利进行
- update xwcmdbfieldinfo SET DBLENGTH = 3000 WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'RelPhoto';
- update xwcmviewfieldinfo SET DBLENGTH = 3000 WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'RelPhoto';
- alter table wcmmetatableGovInfo
- MODIFY COLUMN `RelPhoto` varchar(3000) NULL DEFAULT ''
|
