Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 567:c2be0a0e049e find-move-scp

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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