J’ai regrouper les différent bout de script intégrer dans les changelog depuis la 7 à la 7.2.2
(Des fois ils se répètent)
DELETE FROM meta_help WHERE field_name = ‹ generateProjectOrder ›;
UPDATE account_move_line moveLine
SET bank_reconciled_amount = 0
FROM account_account account
JOIN account_account_type accountType
ON account.account_type = accountType.id
WHERE moveLine.account = account.id
AND accountType.technical_type_select <> ‹ cash ›;
UPDATE production_sop_line SET sop_manuf_gap = sop_manuf_gap100;
UPDATE production_sop_line SET sop_sales_gap = sop_sales_gap100;
UPDATE production_sop_line SET sop_stock_gap = sop_stock_gap*100;
UPDATE studio_app
SET image = null
WHERE image in
(SELECT id
FROM meta_file
where file_path LIKE ‹ app-% ›
AND file_type = ‹ image/png ›);
DELETE
FROM meta_file
WHERE file_path LIKE ‹ app-% ›
AND file_type = ‹ image/png ›;
ALTER TABLE account_invoice_payment ADD COLUMN IF NOT EXISTS reconcile bigint;
UPDATE account_invoice_payment payment SET reconcile = (SELECT id FROM account_reconcile reconcile WHERE reconcile.invoice_payment = payment.id) WHERE payment.reconcile IS NULL;
UPDATE account_invoice_payment payment SET reconcile = (
SELECT MIN(reconcile.id) FROM account_reconcile reconcile
INNER JOIN account_invoice_term_payment itp ON itp.invoice_payment = payment.id
INNER JOIN account_invoice_term it ON it.id = itp.invoice_term
INNER JOIN account_move_line ml ON ml.id = it.move_line
WHERE reconcile.debit_move_line = ml.id OR reconcile.credit_move_line = ml.id) WHERE payment.reconcile IS NULL;
ALTER TABLE account_reconcile DROP COLUMN invoice_payment;
DELETE FROM meta_action
WHERE name IN (
‹ action-invoice-term-method-compute-total-payment-session ›,
‹ action-payment-session-record-set-session-total-amount-btn ›,
‹ action-method-payment-session-compute-total ›
);
SOP/MPS: Rename manufacturingYear to manufacturingPeriod and added demo data.
Pourtant même en intégrant cela dans la BDD (Copie) de la 6.5, il y a souvent des erreurs comme quoi la table est inexistante etc …
(J’attends toujours le rappelle du tech AXELOR … )