sql

-- generate alter table to change default values on columns from previous MySQL version
select 
-- TABLE_NAME, COLUMN_NAME,
-- column_type,
 concat('ALTER TABLE ', table_name, ' CHANGE ', COLUMN_NAME, ' ', COLUMN_NAME, ' ', column_type,' NOT NULL DEFAULT ',if( COLUMN_DEFAULT = '0000-00-00', "'1000-01-01';", "'1000-01-01 00:00:00';")) alt
from information_schema.columns
where table_schema = 'sourcedb'
and COLUMN_DEFAULT in ('0000-00-00 00:00:00', '0000-00-00')
order by table_name