www

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | Submodules | README | LICENSE
commit 9bf8333ea8d1fd87aa509fd6663ad8082bc5602f
parent 413670b09d8e13a5c7dd214d10e019b5bed345aa
Author: Dan Stillman <dstillman@zotero.org>
Date:   Mon, 16 Jun 2008 21:01:09 +0000

Missed file for tag case insensitivity


Diffstat:

Muserdata.sql | 2+-


1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/userdata.sql b/userdata.sql
@@ -71,7 +71,7 @@ CREATE INDEX itemAttachments_mimeType ON itemAttachments(mimeType);
 -- Individual entries for each tag
 CREATE TABLE tags (
     tagID INTEGER PRIMARY KEY,
-    name TEXT,
+    name TEXT COLLATE NOCASE,
     type INT,
     dateModified DEFAULT CURRENT_TIMESTAMP NOT NULL,
     key TEXT NOT NULL UNIQUE,