﻿  -----------------------------------------Sayed 2025-05-06 -----------------
 ALTER TABLE dbo.FingerAreaCheckPointLogs ADD
	TimeCheckInOutPureDataId int NULL
GO
 -----------------------------------------End 2025-05-06 -----------------
 ----------------------------------------- AK 2025-05-06 --------------------
UPDATE APIs SET ApiName=N'ERP Api' WHERE ApiId=4
GO
 -----------------------------------------END AK 2025-05-06 --------------------
 ----------------------------------------- AK 2025-05-06 --------------------
BEGIN TRANSACTION
GO
CREATE TABLE dbo.TaskFiles
	(
	TaskFileCode int NOT NULL IDENTITY (1, 1),
	TaskCode int NOT NULL,
	FileName nvarchar(500) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.TaskFiles ADD CONSTRAINT
	PK_TaskFiles PRIMARY KEY CLUSTERED 
	(
	TaskFileCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.TaskFiles ADD CONSTRAINT
	FK_TaskFiles_Tasks FOREIGN KEY
	(
	TaskCode
	) REFERENCES dbo.Tasks
	(
	TaskCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.TaskFiles SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
 -----------------------------------------END AK 2025-05-06 --------------------
  ----------------------------------------- AK 2025-05-06 --------------------
UPDATE [SST.ERP_Client].dbo.APIs SET ApiName=N'ERP Api' WHERE ApiId=4
GO
 -----------------------------------------END AK 2025-05-06 --------------------