*************************** 1. row ***************************
             Trigger: sc_account_INSERT
               Event: INSERT
               Table: account
           Statement: BEGIN
IF (@DISABLE_TRIGGER IS NULL) THEN
  INSERT INTO `sc_account` SET
    `referenceId`=`NEW`.`id`,
    `action`='INSERT',
    `value_status`=`NEW`.`status`,
    `value_servicetyp`=`NEW`.`servicetyp`,
    `value_price`=`NEW`.`price`,
    `fieldsChanged`='status,servicetyp,price',
    `time`=NOW();
END IF;
END
              Timing: AFTER
             Created: NULL
            sql_mode: 
             Definer: OURDB@10.255.0.4
character_set_client: utf8mb4
collation_connection: utf8mb4_unicode_ci
  Database Collation: utf8_unicode_ci
*************************** 2. row ***************************
             Trigger: sc_account_UPDATE
               Event: UPDATE
               Table: account
           Statement: BEGIN
DECLARE __tmp__ VARCHAR(4096);
IF (@DISABLE_TRIGGER IS NULL) THEN
  SET __tmp__=CONCAT_WS(',',IF(`NEW`.`status`<=>`OLD`.`status`,NULL,"status"),IF(`NEW`.`servicetyp`<=>`OLD`.`servicetyp`,NULL,"servicetyp"),IF(`NEW`.`price`<=>`OLD`.`price`,NULL,"price"));
  IF (__tmp__!='') THEN
    INSERT INTO `sc_account` SET
      `referenceId`=`NEW`.`id`,
      `action`='UPDATE',
      `value_status`=IF(`NEW`.`status` <=> `OLD`.`status`,NULL,`NEW`.`status`),
      `value_servicetyp`=IF(`NEW`.`servicetyp` <=> `OLD`.`servicetyp`,NULL,`NEW`.`servicetyp`),
      `value_price`=IF(`NEW`.`price` <=> `OLD`.`price`,NULL,`NEW`.`price`),
      `fieldsChanged`=__tmp__,
      `time`=NOW();
  END IF;
END IF;
END
              Timing: AFTER
             Created: NULL
            sql_mode: 
             Definer: OURDB@10.255.0.4
character_set_client: utf8mb4
collation_connection: utf8mb4_unicode_ci
  Database Collation: utf8_unicode_ci