Announcement

Collapse
No announcement yet.

Which table should I remove?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Which table should I remove?

    Hello,

    After several upgrade of my forum since 2000 to the latest release 5.1.7 , there are many of obsolete remaining tables in my forum database. Could you please tell me which table should I remove and doesn't cause any problem to the database;

    Here is the list :

    access
    ad
    adcriteria
    adminhelp
    administrator
    adminlog
    adminmessage
    adminutil
    announcement
    announcementread
    apiclient
    apilog
    apipost
    attach
    attachment
    attachmentcategory
    attachmentcategoryuser
    attachmentpermission
    attachmenttype
    attachmentviews
    autosavetext
    avatar
    bbcode
    bbcode_video
    block
    blockconfig
    blocktype
    blog
    blog_attachmentlegacy
    blog_category
    blog_categorypermission
    blog_categoryuser
    blog_custom_block
    blog_custom_block_parsed
    blog_deletionlog
    blog_editlog
    blog_featured
    blog_groupmembership
    blog_grouppermission
    blog_hash
    blog_moderation
    blog_moderator
    blog_pinghistory
    blog_rate
    blog_read
    blog_relationship
    blog_search
    blog_searchresult
    blog_sitemapconf
    blog_subscribeentry
    blog_subscribeuser
    blog_summarystats
    blog_tachyentry
    blog_textparsed
    blog_trackback
    blog_trackbacklog
    blog_user
    blog_usercss
    blog_usercsscache
    blog_userread
    blog_userstats
    blog_views
    blog_visitor
    bookmarksite
    cache
    cacheevent
    calendar
    calendarcustomfield
    calendarmoderator
    calendarpermission
    channel
    channelprefixset
    closure
    cms_article
    cms_category
    cms_grid
    cms_layout
    cms_layoutwidget
    cms_navigation
    cms_node
    cms_nodecategory
    cms_nodeconfig
    cms_nodeinfo
    cms_permissions
    cms_rate
    cms_sectionorder
    cms_widget
    cms_widgetconfig
    cms_widgettype
    contentpriority
    contentread
    contenttype
    cpsession
    cron
    cronlog
    customavatar
    customprofile
    customprofilepic
    datastore
    deletionlog
    discussion
    discussionread
    editlog
    event
    externalcache
    faq
    filedata
    filedataresize
    forum
    forumpermission
    forumread
    forumrunner_attachment
    forumrunner_push_data
    forumrunner_push_users
    gallery
    groupintopic
    groupmessage
    groupmessage_hash
    groupread
    holiday
    hook
    humanverify
    hvanswer
    hvquestion
    icon
    imagecategory
    imagecategorypermission
    inactiveuserlog
    indexqueue
    infraction
    infractionban
    infractiongroup
    infractionlevel
    ipdata
    language
    link
    mailqueue
    mapiposthash
    messagefolder
    moderation
    moderator
    moderatorlog
    navigation
    node
    nodehash
    noderead
    nodestatreplies
    nodestats
    nodeview
    nodevisits
    notice
    noticecriteria
    noticedismissed
    notification
    notificationevent
    notificationtype
    package
    page
    pagetemplate
    passwordhistory
    paymentapi
    paymentinfo
    paymenttransaction
    permission
    photo
    phrase
    phrasetype
    picturecomment
    picturecomment_hash
    picturelegacy
    plugin
    pm
    pmreceipt
    pmtext
    pmthrottle
    podcast
    podcastitem
    poll
    polloption
    pollvote
    post
    postedithistory
    posthash
    postindex
    postlog
    postparsed
    postrelease
    prefix
    prefixpermission
    prefixset
    privatemessage
    product
    productcode
    productdependency
    profileblockprivacy
    profilefield
    profilefieldcategory
    profilevisitor
    ranks
    redirect
    reminder
    report
    reputation
    reputationlevel
    route
    routenew
    rssfeed
    rsslog
    screenlayout
    searchcore
    searchcore_text
    searchgroup
    searchgroup_text
    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
    setting
    settinggroup
    sigparsed
    sigpic
    sigpicnew
    site
    skimlinks
    smilie
    socialgroup
    socialgroupcategory
    socialgroupicon
    socialgroupmember
    spamlog
    stats
    strikes
    style
    stylevar
    stylevardfn
    subscribediscussion
    subscribeevent
    subscribeforum
    subscribegroup
    subscribethread
    subscription
    subscriptionlog
    subscriptionpermission
    tag
    tagcontent
    tagnode
    tagsearch
    template
    templatehistory
    templatemerge
    text GiB
    thread
    threadrate
    threadread
    threadredirect
    threadviews
    thread_post
    thread_serviceupdate
    upgradelog
    user
    useractivation
    userban
    userchangelog
    usercss
    usercsscache
    userfield
    usergroup
    usergroupleader
    usergrouprequest
    userlist
    usernote
    userpromotion
    userstylevar
    usertextfield
    usertitle
    video
    videoitem
    visitormessage
    visitormessage_hash
    widget
    widgetchannelconfig
    widgetdefinition
    widgetinstance
    widgetuserconfig
    words
    Last edited by sandrose; Sat 23rd May '15, 1:51am.
    http://www.vbulletin.com/forum/filed...ledataid=63608

  • #2
    Please help
    http://www.vbulletin.com/forum/filed...ledataid=63608

    Comment


    • #3
      You shouldn't remove any at this time.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #4
        Yes, do not remove anything!

        For example, to do reedirects old URLs it was helpfull to lookup in old tables to find the old Node-ID

        Comment


        • #5
          Ok Thanks
          http://www.vbulletin.com/forum/filed...ledataid=63608

          Comment

          Related Topics

          Collapse

          Working...
          X