USE [StudentInfo]
GO
ALTER ROLE [db_ddladmin] ADD MEMBER [sqlreport]
GO
ALTER ROLE [db_datareader] ADD MEMBER [sqlreport]
GO
ALTER ROLE [db_datawriter] ADD MEMBER [sqlreport]
GO
/****** Object:  Table [dbo].[links]    Script Date: 11/06/2026 23:07:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[links](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[menu] [varchar](100) NULL,
	[parent_id] [int] NULL,
	[url] [varchar](256) NULL,
	[status] [int] NULL,
 CONSTRAINT [PK_links] PRIMARY KEY CLUSTERED 
(
	[id] 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].[tblDesign]    Script Date: 11/06/2026 23:07:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblDesign](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[txtHeader] [nvarchar](500) NULL,
	[txtFooter] [nvarchar](500) NULL,
	[Logo] [nvarchar](500) NULL,
 CONSTRAINT [PK_tblDesign] PRIMARY KEY CLUSTERED 
(
	[id] 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].[users]    Script Date: 11/06/2026 23:07:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET IDENTITY_INSERT [dbo].[links] ON 

INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (1, N'Application', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (2, N'Sample 1', 1, N'https://maintainem-dev.azurewebsites.net/', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (3, N'Sample 1', 1, N'https://trackem.com.au/', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (4, N'Attendance', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (5, N'ATT001 Overall College Attendance Summary Report', 4, N'http://gb08/reports/report/Attendance/ATT001_Overall%20College%20Attendance%20Summary', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (6, N'One Grade', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (7, N'OGD001 Predicted Grade Report', 6, N'http://gb08/reports/report/One%20Grade%20-%20Predicted%20Grades/OGD001_Predicted%20Grades', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (8, N'ATT002 Overall College Attendance Summary Comparisons', 4, N'http://gb08/reports/report/Attendance/ATT002_Overall%20College%20Attendance%20Comparison%20Summary', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (9, N'College Performance (QAR)', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (10, N'Enrolments', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (11, N'Students', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (12, N'Funding', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (13, N'Progression & Destination', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (14, N'CPR001 College Performance Report (QAR)', 9, N'http://gb08/reports/report/College%20Performance/CPFR001_CollegePerformanceReport', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (15, N'STD001 College Student Profile', 11, N'http://gb08/reports/report/Students/STD001_College%20Student%20Profile', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (16, N'College Systems', 0, NULL, 0)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (17, N'OneGrade', 16, N'http://gb08/OneGradePlus/', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (18, N'ProMonitor', 16, N'http://gb08/ProMonitor/', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (19, N'Quality and Standards', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (20, N'QAS001 Curriculum and Quality Performance Report - Attendance', 19, N'http://gb08/reports/report/Quality%20and%20Standards/QAS001_Curriculum%20and%20Quality%20Performance%20Report%20-%20Attendance', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (21, N'QAS002 Curriculum and Quality Performance Report - Progress', 19, N'http://gb08/reports/report/Quality%20and%20Standards/QAS002_Curriculum%20and%20Quality%20Performance%20Report%20-%20Progress', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (22, N'QAS003 Curriculum and Quality Performance Report - In-Year Retention', 19, N'http://gb08/reports/report/Quality%20and%20Standards/QAS003_Curriculum%20and%20Quality%20Performance%20Report%20-%20In-Year%20Retention', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (23, N'QAS004 Curriculum and Quality Performance Report - End Of Year Retention', 19, N'http://gb08/reports/report/Quality%20and%20Standards/QAS004_Curriculum%20and%20Quality%20Performance%20Report%20-%20End%20Year%20Retention', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (24, N'CPR002 College Performance Report and National Rates', 9, N'http://gb08/reports/report/College%20Performance/CPFR002_College%20Performance%20Report%20and%20National%20Rates', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (25, N'STD002 Barrier to Learning Gap Analysis', 11, N'http://gb08/reports/report/Students/STD002_Barrier%20to%20Learning%20Gap%20Analysis', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (26, N'Exams', 0, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (27, N'EXM001 GCSE Exams Desk Cards', 26, N'http://gb08/reports/report/Exams/EXM001_Exams%20Desk%20Cards', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (28, N'EXM002 Exams Room Allocation List', 26, N'http://gb08/reports/report/Exams/EXM002_Exams%20Room%20Allocation%20List', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (29, N'EXM003 Exams Invigilation List By Staff', 26, N'http://gb08/reports/report/Exams/EXM003_Exams%20Invigilation%20List%20By%20Staff', 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (30, N'Students Parent Mail ', 11, NULL, 1)
INSERT [dbo].[links] ([id], [menu], [parent_id], [url], [status]) VALUES (31, N'STD003 Student Parent Mailing List', 30, N'http://gb08/Reports/report/Students/STD003_Student%20Parent%20Mail', 1)
SET IDENTITY_INSERT [dbo].[links] OFF
GO
SET IDENTITY_INSERT [dbo].[tblDesign] ON 

INSERT [dbo].[tblDesign] ([id], [txtHeader], [txtFooter], [Logo]) VALUES (1, N'College Information Portal', N'Powered by: BAE (Management & BI) Consulting Ltd', N'images/Logo.jpg')
SET IDENTITY_INSERT [dbo].[tblDesign] OFF
GO
ALTER TABLE [dbo].[links] ADD  CONSTRAINT [DF__links__menu__36B12243]  DEFAULT (NULL) FOR [menu]
GO
ALTER TABLE [dbo].[links] ADD  CONSTRAINT [DF__links__parent_id__37A5467C]  DEFAULT ((0)) FOR [parent_id]
GO
ALTER TABLE [dbo].[links] ADD  CONSTRAINT [DF__links__url__38996AB5]  DEFAULT (NULL) FOR [url]
GO
ALTER TABLE [dbo].[links] ADD  CONSTRAINT [DF__links__status__398D8EEE]  DEFAULT ('1') FOR [status]
GO
