How do i solve the problem of content existing in multiple versions and multiple languages?

My current structure:

Each content are only able to have one active version in every language, and that is how I am curious regarding how to best solve.

At this time I've got a column from the contentversions table, meaning for every change of active version I must operate a update and hang active=false on all version after which a update to create active=true for that bit of content under consideration.

You could utilize a table activeversion with similar structure as content_contentversion_languages, however with a distinctive key on (content_id, language_id) along with a single foreign key on all posts, referencing content_contentversion_languages. Marking a brand new version as active requires only a single Place or UPDATE for this table.