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

[..hidden..]

Revision: 5171
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5171&view=rev
Author:   einhverfr
Date:     2012-11-09 08:10:39 +0000 (Fri, 09 Nov 2012)
Log Message:
-----------
Correcting upgrade/1.2-1.3.sql blank makemodel.model field and SQL comment.

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/modules/Account.sql
    branches/1.3/sql/upgrade/1.2-1.3.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2012-11-08 08:25:10 UTC (rev 5170)
+++ branches/1.3/Changelog	2012-11-09 08:10:39 UTC (rev 5171)
@@ -10,6 +10,8 @@
 * Fixed invoice date not printing on checks (Chris T, h/t Neil S)
 * Changed INSTALL to do make test, not of make install (Chris T h/t Kevin B)
 * Fixed framework for printing parts tumbnails in invoices (Chris T)
+* Upgrade now handles nulls in model field of makemodel (Chris T)
+* Fixed issue with comment in account.sql (Chris T)
 
 berend T is Berend Tober
 Chris T is Chris Travers

Modified: branches/1.3/sql/modules/Account.sql
===================================================================
--- branches/1.3/sql/modules/Account.sql	2012-11-08 08:25:10 UTC (rev 5170)
+++ branches/1.3/sql/modules/Account.sql	2012-11-09 08:10:39 UTC (rev 5171)
@@ -289,6 +289,7 @@
 $$ language plpgsql;
 
 COMMENT ON FUNCTION account__save_tax
-(in_chart_id int, in_validto date, in_rate numeric, in_minval numeric, 
-in_taxnumber text, in_pass int, in_taxmodule_id int, in_old_validto date) IS
+(in_chart_id int, in_validto date, in_rate numeric, in_minvalue numeric, 
+in_maxvalue numeric, in_taxnumber text, 
+in_pass int, in_taxmodule_id int, in_old_validto date) IS
 $$ This saves tax rates.$$; 

Modified: branches/1.3/sql/upgrade/1.2-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3.sql	2012-11-08 08:25:10 UTC (rev 5170)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2012-11-09 08:10:39 UTC (rev 5171)
@@ -376,6 +376,9 @@
 
 -- must rebuild this table due to changes since 1.2
 
+-- needed to handle null values
+UPDATE lsmb12.makemodel set model = '' where model is null;
+
 INSERT INTO makemodel
 SELECT * FROM lsmb12.makemodel;
 

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