Структура таблиц vBulletin v3.7.2


vB_access - [userid, forumid, accessmask]

vB_adminhelp - [adminhelpid, script, action, optionname, displayorder, volatile, product]

vB_administrator - [userid, adminpermissions, navprefs, cssprefs, notes, dismissednews, languageid]

vB_adminlog - [adminlogid, userid, dateline, script, action, extrainfo, ipaddress]

vB_adminmessage - [adminmessageid, varname, dismissable, script, action, execurl, method, dateline, status, statususerid]

vB_adminutil - [title, text]

vB_album - [albumid, userid, createdate, lastpicturedate, visible, moderation, title, description, state, coverpictureid]

vB_albumpicture - [albumid, pictureid, dateline]

vB_announcement - [announcementid, title, userid, startdate, enddate, pagetext, forumid, views, announcementoptions]

vB_announcementread - [announcementid, userid]

vB_attachment - [attachmentid, userid, dateline, thumbnail_dateline, filename, filedata, visible, counter, filesize, postid, filehash, posthash, thumbnail, thumbnail_filesize, extension]

vB_attachmentpermission - [attachmentpermissionid, extension, usergroupid, size, width, height, attachmentpermissions]

vB_attachmenttype - [extension, mimetype, size, width, height, enabled, display, thumbnail, newwindow]

vB_attachmentviews - [attachmentid]

vB_avatar - [avatarid, title, minimumposts, avatarpath, imagecategoryid, displayorder]

vB_bbcode - [bbcodeid, bbcodetag, bbcodereplacement, bbcodeexample, bbcodeexplanation, twoparams, title, buttonimage, options]

vB_bookmarksite - [bookmarksiteid, title, iconpath, active, displayorder, url]

vB_calendar - [calendarid, title, description, displayorder, neweventemail, moderatenew, startofweek, options, cutoff, eventcount, birthdaycount, startyear, endyear, holidays]

vB_calendarcustomfield - [calendarcustomfieldid, calendarid, title, description, options, allowentry, required, length]

vB_calendarmoderator - [calendarmoderatorid, userid, calendarid, neweventemail, permissions]

vB_calendarpermission - [calendarpermissionid, calendarid, usergroupid, calendarpermissions]

vB_cpsession - [userid, hash, dateline]

vB_cron - [cronid, nextrun, weekday, day, hour, minute, filename, loglevel, active, varname, volatile, product]

vB_cronlog - [cronlogid, varname, dateline, description, type]

vB_customavatar - [userid, filedata, dateline, filename, visible, filesize, width, height, filedata_thumb, width_thumb, height_thumb]

vB_customprofilepic - [userid, filedata, dateline, filename, visible, filesize, width, height]

vB_datastore - [title, data, unserialize]

vB_deletionlog - [primaryid, type, userid, username, reason, dateline]

vB_editlog - [postid, userid, username, dateline, reason, hashistory]

vB_event - [eventid, userid, event, title, allowsmilies, recurring, recuroption, calendarid, customfields, visible, dateline, utc, dst, dateline_from, dateline_to]

vB_externalcache - [cachehash, text, headers, dateline, forumid]

vB_faq - [faqname, faqparent, displayorder, volatile, product]

vB_forum - [forumid, styleid, title, title_clean, description, description_clean, options, showprivate, displayorder, replycount, lastpost, lastposter, lastpostid, lastthread, lastthreadid, lasticonid, lastprefixid, threadcount, daysprune, newpostemail, newthreademail, parentid, parentlist, password, link, childlist, defaultsortfield, defaultsortorder, imageprefix]

vB_forumpermission - [forumpermissionid, forumid, usergroupid, forumpermissions]

vB_forumprefixset - [forumid, prefixsetid]

vB_forumread - [userid, forumid, readtime]

vB_groupmessage - [gmid, groupid, postuserid, postusername, dateline, state, title, pagetext, ipaddress, allowsmilie, reportthreadid]

vB_groupmessage_hash - [postuserid, groupid, dupehash, dateline]

vB_holiday - [holidayid, varname, recurring, recuroption, allowsmilies]

vB_humanverify - [hash, answer, dateline, viewed]

vB_hvanswer - [answerid, questionid, answer, dateline]

vB_hvquestion - [questionid, regex, dateline]

vB_icon - [iconid, title, iconpath, imagecategoryid, displayorder]

vB_imagecategory - [imagecategoryid, title, imagetype, displayorder]

vB_imagecategorypermission - [imagecategoryid, usergroupid]

