www

commit 6de3c0230198269f05d1498ca0f5098b1877c524
parent 8317a0c439c8b11a1d59a40672feaa066e204682
Author: Dan Stillman <dstillman@zotero.org>
Date:   Wed, 27 May 2009 03:52:18 +0000

Fix problems with imported files in 2.0b4 due to incorrect NULL handling


Diffstat:
M
chrome/content/zotero/xpcom/schema.js
 | 
4
++++
M
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
@@ -2390,6 +2390,10 @@ Zotero.Schema = new function(){
 				if (i==56) {
 					Zotero.DB.query("UPDATE itemAttachments SET mimeType=charsetID, charsetID=NULL WHERE charsetID REGEXP '[a-zA-Z0-9\-]+/[a-zA-Z0-9\-]'");
 				}
+				
+				if (i==57) {
+					Zotero.DB.query("UPDATE itemAttachments SET linkMode=0, mimeType=NULL WHERE linkMode IS NULL AND mimeType=0");
+				}
 			}
 			
 			_updateDBVersion('userdata', toVersion);
diff --git a/userdata.sql b/userdata.sql
@@ -1,4 +1,4 @@
--- 56
+-- 57
 
 -- This file creates tables containing user-specific data for new users --
 -- any changes made here must be mirrored in transition steps in schema.js::_migrateSchema()