CREATE TABLE [dbo].[Contact]
(
[ContactID] [int] NOT NULL IDENTITY(1, 1),
[Name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Title] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhoneNr] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PasswordFormat] [int] NULL,
[PasswordHashAlgorithm] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PasswordSalt] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsApproved] [bit] NOT NULL,
[CreationDate] [datetime] NOT NULL,
[LastLoginDate] [datetime] NULL,
[LastPasswordChangedDate] [datetime] NULL,
[FailedPasswordAttemptCount] [int] NOT NULL,
[FailedPasswordAttemptWindowStart] [datetime] NULL,
[Comment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserPermissionsID] [int] NOT NULL CONSTRAINT [DF_Contact_UserPermissionsID] DEFAULT ((5)),
[PreferredLCID] [smallint] NOT NULL CONSTRAINT [DF_Contact_PreferredLCID] DEFAULT ((1033)),
[HasAcceptedTermsAndConditions] [bit] NOT NULL CONSTRAINT [DF_Contact_HasAcceptedTermsAndConditions] DEFAULT ((0)),
[HasAcknowledgedServerMaintenance] [bit] NOT NULL CONSTRAINT [DF_Contact_HasAcknowledgedServerMaintenance] DEFAULT ((0)),
[StartupTutorialEnabled] [bit] NOT NULL CONSTRAINT [DF_Contact_StartupTutorialEnabled] DEFAULT ((1)),
[IncludeHierarchy] [bit] NOT NULL CONSTRAINT [DF_Contact_IncludeHierarchy] DEFAULT ((0)),
[UseDetailedAccountSelector] [bit] NOT NULL CONSTRAINT [DF_Contact_UseDetailedAccountSelector] DEFAULT ((0)),
[State] [smallint] NOT NULL CONSTRAINT [DF_Contact_State] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contact] ADD CONSTRAINT [PK_Contact_ContactID] PRIMARY KEY CLUSTERED ([ContactID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contact] ADD CONSTRAINT [FK_Contact_UserPermissionsID_UserPermissions_UserPermissionsID] FOREIGN KEY ([UserPermissionsID]) REFERENCES [dbo].[UserPermissions] ([UserPermissionsID])
GO