Audit Table using Triggers
- by Jose
DROP TABLE IF EXISTS `actividades`.`act_actividad_audit`;
CREATE TABLE `actividades`.`act_actividad_audit` (
`fe_creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
`usr_digitador` char(10) NOT NULL,
`ip_digitador` char(15) NOT NULL,
`id_act_actividad` int(10) unsigned NOT NULL,
`titulo` char(64) NOT NULL,
`act_prioridad_id` int(10) unsigned NOT NULL,
`act_motivo_id` int(10) unsigned NOT NULL,
`detalle` text,
`detalle_tecnico` text,
`hostname_id` int(10) unsigned NOT NULL,
`hostname_nombre` char(50) NOT NULL,
`es_SMOP` tinyint(1) NOT NULL,
`url_SMOP` text,
`es_tecnico` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Auditoria Actividad General';
I want to populate that audit table with a trigger but how can i send or fill the values for usr_digitador or ip_digitador if that values are on client side.? please help
