alter table user
  modify column passworddate date not null default '1900-01-01',
  modify column birthday_search date not null default '1900-01-01';

update user set birthday_search = '1901-01-01' where DATE_FORMAT(birthday_search,'%Y-%m-%d') = '0000-00-00';