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

[..hidden..]

Revision: 6372
          http://sourceforge.net/p/ledger-smb/code/6372
Author:   ehuelsmann
Date:     2014-01-04 21:00:53 +0000 (Sat, 04 Jan 2014)
Log Message:
-----------
Don't overwrite version number in the defaults table when upgrading.

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-04 10:54:38 UTC (rev 6371)
+++ trunk/sql/upgrade/1.2-1.4.sql	2014-01-04 21:00:53 UTC (rev 6372)
@@ -765,8 +765,6 @@
  SELECT setval('cr_report_id_seq', max(id)) FROM cr_report;
  SELECT setval('cr_report_line_id_seq', max(id)) FROM cr_report_line;
 
-UPDATE defaults SET value = '1.3.999' WHERE setting_key = 'version';
-
 update defaults set value = 'yes' where setting_key = 'migration_ok';
 
 COMMIT;

Modified: trunk/sql/upgrade/1.3-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.3-1.4.sql	2014-01-04 10:54:38 UTC (rev 6371)
+++ trunk/sql/upgrade/1.3-1.4.sql	2014-01-04 21:00:53 UTC (rev 6372)
@@ -154,7 +154,8 @@
 ALTER TABLE gl ENABLE TRIGGER ALL;
 
 INSERT INTO gifi SELECT * FROM lsmb13.gifi;
-SELECT setting__set(setting_key, value) FROM lsmb13.defaults;
+SELECT setting__set(setting_key, value) FROM lsmb13.defaults
+ where not setting_key = 'version';
 INSERT INTO batch SELECT * FROM lsmb13.batch;
 
 ALTER TABLE ar DISABLE TRIGGER ALL;

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


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits