What I want to have happen is before an update or delete occurs I want the row being affected to be copied out to an archive table. so I have a copy of what the data looked like before the update happened.
I'm not sure how to reference the data from the row being affected to insert it into an archive table of the same structure as the origingal.
DEAL and DEAL_ARCHIVE
so and update happens to any column of deal it copies the entire unaltered row affected over to DEAL_ARCHIVE then completes the update to DEAL.