20220620_mashengyi_01.sql 530 B

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