SQLite: Foreign keys are not created

[masdaster]

Setting up my schema files like it's described in the docs (https://leafphp.dev/docs/database/files.html) results in the columns being created but the constraints not. I'm using a SQLite database file.

Sample: project_members.yml

relationships:
  - Project
  - User

Based on this schema file a table "project_members" is created with the columns "id", "project_id", "user_id" and the default timestamp columns. There should also be two foreign key constraints after calling db:migrate but they are missing.

Environment

• OS: Win11
• PHP: 8.4.11

Dependencies

• "leafs/aloe": "^4.0",
• "leafs/blade": "^4.0",
• "leafs/mvc-core": "^4.0",
• "leafs/leaf": "^4.0",
• "leafs/logger": "^4.0",
• "leafs/auth": "^4.2",
• "leafs/cors": "^1.2"