yhm_orders.sql 1.21 KB
/*订单状态添加索引*/
ALTER TABLE `yhm_orders`.`orders` ADD INDEX `idx_order_status` (`order_status`);

ALTER TABLE `orders_goods`
MODIFY COLUMN `product_sku`  int(11) UNSIGNED NOT NULL COMMENT '商品sku' AFTER `product_skc`;

ALTER TABLE `yhm_orders`.`orders` CHANGE `last_order_amount` `last_order_amount` DECIMAL(10,2) UNSIGNED NULL  COMMENT '订单成交价: 订单成交价 = 订单原价 + 最终运费';
ALTER TABLE `yhm_orders`.`orders_goods_info`     ADD COLUMN `shipping_fee` DECIMAL(10,2) NULL COMMENT '订单运费' AFTER `last_price`;

ALTER TABLE `yhm_orders`.`shopping_change_price`     ADD COLUMN `agreement_shipping_fee` DECIMAL(10,2) DEFAULT '0' NULL COMMENT '商品运费价格' AFTER `buy_number`,     ADD COLUMN `order_shipping_fee` DECIMAL(10,2) DEFAULT '0' NULL COMMENT '订单运费价格' AFTER `agreement_shipping_fee`,     ADD COLUMN `order_amount` DECIMAL(10,2) DEFAULT '0' NULL COMMENT '订单单价' AFTER `order_shipping_fee`,    CHANGE `agreement_price` `agreement_price` DECIMAL(10,2) NULL  COMMENT '商品成交价';
ALTER TABLE `yhm_orders`.`shopping_change_price`     ADD COLUMN `order_last_shipping_fee` DECIMAL(10,2) DEFAULT '0' NULL COMMENT '订单运费价格' AFTER `agreement_shipping_fee`;