10. Annex: Database Schema

Important

Always back up your .db file before performing database migrations.

10.1. Version 1.0.0

Version 1.0.0 of the database contains the following tables:

position: Stores the positions with the columns id (primary key) and state (state of the position in JSON format).
analysis: Stores the analyses of the positions with the columns id (primary key), position_id (foreign key referencing position), and data (analysis data in JSON format).
comment: Stores the comments associated with the positions with the columns id (primary key), position_id (foreign key referencing position), and text (comment text).
metadata: Stores the metadata of the database with the columns key (primary key) and value (value associated with the key).

Version 1.1.0 of the database adds the following table:

command_history: Stores the command history with the columns id (primary key), command (text of the command), and timestamp (date and time of command execution).

The other tables remain unchanged from version 1.0.0.

To migrate the database from version 1.0.0 to version 1.1.0, execute the command migrate_from_1_0_to_1_1 in blunderDB.

Version 1.2.0 of the database adds the following table:

filter_library: Stores search filters with the columns id (primary key), name (filter name), command (command associated with the filter), and edit_position (position edited when saving the filter).

The other tables remain unchanged from version 1.1.0.

To migrate the database from version 1.1.0 to version 1.2.0, execute the command migrate_from_1_1_to_1_2 in blunderDB.