-- =============================================================================
-- MIGRATION: Per-user light/dark theme-mode preference
-- Convention: Prisma maps createdAt→createdOn, updatedAt→updatedOn in DB
-- Run: idempotent — safe to re-execute
-- =============================================================================

BEGIN;

DO $$
BEGIN
  IF NOT EXISTS (
    SELECT 1 FROM pg_type t
    JOIN pg_namespace n ON n.oid = t.typnamespace
    WHERE t.typname = 'ThemeMode' AND n.nspname = 'admin'
  ) THEN
    CREATE TYPE admin."ThemeMode" AS ENUM ('light', 'dark');
  END IF;
END $$;

ALTER TABLE admin.users
  ADD COLUMN IF NOT EXISTS "themeMode" admin."ThemeMode" NOT NULL DEFAULT 'light';

COMMIT;