Under admin/sql/updates/schema-change, we currently use the following file suffixes:

• mirror - runs on all nodes
• extensions - runs on all nodes as a superuser
• standalone - runs on master and standalone nodes
• mirror_only - runs on mirror nodes
• master_only - runs on master nodes

Some of these names don't make clear which nodes they run on, e.g. it's not obvious that "mirror" runs on all nodes. I propose the following changes, but am open to other suggestions:

• mirror -> all
• extensions -> all_extensions
• standalone -> master_or_standalone

We should also consider adding master_or_mirror, which can be useful for replication-related schema items; it would have been useful for the dbmirror2 additions in schema 27.