fix default value for new column as autogenerate SQL was missing default 0

https://github.com/apache/airflow/pull/34335