Source: config/migrations/20260531-add-txlines-sequence.js

export const id = '20260531-add-txlines-sequence';
export const name = 'Add Sequence column to TransactionLines';
export const DRY_RUN = false;

/**
 * Adds a Sequence column to TransactionLines to preserve
 * booking line ordering (PosNr from old KPE system).
 * Uses IF NOT EXISTS to stay idempotent.
 */
export const migrate = async ({ query }) => {
    await query('SET @@system_versioning_alter_history = 1', []);
    await query(`
        ALTER TABLE TransactionLines
        ADD COLUMN IF NOT EXISTS \`Sequence\` int DEFAULT 0 AFTER \`Description\`
    `, []);
    await query('SET @@system_versioning_alter_history = 0', []);
};