mt5-manager/docs/articles/part-04/publish/code/02_sql.txt

CREATE TABLE IF NOT EXISTS terminals (
    id         INTEGER PRIMARY KEY,
    folder     TEXT NOT NULL UNIQUE,  -- ключ связи с config.json
    path       TEXT,                  -- полный путь, для диагностики
    company    TEXT,
    build      INTEGER,
    first_seen INTEGER,
    last_seen  INTEGER
);

CREATE TABLE IF NOT EXISTS states (
    terminal_id   INTEGER PRIMARY KEY REFERENCES terminals(id),
    updated_at    INTEGER NOT NULL,
    connected     INTEGER,
    ping_last     INTEGER,
    login         INTEGER,
    server        TEXT,
    currency      TEXT,
    leverage      INTEGER,
    trade_mode    INTEGER,
    trade_allowed INTEGER,
    balance       REAL,
    equity        REAL,
    profit        REAL,
    margin        REAL,
    margin_free   REAL,
    margin_level  REAL,
    credit        REAL,
    positions     INTEGER,
    company       TEXT,
    holder_name   TEXT,
    error_code    INTEGER DEFAULT 0,
    error_text    TEXT
);