SQL

CREATE TABLE strategy_logs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  time DATETIME,
  symbol TEXT,
  price REAL,
  rsi REAL,
  macd REAL,
  bias REAL,
  pred_10m TEXT,
  conf_10m INTEGER,
  pred_30m TEXT,
  conf_30m INTEGER,
  strategy TEXT,
  backtest_10m TEXT DEFAULT '⏳ 待回测',
  backtest_30m TEXT DEFAULT '⏳ 待回测'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
time DATETIME ✓ Rename | Drop
symbol TEXT ✓ Rename | Drop
price REAL ✓ Rename | Drop
rsi REAL ✓ Rename | Drop
macd REAL ✓ Rename | Drop
bias REAL ✓ Rename | Drop
pred_10m TEXT ✓ Rename | Drop
conf_10m INTEGER ✓ Rename | Drop
pred_30m TEXT ✓ Rename | Drop
conf_30m INTEGER ✓ Rename | Drop
strategy TEXT ✓ Rename | Drop
backtest_10m TEXT ✓ Rename | Drop
backtest_30m TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?