User Story (Required on creation):

As a user, I can change set a database schema or a table prefix and the engine creates the database schema automatically when bootstrapping.

Functional Requirements (Required before implementation):

When setting the databaseTablePrefix or databaseSchema property, the default create scripts are adjusted accordingly on the fly and the database schema is created automatically; currently, the create scripts need to be manually adjusted to reflect the aforementioned properties.

Technical Requirements (Required before implementation):

-

Limitations of Scope (Optional):

-

Hints (optional):

-

Solution ideas

1. Use regular expressions to adjust the default create scripts on the fly
2. Use a template language to define where in the schema definitions the schema name/table prefix should be set

Original Ticket Description

By adding the following setting to process.xml, it is expected tables be created with this schema and prefix. But tables are created in default schema and no prefix applied.

<property name="databaseTablePrefix">MY_SCHEMA.MY_PREFIX</property>

It needs to be when create table automatically with databaseSchemaUpdate=true, schema and table prefix are also applied.