www

commit a152e35786b2a56dc63fc4b0203b8b1450eac0b8
parent 45c2265c1ed34f926c34bceb388679cf34134a1b
Author: Dan Stillman <dstillman@zotero.org>
Date:   Wed, 17 Feb 2016 18:01:38 -0500

Don't create itemSeeAlso table (already removed via schema updates)

Diffstat:
M
resource/schema/userdata.sql
 | 
9
---------

1 file changed, 0 insertions(+), 9 deletions(-)
diff --git a/resource/schema/userdata.sql b/resource/schema/userdata.sql
@@ -139,15 +139,6 @@ CREATE TABLE itemTags (
 );
 CREATE INDEX itemTags_tagID ON itemTags(tagID);
 
-CREATE TABLE itemSeeAlso (
-    itemID INT NOT NULL,
-    linkedItemID INT NOT NULL,
-    PRIMARY KEY (itemID, linkedItemID),
-    FOREIGN KEY (itemID) REFERENCES items(itemID) ON DELETE CASCADE,
-    FOREIGN KEY (linkedItemID) REFERENCES items(itemID) ON DELETE CASCADE
-);
-CREATE INDEX itemSeeAlso_linkedItemID ON itemSeeAlso(linkedItemID);
-
 CREATE TABLE creators (
     creatorID INTEGER PRIMARY KEY,
     firstName TEXT,