We will now create a table named
Posts which will hold all our blog posts.
This table will have the following five fields:
id: The ID of the post
title: The post's title
body: The post's text
fk_author: This will contain the ID of the author
postedOn: The date when the post was published
The following is the SQL query that you can use to create this table:
CREATE TABLE 'Posts' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'title' text NOT NULL, 'body' longtext NOT NULL, 'fk_author' int(11) NOT NULL, 'postedOn' datetime NOT NULL, PRIMARY KEY ('id') ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Our table will be set correctly with this query.