 COMMENT '省市区'
   AFTER `district`;
 
-ALTER TABLE `flm`.`mch_page`
-  RENAME TO `flm`.`con_page`;
-
-CREATE TABLE `flm`.`con_article_category` (
+ALTER TABLE `mch_page`
+  RENAME TO `con_page`;
+
+CREATE TABLE `con_article_category` (
   `id`          INT          NOT NULL AUTO_INCREMENT,
   `parent_id`   INT          NULL,
   `name`        VARCHAR(45)  NULL,

  PRIMARY KEY (`id`)
);

ALTER TABLE `flm`.`pt_order_pb`
  CHANGE COLUMN `order_no` `order_id` INT NULL DEFAULT NULL
  AFTER `id`;


CREATE TABLE `flm`.`sale_sub_order` (
  `id`           INT           NOT NULL AUTO_INCREMENT,
  `order_no`     VARCHAR(20)   NULL,
  `parent_order` INT           NULL,

  PRIMARY KEY (`shop_id`)
);

ALTER TABLE `mch_merchant`
  ADD COLUMN `level` INT NULL
COMMENT '商户等级'
  AFTER `name`;


ALTER TABLE `gs_category`
  CHANGE COLUMN `merchant_id` `mch_id` INT(11) NULL
  DEFAULT NULL
COMMENT '商户ID(merhantId ID);如果为空，则表示系统的f分类 ';

ALTER TABLE `gs_category`
  ADD COLUMN `level` TINYINT(1) NULL
  AFTER `sort_number`;

ALTER TABLE `mch_merchant`
  ADD COLUMN `self_sales` TINYINT(1) NULL
  AFTER `name`;


ALTER TABLE `gs_sale_label`
  DROP COLUMN `is_internal`,
  CHANGE COLUMN `merchant_id` `mch_id` INT(11) NULL DEFAULT NULL,
  CHANGE COLUMN `goods_image` `label_image` VARCHAR(100) NULL DEFAULT NULL,
  RENAME TO `gs_sale_label`;


ALTER TABLE `pt_page`
  CHANGE COLUMN `merchant_id` `mch_id` INT(11) NULL DEFAULT NULL,
  RENAME TO `mch_page`;

ALTER TABLE `gs_item`
  ADD COLUMN `supplier_id` INT NULL
  AFTER `category_id`;

ALTER TABLE `pm_info`
  CHANGE COLUMN `merchant_id` `mch_id` INT(11) NULL DEFAULT NULL;

ALTER TABLE `ad_position`
  CHANGE COLUMN `description` `key` VARCHAR(45) NULL DEFAULT NULL
  AFTER `group_id`,
  CHANGE COLUMN `name` `name` VARCHAR(45) NULL DEFAULT NULL;

CREATE TABLE `msg_list` (
  `id`          INT        NOT NULL AUTO_INCREMENT,
  `msg_type`    TINYINT(1) NULL,
  `use_for`     TINYINT(1) NULL,
