StevenJW-University/Y2S1-Database_Design
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
master
Y2S1-Database_Design/SQL/insert_generated.sql
StevenJW c0d3f8b07a Upload project.
2020-06-07 22:29:59 +01:00

328 lines
72 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
SET IDENTITY_INSERT [dbo].[Users] ON
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (1, N'WickedWorm', 8025, N'I am the social media director of WB. I post new WB content when released.')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (2, N'NailVista', 2407, N'I post jokes on the internet.')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (3, N'ExtremeRefined', 2641, N'I post comedy videos from my own bedroom.')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (4, N'KnowGem', 2030, N'Solo music artist focusing in rock')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (5, N'EmergeReal', 6343, N'Owner of site. If you need help feel free to ask me :)')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (6, N'ArmWhoa', 2460, N'Look out for new releases coming soon!')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (7, N'IcedTeaDramatic', 9231, N'I am the artistic director of WB, I post stuff for upcoming projects.')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (8, N'WisBerserk56', 466, NULL)
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (9, N'Play4Ask', -2357, N'I post my thoughts on the internet.')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (10, N'FeatTiffin', 54, N'I like to view good media.')
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (11, N'Butter4Real', 4, NULL)
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (12, N'Stickyundefined', -6, NULL)
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (13, N'KickerOne', -145, NULL)
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (14, N'ImPrivate', 0, NULL)
INSERT [dbo].[Users] ([UserID], [UserName], [LikeCount], [UserDescription]) VALUES (15, N'OMGTHE1', -2, NULL)
SET IDENTITY_INSERT [dbo].[Users] OFF
SET IDENTITY_INSERT [dbo].[RoleAllocation] ON
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (1, 1, 2)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (2, 1, 3)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (3, 2, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (4, 3, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (5, 3, 2)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (6, 3, 3)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (7, 4, 2)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (8, 4, 3)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (9, 5, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (10, 5, 2)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (11, 5, 3)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (12, 5, 4)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (13, 5, 5)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (14, 5, 6)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (15, 6, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (16, 6, 3)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (17, 7, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (18, 7, 2)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (19, 7, 3)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (20, 7, 6)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (21, 8, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (22, 10, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (23, 14, 1)
INSERT [dbo].[RoleAllocation] ([RoleAllocationID], [UserID], [RoleID]) VALUES (24, 15, 1)
SET IDENTITY_INSERT [dbo].[RoleAllocation] OFF
SET IDENTITY_INSERT [dbo].[ProfilePicture] ON
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (1, 1, N'flower.jpeg', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (2, 2, N'car.jpeg', 550, 550)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (3, 3, N'user_pfp.jpeg', 250, 300)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (4, 4, N'default.png', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (5, 5, N'default.png', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (6, 6, N'default.png', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (7, 7, N'new_profile.jpeg', 1000, 1000)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (8, 8, N'm.jpeg', 505, 505)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (9, 9, N'default.png', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (10, 10, N'flowers.jpeg', 450, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (11, 11, N'default.png', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (12, 12, N'kb_.jpeg', 300, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (13, 13, N'default.png', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (14, 14, N'default.png', 500, 500)
INSERT [dbo].[ProfilePicture] ([PictureID], [UserID], [PictureFileName], [Height], [Width]) VALUES (15, 15, N'me_irl.jpeg', 1200, 1200)
SET IDENTITY_INSERT [dbo].[ProfilePicture] OFF
SET IDENTITY_INSERT [dbo].[Category] ON
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (1, N'Comedy')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (2, N'Education')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (3, N'Entertainment')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (4, N'Film')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (5, N'Animation')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (6, N'Show')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (7, N'Gaming')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (8, N'News')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (9, N'Vlogs/Blogs')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (10, N'Technology')
INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (11, N'Sport')
SET IDENTITY_INSERT [dbo].[Category] OFF
SET IDENTITY_INSERT [dbo].[Production] ON
INSERT [dbo].[Production] ([ProductionID], [ProductionName]) VALUES (1, N'Warner Bros')
INSERT [dbo].[Production] ([ProductionID], [ProductionName]) VALUES (2, N'Dreamworks')
INSERT [dbo].[Production] ([ProductionID], [ProductionName]) VALUES (3, N'Disney')
SET IDENTITY_INSERT [dbo].[Production] OFF
SET IDENTITY_INSERT [dbo].[MediaEntry] ON
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (1, 9, 2, NULL, N'Holiday snaps! :)', N'Loving life rn!', CAST(N'2018-09-09T08:23:00.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (2, 4, 1, 1, N'Oliver!', N'After being sold to a mortician, young orphan Oliver Twist runs away and meets a group of boys trained to be pickpockets by an elderly mentor.', CAST(N'2018-09-09T10:34:21.000' AS DateTime), 1)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (3, 1, 11, NULL, N'Best prank EVER!', N'She should have seen it coming! haha', CAST(N'2018-09-09T12:04:58.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (4, 4, 8, NULL, N'The Howling Walkway', N'From my newest album, enjoy~', CAST(N'2018-09-09T16:02:51.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (5, 8, 9, 1, N'Brexit Vote Uncertain', N'UK seems to not know whether brexit will happen at all...', CAST(N'2018-09-10T02:33:13.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (6, 1, 2, NULL, N'Top Gear best moments!', N'Watch these three guys rant and rave for 20 minutes!!!!', CAST(N'2018-09-10T03:52:01.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (7, 3, 3, NULL, N'Fake SD Card Scam!', N'Can you believe theyre selling this?!?!', CAST(N'2018-09-10T06:00:04.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (8, 1, 2, NULL, N'10 WORST Christmas Presents EVER!', N'Check out some of these horrible gifts...', CAST(N'2018-09-10T09:29:40.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (9, 2, 5, 3, N'Popcorn Recipies', N'Some of my fav popcorn food :)', CAST(N'2018-09-10T12:52:00.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (10, 1, 8, NULL, N'Ready Meal Taste Test', N'Yeah these arent good...', CAST(N'2018-09-10T20:01:59.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (11, 6, 1, 1, N'Friends: Episode 16', N'Watch Friends HERE!', CAST(N'2018-09-10T23:34:02.000' AS DateTime), 1)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (12, 3, 6, NULL, N'Deconstructing Nature', N'EDM album :3', CAST(N'2018-09-11T09:29:22.000' AS DateTime), 1)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (13, 3, 7, NULL, N'Upcoming projects :eyes:', N'Just a teaser for the new film', CAST(N'2018-09-11T10:00:52.000' AS DateTime), 1)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (14, 3, 7, NULL, N'Upcoming projects PART 2', N'Another teaser, why not :P', CAST(N'2018-09-11T10:40:23.000' AS DateTime), 1)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (15, 9, 12, NULL, N'The world is amazing.', N'So nice.', CAST(N'2018-09-11T14:38:32.000' AS DateTime), 0)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (16, 6, 5, 2, N'Cars Miniseries', N'Watch miniseries here', CAST(N'2018-09-11T17:52:15.000' AS DateTime), 1)
INSERT [dbo].[MediaEntry] ([EntryID], [CategoryID], [UserID], [ProductionID], [Title], [EntryDescription], [UploadDate], [Premium]) VALUES (17, 6, 1, 1, N'Friends: Episode 17-20', N'Watch friends here', CAST(N'2018-09-11T19:25:50.000' AS DateTime), 1)
SET IDENTITY_INSERT [dbo].[MediaEntry] OFF
SET IDENTITY_INSERT [dbo].[ContentPage] ON
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (1, 1, 500, 20)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (2, 2, 20000, 500)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (3, 3, 1, 1)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (4, 4, 10, 0)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (5, 5, 150, 320)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (6, 6, 15, 3)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (7, 7, 120, 14)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (8, 8, 691, 142)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (9, 9, 351, 21)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (10, 10, 63, 12)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (11, 11, 898, 32)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (12, 12, 134, 6)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (13, 13, 1740, 348)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (14, 14, 1294, 211)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (15, 15, 248, 42)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (16, 16, 673, 84)
INSERT [dbo].[ContentPage] ([PageID], [EntryID], [Likes], [Dislikes]) VALUES (17, 17, 1482, 183)
SET IDENTITY_INSERT [dbo].[ContentPage] OFF
SET IDENTITY_INSERT [dbo].[Comment] ON
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (1, 1, 1, N'Love the pics! :)', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (2, 2, 1, N'thx', 1)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (3, 4, 1, N'Amazing', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (4, 2, 1, N'thanks :)', 3)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (5, 3, 2, N'A true classic.', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (6, 1, 2, N'Agree!', 5)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (7, 12, 5, N'idk about this one...', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (8, 10, 7, N'Interesting, thanks for the tip!', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (9, 5, 11, N'Such a good show!', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (10, 3, 12, N'Tunes!', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (11, 15, 17, N'Thanks for the upload!', NULL)
INSERT [dbo].[Comment] ([CommentID], [UserID], [PageID], [Content], [ParentComment]) VALUES (12, 3, 17, N'Ta!', NULL)
SET IDENTITY_INSERT [dbo].[Comment] OFF
SET IDENTITY_INSERT [dbo].[AiredTypes] ON
INSERT [dbo].[AiredTypes] ([AiredTypeID], [AiredType]) VALUES (1, N'TV Show')
INSERT [dbo].[AiredTypes] ([AiredTypeID], [AiredType]) VALUES (2, N'Movie')
INSERT [dbo].[AiredTypes] ([AiredTypeID], [AiredType]) VALUES (3, N'PSA')
INSERT [dbo].[AiredTypes] ([AiredTypeID], [AiredType]) VALUES (4, N'Play')
INSERT [dbo].[AiredTypes] ([AiredTypeID], [AiredType]) VALUES (5, N'Home Made')
INSERT [dbo].[AiredTypes] ([AiredTypeID], [AiredType]) VALUES (6, N'Premiere')
INSERT [dbo].[AiredTypes] ([AiredTypeID], [AiredType]) VALUES (7, N'Live Action')
SET IDENTITY_INSERT [dbo].[AiredTypes] OFF
SET IDENTITY_INSERT [dbo].[VideoFileTypes] ON
INSERT [dbo].[VideoFileTypes] ([FileTypeID], [TypeName], [TypeExtension], [Codec]) VALUES (1, N'WebM', N'.webm', N'VP8, VP9')
INSERT [dbo].[VideoFileTypes] ([FileTypeID], [TypeName], [TypeExtension], [Codec]) VALUES (2, N'Flash Video', N'.flv', N'H.264')
INSERT [dbo].[VideoFileTypes] ([FileTypeID], [TypeName], [TypeExtension], [Codec]) VALUES (3, N'AVI', N'.avi', N'AVI')
INSERT [dbo].[VideoFileTypes] ([FileTypeID], [TypeName], [TypeExtension], [Codec]) VALUES (4, N'QuickTime File Format', N'.mov', N'QuickTime')
INSERT [dbo].[VideoFileTypes] ([FileTypeID], [TypeName], [TypeExtension], [Codec]) VALUES (5, N'Windows Media Video', N'.wmv', N'ASF')
INSERT [dbo].[VideoFileTypes] ([FileTypeID], [TypeName], [TypeExtension], [Codec]) VALUES (6, N'MPEG-4', N'.mp4', N'MPEG-4')
SET IDENTITY_INSERT [dbo].[VideoFileTypes] OFF
SET IDENTITY_INSERT [dbo].[VideoEncode] ON
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (1, N'1080p60', 1920, 1080, 60)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (2, N'1080p30', 1920, 1080, 30)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (3, N'720p60', 1280, 720, 60)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (4, N'720p30', 1280, 720, 30)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (5, N'480p60', 848, 480, 60)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (6, N'480p30', 848, 480, 30)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (7, N'1440p30', 2560, 1440, 30)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (8, N'1440p60', 2560, 1440, 60)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (9, N'2160p30', 3840, 2160, 30)
INSERT [dbo].[VideoEncode] ([EncodeID], [EncodeName], [Width], [Height], [Framerate]) VALUES (10, N'2160p60', 3840, 2160, 60)
SET IDENTITY_INSERT [dbo].[VideoEncode] OFF
SET IDENTITY_INSERT [dbo].[VideoEntry] ON
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (1, 2, 6, 4, 2, N'oliver!', CAST(N'1968-09-27T00:00:00.000' AS DateTime), 9180)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (2, 5, 2, 1, 1, N'brexit_uncertain', CAST(N'2018-09-09T00:00:00.000' AS DateTime), 300)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (3, 6, 4, 3, 1, N'top_gear_best', CAST(N'2012-01-01T00:00:00.000' AS DateTime), 1204)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (4, 7, 1, 6, 3, N'sd_card', CAST(N'2018-09-01T00:00:00.000' AS DateTime), 513)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (5, 8, 2, 5, 5, N'worst_presents', CAST(N'2017-12-01T00:00:00.000' AS DateTime), 295)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (6, 9, 1, 3, 5, N'pop_reci', CAST(N'2018-04-09T00:00:00.000' AS DateTime), 196)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (7, 10, 2, 6, 5, N'ready_meal', CAST(N'2018-08-28T00:00:00.000' AS DateTime), 302)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (8, 11, 7, 6, 1, N'friends_s1_e16', CAST(N'1995-02-23T00:00:00.000' AS DateTime), 1440)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (9, 16, 9, 3, 1, N'Cars_mini_1', CAST(N'2017-12-04T00:00:00.000' AS DateTime), 740)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (10, 17, 7, 6, 1, N'friends_17', CAST(N'1995-02-23T00:00:00.000' AS DateTime), 1367)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (11, 17, 7, 6, 1, N'friends_18', CAST(N'1995-03-02T00:00:00.000' AS DateTime), 1485)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (12, 17, 7, 6, 1, N'friends_19', CAST(N'1995-03-09T00:00:00.000' AS DateTime), 1501)
INSERT [dbo].[VideoEntry] ([VideoID], [EntryID], [EncodeID], [FileTypeID], [AiredTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (13, 17, 7, 6, 1, N'friends_20', CAST(N'1995-04-06T00:00:00.000' AS DateTime), 1402)
SET IDENTITY_INSERT [dbo].[VideoEntry] OFF
SET IDENTITY_INSERT [dbo].[VideoPreview] ON
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (1, 1, 6, 4, N'oliver_trailer_1', CAST(N'1968-09-27T00:00:00.000' AS DateTime), 132)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (2, 1, 6, 4, N'oliver_trailer_2', CAST(N'1968-09-27T00:00:00.000' AS DateTime), 203)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (3, 1, 6, 4, N'oliver_trailer_3', CAST(N'1968-09-27T00:00:00.000' AS DateTime), 152)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (4, 1, 6, 4, N'oliver_trailer_4', CAST(N'1968-09-27T00:00:00.000' AS DateTime), 173)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (5, 6, 4, 3, N'top_gear_best_preview', CAST(N'2012-01-01T00:00:00.000' AS DateTime), 124)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (6, 11, 7, 6, N'friends_s1_e16_preview', CAST(N'1995-02-23T00:00:00.000' AS DateTime), 90)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (7, 16, 9, 3, N'Cars_mini_1_preview', CAST(N'2017-12-04T00:00:00.000' AS DateTime), 94)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (8, 17, 7, 6, N'friends_17_preview_1', CAST(N'1995-02-22T00:00:00.000' AS DateTime), 101)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (9, 17, 7, 6, N'friends_17_preview_2', CAST(N'1995-02-23T00:00:00.000' AS DateTime), 99)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (10, 17, 7, 6, N'friends_18_preview_1', CAST(N'1995-03-01T00:00:00.000' AS DateTime), 82)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (11, 17, 7, 6, N'friends_18_preview_2', CAST(N'1995-03-02T00:00:00.000' AS DateTime), 100)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (12, 17, 7, 6, N'friends_19_preview', CAST(N'1995-03-09T00:00:00.000' AS DateTime), 95)
INSERT [dbo].[VideoPreview] ([PreviewID], [VideoID], [EncodeID], [FileTypeID], [VideoFileName], [AiredOn], [Length]) VALUES (13, 17, 7, 6, N'friends_20_preview', CAST(N'1995-04-06T00:00:00.000' AS DateTime), 95)
SET IDENTITY_INSERT [dbo].[VideoPreview] OFF
SET IDENTITY_INSERT [dbo].[AudioGenre] ON
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (1, N'Blues')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (2, N'Country')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (3, N'Electronic')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (4, N'Folk')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (5, N'Hip Hop')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (6, N'Jazz')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (7, N'Pop')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (8, N'R%B')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (9, N'Rock')
SET IDENTITY_INSERT [dbo].[AudioGenre] OFF
SET IDENTITY_INSERT [dbo].[ReleaseType] ON
INSERT [dbo].[ReleaseType] ([ReleaseTypeID], [TypeName]) VALUES (1, N'Single')
INSERT [dbo].[ReleaseType] ([ReleaseTypeID], [TypeName]) VALUES (2, N'Album')
INSERT [dbo].[ReleaseType] ([ReleaseTypeID], [TypeName]) VALUES (3, N'EP')
INSERT [dbo].[ReleaseType] ([ReleaseTypeID], [TypeName]) VALUES (4, N'One off')
SET IDENTITY_INSERT [dbo].[ReleaseType] OFF
SET IDENTITY_INSERT [dbo].[AudioFileTypes] ON
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (1, N'Advanced Audio Coding', N'.aac')
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (2, N'Apple AIFF', N'.aiff')
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (3, N'Free Lossless Audio Codec', N'.flac')
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (4, N'MPEG-4 Audio', N'.m4a')
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (5, N'MPEG Layer III', N'.mp3')
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (6, N'Vorbis', N'.ogg')
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (7, N'Wave', N'.wav')
INSERT [dbo].[AudioFileTypes] ([FileTypeID], [TypeName], [TypeExtention]) VALUES (8, N'Windows Media Audio', N'.wma')
SET IDENTITY_INSERT [dbo].[AudioFileTypes] OFF
SET IDENTITY_INSERT [dbo].[AudioEntry] ON
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (1, 4, 7, 1, 213, 256, N'the_howling_walkway')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (2, 12, 5, 2, 78, 320, N'sunrise')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (3, 12, 5, 2, 241, 320, N'deconstructing_nature')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (4, 12, 5, 2, 116, 320, N'dream_field')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (5, 12, 5, 2, 180, 320, N'floating_through_a_frozen_atlantis')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (6, 12, 5, 2, 43, 320, N'interlude')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (7, 12, 5, 2, 205, 320, N'broadcast')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (8, 12, 5, 2, 335, 320, N'skyshifer_vip')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (9, 12, 5, 2, 161, 320, N'serotonin')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (10, 12, 5, 2, 232, 320, N'data_corruption_symphony')
INSERT [dbo].[AudioEntry] ([AudioID], [EntryID], [FileTypeID], [ReleaseTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (11, 12, 5, 2, 449, 320, N'cherry_blossoms_explode_across_the_dying_horizon')
SET IDENTITY_INSERT [dbo].[AudioEntry] OFF
SET IDENTITY_INSERT [dbo].[AudioGenreEntry] ON
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (1, 1, 9)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (2, 2, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (3, 3, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (4, 4, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (5, 5, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (6, 6, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (7, 7, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (8, 8, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (9, 9, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (10, 10, 3)
INSERT [dbo].[AudioGenreEntry] ([GenreEntryID], [AudioID], [GenreID]) VALUES (11, 11, 3)
SET IDENTITY_INSERT [dbo].[AudioGenreEntry] OFF
SET IDENTITY_INSERT [dbo].[AudioPreview] ON
INSERT [dbo].[AudioPreview] ([PreviewID], [AudioID], [FileTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (1, 1, 7, 28, 320, N'the_howling_walkway_1')
INSERT [dbo].[AudioPreview] ([PreviewID], [AudioID], [FileTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (2, 1, 2, 10, 320, N'the_howling_walkway_2')
INSERT [dbo].[AudioPreview] ([PreviewID], [AudioID], [FileTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (3, 1, 2, 20, 320, N'the_howling_walkway_3')
INSERT [dbo].[AudioPreview] ([PreviewID], [AudioID], [FileTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (4, 8, 3, 30, 1000, N'skyshifter_vip_1')
INSERT [dbo].[AudioPreview] ([PreviewID], [AudioID], [FileTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (5, 8, 3, 40, 1000, N'skyshifter_vip_2')
INSERT [dbo].[AudioPreview] ([PreviewID], [AudioID], [FileTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (6, 11, 3, 60, 1000, N'cherry_blossoms_explode_across_the_dying_horizon_1')
INSERT [dbo].[AudioPreview] ([PreviewID], [AudioID], [FileTypeID], [AudioLength], [BitRate], [AudioFileName]) VALUES (7, 11, 3, 30, 1000, N'cherry_blossoms_explode_across_the_dying_horizon_2')
SET IDENTITY_INSERT [dbo].[AudioPreview] OFF
SET IDENTITY_INSERT [dbo].[ImageFileTypes] ON
INSERT [dbo].[ImageFileTypes] ([FileTypeID], [FileTypeName], [FileTypeExtension]) VALUES (1, N'Joint Photographic Experts Group', N'.jpeg')
INSERT [dbo].[ImageFileTypes] ([FileTypeID], [FileTypeName], [FileTypeExtension]) VALUES (2, N'Joint Photographic Experts Group', N'.jpg')
INSERT [dbo].[ImageFileTypes] ([FileTypeID], [FileTypeName], [FileTypeExtension]) VALUES (3, N'Tagged Image File Format', N'.tiff')
INSERT [dbo].[ImageFileTypes] ([FileTypeID], [FileTypeName], [FileTypeExtension]) VALUES (4, N'Graphics Interchange File Format', N'.gif')
INSERT [dbo].[ImageFileTypes] ([FileTypeID], [FileTypeName], [FileTypeExtension]) VALUES (5, N'Windows Bitmap', N'.bmp')
INSERT [dbo].[ImageFileTypes] ([FileTypeID], [FileTypeName], [FileTypeExtension]) VALUES (6, N'Portable Network Graphics', N'.png')
SET IDENTITY_INSERT [dbo].[ImageFileTypes] OFF
SET IDENTITY_INSERT [dbo].[ImageEntry] ON
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (1, 1, 1, N'snap1', 500, 500)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (2, 1, 1, N'snap2', 500, 500)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (3, 1, 1, N'snap3', 500, 500)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (4, 1, 4, N'vid1', 500, 500)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (5, 3, 2, N'prank', 1280, 720)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (6, 13, 6, N'pic1', 4000, 4000)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (7, 13, 6, N'pic2', 4000, 4000)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (8, 13, 6, N'pic3', 4000, 4000)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (9, 13, 6, N'pic4', 4000, 4000)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (10, 13, 6, N'pic5', 4000, 4000)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (11, 13, 4, N'clip', 1920, 1080)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (12, 14, 4, N'clip2', 1920, 1080)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (13, 15, 3, N'world_pic', 4500, 3500)
INSERT [dbo].[ImageEntry] ([ImageID], [EntryID], [FileTypeID], [ImageFileName], [Height], [Width]) VALUES (14, 15, 3, N'world_pic2', 1000, 2000)
SET IDENTITY_INSERT [dbo].[ImageEntry] OFF
SET IDENTITY_INSERT [dbo].[Thumbnail] ON
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (1, 1, N'snaps.png', 1920, 1080)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (2, 2, N'oliver.png', 1920, 1080)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (3, 3, N'prank.png', 1000, 1000)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (4, 4, N'walkway.png', 2000, 2000)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (5, 5, N'brexit.png', 1500, 600)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (6, 6, N'top_.png', 750, 400)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (7, 7, N'fake.png', 1200, 1200)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (8, 8, N'worst.png', 1400, 1400)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (9, 9, N'popcorn.png', 1920, 1080)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (10, 10, N'meal.png', 1920, 1080)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (11, 11, N'friends16.png', 1920, 1200)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (12, 12, N'nat.png', 720, 720)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (13, 13, N'up.png', 4000, 4000)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (14, 14, N'up2.png', 4000, 4000)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (15, 15, N'amaze.png', 1500, 1500)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (16, 16, N'cars.png', 1280, 720)
INSERT [dbo].[Thumbnail] ([ThumbnailID], [EntryID], [ThumbnailFileName], [Height], [Width]) VALUES (17, 17, N'friends.png', 1920, 1200)
SET IDENTITY_INSERT [dbo].[Thumbnail] OFF
Reference in New Issue View Git Blame Copy Permalink