SF.net SVN: ledger-smb:[6709] trunk/sql/upgrade

[..hidden..]

Revision: 6709
          http://sourceforge.net/p/ledger-smb/code/6709
Author:   einhverfr
Date:     2014-01-30 07:59:14 +0000 (Thu, 30 Jan 2014)
Log Message:
-----------
Adding default currency to upgrades.

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

Modified: trunk/sql/upgrade/1.2-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.2-1.4.sql	2014-01-29 15:03:48 UTC (rev 6708)
+++ trunk/sql/upgrade/1.2-1.4.sql	2014-01-30 07:59:14 UTC (rev 6709)
@@ -83,6 +83,8 @@
 	(SELECT id FROM entity_credit_account e 
 	WHERE e.meta_number = customernumber AND customer.entity_id = e.entity_id and entity_class = 2);
 
+UPDATE entity_credit_account SET curr = defaults_get_defaultcurrency()
+ WHERE curr IS NULL;
 --Company
 
 INSERT INTO company (entity_id, legal_name, tax_id)

Modified: trunk/sql/upgrade/1.3-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.3-1.4.sql	2014-01-29 15:03:48 UTC (rev 6708)
+++ trunk/sql/upgrade/1.3-1.4.sql	2014-01-30 07:59:14 UTC (rev 6709)
@@ -132,6 +132,8 @@
 INSERT INTO entity_bank_account (id, entity_id, bic, iban)
 SELECT id, entity_id, bic, iban FROM lsmb13.entity_bank_account;
 INSERT INTO entity_credit_account SELECT * FROM lsmb13.entity_credit_account;
+UPDATE entity_credit_account SET curr = defaults_get_defaultcurrency()
+ WHERE curr IS NULL;
 INSERT INTO eca_to_contact SELECT * FROM lsmb13.eca_to_contact;
 INSERT INTO eca_to_location SELECT * FROM lsmb13.eca_to_location;
 INSERT INTO entity_note SELECT * FROM lsmb13.entity_note;

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


------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable 
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits