The database structure of WordPress.

wordpress-database-tableIn this article I would like to tell you about the database structure of  WordPress. Many may say, why do we need this?Indeed, so can only say novice webmasters and bloggers.After all, there are cases that you are not able to go to the admin console WordPress (for example,error 500 Error).You can connect to your MySQL database and make the necessary steps: add a column, article, page, and so on.

Also, you wantto change the administrator password WordPressvia MySQL, entered into the database, and the structures do not know her.

A more detailed structure is painted and is on the official website of WordPress.Therefore, we will not be in this article to consider all in detail, but let’s just say a few words about each table, which is responsible for something.

Name of the table

Description of the table

wp_ termsThis table contains a list of terms WordPress. By the terms, in this case, include the name of the columns, tags, categories references.In this table, one term can be called as headings and label (for example, heading Clocks, Watches and the label). Names can be repeated, but they will still be unique because they are tied to a specific article.
wp_ term_TaxonomyIn this table, each term is associated with its type. That is, the column is associated with the name and marks are compared with the labels (if any).That is, in the first table, we have formed a title, and in the second we shape description and data tables are interrelated, that is, complement each other. This table is actually formed headings and labels with complete information.
 wp_ PostsIs the main table, which stores all of the articles on your site. And it will store all versions of records (audit), but this is the case, if you have a wordpress settings enabled this option.
wp_PostMetaThis table contains additional attributes that complement the table wp_posts.
wp_ term_relationshipsIn this table, the binding pages, records and links with headings, labels which are in table wp_term_taxonomy.
wp_commentsThis table contains comments post or page. It also contains complete information and commentary about the author.
wp_ LinksSimple table in which there is the usual list of links WordPress. Links can also be broken down into categories that are in the table wp_terms, and communication is carried out through a table wp_term_relationships.
wp_ usersIn this table, there is a complete list of registered users WordPress, including the site administrator.You can change your password.
wp_usermetaContains additional information users.
wp_ optionsThere are options of the database and the site itself: the name, address, email address and so on.

I want to draw attention to the fact that each table before the prefix wp_, which you can vary.Given that I have here is the default.Now you know the whole list of tables, and easily edit them.

I would also like to say about the fact that this is the main list of tables, without which WordPress will not work.Others modules, plug-ins and various scripts can create additional tables.


Leave a Reply