/*-----------------------------------------------------------------------------------------
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