Database::getTableCreate with db prefixes

[piotr-cz]

Database::getTableCreate returns statement with prefixes instead of placeholder #__:

CREATE TABLE `foo_profile` (

Tested on MysqliDriver, but likely same results for other drivers where the method is present: SqliteDriver, OracleDriver, MysqlDriver

[mbabker]

I might argue this is intended behavior. In MysqliDriver, the database is being queried to get the statement without any post-processing and we don't have any code to replace a prefix with the placeholder currently.

[piotr-cz]

I'm not sure either whether this is the intended behavior.

the database is being queried to get the statement without any post-processing

The loadRow method invokes execute method which uses replacePrefix method.

The thing is that replacePrefix replaces placeholder with actual prefix, and the getTableCreate should require doing so the other way around.

We are not using this method in the Joomla CMS, and tests just assert return against being an array.

[mbabker]

If we come up with code to reverse a prefix into the generic #__ then sure, let's implement this change.