-- School branding — lets each school customize their own report cards
-- and payslips (name, address, contact info, logos, colors) instead of
-- the hardcoded "Hello Kiddies School" placeholder every school
-- currently sees regardless of their actual identity.
CREATE TABLE IF NOT EXISTS school_branding (
  school_id             INTEGER PRIMARY KEY REFERENCES schools(id) ON DELETE CASCADE,
  school_name           TEXT,
  address               TEXT,
  phone                 TEXT,
  email                 TEXT,
  website               TEXT,
  report_card_logo_url  TEXT,
  payslip_logo_url      TEXT,
  primary_color         TEXT DEFAULT '#9B1C1C',
  secondary_color       TEXT DEFAULT '#f9b800',
  updated_at            TIMESTAMPTZ NOT NULL DEFAULT now()
);