# TASK — Database Foundation Review

Review the newly generated database foundation.

Files to review:

* database/schema.sql
* database/seed.sql
* database/README.md

Do NOT modify PHP code.

Do NOT modify documentation outside the database folder.

Perform a complete static review.

Verify:

1. SQL syntax consistency.
2. Foreign key integrity.
3. Circular dependency handling.
4. Index completeness.
5. Primary key definitions.
6. AUTO_INCREMENT usage.
7. Engine consistency (InnoDB).
8. Charset and collation consistency.
9. Seed execution order.
10. Idempotency of seed.sql.
11. Missing indexes.
12. Duplicate indexes.
13. Invalid foreign keys.
14. Nullable columns that conflict with foreign key actions.
15. Reserved keyword usage.
16. Import order correctness.

Additionally:

* Look for potential performance issues.
* Look for future migration risks.
* Look for inconsistent naming.
* Look for columns that should probably be UNIQUE.
* Look for missing ON DELETE / ON UPDATE actions.

Output:

1. PASS / FAIL
2. Critical Issues
3. Warnings
4. Recommendations
5. Ready for Commit?

Do not generate new SQL unless a critical issue is found.
Stop after the review.