mirror of
https://github.com/Dictionarry-Hub/trash-pcd.git
synced 2026-05-03 10:54:16 +02:00
Seraphys
924 lines
42 KiB
SQL
924 lines
42 KiB
SQL
-- @operation: export
|
|
-- @entity: batch
|
|
-- @name: Update Multi VF HD Remux
|
|
-- @exportedAt: 2026-04-18T22:32:19.438Z
|
|
-- @opIds: 6757, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6781, 6782, 6783, 6784, 6785, 6786, 6787, 6788, 6789, 6790, 6791, 6792, 6793, 6794, 6795, 6796, 6797, 6798, 6799, 6800, 6801, 6802, 6803, 6804, 6805, 6806, 6807, 6808, 6809, 6810, 6811, 6812, 6813, 6814, 6815, 6816, 6817, 6818, 6819, 6820, 6821, 6822, 6823, 6824, 6825, 6826, 6827, 6828, 6829, 6830, 6831, 6832, 6833, 6834, 6835
|
|
|
|
-- --- BEGIN op 6757 ( create quality_profile "[French MULTi.VF] HD Remux" )
|
|
insert into "quality_profiles" ("name", "description", "upgrades_allowed", "minimum_custom_format_score", "upgrade_until_score", "upgrade_score_increment") values ('[French MULTi.VF] HD Remux', 'French Quality Profile that covers:
|
|
- WEBDL: 1080p
|
|
- Bluray 1080p
|
|
- Remux: 1080p', 1, 0, 0, 1);
|
|
|
|
insert into "tags" ("name") values ('French') on conflict ("name") do nothing;
|
|
|
|
INSERT INTO quality_profile_tags (quality_profile_name, tag_name) VALUES ('[French MULTi.VF] HD Remux', 'French');
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Remux-1080p', NULL, 0, 1, 1);
|
|
|
|
INSERT INTO quality_groups (quality_profile_name, name) VALUES ('[French MULTi.VF] HD Remux', 'Bluray|WEB 1080p');
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'Bluray|WEB 1080p', 'Bluray-1080p', 0);
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'Bluray|WEB 1080p', 'WEBRip-1080p', 1);
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'Bluray|WEB 1080p', 'WEBDL-1080p', 2);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', NULL, 'Bluray|WEB 1080p', 1, 1, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Raw-HD', NULL, 2, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'BR-DISK', NULL, 3, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Remux-2160p', NULL, 4, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Bluray-2160p', NULL, 5, 0, 0);
|
|
|
|
INSERT INTO quality_groups (quality_profile_name, name) VALUES ('[French MULTi.VF] HD Remux', 'WEB 2160p');
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'WEB 2160p', 'WEBRip-2160p', 0);
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'WEB 2160p', 'WEBDL-2160p', 1);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', NULL, 'WEB 2160p', 6, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'HDTV-2160p', NULL, 7, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'HDTV-1080p', NULL, 8, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Bluray-720p', NULL, 9, 0, 0);
|
|
|
|
INSERT INTO quality_groups (quality_profile_name, name) VALUES ('[French MULTi.VF] HD Remux', 'WEB 720p');
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'WEB 720p', 'WEBRip-720p', 0);
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'WEB 720p', 'WEBDL-720p', 1);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', NULL, 'WEB 720p', 10, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'HDTV-720p', NULL, 11, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Bluray-576p', NULL, 12, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Bluray-480p', NULL, 13, 0, 0);
|
|
|
|
INSERT INTO quality_groups (quality_profile_name, name) VALUES ('[French MULTi.VF] HD Remux', 'WEB 480p');
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'WEB 480p', 'WEBRip-480p', 0);
|
|
|
|
INSERT INTO quality_group_members (quality_profile_name, quality_group_name, quality_name, position) VALUES ('[French MULTi.VF] HD Remux', 'WEB 480p', 'WEBDL-480p', 1);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', NULL, 'WEB 480p', 14, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'DVD-R', NULL, 15, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'DVD', NULL, 16, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'SDTV', NULL, 17, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'DVDSCR', NULL, 18, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'REGIONAL', NULL, 19, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'TELECINE', NULL, 20, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'TELESYNC', NULL, 21, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'CAM', NULL, 22, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'WORKPRINT', NULL, 23, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'Unknown', NULL, 24, 0, 0);
|
|
|
|
INSERT INTO quality_profile_qualities (quality_profile_name, quality_name, quality_group_name, position, enabled, upgrade_until) VALUES ('[French MULTi.VF] HD Remux', 'HDTV-480p', NULL, 25, 0, 0);
|
|
-- --- END op 6757
|
|
|
|
-- --- BEGIN op 6758 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
update "quality_profiles" set "upgrade_until_score" = 10000 where "name" = '[French MULTi.VF] HD Remux' and "upgrade_until_score" = 0;
|
|
-- --- END op 6758
|
|
|
|
-- --- BEGIN op 6759 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', '3D', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = '3D'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6759
|
|
|
|
-- --- BEGIN op 6760 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'AAC', 'radarr', 1000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'AAC'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6760
|
|
|
|
-- --- BEGIN op 6761 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'AMZN', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'AMZN'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6761
|
|
|
|
-- --- BEGIN op 6762 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'ATMOS (undefined)', 'radarr', 3000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'ATMOS (undefined)'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6762
|
|
|
|
-- --- BEGIN op 6763 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'ATV', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'ATV'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6763
|
|
|
|
-- --- BEGIN op 6764 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'ATVP', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'ATVP'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6764
|
|
|
|
-- --- BEGIN op 6765 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'AV1', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'AV1'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6765
|
|
|
|
-- --- BEGIN op 6766 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'BCORE', 'radarr', 15
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'BCORE'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6766
|
|
|
|
-- --- BEGIN op 6767 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'BR-DISK', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'BR-DISK'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6767
|
|
|
|
-- --- BEGIN op 6768 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'CRiT', 'radarr', 20
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'CRiT'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6768
|
|
|
|
-- --- BEGIN op 6769 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DD', 'radarr', 750
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DD'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6769
|
|
|
|
-- --- BEGIN op 6770 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DD+', 'radarr', 1750
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DD+'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6770
|
|
|
|
-- --- BEGIN op 6771 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DD+ ATMOS', 'radarr', 3000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DD+ ATMOS'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6771
|
|
|
|
-- --- BEGIN op 6772 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DSNP', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DSNP'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6772
|
|
|
|
-- --- BEGIN op 6773 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DTS', 'radarr', 1250
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DTS'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6773
|
|
|
|
-- --- BEGIN op 6774 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DTS X', 'radarr', 4500
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DTS X'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6774
|
|
|
|
-- --- BEGIN op 6775 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DTS-ES', 'radarr', 1500
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DTS-ES'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6775
|
|
|
|
-- --- BEGIN op 6776 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DTS-HD HRA', 'radarr', 2000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DTS-HD HRA'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6776
|
|
|
|
-- --- BEGIN op 6777 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'DTS-HD MA', 'radarr', 2500
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'DTS-HD MA'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6777
|
|
|
|
-- --- BEGIN op 6778 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Extras', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Extras'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6778
|
|
|
|
-- --- BEGIN op 6779 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'FLAC', 'radarr', 2250
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'FLAC'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6779
|
|
|
|
-- --- BEGIN op 6780 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'FR LQ', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'FR LQ'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6780
|
|
|
|
-- --- BEGIN op 6781 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'FR Remux Tier 01', 'radarr', 1950
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'FR Remux Tier 01'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6781
|
|
|
|
-- --- BEGIN op 6782 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'FR Remux Tier 02', 'radarr', 1900
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'FR Remux Tier 02'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6782
|
|
|
|
-- --- BEGIN op 6783 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'FR Scene Groups', 'radarr', 1500
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'FR Scene Groups'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6783
|
|
|
|
-- --- BEGIN op 6784 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'FR WEB Tier 01', 'radarr', 1700
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'FR WEB Tier 01'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6784
|
|
|
|
-- --- BEGIN op 6785 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'FR WEB Tier 02', 'radarr', 1650
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'FR WEB Tier 02'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6785
|
|
|
|
-- --- BEGIN op 6786 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'HBO', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'HBO'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6786
|
|
|
|
-- --- BEGIN op 6787 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'HMAX', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'HMAX'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6787
|
|
|
|
-- --- BEGIN op 6788 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Hulu', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Hulu'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6788
|
|
|
|
-- --- BEGIN op 6789 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'LQ', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'LQ'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6789
|
|
|
|
-- --- BEGIN op 6790 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'LQ (Release Title)', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'LQ (Release Title)'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6790
|
|
|
|
-- --- BEGIN op 6791 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Language: Not French', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Language: Not French'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6791
|
|
|
|
-- --- BEGIN op 6792 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Language: Not Original', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Language: Not Original'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6792
|
|
|
|
-- --- BEGIN op 6793 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Language: Original + French', 'radarr', 500
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Language: Original + French'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6793
|
|
|
|
-- --- BEGIN op 6794 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'MA', 'radarr', 20
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'MA'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6794
|
|
|
|
-- --- BEGIN op 6795 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'MAX', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'MAX'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6795
|
|
|
|
-- --- BEGIN op 6796 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'MULTi', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'MULTi'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6796
|
|
|
|
-- --- BEGIN op 6797 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'NF', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'NF'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6797
|
|
|
|
-- --- BEGIN op 6798 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'PCM', 'radarr', 2250
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'PCM'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6798
|
|
|
|
-- --- BEGIN op 6799 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'PCOK', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'PCOK'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6799
|
|
|
|
-- --- BEGIN op 6800 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'PLAY', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'PLAY'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6800
|
|
|
|
-- --- BEGIN op 6801 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'PMTP', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'PMTP'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6801
|
|
|
|
-- --- BEGIN op 6802 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'ROKU', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'ROKU'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6802
|
|
|
|
-- --- BEGIN op 6803 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Remux Tier 01', 'radarr', 1950
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Remux Tier 01'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6803
|
|
|
|
-- --- BEGIN op 6804 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Remux Tier 02', 'radarr', 1900
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Remux Tier 02'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6804
|
|
|
|
-- --- BEGIN op 6805 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Remux Tier 03', 'radarr', 1850
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Remux Tier 03'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6805
|
|
|
|
-- --- BEGIN op 6806 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Repack/Proper', 'radarr', 5
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Repack/Proper'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6806
|
|
|
|
-- --- BEGIN op 6807 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Repack2', 'radarr', 6
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Repack2'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6807
|
|
|
|
-- --- BEGIN op 6808 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Repack3', 'radarr', 7
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Repack3'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6808
|
|
|
|
-- --- BEGIN op 6809 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'STAN', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'STAN'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6809
|
|
|
|
-- --- BEGIN op 6810 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Sing-Along Versions', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Sing-Along Versions'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6810
|
|
|
|
-- --- BEGIN op 6811 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'TrueHD', 'radarr', 2750
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'TrueHD'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6811
|
|
|
|
-- --- BEGIN op 6812 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'TrueHD ATMOS', 'radarr', 5000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'TrueHD ATMOS'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6812
|
|
|
|
-- --- BEGIN op 6813 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'Upscaled', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Upscaled'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6813
|
|
|
|
-- --- BEGIN op 6814 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VF2', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VF2'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6814
|
|
|
|
-- --- BEGIN op 6815 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VFB', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VFB'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6815
|
|
|
|
-- --- BEGIN op 6816 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VFF', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VFF'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6816
|
|
|
|
-- --- BEGIN op 6817 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VFI', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VFI'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6817
|
|
|
|
-- --- BEGIN op 6818 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VFQ', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VFQ'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6818
|
|
|
|
-- --- BEGIN op 6819 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VOF', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VOF'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6819
|
|
|
|
-- --- BEGIN op 6820 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VOQ', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VOQ'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6820
|
|
|
|
-- --- BEGIN op 6821 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VOSTRF', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VOSTRF'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6821
|
|
|
|
-- --- BEGIN op 6822 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'VQ', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'VQ'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6822
|
|
|
|
-- --- BEGIN op 6823 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'WEB Tier 01', 'radarr', 1700
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'WEB Tier 01'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6823
|
|
|
|
-- --- BEGIN op 6824 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'WEB Tier 02', 'radarr', 1650
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'WEB Tier 02'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6824
|
|
|
|
-- --- BEGIN op 6825 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'WEB Tier 03', 'radarr', 1600
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'WEB Tier 03'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6825
|
|
|
|
-- --- BEGIN op 6826 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'iT', 'radarr', 0
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'iT'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6826
|
|
|
|
-- --- BEGIN op 6827 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
|
|
SELECT '[French MULTi.VF] HD Remux', 'x265 (HD)', 'radarr', -10000
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'x265 (HD)'
|
|
AND arr_type = 'radarr'
|
|
);
|
|
-- --- END op 6827
|
|
|
|
-- --- BEGIN op 6828 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
UPDATE quality_profile_custom_formats
|
|
SET score = -10000
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Language: Not French'
|
|
AND arr_type = 'radarr'
|
|
AND score = 0;
|
|
-- --- END op 6828
|
|
|
|
-- --- BEGIN op 6829 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
UPDATE quality_profile_custom_formats
|
|
SET score = 0
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Language: Not Original'
|
|
AND arr_type = 'radarr'
|
|
AND score = -10000;
|
|
-- --- END op 6829
|
|
|
|
-- --- BEGIN op 6830 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
DELETE FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Remux Tier 01'
|
|
AND arr_type = 'radarr'
|
|
AND score = 1950;
|
|
-- --- END op 6830
|
|
|
|
-- --- BEGIN op 6831 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
DELETE FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Remux Tier 02'
|
|
AND arr_type = 'radarr'
|
|
AND score = 1900;
|
|
-- --- END op 6831
|
|
|
|
-- --- BEGIN op 6832 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
DELETE FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'Remux Tier 03'
|
|
AND arr_type = 'radarr'
|
|
AND score = 1850;
|
|
-- --- END op 6832
|
|
|
|
-- --- BEGIN op 6833 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
DELETE FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'WEB Tier 01'
|
|
AND arr_type = 'radarr'
|
|
AND score = 1700;
|
|
-- --- END op 6833
|
|
|
|
-- --- BEGIN op 6834 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
DELETE FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'WEB Tier 02'
|
|
AND arr_type = 'radarr'
|
|
AND score = 1650;
|
|
-- --- END op 6834
|
|
|
|
-- --- BEGIN op 6835 ( update quality_profile "[French MULTi.VF] HD Remux" )
|
|
DELETE FROM quality_profile_custom_formats
|
|
WHERE quality_profile_name = '[French MULTi.VF] HD Remux'
|
|
AND custom_format_name = 'WEB Tier 03'
|
|
AND arr_type = 'radarr'
|
|
AND score = 1600;
|
|
-- --- END op 6835
|