[tryton-debian-vcs] tryton-server branch debian updated. debian/4.2.0-1-6-g615e20f

[Mathias Behrle]

The following commit has been merged in the debian branch:
https://alioth.debian.org/plugins/scmgit/cgi-bin/gitweb.cgi/?p=tryton/tryton-server.git;a=commitdiff;h=debian/4.2.0-1-6-g615e20f

commit 615e20f030309ea7a5cd506bb9354784e7b052d9
Author: Mathias Behrle <mathiasb at m9s.biz>
Date:   Fri Dec 16 13:44:31 2016 +0100

    Add also the manual upgrade procedures for 3.6 and 4.0 to the NEWS file.

diff --git a/debian/NEWS b/debian/NEWS
index b729a16..5eb5581 100644
--- a/debian/NEWS
+++ b/debian/NEWS
@@ -35,9 +35,23 @@ tryton-server (4.0.1-1) unstable; urgency=medium
   for Tryton to continue to work.
 
   As for each major release don't forget to backup your database(s) and
-  then run the database update with
+  follow the upgrade procedures:
+
+  Tax signs for credit notes have been changed and must be updated via SQL
+  *before* the 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;
+  
+  Finally run the database update with
   $ sudo -u tryton trytond-admin -v -c /etc/tryton/trytond.conf --all -d <your_database_name>
-  and restart the server(s) with
+
+  Column category from product.template must be dropped via SQL
+  after the update:
+    ALTER TABLE product_template DROP COLUMN category;
+
+  Finally restart the server(s) with
   $ sudo service tryton-server restart
   $ sudo service tryton-server-cron restart
 
@@ -57,9 +71,16 @@ tryton-server (3.8.0-1) unstable; urgency=medium
 tryton-server (3.6.0-1) unstable; urgency=medium
 
   This is the new major release 3.6.0.
+  
   As for each major release don't forget to backup your database(s) and
-  then run the database update with
-  $ sudo -u tryton trytond -v -c /etc/tryton/trytond.conf --all -d <your_database_name>
+  follow the upgrade procedures:
+
+  Second currency amounts must be updated via SQL:
+    UPDATE account_move_line SET amount_second_currency = (amount_second_currency * -1)
+    WHERE amount_second_currency IS NOT NULL AND SIGN(amount_second_currency) != SIGN(debit - credit);
+  
+  Finally run the database update with
+  $ sudo -u tryton trytond-admin -v -c /etc/tryton/trytond.conf --all -d <your_database_name>
   and restart the server with
   $ sudo service tryton-server restart
 
-- 
tryton-server