SF.net SVN: ledger-smb:[6405] trunk/sql/upgrade/1.2-1.4.sql

[..hidden..]

Revision: 6405
          http://sourceforge.net/p/ledger-smb/code/6405
Author:   einhverfr
Date:     2014-01-07 02:51:13 +0000 (Tue, 07 Jan 2014)
Log Message:
-----------
Committing Turtle's 1.2-1.4 upgrade patch, bug 906

Modified Paths:
--------------
    trunk/sql/upgrade/1.2-1.4.sql

Modified: trunk/sql/upgrade/1.2-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.2-1.4.sql	2014-01-07 01:22:19 UTC (rev 6404)
+++ trunk/sql/upgrade/1.2-1.4.sql	2014-01-07 02:51:13 UTC (rev 6405)
@@ -29,7 +29,7 @@
   FROM lsmb12.chart WHERE charttype = 'H';
 
 SELECT account__save(id, accno, description, category, gifi_accno, NULL, contra, 
-                    CASE WHEN link like '%tax%' THEN true ELSE false END, 
+                    (CASE WHEN link like '%tax%' THEN true ELSE false END), 
                     string_to_array(link,':'), false, false)
   FROM lsmb12.chart 
  WHERE charttype = 'A';
@@ -398,7 +398,8 @@
 -- needed to handle null values
 UPDATE lsmb12.makemodel set model = '' where model is null;
 
-INSERT INTO makemodel
+--barcode will throw off SELECT * FROM makemodel
+INSERT INTO makemodel (parts_id, make, model)
 SELECT * FROM lsmb12.makemodel;
 
 INSERT INTO gifi

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


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits