seanbehan · March 11, 2018 21:39
diff --git a/mysql-uuid-trigger.sql b/mysql-uuid-trigger.sql
 -- if uuid is set use that, otherwise create uuid

 create trigger trigger_defaults_on_users 
  before insert on users 
  for each row 
    set new.uuid = coalesce(nullif(new.uuid, ''), uuid())
 ;
	-- if uuid is set use that, otherwise create uuid

	create trigger trigger_defaults_on_users
	before insert on users
	for each row
	set new.uuid = coalesce(nullif(new.uuid, ''), uuid())
	;