Y2S1-Database_Design/SQL/individual_inserts/1 - Roles.Table.sql
2020-06-07 22:29:59 +01:00

12 lines
1.0 KiB
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

USE [MediaLibrary]
GO
SET IDENTITY_INSERT [dbo].[Roles] ON
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (1, N'Premium')
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (2, N'VIP')
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (3, N'Uploader')
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (4, N'Administrator')
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (5, N'Moderator')
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (6, N'Content Janitor')
SET IDENTITY_INSERT [dbo].[Roles] OFF