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 ;
As you can see, I replaced the usual
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.
We might have...