 );
 
 
-ALTER TABLE `flm`.`pt_order_item`
+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 `flm`.`sale_order_item`;
-
-ALTER TABLE `flm`.`sale_order_item`
+  RENAME TO `sale_order_item`;
+
+ALTER TABLE `sale_order_item`
   CHANGE COLUMN `snapshot_id` `snap_id` INT(11) NULL DEFAULT NULL;
 
-ALTER TABLE `flm`.`sale_order_item`
+ALTER TABLE `sale_order_item`
   DROP COLUMN `sku`;
 
 
-CREATE TABLE `flm`.`express_template` (
+CREATE TABLE `express_template` (
   `id`         INT           NOT NULL AUTO_INCREMENT,
   `user_id`    INT           NULL,
   `name`       VARCHAR(45)   NULL,

  PRIMARY KEY (`id`)
);

ALTER TABLE `flm`.`sale_order`
  CHANGE COLUMN `total_fee` `goods_fee` DECIMAL(8, 2) NULL DEFAULT NULL
COMMENT '商品金额';


ALTER TABLE `flm`.`sale_sub_order`
  CHANGE COLUMN `total_fee` `goods_fee` DECIMAL(8, 2) NULL DEFAULT NULL,
  ADD COLUMN `express_fee` DECIMAL(4, 2) NULL
  AFTER `discount_fee`;

ALTER TABLE `flm`.`sale_order`
  ADD COLUMN `package_fee` DECIMAL(4, 2) NULL
  AFTER `express_fee`;

ALTER TABLE `flm`.`sale_sub_order`
  ADD COLUMN `package_fee` DECIMAL(4, 2) NULL
  AFTER `express_fee`;


ALTER TABLE `flm`.`sale_sub_order`
  ADD COLUMN `buyer_id` INT NULL
  AFTER `parent_order`;

ALTER TABLE `zxdb`.`pt_order_log`
  ADD COLUMN `order_state` TINYINT(2) NULL
  AFTER `type`,
  RENAME TO `zxdb`.`sale_order_log`;

ALTER TABLE `flm`.`sale_sub_order`
  ADD COLUMN `is_paid` TINYINT(1) NULL
  AFTER `final_fee`;

ALTER TABLE `flm`.`sale_sub_order`
  CHANGE COLUMN `status` `state` TINYINT(1) NULL DEFAULT NULL;

ALTER TABLE `flm`.`sale_order`
  CHANGE COLUMN `status` `state` TINYINT(1) NULL DEFAULT NULL;

ALTER TABLE `flm`.`mch_enterprise_info`
  ADD COLUMN `person_id` VARCHAR(20) NULL
COMMENT '法人身份证号'
  AFTER `person_name`;

ALTER TABLE `flm`.`mch_enterprise_info`
  ADD COLUMN `is_handled` TINYINT(1) NULL
  AFTER `company_imageurl`;

CREATE TABLE `flm`.`ship_order` (
  `id`           INT           NOT NULL AUTO_INCREMENT,
  `order_id`     INT           NULL,
  `sp_id`        INT           NULL

                         `update_time`
                       FROM mm_member;

ALTER TABLE `mm_profile`
  ADD COLUMN `province` INT NULL
  AFTER `email`,
  ADD COLUMN `city` INT NULL
