-- Step 39 verification: customer avatar fields
-- Safe to run on hosting dev/prod after docs/step-39-add-customer-avatar-fields.sql.
-- This script is read-only.

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  COLUMN_TYPE,
  IS_NULLABLE,
  COLUMN_DEFAULT
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'customerUsers'
  AND COLUMN_NAME IN ('avatarType', 'avatarStyle', 'avatarSeed', 'avatarUrl')
ORDER BY ORDINAL_POSITION;
