Table Icon dbo.forums_User

View Properties

Name Value
Owner dbo
Created 2004-05-31

Columns

Name Data Type Length
AIM nvarchar 50
Approved bit 1
Attributes binary 4
AvatarType int 4
AvatarUrl nvarchar 256
DateCreated datetime 8
DateFormat nvarchar 10
Email nvarchar 75
FakeEmail nvarchar 75
FlatView bit 1
ForumView int 4
HasAvatar bit 1
ICQ nvarchar 50
Interests nvarchar 100
IsModerator int 4
LastActivity datetime 8
LastLogin datetime 8
Location nvarchar 100
MSN nvarchar 50
Occupation nvarchar 100
Password nvarchar 50
PostViewOrder bit 1
ProfileApproved bit 1
ShowAvatar bit 1
ShowUnreadTopicsOnly bit 1
Signature nvarchar 256
Style nvarchar 20
TimeZone int 4
TotalPosts int 4
TrackYourPosts bit 1
Trusted bit 1
URL nvarchar 100
UserName nvarchar 50
Yahoo nvarchar 50

Total: 34 column(s)

SQL

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


CREATE VIEW forums_User
AS
    SELECT
        UserName,
        Password, 
        Email, 
        ForumView, 
        Approved, 
        ProfileApproved, 
        Trusted, 
        FakeEmail, 
        URL, 
        Signature, 
        DateCreated, 
        TrackYourPosts, 
        LastLogin, 
        LastActivity, 
        TimeZone, 
        Location, 
        Occupation, 
        Interests, 
        MSN, 
        Yahoo, 
        AIM, 
        ICQ, 
        TotalPosts, 
        HasAvatar, 
        ShowUnreadTopicsOnly, 
        Style, 
        AvatarType, 
        ShowAvatar, 
        DateFormat, 
        PostViewOrder,
        AvatarUrl,
        (
            SELECT COUNT(*)
            FROM Moderators
            WHERE Moderators.Username = Users.Username
        ) AS IsModerator,
        FlatView,
        Attributes
    FROM Users

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


					

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