[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Revision: 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:

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.
Ledger-smb-commits mailing list