USE [StudentInfo] GO /****** Object: User [sqlreport] Script Date: 11/06/2026 23:07:35 ******/ CREATE USER [sqlreport] FOR LOGIN [sqlreport] WITH DEFAULT_SCHEMA=[dbo] 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 CREATE TABLE [dbo].[users]( [id] [int] IDENTITY(1,1) NOT NULL, [username] [varchar](100) NOT NULL, [password] [varchar](250) NOT NULL, CONSTRAINT [PK__users__3213E83FEAB56324] 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 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 SET IDENTITY_INSERT [dbo].[users] ON INSERT [dbo].[users] ([id], [username], [password]) VALUES (1, N'admin', N'123') SET IDENTITY_INSERT [dbo].[users] 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