50 lines (28 loc) · 1.16 KB

librematch-database

Migrations for the Libre:Match Database

Development

librematch_dev.sqlite3 is the database that can be used for local development of the collector and other components.

Entity-Relationship diagram (updated at 2022-10-30)

Setup

Install dbmate.

Running Migrations

Create database and migrate to the latest version

dbmate --url <database_driver://db_url> up
Rollback the latest migration

dbmate --url <database_driver://db_url> down
Drop database if it exists

dbmate --url <database_driver://db_url> drop

Example

dbmate up dbmate down dbmate drop (by using the .env file in the root-dir of this repository)

License

AGPL-3.0-or-later; see LICENSE.