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

21 lines
4.2 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].[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