Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 616:dbecea588ef5 find-move-scp

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
revert to database v3
author Sebastien Jodogne <s.jodogne@gmail.com>
date Fri, 25 Oct 2013 11:06:10 +0200
parents c2be0a0e049e
children 01d8611c4a60
comparison
equal deleted inserted replaced
615:ec0b7a51d7bd 616:dbecea588ef5
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);
70 71
71 CREATE INDEX ChangesIndex ON Changes(internalId); 72 CREATE INDEX ChangesIndex ON Changes(internalId);
72 73
73 CREATE TRIGGER AttachedFileDeleted 74 CREATE TRIGGER AttachedFileDeleted
74 AFTER DELETE ON AttachedFiles 75 AFTER DELETE ON AttachedFiles