WordPress Database Table Prefixes

WordPress Database Table Prefixes

See a full list of database table prefixes for WordPress and popular plugins.

Standard WordPress Tables

The following tables are created during a new WordPress installation.

  • commentmeta
  • comments
  • links
  • options
  • postmeta
  • posts
  • termmeta
  • terms
  • term_relationships
  • term_taxonomy
  • usermeta
  • users

Plugin Tables

Following are the tables created by popular plugins.

They are listed in alphabetical order according to the table prefix name, not the plugin name.

Visitors Traffic Real Time Statics

  • ahc_browsers
  • ahc_countries
  • ahc_daily_visitors_stats
  • ahc_hits
  • ahc_keywords
  • ahc_online_users
  • ahc_recent_visitors
  • ahc_refering_sites
  • ahc_searchng_visits
  • ahc_search_engines
  • ahc_search_engine_crawlers
  • ahc_settings
  • ahc_title_traffic
  • ach_visitors
  • ahc_visits_time

Zip Recipes

  • amd_zlrecipe_recipes

Bad Behavior

  • bad_behavior

Easy Updates Manager

  • eum_logs

EWWW

  • ewwwio_images

Formidable

  • frm_fields
  • frm_forms
  • frm_items
  • frm_item_metas

FooGallery

  • gallery_albums
  • gallery_pics
  • gallery_settings

ImagePress

  • ip_collectionmeta
  • ip_collections

iThemes Security

  • itsec_lockouts
  • itsec_log
  • itsec_temp

Login Lockdown

  • lockdowns
  • login_fails

MailPoet (also see wysija below)

  • mailpoet_custom_fields
  • mailpoet_dynamic_segment_filters
  • mailpoet_feature_flags
  • mailpoet_forms
  • mailpoet_log
  • mailpoet_mapping_to-external_entities
  • mailpoet_newsletters
  • mailpoet_newsletter_links
  • mailpoet_newsletter_option
  • mailpoet_newsletter_option_fields
  • mailpoet_newsletter_posts
  • mailpoet_newsletter_segment
  • mailpoet_newsletter_templates
  • mailpoet_scheduled_tasks
  • mailpoet_scheduled_task_subscribers
  • mailpoet_segments
  • mailpoet_sending_queues
  • mailpoet_settings
  • mailpoet_statistics_clicks
  • mailpoet_statistics_forms
  • mailpoet_statistics_newsletters
  • mailpoet_statistics_opens
  • mailpoet_statistics_unsubscribes
  • mailpoet_statistic_woocommerce_purchases
  • mailpoet_stats_notifications
  • mailpoet_subscribers
  • mailpoet_subscriber_custom_field
  • mailpoet_subscriber_ips
  • mailpoet_subscriber_segment
  • mailpoet_user_flags

MainWP

  • mainwp_client_report
  • mainwp_client_report_client
  • mainwp_client_report_format
  • mainwp_client_report_site_token
  • mainwp_client_report_token
  • mainwp_group
  • mainwp_request_log
  • mainwp_tips
  • mainwp_users
  • mainwp_wp
  • mainwp_wp_backup
  • mainwp_wp_backup_progress
  • mainwp_wp_group
  • mainwp_wp_options
  • mainwp_wp_settings_backup
  • mainwp_wp_sync

MemberPress

  • mepr_events
  • mepr_jobs
  • mepr_members
  • mepr_rule_access_conditions
  • mepr_subscriptions
  • mepr_tax_rates
  • mepr_tax_rate_locations
  • mepr_transactions
  • mepr_transaction_meta

Code Snippets

  • ms_snippets

WP Reviews

  • mts_wp_reviews

Mediavine Create

  • mv_creations
  • mv_images
  • mv_nutrition
  • mv_products
  • mv_products_map
  • mv_relations
  • mv_reviews
  • mv_revisions
  • mv_settings
  • mv_shapes
  • mv_supplies

Ninja Forms

  • nf3_actions
  • nf3_action_meta
  • nf3_chunks
  • nf3_fields
  • nf3_field_meta
  • nf3_forms
  • nf3_form_meta
  • nf3_objects
  • nf3_object_meta
  • nf3_relationships
  • nf3_upgrades

WP All Export

  • pmxe_exports
  • pmxe_google_cats
  • pmxe_posts
  • pmxe_templates

