commit 662be5e1986720f538e0d20260cdde41e5bb6668 parent 4966a55a1b1fa3cee58c506475ba9932989ea8f4 Author: Dan Stillman <dstillman@zotero.org> Date: Wed, 11 Jan 2012 18:23:59 -0500 Add integrity check query for empty creators Diffstat:
| M | chrome/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 @@ -1087,7 +1087,9 @@ Zotero.Schema = new function(){ // TODO: check 'libraries', not 'groups', but first add a // migration step to delete 'libraries' rows not in 'groups' //"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 syncDeleteLog WHERE libraryID != 0 AND libraryID NOT IN (SELECT libraryID FROM groups)", + + "SELECT COUNT(*) FROM creatorData WHERE firstName='' AND lastName=''" ]; for each(var sql in queries) {