All geek questions in one place

Database structure for version control and multiple languages

How can I solve the problem of content existing in several versions and in several languages?

My current structure:

Each content can have only one active version in each language, and this is how I wonder how best to solve.

Right now I have a column in the contentversions table, which means that for every change in the active version, I have to start the update and set active = false for all versions, and then update to set active = true for the part of the content in question.

+3
source share
1 answer

activeversion , content_contentversion_languages, (content_id, language_id) , content_contentversion_languages. INSERT UPDATE .

+2

Source: https://habr.com/ru/post/1747667/

More articles:


All Articles