Table Icon dbo.Users

Table Properties

Name Value
Owner dbo
Created 2004-05-31
Located On PRIMARY
Rows 1
Data Size KB 8
Index Size KB 64

Columns

  Name Description Data Type Length NULL Default RowGUIDCOL Computed
Primary Key UserName nvarchar 50      
Identity UserId int 4      
  ScreenName nvarchar 50 Nullable    
  Password nvarchar 50      
  Email nvarchar 75      
  ForumView int 4      
  ProfileApproved bit 1      
  Approved bit 1      
  Trusted bit 1      
  FakeEmail nvarchar 75      
  URL nvarchar 100      
  Signature nvarchar 256 Nullable    
  DateCreated datetime 8      
  TrackYourPosts bit 1      
  LastLogin datetime 8      
  LastActivity datetime 8      
  TimeZone int 4      
  Location nvarchar 100      
  Occupation nvarchar 100      
  Interests nvarchar 100      
  MSN nvarchar 50      
  Yahoo nvarchar 50      
  AIM nvarchar 50      
  ICQ nvarchar 50      
  TotalPosts int 4      
  HasAvatar bit 1      
  ShowUnreadTopicsOnly bit 1      
  Style nvarchar 20      
  ShowAvatar bit 1      
  DateFormat nvarchar 10      
  PostViewOrder bit 1      
  FlatView bit 1      
  DisplayInMemberList bit 1      
  AvatarUrl nvarchar 256      
  AvatarType int 4      
  Attributes binary 4      

Total: 36 column(s)

Indentity Column

Name Seed Increment Not for Replication
UserId 1 1  

Check Constraints

No check constraints exists

Indexes

Index Primary Unique Clustered
PK_Users Primary Key Unique Index Clustered Index
IX_Users_UniqueEmail   Unique Index  
IX_Users      
IX_Users_1      

Permissions

No direct permissions defined (N.B. Permissions may be inherited from roles

SQL

CREATE TABLE [Users] (
	[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[UserId] [int] IDENTITY (1, 1) NOT NULL ,
	[ScreenName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Email] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ForumView] [int] NOT NULL CONSTRAINT [DF_Users_ForumView] DEFAULT (2),
	[ProfileApproved] [bit] NOT NULL CONSTRAINT [DF_Users_ProfileApproved] DEFAULT (1),
	[Approved] [bit] NOT NULL CONSTRAINT [DF_Users_Approved] DEFAULT (1),
	[Trusted] [bit] NOT NULL CONSTRAINT [DF_Users_Trusted] DEFAULT (0),
	[FakeEmail] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_FakeEmail] DEFAULT (''),
	[URL] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_URL] DEFAULT (''),
	[Signature] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Users_Signature] DEFAULT (''),
	[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_Users_DateCreated] DEFAULT (getdate()),
	[TrackYourPosts] [bit] NOT NULL CONSTRAINT [DF_Users_TrackYourPosts] DEFAULT (0),
	[LastLogin] [datetime] NOT NULL CONSTRAINT [DF_Users_LastLogin] DEFAULT (getdate()),
	[LastActivity] [datetime] NOT NULL CONSTRAINT [DF_Users_LastActivity] DEFAULT (getdate()),
	[TimeZone] [int] NOT NULL CONSTRAINT [DF_Users_TimeZone] DEFAULT ((-5)),
	[Location] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Location] DEFAULT (''),
	[Occupation] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Occupation] DEFAULT (''),
	[Interests] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Interests] DEFAULT (''),
	[MSN] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_MSN] DEFAULT (''),
	[Yahoo] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Yahoo] DEFAULT (''),
	[AIM] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_AIM] DEFAULT (''),
	[ICQ] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_ICQ] DEFAULT (''),
	[TotalPosts] [int] NOT NULL CONSTRAINT [DF_Users_TotalPosts] DEFAULT (0),
	[HasAvatar] [bit] NOT NULL CONSTRAINT [DF_Users_HasAvatar] DEFAULT (0),
	[ShowUnreadTopicsOnly] [bit] NOT NULL CONSTRAINT [DF_Users_ShowUnreadTopicsOnly] DEFAULT (0),
	[Style] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Style_1] DEFAULT (N'default'),
	[ShowAvatar] [bit] NOT NULL CONSTRAINT [DF_Users_ShowAvatar] DEFAULT (0),
	[DateFormat] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_DateFormat] DEFAULT (N'MM-dd-yyyy'),
	[PostViewOrder] [bit] NOT NULL CONSTRAINT [DF_Users_PostViewOrder] DEFAULT (0),
	[FlatView] [bit] NOT NULL CONSTRAINT [DF_Users_FlatView] DEFAULT (1),
	[DisplayInMemberList] [bit] NOT NULL CONSTRAINT [DF_Users_DisplayInMemberList] DEFAULT (1),
	[AvatarUrl] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Users__AvatarUrl__6D6238AF] DEFAULT (''),
	[AvatarType] [int] NOT NULL CONSTRAINT [DF__Users__AvatarTyp__6E565CE8] DEFAULT (1),
	[Attributes] [binary] (4) NOT NULL CONSTRAINT [DF_Users_Attributes] DEFAULT (0),
	CONSTRAINT [PK_Users] PRIMARY KEY  CLUSTERED 
	(
		[UserName]
	)  ON [PRIMARY] ,
	CONSTRAINT [IX_Users_UniqueEmail] UNIQUE  NONCLUSTERED 
	(
		[Email]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO



					

Generated on 26/08/2004 15:05:24 by DataAide.