therobbiedavis/Listenarr 0.2.35

Canary 0.2.35

on GitHub

This pull request adds several migration files to handle missing columns in the ApplicationSettings table, addressing historical inconsistencies where columns were manually added in some databases. It introduces both authoritative and final migrations that add the expected columns, including notification triggers and US proxy settings, and documents the approach for environments with manual changes. Some migrations are intentionally no-ops to avoid duplicate column errors and preserve data integrity.

ApplicationSettings column additions:

• Authoritative and final migrations (AddMissingApplicationSettingsColumns_Final, AddMissingApplicationSettingsColumns_Authoritative) add the following columns to the ApplicationSettings table: EnabledNotificationTriggers, PreferUsDomain, UseUsProxy, UsProxyHost, UsProxyPort, UsProxyUsername, UsProxyPassword, and WebhookUrl, with appropriate types and default values. [1] [2] [3]
• Clean migration (AddMissingApplicationSettingsColumns_Clean) adds all the above columns except WebhookUrl.

Migration history and documentation:

• Migrations are added to record and track columns that were manually added in production databases, ensuring migration history reflects the current schema state.
• Several migrations (AddMissingApplicationSettingsColumns, AddMissingApplicationSettingsColumnsClean, AddMissingApplicationSettingsColumns_Authoritative_20251116202412) are intentionally left as no-ops to avoid duplicate column errors and accidental data loss, with comments explaining the rationale and guidance for manual fixes if needed. [[1]](diffhunk://#diff-39d671e05ddd3cd900a1d825d88c55e478628f0414f34bcde32dc65fc187b58fR...

Automated canary build

• Version: 0.2.35
• Commit: 3b2610f
• Original PR: #175