CREATE TABLE foo (
    $definitions
);

CREATE TABLE foo_versions (
    username  VARCHAR(8) DEFAULT current_user(),
    timestamp DATETIME DEFAULT NOW(),
    action CHAR(1), -- IUD
    $definitions -- stores the values BEFORE the action
);

CREATE TRIGGER foo_update BEFORE update ON foo
FOR EACH ROW
INSERT INTO foo_versions ('U',$columns);

CREATE TRIGGER foo_delete BEFORE delete ON foo
FOR EACH ROW
INSERT INTO foo_versions ('D',$columns);

CREATE TRIGGER foo_insert BEFORE update ON foo
FOR EACH ROW
INSERT INTO foo_versions ('I',$columns);