Mercurial > hg > orthanc

annotate OrthancServer/PrepareDatabaseV4.sql @ 614:f27923072afd find-move-scp

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merge
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 24 Oct 2013 10:33:11 +0200
parents c2be0a0e049e
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
567
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
1 -- New in database version 4
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
2 CREATE TABLE AvailableTags(
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
3 tagGroup INTEGER,
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
4 tagElement INTEGER,
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
5 PRIMARY KEY(tagGroup, tagElement)
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
6 );
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
7
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
8 -- Until database version 4, the following index was set to "COLLATE
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
9 -- BINARY". This implies case-sensitive searches, but DICOM C-Find
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
10 -- requires case-insensitive searches.
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
11 -- http://www.sqlite.org/optoverview.html#like_opt
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
12 CREATE INDEX MainDicomTagsIndexValues ON MainDicomTags(value COLLATE NOCASE);