Delete Triggers example

Delete Trigger

delimiter//

create TRIGGER v57node_delete before delete ON v57node

FOR EACH ROW

BEGIN

set @masteruuid=(select masterUUid from v20ucr_session_lookup where ucr_session_id=old.ucr_session_id);

set @masterTable=(select masterTable from v20ucr_session_lookup where ucr_session_id=old.ucr_session_id);

insert into v20ucr_record_master(tableName,recUUID,clientMask,masterUUID,ucr_session_id,masterTable)

values('v57node',old.uuid, old.clientmask,@masteruuid,old.ucr_session_id,@masterTable);

END;