Migration from 5.8 to 6.0

Must

  • [SQL] fix currency, invoice_type and party on invoice line

    UPDATE account_invoice_line SET currency = (SELECT currency FROM account_invoice WHERE id = account_invoice_line.invoice);
    UPDATE account_invoice_line SET invoice_type = (SELECT type FROM account_invoice WHERE id = account_invoice_line.invoice) WHERE invoice_type IS NOT NULL;
    UPDATE account_invoice_line SET party = (SELECT party FROM account_invoice WHERE id = account_invoice_line.invoice) WHERE party IS NOT NULL;
    
  • [SQL] before update, add access on field

    ALTER TABLE ir_model_field ADD COLUMN "access" BOOLEAN
    

Should

  • [SQL] after update, remove code column
    ALTER table ir_sequence_type DROP COLUMN code