Mercurial > hg > orthanc
view OrthancServer/PrepareDatabaseV4.sql @ 608:0bedf8ff9288 find-move-scp
basic find scp
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 17 Oct 2013 18:07:55 +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);