﻿


--------------------------------------- Ali 2-02-2023 ---------


CREATE TABLE [dbo].[SqlInterfaceHistory](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Quary] [nvarchar](max) NOT NULL,
	[RunDate] [datetime] NOT NULL,
	[RunBy] [int] NOT NULL,
 CONSTRAINT [PK_SqlInterfaceHistory] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
--------------------------------------- End 2-02-2023 ---------

--------------------------------------- Ali 6-02-2023 ---------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1006,N'Licenses',N'التراخيص',null,N'',N'','fa fa-thumb-tack',N'',7,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1006,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1367,N'التراخيص',N'Licenses',1006,1)
Go


Update [dbo].[SystemMenu] Set ParentID=1006,Sequence=1
 Where  SystemMenuCode= 172
Go



Update [dbo].[SystemMenu] Set ParentID=1006,Sequence=2
 Where  SystemMenuCode= 242
Go



   INSERT INTO [dbo].[SecurityUserDetail] (SecurityUserID,PrivilegeID)
SELECT DISTINCT SecurityUserID, 1367 
FROM [dbo].[SecurityUserDetail] WHERE PrivilegeID in (1193,1194,1195)
Go

INSERT INTO [dbo].SecurityGroupDetail (SecurityGroupID,PrivilegeID)
SELECT DISTINCT SecurityGroupID, 1367 
FROM [dbo].SecurityGroupDetail WHERE PrivilegeID in (1193,1194,1195)
Go
--------------------------------------- End 6-02-2023 ---------
--------------------------------------- Hammad 7-02-2023 ---------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'PrivilegeDependonOrganizationStructure', N'Privilege Depend on organization structure ', N' الاعتماد على الهيكل الادارى فى الصلاحيات ', N'false', 1, 50, 1, 1, NULL, NULL, NULL, N'الاعتماد على الهيكل الادارى فى صلاحيات الاقسام والموظفين والصلاحيات الماليه تعمل بنظام (security level)')
GO
--------------------------------------- End 7-02-2023 -----------
--------------------------------------- Hammad 9-02-2023 ---------
CREATE TABLE [dbo].[UserEmployeeOrganization](
	[UserEmployeeOrgCode] [int] IDENTITY(1,1) NOT NULL,
	[UserCode] [int] NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[Status] [int] NOT NULL,
	[LocationCode] [tinyint] NOT NULL,
 CONSTRAINT [PK_UserEmployeeOrganization] PRIMARY KEY CLUSTERED 
(
	[UserEmployeeOrgCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
--------------------------------------- End 9-02-2023 -----------

--------------------------------------- Sayed 09-02-2023 ---------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1005,N'Users Online',N'المستخدمين (Online)',1003,N'/UsersOnline',N'Index','fa fa-thumb-tack',N'get',4,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1005,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1361,N'المستخدمين (Online)',N'User Online',1005,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1362,N'عرض المستخدمين (Online)',N'View User Online',1005,2)
Go

--------------------------------------- End 09-02-2023 ---------
