Re: history log table

Thanks for the reply.

Are you able to explain further or direct me to something online that
could help me out in getting this sorted? I'm just starting with
cakephp.

Thankyou

On Oct 3, 7:59 pm, euromark <dereurom...@googlemail.com> wrote:
> you could write a method in the model or even a behavior which will do
> that for you
> in the beforeSave() callback it can be triggered globally
>
> On 3 Okt., 06:38, elogic <asymo...@elogicmedia.com.au> wrote:
>
>
>
>
>
>
>
> > My client wants a listing of all actions that happen within the system
> > so they can check back and search the records at a later date.
>
> > I thought the best way to handle this would be to have a histories
> > table which would be similar to below:
>
> > CREATE TABLE `histories` (
> >         `id` INT(11) NULL AUTO_INCREMENT,
> >         `user_id` INT(11) NOT NULL DEFAULT '0',
> >         `action` VARCHAR(50) NULL DEFAULT NULL,
> >         `content` VARCHAR(250) NULL DEFAULT NULL,
> >         `created` DATETIME NULL DEFAULT NULL,
> >         `modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
> > CURRENT_TIMESTAMP,
> >         PRIMARY KEY (`id`),
> >         INDEX `user_id` (`user_id`)
> > )
>
> > How would I go about inserting the user_id (the logged user - using
> > Auth), action (i.e. create, edit, delete, login etc) and content
> > (added joe blogs or deleted record ID123 etc) from every section
> > within the site?
>
> > Thanks

--
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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php