Trigger for the Auction Table

[DavidLSC]

We might need to have a trigger that checks the ClosingDate >CURRENT_TIMESTAMP(which means this auction is still going) if (ClosingDate <=CURRENT_TIMESTAMP){
the table should update the CurrentBid to the ClosingBid
AND
the CurrentBidID to ClosingBidID
AND the BuyerID to the CustomerID who posted the ClosingBid
}