In 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_ terms||This 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_Taxonomy||In 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_ Posts||Is 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_PostMeta||This table contains additional attributes that complement the table wp_posts.|
|wp_ term_relationships||In this table, the binding pages, records and links with headings, labels which are in table wp_term_taxonomy.|
|wp_comments||This table contains comments post or page. It also contains complete information and commentary about the author.|
|wp_ Links||Simple 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_ users||In this table, there is a complete list of registered users WordPress, including the site administrator.You can change your password.|
|wp_usermeta||Contains additional information users.|
|wp_ options||There 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.