Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 77:b8dfde8d64e8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
new dicom tags
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 20 Sep 2012 13:41:18 +0200
parents 4bc019d2f969
children 6212bf978584
comparison
equal deleted inserted replaced
76:e2d68529605f 77:b8dfde8d64e8
15 ); 15 );
16 16
17 CREATE TABLE Series( 17 CREATE TABLE Series(
18 uuid TEXT PRIMARY KEY, 18 uuid TEXT PRIMARY KEY,
19 parentStudy TEXT REFERENCES Studies(uuid) ON DELETE CASCADE, 19 parentStudy TEXT REFERENCES Studies(uuid) ON DELETE CASCADE,
20 dicomSeries TEXT 20 dicomSeries TEXT,
21 numberOfInstances INTEGER
21 ); 22 );
22 23
23 CREATE TABLE Instances( 24 CREATE TABLE Instances(
24 uuid TEXT PRIMARY KEY, 25 uuid TEXT PRIMARY KEY,
25 parentSeries TEXT REFERENCES Series(uuid) ON DELETE CASCADE, 26 parentSeries TEXT REFERENCES Series(uuid) ON DELETE CASCADE,
26 dicomInstance TEXT, 27 dicomInstance TEXT,
27 fileUuid TEXT, 28 fileUuid TEXT,
28 fileSize INTEGER, 29 fileSize INTEGER,
29 jsonUuid TEXT, 30 jsonUuid TEXT,
30 distantAet TEXT 31 distantAet TEXT,
32 instanceIndex INTEGER
31 ); 33 );
32 34
33 CREATE TABLE MainDicomTags( 35 CREATE TABLE MainDicomTags(
34 uuid TEXT, 36 uuid TEXT,
35 tagGroup INTEGER, 37 tagGroup INTEGER,
53 CREATE INDEX DicomStudyIndex ON Studies(dicomStudy); 55 CREATE INDEX DicomStudyIndex ON Studies(dicomStudy);
54 CREATE INDEX DicomSeriesIndex ON Series(dicomSeries); 56 CREATE INDEX DicomSeriesIndex ON Series(dicomSeries);
55 CREATE INDEX DicomInstanceIndex ON Instances(dicomInstance); 57 CREATE INDEX DicomInstanceIndex ON Instances(dicomInstance);
56 58
57 CREATE INDEX MainDicomTagsIndex ON MainDicomTags(uuid); 59 CREATE INDEX MainDicomTagsIndex ON MainDicomTags(uuid);
60 CREATE INDEX MainDicomTagsGroupElement ON MainDicomTags(tagGroup, tagElement);
61 CREATE INDEX MainDicomTagsValues ON MainDicomTags(value COLLATE BINARY);
62
58 CREATE INDEX ChangesIndex ON Changes(uuid); 63 CREATE INDEX ChangesIndex ON Changes(uuid);
59 64
60 CREATE TRIGGER InstanceRemoved 65 CREATE TRIGGER InstanceRemoved
61 AFTER DELETE ON Instances 66 AFTER DELETE ON Instances
62 FOR EACH ROW BEGIN 67 FOR EACH ROW BEGIN