One solution : use the Revision Behavior that stores revisions of any model you want : http://bakery.cakephp.org/articles/alkemann/2008/12/18/revision-behavior-revision-control-made-easy You will have to make a special table for posts_revs where all revisions of posts will be stored, but that way you will be able to fetch any version you want of your posts. In your case it will be the last validated one, but you will be able to use it for further functionalities.
Otherwise I would go with your first solutions with separate tables. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
