DELETE dbo.MediaInfo
GO
DELETE dbo.MediaInfoFormat


SELECT * FROM dbo.MediaInfo

-- 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)



INSERT INTO ProcessAWS (FormatIdKey,[Status],CrDate,ProcessType)
SELECT FormatIDKey,0 AS STATUS,GETDATE() AS CrDate,30 AS ProcessType
FROM dbo.FORMAT A
LEFT JOIN dbo.Folder AS T3 ON A.FolderId = T3.Id	
LEFT JOIN dbo.Folder AS T2 ON T3.ParentId = T2.Id
LEFT JOIN dbo.Folder AS T1 ON T2.ParentId = T1.Id
WHERE 
	ISNULL(A.Deleted,0) = 0 AND FormatIDKey <> 16089
	AND (ISNULL(T3.Deleted,0) = 0 AND ISNULL(T2.Deleted,0) = 0 AND ISNULL(T1.Deleted,0) = 0)









	DELETE from ProcessAWS where ProcessType = 30 and status = 0
AND FormatIdKey in 
(
SELECT FormatIDKey
FROM dbo.FORMAT A
LEFT JOIN dbo.Folder AS T3 ON A.FolderId = T3.Id	
LEFT JOIN dbo.Folder AS T2 ON T3.ParentId = T2.Id
LEFT JOIN dbo.Folder AS T1 ON T2.ParentId = T1.Id
WHERE 
	ISNULL(A.Deleted,0) = 0 AND FormatIDKey <> 16089
	AND (ISNULL(T3.Deleted,0) = 0 AND ISNULL(T2.Deleted,0) = 0 AND ISNULL(T1.Deleted,0) = 0)
	AND a.FileFormatID IN ( SELECT FileFormatID FROM FileFormat WHERE FileTypeID IN (6, 7,8)))