Last active
November 5, 2019 04:04
-
-
Save mpolinowski/2d72874a41eb7b8dbbd2afe2da4ad279 to your computer and use it in GitHub Desktop.
vBulletin5 SQL tables
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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