This is not a big deal, but how should one go about requesting updates to the options in a pull-down with set choices?

For Norway the Parental rating drop down in My Movies offers the following choices: [A, 7 år, 11 år, 15 år, 18 år] (which were the correct options some years ago).
For the past five years (at least) the correct rating options have been: [A – tillatt for alle, 6 år, 9 år, 12 år, 15 år, 18 år] (Ref: https://www.medietilsynet.no/tv-film-radio/film-og-kino/slik-settes-en-aldersgrense/ ).
There may possibly be other options, but I think those two sets, in addition to "Unrated" mostly covers it.

If the aim is to have correct info in the database, my suggestion would be to add the options [6 år, 9 år, 12 år] to the current available choices for Norway.

Thank you for the thorough explanation. I am fine with it as is, and I am not that worried about the ratings field. I'll just skip it when entering data if there is no match.


The following is not a suggestion that you actually do something about the current state, as it is probably not worth it. (You could consider putting it at the very bottom of the the change request list maybe).

But, depending on how complex it is to mass update records in the database, and unless there are additional technical issues I am not aware of, or something else I didn't understand correctly, I do think it would be possible to address this within your current data structure to enable entering correct data for both recent and older Norwegian titles while keeping data for older Norwegain titles.

Any Norwegain title, new or old, should always have exactly one single rating out of a total of 8 options total. DVDs (and Blu-rays) from 1998 to around 2019 should have one of the five currently available ratings, while recent releases add three new options.

Replace the values in the current ratings table for Norway as follows (the string for 2, 4, 6, and 7 changes):
region value="Norway" tv="false"
rating value="8"18 år/rating
rating value="7"15 år/rating
rating value="6"12 år/rating
rating value="5"11 år/rating
rating value="4"9 år/rating
rating value="3"7 år/rating
rating value="2"6 år/rating
rating value="1"A/rating
rating value="0"Unrated/rating
rating value="-1"None/rating
/region

For all Norway titles, change current rating values as follows (doing the remapping in this order should avoid loops/double remappings):
value "1" ok
value "2" change to "1"
value "3" ok
value "4" change to "5"
value "5" ok
value "7" change to "8"
value "6" change to "7"
value "8" ok
(I assume there is a flag for when a title is updated. If so the titles with a changed rating value should have this set).

After this there will be no titles with the rating value 2, 4 or 6, and all titles keep the displayed rating they have now. But the new ratings are available for selection when editing.