qimall/addons/Mch/install.sql

CREATE TABLE `qimall_addons_mch` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `mall_id` int(11) NOT NULL DEFAULT '0',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '绑定会员id',
    `shop_owner` varchar(255) NOT NULL DEFAULT '' COMMENT '店长姓名',
    `shop_mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '店长手机号',
    `store_name` varchar(255) NOT NULL DEFAULT '' COMMENT '门店名称',
    `c_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店分类',
    `store_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '门店简介',
    `logo_img` varchar(255) NOT NULL DEFAULT '' COMMENT '门店logo',
    `license_img` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照',
    `province_id` int(11) DEFAULT '0' COMMENT '省',
    `city_id` int(11) DEFAULT '0' COMMENT '市',
    `district_id` int(11) DEFAULT '0' COMMENT '区',
    `address` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
    `expire_time` bigint(20) NOT NULL DEFAULT '0' COMMENT '失效时间，0代表无限期',
    `total_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '累计收入',
    `balance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '当前余额',
    `total_expenses` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '累计支出',
    `user_nums` int(11) DEFAULT '0' COMMENT '会员总数',
    `longitude` varchar(255) NOT NULL DEFAULT '' COMMENT '经度',
    `latitude` varchar(255) NOT NULL DEFAULT '' COMMENT '维度',
    `check_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态：0：待审核；1：已通过；2：未通过',
    `check_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '审核备注',
    `store_style` tinyint(1) NOT NULL DEFAULT '1' COMMENT '门店样式 1：样式1；2：样式2',
    `commission_authority` varchar(255) NOT NULL DEFAULT '' COMMENT '分佣/营销权限',
    `share_title` varchar(255) NOT NULL DEFAULT '' COMMENT '分享标题',
    `share_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '分享描述',
    `share_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '分享图片',
    `freight_type` varchar(255) NOT NULL DEFAULT '' COMMENT '配送设置',
    `intra_city_distribution` varchar(500) NOT NULL DEFAULT '' COMMENT '同城配送',
    `total_order_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '订单总金额',
    `total_num` int(11) NOT NULL DEFAULT '0' COMMENT '总数',
    `total_settled_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '已结算总金额',
    `unsettled_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '未结算金额',
    `sales_volume` int(11) NOT NULL DEFAULT '0' COMMENT '销量',
    `praise` decimal(3,1) NOT NULL DEFAULT '5' COMMENT '评分',
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
    `shop_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '门店营业状态，1：正在营业；0：休息中',
    `scan_code_bind` tinyint(1) NOT NULL DEFAULT '0' COMMENT '门店收款码-扫码绑定开关：0：否；1：是',
    `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户';

CREATE TABLE `qimall_addons_mch_admin` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `username` varchar(50) NOT NULL DEFAULT '' COMMENT '登录账号',
     `account` varchar(50) NOT NULL DEFAULT '' COMMENT '账号名称',
     `password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
    `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
     `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
     `auth_key` varchar(128) NOT NULL DEFAULT '',
     `access_token` varchar(128) NOT NULL DEFAULT '',
     `admin_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '管理员类型1超级管理员2管理员3操作员',
     `created_at` int(11) NOT NULL DEFAULT '0',
     `updated_at` int(11) NOT NULL DEFAULT '0',
     `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
     PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户后台管理员表';

CREATE TABLE `qimall_addons_mch_bank` (
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
   `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
   `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
   `username` varchar(50) NOT NULL DEFAULT '' COMMENT '开户名',
   `bank` varchar(255) NOT NULL DEFAULT '' COMMENT '开户银行',
   `card_no` varchar(255) NOT NULL DEFAULT '' COMMENT '银行卡号',
   `created_at` int(11) NOT NULL DEFAULT '0',
   `updated_at` int(11) NOT NULL DEFAULT '0',
   `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
   PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户提现银行卡';

