commit fe3ff1357156ac950bf95d971bfc2ba264a7f06f
parent a4d049fe46e9ebaf2932d43433eae561df0c5b0b
Author: Dan Stillman <dstillman@zotero.org>
Date: Tue, 29 Jul 2008 17:47:07 +0000
Fix id changing with items with highlights or annotations
Diffstat:
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/chrome/content/zotero/xpcom/data/item.js b/chrome/content/zotero/xpcom/data/item.js
@@ -1017,9 +1017,7 @@ Zotero.Item.prototype.save = function() {
Zotero.DB.query("INSERT INTO items VALUES (?, ?, ?, ?, ?)",
[this.id, row.itemTypeID, row.dateAdded, row.dateModified, 'TEMPKEY']);
- Zotero.DB.query("UPDATE annotations SET itemID=? WHERE itemID=?", params);
Zotero.DB.query("UPDATE collectionItems SET itemID=? WHERE itemID=?", params);
- Zotero.DB.query("UPDATE highlights SET itemID=? WHERE itemID=?", params);
Zotero.DB.query("UPDATE itemCreators SET itemID=? WHERE itemID=?", params);
Zotero.DB.query("UPDATE itemAttachments SET itemID=? WHERE itemID=?", params);
Zotero.DB.query("UPDATE itemAttachments SET sourceItemID=? WHERE sourceItemID=?", params);
@@ -1031,6 +1029,8 @@ Zotero.Item.prototype.save = function() {
Zotero.DB.query("UPDATE itemTags SET itemID=? WHERE itemID=?", params);
Zotero.DB.query("UPDATE fulltextItemWords SET itemID=? WHERE itemID=?", params);
Zotero.DB.query("UPDATE fulltextItems SET itemID=? WHERE itemID=?", params);
+ Zotero.DB.query("UPDATE annotations SET itemID=? WHERE itemID=?", params);
+ Zotero.DB.query("UPDATE highlights SET itemID=? WHERE itemID=?", params);
Zotero.DB.query("DELETE FROM items WHERE itemID=?", oldID);
Zotero.DB.query("UPDATE items SET key=? WHERE itemID=?", [row.key, this.id]);