﻿--------------------------------------- Ali 2024-12-30 -------------------



CREATE TABLE [dbo].[WF_TrackNationalities](
	[TrackNationalityCode] [int] IDENTITY(1,1) NOT NULL,
	[TrackId] [int] NOT NULL,
	[NationalityCode] [tinyint] NOT NULL,
 CONSTRAINT [PK_WF_TrackNationalities] PRIMARY KEY CLUSTERED 
(
	[TrackNationalityCode] 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_TrackNationalities]  WITH CHECK ADD  CONSTRAINT [FK_WF_TrackNationalities_Nationality] FOREIGN KEY([NationalityCode])
REFERENCES [dbo].[Nationality] ([NationalityCode])
GO

ALTER TABLE [dbo].[WF_TrackNationalities] CHECK CONSTRAINT [FK_WF_TrackNationalities_Nationality]
GO

ALTER TABLE [dbo].[WF_TrackNationalities]  WITH CHECK ADD  CONSTRAINT [FK_WF_TrackNationalities_WF_Track] FOREIGN KEY([TrackId])
REFERENCES [dbo].[WF_Track] ([TrackId])
GO

ALTER TABLE [dbo].[WF_TrackNationalities] CHECK CONSTRAINT [FK_WF_TrackNationalities_WF_Track]
GO
--------------------------------------- End 2024-12-30 -------------------
--------------------------------------- Hammad 2024-12-30 ----------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
VALUES (N'WFPermissionMaxHour', N'Permission Max No Of Hour ', N'الحد الاقصى لعدد ساعات الاذن  ', N'6', 2, 35, 2, 1, 1, CAST(N'2025-01-01T14:10:34.067' AS DateTime), 2, N'الحد الاقصى لعدد ساعات الاذن  ')
GO
--------------------------------------- End 2024-12-30 ----------------
----------------------------------------- AK 2025-01-02 --------------------
UPDATE SecurityPrivilege SET DescriptionAR=trim(DescriptionAR),DescriptionEN=trim(DescriptionEN) WHERE (Len(trim(DescriptionAR))<>Len(DescriptionAR) OR Len(trim(DescriptionEN))<>Len(DescriptionEN))
GO
UPDATE SystemMenu SET Arabic_Name=trim(Arabic_Name),Name=trim(Name) WHERE (Len(trim(Arabic_Name))<>Len(Arabic_Name) OR Len(trim(Name))<>Len(Name)
GO
----------------------------------------- AK 2025-01-02 --------------------- 