CREATE TABLE [dbo].[Forum_Users]
(
[UserID] [int] NOT NULL,
[Signature] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserAvatar] [int] NULL CONSTRAINT [DF_Forum_Users_UseAvatar] DEFAULT ((0)),
[Avatar] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdditionalAvatars] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostCount] [int] NULL CONSTRAINT [DF_Forum_Users_PostCount] DEFAULT ((0)),
[LastActivity] [datetime] NULL CONSTRAINT [DF_Forum_Users_LastActivity] DEFAULT (((1)/(1))/(2001)),
[IsTrusted] [bit] NULL CONSTRAINT [DF_Forum_Users_IsTrusted] DEFAULT ((0)),
[EnableOnlineStatus] [bit] NULL CONSTRAINT [DF_Forum_Users_EnableOnlineStatus] DEFAULT ((1)),
[ThreadsPerPage] [int] NULL,
[PostsPerPage] [int] NULL,
[ViewDescending] [bit] NULL CONSTRAINT [DF_Forum_Users_ViewDescending] DEFAULT ((0)),
[EnableModNotification] [bit] NULL,
[EmailFormat] [int] NOT NULL CONSTRAINT [DF_Forum_Users_EmailFormat] DEFAULT ((1)),
[PortalID] [int] NOT NULL,
[EnablePublicEmail] [bit] NOT NULL CONSTRAINT [DF_Forum_Users_EnablePublicEmail] DEFAULT ((0)),
[TrackingDuration] [int] NOT NULL CONSTRAINT [DF_Forum_Users_TrackingDuration] DEFAULT ((1000)),
[LockTrust] [bit] NOT NULL CONSTRAINT [DF_Forum_Users_LockTrust] DEFAULT ((0)),
[IsBanned] [bit] NOT NULL CONSTRAINT [DF_Forum_Users_IsBanned] DEFAULT ((0)),
[LiftBanDate] [datetime] NULL,
[EnableSelfNotifications] [bit] NOT NULL CONSTRAINT [DF_Forum_Users_EnableSelfNotifications] DEFAULT ((0)),
[EnableProfileWeb] [bit] NOT NULL CONSTRAINT [DF_Forum_Users_EnableProfileWeb] DEFAULT ((1)),
[EnableDefaultPostNotify] [bit] NOT NULL CONSTRAINT [DF_Forum_Users_EnableDefaultPostNotify] DEFAULT ((1)),
[StartBanDate] [datetime] NULL
) ON [PRIMARY]

GO