123456789101112 |
- set feedback off
- set define off
- 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
|