SyncHistorySQL

Parameters

• useDefaults true - use default parameters. Save data to the COMMON hierarchy, to the db/ram/{server_name} directory.{account number}.trade.db

you can specify useDefaults=false and set your own save options:

• useCommon - use the COMMON hierarchy or the data directory of the current terminal
• useFolder - directory to save the database
• useFilename - the name of the database inside the directory

Database schema

The database contains the necessary minimum, in the style of mt4 and adapted for frequent inserts. After creating the database with the script, you can make your own adjustments to it (add indexes, computable fields, additional data and tables)

CREATE TABLE IF NOT EXISTS 
History (
        ticket          INT PRIMARY KEY,
        symbol          VARCHAR(16),
        'type'          VARCHAR(16),
        lots            REAL,
        openPrice       REAL,
        stopLoss        REAL,
        takeProfit      REAL,
        price           REAL,
        'time'          DATETIME,
        closeTime       DATETIME,
        expiration      DATETIME,
        profit          REAL,
        swap            REAL,
        commission      REAL,
        magic           INTEGER,
        'comment'       VARCHAR(255)
) WITHOUT ROWID;