SQL

CREATE TABLE daily_close  (
  guild_id INTEGER NOT NULL,
  symbol TEXT NOT NULL,
  date TEXT NOT NULL,
  close_price REAL NOT NULL,
  PRIMARY KEY (guild_id, symbol, date)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
guild_id INTEGER ✓ Rename | Drop
symbol TEXT ✓ Rename | Drop
date TEXT ✓ Rename | Drop
close_price REAL Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_daily_close_1
  • guild_id
  • symbol
  • date
 ✓ SQL
-- no sql found --
 Drop