   DEFAULT CHARSET = utf8;
 
 
-ALTER TABLE `flm`.`express_provider`
+ALTER TABLE `express_provider`
   CHANGE COLUMN `letter` `group_flag` VARCHAR(45)
 CHARACTER SET 'utf8'
 COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL;
 
 
-ALTER TABLE `flm`.`gs_item`
+ALTER TABLE `gs_item`
   ADD COLUMN `express_tid` INT NULL
 COMMENT '快递模板编号'
   AFTER `sale_price`;
 
-ALTER TABLE `flm`.`gs_snapshot`
+ALTER TABLE `gs_snapshot`
   ADD COLUMN `express_tid` INT NULL
   AFTER `sale_price`;
 
-ALTER TABLE `flm`.`gs_item`
+ALTER TABLE `gs_item`
   CHANGE COLUMN `img` `img` VARCHAR(120) NULL DEFAULT NULL;
 
-ALTER TABLE `flm`.`gs_item`
+ALTER TABLE `gs_item`
   CHANGE COLUMN `weight` `weight` FLOAT(6, 2) NULL DEFAULT NULL
 COMMENT '重量,单位:克(g)';
 
-ALTER TABLE `flm`.`gs_snapshot`
+ALTER TABLE `gs_snapshot`
   CHANGE COLUMN `weight` `weight` FLOAT(6, 2) NULL DEFAULT NULL
 COMMENT '单件重量,单位:克(g)';
 
-ALTER TABLE `flm`.`gs_snapshot`
+ALTER TABLE `gs_snapshot`
   ADD COLUMN `cost` DECIMAL(8, 2) NULL
   AFTER `weight`;
 
 
-ALTER TABLE `flm`.`gs_sales_snapshot`
+ALTER TABLE `gs_sales_snapshot`
   ADD COLUMN `cost` DECIMAL(8, 2) NULL
 COMMENT '供货价'
   AFTER `img`;

  `final_amount` DECIMAL(8, 2) NULL,
  PRIMARY KEY (`id`)
);
ALTER TABLE `flm`.`sale_order`
  CHANGE COLUMN `goods_fee` `goods_amount` DECIMAL(8, 2) NULL DEFAULT NULL
COMMENT '商品金额',
  CHANGE COLUMN `discount_fee` `discount_amount` DECIMAL(8, 2) NULL DEFAULT NULL,
  CHANGE COLUMN `final_fee` `final_amount` DECIMAL(8, 2) NULL DEFAULT NULL;

ALTER TABLE `flm`.`sale_order_item`
  CHANGE COLUMN `fee` `amount` DECIMAL(8, 2) NULL DEFAULT NULL,
  CHANGE COLUMN `final_fee` `final_amount` DECIMAL(8, 2) NULL DEFAULT NULL;

ALTER TABLE `flm`.`sale_sub_order`
  CHANGE COLUMN `goods_fee` `goods_amount` DECIMAL(8, 2) NULL DEFAULT NULL,
  CHANGE COLUMN `discount_fee` `discount_amount` DECIMAL(8, 2) NULL DEFAULT NULL,
  CHANGE COLUMN `final_fee` `final_amount` DECIMAL(8, 2) NULL DEFAULT NULL;

ALTER TABLE `flm`.`sale_order_item`
  ADD COLUMN `is_shipped` TINYINT(1) NULL
  AFTER `final_amount`;

ALTER TABLE `flm`.`mm_integral_log`
  CHANGE COLUMN `partner_id` `mch_id` INT(11) NULL DEFAULT NULL;

ALTER TABLE `flm`.`pay_order`
  CHANGE COLUMN `sub_fee` `sub_amount` DECIMAL(8, 2) NULL DEFAULT NULL
COMMENT '立减金额',
  ADD COLUMN `adjustment_amount` DECIMAL(8, 2) NULL

);


ALTER TABLE `pt_order_item`
  CHANGE COLUMN `update_time` `update_time` INT NULL DEFAULT NULL,
  ADD COLUMN `sku_id` INT NULL
  AFTER `order_id`,
  ADD COLUMN `final_fee` DECIMAL(8, 2) NULL
  AFTER `fee`,
  RENAME TO `sale_order_item`;

ALTER TABLE `sale_order_item`
  CHANGE COLUMN `snapshot_id` `snap_id` INT(11) NULL DEFAULT NULL;

ALTER TABLE `sale_order_item`
  DROP COLUMN `sku`;


CREATE TABLE `express_template` (
  `id`         INT           NOT NULL AUTO_INCREMENT,
  `user_id`    INT           NULL,
  `name`       VARCHAR(45)   NULL,
