Query

pilot.db — trainer_settings

SQL

CREATE TABLE trainer_settings  (
  trainer_id INTEGER NOT NULL REFERENCES trainers(id) ON DELETE CASCADE,
  key TEXT NOT NULL,
  value TEXT NOT NULL,
  -- JSON-Stringified
  PRIMARY KEY (trainer_id, key)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
trainer_id INTEGER ✓ Rename | Drop
key TEXT ✓ Rename | Drop
value TEXT Rename | Drop

Foreign Keys

Column Destination
trainer_id trainers.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_trainer_settings_1
  • trainer_id
  • key
 ✓ SQL
-- no sql found --
 Drop