create the mysql column for verified incrementally, same as postgresql