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`;