Pretty Links

  • prli_clicks
  • prli_groups
  • prli_links
  • prli_link_metas

Redirection

  • redirection_404
  • redirection_groups
  • redirection_items
  • redirection_logs

RevSlider

  • revslider_css
  • revslider_layer_animations
  • revlider_navigations
  • revslider_sliders
  • revslider_slides
  • revslider_static_slides

Smash Balloon Instagram Feed

  • sbi_instagram_feeds_posts
  • sbi_instagram_posts

SmushIt

  • smush_dir_images

Subscribe to Comments Reloaded

  • subscribe_reloaded_subscribers

Social Share Buttons by Supsystic

  • supsystic_ss_networks
  • supsystic_ss_projects
  • supsystic_ss_project_networks
  • supsystic_ss_shares
  • supsystic_ss_views

Swift Performance

  • swift_performance_warmup

Thrive Architect

  • tcb_api_error_log

Thrive Comments

  • tcm_email_hash
  • tcm_logs

Thrive Quiz Builder (TGE)

(Note: this plugin uses 2 different database table prefixes. See the TQB tables below)

  • Tge_answers
  • tge_questions

Thrive Headline Optimizer

  • tho_event_log
  • tho_tests
  • tho_test_items

Thrive Quiz Builder (TQB)

(Note: this plugin uses 2 different database table prefixes. See the TGE tables above)

  • tqb_event_log
  • tqb_results
  • tqb_results_links
  • tqb_tests
  • tqb_tests_items
  • tqb_users
  • tqb_user_answers
  • tqb_variations

Thrive Apprentice

  • tva_ipn_log
  • tva_orders
  • tva_order_items
  • tva_transactions

Thrive Leads

  • tve_leads_contacts
  • tve_leads_contact_download
  • tve_leads_event_log
  • tve_leads_form_variations
  • tve_leads_group_options
  • tve_leads_saved_group_options
  • tve_leads_split_test
  • tve_leads_split_test_items

Thrive Ultimatum

  • tve_ult_designs
  • tve_ult_emails
  • tve_ult_events
  • tve_ult_event_log
  • tve_ult-setings_campaign
  • tve_ult_settings_templates

Thrive Ovation

  • tvo_activity_log

Uji Countdown

  • uji_counter
  • uji_subscriptions

Wordfence

  • wfBlockedIPLog
  • wfBlocks7
  • wfConfig
  • wfCrawlers
  • wfFileChanges
  • wfFileMods
  • wfHits
  • wfHoover
  • wfissues
  • wfKnownFileList
  • wfLiveTrafficHuman
  • wfLocs
  • wfLogins
  • wfls_2fa_secrets
  • wfls_settings
  • wfNotifications
  • wfPendingIssues
  • wfReverseCache
  • wfSNIPCache
  • wfTrafficRates

WP Optimize

  • wpai_blocks
  • wpai_settings

WP Business Directory Pro

  • wpbdp_fees
  • wpbdp_form_fields
  • wpbdp_listing_fees
  • wpbdp_payments
  • wpbdp_payments_items
  • wpbdp_submit_state

WYSIJA (from MailPoet, see above)

  • wysija_campaign
  • wysija_campaign_list
  • wysija_custom_field
  • wysija_email
  • wysija_email_user_stat
  • wysija_email_user_url
  • wysija_form
  • wysija_list
  • wysija_queue
  • wysija_subscriber_ips
  • wysija_url
  • wysija_url_mail
  • wysija_user
  • wysija_user_field
  • wysija_history
  • wysija_list

Broken Link Status Checker

  • wplnst_scans
  • wplnst_scans_objects
  • wplnst_urls
  • wplinst_urls_locations
  • wplnst_urls_locations_att
  • wplnst_urls_status

WP Security Audit

  • wsal_metadata
  • wsal_occurrences
  • wsal_options

Yoast SEO – free version

  • yoast_indexable
  • yoast_indexable_hierarchy
  • yoast_migrations
  • yoast_primary_term
  • yoast_se_links
  • yoast_seo_meta

 

Want to contribute to this project?

Contact me with your plugin name, link, and database table names or leave your comments below.

Related Post

Leave a Reply

Your email address will not be published. Required fields are marked *

9 + 16 =