Idea

Hi, I have made a somewhat similar thing once, so I have an idea for you.
To make it simple to add more translations for the country-names, add another table, like this pseudo-code:

create table translated_country_names (
`country_code` varchar(2) CHARACTER SET ascii NOT NULL DEFAULT '',
`lang_code` varchar(8) CHARACTER SET utf8mb4 NOT NULL,
`cname` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
);

Then insert each translated country:

insert into translated_country_names (country_code, lang_code, cname) values('ad','de','Andorra');

This way you can remove all languages from your table 'countries', and later easily add more languages into 'translated_country_names'.

Nice package/table of information!

Thanks for the feedback and idea. I'll give it a consideration.