317eb2c3

Author: Michael Lynch <git@mtlynch.io>

Committer: Michael Lynch <mtlynch@noreply.codeberg.org>

Store user IDs as UUIDv4 values (#134)

Change Little Moments user IDs from numeric uint32 values to generated UUIDv4 identifiers. Store users.id and all user foreign keys as TEXT in the initial SQLite schema because no existing database migration path is needed.

Validate user IDs when parsing strings, enforce the UUIDv4 shape in SQLite, and map Tinybeans numeric user IDs to generated Little Moments UUIDs during import.

Reviewed-on: https://codeberg.org/mtlynch/little-moments/pulls/134