set feedback off set define off -- 增加contractStatus字段, alter table t_billInvoice DROP COLUMN invoiceStatus; alter table t_billInvoice add column invoiceStatus tinyint(4) DEFAULT NULL COMMENT '发票状态 1、待开票 2、开票中 3、开票完成',ALGORITHM=inplace,LOCK=NONE; alter table t_billInvoice DROP COLUMN msg; alter table t_billInvoice add column msg varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '发票状态信息',ALGORITHM=inplace,LOCK=NONE; commit; set feedback on set define on