Skip to main content

One post tagged with "schema"

View All Tags

MySQL Foreign Keys and Schema Management

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

Important MySQL schema management improvements.

Auto Foreign Key Generation​

ensureTables automatically creates foreign key constraints:

+ MysqlRepository: FK generation logic
+ Auto-create FOREIGN KEY based on domain model relationships

No need to manually manage foreign key relationships.

ALTER TABLE Fix​

Corrected MySQL ALTER TABLE statement generation:

+ Column type changes and nullability updates
+ Schema migration edge case handling

ensureTables Flow​

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

Checker Optimization​

needCheck logic optimized to reduce unnecessary validation overhead.