diff -r 000000000000 -r 6474c204b198 toolkit/components/downloads/test/schema_migration/test_migration_to_3.js
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/toolkit/components/downloads/test/schema_migration/test_migration_to_3.js	Wed Dec 31 06:09:35 2014 +0100
@@ -0,0 +1,45 @@
+/* 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 v1 to v2
+
+function run_test()
+{
+  // First import the downloads.sqlite file
+  importDatabaseFile("v2.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 >= 3);
+
+  // Check that the column exists (statement should not throw)
+  stmt = dbConn.createStatement("SELECT referrer FROM moz_downloads");
+  stmt.finalize();
+
+  // now we check the entries
+  stmt = dbConn.createStatement(
+    "SELECT name, source, target, startTime, endTime, state, referrer " +
+    "FROM moz_downloads " +
+    "WHERE id = 2");
+  stmt.executeStep();
+  do_check_eq("381603.patch", stmt.getString(0));
+  do_check_eq("https://bugzilla.mozilla.org/attachment.cgi?id=266520",
+              stmt.getUTF8String(1));
+  do_check_eq("file:///Users/sdwilsh/Desktop/381603.patch",
+              stmt.getUTF8String(2));
+  do_check_eq(1180493839859230, stmt.getInt64(3));
+  do_check_eq(1180493839859230, stmt.getInt64(4));
+  do_check_eq(1, stmt.getInt32(5));
+  do_check_true(stmt.getIsNull(6));
+  stmt.finalize();
+
+  cleanup();
+}
+