if not exists (select * from sys.tables where object_id = object_id(N'dbo.DepartmentHistory'))
    create table dbo.DepartmentHistory
    (
        ID int not null IDENTITY(1, 1) constraint PK_DepartmentHistory primary key 
        ,HistoryType char(1) not null
        ,DepartmentID uniqueidentifier not null
        ,Name nvarchar(256) not null
        ,Description nvarchar(256) null
        ,ModifiedDate datetime not null
        ,ModifiedUserName nvarchar(256) null
        ,ModifiedLoggedUserName nvarchar(256) null
    )