You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
1.2 KiB
22 lines
1.2 KiB
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;
|
|
|
|
|