Creating A Books Database Table

Now, we're going to start the process of manually building a 'books' module.  For us, this process starts with building a simple database table.  Below is a three minute video, showing you precisely how to do this.  For those in a hurry, the SQL code for creating our 'books' database table is available at the bottom of this page.

'Books' Table SQL

Below is the SQL code required for creating the 'books' database table:

CREATE TABLE `books` (
  `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `author_id` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL
);