Mercurial > hg > orthanc
diff OrthancServer/PrepareDatabase.sql @ 77:b8dfde8d64e8
new dicom tags
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 20 Sep 2012 13:41:18 +0200 |
parents | 4bc019d2f969 |
children | 6212bf978584 |
line wrap: on
line diff
--- a/OrthancServer/PrepareDatabase.sql Mon Sep 17 17:32:33 2012 +0200 +++ b/OrthancServer/PrepareDatabase.sql Thu Sep 20 13:41:18 2012 +0200 @@ -17,7 +17,8 @@ CREATE TABLE Series( uuid TEXT PRIMARY KEY, parentStudy TEXT REFERENCES Studies(uuid) ON DELETE CASCADE, - dicomSeries TEXT + dicomSeries TEXT, + numberOfInstances INTEGER ); CREATE TABLE Instances( @@ -27,7 +28,8 @@ fileUuid TEXT, fileSize INTEGER, jsonUuid TEXT, - distantAet TEXT + distantAet TEXT, + instanceIndex INTEGER ); CREATE TABLE MainDicomTags( @@ -55,6 +57,9 @@ CREATE INDEX DicomInstanceIndex ON Instances(dicomInstance); CREATE INDEX MainDicomTagsIndex ON MainDicomTags(uuid); +CREATE INDEX MainDicomTagsGroupElement ON MainDicomTags(tagGroup, tagElement); +CREATE INDEX MainDicomTagsValues ON MainDicomTags(value COLLATE BINARY); + CREATE INDEX ChangesIndex ON Changes(uuid); CREATE TRIGGER InstanceRemoved