How to add PREFIX tables to install.sql in OpenCart 2 OCMOD when installing the module?

Question

opencart

By default, tables in the database have the prefix oc_
Among the installed modules, I see that people write like this: oc_table
But what happens if I have a different prefix?
How can I use it to modify tables with install.sql?

Answer 1

So far I have achieved the result using the install.php file

$query = "ALTER TABLE `".DB_PREFIX."category_description`
ADD `name_genitive` VARCHAR( 100 ) NOT NULL AFTER `name`,
ADD `name_singular` VARCHAR( 100 ) NOT NULL AFTER `name_genitive`; ";	
$result = $this->db->query($query);

Answer 2

Usually use the DB_PREFIX constant