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