Database structure for versioning and multiple languages
- by phobia
How can I solve the issue of content existing in multiple versions and multiple languages?
My current structure:
Each content can only have one active version in each language, and that's how I'm curious on how to best solve.
Right now I have a column of the contentversions table, which means for each change of active version I have to run a update and set active=false on all version and then a update to set active=true for the piece of content in question.