   CHANGE COLUMN `merchant_id` `mch_id` INT(11) NULL DEFAULT NULL,
   ADD COLUMN `shop_type` TINYINT(1) NULL
   AFTER `mch_id`,
-  RENAME TO `zxdb`.`mch_shop`;
-
-
-CREATE TABLE `zxdb`.`mch_online_shop` (
+  RENAME TO `mch_shop`;
+
+
+CREATE TABLE `mch_online_shop` (
   `shop_id`     INT          NOT NULL,
   `alias`       VARCHAR(20)  NULL,
   `tel`         VARCHAR(45)  NULL,

);


ALTER TABLE `flm`.`sale_cart_item`
  ADD COLUMN `mch_id` INT NULL
  AFTER `cart_id`,
  ADD COLUMN `shop_id` INT NULL
  AFTER `mch_id`;

ALTER TABLE `flm`.`mm_level`
  ADD COLUMN `is_official` TINYINT(1) NULL
  AFTER `program_signal`;

CREATE TABLE `flm`.`mm_trusted_info` (
  `member_id`   INT          NOT NULL,
  `real_name`   VARCHAR(10)  NULL,
  `body_number` VARCHAR(20)  NULL,

  DEFAULT CHARSET = utf8;


ALTER TABLE `mm_account`
  CHANGE COLUMN `freezes_integral` `freeze_integral` INT(11) NOT NULL
COMMENT '不可用积分',
  CHANGE COLUMN `balance` `balance` DECIMAL(10, 2) NOT NULL
