mt5-manager/docs/publish/code/02_sql.txt
Yuriy Bykov Yuriy Bykov 97a0ec37d4 Prepare article part 4 for publication
Article:
- rename the deployment section to "Развёртывание через config/services.ini"
- keep only first-level sections in the table of contents, drop the
  archive entry
- add the warning block and the archive table in the series format
- rename screenshots to meaningful English names

Publishing helpers (docs/publish):
- build_article_html.py builds the HTML fragment for the site editor with
  anchored headings, linked table of contents, captions and code blocks
- code/ holds each code block as a separate file, description.txt the
  short description

Code:
- static/script.js: bump version to 0.3.0

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-10-28 23:43:05 +03:00
34 lines
993 B
Text
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
);