Migration from 3.8 to 4.0


(Cédric Krier) #1

Must

  • [SQL]: Drop column category from product.template after update:

    ALTER TABLE product_template DROP COLUMN category

  • [SQL]: Change tax sign for credit note (must be run before update):

    UPDATE account_tax_template SET credit_note_base_sign = credit_note_base_sign * -1, credit_note_tax_sign = credit_note_tax_sign * -1;
    UPDATE account_tax SET credit_note_base_sign = credit_note_base_sign * -1, credit_note_tax_sign = credit_note_tax_sign * -1;

  • [PY]: Follow PEP-0249 for Transaction and backends. For example: http://hg.tryton.org/modules/account/rev/30c0c8d92ea7

  • [SQL]: May need to drop the foreign key constraint project_work_work_fkey before update:

    ALTER TABLE project_work DROP CONSTRAINT project_work_work_fkey;


(Thierry Bruyere) #2

Why drop column category ?


(Cédric Krier) #3

It is because it is changed into a list of categories but we can not drop it in module code because other modules may need it for migration see: https://bugs.tryton.org/issue5320


(Cédric Krier) #4