11 lines
927 B
Markdown
11 lines
927 B
Markdown
# Phase 65 — Reviewed additive schema migration
|
|
|
|
From **Compare Schema Structures…**, select **Review Additive Migration…**.
|
|
Choose missing columns, review the SQL, copy it, or open it in a new SQL editor tab.
|
|
|
|
## Safety boundary
|
|
|
|
The generator only creates `ALTER TABLE ... ADD COLUMN` for columns present in the source but absent in an existing target table. It deliberately does **not** generate `DROP`, `MODIFY`, table creation, view creation, key/index changes, or automatically execute any DDL. Full table and view definitions and index dependencies are not available in the existing introspection snapshot. Auto-increment columns are skipped. No statement is applied without an explicit subsequent user action in the SQL editor.
|
|
|
|
Review constraints, defaults, data compatibility, and backups before execution. MySQL DDL generally causes implicit commits. Re-introspect both databases before preparing a migration.
|