SF.net SVN: ledger-smb:[6452] branches/1.3/sql/upgrade/1.2-1.3.sql

[..hidden..]

Revision: 6452
          http://sourceforge.net/p/ledger-smb/code/6452
Author:   einhverfr
Date:     2014-01-14 04:09:04 +0000 (Tue, 14 Jan 2014)
Log Message:
-----------
Undoing accidental commit of upgrade script.

Modified Paths:
--------------
    branches/1.3/sql/upgrade/1.2-1.3.sql

Modified: branches/1.3/sql/upgrade/1.2-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3.sql	2014-01-14 04:02:39 UTC (rev 6451)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2014-01-14 04:09:04 UTC (rev 6452)
@@ -461,10 +461,7 @@
             fx_transaction, project_id, memo, invoice_id, entry_id
        FROM lsmb12.acc_trans
        JOIN lsmb12.chart ON acc_trans.chart_id = chart.id
-       JOIN account a ON chart.accno = a.accno
-      WHERE trans_id IN (select id from lsmb12.ar UNION
-                         SELECT id from lsmb12.ap UNION
-                         SELECT id FROM lsmb12.gl); 
+       JOIN account a ON chart.accno = a.accno;
 
 INSERT INTO invoice (id, trans_id, parts_id, description, qty, allocated,
             sellprice, fxsellprice, discount, assemblyitem, unit, project_id,

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


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits