annotate 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 |
|
rev |
line source |
567
|
1 -- New in database version 4
|
|
2 CREATE TABLE AvailableTags(
|
|
3 tagGroup INTEGER,
|
|
4 tagElement INTEGER,
|
|
5 PRIMARY KEY(tagGroup, tagElement)
|
|
6 );
|
|
7
|
|
8 -- Until database version 4, the following index was set to "COLLATE
|
|
9 -- BINARY". This implies case-sensitive searches, but DICOM C-Find
|
|
10 -- requires case-insensitive searches.
|
|
11 -- http://www.sqlite.org/optoverview.html#like_opt
|
|
12 CREATE INDEX MainDicomTagsIndexValues ON MainDicomTags(value COLLATE NOCASE);
|