Summary

• sort table names in natural numeric order in both the table overview and sidebar
• preserve MySQL column default values, including explicit empty-string defaults and supported expressions
• add per-column default, character set, collation, and comment editing
• generate complete MySQL column definitions while filtering DEFAULT_GENERATED
• keep column-level character set behavior scoped to MySQL

Testing

• npm --prefix frontend test -- src/components/TableDesignerSqlPreview.test.tsx src/utils/tableOverviewFilter.test.ts src/utils/columnDefinition.test.ts src/components/tableDesignerSchemaSql.test.ts (58 passed)
• sidebar natural-sort focused test (passed)
• npm --prefix frontend run build (passed; existing chunk-size warning only)
• go test ./internal/db ./internal/connection (passed)
• i18n JSON validation, Go formatting check, and git show --check (passed)

Validation notes

• The full sidebar test file still has 5 unrelated source/CSS sentinel failures. The same 5 failures reproduce against the pre-sidebar-change baseline.
• Repository-wide frontend and Go suites contain existing environment/baseline failures unrelated to this change.
• Docker was unavailable, so a disposable MySQL round-trip test could not be run.
• The development page was reachable, but Playwright is not installed in the repository, so automated UI interaction screenshots were not produced.

Known limitation

MySQL SHOW FULL COLUMNS cannot reliably distinguish no DEFAULT clause from an explicit DEFAULT NULL. This change preserves non-null defaults and explicit empty-string defaults without introducing a full SHOW CREATE TABLE parser.

Closes #705