-- migrations/004_ticker_weather.sql
ALTER TABLE screens
  ADD COLUMN IF NOT EXISTS show_ticker   BOOLEAN DEFAULT false,
  ADD COLUMN IF NOT EXISTS ticker_text   TEXT,
  ADD COLUMN IF NOT EXISTS ticker_speed  INT DEFAULT 40,        -- px/sn
  ADD COLUMN IF NOT EXISTS ticker_bg     VARCHAR(20) DEFAULT '#000000',
  ADD COLUMN IF NOT EXISTS ticker_color  VARCHAR(20) DEFAULT '#ffff00',
  ADD COLUMN IF NOT EXISTS show_weather  BOOLEAN DEFAULT false,
  ADD COLUMN IF NOT EXISTS weather_city  VARCHAR(100);           -- örn: Elazig