Skip to content

Instantly share code, notes, and snippets.

@mpolinowski

mpolinowski/vBulletin5_SQL.txt

Last active November 5, 2019 04:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mpolinowski/2d72874a41eb7b8dbbd2afe2da4ad279 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mpolinowski/2d72874a41eb7b8dbbd2afe2da4ad279 to your computer and use it in GitHub Desktop.
Download ZIP
vBulletin5 SQL tables
Raw
vBulletin5_SQL.txt
MariaDB [vb5]> show tables;
+-----------------------------------+
| Tables_in_vb5 |
+-----------------------------------+
| Firmware |
| Firmware_Rechte |
| ad |
| adcriteria |
| adminhelp |
| administrator |
| adminlog |
| adminmessage |
| adminutil |
| album |
| albumupdate |
| announcement |
| announcementread |
| apiclient |
| apiclient_devicetoken |
| apilog |
| attach |
| attachment |
| attachmentcategory |
| attachmentcategoryuser |
| attachmentpermission |
| attachmenttype |
| attachmentviews |
| autosavetext |
| avatar |
| bbcode |
| bbcode_video |
| cache |
| cacheevent |
| calendar |
| calendarcustomfield |
| calendarmoderator |
| calendarpermission |
| channel |
| channelprefixset |
| closure |
| contentpriority |
| contenttype |
| cpsession |
| cron |
| cronlog |
| customavatar |
| customprofile |
| customprofilepic |
| datastore |
| deletionlog |
| discussion |
| dl2_categories |
| dl2_comments |
| dl2_downloads |
| dl2_extensions |
| dl2_files |
| dl2_images |
| dl2_main |
| dl2_reports |
| dl2_stats |
| dl2_votes |
| editlog |
| event |
| externalcache |
| faq |
| fcmessage |
| fcmessage_offload |
| fcmessage_queue |
| filedata |
| filedataresize |
| force_read_guests |
| force_read_users |
| formbits |
| formresults |
| forms |
| forumpermission |
| forumrunner_attachment |
| forumrunner_push_data |
| forumrunner_push_users |
| gallery |
| groupintopic |
| holiday |
| hook |
| humanverify |
| hvanswer |
| hvquestion |
| icon |
| imagecategory |
| imagecategorypermission |
| infraction |
| infractionban |
| infractiongroup |
| infractionlevel |
| ipaddressinfo |
| ipdata |
| language |
| legacyevent |
| lgv |
| link |
| loginlibrary |
| mailqueue |
| mapiposthash |
| messagefolder |
| microsupport_categories |
| microsupport_departments |
| microsupport_faq |
| microsupport_faq_stats |
| microsupport_fields |
| microsupport_pre_stats |
| microsupport_predefinied |
| microsupport_products |
| microsupport_spam_log |
| microsupport_support_chats |
| microsupport_supportusers_online |
| microsupport_ticket_fields |
| microsupport_ticket_replies |
| microsupport_ticket_status |
| microsupport_tickets |
| microsupport_users_online |
| moderation |
| moderator |
| moderatorlog |
| node |
| nodehash |
| noderead |
| nodeview |
| notice |
| noticecriteria |
| noticedismissed |
| notification |
| notificationevent |
| notificationtype |
| package |
| page |
| pagetemplate |
| passwordhistory |
| paymentapi |
| paymentinfo |
| paymenttransaction |
| permission |
| photo |
| phrase |
| phrasetype |
| poll |
| polloption |
| pollvote |
| post_thanks |
| postedithistory |
| prefix |
| prefixpermission |
| prefixset |
| privacyconsent |
| privatemessage |
| product |
| productcode |
| productdependency |
| profilefield |
| profilefieldcategory |
| profilevisitor |
| ranks |
| rbs_banners |
| rbs_hits |
| redirect |
| report |
| reputation |
| reputationlevel |
| routenew |
| rssfeed |
| rsslog |
| screenlayout |
| searchlog |
| searchtowords_a |
| searchtowords_b |
| searchtowords_c |
| searchtowords_d |
| searchtowords_e |
| searchtowords_f |
| searchtowords_g |
| searchtowords_h |
| searchtowords_i |
| searchtowords_j |
| searchtowords_k |
| searchtowords_l |
| searchtowords_m |
| searchtowords_n |
| searchtowords_o |
| searchtowords_other |
| searchtowords_p |
| searchtowords_q |
| searchtowords_r |
| searchtowords_s |
| searchtowords_t |
| searchtowords_u |
| searchtowords_v |
| searchtowords_w |
| searchtowords_x |
| searchtowords_y |
| searchtowords_z |
| sentto |
| session |
| sessionauth |
| setting |
| settinggroup |
| sigparsed |
| sigpic |
| sigpicnew |
| site |
| smilie |
| spamlog |
| stats |
| strikes |
| style |
| stylevar |
| stylevardfn |
| subscribediscussion |
| subscribeevent |
| subscription |
| subscriptionlog |
| subscriptionpermission |
| tabs |
| tachyforumcounter |
| tachyforumpost |
| tachythreadcounter |
| tachythreadpost |
| tag |
| tagnode |
| tagsearch |
| template |
| templateedit |
| templateeditlocation |
| templatehistory |
| templatemerge |
| text |
| thread_post |
| trending |
| upgradelog |
| user |
| useractivation |
| userauth |
| userban |
| userchangelog |
| userfield |
| usergroup |
| usergroupleader |
| usergrouprequest |
| userlist |
| userloginmfa |
| usernote |
| userpromotion |
| userstylevar |
| usertextfield |
| usertitle |
| vault_article |
| vault_list |
| vault_namespace |
| vault_revision |
| vault_upgradelog |
| vbglossar_category |
| vbglossar_entry |
| vbglossar_entryfields |
| vbglossar_entryfieldsdata |
| vbglossar_entryhistory |
| vbglossar_entryrate |
| video |
| videoitem |
| vsa_ppdonate |
| widget |
| widgetchannelconfig |
| widgetdefinition |
| widgetinstance |
| widgetuserconfig |
| words |
| xperience_achievements |
| xperience_achievements_categories |
| xperience_achievements_fields |
| xperience_achievements_issues |
| xperience_achievements_log |
| xperience_award_categories |
| xperience_award_issues |
| xperience_awards |
| xperience_custompoints |
| xperience_gap |
| xperience_groups |
| xperience_level |
| xperience_promotion |
| xperience_promotion_issues |
| xperience_stats |
| xperience_stats_changes |
+-----------------------------------+
284 rows in set (0.001 sec)
MariaDB [vb5]> describe node;
+-------------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-----------------------+------+-----+---------+----------------+
| nodeid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| routeid | int(10) unsigned | NO | MUL | 0 | |
| contenttypeid | smallint(6) | NO | MUL | NULL | |
| publishdate | int(11) | YES | MUL | NULL | |
| unpublishdate | int(11) | YES | MUL | NULL | |
| userid | int(10) unsigned | YES | MUL | NULL | |
| groupid | int(10) unsigned | YES | | NULL | |
| authorname | varchar(100) | YES | | NULL | |
| description | varchar(1024) | YES | | NULL | |
| title | varchar(512) | YES | | NULL | |
| htmltitle | varchar(512) | YES | | NULL | |
| parentid | int(11) | NO | MUL | NULL | |
| urlident | varchar(512) | YES | MUL | NULL | |
| displayorder | smallint(6) | YES | | NULL | |
| starter | int(11) | NO | MUL | 0 | |
| created | int(11) | YES | MUL | NULL | |
| lastcontent | int(11) | NO | MUL | 0 | |
| lastcontentid | int(11) | NO | | 0 | |
| lastcontentauthor | varchar(100) | NO | | | |
| lastauthorid | int(10) unsigned | NO | MUL | 0 | |
| lastprefixid | varchar(25) | NO | | | |
| textcount | mediumint(8) unsigned | NO | MUL | 0 | |
| textunpubcount | mediumint(8) unsigned | NO | | 0 | |
| totalcount | mediumint(8) unsigned | NO | MUL | 0 | |
| totalunpubcount | mediumint(8) unsigned | NO | | 0 | |
| ipaddress | varchar(45) | NO | MUL | | |
| showpublished | smallint(5) unsigned | NO | MUL | 0 | |
| oldid | int(10) unsigned | YES | | NULL | |
| oldcontenttypeid | int(10) unsigned | YES | MUL | NULL | |
| nextupdate | int(11) | YES | MUL | NULL | |
| lastupdate | int(11) | YES | MUL | NULL | |
| featured | smallint(6) | NO | MUL | 0 | |
| CRC32 | varchar(10) | NO | | | |
| taglist | mediumtext | YES | | NULL | |
| inlist | smallint(5) unsigned | NO | MUL | 1 | |
| protected | smallint(5) unsigned | NO | | 0 | |
| setfor | int(11) | NO | MUL | 0 | |
| votes | smallint(5) unsigned | NO | | 0 | |
| hasphoto | smallint(6) | NO | | 0 | |
| hasvideo | smallint(6) | NO | | 0 | |
| deleteuserid | int(10) unsigned | YES | | NULL | |
| deletereason | varchar(125) | YES | | NULL | |
| open | smallint(6) | NO | | 1 | |
| showopen | smallint(6) | NO | | 1 | |
| sticky | tinyint(1) | NO | MUL | 0 | |
| approved | tinyint(1) | NO | MUL | 1 | |
| showapproved | tinyint(1) | NO | MUL | 1 | |
| viewperms | tinyint(4) | NO | | 2 | |
| commentperms | tinyint(4) | NO | | 1 | |
| nodeoptions | int(10) unsigned | NO | | 138 | |
| prefixid | varchar(25) | NO | MUL | | |
| iconid | smallint(6) | NO | | 0 | |
| public_preview | smallint(6) | NO | MUL | 0 | |
+-------------------+-----------------------+------+-----+---------+----------------+
MariaDB [vb5]> SELECT COUNT(*) FROM node;
+----------+
| COUNT(*) |
+----------+
| 34375 |
+----------+
1 row in set (0.000 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment