We will now create a table named Posts which will hold all our blog posts.
This table will have the following five fields:
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.