DELIMITER $$

DROP TRIGGER `tablename_bi`$$

CREATE TRIGGER `tablename_bi` BEFORE INSERT ON `patients_notes`

	FOR EACH ROW BEGIN

	SET NEW.inserted = ifnull(NEW.inserted, now());

	SET NEW.insertedby = ifnull(NEW.insertedby, username());

	END$$

DELIMITER ;