diff -r 000000000000 -r 6474c204b198 toolkit/components/downloads/test/schema_migration/test_migration_to_4.js
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/toolkit/components/downloads/test/schema_migration/test_migration_to_4.js	Wed Dec 31 06:09:35 2014 +0100
@@ -0,0 +1,46 @@
+/* This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
+
+// This file tests migration from v3 to v4
+
+function run_test()
+{
+  // First import the downloads.sqlite file
+  importDatabaseFile("v3.sqlite");
+
+  // ok, now it is OK to init the download manager - this will perform the
+  // migration!
+  var dm = Cc["@mozilla.org/download-manager;1"].
+           getService(Ci.nsIDownloadManager);
+  var dbConn = dm.DBConnection;
+  var stmt = null;
+
+  // check schema version
+  do_check_true(dbConn.schemaVersion >= 4);
+
+  // Check that the column exists (statement should not throw)
+  stmt = dbConn.createStatement("SELECT entityID FROM moz_downloads");
+  stmt.finalize();
+
+  // now we check the entries
+  stmt = dbConn.createStatement(
+    "SELECT name, source, target, startTime, endTime, state, referrer, entityID " +
+    "FROM moz_downloads " +
+    "WHERE id = 27");
+  stmt.executeStep();
+  do_check_eq("Firefox 2.0.0.6.dmg", stmt.getString(0));
+  do_check_eq("http://ftp-mozilla.netscape.com/pub/mozilla.org/firefox/releases/2.0.0.6/mac/en-US/Firefox%202.0.0.6.dmg",
+              stmt.getUTF8String(1));
+  do_check_eq("file:///Users/sdwilsh/Desktop/Firefox%202.0.0.6.dmg",
+              stmt.getUTF8String(2));
+  do_check_eq(1187390974170783, stmt.getInt64(3));
+  do_check_eq(1187391001257446, stmt.getInt64(4));
+  do_check_eq(1, stmt.getInt32(5));
+  do_check_eq("http://www.mozilla.com/en-US/products/download.html?product=firefox-2.0.0.6&os=osx&lang=en-US",stmt.getUTF8String(6));
+  do_check_true(stmt.getIsNull(7));
+  stmt.finalize();
+
+  cleanup();
+}
+