ALTER TABLE `fees_invoice`.`corporate_invoice_items`
ADD COLUMN `ITEM_NO` varchar(100) NULL AFTER `ORIGIN_PRICE`,
ADD COLUMN `EXT01` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `ITEM_NO`,
ADD COLUMN `EXT02` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `EXT01`,
ADD COLUMN `EXT03` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `EXT02`,
ADD COLUMN `EXT04` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `EXT03`,
ADD COLUMN `EXT05` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `EXT04`;

CREATE TABLE `supplier_material_define` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `item_no` varchar(100) NOT NULL COMMENT '物料号',
  `similar_item_no` varchar(100) DEFAULT NULL COMMENT '相似物料号',
  `item_type` varchar(50) DEFAULT NULL COMMENT '0：按单价匹配/1：相似物料',
  `remark` varchar(100) DEFAULT NULL,
  `ext01` varchar(100) DEFAULT NULL,
  `ext02` varchar(100) DEFAULT NULL,
  `ext03` varchar(100) DEFAULT NULL,
  `ext04` varchar(100) DEFAULT NULL,
  `ext05` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;