ALTER TABLE `achieve_new`
|
DROP COLUMN `achieveMoney`,
|
ADD COLUMN `achieveMoney` double(10, 0) NULL AFTER `company_id`;
|
|
|
ALTER TABLE `sys_order`
|
ADD COLUMN `orderType` int(2) NULL COMMENT '订单类型1，销售订单，2退款订单' AFTER `company_id`;
|
|
|
ALTER TABLE `achieve_new`
|
CHANGE COLUMN `t3` `achieveType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `t2`;
|
|
ALTER TABLE `sys_order_item`
|
ADD COLUMN `refundCount` int(11) NULL COMMENT '退款数量' AFTER `pay_method_detail`;
|
