USE [Elyse_DB]
GO
/****** Object:  Table [user_restr].[role_list]    Script Date: Sat 05-09-2026 7:01:54 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [user_restr].[role_list](
	[role_name] [nvarchar](50) NOT NULL,
	[role_description] [nvarchar](max) NULL,
 CONSTRAINT [PK_role_list] PRIMARY KEY CLUSTERED 
(
	[role_name] 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] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [user_restr].[role_list] ([role_name], [role_description]) VALUES (N'Configurator', N'Creates metadata lists.')
INSERT [user_restr].[role_list] ([role_name], [role_description]) VALUES (N'Controller', N'Assigns metadata.')
INSERT [user_restr].[role_list] ([role_name], [role_description]) VALUES (N'Editor', N'Adds files, tags files.')
INSERT [user_restr].[role_list] ([role_name], [role_description]) VALUES (N'Reader', N'Reads data.  Can create their own personal tag browsing tree.')
INSERT [user_restr].[role_list] ([role_name], [role_description]) VALUES (N'Reviewer', N'Reviews documents for an editor.')
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This table lists the different roles within the database that can be assigned to users.  These roles parallel the application roles. 

COPYRIGHT NOTICE
This database schema and stored procedures are protected by copyright.
Copyright.  Silkwood Software Pty. Ltd. 2023
' , @level0type=N'SCHEMA',@level0name=N'user_restr', @level1type=N'TABLE',@level1name=N'role_list'
GO
