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

[..hidden..]

Revision: 5607
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5607&view=rev
Author:   einhverfr
Date:     2013-01-18 08:09:49 +0000 (Fri, 18 Jan 2013)
Log Message:
-----------
Corrections to 1.2-1.4 upgradedb scripts.

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

Property Changed:
----------------
    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	2013-01-18 08:06:03 UTC (rev 5606)
+++ trunk/sql/upgrade/1.2-1.4.sql	2013-01-18 08:09:49 UTC (rev 5607)
@@ -684,10 +684,12 @@
 
 INSERT INTO jcitems(id, business_unit_id, parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            person_id, notes, total)
+            person_id, notes, total, jctype, curr)
      SELECT j.id,  project_id + 1000, parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            p.id, j.notes, coalesce(qty, 0)
+            p.id, j.notes, coalesce(qty, 0), 1, 
+            (SELECT (string_to_array(value, ':'))[1]
+               FROM lsmb12.defaults WHERE setting_key = 'curr')
        FROM lsmb12.jcitems j
        JOIN lsmb12.employee e ON j.employee_id = e.id
        JOIN person p ON e.entity_id = p.entity_id;


Property changes on: trunk/sql/upgrade/1.2-1.4.sql
___________________________________________________________________
Modified: svn:mergeinfo
   - /branches/1.3/sql/upgrade/1.2-1.3.sql:3711-5403
/branches/1.3/sql/upgrade/1.2-1.4.sql:3711-5135
   + /branches/1.3/sql/upgrade/1.2-1.3.sql:3711-5403
/branches/1.3/sql/upgrade/1.2-1.4.sql:3711-5135
/trunk/sql/upgrade/1.3-1.4.sql:5602-5603

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