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.