It typically stores the settings of plugins and themes as well. This table stores your website configurations like the site title, tagline, and timezone. Instead of storing the content of the website, it stores the settings of the site. The options table is a different kind of table. Note: Throughout the database, there are many such tables that enable the WordPress core or a theme or plugin to store extra information. The social sharing plugin MashShare stores share counts of specific posts in this table. Some plugins store data within this table. It’s an extension of the wp_ posts table. The content types include text, revisions, menu items, media attachments, and any custom items. Since types of content from your posts and pages is stored in this table, it’s arguably the most important table in the WordPress database. For developers & website builders, it's necessary to have knowledge of how the database is structured and how it works. Graphical presentation of WordPress tables and how they are connected to each other The database is an integral part of a WordPress website. So the table that stored blog posts will share a relationship with the tables where category and tags are stored.īefore we start describing what the tables store and how they are connected to each other, here’s a graphical structure of WordPress database: One piece of data can be related to other data, for instance, a post can be associated with categories and tags. Many of the tables are related to one another. WordPress Database TablesĪ brand new WordPress website has 11 tables. In the next section, we are going to walk you through every WordPress table and show you which tables are responsible for the content on your WordPress website. Storing data in a specific table makes it faster and easier to find them. For instance, the wp comments table captures all information left by a person commenting on a post like IP Address, comment author slug, etc. Every table can store only specific data. There are 11 tables by default on a new WordPress website. In a WordPress database, the shelves are known as tables. An image of a typical warehouse that comes to mind is that of rows and rows of cardboard boxes. All your data is placed in an organized manner so that it’s easy to find them. Everything on your WordPress website, be it posts, custom post type, pages, comments, and even settings are stored in a database. What is WordPress Database?Ī database is created whenever you build a WordPress website. Show you behind the scenes of how data is stored. In this article, we’ll give you a tour of the WordPress database structure. But there are times you will find yourself in a situation where some knowledge of WordPress database schema is required. Installing WordPress and running the site doesn’t require any knowledge of the underlying structure. Launched over a decade ago, WordPress has become the world’s most popular website building platform.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |