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);