Bay Six Software Forum Index Bay Six Software
Beyond the Basics
 
 FAQFAQ   SearchSearch   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Working on the DB structure

 
Post new topic   Reply to topic    Bay Six Software Forum Index -> SapientBoard
View previous topic :: View next topic  
Author Message
Brent
Site Admin


Joined: 01 Jul 2005
Posts: 800

PostPosted: Apr 1st, 2009, 9:34am    Post subject: Working on the DB structure Reply with quote

  1. board
    • boardLangID
    • boardSkinID
    • boardTitle
    • boardDescription
    • boardDomain
    • boardDirectory
    • boardLocked
    • maxTopicsPerPage
    • maxPostsPerPage
    • maxUsersPerPage
    • boardTimeZone
    • boardDateFormat
    • boardCreationDate
    • boardVersion
    • boardLastPostDate
    • maxUnreadPerUser
    • maxPostSize
    • maxPmsPerUser
    • boardRobotFriendly
  2. sessions
    • userID
    • sessionID
    • adminSID
    • lastIP
    • lastTime
    • clientHash
  3. users
    • userID
    • username
    • password
    • email
    • langID
    • skinID
    • rankID
    • avatarURL
    • signature
    • signupDate
    • lastVisitDate
    • posts
    • visibility
    • lastAccessDate
    • bookmarksVisible
    • dateFormat
    • timeZone
    • emailVisible
    • allowPms
  4. annotations
    • userID
    • ownerUserID
    • noteText
  5. profileCats
    • catID
    • catTitle
    • visInSignup
    • visInProfile
    • required
    • allowHidden
    • catOrder
  6. profileData
    • dataID
    • ownerCatID
    • label
    • description
    • dataType
    • showataInSignup
    • showInProfile
    • skinVariable
    • required
    • requiredDataID
    • defaultDataID
    • allowHidden
    • dataOrder
  7. profileTexts
    • dataID
    • userID
    • textData
    • visible
  8. profileURLs
    • dataID
    • userID
    • URLData
    • visible
  9. profileDates
    • dataID
    • userID
    • dateData
    • visible
  10. profileBooleans
    • dataID
    • userID
    • booleanData
    • visible
  11. userBans
    • userID
    • ownerUserID
    • startDate
    • endData
    • reason
  12. ignores
    • userID
    • ownerUserID
  13. watches
    • userID
    • watchedID
    • watchType
  14. langs
    • langID
    • langName
    • langFile
    • available
  15. skins
    • skinID
    • skinName
    • skinFile
    • available
  16. ranks
    • rankID
    • title
    • imageURL
    • minPosts
  17. groups
    • groupID
    • ownerUserID
    • title
    • description
    • visible
  18. underlings
    • userID
    • groupID
    • memberStatus
  19. indexCats
    • catID
    • title
    • catOrder
  20. forums
    • forumID
    • ownerCatID
    • ownerForumID
    • modGroupID
    • title
    • description
    • topicCount
    • postCount
    • creditUserPosts
    • forumOrder
    • forumLocked
    • botsIndexForum
    • botsIndexTopics
  21. topics
    • topicID
    • ownerForumID
    • ownerUserID
    • lastPostID
    • topicSubject
    • topicPosts
    • topicType
    • topicLocked
  22. posts
    • postID
    • ownerTopicID
    • ownerUserID
    • replyToPostID
    • creationDate
    • lastEditDate
    • editCount
    • postSubject
    • message
    • posterIP
  23. unread
    • userID
    • topicID
  24. personals
    • recipientUserID
    • senderUserIs
    • senderIP
    • subject
    • sentDate
    • statusRecipient
    • statusSender
    • message
  25. bookmarks
    • ownerUserID
    • topicID
    • description
  26. robots
    • robotID
    • robotName
    • robotAllowed
  27. robotIPs
    • robotID
    • ipStart
    • ipEnd
  28. modActions
    • modUserID
    • actDate
    • actType
    • actedOnID
    • ownerUserID
    • description

_________________
Brent
Back to top
View user's profile Send private message Send e-mail
Brent
Site Admin


Joined: 01 Jul 2005
Posts: 800

PostPosted: Apr 4th, 2009, 5:02am    Post subject: Re: Working on the DB structure Reply with quote

Changed most names, added new tables "sessions" and "modActions."
_________________
Brent
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Bay Six Software Forum Index -> SapientBoard All times are GMT
Page 1 of 1
Jump to:  
Quick Reply
Username:
Message:
   Shortcut keys: Alt+Q to activate, Alt+P to preview, Alt+S to submit
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum



Lo-Fi Version
Powered by phpBB © 2001, 2005 phpBB Group