yystopf
/
microservices
forked from Gitlink/microservices
0
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
microservices/sql/update/hisotry_sql/2023-07-06-001.sql

528 lines
15 KiB
SQL
Raw Permalink Blame History

SET FOREIGN_KEY_CHECKS = 0;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '系统管理',
`parent_id` = 0,
`order_num` = 1,
`path` = 'system',
`component` = NULL,
`query` = '',
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'AppstoreFilled',
`create_by` = 'admin',
`create_time` = '2021-12-10 14:12:14',
`update_by` = 'admin',
`update_time` = '2023-07-04 15:26:18',
`remark` = '系统管理目录'
WHERE `menu_id` = 1;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '系统监控',
`parent_id` = 0,
`order_num` = 2,
`path` = 'monitor',
`component` = NULL,
`query` = '',
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'QuestionCircleFilled',
`create_by` = 'admin',
`create_time` = '2021-12-10 14:12:14',
`update_by` = 'admin',
`update_time` = '2023-07-04 13:36:15',
`remark` = '系统监控目录'
WHERE `menu_id` = 2;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '组织管理',
`parent_id` = 1,
`order_num` = 1,
`path` = 'dept',
`component` = 'system/dept/index',
`query` = '',
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'system:dept:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2021-12-10 14:12:14',
`update_by` = 'admin',
`update_time` = '2023-07-04 15:39:38',
`remark` = '组织管理菜单'
WHERE `menu_id` = 103;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '内容管理',
`parent_id` = 0,
`order_num` = 1,
`path` = 'cms',
`component` = NULL,
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'QuestionCircleOutlined',
`create_by` = 'admin',
`create_time` = '2021-12-20 14:53:48',
`update_by` = 'admin',
`update_time` = '2023-07-04 13:35:53',
`remark` = ''
WHERE `menu_id` = 2007;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '专区管理',
`parent_id` = 0,
`order_num` = 5,
`path` = 'zone',
`component` = NULL,
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'ShopFilled',
`create_by` = 'admin',
`create_time` = '2023-03-17 11:42:55',
`update_by` = 'admin',
`update_time` = '2023-07-04 15:00:23',
`remark` = ''
WHERE `menu_id` = 2074;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '栏目管理',
`parent_id` = 2111,
`order_num` = 2,
`path` = 'column',
`component` = 'zone/cms/column/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'cms:doc:dirList',
`icon` = '#',
`create_by` = 'innov',
`create_time` = '2023-04-13 16:14:51',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:46:25',
`remark` = ''
WHERE `menu_id` = 2085;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '文章管理',
`parent_id` = 2111,
`order_num` = 3,
`path` = 'doc',
`component` = 'zone/cms/doc/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'cms:doc:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-04-14 16:27:38',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:46:33',
`remark` = ''
WHERE `menu_id` = 2086;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '专区概览',
`parent_id` = 2074,
`order_num` = 1,
`path` = 'list',
`component` = 'zone/cms/zone/index',
`query` = 'changeCurrentUserIdentity',
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:zoneDetail:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-04-21 16:46:27',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:39:34',
`remark` = ''
WHERE `menu_id` = 2087;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '项目管理',
`parent_id` = 2074,
`order_num` = 4,
`path` = 'project',
`component` = NULL,
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'SlackCircleFilled',
`create_by` = 'admin',
`create_time` = '2023-05-22 16:34:16',
`update_by` = 'admin',
`update_time` = '2023-07-04 15:02:19',
`remark` = ''
WHERE `menu_id` = 2112;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '项目分类',
`parent_id` = 2112,
`order_num` = 2,
`path` = 'category',
`component` = 'zone/project/category/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:projectType:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-05-22 16:35:27',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:47:10',
`remark` = ''
WHERE `menu_id` = 2113;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '项目列表',
`parent_id` = 2112,
`order_num` = 3,
`path` = 'list',
`component` = 'zone/project/list/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:project:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-05-22 16:45:01',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:47:14',
`remark` = ''
WHERE `menu_id` = 2115;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '会员管理',
`parent_id` = 2074,
`order_num` = 5,
`path` = 'member',
`component` = NULL,
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'CrownFilled',
`create_by` = 'admin',
`create_time` = '2023-05-24 09:46:53',
`update_by` = 'admin',
`update_time` = '2023-07-04 15:03:51',
`remark` = ''
WHERE `menu_id` = 2116;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '会员分类',
`parent_id` = 2116,
`order_num` = 1,
`path` = 'category',
`component` = 'zone/member/category/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:memberType:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-05-24 09:48:32',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:47:21',
`remark` = ''
WHERE `menu_id` = 2117;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '会员列表',
`parent_id` = 2116,
`order_num` = 3,
`path` = 'list',
`component` = 'zone/member/list/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:member:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-05-24 09:49:05',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:47:32',
`remark` = ''
WHERE `menu_id` = 2118;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '会员等级',
`parent_id` = 2116,
`order_num` = 2,
`path` = 'identity',
`component` = 'zone/member/Identity/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:memberLevel:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-05-27 11:20:34',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:47:26',
`remark` = ''
WHERE `menu_id` = 2119;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = 'logo管理',
`parent_id` = 2164,
`order_num` = 2,
`path` = 'list',
`component` = 'zone/partner/list/index',
`query` = '',
`is_frame` = 1,
`is_cache` = 1,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:partners:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-07 15:56:22',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:46:54',
`remark` = ''
WHERE `menu_id` = 2157;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '合作伙伴',
`parent_id` = 2074,
`order_num` = 2,
`path` = 'partner',
`component` = '',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'WalletFilled',
`create_by` = 'admin',
`create_time` = '2023-06-08 14:18:45',
`update_by` = 'admin',
`update_time` = '2023-07-04 14:43:55',
`remark` = ''
WHERE `menu_id` = 2164;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '首页配置',
`parent_id` = 2074,
`order_num` = 1,
`path` = 'configuration',
`component` = 'zone/cms/zone/configuration',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-08 14:27:54',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:46:09',
`remark` = ''
WHERE `menu_id` = 2166;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '审核会员列表',
`parent_id` = 2116,
`order_num` = 4,
`path` = 'auditList',
`component` = 'zone/member/AuditList/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:member:auditList',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-12 10:52:48',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:47:37',
`remark` = ''
WHERE `menu_id` = 2167;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '项目配置',
`parent_id` = 2112,
`order_num` = 1,
`path` = 'configuration',
`component` = 'zone/project/configuration/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-16 14:43:21',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:47:05',
`remark` = ''
WHERE `menu_id` = 2169;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = 'logo分类管理',
`parent_id` = 2164,
`order_num` = 1,
`path` = 'category',
`component` = 'zone/partner/category/index',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:partnersType:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-20 15:50:27',
`update_by` = 'admin',
`update_time` = '2023-07-05 09:46:47',
`remark` = ''
WHERE `menu_id` = 2171;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源管理',
`parent_id` = 2074,
`order_num` = 6,
`path` = 'resource',
`component` = NULL,
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'FileZipFilled',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:52:07',
`update_by` = 'admin',
`update_time` = '2023-07-04 15:04:35',
`remark` = ''
WHERE `menu_id` = 2179;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源类别',
`parent_id` = 2179,
`order_num` = 1,
`path` = 'category',
`component` = '',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:resourceType:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:54:45',
`update_by` = 'admin',
`update_time` = '2023-07-05 10:00:28',
`remark` = ''
WHERE `menu_id` = 2180;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源领域',
`parent_id` = 2179,
`order_num` = 2,
`path` = 'domain',
`component` = 'zone/resource/domain',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:resourceDomain:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:57:04',
`update_by` = 'admin',
`update_time` = '2023-07-05 10:59:10',
`remark` = ''
WHERE `menu_id` = 2186;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源列表',
`parent_id` = 2179,
`order_num` = 3,
`path` = 'resource',
`component` = 'zone/resource/list',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 1,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:resource:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:58:40',
`update_by` = 'admin',
`update_time` = '2023-07-05 10:00:36',
`remark` = ''
WHERE `menu_id` = 2192;
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink