Mercurial > hg > orthanc
view OrthancServer/PrepareDatabaseV4.sql @ 613:60d90e48e809 find-move-scp
query/retrieve
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 18 Oct 2013 17:27:26 +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);