view OrthancServer/PrepareDatabaseV4.sql @ 567:c2be0a0e049e find-move-scp

cont
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 19 Sep 2013 17:43:38 +0200
parents
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);