[1.8] Main app: database migration for client e-invoicing columns

[nielsdrost7]

Target repository: InvoicePlane (main app) · branch prep/v180
Related feature issues: #13 · #14

What to do

Create a database migration file for InvoicePlane v1.8.0 that adds the following column to ip_clients:

ALTER TABLE ip_clients
    ADD COLUMN client_peppol_id VARCHAR(100) DEFAULT NULL AFTER client_vat_id;

Also verify whether client_company_number already exists on ip_clients in the v1.8.0 schema. If it does not, add it:

ALTER TABLE ip_clients
    ADD COLUMN client_company_number VARCHAR(50) DEFAULT NULL AFTER client_vat_id;

The FatturaPA delivery fields (client_einvoice_sdi_code, client_einvoice_pec_email) are stored as key→value rows in ip_client_meta — no new columns needed for those.

Acceptance criteria

• Migration file created with the correct v1.8.0 version prefix
• client_peppol_id VARCHAR(100) DEFAULT NULL added to ip_clients
• client_company_number VARCHAR(50) DEFAULT NULL confirmed present / added to ip_clients
• Migration runs cleanly on a fresh v1.8.0 install
• Migration runs cleanly as an upgrade from v1.7.x without data loss