Skip to main content

Monthly Update - 2025-09

· One min read
TeaQL Spring Boot Starter
TeaQL Spring Boot Starter
Core Contributor

This month's updates bring important MySQL schema management improvements, including automatic foreign key generation and alter column fixes.

Changes​

teaql-spring-boot-starter​

🚀 Add MySQL FK generation when ensuring tables​

TeaQL now automatically generates foreign key constraints when ensuring database tables. When ensureTables runs, MySQL repositories will detect entity relationships defined in the domain model and create the corresponding FOREIGN KEY constraints in the database schema.

+ MysqlRepository: added FK generation logic to ensureTables()
+ Automatically creates FK constraints based on domain model relationships

This means you no longer need to manually manage foreign key relationships in your MySQL database — TeaQL handles it for you based on your model definitions.

🚀 Fix MySQL ALTER issue​

Fixed an issue with the MySQL ALTER TABLE statement generation. The alter column logic was incorrectly constructing DDL statements, which could cause schema migration failures.

+ MysqlRepository: corrected ALTER TABLE column modification logic
+ Resolved edge cases in column type changes and nullability updates
Technical Details

The ensureTables process now follows this order:

  1. Create missing tables
  2. Add missing columns
  3. Generate foreign keys (new)
  4. Fix column type mismatches

This ensures FK constraints reference columns that already exist.