-use pcr;
-
 use pcr;
 
 drop trigger if exists after_patient_insert;

  END$$
DELIMITER ;


  FOR EACH ROW
  BEGIN
    INSERT INTO event_log
    set organisation_id = OLD.organisation_id,
      entry_date = now(),
      entered_by_practitioner_id  = OLD.entered_by_practitioner_id,
      device_id = 0,
      entry_mode = 0,
      table_id = 8,
