authelia/internal/storage/migrations/V0009.FixConstraints.postgr...

7 lines
177 B
MySQL
Raw Permalink Normal View History

ALTER TABLE webauthn_devices
ALTER COLUMN aaguid DROP NOT NULL;
UPDATE webauthn_devices
SET aaguid = NULL
WHERE aaguid = '' OR aaguid = '00000000-00000000-00000000-00000000';