763ad23e

Enable PRAGMA foreign_keys so REFERENCES clauses are enforced (#171)

SQLite ignores foreign key constraints by default. Without this pragma,
the REFERENCES clauses on magic_login_tokens and auth_sessions are
silently skipped.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

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

Agent Instructions

Each run corresponds to one flake attribute. Click a run for its logs and status.

Example: https://nix-ci.com/cb:mtlynch:little-moments/master/763ad23eed1aa9d2215c6d85c9c753164f2a09cf/72cdbf64-6f76-46e3-b639-e0bddb660094

Wait for suite to complete:

curl --netrc -N https://nix-ci.com/cb:mtlynch:little-moments/master/763ad23eed1aa9d2215c6d85c9c753164f2a09cf/wait

This page is also available in machine-friendly formats. Request one with the Accept header:

• curl --netrc -H 'Accept: application/json' https://nix-ci.com/cb:mtlynch:little-moments/master/763ad23eed1aa9d2215c6d85c9c753164f2a09cf
• curl --netrc -H 'Accept: text/markdown' https://nix-ci.com/cb:mtlynch:little-moments/master/763ad23eed1aa9d2215c6d85c9c753164f2a09cf

For more instructions, fetch https://nix-ci.com/instructions .