ALTER TABLE cards ADD COLUMN provider TEXT NOT NULL DEFAULT 'jira'
  CHECK (provider IN ('jira', 'github'));

ALTER TABLE cards ADD COLUMN external_url TEXT DEFAULT NULL;

CREATE INDEX IF NOT EXISTS idx_cards_provider ON cards (provider, card_id);

PRAGMA user_version = 2;
