Y2S1-Database_Design/SQL/individual_inserts/1 - Roles.Table.sql

12 lines
1.0 KiB
MySQL
Raw Permalink Normal View History

2020-06-07 21:29:59 +00:00
<EFBFBD><EFBFBD>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