Well, this is the most important table in wordpress structure. It stores all the posts, and some post related data. The structure is mentioned below: Field Type Null Key Default Extra ID bigint(20) unsigned PRI & IND Pt4 auto_increment post_author bigint(20) unsigned 0 FK->wp_users.ID post_date datetime IND Pt3 0000-00-00 00:00:00 post_date_gmt datetime 0000-00-00 00:00:00 post_content …
Introduction to WordPress Database: wp_links
In the structure of wordpress database, this is the LEAST used table as we rarely manage links, in fact categories links. This table provides ability to manage links, category wise, and then we can display them a widget, export or import them in an OPML format etc. The database structure is as follows: Table: wp_links …
Introduction to WordPress Database: wp_terms
Introduction to WordPress Database: wp_terms To categorize and manage posts and other contents, wordpress uses various taxonomies like categories, tags and link categories. These taxonomies are saved in wp_terms table. The type of the taxonomy (weather it is category or tag) is saved in wp_ term_taxonomy. The table structure is as follows: Field Type Null …
Introduction to WordPress Database: wp_comments
Introduction to WordPress Database: wp_comments Current Version : 2.9.2 Comments made by users on posts, pages or attachments are saved in this table by wordpress. To insert a comment manually, one can use wp_insert_comment function. The argument is an array, with information related to the comment. Check wp_insert_comment for more details. The structure of the …
Introduction to WordPress Database: wp_users
Introduction to WordPress Database: wp_users Current Version : 2.9.2 WordPress saves the user details in wp_users table. All the major details like user id, user_login, email address, password (In MD5) are saved in this table. Below mentioned is the structure of this table: Field Type Null Key Default Extra ID bigint(20) unsigned PRI NULL auto_increment …
Introduction to WordPress Database: wp_commentmeta
Introduction to WordPress Database: wp_commentmeta Current Version: 2.9.2 Each comment features information called the meta data and it is stored in the wp_commentmeta Just like wp_postmeta, we can store comment related information in this table. There is a very interesting article on this by soapboxdave: http://www.soapboxdave.com/2010/02/using-wordpress-comment-meta/ We can use add_comment_meta function to add contents to …