First of all, we will create a directory named install in the module directory. In this directory, create one file named install.sql in which you will put the SQL request that you want to execute on installation. In our case, it will be the mymod_comment table creation (the one we created manually in Chapter 2, Hooks):

CREATE TABLE IF NOT EXISTS `PREFIX_mymod_comment` (
  `id_mymod_comment` int(11) NOT NULL AUTO_INCREMENT,
  `id_product` int(11) NOT NULL,
  `grade` tinyint(1) NOT NULL,
  `comment` text NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_mymod_comment`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Then, in the install method in mymodcomments.php, we will load the SQL file content and execute it.

We might have...