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

[..hidden..]

Revision: 5842
          http://sourceforge.net/p/ledger-smb/code/5842
Author:   einhverfr
Date:     2013-05-20 12:23:09 +0000 (Mon, 20 May 2013)
Log Message:
-----------
Correcting 1.2-1.4 migrations for taxincluded settings

Modified Paths:
--------------
    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-05-20 11:46:43 UTC (rev 5841)
+++ trunk/sql/upgrade/1.2-1.4.sql	2013-05-20 12:23:09 UTC (rev 5842)
@@ -57,10 +57,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 = 
@@ -71,10 +72,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.