SQL

CREATE TABLE holdings  (
  guild_id INTEGER NOT NULL,
  user_id INTEGER NOT NULL,
  symbol TEXT NOT NULL,
  shares INTEGER NOT NULL DEFAULT 0,
  PRIMARY KEY (guild_id, user_id, symbol),
  FOREIGN KEY (guild_id, user_id)
                    REFERENCES users (guild_id, user_id)
                    ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
guild_id INTEGER ✓ Rename | Drop
user_id INTEGER ✓ Rename | Drop
symbol TEXT ✓ Rename | Drop
shares INTEGER Rename | Drop

Foreign Keys

Column Destination
guild_id users.guild_id
user_id users.user_id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_holdings_1
  • guild_id
  • user_id
  • symbol
 ✓ SQL
-- no sql found --
 Drop