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

[..hidden..]

Revision: 5843
          http://sourceforge.net/p/ledger-smb/code/5843
Author:   einhverfr
Date:     2013-05-20 13:01:12 +0000 (Mon, 20 May 2013)
Log Message:
-----------
Fixing upgrade for taxincluded settings

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	2013-05-20 12:23:09 UTC (rev 5842)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2013-05-20 13:01:12 UTC (rev 5843)
@@ -52,10 +52,11 @@
 
 INSERT INTO entity_credit_account
 (entity_id, meta_number, business_id, creditlimit, ar_ap_account_id, 
-	cash_account_id, startdate, enddate, threshold, entity_class)
+	cash_account_id, startdate, enddate, threshold, entity_class,
+        taxincluded)
 SELECT entity_id, vendornumber, business_id, creditlimit, 
        (select id from account where accno = :ap), 
-	NULL, startdate, enddate, 0, 1
+	NULL, startdate, enddate, 0, 1, taxincluded
 FROM lsmb12.vendor WHERE entity_id IS NOT NULL;
 
 UPDATE lsmb12.vendor SET credit_id = 
@@ -66,10 +67,11 @@
 
 INSERT INTO entity_credit_account
 (entity_id, meta_number, business_id, creditlimit, ar_ap_account_id, 
-	cash_account_id, startdate, enddate, threshold, entity_class)
+	cash_account_id, startdate, enddate, threshold, entity_class, 
+        taxincluded)
 SELECT entity_id, customernumber, business_id, creditlimit,
        (select id from account where accno = :ar),
-	NULL, startdate, enddate, 0, 2
+	NULL, startdate, enddate, 0, 2, taxincluded
 FROM lsmb12.customer WHERE entity_id IS NOT NULL;
 
 UPDATE lsmb12.customer SET credit_id = 

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