SQL

CREATE TABLE price_history  (
  guild_id INTEGER NOT NULL,
  symbol TEXT NOT NULL,
  tick_index INTEGER NOT NULL,
  ts TEXT NOT NULL,
  price REAL NOT NULL,
  PRIMARY KEY (guild_id, symbol, tick_index)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
guild_id INTEGER ✓ Rename | Drop
symbol TEXT ✓ Rename | Drop
tick_index INTEGER ✓ Rename | Drop
ts TEXT Rename | Drop
price REAL Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_price_history_1
  • guild_id
  • symbol
  • tick_index
 ✓ SQL
-- no sql found --
 Drop