Can we add multiple database tables while module installation in prestashop 1.7

[Venky967]

In order to create a database table I have a function like this

 

public function installDb()

{

return (Db::getInstance()->execute('

CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'sampletable` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`username` varchar(50) NOT NULL,

`password` varchar(255) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `TRANSUNION_CONFIGURE_DETAILS_USERNAME` (`username`)

) ENGINE = '._MYSQL_ENGINE_.' CHARACTER SET utf8 COLLATE utf8_general_ci;'));

}

 

By doing this ,after my module installation a single table named "sampletable" is created.Now I want multiple tables to be created.How to achieve it?

Thank you.

[BalzoT]

Yes you can! just put you code like this 

public function installDb(){
return (Db::getInstance()->execute('QUERY') && Db::getInstance()->execute('QUERY2') && ...);
}

[Venky967]

Thanks for your instant answer .It's working fine.