
  ------------------------------Ali 2020-06-04--------------
 ALTER TABLE dbo.UserType ADD
	OrganizationCategoryCode int NULL
GO

ALTER TABLE [dbo].[UserType]  WITH CHECK ADD  CONSTRAINT [FK_UserType_OrganizationCategory] FOREIGN KEY([OrganizationCategoryCode])
REFERENCES [dbo].[OrganizationCategory] ([OrganizationCategoryCode])
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (253, N'Organization Structure privileges', N'صلاحيات الهيكل الإدارى', 250, N'/BasicData/OrganizationStructurePrivilege', N'Index', NULL, N'get', 5, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 253, 6)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1218, N'صلاحيات الهيكل الإدارى', N'Organization Structure privileges', 253, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1219, N'عرض صلاحيات الهيكل الإدارى', N'View Organization Structure privileges', 253, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1220, N'إضافة صلاحيات الهيكل الإدارى', N'Add Organization Structure privileges', 253, 2)
GO
  ------------------------------End 2020-06-04--------------
  ------------------------------Hammad 2020-06-08-----------

  


CREATE TABLE [dbo].[WF_MissionPlace](
	[MissionPlaceCode] [int] IDENTITY(1,1) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[ModificationDateHijri] [nvarchar](10) NULL,
 CONSTRAINT [PK_WF_MissionPlace] PRIMARY KEY CLUSTERED 
(
	[MissionPlaceCode] 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



CREATE TABLE [dbo].[WF_MissionPlaceLevel](
	[MissionPlaceLevelCode] [int] IDENTITY(1,1) NOT NULL,
	[MissionPlaceCode] [int] NOT NULL,
	[LevelCode] [tinyint] NOT NULL,
	[Amount] [float] NOT NULL,
 CONSTRAINT [PK_MissionPlaceLevel] PRIMARY KEY CLUSTERED 
(
	[MissionPlaceLevelCode] 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

ALTER TABLE [dbo].[WF_MissionPlaceLevel]  WITH CHECK ADD  CONSTRAINT [FK_WF_MissionPlaceLevel_Levels] FOREIGN KEY([LevelCode])
REFERENCES [dbo].[Levels] ([LevelCode])
GO

ALTER TABLE [dbo].[WF_MissionPlaceLevel] CHECK CONSTRAINT [FK_WF_MissionPlaceLevel_Levels]
GO

ALTER TABLE [dbo].[WF_MissionPlaceLevel]  WITH CHECK ADD  CONSTRAINT [FK_WF_MissionPlaceLevel_WF_MissionPlace] FOREIGN KEY([MissionPlaceCode])
REFERENCES [dbo].[WF_MissionPlace] ([MissionPlaceCode])
GO

ALTER TABLE [dbo].[WF_MissionPlaceLevel] CHECK CONSTRAINT [FK_WF_MissionPlaceLevel_WF_MissionPlace]
GO




INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (254, N'Mission Place', N'مكان المامورية', 28, N'/WorkFlow/MissionPlace', N'Index', NULL, N'get', 20, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3535, N'مكان المامورية', N' Mission Place', 254, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3536, N'عرض مكان المامورية', N'View Mission Place', 254, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3537, N'اضافة مكان المامورية', N'Add Mission Place', 254, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3538, N'تعديل مكان المامورية', N'Edit Mission Place', 254, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3539, N'حذف مكان المامورية', N'Delete Mission Place', 254, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3540, N'حفظ مكان المامورية', N'Save Mission Place', 254, 2)
GO

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 254, 1)
Go

  ALTER TABLE dbo.WF_VacationRequest ADD
	MissionPlaceCode int NULL
GO


ALTER TABLE [dbo].[WF_VacationRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_VacationRequest_WF_MissionPlace] FOREIGN KEY([MissionPlaceCode])
REFERENCES [dbo].[WF_MissionPlace] ([MissionPlaceCode])
GO

ALTER TABLE [dbo].[WF_VacationRequest] CHECK CONSTRAINT [FK_WF_VacationRequest_WF_MissionPlace]
GO



ALTER TABLE dbo.WF_PermissionRequest ADD
	MissionPlaceCode int NULL
GO
ALTER TABLE [dbo].[WF_PermissionRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PermissionRequest_WF_MissionPlace] FOREIGN KEY([MissionPlaceCode])
REFERENCES [dbo].[WF_MissionPlace] ([MissionPlaceCode])
GO

ALTER TABLE [dbo].[WF_PermissionRequest] CHECK CONSTRAINT [FK_WF_PermissionRequest_WF_MissionPlace]
GO
  ------------------------------End 2020-06-08-----------
