----------------------------Hammad 2021-02-01-------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (449, N'Attendance Sheet', N'كشف الحضور والانصراف', 345, N'/Attendance/AttendanceSheet', N'Index', N'fa fa-calendar', N'get', 5, 1, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13067, N'كشف الحضور والانصراف', N'Attendance Sheet', 449, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13068, N' عرض كشف الحضور والانصراف ', N' View Attendance Sheet', 449, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13069, N' حفظ  كشف الحضور والانصراف', N' Save Attendance Sheets', 449, 2)
Go
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (449, 11)
GO
----------------------------End 2021-02-01-------------------
----------------------------Sayed 2021-02-08----------------
CREATE TABLE [dbo].[ShiftSection](
	[SerialAuto] [int] IDENTITY(1,1) NOT NULL,
	[ShiftCode] [int] NOT NULL,
	[SectionCode] [nvarchar](6) NOT NULL,
	[Available] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_ShiftSection] PRIMARY KEY CLUSTERED 
(
	[ShiftCode] ASC,
	[SectionCode] 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].[ShiftSection] ADD  CONSTRAINT [DF_ShiftSection_Available]  DEFAULT ((0)) FOR [Available]
GO


CREATE TABLE [dbo].[TimeSheet](
	[EmployeeCode] [int] NOT NULL,
	[Period] [tinyint] NOT NULL,
	[PYear] [smallint] NOT NULL,
	[FirstDay] [datetime] NULL,
	[LastDay] [datetime] NULL,
	[TotalDays] [int] NULL,
	[VT1] [tinyint] NULL,
	[VT2] [tinyint] NULL,
	[VT3] [tinyint] NULL,
	[VT4] [tinyint] NULL,
	[VT5] [tinyint] NULL,
	[VT6] [tinyint] NULL,
	[VT7] [tinyint] NULL,
	[VT8] [tinyint] NULL,
	[VT9] [tinyint] NULL,
	[VT10] [tinyint] NULL,
	[VT11] [tinyint] NULL,
	[VT12] [tinyint] NULL,
	[VT13] [tinyint] NULL,
	[LineType] [tinyint] NULL,
	[01] [nvarchar](2) NULL,
	[02] [nvarchar](2) NULL,
	[03] [nvarchar](2) NULL,
	[04] [nvarchar](2) NULL,
	[05] [nvarchar](2) NULL,
	[06] [nvarchar](2) NULL,
	[07] [nvarchar](2) NULL,
	[08] [nvarchar](2) NULL,
	[09] [nvarchar](2) NULL,
	[10] [nvarchar](2) NULL,
	[11] [nvarchar](2) NULL,
	[12] [nvarchar](2) NULL,
	[13] [nvarchar](2) NULL,
	[14] [nvarchar](2) NULL,
	[15] [nvarchar](2) NULL,
	[16] [nvarchar](2) NULL,
	[17] [nvarchar](2) NULL,
	[18] [nvarchar](2) NULL,
	[19] [nvarchar](2) NULL,
	[20] [nvarchar](2) NULL,
	[21] [nvarchar](2) NULL,
	[22] [nvarchar](2) NULL,
	[23] [nvarchar](2) NULL,
	[24] [nvarchar](2) NULL,
	[25] [nvarchar](2) NULL,
	[26] [nvarchar](2) NULL,
	[27] [nvarchar](2) NULL,
	[28] [nvarchar](2) NULL,
	[29] [nvarchar](2) NULL,
	[30] [nvarchar](2) NULL,
	[31] [nvarchar](2) NULL,
	[Serial] [int] NULL,
	[Type] [tinyint] NULL,
	[SectionCode] [nvarchar](20) NULL,
	[HRApproval] [int] NULL,
	[WorkingDays] [float] NULL,
	[DepApproval] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_TimeSheet] PRIMARY KEY CLUSTERED 
(
	[EmployeeCode] ASC,
	[Period] ASC,
	[PYear] 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].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_EmployeeCode]  DEFAULT ((0)) FOR [EmployeeCode]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_TotalDays]  DEFAULT ((0)) FOR [TotalDays]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT1]  DEFAULT ((0)) FOR [VT1]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT2]  DEFAULT ((0)) FOR [VT2]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT3]  DEFAULT ((0)) FOR [VT3]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT4]  DEFAULT ((0)) FOR [VT4]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT5]  DEFAULT ((0)) FOR [VT5]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT6]  DEFAULT ((0)) FOR [VT6]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT7]  DEFAULT ((0)) FOR [VT7]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT8]  DEFAULT ((0)) FOR [VT8]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT9]  DEFAULT ((0)) FOR [VT9]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT10]  DEFAULT ((0)) FOR [VT10]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT11]  DEFAULT ((0)) FOR [VT11]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT12]  DEFAULT ((0)) FOR [VT12]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_VT13]  DEFAULT ((0)) FOR [VT13]
GO

ALTER TABLE [dbo].[TimeSheet] ADD  CONSTRAINT [DF_TimeSheet_LineType]  DEFAULT ((0)) FOR [LineType]
GO


--------------------------End 2021-02-08---------------------------------------