/*-----------------------------------------------------------------------------------------
1.版本号：2023.01.04
2.使用说明：隐藏菜单，需要手动执行后分配权限
3.适用范围：开启数据库备份
4.风险：功能执行耗时较长，影响正常业务。请谨慎操作
*/
IF NOT EXISTS (SELECT 1 FROM t_sys_menu WHERE menu_id = 'H215')
BEGIN
	INSERT INTO t_sys_menu(menu_id,menu_name,menu_code,menu_type,open_type,open_parameter, branch_flag,normal_flag,flag1,flag2,flag3,menu_df_name,sort_no,menu_url,hit_count,com_flag,branch_grant,isnew,add_date,menu_id_new,menu_name_new,menu_sort_no_new,IsShowMenu) 
	VALUES('H215','数据库管理','','OTHR','W',NULL,'11111111',1,0,0,1,'数据库管理',1250,'~/WebPages/Adm/DBManage.aspx',0,0,'1111111111','0','2022-12-27','H215','数据库管理',1250,0)
END
GO

--自动添加1001用户菜单权限
INSERT INTO dbo.t_sys_oper_grant ( oper_id , func_id , grant0 , grant1 , grant2 , grant3 , grant4 , grant5 , grant6 , grant7 , grant8 , grant9 , change_flag ) 
SELECT  '1001', menu_id, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0' 
FROM dbo.t_sys_menu WHERE RTRIM(menu_id) NOT IN(SELECT RTRIM(func_id)  FROM dbo.t_sys_oper_grant  WHERE oper_id = '1001');
GO