Mercurial > hg > orthanc
comparison OrthancServer/PrepareDatabase.sql @ 567:c2be0a0e049e find-move-scp
cont
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 19 Sep 2013 17:43:38 +0200 |
parents | d384af918264 |
children | dbecea588ef5 |
comparison
equal
deleted
inserted
replaced
565:c931ac02db82 | 567:c2be0a0e049e |
---|---|
65 CREATE INDEX ResourceTypeIndex ON Resources(resourceType); | 65 CREATE INDEX ResourceTypeIndex ON Resources(resourceType); |
66 CREATE INDEX PatientRecyclingIndex ON PatientRecyclingOrder(patientId); | 66 CREATE INDEX PatientRecyclingIndex ON PatientRecyclingOrder(patientId); |
67 | 67 |
68 CREATE INDEX MainDicomTagsIndex1 ON MainDicomTags(id); | 68 CREATE INDEX MainDicomTagsIndex1 ON MainDicomTags(id); |
69 CREATE INDEX MainDicomTagsIndex2 ON MainDicomTags(tagGroup, tagElement); | 69 CREATE INDEX MainDicomTagsIndex2 ON MainDicomTags(tagGroup, tagElement); |
70 CREATE INDEX MainDicomTagsIndexValues ON MainDicomTags(value COLLATE BINARY); | |
71 | 70 |
72 CREATE INDEX ChangesIndex ON Changes(internalId); | 71 CREATE INDEX ChangesIndex ON Changes(internalId); |
73 | 72 |
74 CREATE TRIGGER AttachedFileDeleted | 73 CREATE TRIGGER AttachedFileDeleted |
75 AFTER DELETE ON AttachedFiles | 74 AFTER DELETE ON AttachedFiles |