· 2 years ago · Feb 20, 2023, 07:30 PM
1USE [NectarSSO]
2GO
3ALTER TABLE [dbo].[ReportGroups] DROP CONSTRAINT [FK_ReportGroups_Reports_ReportId]
4GO
5ALTER TABLE [dbo].[ReportGroups] DROP CONSTRAINT [FK_ReportGroups_Reports_ReportChildId]
6GO
7ALTER TABLE [dbo].[ConfigUserPrivileges] DROP CONSTRAINT [FK_ConfigUserPrivileges_Reports_ReportId]
8GO
9/****** Object: Table [dbo].[Reports] Script Date: 2/20/2023 11:01:53 AM ******/
10IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Reports]') AND type in (N'U'))
11DROP TABLE [dbo].[Reports]
12GO
13/****** Object: Table [dbo].[ReportGroups] Script Date: 2/20/2023 11:01:53 AM ******/
14IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ReportGroups]') AND type in (N'U'))
15DROP TABLE [dbo].[ReportGroups]
16GO
17/****** Object: Table [dbo].[ConfigUserPrivileges] Script Date: 2/20/2023 11:01:53 AM ******/
18IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConfigUserPrivileges]') AND type in (N'U'))
19DROP TABLE [dbo].[ConfigUserPrivileges]
20GO
21/****** Object: Table [dbo].[ConfigUserPrivileges] Script Date: 2/20/2023 11:01:53 AM ******/
22SET ANSI_NULLS ON
23GO
24SET QUOTED_IDENTIFIER ON
25GO
26CREATE TABLE [dbo].[ConfigUserPrivileges](
27 [UserName] [varchar](20) NOT NULL,
28 [ReportId] [int] NOT NULL,
29 [EnableView] [bit] NOT NULL,
30 [EnableEdit] [bit] NOT NULL,
31 CONSTRAINT [PK_ConfigUserPrivileges] PRIMARY KEY CLUSTERED
32(
33 [UserName] ASC,
34 [ReportId] ASC
35)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]
36) ON [PRIMARY]
37GO
38/****** Object: Table [dbo].[ReportGroups] Script Date: 2/20/2023 11:01:53 AM ******/
39SET ANSI_NULLS ON
40GO
41SET QUOTED_IDENTIFIER ON
42GO
43CREATE TABLE [dbo].[ReportGroups](
44 [ReportId] [int] NOT NULL,
45 [ReportChildId] [int] NOT NULL,
46 [Position] [int] NOT NULL,
47 CONSTRAINT [PK_ReportGroups] PRIMARY KEY CLUSTERED
48(
49 [ReportId] ASC,
50 [ReportChildId] ASC
51)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]
52) ON [PRIMARY]
53GO
54/****** Object: Table [dbo].[Reports] Script Date: 2/20/2023 11:01:53 AM ******/
55SET ANSI_NULLS ON
56GO
57SET QUOTED_IDENTIFIER ON
58GO
59CREATE TABLE [dbo].[Reports](
60 [ReportId] [int] IDENTITY(1,1) NOT NULL,
61 [ReportTypeId] [int] NOT NULL,
62 [Name] [varchar](25) NOT NULL,
63 [Description] [varchar](100) NOT NULL,
64 [Url] [varchar](30) NOT NULL,
65 [Image] [varchar](20) NOT NULL,
66 [StatusId] [int] NOT NULL,
67 CONSTRAINT [PK_Reports] PRIMARY KEY CLUSTERED
68(
69 [ReportId] ASC
70)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]
71) ON [PRIMARY]
72GO
73INSERT [dbo].[ConfigUserPrivileges] ([UserName], [ReportId], [EnableView], [EnableEdit]) VALUES (N'dev@mundonectar.com', 1, 1, 1)
74GO
75INSERT [dbo].[ConfigUserPrivileges] ([UserName], [ReportId], [EnableView], [EnableEdit]) VALUES (N'dev@mundonectar.com', 2, 1, 1)
76GO
77INSERT [dbo].[ConfigUserPrivileges] ([UserName], [ReportId], [EnableView], [EnableEdit]) VALUES (N'dev@mundonectar.com', 5, 1, 1)
78GO
79INSERT [dbo].[ReportGroups] ([ReportId], [ReportChildId], [Position]) VALUES (1, 2, 1)
80GO
81INSERT [dbo].[ReportGroups] ([ReportId], [ReportChildId], [Position]) VALUES (2, 5, 1)
82GO
83INSERT [dbo].[ReportGroups] ([ReportId], [ReportChildId], [Position]) VALUES (3, 4, 1)
84GO
85SET IDENTITY_INSERT [dbo].[Reports] ON
86GO
87INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (1, 1, N'Modulo 1', N'Modulo 1', N'', N'', 1)
88GO
89INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (2, 2, N'Sub modulo 1', N'Sub modulo 1', N'', N'', 1)
90GO
91INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (3, 1, N'Modulo 2', N'Modulo 2', N'', N'', 1)
92GO
93INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (4, 2, N'Sub modulo 2', N'Sub modulo 2', N'', N'', 1)
94GO
95INSERT [dbo].[Reports] ([ReportId], [ReportTypeId], [Name], [Description], [Url], [Image], [StatusId]) VALUES (5, 3, N'Aprobar sub 1', N'Aprobar sub 1', N'', N'', 1)
96GO
97SET IDENTITY_INSERT [dbo].[Reports] OFF
98GO
99ALTER TABLE [dbo].[ConfigUserPrivileges] WITH CHECK ADD CONSTRAINT [FK_ConfigUserPrivileges_Reports_ReportId] FOREIGN KEY([ReportId])
100REFERENCES [dbo].[Reports] ([ReportId])
101GO
102ALTER TABLE [dbo].[ConfigUserPrivileges] CHECK CONSTRAINT [FK_ConfigUserPrivileges_Reports_ReportId]
103GO
104ALTER TABLE [dbo].[ReportGroups] WITH CHECK ADD CONSTRAINT [FK_ReportGroups_Reports_ReportChildId] FOREIGN KEY([ReportChildId])
105REFERENCES [dbo].[Reports] ([ReportId])
106GO
107ALTER TABLE [dbo].[ReportGroups] CHECK CONSTRAINT [FK_ReportGroups_Reports_ReportChildId]
108GO
109ALTER TABLE [dbo].[ReportGroups] WITH CHECK ADD CONSTRAINT [FK_ReportGroups_Reports_ReportId] FOREIGN KEY([ReportId])
110REFERENCES [dbo].[Reports] ([ReportId])
111GO
112ALTER TABLE [dbo].[ReportGroups] CHECK CONSTRAINT [FK_ReportGroups_Reports_ReportId]
113GO
114