Database Schema

Schema Definition

The only file containing the schema of the bibsonomy database is bibsonomy-database/src/main/resources/bibsonomy-db-schema.sql. If you add, delete or modify tables, please transcribe them in this file. It is used to create the test database for unit tests.

Also provide a migration file with all necessary queries to change the current version of the schema to the new one (folder: database/migrations/VERSION).

Other modules using a separate database might have a separate schema description (e.g., the recommender module).

Creating the Test Database

The schema is used to create the test database. To fill the database with some initial test values the file bibsonomy-database/src/test/resources/database/insert-test-data.sql is used.