
ALTER TABLE [dbo].[TA_Tbl_LeaveType] ADD 
[IsDocProofRequired] [bit] NULL,
[LeaveCategory] [int] NULL,
[isWFH] [int] NULL
GO
ALTER TABLE [dbo].[TA_Tbl_PayrollProcessDetails] ADD 
[FullPaidLeave] [numeric] (18,1) NULL,
[HalfPaidLeave] [numeric] (18,1) NULL,
[UnPaidLeave] [numeric] (18,1) NULL
GO
ALTER TABLE [dbo].[ImportFromExcel] ADD 
[LeaveType16] [decimal] (18,1) NULL,
[LeaveType17] [decimal] (18,1) NULL,
[LeaveType18] [decimal] (18,1) NULL,
[LeaveType19] [decimal] (18,1) NULL,
[LeaveType20] [decimal] (18,1) NULL,
[LeaveType21] [decimal] (18,1) NULL,
[LeaveType22] [decimal] (18,1) NULL,
[LeaveType23] [decimal] (18,1) NULL,
[LeaveType24] [decimal] (18,1) NULL,
[LeaveType25] [decimal] (18,1) NULL,
[LeaveType26] [decimal] (18,1) NULL,
[LeaveType27] [decimal] (18,1) NULL,
[LeaveType28] [decimal] (18,1) NULL,
[LeaveType29] [decimal] (18,1) NULL,
[LeaveType30] [decimal] (18,1) NULL
GO
ALTER TABLE [dbo].[TA_Tbl_LeaveApplication] ADD 
[MCFilePath] [varchar] (200) NULL
GO
CREATE TABLE [dbo].[TA_Tbl_LeaveApplication_FileUpload]
(
	[Id] [bigint] IDENTITY (1,1) NOT NULL,
	[FileName] [varchar] (50) NOT NULL,
	[FilePath] [nvarchar] (200) NOT NULL,
	[Emp_Id] [int] NOT NULL,
	[LeaveApplication_Id] [bigint] NOT NULL
)
GO
