Nested Set - for CMS with two versions (edit / publish) mode
- by Rick
Hi!
I'm looking for a solution (PHP/Symfony/Doctrine) for the following problem.
I'm creating a table called 'pages'. This table is a nested set. I also want to create a table called 'pages_published' which has ofcourse also a nested set.
Once i create a record in table 'pages' at some point i want to publish this to the 'pages_published)-table. How do make sure the sort order and the level in the structure keeps ok.
Is there some standard solution for my approach?