vB_infraction - [infractionid, infractionlevelid, postid, userid, whoadded, points, dateline, note, action, actiondateline, actionuserid, actionreason, expires, threadid, customreason]

vB_infractionban - [infractionbanid, usergroupid, banusergroupid, amount, period, method]

vB_infractiongroup - [infractiongroupid, usergroupid, orusergroupid, pointlevel, override]

vB_infractionlevel - [infractionlevelid, points, expires, period, warning, extend]

vB_language - [languageid, title, userselect, options, languagecode, charset, imagesoverride, dateoverride, timeoverride, registereddateoverride, calformat1override, calformat2override, logdateoverride, locale, decimalsep, thousandsep, phrasegroup_global, phrasegroup_cpglobal, phrasegroup_cppermission, phrasegroup_forum, phrasegroup_calendar, phrasegroup_attachment_image, phrasegroup_style, phrasegroup_logging, phrasegroup_cphome, phrasegroup_promotion, phrasegroup_user, phrasegroup_help_faq, phrasegroup_sql, phrasegroup_subscription, phrasegroup_language, phrasegroup_bbcode, phrasegroup_stats, phrasegroup_diagnostic, phrasegroup_maintenance, phrasegroup_profilefield, phrasegroup_thread, phrasegroup_timezone, phrasegroup_banning, phrasegroup_reputation, phrasegroup_wol, phrasegroup_threadmanage, phrasegroup_pm, phrasegroup_cpuser, phrasegroup_accessmask, phrasegroup_cron, phrasegroup_moderator, phrasegroup_cpoption, phrasegroup_cprank, phrasegroup_cpusergroup, phrasegroup_holiday, phrasegroup_posting, phrasegroup_poll, phrasegroup_fronthelp, phrasegroup_register, phrasegroup_search, phrasegroup_showthread, phrasegroup_postbit, phrasegroup_forumdisplay, phrasegroup_messaging, phrasegroup_inlinemod, phrasegroup_plugins, phrasegroup_cprofilefield, phrasegroup_reputationlevel, phrasegroup_infraction, phrasegroup_infractionlevel, phrasegroup_notice, phrasegroup_prefix, phrasegroup_prefixadmin, phrasegroup_album, phrasegroup_socialgroups]

vB_mailqueue - [mailqueueid, dateline, toemail, fromemail, subject, message, header]

vB_moderation - [primaryid, type, dateline]

vB_moderator - [moderatorid, userid, forumid, permissions, permissions2]

vB_moderatorlog - [moderatorlogid, dateline, userid, forumid, threadid, postid, pollid, attachmentid, action, type, threadtitle, ipaddress, product, id1, id2, id3, id4, id5]

vB_notice - [noticeid, title, displayorder, persistent, active]

vB_noticecriteria - [noticeid, criteriaid, condition1, condition2, condition3]

vB_passwordhistory - [userid, password, passworddate]

vB_paymentapi - [paymentapiid, title, currency, recurring, classname, active, settings]

vB_paymentinfo - [paymentinfoid, hash, subscriptionid, subscriptionsubid, userid, completed]

vB_paymenttransaction - [paymenttransactionid, paymentinfoid, transactionid, state, amount, currency, dateline, paymentapiid, request, reversed]

vB_phrase - [phraseid, languageid, varname, fieldname, text, product, username, dateline, version]

vB_phrasetype - [fieldname, title, editrows, product, special]

vB_picture - [pictureid, userid, caption, extension, filedata, filesize, width, height, thumbnail, thumbnail_filesize, thumbnail_width, thumbnail_height, thumbnail_dateline, idhash, reportthreadid, state]

vB_picturecomment - [commentid, pictureid, postuserid, postusername, dateline, state, title, pagetext, ipaddress, allowsmilie, reportthreadid, messageread]

vB_picturecomment_hash - [postuserid, pictureid, dupehash, dateline]

vB_plugin - [pluginid, title, hookname, phpcode, product, devkey, active, executionorder]

vB_pm - [pmid, pmtextid, userid, folderid, messageread]

vB_pmreceipt - [pmid, userid, touserid, tousername, title, sendtime, readtime, denied]

vB_pmtext - [pmtextid, fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie]

vB_podcast - [forumid, author, category, image, explicit, enabled, keywords, owneremail, ownername, subtitle, summary, categoryid]

vB_podcastitem - [postid, url, length, explicit, keywords, subtitle, author]

