CREATE DEFINER=`aerion`@`192.180.1.5` TRIGGER `immi_qry_after_insert` AFTER INSERT ON `immi_qry` FOR EACH ROW begin

DECLARE vUser varchar(50);


IF(NEW.updated_by='0')THEN
set vUser='Admin';
else
set vUser=(select concat(firstname, ' ',lastname) from emp where emp_id = NEW.updated_by);
END IF;

 
INSERT INTO log_global
set
last_update	    =	now(),
updater         =	vUser,
table_update    =	'immi_qry',
actions			= 	'A',
table_id		=	CONCAT('idimmi_qry', '.',NEW.idimmi_qry),	
col1 			=	CONCAT('immi_desc', '.',NEW.immi_desc),
col4			=	CONCAT('immi_desc_detail', '.',NEW.immi_desc_detail);

END






CREATE DEFINER=`aerion`@`192.180.1.5` TRIGGER `immi_qry_after_update` AFTER UPDATE ON `immi_qry` FOR EACH ROW begin

DECLARE vUser varchar(50);



IF(OLD.updated_by='0')THEN
set vUser='Admin';
else
set vUser=(select concat(firstname, ' ',lastname) from emp where emp_id = OLD.updated_by);
END IF;

 
INSERT INTO log_global
set
last_update 	= now(),
updater         = vUser,
table_update    = 'immi_qry',
actions			=	'O',
table_id		=	CONCAT('idimmi_qry', '.',OLD.idimmi_qry),	
col1			=	CONCAT('immi_desc', '.',OLD.immi_desc),
col4			=	CONCAT('immi_desc_detail', '.',OLD.immi_desc_detail);

	

 
INSERT INTO log_global
set
last_update 	        = now(),
updater                 = vUser,
table_update     	= 'immi_qry',
actions			=	'N',
table_id		=	CONCAT('idimmi_qry', '.',NEW.idimmi_qry),	
col1			=	CONCAT('immi_desc', '.',NEW.immi_desc),
col4			=	CONCAT('immi_desc_detail', '.',NEW.immi_desc_detail);

END







CREATE DEFINER=`jitenpatel`@`%` TRIGGER `immi_qry_after_delete` AFTER DELETE ON `immi_qry` FOR EACH ROW begin
 
DECLARE vUser varchar(50);


IF(OLD.updated_by='0')THEN
set vUser='Admin';
else
set vUser=(select concat(firstname, ' ',lastname) from emp where emp_id = OLD.updated_by);
END IF;

 
INSERT INTO log_global
set
last_update 	= now(),
updater         = vUser,
table_update    = 'immi_qry',
actions			=	'D',
table_id		=	CONCAT('idimmi_qry', '.',OLD.idimmi_qry),	
col1			=	CONCAT('immi_desc', '.',OLD.immi_desc);
	


END