SQL

CREATE TABLE companies  (
  guild_id INTEGER NOT NULL,
  symbol TEXT NOT NULL,
  name TEXT NOT NULL,
  base_price REAL NOT NULL,
  slope REAL NOT NULL,
  drift REAL NOT NULL,
  player_impact REAL NOT NULL DEFAULT 0.5,
  starting_tick INTEGER NOT NULL,
  current_price REAL NOT NULL DEFAULT 0,
  last_tick INTEGER NOT NULL DEFAULT 0,
  updated_at TEXT NOT NULL,
  PRIMARY KEY (guild_id, symbol)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
guild_id INTEGER ✓ Rename | Drop
symbol TEXT ✓ Rename | Drop
name TEXT Rename | Drop
base_price REAL Rename | Drop
slope REAL Rename | Drop
drift REAL Rename | Drop
player_impact REAL Rename | Drop
starting_tick INTEGER Rename | Drop
current_price REAL Rename | Drop
last_tick INTEGER Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

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