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

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  COLUMN_TYPE,
  IS_NULLABLE
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'customerUsers'
  AND COLUMN_NAME = 'defaultName';