20180423.sql 494 B

12345678910
  1. -- 订单表字段改名
  2. ALTER TABLE `order`
  3. CHANGE COLUMN `totalOriginalPrice` `origin_amount` INT(11) NOT NULL DEFAULT '0' COMMENT '订单原始总价,单位分' AFTER `coupon_id`,
  4. CHANGE COLUMN `totalPrice` `amount` INT(11) NOT NULL DEFAULT '0' COMMENT '订单总价,单位分' AFTER `origin_amount`;
  5. -- 订单商品表字段改名
  6. ALTER TABLE `order_goods`
  7. CHANGE COLUMN `original_price` `origin_price` INT(11) NOT NULL DEFAULT '0' COMMENT '商品原价,单位分' AFTER `num`;