vB_poll - [pollid, question, dateline, options, votes, active, numberoptions, timeout, multiple, voters, public, lastvote]

vB_pollvote - [pollvoteid, pollid, userid, votedate, voteoption, votetype]

vB_post - [postid, threadid, parentid, username, userid, title, dateline, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible, attach, infraction, reportthreadid]

vB_postedithistory - [postedithistoryid, postid, userid, username, title, iconid, dateline, reason, original, pagetext]

vB_posthash - [userid, threadid, postid, dupehash, dateline]

vB_postindex - [wordid, postid, intitle, score]

vB_postlog - [postid, useragent, ip, dateline]

vB_postparsed - [postid, dateline, styleid, languageid, hasimages, pagetext_html]

vB_prefix - [prefixid, prefixsetid, displayorder]

vB_prefixset - [prefixsetid, displayorder]

vB_product - [productid, title, description, version, active, url, versioncheckurl]

vB_productcode - [productcodeid, productid, version, installcode, uninstallcode]

vB_productdependency - [productdependencyid, productid, dependencytype, parentproductid, minversion, maxversion]

vB_profilefield - [profilefieldid, profilefieldcategoryid, required, hidden, maxlength, size, displayorder, editable, type, data, height, def, optional, searchable, memberlist, regex, form, html, perline]

vB_profilefieldcategory - [profilefieldcategoryid, displayorder, location]

vB_profilevisitor - [userid, visitorid, dateline, visible]

vB_ranks - [rankid, minposts, ranklevel, rankimg, usergroupid, type, stack, display]

vB_reminder - [reminderid, userid, title, text, duedate, adminonly, completedby, completedtime]

vB_reputation - [reputationid, postid, userid, reputation, whoadded, reason, dateline]

vB_reputationlevel - [reputationlevelid, minimumreputation]

vB_rssfeed - [rssfeedid, title, url, port, ttl, maxresults, userid, forumid, prefixid, iconid, titletemplate, bodytemplate, searchwords, itemtype, threadactiondelay, endannouncement, options, lastrun]

vB_rsslog - [rssfeedid, itemid, itemtype, uniquehash, contenthash, dateline, threadactiontime, threadactioncomplete]

vB_search - [searchid, userid, ipaddress, personal, query, searchuser, forumchoice, prefixchoice, sortby, sortorder, searchtime, showposts, orderedids, announceids, dateline, searchterms, displayterms, searchhash, titleonly, completed]

vB_session - [sessionhash, userid, host, idhash, lastactivity, location, useragent, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, bypass, profileupdate]

vB_setting - [varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile, datatype, product, validationcode, blacklist]

vB_settinggroup - [grouptitle, displayorder, volatile, product]

vB_sigparsed - [userid, styleid, languageid, signatureparsed, hasimages]

vB_sigpic - [userid, filedata, dateline, filename, visible, filesize, width, height]

vB_smilie - [smilieid, title, smilietext, smiliepath, imagecategoryid, displayorder]

vB_socialgroup - [groupid, name, description, creatoruserid, dateline, members, picturecount, lastpost, lastposter, lastposterid, lastgmid, visible, deleted, moderation, type, moderatedmembers, options]

vB_socialgroupmember - [userid, groupid, dateline, type]

vB_socialgrouppicture - [groupid, pictureid, dateline]

vB_spamlog - [postid]

vB_stats - [dateline, nuser, nthread, npost, ausers]

vB_strikes - [striketime, strikeip, username]

vB_style - [styleid, title, parentid, parentlist, templatelist, csscolors, css, stylevars, replacements, editorstyles, userselect, displayorder]

vB_subscribeevent - [subscribeeventid, userid, eventid, lastreminder, reminder]

vB_subscribeforum - [subscribeforumid, userid, forumid, emailupdate]

vB_subscribethread - [subscribethreadid, userid, threadid, emailupdate, folderid, canview]

vB_subscription - [subscriptionid, varname, cost, forums, nusergroupid, membergroupids, active, options, displayorder, adminoptions]

vB_subscriptionlog - [subscriptionlogid, subscriptionid, userid, pusergroupid, status, regdate, expirydate]

vB_subscriptionpermission - [subscriptionpermissionid, subscriptionid, usergroupid]

vB_tachyforumcounter - [userid, forumid, threadcount, replycount]

vB_tachyforumpost - [userid, forumid, lastpost, lastposter, lastpostid, lastthread, lastthreadid, lasticonid, lastprefixid]

