------------------------------- Hammad 2020-10-28 -----------------------
ALTER TABLE dbo.VacationType ADD
	ShowSalaryAdvanceRequired bit NOT NULL CONSTRAINT DF_VacationType_ShowVacationTime1 DEFAULT ((0)),
	ShowAirTicketRequired bit NOT NULL CONSTRAINT DF_VacationType_ShowVacationTime2 DEFAULT ((0)),
	SubmitBeforRequestDate int NULL,
	SubmitAfterRequestDate int NULL
GO
------------------------------- End 2020-10-28 -----------------------
------------------------------- Ali 2020-11-01 -----------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2134, N'ارسال نموذج استفسار ', N'Send Enquiry Templete', 16, 2)
Go

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (160, N' Enquiry about Transaction ', N'استفسار عن معامله', 0, 2)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
Go
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (160, N' Enquiry about Transaction ', N'استفسار عن معامله', 160, N'استفسار عن معامله', N'<p>استفسار عن المعامله</p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
Go



CREATE TABLE [dbo].[AC_TransactionEnquiry](
	[TransactionEnquiryId] [int] IDENTITY(1,1) NOT NULL,
	[TransactionCode] [int] NOT NULL,
	[AuthorityCode] [int] NOT NULL,
	[Content] [nvarchar](max) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[ModificationDateHijri] [nvarchar](10) NULL,
	[PenaltyAuthorityCode] [int] NOT NULL,
 CONSTRAINT [PK_AC_TransactionEnquiry] PRIMARY KEY CLUSTERED 
(
	[TransactionEnquiryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AC_TransactionEnquiry]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionEnquiry_AC_Transaction] FOREIGN KEY([TransactionCode])
REFERENCES [dbo].[AC_Transaction] ([TransactionCode])
GO

ALTER TABLE [dbo].[AC_TransactionEnquiry] CHECK CONSTRAINT [FK_AC_TransactionEnquiry_AC_Transaction]
GO





ALTER TABLE dbo.AC_Authority ADD
	AuthorityLevel tinyint NULL,
	DepartmentCode nvarchar(4) NULL
GO
ALTER TABLE dbo.AC_Authority SET (LOCK_ESCALATION = TABLE)
GO
------------------------------- End 2020-11-01 -----------------------
------------------------------- A.Khaled 2020-11-02 -------------------------- 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (1000, N'Career path', N'المسار الوظيفي', 4, N'/Inventory/DualLadderPath', N'Index', N'fa fa-thumb-tack', N'get', 0, 1, 0)
INSERT INTO SystemMenuModule (SystemMenuCode,AppModuleCode) VALUES (1000,6)
------------------------------- End 2020-11-02 --------------------------
------------------------------- Hammad 2020-11-02 -----------------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (161, N'Employee Delegation', N'تفويض الموظفيين', 0, 1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (161, N'Employee Delegation', N'تفويض الموظفيين', 161, N'تفويض الموظفيين', N'<p>تفويض الموظفيين</p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
------------------------------- End 2020-11-02 -----------------------

