www

commit 2a102577d1c606d03862b4137fe3da77dc52fc9c
parent 8ddab2fbec4d095b5c4e6acc26dcf89d4c73842b
Author: Dan Stillman <dstillman@zotero.org>
Date:   Tue, 10 Jan 2012 19:48:30 -0500

Fix FK

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
@@ -3064,6 +3064,10 @@ Zotero.Schema = new function(){
 				Zotero.wait();
 			}
 			
+			// TODO
+			//
+			// Replace customBaseFieldMappings to fix FK fields/customField -> customFields->customFieldID
+			
 			_updateDBVersion('userdata', toVersion);
 			
 			Zotero.DB.commitTransaction();
diff --git a/userdata.sql b/userdata.sql
@@ -378,7 +378,7 @@ CREATE TABLE customBaseFieldMappings (
     PRIMARY KEY (customItemTypeID, baseFieldID, customFieldID),
     FOREIGN KEY (customItemTypeID) REFERENCES customItemTypes(customItemTypeID),
     FOREIGN KEY (baseFieldID) REFERENCES fields(fieldID),
-    FOREIGN KEY (customFieldID) REFERENCES fields(customFieldID)
+    FOREIGN KEY (customFieldID) REFERENCES customFields(customFieldID)
 );
 CREATE INDEX customBaseFieldMappings_baseFieldID ON customBaseFieldMappings(baseFieldID);
 CREATE INDEX customBaseFieldMappings_customFieldID ON customBaseFieldMappings(customFieldID);