﻿-----------------------------------------SHEHAB 2026-04-28 --------------------

ALTER TABLE [SST.ERP_Client].[dbo].[Clients] ADD
	ErpPublishURL nvarchar(250) NULL,
	ErpPhysicalPath nvarchar(250) NULL
GO
-----------------------------------------END 2026-04-28 --------------------
-----------------------------------------Ali 2026-05-03 --------------------

 IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE name = 'CountryKey' AND object_id = OBJECT_ID('dbo.Country'))
                   ALTER TABLE [dbo].[Country] ADD [CountryKey] nvarchar(20)  NULL
Go
				   
           IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE name = 'CountryCode' AND object_id = OBJECT_ID('dbo.ForeignerUser'))
              ALTER TABLE [dbo].[ForeignerUser] ADD [CountryCode] INT NULL
Go
           

 IF NOT EXISTS (
                     SELECT 1 FROM sys.indexes 
                     WHERE name = 'IX_ForeignerUser_CountryCode' 
                     AND object_id = OBJECT_ID('dbo.ForeignerUser')
                 )
                 BEGIN
                     CREATE INDEX [IX_ForeignerUser_CountryCode]
                     ON [dbo].[ForeignerUser] ([CountryCode])
                 END
               Go 

 IF NOT EXISTS (
                    SELECT 1 FROM sys.foreign_keys 
                    WHERE name = 'FK_ForeignerUser_Country_CountryCode'
                )
                BEGIN
                    ALTER TABLE [dbo].[ForeignerUser]
                    ADD CONSTRAINT [FK_ForeignerUser_Country_CountryCode]
                    FOREIGN KEY ([CountryCode]) 
                    REFERENCES [dbo].[Country]([CountryCode])
                END
               Go


INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'Rec_IntegrationWithNewOnlineRecruitment',N'Integration With New Online Recruitment',N'التكامل مع التوظيف الاونلاين الجديد',N'true',14,45,1,1,Null,Null,Null,N'لعرض البيانات التى تم اضافتها جديد فى التوظيف الاونلاين الجديد')
Go
-----------------------------------------END 2026-05-03 --------------------
----------------------------------------- AK 2026-05-04 -----------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
VALUES (N'ShowChatFeature', N'Show chat page', N'عرض صفحة تواصل مع موظفيني', N'false', 15, 3, 1, 1, NULL, NULL, NULL, N'عرض صفحة تواصل مع موظفيني')
GO
----------------------------------------- End 2026-05-04 ------------