SQL

CREATE TABLE user_settings  (
  user_id TEXT NOT NULL,
  key TEXT NOT NULL,
  value TEXT NOT NULL,
  updated_at TEXT NOT NULL DEFAULT (datetime('now')),
  PRIMARY KEY (user_id, key),
  FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
user_id TEXT ✓ Rename | Drop
key TEXT ✓ Rename | Drop
value TEXT Rename | Drop
updated_at TEXT Rename | Drop

Foreign Keys

Column Destination
user_id user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_user_settings_1
  • user_id
  • key
 ✓ SQL
-- no sql found --
 Drop