Mercurial > hg > orthanc
diff OrthancServer/PrepareDatabase.sql @ 1711:5ebd6cbb3da8 db-changes
Backed out changeset 2ad22b2970a2
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 16 Oct 2015 17:36:07 +0200 |
parents | 2ad22b2970a2 |
children |
line wrap: on
line diff
--- a/OrthancServer/PrepareDatabase.sql Tue Oct 13 17:48:30 2015 +0200 +++ b/OrthancServer/PrepareDatabase.sql Fri Oct 16 17:36:07 2015 +0200 @@ -27,15 +27,6 @@ PRIMARY KEY(id, tagGroup, tagElement) ); --- The following table was added in Orthanc 0.9.5 (database v6) -CREATE TABLE SearchableStudies( - id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE, - tagGroup INTEGER, - tagElement INTEGER, - value TEXT, -- assumed to be in upper case - PRIMARY KEY(id, tagGroup, tagElement) - ); - CREATE TABLE Metadata( id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE, type INTEGER, @@ -95,10 +86,6 @@ CREATE INDEX DicomIdentifiersIndex2 ON DicomIdentifiers(tagGroup, tagElement); CREATE INDEX DicomIdentifiersIndexValues ON DicomIdentifiers(value COLLATE BINARY); --- The 2 following indexes were added in Orthanc 0.9.5 (database v6) -CREATE INDEX SearchableStudiesIndex1 ON SearchableStudies(id); -CREATE INDEX SearchableStudiesIndexValues ON SearchableStudies(value COLLATE BINARY); - CREATE INDEX ChangesIndex ON Changes(internalId); CREATE TRIGGER AttachedFileDeleted