﻿--------------------------------------- Ali  09-01-2023 ------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1002,N'Tages',N'الكلمات الافتتاحية',133,N'/Archive/ArcTage',N'Index','fa fa-thumb-tack',N'get',5,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1002,3)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9038,N'الكلمات الافتتاحية',N'Tages',1002,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9039,N'عرض الكلمات الافتتاحية',N'View Tages',1002,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9040,N'إضافة الكلمات الافتتاحية',N'Add Tages',1002,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9041,N'تعديل الكلمات الافتتاحية',N'Edit Tages',1002,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9042,N'حذف الكلمات الافتتاحية',N'Delete Tages',1002,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9043,N'حفظ الكلمات الافتتاحية',N'Save Tages',1002,2)
Go

--------------------------------------- End  09-01-2023 ------------
--------------------------------------- Ali  10-01-2023 ------------


CREATE TABLE [dbo].[Arc_Tages](
	[TageCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](250) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModificationDate] [datetime] NULL,
	[ModifiedBy] [int] NULL,
 CONSTRAINT [PK_Arc_Tages] PRIMARY KEY CLUSTERED 
(
	[TageCode] 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


CREATE TABLE [dbo].[Arc_FileTages](
	[FileTageCode] [int] IDENTITY(1,1) NOT NULL,
	[TageCode] [int] NOT NULL,
	[FileCode] [int] NOT NULL,
 CONSTRAINT [PK_Arc_FileTages] PRIMARY KEY CLUSTERED 
(
	[FileTageCode] 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].[Arc_FileTages]  WITH CHECK ADD  CONSTRAINT [FK_Arc_FileTages_Arc_File] FOREIGN KEY([FileCode])
REFERENCES [dbo].[Arc_File] ([FileCode])
GO

ALTER TABLE [dbo].[Arc_FileTages] CHECK CONSTRAINT [FK_Arc_FileTages_Arc_File]
GO

ALTER TABLE [dbo].[Arc_FileTages]  WITH CHECK ADD  CONSTRAINT [FK_Arc_FileTages_Arc_Tages] FOREIGN KEY([TageCode])
REFERENCES [dbo].[Arc_Tages] ([TageCode])
GO

ALTER TABLE [dbo].[Arc_FileTages] CHECK CONSTRAINT [FK_Arc_FileTages_Arc_Tages]
GO


--------------------------------------- End  10-01-2023 ------------
