Skip to content

3. The database structure

Jump to bottom
herve91 edited this page May 3, 2018 · 1 revision

databasestructure

All the database operations have been automated.

Before each database operation, the plugin validates its connection to the database, and the database model version (using the database_version table.

If the database has not been initialized, then the plugin asks if the tables should be created:

database plugin - tables not found

Once the table have been created, the plugin indicates:

database plugin - database successfully initialized

If the plugin requires a newer version of the database structure, then the plugin asks if the database should be upgraded: database plugin - upgrade database

For Archi 3.x

We provide scripts to automate the database structure creation for all the relational database brands managed by the plugin:

  • create tables (Microsoft SQL Server).sql
  • create tables (MySQL).sql
  • create tables (PostGreSQL).sql
  • create tables (SQLite).sql

Those scripts must be run against your database. Not doing so will prevent the plugin to export the models to the database. Upgrading the datamodel is also a manual process.

Clone this wiki locally