www

commit e4fa5f10b0f675d6e119a7b7e03f5904c39e3210
parent c430baa85dd42996311008738d49649b08106e67
Author: Dan Stillman <dstillman@zotero.org>
Date:   Tue,  8 Jul 2008 16:26:50 +0000

Fix attachments with missing rows in itemAttachments


Diffstat:
M
chrome/content/zotero/xpcom/schema.js
 | 
10
++++++++--

1 file changed, 8 insertions(+), 2 deletions(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -1244,8 +1244,7 @@ Zotero.Schema = new function(){
 					Zotero.DB.query("DELETE FROM version WHERE schema='fulltext'");
 				}
 				
-				// 1.5
-				
+				// 1.5 Sync Preview
 				if (i==37) {
 					// Some data cleanup from the pre-FK-trigger days
 					Zotero.DB.query("DELETE FROM annotations WHERE itemID NOT IN (SELECT itemID FROM items)");
@@ -1652,6 +1651,13 @@ Zotero.Schema = new function(){
 						Zotero.DB.query("UPDATE fulltextItems SET itemID=? WHERE itemID=?", params);
 					}
 				}
+				
+				if (i==38) {
+					var ids = Zotero.DB.columnQuery("SELECT itemID FROM items WHERE itemTypeID=14 AND itemID NOT IN (SELECT itemID FROM itemAttachments)");
+					for each(var id in ids) {
+						Zotero.DB.query("INSERT INTO itemAttachments (itemID, linkMode) VALUES (?, ?)", [id, 3]);
+					}
+				}
 			}
 			
 			_updateDBVersion('userdata', toVersion);