Just do something! It's just getting started and skillful. Create a BBS this time to implement the most basic functions
Tool: Asp. net2.0 + sqlserver2005 took a look at the functions and databases today and referred to others. It is simple to implement the most basic functions.
Addon BBS
**************************************** ************************************ *********
$
Super administrator $ General Administrator (bamboo) $ general user
-- | -- Delete user $ -- | -- modifyArticle $ -- | -- Post
| -- Modify user information $ | -- add an excellent article $ | -- modify an article
| -- Delete layout $ | -- top an article $ | -- modify Personal Data
| -- Add layout $ | --
| -- Modify layout $ | --
| -- Delete an article $ | --
| -- $
$
**************************************** * ** Database ************************************ ********
User table (forumusertab) Article table (forumarticletab)
-- | -- User ID (usernameid) -- | -- Article ID (ArticleID)
| -- Username | -- article title (articlename)
| -- Nickname (usernickname) | -- Article category (articleclass)
| -- Password | -- author (articleauthor)
| -- Userclass | -- article content (articlecontent)
| -- Email (useremail) | -- post time)
| -- MSN (usermsn) | -- Post IP (articlepostip)
| -- QQ (userqq) | -- layout (articleboardid)
| -- Avatar (userhead) | -- clicks (articlehits)
| -- Signature (usersign) | -- determines whether to stick to the top (articleistop)
| -- Gender (usersex) | -- whether it is articleisgood)
| -- Homepage (userhomepage) | --
| -- Registration time (userregtime) | --
| -- Register an IP address (userregip) | --
| -- Userlogintimes | --
| -- Last Logon Time (userlastlogintime) | --
| -- Last Logon IP address (userlastloginip) | --
| -- Whether to restrict posting (userlocked) | --
| -- Total number of posts (userarticles) | --
| --
Forumboardtab)
-- | -- Layout ID (boardid) -- | -- reply ID (replyid)
| -- Layout name (boardname) | -- Article ID (replyarticleid)
| -- Layout class | -- article title (replyarticlename)
| -- Reply content (replycontent)
| -- Reply to the author (replyauthor)
| -- Reply time (replytime)
| -- Reply IP (replyip)
| --
BBS info table (foruminfotab)
-- | -- BBS info table ID (foruminfoid)
| -- Copyright (foruminfocopyright)
| -- Version (foruminfoversionnumber)
| -- BBS name (foruminfobbsname)
| -- URL (foruminfourl)
| -- Email (foruminfoemail)
| -- Foruminfomaxpeople)
| -- Foruminfomaxpeopletime)
| --
I probably listed the following functions and databases, and I did not expect to add them later.