SQL

CREATE TABLE channels  (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  icon TEXT,
  category TEXT,
  description TEXT,
  display_order INTEGER DEFAULT 0
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?