qimall/sql/qimall_menu.sql

CREATE TABLE `qimall_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',
                               `cate_id` int(11) NOT NULL COMMENT '菜单分类',
                               `addons_name` varchar(100) NOT NULL DEFAULT '' COMMENT '插件名称',
                               `is_addon` tinyint(1) unsigned DEFAULT '0' COMMENT '是否插件',
                               `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=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统_菜单导航表';

INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (1, '账户管理', 'backend', 1, '', 0, 0, 'admin/account/index', 'el-icon-user', 1, 1, 3, NULL, 'tr_0', 1, 1628586713, 1636019174);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (2, '我的账户', 'backend', 1, '', 0, 1, 'admin/account/info', 'icon-person', 2, 0, 999, NULL, '', 1, 1628586713, 1629168543);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (3, '账户列表', 'backend', 1, '', 0, 1, 'admin/account/index', 'icon-liebiao', 2, 0, 999, NULL, '', 1, 1628586713, 1628586713);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (5, '商城管理', 'backend', 1, '', 0, 0, 'admin/mall/index', 'el-icon-s-shop', 1, 0, 999, NULL, 'tr_0', 1, 1628586713, 1636612452);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (6, '商城列表', 'backend', 1, '', 0, 5, 'admin/mall/index', 'el-icon-s-shop', 2, 0, 999, NULL, '', 1, 1628586713, 1628586713);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (7, '回收站', 'backend', 1, '', 0, 5, 'admin/mall/recycle', 'el-icon-delete', 2, 0, 999, NULL, '', 1, 1628586713, 1628586713);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (8, '菜单管理', 'backend', 1, '', 0, 0, 'admin/menu/index', 'el-icon-tickets', 1, 0, 700, NULL, 'tr_0', 1, 1628586713, 1636019196);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (9, '菜单列表', 'backend', 1, '', 0, 8, 'admin/menu/index', 'el-icon-tickets', 2, 1, 999, NULL, 'tr_0 tr_8', 1, 1628586713, 1629949970);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (10, '应用管理', 'backend', 1, '', 0, 0, 'admin/addons/index', 'el-icon-menu', 1, 1, 40, NULL, 'tr_0', 1, 1628586713, 1636612465);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (11, '应用列表', 'backend', 1, '', 0, 10, 'admin/addons/index', 'el-icon-menu', 2, 1, 999, NULL, '', 1, 1628586713, 1629107497);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (12, '应用设计', 'backend', 1, '', 0, 10, 'admin/addons/create', 'el-icon-menu', 2, 1, 999, NULL, '', 1, 1628586713, 1629276427);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (13, '本地应用', 'backend', 1, '', 0, 10, 'admin/addons/local', 'menu', 2, 1, 999, NULL, '', 1, 1629166052, 1629276401);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (20, '角色管理', 'backend', 1, '', 0, 1, 'admin/role/index', '', 2, 0, 999, NULL, 'tr_0  tr_1', 1, 1629180532, 1629180532);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (21, '权限管理', 'backend', 1, '', 0, 1, 'admin/rbac-auth-item/index', '', 2, 0, 999, NULL, 'tr_0  tr_1', 1, 1629250639, 1629255399);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (31, '概况', 'backend', 2, '', 0, 0, 'mall/overview/index', 'el-icon-s-platform', 1, 0, 10, NULL, 'tr_0', 1, 1629383195, 1635931143);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (32, '商品', 'backend', 2, '', 0, 0, 'mall/goods/index', 'el-icon-s-goods', 1, 0, 999, NULL, 'tr_0', 1, 1629383195, 1636613172);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (33, '订单', 'backend', 2, '', 0, 0, 'mall/order/index', 'el-icon-s-order', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (34, '会员', 'backend', 2, '', 0, 0, 'mall/user/index', 'el-icon-user-solid', 1, 0, 999, NULL, 'tr_0', 1, 0, 1636613163);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (35, '资产', 'backend', 2, '', 0, 0, 'mall/finance/stat', 'el-icon-coin', 1, 0, 999, NULL, 'tr_0', 1, 0, 1636613193);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (36, '数据', 'backend', 2, '', 0, 0, 'mall/statistics/data-statistics', 'el-icon-s-data', 1, 0, 999, NULL, 'tr_0', 1, 0, 1636962539);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (37, '应用', 'backend', 2, '', 0, 37, 'mall/addons/index', '', 2, 0, 999, NULL, 'tr_0 tr_37tr_37 ', 1, 0, 1637318996);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (38, '设置', 'backend', 2, '', 0, 0, 'mall/setting/index', 'el-icon-setting', 1, 0, 999, NULL, 'tr_0', 1, 0, 1636613206);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (39, '渠道', 'backend', 2, '', 0, 0, 'mall/channel/index', 'el-icon-share', 1, 0, 999, NULL, '', 1, 0, 0);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (40, '装修', 'backend', 2, '', 0, 0, 'mall/diy/index', 'el-icon-s-shop', 1, 0, 20, NULL, 'tr_0', 1, 0, 1637913464);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (41, '站点设置', 'backend', 1, '', 0, 0, 'admin/setting/index', 'el-icon-setting', 1, 0, 999, NULL, 'tr_0', 1, 1629429170, 1636019334);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (42, '系统设置', 'backend', 1, '', 0, 41, 'admin/setting/index', '', 2, 0, 999, NULL, 'tr_0 tr_41', 1, 1629429198, 1629429198);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (43, '商品列表', 'backend', 2, '', 0, 32, 'mall/goods/index', '', 2, 1, 999, NULL, ' tr_32', 1, 1629443569, 1629443569);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (44, '会员列表', 'backend', 2, '', 0, 34, 'mall/user/index', '', 2, 1, 999, NULL, ' tr_34', 1, 1629444754, 1629972950);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (45, '商品分类', 'backend', 2, '', 0, 32, 'mall/cate/index', '', 2, 0, 999, NULL, ' tr_32', 1, 1629454295, 1629454295);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (46, '会员等级', 'backend', 2, '', 0, 34, 'mall/user-level/index', '', 2, 1, 999, NULL, ' tr_34', 1, 1629532814, 1630918240);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (48, '关系设置', 'backend', 2, '', 0, 34, 'mall/user/relation-edit', '', 2, 1, 999, NULL, ' tr_34', 1, 1629533421, 1630918257);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (51, '标签列表', 'backend', 2, '', 0, 34, 'mall/tag/index', '', 2, 1, 999, NULL, ' tr_34', 1, 1629534119, 1629534119);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (58, '商品服务', 'backend', 2, '', 0, 32, 'mall/goods/service', '', 2, 0, 999, NULL, ' tr_32', 1, 1629985927, 1629985927);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (59, '商品标签', 'backend', 2, '', 0, 32, 'mall/goods/label', '', 2, 0, 999, NULL, ' tr_32', 1, 1629985983, 1629985983);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (60, '运费模板', 'backend', 2, '', 0, 32, 'mall/freight/rules', '', 2, 0, 999, NULL, ' tr_32', 1, 1629986098, 1629986098);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (61, '包邮规则', 'backend', 2, '', 0, 32, 'mall/freight/free-shipping-rules', '', 2, 0, 999, NULL, ' tr_32', 1, 1629990031, 1629990031);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (62, '商城设置', 'backend', 2, '', 0, 38, 'mall/setting/index', '', 2, 0, 999, NULL, ' tr_38', 1, 1630316957, 1630316957);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (63, '资产设置', 'backend', 2, '', 0, 38, 'mall/setting/assets', '', 2, 0, 999, NULL, ' tr_38', 1, 1630316986, 1630316986);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (66, '订单管理', 'backend', 2, '', 0, 33, 'mall/order/index', '', 2, 0, 999, NULL, '', 1, 1630316986, 1630316986);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (67, '页面装修', 'backend', 2, '', 0, 40, 'mall/diy/index', '', 1, 0, 1, NULL, 'tr_0 tr_40', 1, 1630977989, 1637747310);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (70, '底部导航', 'backend', 2, '', 0, 40, 'mall/decorate/bottom-nav', '', 2, 0, 5, NULL, 'tr_0 tr_40', 1, 1631874166, 1631874295);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (74, '全局配置', 'backend', 2, '', 0, 40, 'mall/decorate/setting', '', 2, 0, 30, NULL, 'tr_0 tr_40', 1, 1631874242, 1631874351);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (76, '渠道管理', 'backend', 2, '', 0, 39, 'mall/channel/index', '', 2, 0, 999, NULL, ' tr_39', 1, 1631874493, 1631874493);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (77, '公众号管理', 'backend', 2, '', 0, 39, 'mall/wechat/edit', '', 2, 0, 999, NULL, ' tr_39', 1, 1631874512, 1631874512);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (78, '公众号设置', 'backend', 2, '', 0, 77, 'mall/wechat/edit', '', 3, 0, 999, NULL, ' tr_39 tr_77', 1, 1631874530, 1631874530);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (79, '自定义菜单', 'backend', 2, '', 0, 77, 'mall/wechat/menus', '', 3, 0, 999, NULL, ' tr_39 tr_77', 1, 1631874546, 1631874546);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (80, '自动回复', 'backend', 2, '', 0, 77, 'mall/wechat/reply-rule', '', 3, 0, 999, NULL, ' tr_39 tr_77', 1, 1631874725, 1631874725);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (81, '素材管理', 'backend', 2, '', 0, 77, 'mall/wechat/material', '', 3, 0, 999, NULL, ' tr_39 tr_77', 1, 1631874737, 1631874737);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (82, '图文素材', 'backend', 2, '', 0, 77, 'mall/wechat/article', '', 3, 0, 999, NULL, ' tr_39 tr_77', 1, 1631874755, 1631874755);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (83, '我的应用', 'backend', 2, '', 0, 37, 'mall/addons/index', '', 2, 0, 999, NULL, ' tr_37', 1, 1631874853, 1631874853);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (84, '应用市场', 'backend', 2, '', 0, 37, 'mall/addons/market', '', 2, 0, 999, NULL, ' tr_37', 1, 1631874865, 1631874865);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (108, '评价管理', 'backend', 2, '', 0, 33, 'mall/order-comments/index', '', 2, 1, 999, NULL, ' tr_33', 1, 1633594000, 1633594000);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (124, '售后订单', 'backend', 2, '', 0, 33, 'mall/order/refund', '', 2, 1, 999, NULL, ' tr_33', 1, 1633685442, 1633685442);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (149, '下载', 'backend', 2, '', 0, 0, 'mall/download/index', 'el-icon-download', 1, 1, 999, NULL, 'tr_0', 1, 1633939027, 1635825144);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (150, '下载中心', 'backend', 2, '', 0, 149, 'mall/download/index', '', 1, 1, 999, NULL, 'tr_0  tr_149', 1, 1633939051, 1633939102);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (163, '定时任务', 'backend', 1, '', 0, 0, 'admin/task/index', 'el-icon-tickets', 1, 1, 999, NULL, 'tr_0 ', 1, 1634006113, 1636019170);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (165, '任务列表', 'backend', 1, '', 0, 163, 'admin/task/index', '', 2, 1, 999, NULL, 'tr_0 tr_163', 1, 1634006113, 1634006113);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (166, '任务记录', 'backend', 1, '', 0, 163, 'admin/task/executed-list', '', 2, 1, 999, NULL, 'tr_0 tr_163', 1, 1634006113, 1634006113);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (326, '订单设置', 'backend', 2, '', 0, 38, 'mall/setting/order', '', 4, 1, 999, NULL, ' tr_38 tr_62 tr_38', 1, 1634292193, 1634292193);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (327, '资产概况', 'backend', 2, '', 0, 35, 'mall/finance/stat', '', 2, 1, 999, NULL, ' tr_35', 1, 1634540242, 1634540242);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (328, '会员资产', 'backend', 2, '', 0, 35, 'mall/finance/index', '', 2, 1, 999, NULL, ' tr_35', 1, 1634540351, 1634540351);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (329, '余额明细', 'backend', 2, '', 0, 35, 'mall/finance/balance-log', '', 2, 1, 999, NULL, ' tr_35', 1, 1634540422, 1634540422);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (330, '积分明细', 'backend', 2, '', 0, 35, 'mall/finance/score-log', '', 2, 1, 999, NULL, ' tr_35', 1, 1634540538, 1634540538);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (331, '小程序管理', 'backend', 2, '', 0, 39, 'mall/mini-program/edit', '', 2, 0, 999, NULL, ' tr_39', 1, 1631874512, 1631874512);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (332, '小程序基础配置', 'backend', 2, '', 0, 331, 'mall/mini-program/edit', '', 3, 0, 999, NULL, ' tr_39 tr_331', 1, 1631874530, 1631874530);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (333, '佣金明细', 'backend', 2, '', 0, 35, 'mall/finance/commission-log', '', 2, 1, 999, NULL, ' tr_35 tr_333', 1, 1634540538, 1634540538);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (488, '员工列表', 'backend', 2, '', 0, 38, 'mall/account/index', '', 4, 1, 999, NULL, ' tr_38 tr_62 tr_38', 1, 1635754247, 1635754247);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (489, '岗位列表', 'backend', 2, '', 0, 38, 'mall/role/index', '', 4, 1, 999, NULL, ' tr_38 tr_62 tr_38', 1, 1635754334, 1635754334);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (554, '链接管理', 'backend', 1, '', 0, 0, 'admin/link/cate-index', 'el-icon-link', 1, 1, 999, NULL, 'tr_0', 1, 1636018562, 1636019169);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (555, '链接分类', 'backend', 1, '', 0, 554, 'admin/link/cate-index', '', 1, 1, 999, NULL, 'tr_0  tr_554', 1, 1636018616, 1636018686);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (556, '链接管理', 'backend', 1, '', 0, 554, 'admin/link/index', '', 2, 1, 999, NULL, 'tr_0  tr_554', 1, 1636018639, 1636018639);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (735, '数据概况', 'backend', 2, '', 0, 36, 'mall/statistics/data-statistics', '', 1, 1, 999, NULL, 'tr_0 tr_36', 1, 1636701575, 1636962568);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (736, '销售数据', 'backend', 2, '', 0, 36, 'mall/statistics/sale-statistics', '', 1, 1, 999, NULL, 'tr_0 tr_36', 1, 1636701645, 1636962580);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (922, '数据设置', 'backend', 2, '', 0, 38, 'mall/data/index', '', 2, 0, 999, NULL, 'tr_0 tr_38', 1, 1637291840, 1637291892);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (923, '团队人数', 'backend', 2, '', 0, 36, 'mall/statistics/team-size', '', 2, 0, 999, NULL, 'tr_0 tr_36', 1, 1637306670, 1637306670);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (925, '会员数据', 'backend', 2, '', 0, 36, 'mall/statistics/user-data', '', 1, 0, 999, NULL, 'tr_0 tr_36', 1, 1637306805, 1637323338);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (926, '应用', 'backend', 2, '', 0, 0, 'mall/addons/index', 'el-icon-s-finance', 1, 0, 999, NULL, 'tr_0', 1, 1637319234, 1637369689);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (927, '我的应用', 'backend', 2, '', 0, 926, 'mall/addons/index', '', 2, 0, 999, NULL, 'tr_0  tr_926', 1, 1637319343, 1637319343);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (928, '应用市场', 'backend', 2, '', 0, 926, 'mall/addons/market', '', 2, 0, 999, NULL, 'tr_0  tr_926', 1, 1637319370, 1637319370);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (939, '编辑', 'backend', 2, '', 0, 938, 'distribution/distribution/edit', '', 4, 0, 999, NULL, 'tr_0  tr_926 tr_932 tr_938', 1, 1637319979, 1637319979);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (940, '搜索', 'backend', 2, '', 0, 938, 'distribution/distribution/search-user', '', 4, 0, 999, NULL, 'tr_0  tr_926 tr_932 tr_938', 1, 1637320046, 1637320046);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (941, '编辑', 'backend', 2, '', 0, 937, 'distribution/level/edit', '', 4, 0, 999, NULL, 'tr_0  tr_926 tr_932 tr_937', 1, 1637320075, 1637320075);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (942, '设置升级条件', 'backend', 2, '', 0, 937, 'distribution/level/condition-setting', '', 4, 0, 999, NULL, 'tr_0  tr_926 tr_932 tr_937', 1, 1637320103, 1637320103);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (944, '添加备注', 'backend', 2, '', 0, 938, 'distribution/distribution/remarks-edit', '', 4, 0, 999, NULL, 'tr_0  tr_926 tr_932 tr_938', 1, 1637320182, 1637320182);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (945, '删除', 'backend', 2, '', 0, 938, 'distribution/distribution/delete', '', 4, 0, 999, NULL, 'tr_0  tr_926 tr_932 tr_938', 1, 1637320223, 1637320223);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (946, '提现审核', 'backend', 2, '', 0, 35, 'mall/finance/cash', '', 2, 0, 999, NULL, 'tr_0 tr_35', 1, 1637737461, 1637737461);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (948, '批量发货', 'backend', 2, '', 0, 33, 'mall/order/batch-delivery', '', 1, 1, 999, NULL, ' tr_33', 1, 1638268906, 1638782117);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (949, '会员设置', 'backend', 2, '', 0, 38, 'mall/setting/user', '', 2, 1, 999, NULL, 'tr_0 tr_38', 1, 1638500001, 1638500001);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (951, '打印机设置', 'backend', 2, '', 0, 38, 'mall/setting/printer', '', 1, 0, 999, NULL, 'tr_0 tr_38', 1, 1638848307, 1638858883);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (967, '模板管理', 'backend', 1, '', 0, 0, 'admin/template/index', 'el-icon-document-copy', 1, 1, 999, NULL, 'tr_0', 1, 1638871622, 1638871808);
INSERT INTO `qimall_menu`(`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (968, '商城模板', 'backend', 1, '', 0, 967, 'admin/template/mall', '', 2, 1, 999, NULL, 'tr_0 tr_967', 1, 1638871839, 1638871839);