CortenDesk 0.9.1

Two fixes for problems reported against 0.9.0. Upgrading is recommended for everyone on MariaDB.

Fixed

• Migrations failed on MariaDB (and on any MySQL left at explicit_defaults_for_timestamp=0). Installing or upgrading to 0.9.0 died with SQLSTATE[42000]: 1067 Invalid default value for 'expires_at' and left the database half-migrated. A NOT NULL TIMESTAMP with no default gets an implicit '0000-00-00 00:00:00' on those servers, which Laravel's strict mode rejects. Four tables were affected.
• Single sign-on refused users whose provider does not send email_verified (#6). The claim is optional in OpenID Connect and several providers never send it — Microsoft Entra ID among them. An absent claim was treated exactly like a provider reporting the address as unverified, so those users could never be matched to an account. Absent and denied are now different: an absent claim is trusted, an explicit "not verified" is still refused, and Settings → SSO gains a switch to require the claim for providers that let people choose their own address.

Notes

• If 0.9.0 already failed on you, just upgrade and run php artisan migrate (the Docker image does it on start). The migration that failed never created anything, so there is nothing to repair by hand.
• No configuration changes are needed. Everything added in 0.9.0 still defaults to off.

docker pull marcpope/cortendesk:0.9.1
docker pull ghcr.io/marcpope/cortendesk:0.9.1