if not exists (select * FROM sys.sysobjects where id = object_id(N'dbo.UserAccount'))
    create table dbo.UserAccount
    (
        ID uniqueidentifier not null constraint PK_UserAccount PRIMARY KEY CLUSTERED
        ,FullName nvarchar(100) null
        ,ConnectionOverrides nvarchar(max) null
        ,IsTemplate bit not null constraint DF_UserAccount_IsTemplate default (0)
        ,Email nvarchar(200) null
        ,IsOwner bit not null constraint DF_UserAccount_IsOwner default (0)
        ,Password nvarchar(128) null
        ,PasswordSalt nvarchar(128) null
        ,LastLoginDate datetime null
        ,LastPasswordChangedDate datetime null
        ,PersonalConnectionCacheID varchar(100) null
        ,PersonalConnections nvarchar(max) null
        ,Data nvarchar(max) null
        ,CreationDate datetime not null constraint DF_UserAccount_CreationDate default (getdate())
        ,CreatedByUserName nvarchar(256) null
        ,CreatedByLoggedUserName nvarchar(256) null
        ,ModifiedDate datetime null constraint DF_UserAccount_ModifiedDate default (getdate())
        ,ModifiedUserName nvarchar(256) null
        ,ModifiedLoggedUserName nvarchar(256) null
    )