1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
| # 新增店铺装修模板表
| CREATE TABLE `tz_shop_template` (
| `template_id` bigint NOT NULL AUTO_INCREMENT COMMENT '店铺模板表',
| `shop_id` bigint DEFAULT NULL COMMENT '店铺id',
| `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
| `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '装修内容',
| `image` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
| `type` int DEFAULT NULL COMMENT '1PC端 2移动端',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
| `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
| `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
| PRIMARY KEY (`template_id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品装修模板表';
|
| # 菜单变更
| # 平台端菜单变更
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (865, 0, '装修', '', '', 0, 'Distribution', 8, 'Fitment', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (866, 865, 'PC端装修', '', '', 0, '', 0, 'PC Decoration', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (867, 865, '移动端装修', '', '', 0, '', 1, 'Mobile terminal decoration', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (868, 866, '页面管理', 'platform/decorate/list/index', '', 1, '', 0, 'Page management', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (869, 866, '模板管理', 'platform/decorate/template/index', '', 1, '', 1, 'Template management', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (870, 867, '页面管理', 'platform/feature/list/list', '', 1, '', 0, 'Page management', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (871, 867, '模板管理', 'platform/feature/template/index', '', 1, '', 1, 'Template management', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (874, 868, '新增页面', '', 'platform:shopRenovation:savePC', 2, '', 0, 'New page', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (875, 868, '修改', '', 'platform:shopRenovation:updatePC', 2, '', 0, 'Revise', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (876, 868, '删除', '', 'platform:shopRenovation:deletePC', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (877, 868, '设为主页', '', 'platform:shopRenovation:updateHomePagePC', 2, '', 0, 'Set to home page', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (878, 868, '分页查看', '', 'platform:shopRenovation:pagePC', 2, '', 0, 'Paginated view', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (879, 869, '新增模板', '', 'platform:shopTemplate:savePC', 2, '', 0, 'New templates', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (880, 869, '分页查看', '', 'platform:shopTemplate:pagePC', 2, '', 0, 'Paginated view', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (881, 869, '复制', '', 'platform:shopTemplate:copyPC', 2, '', 0, 'Copy', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (882, 869, '删除', '', 'platform:shopTemplate:deletePC', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (883, 869, '编辑', '', 'platform:shopTemplate:updatePC', 2, '', 0, 'Edit', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (884, 870, '分页查看', '', 'platform:shopRenovation:pageMove', 2, '', 0, 'Paginated view', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (885, 870, '新增页面', '', 'platform:shopRenovation:saveMove', 2, '', 0, 'New page', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (886, 870, '修改', '', 'platform:shopRenovation:updateMove', 2, '', 0, 'Revise', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (887, 870, '删除', '', 'platform:shopRenovation:deleteMove', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (888, 870, '设为主页', '', 'platform:shopRenovation:updateHomePageMove', 2, '', 0, 'Set to home page', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (889, 871, '新增模板', '', 'platform:shopTemplate:saveMove', 2, '', 0, 'New templates', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (890, 871, '分页查看', '', 'platform:shopTemplate:pageMove', 2, '', 0, 'Paginated view', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (891, 871, '复制', '', 'platform:shopTemplate:copyMove', 2, '', 0, 'Copy', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (892, 871, '删除', '', 'platform:shopTemplate:deleteMove', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (893, 871, '编辑', '', 'platform:shopTemplate:updateMove', 2, '', 0, 'Edit', 0);
|
| UPDATE `yami_bbc`.`tz_sys_menu` SET `parent_id` = 414, `name` = '平台装修', `url` = 'platform/feature/list/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 1, `name_en` = 'Platform Design', `hidden` = 1 WHERE `menu_id` = 671;
| UPDATE `yami_bbc`.`tz_sys_menu` SET `parent_id` = 414, `name` = '编辑微页面', `url` = '/platform/feature/create/edit/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 0, `name_en` = 'Edit Micropage', `hidden` = 1 WHERE `menu_id` = 797;
| UPDATE `yami_bbc`.`tz_sys_menu` SET `parent_id` = 414, `name` = '编辑PC装修界面', `url` = '/platform/decorate/create/edit/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 3, `name_en` = '编辑PC装修界面', `hidden` = 1 WHERE `menu_id` = 815;
| UPDATE `yami_bbc`.`tz_sys_menu` SET `parent_id` = 414, `name` = 'PC预览装修', `url` = '/platform/decorate/create/select-decorate/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 0, `name_en` = 'PC Select Decorate', `hidden` = 1 WHERE `menu_id` = 816;
| UPDATE `yami_bbc`.`tz_sys_menu` SET `parent_id` = 0, `name` = '系统', `url` = '', `perms` = '', `type` = 0, `icon` = 'system', `order_num` = 9, `name_en` = 'System', `hidden` = 0 WHERE `menu_id` = 1;
|
|
| # 商家端菜单变更
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (351, 0, '装修', '', '', 0, 'Distribution', 8, 'Fitment', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (352, 351, 'PC端装修', '', '', 0, '', 0, 'PC Decoration', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (353, 351, '移动端装修', '', '', 0, '', 1, 'Mobile terminal decoration', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (354, 352, '页面管理', 'shop/decorate/list/index', '', 1, '', 0, 'Page management', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (355, 352, '模板管理', 'shop/decorate/template/index', '', 1, '', 1, 'Template management', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (356, 353, '页面管理', 'shop/feature/list/list', '', 1, '', 0, 'Page management', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (357, 353, '模板管理', 'shop/feature/template/index', '', 1, '', 0, 'Template management', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (359, 357, '新增模板', '', 'shop:shopTemplate:saveMove', 2, '', 0, 'New template', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (360, 357, '编辑', '', 'shop:shopTemplate:updateMove', 2, '', 0, 'Edit', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (361, 357, '删除', '', 'shop:shopTemplate:deleteMove', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (362, 357, '复制', '', 'shop:shopTemplate:copyMove', 2, '', 0, 'Copy', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (363, 355, '新增模板', '', 'shop:shopTemplate:savePC', 2, '', 0, 'New template', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (364, 355, '删除', '', 'shop:shopTemplate:deletePC', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (365, 355, '复制', '', 'shop:shopTemplate:copyPC', 2, '', 0, 'Copy', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (366, 355, '编辑', '', 'shop:shopTemplate:updatePC', 2, '', 0, 'Edit', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (367, 354, '新增页面', '', 'shop:shopRenovation:savePC', 2, '', 0, 'New page', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (368, 354, '删除', '', 'shop:shopRenovation:deletePC', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (369, 354, '修改', '', 'shop:shopRenovation:updatePC', 2, '', 0, 'Revise', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (370, 354, '设为主页', '', 'shop:shopRenovation:updateHomePC', 2, '', 0, 'Set to home page', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (371, 356, '新增页面', '', 'shop:shopRenovation:saveMove', 2, '', 0, 'New page', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (372, 356, '删除', '', 'shop:shopRenovation:deleteMove', 2, '', 0, 'Delete', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (373, 356, '设为主页', '', 'shop:shopRenovation:updateHomeMove', 2, '', 0, 'Set to home page', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (374, 356, '修改', '', 'shop:shopRenovation:updateMove', 2, '', 0, 'Revise', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (375, 354, '分页查看', '', 'shop:shopRenovation:pagePC', 2, '', 0, 'Paginated view', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (376, 355, '分页查看', '', 'shop:shopTemplate:pagePC', 2, '', 0, 'Paginated view', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (377, 356, '分页查看', '', 'shop:shopRenovation:pageMove', 2, '', 0, 'Paginated view', 0);
| INSERT INTO `yami_bbc`.`tz_shop_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES (378, 357, '分页查看', '', 'shop:shopTemplate:pageMove', 2, '', 0, 'Paginated view', 0);
|
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 0, `name` = '装修', `url` = 'shop/feature/list/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 4, `name_en` = 'Design', `hidden` = 1 WHERE `menu_id` = 16;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 16, `name` = '修改主页标识', `url` = '', `perms` = 'shop:shopRenovation:updateHome', `type` = 2, `icon` = '', `order_num` = 0, `name_en` = 'Modify homepage logo', `hidden` = 1 WHERE `menu_id` = 78;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 16, `name` = '新增', `url` = '', `perms` = 'shop:shopRenovation:save', `type` = 2, `icon` = '', `order_num` = 0, `name_en` = 'Add', `hidden` = 1 WHERE `menu_id` = 79;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 16, `name` = '修改', `url` = '', `perms` = 'shop:shopRenovation:update', `type` = 2, `icon` = '', `order_num` = 0, `name_en` = 'Modify', `hidden` = 1 WHERE `menu_id` = 80;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 16, `name` = '删除', `url` = '', `perms` = 'shop:shopRenovation:delete', `type` = 2, `icon` = '', `order_num` = 0, `name_en` = 'Delete', `hidden` = 1 WHERE `menu_id` = 81;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 16, `name` = '查看', `url` = '', `perms` = 'shop:shopRenovation:page', `type` = 2, `icon` = '', `order_num` = 0, `name_en` = 'Page', `hidden` = 1 WHERE `menu_id` = 169;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 2, `name` = '编辑微页面', `url` = 'shop/feature/create/edit/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 0, `name_en` = 'Edit mini-page', `hidden` = 1 WHERE `menu_id` = 303;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 2, `name` = '编辑PC端微页面', `url` = 'shop/decorate/create/edit/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 0, `name_en` = '编辑PC端微页面', `hidden` = 1 WHERE `menu_id` = 324;
| UPDATE `yami_bbc`.`tz_shop_menu` SET `parent_id` = 2, `name` = 'PC端微页面查看', `url` = 'shop/decorate/create/select-decorate/index', `perms` = '', `type` = 1, `icon` = '', `order_num` = 0, `name_en` = 'PC Micro Page', `hidden` = 1 WHERE `menu_id` = 327;
|
| delete from `yami_bbc`.`tz_sys_menu` where menu_id = 816;
|
| delete from `yami_bbc`.`tz_shop_menu` where menu_id = 324
|
|
