[6.x] Table does not exist: `webauthn`

[AtmoFX]

Bug description

#9239 has created an error when editing users in the CP.
Possibly important details: my users are stored in SQL, not in files.

I cannot find:

• A migration file in my folders.
• A piece of documentation about that table in v6.statamic.dev.
• A reference to what that table should be in the documentation of webauthn.

But I went to see the files in the PR and stumbled upon what I think could be the migration file in src/Console/Commands/stubs/auth/statamic_webauthn_table.php.stub.
Not sure why it creates a WEBAUTHN_TABLE table when it seems to look for WEBAUTHN table as per the error message.

How to reproduce

On 6.0-alpha.15, open a user to view or edit them in the CP.

Logs

Environment

Environment
Application Name: GaiaMine UAT
Laravel Version: 11.46.1
PHP Version: 8.3.6
Composer Version: 2.8.12
Environment: prod
Debug Mode: OFF
URL: alpha.local/
Maintenance Mode: OFF
Timezone: UTC
Locale: en

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: file
Database: mysql
Logs: stack / single
Mail: smtp
Queue: sync
Session: database

Pulse
Enabled: ENABLED
Version: v1.4.3

Livewire
Livewire: v3.6.4

Statamic
Addons: 5
Sites: 1
Stache Watcher: Disabled (auto)
Static Caching: Disabled
Version: 6.0.0-alpha.15 PRO

Statamic Addons
alt-design/alt-seo: 1.3.0
jacksleight/statamic-bard-mutator: 3.0.5
pecotamic/sitemap: 1.4.10
statamic/eloquent-driver: 4.33.0
stillat/antlers-components: 2.6.0

Statamic Eloquent Driver
Asset Containers: file
Assets: file
Blueprints: file
Collection Trees: file
Collections: file
Entries: eloquent
Fieldsets: file
Form Submissions: eloquent
Forms: file
Global Sets: file
Global Variables: file
Navigation Trees: file
Navigations: file
Revisions: file
Sites: file
Taxonomies: file
Terms: file
Tokens: file

Installation

Other (please explain)

Additional details

Site migrated from 5.x

[duncanmcclean]

Can you try running php please auth:migration?

It will publish a bunch of auth-related migrations, you can delete all but the passkeys one, then run php artisan migrate.

[jasonvarga]

Ah yeah we should probably make a simple way to get that webauthn table migration for the v5-v6 update. Maybe we could have a php please auth:webauthn-migration command.

[AtmoFX]

OK OK; so if I do php please auth:migration then remove the first file since I already have the 4 tables it creates, then it's good. And I feel it is also easy enough that if just written in the migration procedure, that would be all it needs.
Now I suppose I just need to figure out what all this does and how to activate it.

PS: I think I've read somewhere that webauthn needs no foreign key to users but would it not be cleaner to make it one?