SF.net SVN: ledger-smb:[4082] branches/1.3/sql

[..hidden..]

Revision: 4082
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4082&view=rev
Author:   ehuelsmann
Date:     2011-11-25 16:49:57 +0000 (Fri, 25 Nov 2011)
Log Message:
-----------
Fix bug 3437949: Batch printing menu items of invoices and sales orders reversed.

Modified Paths:
--------------
    branches/1.3/sql/Pg-database.sql
    branches/1.3/sql/modules/Fixes.sql

Modified: branches/1.3/sql/Pg-database.sql
===================================================================
--- branches/1.3/sql/Pg-database.sql	2011-11-25 14:56:50 UTC (rev 4081)
+++ branches/1.3/sql/Pg-database.sql	2011-11-25 16:49:57 UTC (rev 4082)
@@ -2877,11 +2877,11 @@
 117	module	bp.pl	294
 117	action	search	295
 117	vc	customer	297
+117	type	invoice	296
 118	module	bp.pl	298
 118	action	search	299
 118	vc	customer	300
-118	type	invoice	301
-117	type	sales_order	296
+118	type	sales_order	301
 120	module	bp.pl	302
 120	action	search	303
 120	vc	customer	304

Modified: branches/1.3/sql/modules/Fixes.sql
===================================================================
--- branches/1.3/sql/modules/Fixes.sql	2011-11-25 14:56:50 UTC (rev 4081)
+++ branches/1.3/sql/modules/Fixes.sql	2011-11-25 16:49:57 UTC (rev 4082)
@@ -44,3 +44,10 @@
 BEGIN;
 ALTER TABLE entity_credit_account ADD FOREIGN KEY (language_code) REFERENCES language(code);
 COMMIT;
+
+BEGIN;
+UPDATE menu_attribute SET value = 'invoice'
+   WHERE node_id = 117 AND attribute = 'type';
+UPDATE menu_attribute SET value = 'sales_order'
+   WHERE node_id = 118 AND attribute = 'type';
+COMMIT;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.