# Schema Patch Report

- Generated: 2026-06-24 18:17:17
- Local schema: `kemetret` (162 tables)
- Live dump schema: `yjsvnlte_pos_db` (156 tables)
- SQL patch: `schema_patch_kemetret_to_yjsvnlte_pos_db_20260624.sql`

## Summary
- missing_tables: 6
- extra_tables: 0
- added_columns: 15
- modified_columns: 0
- added_indexes: 3
- added_constraints: 0
- index_conflicts: 0
- constraint_conflicts: 0
- extra_columns_on_live: 0

## Missing Tables
- `accounting_account_mappings`
- `accounting_periods`
- `daily_closings`
- `journal_entries`
- `journal_entry_audits`
- `journal_entry_lines`

## Live-Only Tables
- None

## Existing Table Column Changes
- `account_types`: 7 add, 0 modify
- `accounts`: 8 add, 0 modify

## Index Additions
- `accounts`: 3

## Constraint Additions
- None

## Manual Review Notes
- None

## Validation
- Applied successfully to temporary local database `yjsvnlte_pos_db_liveserver_compare_20260624`.
- After applying: missing tables = 0, missing columns = 0, missing indexes = 0, missing constraints = 0.
- Remaining displayed column differences are MySQL formatting only, where MySQL expands `COLLATE utf8mb4_unicode_ci` to `CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci`.