cs1.0数据表

The following is a list of tables for Community Server 1.0.

 

List of Tables
ASP.NET Membership System Tables
aspnet_Applications
aspnet_Membership
aspnet_Profile
aspnet_Roles
aspnet_SchemaVersions
aspnet_Users
aspnet_UsersInRoles
Community Server Tables
cs_AnonymousUsers
cs_ApplicationType
cs_BlockedIpAddresses
cs_Censorship
cs_CodeScheduleType
cs_CodeServiceType
cs_DisallowedNames
cs_EmailQueue
cs_Exceptions
cs_ForumPingback
cs_Groups
cs_Images	Is used only for avatars. (用户头像)
cs_LinkCategories
cs_Links
cs_Messages
cs_ModerationAction
cs_ModerationAudit
cs_Moderators
cs_nntp_Newsgroups
cs_nntp_Posts
cs_Post_Categories
cs_PostAttachments	This is where the picture is stored, if file system storage is disabled. Even if you have filesystem storage enabled, it still creates an entry here. Gives quick access to stuff like mimetype, filesize, original filename, etc.
cs_PostEditNotes
cs_PostMetadata	This is where all the EXIF data that is read out of the image is stored.
cs_PostRating
cs_Posts	Picture subject/title/post info. When ParentID = PostID, it is the first post, otherwise, it is a comment on the picture.
cs_Posts_InCategories
cs_PostsArchive
cs_PrivateMessages
cs_ProductPermissions
cs_Ranks
cs_Referrals
cs_Reports
cs_SchemaVersion
cs_SearchBarrel
cs_SearchIgnoreWords
cs_SectionPermissions
cs_Sections
cs_SectionsRead
cs_Services
cs_ServiceSchedule
cs_SiteMappings
cs_Sites
cs_SiteSettings
cs_Smilies
cs_statistics_Site
cs_statistics_User
cs_Styles
cs_Threads	Basic info on the start of a thread/picture posting. It is often used for listings because it is a smaller table than cs_Posts and has better indexes.
cs_ThreadsRead
cs_TrackedSections
cs_TrackedThreads
cs_Urls
cs_UserAvatar
cs_UserProfile
cs_Users
cs_UsersOnline
cs_Version
cs_Votes
cs_VoteSummary
cs_weblog_Posts
cs_weblog_Weblogs