CREATE TABLE `qimall_addons_mch_cate` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `mall_id` int(11) NOT NULL DEFAULT '0',
     `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父级ID',
     `name` varchar(45) NOT NULL DEFAULT '' COMMENT '分类名称',
    `pic` varchar(255) NOT NULL DEFAULT '',
     `big_pic` varchar(255) NOT NULL DEFAULT '',
     `advert_pic` text COMMENT '广告图片',
     `advert_url` text COMMENT '广告链接',
     `advert_open_type` varchar(65) NOT NULL DEFAULT '' COMMENT '打开方式',
     `advert_params` text COMMENT '导航参数',
     `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
     `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
     `sort` int(11) NOT NULL DEFAULT '999' COMMENT '排序',
     `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
     `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
     PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商户分类';

CREATE TABLE `qimall_addons_mch_census` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `mall_id` int(11) NOT NULL DEFAULT '0',
      `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
      `add_user_nums` int(11) NOT NULL DEFAULT '0' COMMENT '新增会员',
      `order_nums` int(11) NOT NULL DEFAULT '0' COMMENT '订单数',
      `settlement_commission` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '结算佣金',
      `sales_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '门店销售额',
      `cashier_sales_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '收银台销售额',
      `date_time` varchar(50) NOT NULL DEFAULT '' COMMENT '日期时间',
     `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
      `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
      `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
      PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户每日统计';

CREATE TABLE `qimall_addons_mch_commission` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
     `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
     `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
    `order_no` varchar(100) NOT NULL DEFAULT '' COMMENT '订单编号',
     `order_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额',
     `pay_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额',
     `discount_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '优惠金额',
     `addons_bonus` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '插件分红',
     `service_charge` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '服务费',
     `amount_received` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '到账金额',
     `is_settlement` tinyint(1) NOT NULL DEFAULT '0' COMMENT '结算状态 0：待结算；1：已结算',
     `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型：1：o2o订单；2：o2o收银台订单',
     `created_at` int(11) NOT NULL DEFAULT '0',
     `updated_at` int(11) NOT NULL DEFAULT '0',
    `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
     PRIMARY KEY (`id`) USING BTREE,
     KEY `idx_order_no` (`order_no`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户提成明细';

CREATE TABLE `qimall_addons_mch_goods_model` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `mall_id` int(11) NOT NULL DEFAULT '0',
     `mch_id` int(11) NOT NULL DEFAULT '0',
     `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
     `content` longtext COMMENT '内容',
     `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
     `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
     `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
     PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='模式';

CREATE TABLE `qimall_addons_mch_goods_ranking` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `mall_id` int(11) NOT NULL DEFAULT '0',
     `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
     `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
     `sales_money` int(11) NOT NULL DEFAULT '0' COMMENT '销售额',
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
     `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
     `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
     PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户商品排行榜';

CREATE TABLE `qimall_addons_mch_menu` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
     `app_id` varchar(20) NOT NULL DEFAULT '0' COMMENT '应用id',
     `pid` int(50) unsigned DEFAULT '0' COMMENT '上级id',
     `url` varchar(100) DEFAULT '' COMMENT '路由',
     `icon` varchar(50) DEFAULT '' COMMENT '样式',
     `level` tinyint(1) unsigned DEFAULT '1' COMMENT '级别',
     `dev` tinyint(4) unsigned DEFAULT '0' COMMENT '开发者[0:都可见;开发模式可见]',
     `sort` int(5) DEFAULT '999' COMMENT '排序',
     `params` json DEFAULT NULL COMMENT '参数',
     `tree` varchar(300) NOT NULL DEFAULT '' COMMENT '树',
     `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
     `created_at` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
     `updated_at` int(10) unsigned DEFAULT '0' COMMENT '修改时间',
     PRIMARY KEY (`id`) USING BTREE,
    KEY `url` (`url`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='多商户后台菜单';

CREATE TABLE `qimall_addons_mch_model` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT '0',
  `mch_id` int(11) NOT NULL DEFAULT '0',
  `content` longtext COMMENT '内容',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
  `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户分佣模式';

CREATE TABLE `qimall_addons_mch_refund_address` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `mall_id` int(11) NOT NULL DEFAULT '0',
    `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
    `refund_name` varchar(255) NOT NULL DEFAULT '' COMMENT '退货名称',
    `name` varchar(255) NOT NULL DEFAULT '' COMMENT '联系人',
    `mobile` varchar(11) NOT NULL DEFAULT '0' COMMENT '退换货手机号',
    `address` varchar(255) NOT NULL DEFAULT '' COMMENT '退换货地址',
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
    `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户退货地址';

CREATE TABLE `qimall_addons_mch_settings` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `mall_id` int(10) unsigned NOT NULL,
   `mch_id` int(10) unsigned NOT NULL,
   `store_service_fee` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否收取服务费，1：收取；0：不收取',
   `store_service_ratio` decimal(5,3) NOT NULL DEFAULT '0.000' COMMENT '门店服务费比例',
   `store_settle_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '服务费计算方式，1：门店商品售价（分佣平台承担）；2：订单实际支付金额（分佣平台承担）；3：商品成本+运费（不包含服务费）（分佣平台承担）；4：订单实际支付减去（分销商提成、经销商提成、区域代理、股东分红）',
   `store_settle_scene` tinyint(4) NOT NULL DEFAULT '1' COMMENT '服务费计算触发场景，1：订单支付；2：订单完成',
   `store_commission_authority` text COMMENT '分销/营销权限，存 json，key 区别各个不同应用',
   `cachier_service_ratio` decimal(5,3) NOT NULL DEFAULT '0.000' COMMENT '收银台服务费比例',
   `cashier_member_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否启用会员价，1：启用；0：不启用',
   `cashier_member_settings` text COMMENT '会员各个等级比例设置，存 json',
   `cashier_distribution_is_enable` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否开启分销设置，1：是；0：否',
   `cashier_distribution_settings` text COMMENT '分销各个等级佣金比例设置，存 json',
   `cashier_agent_is_enable` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否开启经销设置，1：是；0：否',
   `cashier_agent_settings` text COMMENT '经销各个等级佣金比例设置，存 json',
   `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，-1：已删除；0：禁用；1：正常',
   `created_at` int(10) unsigned NOT NULL DEFAULT '0',
   `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `idx_mall_store` (`mall_id`,`mch_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='多商户配置记录表';

CREATE TABLE `qimall_addons_mch_statistics` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
     `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
     `date_time` varchar(50) NOT NULL DEFAULT '' COMMENT '月份',
     `income_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '收入',
     `created_at` int(11) NOT NULL DEFAULT '0',
     `updated_at` int(11) NOT NULL DEFAULT '0',
     `status` tinyint(1) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
     PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户月份统计';

CREATE TABLE `qimall_addons_mch_user` (
     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     `mall_id` int(11) NOT NULL DEFAULT '0',
     `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
     `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
     `last_time` int(11) NOT NULL DEFAULT '0' COMMENT '最近下单时间',
     `order_nums` int(11) NOT NULL DEFAULT '0' COMMENT '店内下单数',
     `pay_nums` int(11) NOT NULL DEFAULT '0' COMMENT '店内消费订单数',
     `pay_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '店内消费金额',
     `refund_nums` int(11) NOT NULL DEFAULT '0' COMMENT '累计退款订单数',
     `refund_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '累计退款金额',
     `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[0禁用 1启用 -1删除]',
     `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
     PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='多商户会员';

CREATE TABLE `qimall_addons_mch_user_enter_qualification` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `mall_id` int(10) unsigned NOT NULL,
      `user_id` int(10) unsigned NOT NULL,
     `enter_mode` tinyint(4) NOT NULL DEFAULT '1' COMMENT '入驻模式，1：免费入驻，2：购买指定商品入驻',
      `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '已经购买的商品 id',
      `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，-1：已删除；0：禁用；1：正常',
      `created_at` int(10) unsigned NOT NULL DEFAULT '0',
      `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `idx_mu_id` (`mall_id`,`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='会员入驻资格记录（监听支付事件写入数据）';

CREATE TABLE `qimall_addons_mch_withdraw_log` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
    `mch_id` int(11) NOT NULL DEFAULT '0' COMMENT '多商户id',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
    `order_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '提现订单号',
    `num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提现金额',
    `actual_num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实际到账金额',
    `poundage_num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '手续费扣除金额',
    `poundage_ratio` float NOT NULL DEFAULT '0' COMMENT '手续费比例',
    `type` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '提现方式 bank--银行转账 balance--打款到余额',
    `extra` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '额外信息',
    `withdraw_status` int(11) NOT NULL DEFAULT '0' COMMENT '提现状态 0--待打款 --已打款 2--驳回 ',
    `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态[0禁用 1启用 -1删除]',
    `remark` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    `created_at` int(11) DEFAULT '0' COMMENT '添加时间戳',
    `updated_at` int(11) DEFAULT '0' COMMENT '更新时间戳',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='多商户提现记录表';


INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (1, '概况', '0', 0, 'mch/client/index/index', 'el-icon-s-platform', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (2, '商品', '0', 0, 'mch/client/goods/index', 'el-icon-s-goods', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (3, '订单', '0', 0, 'mch/client/order/index', 'el-icon-s-order', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (4, '会员', '0', 0, 'mch/client/user/index', 'el-icon-user', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (7, '资产', '0', 0, 'mch/client/finance/index', 'el-icon-coin', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (8, '设置', '0', 0, 'mch/client/setting/index', 'el-icon-setting', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (9, '商品管理', '0', 2, 'mch/client/goods/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (10, '商品分类', '0', 2, 'mch/client/cate/index', '', 2, 0, 999, NULL, '', -1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (12, '订单管理', '0', 3, 'mch/client/order/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (13, '售后订单', '0', 3, 'mch/client/order/refund', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (14, '外部订单', '0', 3, 'mch/client/order/platform-order', '', 2, 0, 999, NULL, '', -1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (15, '资产概况', '0', 7, 'mch/client/finance/index', '', 2, 0, 999, NULL, '', -1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (16, '收入明细', '0', 7, 'mch/client/finance/income-log', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (17, '资金提现', '0', 7, 'mch/client/finance/withdrawal', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (18, '运费模板', '0', 2, 'mch/client/setting/freight-rules', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (19, '商户信息', '0', 8, 'mch/client/setting/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (20, '退货地址', '0', 8, 'mch/client/refund-address/index', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (21, '店铺公告', '0', 8, 'mch/client/notice/index', '', 2, 0, 999, NULL, '', -1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (22, '模式设置', '0', 8, 'mch/client/setting/goods-model', '', 2, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_addons_mch_menu`(`id`, `title`, `app_id`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (23, '运费模板', '0', 8, 'mch/client/setting/freight-rules', '', 2, 0, 999, NULL, '', 1, 0, 0);