update schema with confirmed_registration field