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

[..hidden..]

Revision: 3948
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3948&view=rev
Author:   einhverfr
Date:     2011-11-01 03:36:42 +0000 (Tue, 01 Nov 2011)
Log Message:
-----------
Correcting case handling in upgrade script

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/Pg-database.sql
    branches/1.3/sql/upgrade/1.2-1.3.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2011-10-31 13:54:32 UTC (rev 3947)
+++ branches/1.3/Changelog	2011-11-01 03:36:42 UTC (rev 3948)
@@ -2,6 +2,9 @@
 Initial Release:  Monday, Oct 12 2011
 Supported Presently
 
+Changelog for LedgerSMB 1.3.4
+* Corrected case matching error in upgrade script (Chris T)
+
 Changelog for LedgerSMB 1.3.3
 * Fix for being unable to delete AR/AP drafts (Herman V)
 * Additional button cleanup (Herman V)

Modified: branches/1.3/sql/Pg-database.sql
===================================================================
--- branches/1.3/sql/Pg-database.sql	2011-10-31 13:54:32 UTC (rev 3947)
+++ branches/1.3/sql/Pg-database.sql	2011-11-01 03:36:42 UTC (rev 3948)
@@ -967,7 +967,7 @@
 sonumber|1
 yearend|1
 businessnumber|1
-version|1.3.0
+version|1.3.3
 closedto|\N
 revtrans|1
 ponumber|1

Modified: branches/1.3/sql/upgrade/1.2-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3.sql	2011-10-31 13:54:32 UTC (rev 3947)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2011-11-01 03:36:42 UTC (rev 3948)
@@ -52,14 +52,14 @@
 INSERT INTO entity (name, control_code, entity_class, country_id)
 SELECT name, 'V-' || vendornumber, 1, 
        (select id from country 
-         where lower(short_name)  = :default_country)
+         where lower(short_name)  = lower(:default_country))
 FROM lsmb12.vendor
 GROUP BY name, vendornumber;
 
 INSERT INTO entity (name, control_code, entity_class, country_id)
 SELECT name, 'C-' || customernumber, 2, 
        (select id from country 
-         where lower(short_name)  =  :default_country)
+         where lower(short_name)  =  lower(:default_country))
 FROM lsmb12.customer
 GROUP BY name, customernumber;
 
@@ -371,7 +371,7 @@
 
 INSERT INTO entity(control_code, entity_class, name, country_id)
 select 'E-' || employeenumber, 3, name,
-        (select id from country where lower(short_name) = :default_country)
+        (select id from country where lower(short_name) = lower(:default_country))
 FROM lsmb12.employee;
 
 UPDATE lsmb12.employee set entity_id = 

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