you can use this in php code type 'module'
public function installDB()
{
return Db::getInstance()->execute('
CREATE TABLE `'._DB_PREFIX_.'test`
`id_test` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id_test`)
) DEFAULT CHARSET=utf8;');
}