Y2S1-Database_Design/SQL/individual_inserts/14 - MediaEntry.Table.sql

23 lines
9.2 KiB
MySQL
Raw Permalink Normal View History

2020-06-07 21:29:59 +00:00
<EFBFBD><EFBFBD>USE [MediaLibrary]
GO
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