Creating a database table on module installation

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 ;

Note

As you can see, I replaced the usual ps_ with PREFIX_. That way, we will be able to replace the PREFIX_ string with the prefix chosen by the merchant. It's the method used in PrestaShop installer.

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

We might have...