I found bug related to db update script for column default value.
Although once I exexuted the script on the database:
ALTER TABLE SchemaVersion alter column UpdateUser set default current_user;
and it correctly set the field.
When I try to sync with the database and once again generate the update script it generates the same. Although there was no changes.