manage_invoice/doc/sql/20220620_mashengyi_01.sql

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