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