How do i solve the problem of content existing in multiple versions and multiple languages?
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.