Query

cards.db — user_settings

SQL

CREATE TABLE user_settings  (
  user_id TEXT NOT NULL,
  key TEXT NOT NULL,
  value TEXT,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (user_id, key),
  FOREIGN KEY (user_id) REFERENCES users(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 DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

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