www

commit 19b08a604ac319492b0814cf7117313d4d43557a
parent 245954b8765c463209baee2bafe9c792ea3bed7a
Author: Dan Stillman <dstillman@zotero.org>
Date:   Wed, 25 Jun 2008 00:22:25 +0000

Drop redundant index on fulltextWords


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

2 files changed, 2 insertions(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -1278,6 +1278,8 @@ Zotero.Schema = new function(){
 					Zotero.DB.query("DROP TABLE IF EXISTS userFields");
 					Zotero.DB.query("DROP TABLE IF EXISTS userItemTypeFields");
 					
+					Zotero.DB.query("DROP INDEX IF EXISTS fulltextWords_word");
+					
 					var wordIDs = Zotero.DB.columnQuery("SELECT GROUP_CONCAT(wordID) AS wordIDs FROM fulltextWords GROUP BY word HAVING COUNT(*)>1");
 					if (wordIDs.length) {
 						Zotero.DB.query("CREATE TEMPORARY TABLE deleteWordIDs (wordID INTEGER PRIMARY KEY)");
diff --git a/userdata.sql b/userdata.sql
@@ -183,7 +183,6 @@ CREATE TABLE fulltextWords (
     wordID INTEGER PRIMARY KEY,
     word TEXT UNIQUE
 );
-CREATE INDEX fulltextWords_word ON fulltextWords(word);
 
 CREATE TABLE fulltextItemWords (
     wordID INT,