﻿
---------------------------------------M.Negm 2024-02-22 -----------------------------

ALTER TABLE Divisions
ALTER COLUMN MandatoryLocation int;
GO
-------------------------------------- End 2024-02-22 --------------------------------
-------------------------------------- Hammad 2024-02-22 -----------------------------

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FingerAreaLogs]') AND type in (N'U'))
DROP TABLE [dbo].[FingerAreaLogs]
GO

CREATE TABLE [dbo].[FingerAreaLogs](
	[FingerAreaLogId] [int] IDENTITY(1,1) NOT NULL,
	[FingerAreaProjectsCode] [int] NULL,
	[FingerAreaUnitCode] [int] NULL,
	[LoginId] [int] NOT NULL,
	[LogoutId] [int] NULL,
 CONSTRAINT [PK_FingerAreaLogs] PRIMARY KEY CLUSTERED 
(
	[FingerAreaLogId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]