Mercurial > hg > orthanc
view OrthancServer/PrepareDatabaseV4.sql @ 614:f27923072afd find-move-scp
merge
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 24 Oct 2013 10:33:11 +0200 |
parents | c2be0a0e049e |
children |
line wrap: on
line source
-- New in database version 4 CREATE TABLE AvailableTags( tagGroup INTEGER, tagElement INTEGER, PRIMARY KEY(tagGroup, tagElement) ); -- Until database version 4, the following index was set to "COLLATE -- BINARY". This implies case-sensitive searches, but DICOM C-Find -- requires case-insensitive searches. -- http://www.sqlite.org/optoverview.html#like_opt CREATE INDEX MainDicomTagsIndexValues ON MainDicomTags(value COLLATE NOCASE);