www

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | Submodules | README | LICENSE
commit 9cc26951dc20070e047adbf2d4c761305c4457d5
parent a0d747285966ab29e6f3d346fad2bdbe204186b1
Author: Dan Stillman <dstillman@zotero.org>
Date:   Fri, 27 Jan 2012 00:15:50 -0500

Add additional test to db integrity check

Diffstat:

Mchrome/content/zotero/xpcom/schema.js | 4+++-


1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -1101,7 +1101,9 @@ Zotero.Schema = new function(){
 			//"SELECT COUNT(*) FROM syncDeleteLog WHERE libraryID != 0 AND libraryID NOT IN (SELECT libraryID FROM libraries)"
 			"SELECT COUNT(*) FROM syncDeleteLog WHERE libraryID != 0 AND libraryID NOT IN (SELECT libraryID FROM groups)",
 			
-			"SELECT COUNT(*) FROM creatorData WHERE firstName='' AND lastName=''"
+			"SELECT COUNT(*) FROM creatorData WHERE firstName='' AND lastName=''",
+			
+			"SELECT COUNT(*) FROM itemAttachments JOIN items USING (itemID) WHERE itemTypeID != 14"
 		];
 		
 		for each(var sql in queries) {