vB_tachythreadcounter - [userid, threadid, replycount]

vB_tachythreadpost - [userid, threadid, lastpost, lastposter, lastpostid]

vB_tag - [tagid, tagtext, dateline]

vB_tagsearch - [tagid, dateline]

vB_tagthread - [tagid, threadid, userid, dateline]

vB_template - [templateid, styleid, title, template, template_un, templatetype, dateline, username, version, product]

vB_templatehistory - [templatehistoryid, styleid, title, template, dateline, username, version, comment]

vB_thread - [threadid, title, prefixid, firstpostid, lastpostid, lastpost, forumid, pollid, open, replycount, hiddencount, deletedcount, postusername, postuserid, lastposter, dateline, views, iconid, notes, visible, sticky, votenum, votetotal, attach, similar, taglist]

vB_threadrate - [threadrateid, threadid, userid, vote, ipaddress]

vB_threadread - [userid, threadid, readtime]

vB_threadredirect - [threadid, expires]

vB_threadviews - [threadid]

vB_upgradelog - [upgradelogid, script, steptitle, step, startat, perpage, dateline]

vB_user - [userid, usergroupid, membergroupids, displaygroupid, username, password, passworddate, email, styleid, parentemail, homepage, icq, aim, yahoo, msn, skype, showvbcode, showbirthday, usertitle, customtitle, joindate, daysprune, lastvisit, lastactivity, lastpost, lastpostid, posts, reputation, reputationlevelid, timezoneoffset, pmpopup, avatarid, avatarrevision, profilepicrevision, sigpicrevision, options, birthday, birthday_search, maxposts, startofweek, ipaddress, referrerid, languageid, emailstamp, threadedmode, autosubscribe, pmtotal, pmunread, salt, ipoints, infractions, warnings, infractiongroupids, infractiongroupid, adminoptions, profilevisits, friendcount, friendreqcount, vmunreadcount, vmmoderatedcount, socgroupinvitecount, socgroupreqcount, pcunreadcount, pcmoderatedcount, gmmoderatedcount]

vB_useractivation - [useractivationid, userid, dateline, activationid, type, usergroupid, emailchange]

vB_userban - [userid, usergroupid, displaygroupid, usertitle, customtitle, adminid, bandate, liftdate, reason]

vB_userchangelog - [changeid, userid, fieldname, newvalue, oldvalue, adminid, change_time, change_uniq]

vB_usercss - [userid, selector, property, value]

vB_usercsscache - [userid, cachedcss, buildpermissions]

vB_userfield - [userid, temp, field1, field2, field3, field4]

vB_usergroup - [usergroupid, title, description, usertitle, passwordexpires, passwordhistory, pmquota, pmsendmax, opentag, closetag, canoverride, ispublicgroup, forumpermissions, pmpermissions, calendarpermissions, wolpermissions, adminpermissions, genericpermissions, genericpermissions2, genericoptions, signaturepermissions, visitormessagepermissions, attachlimit, avatarmaxwidth, avatarmaxheight, avatarmaxsize, profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize, sigpicmaxwidth, sigpicmaxheight, sigpicmaxsize, sigmaximages, sigmaxsizebbcode, sigmaxchars, sigmaxrawchars, sigmaxlines, usercsspermissions, albumpermissions, albumpicmaxwidth, albumpicmaxheight, albumpicmaxsize, albummaxpics, albummaxsize, socialgrouppermissions]

vB_usergroupleader - [usergroupleaderid, userid, usergroupid]

vB_usergrouprequest - [usergrouprequestid, userid, usergroupid, reason, dateline]

vB_userlist - [userid, relationid, type, friend]

vB_usernote - [usernoteid, userid, posterid, username, dateline, message, title, allowsmilies]

vB_userpromotion - [userpromotionid, usergroupid, joinusergroupid, reputation, date, posts, strategy, type]

vB_usertextfield - [userid, subfolders, pmfolders, buddylist, ignorelist, signature, searchprefs, rank]

vB_usertitle - [usertitleid, minposts, title]

vB_visitormessage - [vmid, userid, postuserid, postusername, dateline, state, title, pagetext, ipaddress, allowsmilie, reportthreadid, messageread]

vB_visitormessage_hash - [postuserid, userid, dupehash, dateline]

vB_word - [wordid, title]

Уважаемый посетитель, Вы зашли на сайт как незарегистрированный пользователь. Мы рекомендуем Вам зарегистрироваться либо зайти на сайт под своим именем.