ALTER TABLE `risk_activity` ADD COLUMN `isBackUp` varchar(1) NULL COMMENT '是否备案活动,1表示政府备案活动' AFTER `activitySource`; -- 修改历史数据,历史的项目都为备案活动 update risk_activity set isBackUp=1 where gov=1; ALTER TABLE `risk_materialformattr` DROP FOREIGN KEY `FKhpaw3k1a5fdkfhuu7p5ci1ppp`; ALTER TABLE `risk_materialformmenu` DROP FOREIGN KEY `FKnkqolo7c4vc62ax962mh0ue0y`; ALTER TABLE `risk_materialformvalue` DROP FOREIGN KEY `FKeqehn9sex3vajx9amtrx8hk7k`; update base_dict set label='初审退回' where type='PRIMARYSTATUS' and label='初审修改';