SF.net SVN: ledger-smb:[6825] trunk/sql/upgrade/1.3-1.4.sql

[..hidden..]

Revision: 6825
          http://sourceforge.net/p/ledger-smb/code/6825
Author:   einhverfr
Date:     2014-02-10 09:53:13 +0000 (Mon, 10 Feb 2014)
Log Message:
-----------
Fixing upgrade issues where wxpos has been installed (note wxpos would need to be updated separately)

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

Modified: trunk/sql/upgrade/1.3-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.3-1.4.sql	2014-02-10 09:36:44 UTC (rev 6824)
+++ trunk/sql/upgrade/1.3-1.4.sql	2014-02-10 09:53:13 UTC (rev 6825)
@@ -531,7 +531,9 @@
 INSERT INTO audittrail SELECT * FROM lsmb13.audittrail where person_id is not null;
 INSERT INTO translation SELECT * FROM lsmb13.translation;
 INSERT INTO parts_translation SELECT * FROM lsmb13.parts_translation;
-INSERT INTO user_preference SELECT * FROM lsmb13.user_preference;
+INSERT INTO user_preference 
+SELECT id, language, stylesheet, printer, dateformat, numerformat
+  FROM lsmb13.user_preference;
 --INSERT INTO recurring SELECT * FROM lsmb13.recurring;--tshvr4 fields differ
 INSERT INTO recurring(id,reference,startdate,nextdate,enddate,howmany,payment) SELECT id,reference,startdate,nextdate,enddate,howmany,payment FROM lsmb13.recurring;
 INSERT INTO payment_type SELECT * FROM lsmb13.payment_type;

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


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits