SQL

CREATE TABLE banners  (
  id INTEGER PRIMARY KEY,
  title TEXT NOT NULL,
  subtitle TEXT,
  image TEXT,
  video_url TEXT,
  program_id INTEGER,
  display_order INTEGER DEFAULT 0
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
title TEXT Rename | Drop
subtitle TEXT ✓ Rename | Drop
image TEXT ✓ Rename | Drop
video_url TEXT ✓ Rename | Drop
program_id INTEGER ✓ Rename | Drop
display_order INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?