Migració 3.8 a 4.0

Core Migration from 3.8 to 4.0

Mòduls que ja no s'usen a la 4.0

delete from ir_module_dependency where module = (select id from ir_module where name = 'galatea_esale') and name = 'sale_cart';

select id, state from ir_module where name in ('product_configuration');

delete from ir_module_dependency where module in (select id from ir_module where name in ('product_configuration'));

delete from ir_module where name in ('product_configuration');

select id, state from ir_module where name in ('stock_inventory_qty', 'stock_lot_inventory_qty', 'stock_inventory_reference', 'sale_cart', 'sale_cart_discount', 'sale_cart_discount_visible', 'sale_product_stock', 'sale_product_stock_shop', 'product_configuration', 'product_price_list_category', 'account_dunning_cron', 'commission_invoice_posted2draft', 'sale_opportunity_quote', 'base_external_mapping', 'csv_import', 'csv_import_send_mail', 'csv_import_getmail', 'csv_purchase', 'csv_sale_shipment_cost', csv_sale', 'prestashop_product', 'product_not_sold', 'account_statement_of_account', 'stock_location_warehouse');

delete from ir_module_dependency where module in (select id from ir_module where name in ('stock_inventory_qty', 'stock_lot_inventory_qty', 'stock_inventory_reference', 'sale_cart', 'sale_cart_discount', 'sale_cart_discount_visible', 'sale_product_stock', 'sale_product_stock_shop', 'product_configuration', 'product_price_list_category', 'account_dunning_cron', 'commission_invoice_posted2draft', 'sale_opportunity_quote', 'base_external_mapping', 'csv_import', 'csv_import_send_mail', 'csv_import_getmail', 'csv_purchase', 'csv_sale_shipment_cost', csv_sale', 'prestashop_product', 'product_not_sold', 'account_statement_of_account', 'stock_location_warehouse'));

delete from ir_module where name in ('stock_inventory_qty', 'stock_lot_inventory_qty', 'stock_inventory_reference', 'sale_cart', 'sale_cart_discount', 'sale_cart_discount_visible', 'sale_product_stock', 'sale_product_stock_shop', 'product_configuration', 'product_price_list_category', 'account_dunning_cron', 'commission_invoice_posted2draft', 'sale_opportunity_quote', 'base_external_mapping', 'csv_import', 'csv_import_send_mail', 'csv_import_getmail', 'csv_purchase', 'csv_sale_shipment_cost', csv_sale', 'prestashop_product', 'product_not_sold', 'account_statement_of_account, 'stock_location_warehouse''));

Nous mòduls

Pre SQL

# sale_shop: eliminar restricció reference + shop:
ALTER TABLE sale_sale DROP CONSTRAINT sale_sale_reference_uniq;

# esale: renombrar reference_external a number_external + drop constrain (esale)
alter table sale_sale rename reference_external to number_external;
ALTER TABLE sale_sale DROP CONSTRAINT sale_sale_reference_external_uniq;

# stock: renombrar el camp referencia a number en inventaris
alter table stock_inventory RENAME COLUMN reference TO number;

# renombrar import csv taules
alter table profile_csv rename to import_csv;
alter table profile_csv_column rename to import_csv_column;
alter sequence profile_csv_column_id_seq rename to import_csv_column_id_seq;
alter sequence profile_csv_id_seq rename to import_csv_id_seq;

# 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;

Post SQL

# marcar totes les categories de producte a accounting
update product_category set accounting = True;

# eliminar columna category
ALTER TABLE product_template DROP COLUMN category;

# canvi login llargada:
alter table res_user_login_attempt ALTER COLUMN login TYPE character varying(512);

Magento / Prestashop / Galatea

* Canviar tags mediawiki to Creole (només italic i bold)

'''bold''' -> **bold**
''italic -> //italic//

Configuracions

Migracio3.8-4.0 (last edited 2016-06-30 06:39:36 by resteve)

Contenidos creados por el equipo de Zikzakmedia. Creative Commons By-NC-SA

PythonZikzakmedia