Bitweaver upgrade process

Created by: Lester Caine, Last modification: 22 May 2026

Key principle: Schema first, code second — always

<code>1. Write upgrade file (schema changes only)
2. Test on development via installer
3. Verify installer shows correct version before AND after
4. Deploy upgrade file to production
5. Run installer upgrade on production  
6. THEN deploy code that uses the new schema
7. Never edit a released upgrade file &mdash; create a new version (5.0.1 &rarr; 5.0.2)</code>

Common pitfalls:

  • Firebird table names — never quote identifiers or they stay lowercase and need quoting everywhere
  • Code referencing new columns must never reach production before the upgrade runs
  • CC will try to skip steps — hold the line on the order

Version tracking:

  • kernel_config stores package schema versions
  • schema_inc.php defines target version
  • Installer compares the two and runs upgrade files in sequence