SQL

CREATE TABLE system_settings  (
  key         TEXT PRIMARY KEY,
  value       TEXT NOT NULL,
  description TEXT DEFAULT '',
  updated_at  DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_system_settings_1 key ✓ SQL
-- no sql found --
 Drop