DELIMITER $$

CREATE TRIGGER after_areas_insert AFTER INSERT ON areas
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('areas', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_areas_update AFTER UPDATE ON areas
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('areas', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_areas_delete AFTER DELETE ON areas
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('areas', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;
    
DELIMITER $$

CREATE TRIGGER after_area_levels_insert AFTER INSERT ON area_levels
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_levels', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_area_levels_update AFTER UPDATE ON area_levels
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_levels', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_area_levels_delete AFTER DELETE ON area_levels
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_levels', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_area_locations_insert AFTER INSERT ON area_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_area_locations_update AFTER UPDATE ON area_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_area_locations_delete AFTER DELETE ON area_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_area_racks_insert AFTER INSERT ON area_racks
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_racks', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_area_racks_update AFTER UPDATE ON area_racks
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_racks', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_area_racks_delete AFTER DELETE ON area_racks
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('area_racks', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_attendances_insert AFTER INSERT ON attendances
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('attendances', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_attendances_update AFTER UPDATE ON attendances
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('attendances', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_attendances_delete AFTER DELETE ON attendances
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('attendances', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_boms_insert AFTER INSERT ON boms
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('boms', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_boms_update AFTER UPDATE ON boms
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('boms', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_boms_delete AFTER DELETE ON boms
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('boms', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_bom_crushings_insert AFTER INSERT ON bom_crushings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_crushings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_crushings_update AFTER UPDATE ON bom_crushings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_crushings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_crushings_delete AFTER DELETE ON bom_crushings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_crushings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_bom_processes_insert AFTER INSERT ON bom_processes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_processes', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_processes_update AFTER UPDATE ON bom_processes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_processes', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_processes_delete AFTER DELETE ON bom_processes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_processes', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_bom_purchase_parts_insert AFTER INSERT ON bom_purchase_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_purchase_parts', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_purchase_parts_update AFTER UPDATE ON bom_purchase_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_purchase_parts', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_purchase_parts_delete AFTER DELETE ON bom_purchase_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_purchase_parts', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_bom_sub_parts_insert AFTER INSERT ON bom_sub_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_sub_parts', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_sub_parts_update AFTER UPDATE ON bom_sub_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_sub_parts', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_sub_parts_delete AFTER DELETE ON bom_sub_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_sub_parts', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_bom_verifications_insert AFTER INSERT ON bom_verifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_verifications', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_verifications_update AFTER UPDATE ON bom_verifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_verifications', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_bom_verifications_delete AFTER DELETE ON bom_verifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('bom_verifications', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_call_for_assistances_insert AFTER INSERT ON call_for_assistances
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('call_for_assistances', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_call_for_assistances_update AFTER UPDATE ON call_for_assistances
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('call_for_assistances', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_call_for_assistances_delete AFTER DELETE ON call_for_assistances
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('call_for_assistances', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_caproblems_insert AFTER INSERT ON caproblems
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('caproblems', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_caproblems_update AFTER UPDATE ON caproblems
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('caproblems', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_caproblems_delete AFTER DELETE ON caproblems
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('caproblems', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_currencies_insert AFTER INSERT ON currencies
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('currencies', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_currencies_update AFTER UPDATE ON currencies
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('currencies', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_currencies_delete AFTER DELETE ON currencies
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('currencies', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_customers_insert AFTER INSERT ON customers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('customers', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_customers_update AFTER UPDATE ON customers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('customers', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_customers_delete AFTER DELETE ON customers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('customers', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_customer_shipping_locations_insert AFTER INSERT ON customer_shipping_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('customer_shipping_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_customer_shipping_locations_update AFTER UPDATE ON customer_shipping_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('customer_shipping_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_customer_shipping_locations_delete AFTER DELETE ON customer_shipping_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('customer_shipping_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_daily_production_child_parts_insert AFTER INSERT ON daily_production_child_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_child_parts', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_child_parts_update AFTER UPDATE ON daily_production_child_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_child_parts', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_child_parts_delete AFTER DELETE ON daily_production_child_parts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_child_parts', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_daily_production_plannings_insert AFTER INSERT ON daily_production_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_plannings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_plannings_update AFTER UPDATE ON daily_production_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_plannings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_plannings_delete AFTER DELETE ON daily_production_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_plannings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_daily_production_planning_details_insert AFTER INSERT ON daily_production_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_planning_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_planning_details_update AFTER UPDATE ON daily_production_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_planning_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_planning_details_delete AFTER DELETE ON daily_production_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_planning_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_daily_production_products_insert AFTER INSERT ON daily_production_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_products', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_products_update AFTER UPDATE ON daily_production_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_products', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_daily_production_products_delete AFTER DELETE ON daily_production_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('daily_production_products', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_delivery_instructions_insert AFTER INSERT ON delivery_instructions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('delivery_instructions', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_delivery_instructions_update AFTER UPDATE ON delivery_instructions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('delivery_instructions', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_delivery_instructions_delete AFTER DELETE ON delivery_instructions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('delivery_instructions', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_delivery_instruction_details_insert AFTER INSERT ON delivery_instruction_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('delivery_instruction_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_delivery_instruction_details_update AFTER UPDATE ON delivery_instruction_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('delivery_instruction_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_delivery_instruction_details_delete AFTER DELETE ON delivery_instruction_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('delivery_instruction_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_departments_insert AFTER INSERT ON departments
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('departments', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_departments_update AFTER UPDATE ON departments
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('departments', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_departments_delete AFTER DELETE ON departments
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('departments', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_designations_insert AFTER INSERT ON designations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('designations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_designations_update AFTER UPDATE ON designations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('designations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_designations_delete AFTER DELETE ON designations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('designations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_discrepancies_insert AFTER INSERT ON discrepancies
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('discrepancies', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_discrepancies_update AFTER UPDATE ON discrepancies
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('discrepancies', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_discrepancies_delete AFTER DELETE ON discrepancies
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('discrepancies', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_electrical_continuity_scans_insert AFTER INSERT ON electrical_continuity_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_scans', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_electrical_continuity_scans_update AFTER UPDATE ON electrical_continuity_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_scans', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_electrical_continuity_scans_delete AFTER DELETE ON electrical_continuity_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_scans', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_electrical_continuity_summaries_insert AFTER INSERT ON electrical_continuity_summaries
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_summaries', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_electrical_continuity_summaries_update AFTER UPDATE ON electrical_continuity_summaries
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_summaries', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_electrical_continuity_summaries_delete AFTER DELETE ON electrical_continuity_summaries
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_summaries', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_electrical_continuity_tests_insert AFTER INSERT ON electrical_continuity_tests
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_tests', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_electrical_continuity_tests_update AFTER UPDATE ON electrical_continuity_tests
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_tests', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_electrical_continuity_tests_delete AFTER DELETE ON electrical_continuity_tests
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('electrical_continuity_tests', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_family_child_users_insert AFTER INSERT ON family_child_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('family_child_users', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_family_child_users_update AFTER UPDATE ON family_child_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('family_child_users', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_family_child_users_delete AFTER DELETE ON family_child_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('family_child_users', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_family_users_insert AFTER INSERT ON family_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('family_users', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_family_users_update AFTER UPDATE ON family_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('family_users', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_family_users_delete AFTER DELETE ON family_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('family_users', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_final_checkings_insert AFTER INSERT ON final_checkings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checkings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checkings_update AFTER UPDATE ON final_checkings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checkings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checkings_delete AFTER DELETE ON final_checkings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checkings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_final_checking_scans_insert AFTER INSERT ON final_checking_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_scans', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_scans_update AFTER UPDATE ON final_checking_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_scans', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_scans_delete AFTER DELETE ON final_checking_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_scans', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_final_checking_status_lls_insert AFTER INSERT ON final_checking_status_lls
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_status_lls', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_status_lls_update AFTER UPDATE ON final_checking_status_lls
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_status_lls', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_status_lls_delete AFTER DELETE ON final_checking_status_lls
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_status_lls', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_final_checking_status_svs_insert AFTER INSERT ON final_checking_status_svs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_status_svs', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_status_svs_update AFTER UPDATE ON final_checking_status_svs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_status_svs', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_status_svs_delete AFTER DELETE ON final_checking_status_svs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_status_svs', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_final_checking_summaries_insert AFTER INSERT ON final_checking_summaries
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_summaries', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_summaries_update AFTER UPDATE ON final_checking_summaries
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_summaries', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_final_checking_summaries_delete AFTER DELETE ON final_checking_summaries
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('final_checking_summaries', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_good_receivings_insert AFTER INSERT ON good_receivings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receivings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receivings_update AFTER UPDATE ON good_receivings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receivings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receivings_delete AFTER DELETE ON good_receivings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receivings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_good_receiving_locations_insert AFTER INSERT ON good_receiving_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receiving_locations_update AFTER UPDATE ON good_receiving_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receiving_locations_delete AFTER DELETE ON good_receiving_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_good_receiving_products_insert AFTER INSERT ON good_receiving_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_products', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receiving_products_update AFTER UPDATE ON good_receiving_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_products', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receiving_products_delete AFTER DELETE ON good_receiving_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_products', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;


DELIMITER $$

CREATE TRIGGER after_good_receiving_qcs_insert AFTER INSERT ON good_receiving_qcs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_qcs', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receiving_qcs_update AFTER UPDATE ON good_receiving_qcs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_qcs', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_good_receiving_qcs_delete AFTER DELETE ON good_receiving_qcs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('good_receiving_qcs', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_initail_nos_insert AFTER INSERT ON initail_nos
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('initail_nos', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_initail_nos_update AFTER UPDATE ON initail_nos
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('initail_nos', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_initail_nos_delete AFTER DELETE ON initail_nos
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('initail_nos', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_invoices_insert AFTER INSERT ON invoices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('invoices', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_invoices_update AFTER UPDATE ON invoices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('invoices', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_invoices_delete AFTER DELETE ON invoices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('invoices', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_invoice_details_insert AFTER INSERT ON invoice_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('invoice_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_invoice_details_update AFTER UPDATE ON invoice_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('invoice_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_invoice_details_delete AFTER DELETE ON invoice_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('invoice_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_leaves_insert AFTER INSERT ON leaves
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('leaves', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_leaves_update AFTER UPDATE ON leaves
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('leaves', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_leaves_delete AFTER DELETE ON leaves
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('leaves', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_locations_insert AFTER INSERT ON locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_locations_update AFTER UPDATE ON locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_locations_delete AFTER DELETE ON locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_lot_nos_insert AFTER INSERT ON lot_nos
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('lot_nos', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_lot_nos_update AFTER UPDATE ON lot_nos
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('lot_nos', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_lot_nos_delete AFTER DELETE ON lot_nos
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('lot_nos', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_machines_insert AFTER INSERT ON machines
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machines', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_machines_update AFTER UPDATE ON machines
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machines', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_machines_delete AFTER DELETE ON machines
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machines', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_machine_apis_insert AFTER INSERT ON machine_apis
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_apis', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_apis_update AFTER UPDATE ON machine_apis
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_apis', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_apis_delete AFTER DELETE ON machine_apis
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_apis', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_machine_counts_insert AFTER INSERT ON machine_counts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_counts', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_counts_update AFTER UPDATE ON machine_counts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_counts', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_counts_delete AFTER DELETE ON machine_counts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_counts', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_machine_downtimes_insert AFTER INSERT ON machine_downtimes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_downtimes', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_downtimes_update AFTER UPDATE ON machine_downtimes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_downtimes', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_downtimes_delete AFTER DELETE ON machine_downtimes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_downtimes', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_machine_preperations_insert AFTER INSERT ON machine_preperations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_preperations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_preperations_update AFTER UPDATE ON machine_preperations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_preperations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_preperations_delete AFTER DELETE ON machine_preperations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_preperations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_machine_tonnages_insert AFTER INSERT ON machine_tonnages
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_tonnages', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_tonnages_update AFTER UPDATE ON machine_tonnages
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_tonnages', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_machine_tonnages_delete AFTER DELETE ON machine_tonnages
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('machine_tonnages', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_issues_insert AFTER INSERT ON material_issues
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_issues', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_issues_update AFTER UPDATE ON material_issues
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_issues', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_issues_delete AFTER DELETE ON material_issues
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_issues', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_issue_details_insert AFTER INSERT ON material_issue_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_issue_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_issue_details_update AFTER UPDATE ON material_issue_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_issue_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_issue_details_delete AFTER DELETE ON material_issue_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_issue_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_plannings_insert AFTER INSERT ON material_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_plannings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_plannings_update AFTER UPDATE ON material_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_plannings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_plannings_delete AFTER DELETE ON material_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_plannings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_planning_details_insert AFTER INSERT ON material_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_planning_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_planning_details_update AFTER UPDATE ON material_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_planning_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_planning_details_delete AFTER DELETE ON material_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_planning_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_requisitions_insert AFTER INSERT ON material_requisitions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisitions', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisitions_update AFTER UPDATE ON material_requisitions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisitions', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisitions_delete AFTER DELETE ON material_requisitions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisitions', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_requisition_details_insert AFTER INSERT ON material_requisition_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisition_details_update AFTER UPDATE ON material_requisition_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisition_details_delete AFTER DELETE ON material_requisition_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_requisition_product_details_insert AFTER INSERT ON material_requisition_product_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_product_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisition_product_details_update AFTER UPDATE ON material_requisition_product_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_product_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisition_product_details_delete AFTER DELETE ON material_requisition_product_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_product_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_material_requisition_product_details_receives_insert AFTER INSERT ON material_requisition_product_details_receives
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_product_details_receives', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisition_product_details_receives_update AFTER UPDATE ON material_requisition_product_details_receives
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_product_details_receives', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_material_requisition_product_details_receives_delete AFTER DELETE ON material_requisition_product_details_receives
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('material_requisition_product_details_receives', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_migrations_insert AFTER INSERT ON migrations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('migrations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_migrations_update AFTER UPDATE ON migrations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('migrations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_migrations_delete AFTER DELETE ON migrations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('migrations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_model_has_permissions_insert AFTER INSERT ON model_has_permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'model_has_permissions',
        CONCAT('permission_id:',NEW.permission_id,'|model_type:', NEW.model_type, '|model_id:', NEW.model_id),
        'INSERT',
        NOW()
    );
    END IF;
END$$

CREATE TRIGGER after_model_has_permissions_update AFTER UPDATE ON model_has_permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'model_has_permissions',
        CONCAT('permission_id:', NEW.permission_id, '|model_type:', NEW.model_type, '|model_id:', NEW.model_id),
        'UPDATE',
        NOW()
    );
    END IF;
END$$

CREATE TRIGGER after_model_has_permissions_delete AFTER DELETE ON model_has_permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'model_has_permissions',
        CONCAT('permission_id:', OLD.permission_id, '|model_type:', OLD.model_type, '|model_id:', OLD.model_id),
        'DELETE',
        NOW()
    );
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_model_has_roles_insert AFTER INSERT ON model_has_roles
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'model_has_roles', 
        CONCAT('role_id:',NEW.role_id,'|model_type:', NEW.model_type, '|model_id:', NEW.model_id),
        'INSERT',
         NOW()
        );
        END IF;
END$$

CREATE TRIGGER after_model_has_roles_update AFTER UPDATE ON model_has_roles
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'model_has_roles',
             CONCAT('role_id:', NEW.role_id, '|model_type:', NEW.model_type, '|model_id:', NEW.model_id),
            'UPDATE',
            NOW()
        );
        END IF;
END$$

CREATE TRIGGER after_model_has_roles_delete AFTER DELETE ON model_has_roles
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'model_has_roles', 
        CONCAT('role_id:', OLD.role_id, '|model_type:', OLD.model_type, '|model_id:', OLD.model_id),
        'DELETE', 
        NOW());
        END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_more_users_insert AFTER INSERT ON more_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('more_users', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_more_users_update AFTER UPDATE ON more_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('more_users', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_more_users_delete AFTER DELETE ON more_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('more_users', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_notifications_insert AFTER INSERT ON notifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('notifications', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_notifications_update AFTER UPDATE ON notifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('notifications', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_notifications_delete AFTER DELETE ON notifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('notifications', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_notification_screens_insert AFTER INSERT ON notification_screens
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('notification_screens', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_notification_screens_update AFTER UPDATE ON notification_screens
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('notification_screens', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_notification_screens_delete AFTER DELETE ON notification_screens
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('notification_screens', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_orders_insert AFTER INSERT ON orders
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('orders', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_orders_update AFTER UPDATE ON orders
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('orders', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_orders_delete AFTER DELETE ON orders
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('orders', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_order_details_insert AFTER INSERT ON order_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('order_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_order_details_update AFTER UPDATE ON order_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('order_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_order_details_delete AFTER DELETE ON order_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('order_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_outgoings_insert AFTER INSERT ON outgoings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoings_update AFTER UPDATE ON outgoings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoings_delete AFTER DELETE ON outgoings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_outgoing_details_insert AFTER INSERT ON outgoing_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoing_details_update AFTER UPDATE ON outgoing_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoing_details_delete AFTER DELETE ON outgoing_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_outgoing_locations_insert AFTER INSERT ON outgoing_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoing_locations_update AFTER UPDATE ON outgoing_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoing_locations_delete AFTER DELETE ON outgoing_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_outgoing_sale_locations_insert AFTER INSERT ON outgoing_sale_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_sale_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoing_sale_locations_update AFTER UPDATE ON outgoing_sale_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_sale_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_outgoing_sale_locations_delete AFTER DELETE ON outgoing_sale_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('outgoing_sale_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;



DELIMITER $$

CREATE TRIGGER after_permissions_insert AFTER INSERT ON permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('permissions', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_permissions_update AFTER UPDATE ON permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('permissions', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_permissions_delete AFTER DELETE ON permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('permissions', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_personal_access_tokens_insert AFTER INSERT ON personal_access_tokens
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('personal_access_tokens', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_personal_access_tokens_update AFTER UPDATE ON personal_access_tokens
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('personal_access_tokens', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_personal_access_tokens_delete AFTER DELETE ON personal_access_tokens
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('personal_access_tokens', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_personal_users_insert AFTER INSERT ON personal_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('personal_users', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_personal_users_update AFTER UPDATE ON personal_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('personal_users', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_personal_users_delete AFTER DELETE ON personal_users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('personal_users', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_po_important_notes_insert AFTER INSERT ON po_important_notes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('po_important_notes', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_po_important_notes_update AFTER UPDATE ON po_important_notes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('po_important_notes', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_po_important_notes_delete AFTER DELETE ON po_important_notes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('po_important_notes', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_processes_insert AFTER INSERT ON processes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('processes', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_processes_update AFTER UPDATE ON processes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('processes', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_processes_delete AFTER DELETE ON processes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('processes', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_apis_insert AFTER INSERT ON production_apis
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_apis', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_apis_update AFTER UPDATE ON production_apis
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_apis', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_apis_delete AFTER DELETE ON production_apis
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_apis', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_output_traceabilities_insert AFTER INSERT ON production_output_traceabilities
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceabilities', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceabilities_update AFTER UPDATE ON production_output_traceabilities
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceabilities', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceabilities_delete AFTER DELETE ON production_output_traceabilities
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceabilities', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_output_traceability_details_insert AFTER INSERT ON production_output_traceability_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_details_update AFTER UPDATE ON production_output_traceability_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_details_delete AFTER DELETE ON production_output_traceability_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_output_traceability_q_c_s_insert AFTER INSERT ON production_output_traceability_q_c_s
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_q_c_s', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_q_c_s_update AFTER UPDATE ON production_output_traceability_q_c_s
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_q_c_s', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_q_c_s_delete AFTER DELETE ON production_output_traceability_q_c_s
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_q_c_s', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_output_traceability_rejections_insert AFTER INSERT ON production_output_traceability_rejections
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_rejections', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_rejections_update AFTER UPDATE ON production_output_traceability_rejections
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_rejections', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_rejections_delete AFTER DELETE ON production_output_traceability_rejections
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_rejections', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_output_traceability_shifts_insert AFTER INSERT ON production_output_traceability_shifts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_shifts', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_shifts_update AFTER UPDATE ON production_output_traceability_shifts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_shifts', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_traceability_shifts_delete AFTER DELETE ON production_output_traceability_shifts
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_traceability_shifts', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_output_tracebility_scans_insert AFTER INSERT ON production_output_tracebility_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_tracebility_scans', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_tracebility_scans_update AFTER UPDATE ON production_output_tracebility_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_tracebility_scans', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_output_tracebility_scans_delete AFTER DELETE ON production_output_tracebility_scans
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_output_tracebility_scans', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_production_schedulings_insert AFTER INSERT ON production_schedulings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_schedulings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_schedulings_update AFTER UPDATE ON production_schedulings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_schedulings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_production_schedulings_delete AFTER DELETE ON production_schedulings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('production_schedulings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_products_insert AFTER INSERT ON products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('products', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_products_update AFTER UPDATE ON products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('products', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_products_delete AFTER DELETE ON products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('products', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;
DELIMITER $$

CREATE TRIGGER after_product_reorderings_insert AFTER INSERT ON product_reorderings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('product_reorderings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_product_reorderings_update AFTER UPDATE ON product_reorderings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('product_reorderings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_product_reorderings_delete AFTER DELETE ON product_reorderings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('product_reorderings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_pr_approvals_insert AFTER INSERT ON pr_approvals
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('pr_approvals', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_pr_approvals_update AFTER UPDATE ON pr_approvals
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('pr_approvals', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_pr_approvals_delete AFTER DELETE ON pr_approvals
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('pr_approvals', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_orders_insert AFTER INSERT ON purchase_orders
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_orders', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_orders_update AFTER UPDATE ON purchase_orders
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_orders', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_orders_delete AFTER DELETE ON purchase_orders
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_orders', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_order_details_insert AFTER INSERT ON purchase_order_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_order_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_order_details_update AFTER UPDATE ON purchase_order_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_order_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_order_details_delete AFTER DELETE ON purchase_order_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_order_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_plannings_insert AFTER INSERT ON purchase_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_plannings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_plannings_update AFTER UPDATE ON purchase_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_plannings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_plannings_delete AFTER DELETE ON purchase_plannings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_plannings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_planning_details_insert AFTER INSERT ON purchase_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_details_update AFTER UPDATE ON purchase_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_details_delete AFTER DELETE ON purchase_planning_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_planning_products_insert AFTER INSERT ON purchase_planning_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_products', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_products_update AFTER UPDATE ON purchase_planning_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_products', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_products_delete AFTER DELETE ON purchase_planning_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_products', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_planning_suppliers_insert AFTER INSERT ON purchase_planning_suppliers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_suppliers', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_suppliers_update AFTER UPDATE ON purchase_planning_suppliers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_suppliers', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_suppliers_delete AFTER DELETE ON purchase_planning_suppliers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_suppliers', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_planning_verifications_insert AFTER INSERT ON purchase_planning_verifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_verifications', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_verifications_update AFTER UPDATE ON purchase_planning_verifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_verifications', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_planning_verifications_delete AFTER DELETE ON purchase_planning_verifications
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_planning_verifications', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_prices_insert AFTER INSERT ON purchase_prices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_prices', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_prices_update AFTER UPDATE ON purchase_prices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_prices', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_prices_delete AFTER DELETE ON purchase_prices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_prices', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_receive_locations_insert AFTER INSERT ON purchase_receive_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_receive_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_receive_locations_update AFTER UPDATE ON purchase_receive_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_receive_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_receive_locations_delete AFTER DELETE ON purchase_receive_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_receive_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_requisitions_insert AFTER INSERT ON purchase_requisitions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisitions', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_requisitions_update AFTER UPDATE ON purchase_requisitions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisitions', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_requisitions_delete AFTER DELETE ON purchase_requisitions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisitions', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_requisition_details_insert AFTER INSERT ON purchase_requisition_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisition_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_requisition_details_update AFTER UPDATE ON purchase_requisition_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisition_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_requisition_details_delete AFTER DELETE ON purchase_requisition_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisition_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_requisition_statuses_insert AFTER INSERT ON purchase_requisition_statuses
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisition_statuses', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_requisition_statuses_update AFTER UPDATE ON purchase_requisition_statuses
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisition_statuses', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_requisition_statuses_delete AFTER DELETE ON purchase_requisition_statuses
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_requisition_statuses', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_returns_insert AFTER INSERT ON purchase_returns
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_returns', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_returns_update AFTER UPDATE ON purchase_returns
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_returns', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_returns_delete AFTER DELETE ON purchase_returns
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_returns', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_return_locations_insert AFTER INSERT ON purchase_return_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_return_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_return_locations_update AFTER UPDATE ON purchase_return_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_return_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_return_locations_delete AFTER DELETE ON purchase_return_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_return_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_purchase_return_products_insert AFTER INSERT ON purchase_return_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_return_products', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_return_products_update AFTER UPDATE ON purchase_return_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_return_products', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_purchase_return_products_delete AFTER DELETE ON purchase_return_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('purchase_return_products', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_quotations_insert AFTER INSERT ON quotations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('quotations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_quotations_update AFTER UPDATE ON quotations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('quotations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_quotations_delete AFTER DELETE ON quotations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('quotations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_quotation_details_insert AFTER INSERT ON quotation_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('quotation_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_quotation_details_update AFTER UPDATE ON quotation_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('quotation_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_quotation_details_delete AFTER DELETE ON quotation_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('quotation_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_roles_insert AFTER INSERT ON roles
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('roles', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_roles_update AFTER UPDATE ON roles
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('roles', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_roles_delete AFTER DELETE ON roles
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('roles', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_role_has_permissions_insert AFTER INSERT ON role_has_permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'role_has_permissions',
      CONCAT('permission_id:', NEW.permission_id, '|role_id:', NEW.role_id),
         'INSERT',
          NOW());
          END IF;
END$$

CREATE TRIGGER after_role_has_permissions_update AFTER UPDATE ON role_has_permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'role_has_permissions',
          CONCAT('permission_id:', NEW.permission_id, '|role_id:', NEW.role_id),
         'UPDATE',
          NOW());
          END IF;
END$$

CREATE TRIGGER after_role_has_permissions_delete AFTER DELETE ON role_has_permissions
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN

    INSERT INTO sync_logs (table_name, pivot_values, operation, updated_at)
    VALUES (
        'role_has_permissions',
         CONCAT('permission_id:', OLD.permission_id, '|role_id:', OLD.role_id),
         'DELETE',
          NOW()
          );
          END IF;
END$$

DELIMITER $$

CREATE TRIGGER after_sales_returns_insert AFTER INSERT ON sales_returns
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_returns', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_sales_returns_update AFTER UPDATE ON sales_returns
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_returns', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_sales_returns_delete AFTER DELETE ON sales_returns
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_returns', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_sales_return_details_insert AFTER INSERT ON sales_return_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_return_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_sales_return_details_update AFTER UPDATE ON sales_return_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_return_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_sales_return_details_delete AFTER DELETE ON sales_return_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_return_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_sales_return_locations_insert AFTER INSERT ON sales_return_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_return_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_sales_return_locations_update AFTER UPDATE ON sales_return_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_return_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_sales_return_locations_delete AFTER DELETE ON sales_return_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sales_return_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_sale_prices_insert AFTER INSERT ON sale_prices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sale_prices', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_sale_prices_update AFTER UPDATE ON sale_prices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sale_prices', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_sale_prices_delete AFTER DELETE ON sale_prices
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sale_prices', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_spec_breaks_insert AFTER INSERT ON spec_breaks
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('spec_breaks', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_spec_breaks_update AFTER UPDATE ON spec_breaks
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('spec_breaks', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_spec_breaks_delete AFTER DELETE ON spec_breaks
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('spec_breaks', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_sst_percentages_insert AFTER INSERT ON sst_percentages
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sst_percentages', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_sst_percentages_update AFTER UPDATE ON sst_percentages
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sst_percentages', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_sst_percentages_delete AFTER DELETE ON sst_percentages
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('sst_percentages', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_stock_relocations_insert AFTER INSERT ON stock_relocations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_relocations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_stock_relocations_update AFTER UPDATE ON stock_relocations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_relocations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_stock_relocations_delete AFTER DELETE ON stock_relocations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_relocations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_stock_relocation_details_insert AFTER INSERT ON stock_relocation_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_relocation_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_stock_relocation_details_update AFTER UPDATE ON stock_relocation_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_relocation_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_stock_relocation_details_delete AFTER DELETE ON stock_relocation_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_relocation_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_suppliers_insert AFTER INSERT ON suppliers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('suppliers', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_suppliers_update AFTER UPDATE ON suppliers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('suppliers', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_suppliers_delete AFTER DELETE ON suppliers
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('suppliers', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_supplier_lead_times_insert AFTER INSERT ON supplier_lead_times
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_lead_times', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_lead_times_update AFTER UPDATE ON supplier_lead_times
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_lead_times', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_lead_times_delete AFTER DELETE ON supplier_lead_times
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_lead_times', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_supplier_rankings_insert AFTER INSERT ON supplier_rankings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_rankings', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_rankings_update AFTER UPDATE ON supplier_rankings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_rankings', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_rankings_delete AFTER DELETE ON supplier_rankings
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_rankings', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_supplier_shipping_locations_insert AFTER INSERT ON supplier_shipping_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_shipping_locations', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_shipping_locations_update AFTER UPDATE ON supplier_shipping_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_shipping_locations', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_shipping_locations_delete AFTER DELETE ON supplier_shipping_locations
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_shipping_locations', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_supplier_shipping_modes_insert AFTER INSERT ON supplier_shipping_modes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_shipping_modes', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_shipping_modes_update AFTER UPDATE ON supplier_shipping_modes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_shipping_modes', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_supplier_shipping_modes_delete AFTER DELETE ON supplier_shipping_modes
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('supplier_shipping_modes', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_transfer_requests_insert AFTER INSERT ON transfer_requests
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_requests', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_requests_update AFTER UPDATE ON transfer_requests
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_requests', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_requests_delete AFTER DELETE ON transfer_requests
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_requests', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_transfer_request_details_insert AFTER INSERT ON transfer_request_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_details', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_request_details_update AFTER UPDATE ON transfer_request_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_details', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_request_details_delete AFTER DELETE ON transfer_request_details
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_details', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_transfer_request_issues_insert AFTER INSERT ON transfer_request_issues
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_issues', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_request_issues_update AFTER UPDATE ON transfer_request_issues
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_issues', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_request_issues_delete AFTER DELETE ON transfer_request_issues
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_issues', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_transfer_request_receives_insert AFTER INSERT ON transfer_request_receives
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_receives', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_request_receives_update AFTER UPDATE ON transfer_request_receives
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_receives', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_transfer_request_receives_delete AFTER DELETE ON transfer_request_receives
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('transfer_request_receives', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_type_of_products_insert AFTER INSERT ON type_of_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('type_of_products', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_type_of_products_update AFTER UPDATE ON type_of_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('type_of_products', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_type_of_products_delete AFTER DELETE ON type_of_products
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('type_of_products', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_type_of_rejections_insert AFTER INSERT ON type_of_rejections
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('type_of_rejections', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_type_of_rejections_update AFTER UPDATE ON type_of_rejections
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('type_of_rejections', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_type_of_rejections_delete AFTER DELETE ON type_of_rejections
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('type_of_rejections', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_units_insert AFTER INSERT ON units
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('units', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_units_update AFTER UPDATE ON units
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('units', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_units_delete AFTER DELETE ON units
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('units', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_users_insert AFTER INSERT ON users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('users', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_users_update AFTER UPDATE ON users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('users', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_users_delete AFTER DELETE ON users
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('users', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;

DELIMITER $$

CREATE TRIGGER after_verify_status_lls_insert AFTER INSERT ON verify_status_lls
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('verify_status_lls', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_verify_status_lls_update AFTER UPDATE ON verify_status_lls
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('verify_status_lls', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_verify_status_lls_delete AFTER DELETE ON verify_status_lls
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('verify_status_lls', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;



DELIMITER $$

CREATE TRIGGER after_verify_status_svs_insert AFTER INSERT ON verify_status_svs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('verify_status_svs', NEW.id, 'INSERT', NOW());
    END IF;
END$$

CREATE TRIGGER after_verify_status_svs_update AFTER UPDATE ON verify_status_svs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('verify_status_svs', NEW.id, 'UPDATE', NOW());
    END IF;
END$$

CREATE TRIGGER after_verify_status_svs_delete AFTER DELETE ON verify_status_svs
FOR EACH ROW
BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('verify_status_svs', OLD.id, 'DELETE', NOW());
    END IF;
END$$

DELIMITER ;  


DELIMITER $$

CREATE TRIGGER `after_stock_adjustment_details_delete` AFTER DELETE ON `stock_adjustment_details`
 FOR EACH ROW BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_adjustment_details', OLD.id, 'DELETE', NOW());
        END IF;
END

CREATE TRIGGER `after_stock_adjustment_details_insert` AFTER INSERT ON `stock_adjustment_details`
 FOR EACH ROW BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_adjustment_details', NEW.id, 'INSERT', NOW());
        END IF;
END

CREATE TRIGGER `after_stock_adjustment_details_update` AFTER UPDATE ON `stock_adjustment_details`
 FOR EACH ROW BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_adjustment_details', NEW.id, 'UPDATE', NOW());
        END IF;
END


DELIMITER ;  



DELIMITER $$

CREATE TRIGGER `after_stock_adjustments_delete` AFTER DELETE ON `stock_adjustments`
 FOR EACH ROW BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_adjustments', OLD.id, 'DELETE', NOW());
        END IF;
END

CREATE TRIGGER `after_stock_adjustments_insert` AFTER INSERT ON `stock_adjustments`
 FOR EACH ROW BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_adjustments', NEW.id, 'INSERT', NOW());
        END IF;
END

CREATE TRIGGER `after_stock_adjustments_update` AFTER UPDATE ON `stock_adjustments`
 FOR EACH ROW BEGIN
    IF @sync_in_progress IS NULL OR @sync_in_progress = 0 THEN
    INSERT INTO sync_logs (table_name, record_id, operation, updated_at)
    VALUES ('stock_adjustments', NEW.id, 'UPDATE', NOW());
        END IF;
END

DELIMITER ;