﻿ --------------------------Ali 2021-06-19--------------------------

CREATE TABLE [dbo].[PasswordPolicies](
	[PasswordPolicyCode] [int] IDENTITY(1,1) NOT NULL,
	[Description_Arabic] [nvarchar](150) NOT NULL,
	[Description_English] [nvarchar](150) NOT NULL,
	[SecurityUserDescription] [bit] NOT NULL,
	[SecurityPasswordNumber] [bit] NOT NULL,
	[SecurityPasswordSymbols] [bit] NOT NULL,
	[SecurityPasswordCount] [smallint] NOT NULL,
	[CheckIdNumberWhenChangeDefualtPassword] [bit] NOT NULL,
	[CheckBirthDateWhenChangeDefualtPassword] [bit] NOT NULL,
	[CheckYearOfBirthWhenChangeDefualtPassword] [bit] NOT NULL,
	[CheckHiringDateWhenChangeDefualtPassword] [bit] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_PasswordPolicies] PRIMARY KEY CLUSTERED 
(
	[PasswordPolicyCode] 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].[PasswordPolicies] ADD  CONSTRAINT [DF_PasswordPolicies_SecurityUserDescription]  DEFAULT ((0)) FOR [SecurityUserDescription]
GO

ALTER TABLE [dbo].[PasswordPolicies] ADD  CONSTRAINT [DF_PasswordPolicies_SecurityPasswordNumber]  DEFAULT ((0)) FOR [SecurityPasswordNumber]
GO

ALTER TABLE [dbo].[PasswordPolicies] ADD  CONSTRAINT [DF_PasswordPolicies_SecurityPasswordSymbols]  DEFAULT ((0)) FOR [SecurityPasswordSymbols]
GO

ALTER TABLE [dbo].[PasswordPolicies] ADD  CONSTRAINT [DF_PasswordPolicies_CheckIdNumberWhenChangeDefualtPassword]  DEFAULT ((0)) FOR [CheckIdNumberWhenChangeDefualtPassword]
GO

ALTER TABLE [dbo].[PasswordPolicies] ADD  CONSTRAINT [DF_PasswordPolicies_CheckBirthDateWhenChangeDefualtPassword]  DEFAULT ((0)) FOR [CheckBirthDateWhenChangeDefualtPassword]
GO

ALTER TABLE [dbo].[PasswordPolicies] ADD  CONSTRAINT [DF_PasswordPolicies_CheckYearOfBirthWhenChangeDefualtPassword]  DEFAULT ((0)) FOR [CheckYearOfBirthWhenChangeDefualtPassword]
GO

ALTER TABLE [dbo].[PasswordPolicies] ADD  CONSTRAINT [DF_PasswordPolicies_CheckHiringDateWhenChangeDefualtPassword]  DEFAULT ((0)) FOR [CheckHiringDateWhenChangeDefualtPassword]
GO


ALTER TABLE SecurityGroup ADD PasswordPolicyCode int Null
ALTER TABLE dbo.SecurityGroup ADD CONSTRAINT
	FK_SecurityGroup_PasswordPolicies FOREIGN KEY
	(
	PasswordPolicyCode
	) REFERENCES dbo.PasswordPolicies
	(
	PasswordPolicyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(543,N'Password Policy',N'سياسة كلمة المرور',4,N'/PasswordPolicy',N'Index','fa fa-thumb-tack',N'get',15,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(543,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1286,N'سياسة كلمة المرور',N'Password Policy',543,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1287,N'عرض سياسة كلمة المرور',N'View Password Policy',543,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1288,N'إضافة سياسة كلمة المرور',N'Add Password Policy',543,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1289,N'تعديل سياسة كلمة المرور',N'Edit Password Policy',543,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1290,N'حذف سياسة كلمة المرور',N'Delete Password Policy',543,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1291,N'حفظ سياسة كلمة المرور',N'Save Password Policy',543,2)
Go

 --------------------------End 2021-06-19--------------------------
