Hi,
Consider my application helps us to create a collection with different pages and also each have different auto increment id's. I am storing the events of every pages in another mysql table 'events'. Here, pageid and collectionid are my foreign keys in events. My prblem is when we edit the collection details; these action help us to delete or add more. Now following the delete and reinsertion procedure. But it will never keep the values in events table.
Is there any other ways to follow the same action because, I need to carry the history of static (non edit) pages.
Really I am stucked. Any suggections or help please.