if not exists (select * from sys.tables where object_id = object_id(N'dbo.UserInfoHistory'))
    create table dbo.UserInfoHistory
    (
        ID int not null IDENTITY(1, 1) constraint PK_UserInfoHistory primary key 
        ,HistoryType char(1) not null
        ,UserInfoID uniqueidentifier not null
        ,ModifiedDate datetime not null
        ,ModifiedUserName nvarchar(256) null
        ,ModifiedLoggedUserName nvarchar(256) null
        ,Data nvarchar(max) null
    )