For a Universally Unique Identifier in MariaDB


Create the field
   PersonUUID varchar(32)

Then create a trigger

NAVICAT:
Create the trigger
   OnInsertPersonsUUID
   BEFORE INSERT
   SET new.PersonUUID = UUID()


CONSOLE:
CREATE TRIGGER OnInsertPersonsUUID
  BEFORE INSERT ON Persons
  FOR EACH ROW
  SET new.PersonUUID = UUID();