members.uuid is marked as nullable in database schema

[nikwen]

Issue Summary

#11341 introduced UUIDs for members.

It introduced a migration to backfill UUIDs for existing members, and introduced defaults so that each new member would have a UUID.

It seems to me like the database schema should be adjusted to mark the members.uuid column as nullable: false.

When #14600 introduced UUIDs for newsletters, it included a migration to drop nullable from the new newsletters.uuid column. A similar migration could probably be created for the members table.

Steps to Reproduce

1. Look at the schema here:

   Ghost/ghost/core/core/server/data/schema/schema.js

   Line 428 in 048f177

   uuid: {type: 'string', maxlength: 36, nullable: true, unique: true, validations: {isUUID: true}},

Ghost Version

5.108.1

Node.js Version

20.18.1

How did you install Ghost?

Irrelevant for the issue

Database type

MySQL 5.7

Browser & OS version

No response

Relevant log / error output

Code of Conduct

• I agree to be friendly and polite to people in this repository

[sagzy]

Great find, and very valid! Thank you for opening the issue 🙌