   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 ,
+    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,

use pcr;

use pcr;

drop trigger if exists after_patient_insert;

  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 = 1,
      table_id = 8,
