You might want to consider a field for the id of the reviewer, something to indicate their decision (they might decline it) and the time/date of that decision.
Jeremy Burns Class Outfit Tel: +44 (0) 208 123 3822 Mob: +44 (0) 7973 481949 Skype: jeremy_burns http://www.classoutfit.com On 6 Oct 2011, at 15:08, Boyan Penev wrote: > Thank you both for the useful help. > > Regards, > > Boyan > > On Thu, Oct 6, 2011 at 3:36 PM, euromark <dereurom...@googlemail.com> wrote: >> it seems a simply boolean (tinyint 1) is enough in your case >> >> >> On 6 Okt., 15:14, Zaky Katalan-Ezra <procsh...@gmail.com> wrote: >>> You can review CakeDC comments pluginhttps://github.com/CakeDC/comments >>> >>> >>> >>> >>> >>> >>> >>> On Wed, Oct 5, 2011 at 11:02 AM, Boyan <boyan...@googlemail.com> wrote: >>>> Hello, >>> >>>> I am trying to develop a blog- like application with Cakephp and have >>>> a rather general question. >>>> The comments for each post should be first reviewed by the author of >>>> the post, before becoming visible (Comment belongsTo Article, Comment >>>> belongsTo User, Post belongsTo User) >>> >>>> So my question is- what would be the best way to go about it? Would a >>>> boolean flag in the sql table for the comments suffice? And if so- is >>>> it secure enough? Or should I rather use ACL? Or maybe a completely >>>> different approach? >>> >>>> Thank you, >>> >>>> Boyan >>> >>>> -- >>>> Our newest site for the community: CakePHP Video Tutorials >>>> http://tv.cakephp.org >>>> Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help >>>> others with their CakePHP related questions. >>> >>>> To unsubscribe from this group, send email to >>>> cake-php+unsubscr...@googlegroups.com For more options, visit this group >>>> athttp://groups.google.com/group/cake-php >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> cake-php+unsubscr...@googlegroups.com For more options, visit this group at >> http://groups.google.com/group/cake-php >> > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php