USE [NectarSSO]
GO
ALTER TABLE [dbo].[ReportGroups] DROP CONSTRAINT [FK_ReportGroups_Reports_ReportId]
GO
ALTER TABLE [dbo].[ReportGroups] DROP CONSTRAINT [FK_ReportGroups_Reports_ReportChildId]
GO
ALTER TABLE [dbo].[ConfigUserPrivileges] DROP CONSTRAINT [FK_ConfigUserPrivileges_Reports_ReportId]
GO
/****** Object:  Table [dbo].[Reports]    Script Date: 2/20/2023 11:01:53 AM ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Reports]') AND TYPE IN (N'U'))
DROP TABLE [dbo].[Reports]
GO
/****** Object:  Table [dbo].[ReportGroups]    Script Date: 2/20/2023 11:01:53 AM ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ReportGroups]') AND TYPE IN (N'U'))
DROP TABLE [dbo].[ReportGroups]
GO
/****** Object:  Table [dbo].[ConfigUserPrivileges]    Script Date: 2/20/2023 11:01:53 AM ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConfigUserPrivileges]') AND TYPE IN (N'U'))
DROP TABLE [dbo].[ConfigUserPrivileges]
GO
/****** Object:  Table [dbo].[ConfigUserPrivileges]    Script Date: 2/20/2023 11:01:53 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ConfigUserPrivileges](
    [UserName] [VARCHAR](20) NOT NULL,
    [ReportId] [INT] NOT NULL,
    [EnableView] [bit] NOT NULL,
    [EnableEdit] [bit] NOT NULL,
 CONSTRAINT [PK_ConfigUserPrivileges] PRIMARY KEY CLUSTERED
(
    [UserName] ASC,
    [ReportId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ReportGroups]    Script Date: 2/20/2023 11:01:53 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ReportGroups](
    [ReportId] [INT] NOT NULL,
    [ReportChildId] [INT] NOT NULL,
    [POSITION] [INT] NOT NULL,
 CONSTRAINT [PK_ReportGroups] PRIMARY KEY CLUSTERED
(
    [ReportId] ASC,
    [ReportChildId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Reports]    Script Date: 2/20/2023 11:01:53 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Reports](
    [ReportId] [INT] IDENTITY(1,1) NOT NULL,
    [ReportTypeId] [INT] NOT NULL,
    [Name] [VARCHAR](25) NOT NULL,
    [Description] [VARCHAR](100) NOT NULL,
    [Url] [VARCHAR](30) NOT NULL,
    [Image] [VARCHAR](20) NOT NULL,
    [StatusId] [INT] NOT NULL,
 CONSTRAINT [PK_Reports] PRIMARY KEY CLUSTERED
(
    [ReportId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[ConfigUserPrivileges] ([UserName], [ReportId], [EnableView], [EnableEdit]) VALUES (N'[email protected]', 1, 1, 1)
GO
INSERT [dbo].[ConfigUserPrivileges] ([UserName], [ReportId], [EnableView], [EnableEdit]) VALUES (N'[email protected]', 2, 1, 1)
GO
INSERT [dbo].[ConfigUserPrivileges] ([UserName], [ReportId], [EnableView], [EnableEdit]) VALUES (N'[email protected]', 5, 1, 1)
GO
INSERT [dbo].[ReportGroups] ([ReportId], [ReportChildId], [POSITION]) VALUES (1, 2, 1)
GO
INSERT [dbo].[ReportGroups] ([ReportId], [ReportChildId], [POSITION]) VALUES (2, 5, 1)
GO
INSERT [dbo].[ReportGroups] ([ReportId], [ReportChildId], [POSITION]) VALUES (3, 4, 1)
GO
SET IDENTITY_INSERT [dbo].[Reports] ON
GO
INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (1, 1, N'Modulo 1', N'Modulo 1', N'', N'', 1)
GO
INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (2, 2, N'Sub modulo 1', N'Sub modulo 1', N'', N'', 1)
GO
INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (3, 1, N'Modulo 2', N'Modulo 2', N'', N'', 1)
GO
INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (4, 2, N'Sub modulo 2', N'Sub modulo 2', N'', N'', 1)
GO
INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (5, 3, N'Aprobar sub 1', N'Aprobar sub 1', N'', N'', 1)
GO
SET IDENTITY_INSERT [dbo].[Reports] OFF
GO
ALTER TABLE [dbo].[ConfigUserPrivileges]  WITH CHECK ADD  CONSTRAINT [FK_ConfigUserPrivileges_Reports_ReportId] FOREIGN KEY([ReportId])
REFERENCES [dbo].[Reports] ([ReportId])
GO
ALTER TABLE [dbo].[ConfigUserPrivileges] CHECK CONSTRAINT [FK_ConfigUserPrivileges_Reports_ReportId]
GO
ALTER TABLE [dbo].[ReportGroups]  WITH CHECK ADD  CONSTRAINT [FK_ReportGroups_Reports_ReportChildId] FOREIGN KEY([ReportChildId])
REFERENCES [dbo].[Reports] ([ReportId])
GO
ALTER TABLE [dbo].[ReportGroups] CHECK CONSTRAINT [FK_ReportGroups_Reports_ReportChildId]
GO
ALTER TABLE [dbo].[ReportGroups]  WITH CHECK ADD  CONSTRAINT [FK_ReportGroups_Reports_ReportId] FOREIGN KEY([ReportId])
REFERENCES [dbo].[Reports] ([ReportId])
GO
ALTER TABLE [dbo].[ReportGroups] CHECK CONSTRAINT [FK_ReportGroups_Reports_ReportId]
GO