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

[..hidden..]

Revision: 5823
          http://sourceforge.net/p/ledger-smb/code/5823
Author:   einhverfr
Date:     2013-05-18 12:52:50 +0000 (Sat, 18 May 2013)
Log Message:
-----------
This fixes the mime type link issues in upgrading 1.3 to 1.4

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	2013-05-18 11:18:25 UTC (rev 5822)
+++ trunk/sql/upgrade/1.3-1.4.sql	2013-05-18 12:52:50 UTC (rev 5823)
@@ -562,6 +562,8 @@
 INSERT INTO asset_report SELECT * FROM lsmb13.asset_report;
 INSERT INTO asset_report_line SELECT * FROM lsmb13.asset_report_line;
 INSERT INTO asset_rl_to_disposal_method SELECT * FROM lsmb13.asset_rl_to_disposal_method;
+DELETE FROM mime_type;
+INSERT INTO mime_type SELECT * FROM lsmb13.mime_type;
 INSERT INTO file_base SELECT * FROM lsmb13.file_base;
 INSERT INTO file_transaction SELECT * FROM lsmb13.file_transaction;
 INSERT INTO file_order SELECT * FROM lsmb13.file_order;

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