view OrthancServer/PrepareDatabaseV4.sql @ 606:ce5d2040c47b find-move-scp

integration mainline -> find-move-scp
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 17 Oct 2013 14:20:13 +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);