set feedback off set define off -- 增加contractStatus字段, alter table t_customer_rec DROP COLUMN contractStatus; alter table t_customer_rec add column contractStatus int(2) default 0 COMMENT '协议上传状态 1、协议上传失败 2、协议上传成功,审批中 3、备案成功'; commit; set feedback on set define on