It is sometimes necessary to keep track of what changes were made to the database, and by whom. This is known as Audit Logging or an Audit Trail. I have seen several different ways of implementing Audit Logging, but have any ideas about hot to build this based on YII core?
CREATE TABLE IF NOT EXISTS `audit_fld` ( `session_id` bigint(20) unsigned NOT NULL default '0', `tran_seq_no` smallint(6) unsigned NOT NULL default '0', `table_seq_no` smallint(6) unsigned NOT NULL default '0', `field_id` varchar(255) NOT NULL default '', `old_value` text, `new_value` text, PRIMARY KEY (`session_id`,`tran_seq_no`,`table_seq_no`,`field_id`), KEY `field_id` (`field_id`) );
lIKE this based on radicore:
(builden in www.radicore.org framework)