-- The Collection's Unmatched section (#5579): a person matches an album the
-- listing could not, by a MusicBrainz link or a search (method 'manual'),
-- or leaves it off the list for good (outcome 'dismissed': a local band's
-- album MusicBrainz will never have, a mix that is no album).
ALTER TABLE library_album_matches DROP CONSTRAINT library_album_matches_outcome_check;
ALTER TABLE library_album_matches ADD CONSTRAINT library_album_matches_outcome_check
    CHECK (outcome IN ('listed', 'unmatched', 'dismissed'));
ALTER TABLE library_album_matches DROP CONSTRAINT library_album_matches_method_check;
ALTER TABLE library_album_matches ADD CONSTRAINT library_album_matches_method_check
    CHECK (method IN ('', 'tags', 'release', 'discography', 'search', 'manual'));