if not exists (select name from sys.objects where type_desc = 'DEFAULT_CONSTRAINT' and name = 'DF_UserInfo_ModifiedDate') and exists (select * from sys.tables where object_id = object_id(N'dbo.UserInfo'))
    alter table dbo.UserInfo add constraint DF_UserInfo_ModifiedDate DEFAULT getdate() for ModifiedDate;