SF.net SVN: ledger-smb:[6954] trunk/sql/upgrade/sl2.8-1.4.sql

[..hidden..]

Revision: 6954
          http://sourceforge.net/p/ledger-smb/code/6954
Author:   einhverfr
Date:     2014-03-28 04:07:12 +0000 (Fri, 28 Mar 2014)
Log Message:
-----------
1.4-version of sql-ledger migration changes for latest 2.8

Modified Paths:
--------------
    trunk/sql/upgrade/sl2.8-1.4.sql

Modified: trunk/sql/upgrade/sl2.8-1.4.sql
===================================================================
--- trunk/sql/upgrade/sl2.8-1.4.sql	2014-03-28 04:06:34 UTC (rev 6953)
+++ trunk/sql/upgrade/sl2.8-1.4.sql	2014-03-28 04:07:12 UTC (rev 6954)
@@ -442,7 +442,7 @@
 -- ### Move those to business_units
 -- ### TODO: Reconciled disappeared from the source table...
 
-ALTER TABLE sl28.acc_trans ADD COLUMN entry_id integer;
+--ALTER TABLE sl28.acc_trans ADD COLUMN entry_id integer;
 
 update sl28.acc_trans
   set entry_id = nextval('acc_trans_entry_id_seq');
@@ -625,10 +625,10 @@
 
 INSERT INTO jcitems(id, parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            person_id, notes, business_unit_id)
+            person_id, notes, business_unit_id, total)
      SELECT j.id,  parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            p.id, j.notes, j.project_id+1000
+            p.id, j.notes, j.project_id+1000, qty * sellprice
        FROM sl28.jcitems j
        JOIN sl28.employee e ON j.employee_id = e.id
        JOIN person p ON e.entity_id = p.entity_id;

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


------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits