According to
MySql we should use values between '1000-01-01' to '9999-12-31'
Don't use 0000-00-00 it will still give some errors in php, your birthday column should similar
PHP Code:
ALTER TABLE `users` ALTER COLUMN `birthday` SET DEFAULT '1920-01-01';