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

[..hidden..]

Revision: 4258
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4258&view=rev
Author:   ehuelsmann
Date:     2012-01-08 21:35:21 +0000 (Sun, 08 Jan 2012)
Log Message:
-----------
Fix the Shipping -> Ship menu pointing to sales order consolidation.

Found by Nigel Titley.

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	2012-01-08 21:16:51 UTC (rev 4257)
+++ branches/1.3/sql/Pg-database.sql	2012-01-08 21:35:21 UTC (rev 4258)
@@ -2750,10 +2750,10 @@
 63	menu	1	146
 64	module	oe.pl	147
 64	action	search	148
+64	type	ship_order	149
 65	module	oe.pl	150
 65	action	search	151
 65	type	receive_order	152
-64	type	consolidate_sales_order	149
 66	module	oe.pl	153
 66	action	search_transfer	154
 67	menu	1	155

Modified: branches/1.3/sql/modules/Fixes.sql
===================================================================
--- branches/1.3/sql/modules/Fixes.sql	2012-01-08 21:16:51 UTC (rev 4257)
+++ branches/1.3/sql/modules/Fixes.sql	2012-01-08 21:35:21 UTC (rev 4258)
@@ -79,3 +79,12 @@
                           OR op.inventory_accno_id = parts.inventory_accno_id 
                           or op.expense_accno_id = parts.expense_accno_id));
 COMMIT; 
+
+BEGIN;
+-- Fix menu Shipping -> Ship to actually point to the shipping interface
+-- used to point to sales order consolidation
+UPDATE menu_attribute
+ SET value = 'ship_order'
+ WHERE attribute='type'
+       AND node_id = (SELECT id FROM menu_node WHERE label = 'Ship');
+COMMIT;
\ No newline at end of file

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