ACL AnnounceRead Announces ForumWatch Forums GroupMembers GroupNames Guests PollUsers PollVotes Posts Stat ThreadWatch Threads UserForumFlags UsersTable: ACL 
Access Control List (ACL): Contains all access rules
Column name |
Data type |
Description |
| ID | int unsigned | Access rule ID |
| Action | smallint unsigned | Access right identifier 1...19: Global boolean rights 21...29: Global numeric rights 31...59: Limited boolean rights 61...79: Limited numeric rights 81...89: Rights collections >90: Reserved for custom extensions |
| Forum | int unsigned | Forum ID this rule relates to |
| Thread | int unsigned | Thread ID this rule relates to |
| Grant | int | Grant option (0/1) or numeric value |
| Group | int unsigned | User group |
| User | int unsigned | User ID |
| Enabled | bool | Use this rule? |
Table: AnnounceRead
Stores which users have read (‘confirmed’) which announcements
| Msg | int unsigned | Message ID |
| User | int unsigned | User ID |
Table: Announces
Board announcement messages
| ID | int unsigned | Message ID |
| Forum | int | Assigned forum ID 0: overview page -1: admin_lock maintenance message |
| Date | int | Creation timestamp |
| User | int unsigned | Author user ID |
| Subject | varchar(150) | Message’s subject (optional) |
| Msg | text | Content |
| Options | int unsigned | Additional options (can be OR’ed)UNB_ANN_IMPORTANT (1):
Important announcement
UNB_ANN_RECURSIVE (2):
Recursive announcement (also display in sub-forums)
UNB_ANN_INTHREADS (4):
Also show announcement in threads
The access mask is set by two bits, masked by UNB_ANN_FOR_MASK (8|16):UNB_ANN_FOR_ALL (0):
Display for all users
UNB_ANN_FOR_GUESTS (8):
Display for guests only
UNB_ANN_FOR_USERS (16):
Display for logged in users only
UNB_ANN_FOR_MODS (24):
Display for moderators only
(These constants are defined in announce.lib.php.) |
Table: ForumWatch
Forum notifications for new threads
| Forum | int unsigned | Forum ID |
| User | int unsigned | User ID |
| Mode | tinyint unsigned | Type of notification (can be OR’ed)UNB_NOTIFY_EMAIL (1):
E-Mail
UNB_NOTIFY_JABBER (4):
Jabber
|
| Flags | tinyint unsigned | Additional options (not currently used) |
| LastVisited | int | Last forum visit timestamp |
| LastNotify | int | Last notification timestamp |
| LastViewed | int | Timestamp when the user has last viewed the thread |
Table: Forums
Forum definitions
| ID | int unsigned | Forum ID |
| Sort | int | Sort index |
| Parent | int unsigned | Forum ID this forum shall be assigned to |
| Name | varchar(100) | Display name |
| Flags | int | Additional flags (can be OR’ed)UNB_FORUM_CATEGORY (1):
Forum is a category
UNB_FORUM_WEBLINK (2):
Forum is a web link
(These constants are defined in forum.lib.php.) |
| Description | text | Additional forum description |
| Link | varchar(255) | URL to point to if the forum is a web link |
Table: GroupMembers
Users’ group memberships
| Group | int unsigned | User group ID |
| User | int unsigned | User ID |
Table: GroupNames
User group definitions
| ID | int unsigned | User group ID |
| Name | varchar(50) | Display name |
| ShowInTeam | bool | Show members of this group in the operators team? |
Table: Guests
Guests session data
| Session | varchar(80) | PHP Session ID |
| LastActivity | int | Last activity timestamp |
| LastForum | int unsigned | Last visited forum ID |
| UserName | varchar(40) | Name |
Table: PollUsers
Users that have voted in a poll
| Thread | int unsigned | Thread (poll) ID |
| User | int unsigned | User ID |
| VoteNum | int unsigned | Vote ID the user has voted (necessary for cancelling the vote) |
Table: PollVotes
Vote options to a poll
| ID | int unsigned | Vote option ID |
| Thread | int unsigned | Thread (poll) ID |
| Sort | tinyint | Sort index |
| Title | varchar(100) | Vote option title |
| Votes | int unsigned | Count of votes for this vote option |
Table: Posts
Posts
| ID | int unsigned | Post ID |
| Thread | int unsigned | Thread ID |
| ReplyTo | int unsigned | Referenced post ID |
| Date | int | Creation timestamp |
| EditUser | int unsigned | Last editing user ID |
| EditDate | int | Last editing timestamp |
| EditCount | smallint | Count of edits of this post |
| User | int unsigned | Author user ID 0: Guest -1: Former user |
| UserName | varchar(40) | User name if not a registered user |
| Subject | varchar(150) | Post’s subject |
| Msg | text | Content |
| Options | int unsigned | Additional options (can be OR’ed)UNB_POST_NOSMILIES (1):
Disable conversion of smileys to graphics
UNB_POST_NOSPECIALABBC (2):
Disable special ABBC syntax like *bold* (see ABBC_SPECIAL)
(These constants are defined in post.lib.php.) |
| AttachFile | varchar(40) | Attached local filename (post-‹id›.‹ext›) |
| AttachFileName | varchar(100) | Original filename as uploaded by user |
| AttachDLCount | int unsigned | Number of times this file has been downloaded |
| IP | varchar(15) | Author’s IP address |
| Hostname | varchar(150) | Author’s hostname, resolved from the IP address |
| SpamRating | int | Post’s spam/abuse/nonsense probability (not currently used) |
Table: Stat
Statistical data
| Date | int | Timestamp at midnight (0h) local time |
| NewThreads | int | Number of new threads |
| NewPosts | int | Number of new posts |
| OnlineUsers | int | Number of online registered users this day |
| OnlineGuests | int | Number of online guests this day |
| PageHits | int | Total number of page hits in the board |
| NewUsers | int unsigned | User registrations (can be negative when purging) |
Table: ThreadWatch
Thread notifications for new posts
| Thread | int unsigned | Thread ID |
| User | int unsigned | User ID |
| Mode | tinyint unsigned | Type of notification (can be OR’ed)UNB_NOTIFY_EMAIL (1):
E-Mail
UNB_NOTIFY_JABBER (4):
Jabber
UNB_NOTIFY_BOOKMARK (128):
Bookmark (not really a notification...)
(These constants are defined in common.lib.php.)
|
| LastRead | int | Last topic read timestamp (also used for read/unread markers) |
| LastNotify | int | Last notification timestamp |
Table: Threads
Topics
| ID | int unsigned | Thread ID |
| Forum | int unsigned | Assigned forum ID |
| LastPostDate | int | Timestamp of the last post in this thread [auto-generated] |
| Subject | varchar(150) | Display topic name |
| Desc | varchar(150) | Optional topic subtitle (description) |
| Date | int | Creation timestamp |
| User | int unsigned | Author user ID 0: Guest -1: Former user |
| UserName | varchar(40) | User name if not a registered user |
| Views | int unsigned | Number of views of this topics |
| Options | int unsigned | Additional options (can be OR’ed)UNB_THREAD_CLOSED (1):
Closed
UNB_THREAD_IMPORTANT (2):
Important (sticky)
UNB_THREAD_POLL (4):
Poll
UNB_THREAD_MOVED (8):
Moved note
UNB_THREAD_ATTACHMENT (16):
Has an attachment [auto-generated]
(These constants are defined in thread.lib.php.) |
| Question | varchar(150) | Poll question For moved threads (Options & UNB_THREAD_MOVED):ID to target thread |
| PollTimeout | int | Poll timeout in days For moved threads (Options & UNB_THREAD_MOVED):Expire time (in days) for “moved” note |
Table: UserForumFlags
Stores flags for users on forums or threads
| Forum | int unsigned | Forum ID |
| Thread | int unsigned | Thread ID |
| User | int unsigned | User ID |
| Flags | tinyint unsigned | FlagsUNB_UFF_COLLAPSE (1):
The category is collapsed in the forum index
UNB_UFF_IGNORE (2):
Ignore new topics in a forum
UNB_UFF_HIDE (4):
Hide a forum from the forums list
(These constants are defined in common.lib.php.) |
Table: Users
User records and profiles
| ID | int unsigned | User ID |
| Name | varchar(40) | Display name |
| Password | varchar(40) | MD5-encrypted password |
| RegDate | int | Registration timestamp |
| ValidatedEMail | varchar(100) | Registration e-mail address |
| DefaultNotify | tinyint unsigned | Default notification type, see ForumWatch.Mode or ThreadWatch.Mode |
| varchar(100) | E-mail address | |
| ICQ | varchar(15) | ICQ UIN |
| AIM | varchar(30) | AOL IM screenname |
| YIM | varchar(30) | Yahii IM screenname |
| MSN | varchar(50) | MSN Messenger address |
| Jabber | varchar(50) | Jabber IM address (JID) |
| LastActivity | int | Last activity timestamp |
| LastForum | int | Last visited forum 0: Overview page
UNB_ULF_CONFIG (-2):
Board configuration
UNB_ULF_PROFILE (-3):
User profile
UNB_ULF_SEARCH (-4):
Search
UNB_ULF_STAT (-5):
Statistics page
UNB_ULF_USERS (-6):
Users list
(These constants are defined in common.lib.php.) |
| LastLogin | int | Last login timestamp |
| LastLogout | int | Last ‘logout’ timestamp (last activity of previous session, is determined on login) |
| Signature | text | Post signature |
| BirthDay | tinyint unsigned | Day of birthdate |
| BirthMonth | tinyint unsigned | Month of birthdate |
| BirthYear | smallint unsigned | Year of birthdate |
| About | text | Short description, interests etc. |
| Title | varchar(40) | User title displayed with all posts |
| Location | varchar(50) | Location |
| Homepage | varchar(150) | Internet website |
| Gender | char(1) | Gender ‹empty›: undefined f: female m: male |
| Avatar | varchar(150) | Avatar file or URL (contains a “:”) |
| AvatarX | smallint | Horizontal dimension of avatar image [auto-generated] |
| AvatarY | smallint | Vertical dimension of avatar image [auto-generated] |
| Photo | varchar(150) | User photo file or URL (contains a “:”) |
| ActivateKey | varchar(50) | Unique registration validation key |
| RecommendedBy | int unsigned | This user was recommended by user ID for registration (This column is currently unused) |
| Design | varchar(50) | Selected design ‹empty›: Board default |
| ThreadIcons | tinyint | Show post action links with... 0: icons 1: text 2: both (This column is currently unused) |
| Flags | int unsigned | User profile optionsUNB_USER_USERREADPOST (8):
(Admin only) Display all notifications and UserRead data
UNB_USER_FASTREPLY (16):
Enable FastReply
UNB_USER_AUTOLOGIN (32):
Auto re-login (with Cookies)
UNB_USER_POSTCOPY (64):
Include a copy of the post on notification (not yet implemented)
UNB_USER_AUTOIGNORE (128):
Automatically ignore any unread new topics (TODO: add link to docs)
UNB_USER_HALFSIZEAVATARS (512):
Half size avatars if they’re more than 50% of globally allowed maximum height
UNB_USER_HIDEAVATARS (1024):
Hide users’ avatars in posts
UNB_USER_HIDESIGS (2048):
Hide users’ signatures in posts
UNB_USER_HIDEINLINEIMGS (4096):
Hide inline post attachments (images)
(These constants are defined in user.lib.php.) |
| Timezone | tinyint | +/- offset in hours * 4 (-48...+48) 99: Board default |
| TimezoneDS | tinyint | Daylight saving time -1: Board default 0: No DST 1: Auto DST 2: Force DST (not yet implemented) |
| EditControls | int unsigned | What BBCode controls should be displayed when posting (This column is currently unused) |
| ThreadsPerPage | smallint | Number of threads per page -1: Board default (This column is currently unused) |
| ThreadSort | smallint | Threads sorting in threads list -1: Board default (This column is currently unused) |
| ThreadTime | smallint | Show topics of the last ... days in threads list -1: Board default (This column is currently unused) |
| Language | varchar(6) | Selected language’s code, ex: “en”, “de” ‹empty›: Board default or auto detection |
| DateFormat | varchar(20) | Custom date format, see PHP function date() ‹empty›: Language default |
| Extra{n} | varchar(100) | Extra user profile fields, with n being greater than or equal to 1. These columns are automatically added and removed when you change the extra user profile fields captions in the Admin CP |
