add default value 1 to generation number column