SQL

CREATE TABLE logistics_types  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL UNIQUE,
  color TEXT DEFAULT '#64748b',
  icon TEXT DEFAULT '📋'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
name TEXT Rename | Drop
color TEXT ✓ Rename | Drop
icon TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_logistics_types_1 name ✓ SQL
-- no sql found --
 Drop