CREATE TABLE ai(
	ID 				INT UNSIGNED NOT NULL AUTO_INCREMENT,
	NAME			VARCHAR(16),
		PRIMARY KEY(ID)
) ENGINE = InnoDB;

DROP TABLE IF EXISTS uid;

CREATE TABLE uid(
	UID 			BINARY(16),
	NAME			VARCHAR(16),
		PRIMARY KEY(UID)
) ENGINE = InnoDB;

DELIMITER //
CREATE TRIGGER UUID_TEST BEFORE INSERT ON uid FOR EACH ROW
BEGIN
  	SET NEW.UID = UNHEX(REPLACE(UUID(), "-", ""));
END//
DELIMITER ;