SF.net SVN: ledger-smb:[6953] branches/1.3/sql/upgrade/sl2.8-1.3.sql

[..hidden..]

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

Modified Paths:
--------------
    branches/1.3/sql/upgrade/sl2.8-1.3.sql

Modified: branches/1.3/sql/upgrade/sl2.8-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/sl2.8-1.3.sql	2014-03-28 03:06:48 UTC (rev 6952)
+++ branches/1.3/sql/upgrade/sl2.8-1.3.sql	2014-03-28 04:06:34 UTC (rev 6953)
@@ -433,7 +433,7 @@
 
 ALTER TABLE ap ENABLE TRIGGER ap_audit_trail;
 
-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');
@@ -589,10 +589,10 @@
 
 INSERT INTO jcitems(id, project_id, parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            person_id, notes)
+            person_id, notes, total)
      SELECT j.id,  project_id, parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            p.id, j.notes
+            p.id, j.notes, 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