Y2S1-Database_Design/SQL/individual_inserts/21 - VideoEntry.Table.sql

19 lines
5.8 KiB
MySQL
Raw Permalink Normal View History

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