Mercurial > hg > orthanc
view OrthancServer/PrepareDatabaseV4.sql @ 610:5ba825b87b21 find-move-scp
fix static build
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 18 Oct 2013 10:32:12 +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);