Basic schema filename layout consists of 3 basic parts:
- name of relational database management system (RDBMS) for which it’s intended (e.g.
derby,mysql,postgresql,sqlserver); - name of the Tigase component for which it’s intended;
- version of the schema file.
For each component and version it’s possible (but not mandatory) to split all database related functionality into multiple
files but it’s essential that they would be linked/included in the base file for particular database/component/version file.
This allows separating Stored Procedures (-sp), base schema (-schema) and setting properties (-props). In principle the filename pattern looks as follows
<RDBMS_name>-<tigase_component>-schema-<version>[-<sub_schema>].sql
For example schema file for version 7.0.0 of Tigase Server for Derby looks as follow:
derby-server-schema-7.0.0-schema.sql
