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
| -- 注意：该页面对应的前台目录为views/copywritingScheme文件夹下
| -- 如果你想更改到其他目录，请修改sql中component字段对应的值
|
|
| -- 主菜单
| INSERT INTO sys_permission(id, parent_id, name, url, component, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_route, is_leaf, keep_alive, hidden, hide_tab, description, status, del_flag, rule_flag, create_by, create_time, update_by, update_time, internal_or_external)
| VALUES ('177062978662501', NULL, '文案生成方案', '/copywritingScheme/copywritingSchemeList', 'copywritingScheme/CopywritingSchemeList', NULL, NULL, 0, NULL, '1', 0.00, 0, NULL, 1, 0, 0, 0, 0, NULL, '1', 0, 0, 'admin', '2026-02-09 17:36:26', NULL, NULL, 0);
|
| -- 新增
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('177062978662502', '177062978662501', '添加文案生成方案', NULL, NULL, 0, NULL, NULL, 2, 'copywritingScheme:copywriting_scheme:add', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2026-02-09 17:36:26', NULL, NULL, 0, 0, '1', 0);
|
| -- 编辑
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('177062978662503', '177062978662501', '编辑文案生成方案', NULL, NULL, 0, NULL, NULL, 2, 'copywritingScheme:copywriting_scheme:edit', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2026-02-09 17:36:26', NULL, NULL, 0, 0, '1', 0);
|
| -- 删除
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('177062978662504', '177062978662501', '删除文案生成方案', NULL, NULL, 0, NULL, NULL, 2, 'copywritingScheme:copywriting_scheme:delete', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2026-02-09 17:36:26', NULL, NULL, 0, 0, '1', 0);
|
| -- 批量删除
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('177062978662505', '177062978662501', '批量删除文案生成方案', NULL, NULL, 0, NULL, NULL, 2, 'copywritingScheme:copywriting_scheme:deleteBatch', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2026-02-09 17:36:26', NULL, NULL, 0, 0, '1', 0);
|
| -- 导出excel
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('177062978662506', '177062978662501', '导出excel_文案生成方案', NULL, NULL, 0, NULL, NULL, 2, 'copywritingScheme:copywriting_scheme:exportXls', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2026-02-09 17:36:26', NULL, NULL, 0, 0, '1', 0);
|
| -- 导入excel
| INSERT INTO sys_permission(id, parent_id, name, url, component, is_route, component_name, redirect, menu_type, perms, perms_type, sort_no, always_show, icon, is_leaf, keep_alive, hidden, hide_tab, description, create_by, create_time, update_by, update_time, del_flag, rule_flag, status, internal_or_external)
| VALUES ('177062978662507', '177062978662501', '导入excel_文案生成方案', NULL, NULL, 0, NULL, NULL, 2, 'copywritingScheme:copywriting_scheme:importExcel', '1', NULL, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2026-02-09 17:36:26', NULL, NULL, 0, 0, '1', 0);
|
| -- 角色授权（以 admin 角色为例，role_id 可替换）
| INSERT INTO sys_role_permission (id, role_id, permission_id, data_rule_ids, operate_date, operate_ip) VALUES ('177062978662508', 'f6817f48af4fb3af11b9e8bf182f618b', '177062978662501', NULL, '2026-02-09 17:36:26', '127.0.0.1');
| INSERT INTO sys_role_permission (id, role_id, permission_id, data_rule_ids, operate_date, operate_ip) VALUES ('177062978662509', 'f6817f48af4fb3af11b9e8bf182f618b', '177062978662502', NULL, '2026-02-09 17:36:26', '127.0.0.1');
| INSERT INTO sys_role_permission (id, role_id, permission_id, data_rule_ids, operate_date, operate_ip) VALUES ('177062978662510', 'f6817f48af4fb3af11b9e8bf182f618b', '177062978662503', NULL, '2026-02-09 17:36:26', '127.0.0.1');
| INSERT INTO sys_role_permission (id, role_id, permission_id, data_rule_ids, operate_date, operate_ip) VALUES ('177062978662511', 'f6817f48af4fb3af11b9e8bf182f618b', '177062978662504', NULL, '2026-02-09 17:36:26', '127.0.0.1');
| INSERT INTO sys_role_permission (id, role_id, permission_id, data_rule_ids, operate_date, operate_ip) VALUES ('177062978662512', 'f6817f48af4fb3af11b9e8bf182f618b', '177062978662505', NULL, '2026-02-09 17:36:26', '127.0.0.1');
| INSERT INTO sys_role_permission (id, role_id, permission_id, data_rule_ids, operate_date, operate_ip) VALUES ('177062978662513', 'f6817f48af4fb3af11b9e8bf182f618b', '177062978662506', NULL, '2026-02-09 17:36:26', '127.0.0.1');
| INSERT INTO sys_role_permission (id, role_id, permission_id, data_rule_ids, operate_date, operate_ip) VALUES ('177062978662514', 'f6817f48af4fb3af11b9e8bf182f618b', '177062978662507', NULL, '2026-02-09 17:36:26', '127.0.0.1');
|
|
