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