-- @operation: export -- @entity: batch -- @name: 1080p Quality Score Refactor / Add HDTV Fallbacks -- @exportedAt: 2026-02-08T21:41:58.166Z -- @opIds: 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733 -- --- BEGIN op 644 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Bluray', 'radarr', 620000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Bluray' AND arr_type = 'radarr' ); -- --- END op 644 -- --- BEGIN op 645 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Bluray', 'sonarr', 620000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Bluray' AND arr_type = 'sonarr' ); -- --- END op 645 -- --- BEGIN op 646 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV', 'radarr', 340000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV' AND arr_type = 'radarr' ); -- --- END op 646 -- --- BEGIN op 647 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV', 'sonarr', 340000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV' AND arr_type = 'sonarr' ); -- --- END op 647 -- --- BEGIN op 648 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p WEB-DL', 'radarr', 640000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p WEB-DL' AND arr_type = 'radarr' ); -- --- END op 648 -- --- BEGIN op 649 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p WEB-DL', 'sonarr', 640000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p WEB-DL' AND arr_type = 'sonarr' ); -- --- END op 649 -- --- BEGIN op 650 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p WEBRip', 'radarr', 620000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p WEBRip' AND arr_type = 'radarr' ); -- --- END op 650 -- --- BEGIN op 651 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p WEBRip', 'sonarr', 620000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p WEBRip' AND arr_type = 'sonarr' ); -- --- END op 651 -- --- BEGIN op 652 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Bluray', 'radarr', 100000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Bluray' AND arr_type = 'radarr' ); -- --- END op 652 -- --- BEGIN op 653 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Bluray', 'sonarr', 100000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Bluray' AND arr_type = 'sonarr' ); -- --- END op 653 -- --- BEGIN op 654 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p WEB-DL', 'radarr', 80000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p WEB-DL' AND arr_type = 'radarr' ); -- --- END op 654 -- --- BEGIN op 655 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p WEB-DL', 'sonarr', 80000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p WEB-DL' AND arr_type = 'sonarr' ); -- --- END op 655 -- --- BEGIN op 656 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Bluray', 'radarr', 160000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Bluray' AND arr_type = 'radarr' ); -- --- END op 656 -- --- BEGIN op 657 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Bluray', 'sonarr', 160000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Bluray' AND arr_type = 'sonarr' ); -- --- END op 657 -- --- BEGIN op 658 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Bluray', 'radarr', 460000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Bluray' AND arr_type = 'radarr' ); -- --- END op 658 -- --- BEGIN op 659 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Bluray', 'sonarr', 460000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Bluray' AND arr_type = 'sonarr' ); -- --- END op 659 -- --- BEGIN op 660 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV', 'radarr', 240000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV' AND arr_type = 'radarr' ); -- --- END op 660 -- --- BEGIN op 661 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV', 'sonarr', 240000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV' AND arr_type = 'sonarr' ); -- --- END op 661 -- --- BEGIN op 662 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p WEB-DL', 'radarr', 560000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p WEB-DL' AND arr_type = 'radarr' ); -- --- END op 662 -- --- BEGIN op 663 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p WEB-DL', 'sonarr', 560000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p WEB-DL' AND arr_type = 'sonarr' ); -- --- END op 663 -- --- BEGIN op 664 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p WEBRip', 'radarr', 460000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p WEBRip' AND arr_type = 'radarr' ); -- --- END op 664 -- --- BEGIN op 665 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p WEBRip', 'sonarr', 460000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p WEBRip' AND arr_type = 'sonarr' ); -- --- END op 665 -- --- BEGIN op 666 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'DVD', 'radarr', 40000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'DVD' AND arr_type = 'radarr' ); -- --- END op 666 -- --- BEGIN op 667 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'DVD', 'sonarr', 40000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'DVD' AND arr_type = 'sonarr' ); -- --- END op 667 -- --- BEGIN op 668 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SDTV', 'radarr', 20000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SDTV' AND arr_type = 'radarr' ); -- --- END op 668 -- --- BEGIN op 669 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SDTV', 'sonarr', 20000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SDTV' AND arr_type = 'sonarr' ); -- --- END op 669 -- --- BEGIN op 670 ( update quality_profile "1080p Quality" ) UPDATE quality_profile_custom_formats SET score = 161000 WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Balanced Tier 1' AND arr_type = 'radarr' AND score = 101000; -- --- END op 670 -- --- BEGIN op 671 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Balanced Tier 1', 'sonarr', 161000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Balanced Tier 1' AND arr_type = 'sonarr' ); -- --- END op 671 -- --- BEGIN op 672 ( update quality_profile "1080p Quality" ) UPDATE quality_profile_custom_formats SET score = 160000 WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Balanced Tier 2' AND arr_type = 'radarr' AND score = 100000; -- --- END op 672 -- --- BEGIN op 673 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Balanced Tier 2', 'sonarr', 160000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Balanced Tier 2' AND arr_type = 'sonarr' ); -- --- END op 673 -- --- BEGIN op 674 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV Tier 1', 'radarr', 102000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV Tier 1' AND arr_type = 'radarr' ); -- --- END op 674 -- --- BEGIN op 675 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV Tier 1', 'sonarr', 102000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV Tier 1' AND arr_type = 'sonarr' ); -- --- END op 675 -- --- BEGIN op 676 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV Tier 2', 'radarr', 101000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV Tier 2' AND arr_type = 'radarr' ); -- --- END op 676 -- --- BEGIN op 677 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV Tier 2', 'sonarr', 101000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV Tier 2' AND arr_type = 'sonarr' ); -- --- END op 677 -- --- BEGIN op 678 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV Tier 3', 'radarr', 100000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV Tier 3' AND arr_type = 'radarr' ); -- --- END op 678 -- --- BEGIN op 679 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p HDTV Tier 3', 'sonarr', 100000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p HDTV Tier 3' AND arr_type = 'sonarr' ); -- --- END op 679 -- --- BEGIN op 680 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 1', 'radarr', 185000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 1' AND arr_type = 'radarr' ); -- --- END op 680 -- --- BEGIN op 681 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 1', 'sonarr', 185000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 1' AND arr_type = 'sonarr' ); -- --- END op 681 -- --- BEGIN op 682 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 2', 'radarr', 184000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 2' AND arr_type = 'radarr' ); -- --- END op 682 -- --- BEGIN op 683 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 2', 'sonarr', 184000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 2' AND arr_type = 'sonarr' ); -- --- END op 683 -- --- BEGIN op 684 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 3', 'radarr', 183000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 3' AND arr_type = 'radarr' ); -- --- END op 684 -- --- BEGIN op 685 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 3', 'sonarr', 183000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 3' AND arr_type = 'sonarr' ); -- --- END op 685 -- --- BEGIN op 686 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 4', 'radarr', 182000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 4' AND arr_type = 'radarr' ); -- --- END op 686 -- --- BEGIN op 687 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 4', 'sonarr', 182000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 4' AND arr_type = 'sonarr' ); -- --- END op 687 -- --- BEGIN op 688 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 5', 'radarr', 181000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 5' AND arr_type = 'radarr' ); -- --- END op 688 -- --- BEGIN op 689 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 5', 'sonarr', 181000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 5' AND arr_type = 'sonarr' ); -- --- END op 689 -- --- BEGIN op 690 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 6', 'radarr', 180000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 6' AND arr_type = 'radarr' ); -- --- END op 690 -- --- BEGIN op 691 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '1080p Quality Tier 6', 'sonarr', 180000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '1080p Quality Tier 6' AND arr_type = 'sonarr' ); -- --- END op 691 -- --- BEGIN op 692 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 1', 'radarr', 43000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 1' AND arr_type = 'radarr' ); -- --- END op 692 -- --- BEGIN op 693 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 1', 'sonarr', 43000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 1' AND arr_type = 'sonarr' ); -- --- END op 693 -- --- BEGIN op 694 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 2', 'radarr', 42000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 2' AND arr_type = 'radarr' ); -- --- END op 694 -- --- BEGIN op 695 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 2', 'sonarr', 42000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 2' AND arr_type = 'sonarr' ); -- --- END op 695 -- --- BEGIN op 696 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 3', 'radarr', 41000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 3' AND arr_type = 'radarr' ); -- --- END op 696 -- --- BEGIN op 697 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 3', 'sonarr', 41000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 3' AND arr_type = 'sonarr' ); -- --- END op 697 -- --- BEGIN op 698 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 4', 'radarr', 40000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 4' AND arr_type = 'radarr' ); -- --- END op 698 -- --- BEGIN op 699 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '480p Quality Tier 4', 'sonarr', 40000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '480p Quality Tier 4' AND arr_type = 'sonarr' ); -- --- END op 699 -- --- BEGIN op 700 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 1', 'radarr', 63000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 1' AND arr_type = 'radarr' ); -- --- END op 700 -- --- BEGIN op 701 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 1', 'sonarr', 63000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 1' AND arr_type = 'sonarr' ); -- --- END op 701 -- --- BEGIN op 702 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 2', 'radarr', 62000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 2' AND arr_type = 'radarr' ); -- --- END op 702 -- --- BEGIN op 703 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 2', 'sonarr', 62000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 2' AND arr_type = 'sonarr' ); -- --- END op 703 -- --- BEGIN op 704 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 3', 'radarr', 61000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 3' AND arr_type = 'radarr' ); -- --- END op 704 -- --- BEGIN op 705 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 3', 'sonarr', 61000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 3' AND arr_type = 'sonarr' ); -- --- END op 705 -- --- BEGIN op 706 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 4', 'radarr', 60000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 4' AND arr_type = 'radarr' ); -- --- END op 706 -- --- BEGIN op 707 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '576p Quality Tier 4', 'sonarr', 60000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '576p Quality Tier 4' AND arr_type = 'sonarr' ); -- --- END op 707 -- --- BEGIN op 708 ( update quality_profile "1080p Quality" ) UPDATE quality_profile_custom_formats SET score = 120000 WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Balanced Tier 1' AND arr_type = 'radarr' AND score = 60000; -- --- END op 708 -- --- BEGIN op 709 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Balanced Tier 1', 'sonarr', 120000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Balanced Tier 1' AND arr_type = 'sonarr' ); -- --- END op 709 -- --- BEGIN op 710 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV Tier 1', 'radarr', 82000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV Tier 1' AND arr_type = 'radarr' ); -- --- END op 710 -- --- BEGIN op 711 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV Tier 1', 'sonarr', 82000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV Tier 1' AND arr_type = 'sonarr' ); -- --- END op 711 -- --- BEGIN op 712 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV Tier 2', 'radarr', 81000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV Tier 2' AND arr_type = 'radarr' ); -- --- END op 712 -- --- BEGIN op 713 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV Tier 2', 'sonarr', 81000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV Tier 2' AND arr_type = 'sonarr' ); -- --- END op 713 -- --- BEGIN op 714 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV Tier 3', 'radarr', 80000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV Tier 3' AND arr_type = 'radarr' ); -- --- END op 714 -- --- BEGIN op 715 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p HDTV Tier 3', 'sonarr', 80000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p HDTV Tier 3' AND arr_type = 'sonarr' ); -- --- END op 715 -- --- BEGIN op 716 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 1', 'radarr', 145000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 1' AND arr_type = 'radarr' ); -- --- END op 716 -- --- BEGIN op 717 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 1', 'sonarr', 145000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 1' AND arr_type = 'sonarr' ); -- --- END op 717 -- --- BEGIN op 718 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 2', 'radarr', 144000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 2' AND arr_type = 'radarr' ); -- --- END op 718 -- --- BEGIN op 719 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 2', 'sonarr', 144000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 2' AND arr_type = 'sonarr' ); -- --- END op 719 -- --- BEGIN op 720 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 3', 'radarr', 143000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 3' AND arr_type = 'radarr' ); -- --- END op 720 -- --- BEGIN op 721 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 3', 'sonarr', 143000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 3' AND arr_type = 'sonarr' ); -- --- END op 721 -- --- BEGIN op 722 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 4', 'radarr', 142000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 4' AND arr_type = 'radarr' ); -- --- END op 722 -- --- BEGIN op 723 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 4', 'sonarr', 142000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 4' AND arr_type = 'sonarr' ); -- --- END op 723 -- --- BEGIN op 724 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 5', 'radarr', 141000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 5' AND arr_type = 'radarr' ); -- --- END op 724 -- --- BEGIN op 725 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 5', 'sonarr', 141000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 5' AND arr_type = 'sonarr' ); -- --- END op 725 -- --- BEGIN op 726 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 6', 'radarr', 140000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 6' AND arr_type = 'radarr' ); -- --- END op 726 -- --- BEGIN op 727 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', '720p Quality Tier 6', 'sonarr', 140000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = '720p Quality Tier 6' AND arr_type = 'sonarr' ); -- --- END op 727 -- --- BEGIN op 728 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SD Quality Tier 1', 'radarr', 21000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SD Quality Tier 1' AND arr_type = 'radarr' ); -- --- END op 728 -- --- BEGIN op 729 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SD Quality Tier 1', 'sonarr', 21000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SD Quality Tier 1' AND arr_type = 'sonarr' ); -- --- END op 729 -- --- BEGIN op 730 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SD Quality Tier 2', 'radarr', 20000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SD Quality Tier 2' AND arr_type = 'radarr' ); -- --- END op 730 -- --- BEGIN op 731 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SD Quality Tier 2', 'sonarr', 20000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SD Quality Tier 2' AND arr_type = 'sonarr' ); -- --- END op 731 -- --- BEGIN op 732 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SDTV Tier 1', 'radarr', 20000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SDTV Tier 1' AND arr_type = 'radarr' ); -- --- END op 732 -- --- BEGIN op 733 ( update quality_profile "1080p Quality" ) INSERT INTO quality_profile_custom_formats (quality_profile_name, custom_format_name, arr_type, score) SELECT '1080p Quality', 'SDTV Tier 1', 'sonarr', 20000 WHERE NOT EXISTS ( SELECT 1 FROM quality_profile_custom_formats WHERE quality_profile_name = '1080p Quality' AND custom_format_name = 'SDTV Tier 1' AND arr_type = 'sonarr' ); -- --- END op 733