9. Annex: Database Schema

9.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.