www

commit 121b75ef6c3fbddf72bc20cdd88a20fbea97ecc5
parent 1f3cd9a1ae0ee17dbd2e361ab41188438660d8b5
Author: Dan Stillman <dstillman@zotero.org>
Date:   Fri, 24 Jan 2014 19:06:33 -0500

Remove synced settings from deleted libraries in integrity check

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

1 file changed, 4 insertions(+), 0 deletions(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -1335,6 +1335,10 @@ Zotero.Schema = new function(){
 			[
 				"SELECT COUNT(*) FROM fulltextItems WHERE itemID NOT IN (SELECT itemID FROM items WHERE itemTypeID=14)",
 				"DELETE FROM fulltextItems WHERE itemID NOT IN (SELECT itemID FROM items WHERE itemTypeID=14)"
+			],
+			[
+				"SELECT COUNT(*) FROM syncedSettings WHERE libraryID != 0 AND libraryID NOT IN (SELECT libraryID FROM libraries)",
+				"DELETE FROM syncedSettings WHERE libraryID != 0 AND libraryID NOT IN (SELECT libraryID FROM libraries)"
 			]
 		];