views:

63

answers:

0

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?