DELETE dbo.MediaInfo
GO
DELETE dbo.MediaInfoFormat




-- GENERAL
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format',0,1)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format profile',0,2)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Codec ID',0,3)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('File size',0,4)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Duration',0,5)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Overall bit rate',0,6)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Writing application',0,7)
GO
-- VIDEO
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format',1,1)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format/Info',1,2)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format profile',1,3)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format settings CABAC',1,4)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format settings, ReFrames',1,5)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Codec ID',1,6)

INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Codec ID/Info',1,7)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Duration',1,8)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Bit rate',1,9)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Width',1,10)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Height',1,11)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Display aspect ratio',1,12)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Frame rate mode',1,13)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Frame rate',1,14)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Color space',1,15)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Chroma subsampling',1,16)


INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Bit depth',1,17)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Scan type',1,18)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Bits/(Pixel*Frame)',1,19)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Stream size',1,20)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Writing library',1,21)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Encoding settings',1,22)

GO

-- AUDIO
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format',2,1)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format/Info',2,2)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format profile',2,3)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Codec ID',2,4)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Duration',2,5)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Bit rate mode',2,6)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Bit rate',2,7)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Channel(s)',2,8)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Channel positions',2,9)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Sampling rate',2,10)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Compression mode',2,11)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Delay relative to video',2,12)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Stream size',2,13)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Language',2,14)

GO

-- IMAGE
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Format',3,1)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Width',3,2)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Height',3,3)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Color space',3,4)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Chroma subsampling',3,5)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Bit depth',3,6)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Compression mode',3,7)
INSERT dbo.MediaInfo (Name,MediaInfoType,FieldType) VALUES('Stream size',3,8)