www

commit 8a57183e0b4b8103c3be9cd055885c90ce1ccd43
parent 514547ab3b16866a0a78e3e2a581662f673f6d30
Author: Dan Stillman <dstillman@zotero.org>
Date:   Fri,  1 Apr 2016 02:38:36 -0400

Remove unused version table rows

Diffstat:
M
chrome/content/zotero/xpcom/schema.js
 | 
4
++++
M
resource/schema/userdata.sql
 | 
2
+-

2 files changed, 5 insertions(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -2239,6 +2239,10 @@ Zotero.Schema = new function(){
 			else if (i == 84) {
 				yield Zotero.DB.queryAsync("CREATE TABLE syncQueue (\n    libraryID INT NOT NULL,\n    key TEXT NOT NULL,\n    syncObjectTypeID INT NOT NULL,\n    lastCheck TIMESTAMP,\n    tries INT,\n    PRIMARY KEY (libraryID, key, syncObjectTypeID),\n    FOREIGN KEY (libraryID) REFERENCES libraries(libraryID) ON DELETE CASCADE,\n    FOREIGN KEY (syncObjectTypeID) REFERENCES syncObjectTypes(syncObjectTypeID) ON DELETE CASCADE\n)");
 			}
+			
+			else if (i == 85) {
+				yield Zotero.DB.queryAsync("DELETE FROM version WHERE schema IN ('sync', 'syncdeletelog')");
+			}
 		}
 		
 		yield _updateDBVersion('userdata', toVersion);
diff --git a/resource/schema/userdata.sql b/resource/schema/userdata.sql
@@ -1,4 +1,4 @@
--- 84
+-- 85
 
 -- Copyright (c) 2009 Center for History and New Media
 --                    George Mason University, Fairfax, Virginia, USA