Repository navigation
FH6 Local Crypto Tool v1.1.1
·
38 commits
to main
since this release
FH6 Local Crypto Tool v1.1.1
Version 1.1.1 is a focused database-merge hotfix.
Whole-table replacement
- Added Replace whole table (drop + rebuild) for donor tables that must completely replace their staged counterparts.
- The selected staged table is dropped, recreated from the donor's complete
CREATE TABLEdefinition, and populated only with donor rows. - Preserves primary keys, constraints, defaults,
STRICT/WITHOUT ROWIDproperties, row IDs, indexes, and triggers. - Indexes and triggers are rebuilt after the row copy so donor triggers cannot alter imported data while it is being restored.
- Foreign-key enforcement is explicitly disabled and verified before the transaction, preventing a replacement from being silently blocked by linked tables.
- Rebuilt row counts and contents are compared in both directions with the donor before the output is accepted.
- SQLite
quick_checkmust pass before the completed database is written.
Clear merge behavior
- The original per-table action is now labeled Merge rows. It remains an ID-based row upsert: selected matching rows are updated, new rows are inserted, and base-only rows remain.
- Replace whole table (drop + rebuild) is visually separate and removes base-only rows from that selected table.
- Sparse patch databases containing only selected tables or rows remain supported through Merge rows. Do not use whole-table replacement for a sparse table unless it intentionally represents that table's complete contents.
- Neither the staged database nor donor database is overwritten. Every merge produces a new SQLite output.
Verification and packaging
- Tested with related wheel-category and annotation-style tables, including obsolete base rows, foreign keys, custom indexes, triggers, and tables without explicit primary keys.
- Confirmed that rebuilt tables match donor rows and row IDs exactly and that obsolete staged rows are removed.
- Whole-table replacement was independently confirmed against a real modded database.
- The Windows x64 executable is genuinely self-contained and does not require a separate .NET installation.