BiTel

alter table tariff_plan add ts timestamp;

CREATE TABLE `tariff_logs` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`create_date` DATETIME NOT NULL ,
`tpid` INT NOT NULL ,
`title` TEXT
);
 
DELIMITER |
CREATE TRIGGER `tp_logger` BEFORE UPDATE ON `tariff_plan`
FOR EACH ROW BEGIN
INSERT INTO tariff_logs (create_date, tpid, title) VALUES (now(), new.id, new.title);
END;
|
DELIMITER ;

mysql> select * from tariff_logs;
+----+---------------------+------+-----------------------------------+
| id | create_date         | tpid | title                             |
+----+---------------------+------+-----------------------------------+
|  5 | 2010-02-18 19:26:01 |   93 | Анлим минимальный                 |
+----+---------------------+------+-----------------------------------+
1 row in set (0.00 sec)