Files
dictionarry/ops/172.fix-banned-language-groups.sql
2026-06-02 22:49:28 -05:00

28 lines
1.0 KiB
SQL

-- @operation: export
-- @entity: batch
-- @name: Fix Banned Language Groups
-- @exportedAt: 2026-06-03T03:49:26.993Z
-- @opIds: 10912, 10913
-- --- BEGIN op 10912 ( update quality_profile "2160p Balanced" )
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
SELECT '2160p Balanced', 'Banned Language Groups', 'radarr', -999999
WHERE NOT EXISTS (
SELECT 1 FROM quality_profile_custom_formats
WHERE quality_profile_name = '2160p Balanced'
AND custom_format_name = 'Banned Language Groups'
AND arr_type = 'radarr'
);
-- --- END op 10912
-- --- BEGIN op 10913 ( update quality_profile "2160p Balanced" )
INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score)
SELECT '2160p Balanced', 'Banned Language Groups', 'sonarr', -999999
WHERE NOT EXISTS (
SELECT 1 FROM quality_profile_custom_formats
WHERE quality_profile_name = '2160p Balanced'
AND custom_format_name = 'Banned Language Groups'
AND arr_type = 'sonarr'
);
-- --- END op 10913