CREATE DEFINER=`aerion`@`localhost` TRIGGER `feature_grp_load_after_insert` AFTER INSERT ON `feature_grp_load`
FOR EACH ROW 
BEGIN

INSERT INTO log_global
SET
last_update = now(),
updater = NEW.updater_nm,
table_update = 'feature_grp_load',
actions = 'A',
table_id = CONCAT('idfeature_grp_load', '.',NEW.idfeature_grp_load), 
col1 = CONCAT('idfeature_grp.',NEW.idfeature_grp), 
col2 = CONCAT('group_name.',NEW.group_name), 
col3 = CONCAT('group_desc.',NEW.group_desc),
col4 = CONCAT('idfeature_grp_list.',NEW.idfeature_grp_list), 
col5 = CONCAT('feature_id.',NEW.feature_id),
col6 = CONCAT('feature_nm.',NEW.feature_nm);

INSERT INTO feature_grp_log
SET
trans_type = 'A',
table_id = NEW.idfeature_grp_load, 
idfeature_grp = NEW.idfeature_grp, 
group_name = NEW.group_name, 
group_desc = NEW.group_desc,
idfeature_grp_list = NEW.idfeature_grp_list, 
feature_id = NEW.feature_id,
feature_nm = NEW.feature_nm,
updater = NEW.updater,
updater_nm = NEW.updater_nm,
last_update = now();

END








CREATE DEFINER=`aerion`@`localhost` TRIGGER `feature_grp_load_after_update` AFTER UPDATE ON `feature_grp_load`
 FOR EACH ROW BEGIN
	INSERT INTO  log_global
	SET
	last_update    =   now(),
	updater        =   OLD.updater_nm,
	table_update   =   'feature_grp_load',
	actions        =   'O',
	table_id       =   CONCAT('idfeature_grp_load', '.',OLD.idfeature_grp_load), 
	col1           =   CONCAT('idfeature_grp.',OLD.idfeature_grp), 
	col2           =   CONCAT('group_name.',OLD.group_name), 
	col3           =   CONCAT('group_desc.',OLD.group_desc),
	col4           =   CONCAT('idfeature_grp_list.',OLD.idfeature_grp_list), 
	col5           =   CONCAT('feature_id.',OLD.feature_id),
	col6           =   CONCAT('feature_nm.',OLD.feature_nm);

	INSERT INTO  feature_grp_log
	SET
	trans_type     =   'O',
	table_id       =   OLD.idfeature_grp_load, 
	idfeature_grp  =   OLD.idfeature_grp, 
	group_name     =   OLD.group_name, 
	group_desc     =   OLD.group_desc,
	idfeature_grp_list = OLD.idfeature_grp_list, 
	feature_id     =   OLD.feature_id,
	feature_nm     =   OLD.feature_nm,
	updater        =   OLD.updater,
	updater_nm     =   OLD.updater_nm,
	last_update    =   now();
	
	INSERT INTO  log_global
	SET
	last_update    =   now(),
	updater        =   NEW.updater_nm,
	table_update   =   'feature_grp_load',
	actions        =   'N',
	table_id       =   CONCAT('idfeature_grp_load', '.',NEW.idfeature_grp_load), 
	col1           =   CONCAT('idfeature_grp.',NEW.idfeature_grp), 
	col2           =   CONCAT('group_name.',NEW.group_name), 
	col3           =   CONCAT('group_desc.',NEW.group_desc),
	col4           =   CONCAT('idfeature_grp_list.',NEW.idfeature_grp_list), 
	col5           =   CONCAT('feature_id.',NEW.feature_id),
	col6           =   CONCAT('feature_nm.',NEW.feature_nm);

	INSERT INTO  feature_grp_log
	SET
	trans_type     =   'N',
	table_id       =   NEW.idfeature_grp_load, 
	idfeature_grp  =   NEW.idfeature_grp, 
	group_name     =   NEW.group_name, 
	group_desc     =   NEW.group_desc,
	idfeature_grp_list = NEW.idfeature_grp_list, 
	feature_id     =   NEW.feature_id,
	feature_nm     =   NEW.feature_nm,
	updater        =   NEW.updater,
	updater_nm     =   NEW.updater_nm,
	last_update    =   now();
	
END








CREATE DEFINER=`aerion`@`localhost` TRIGGER `feature_grp_load_after_delete` AFTER DELETE ON `feature_grp_load`
 FOR EACH ROW BEGIN
	
	INSERT INTO  log_global
	SET
	last_update    =   now(),
	updater        =   OLD.updater_nm,
	table_update   =   'feature_grp_load',
	actions        =   'D',
	table_id       =   CONCAT('idfeature_grp_load', '.',OLD.idfeature_grp_load), 
	col1           =   CONCAT('idfeature_grp.',OLD.idfeature_grp), 
	col2           =   CONCAT('group_name.',OLD.group_name), 
	col3           =   CONCAT('group_desc.',OLD.group_desc),
	col4           =   CONCAT('idfeature_grp_list.',OLD.idfeature_grp_list), 
	col5           =   CONCAT('feature_id.',OLD.feature_id),
	col6           =   CONCAT('feature_nm.',OLD.feature_nm);

	INSERT INTO  feature_grp_log
	SET
	trans_type     =   'D',
	table_id       =   OLD.idfeature_grp_load, 
	idfeature_grp  =   OLD.idfeature_grp, 
	group_name     =   OLD.group_name, 
	group_desc     =   OLD.group_desc,
	idfeature_grp_list = OLD.idfeature_grp_list, 
	feature_id     =   OLD.feature_id,
	feature_nm     =   OLD.feature_nm,
	updater        =   OLD.updater,
	updater_nm     =   OLD.updater_nm,
	last_update    =   now();

END