--- a/OrthancServer/PrepareDatabase.sql	Mon Sep 17 17:32:33 2012 +0200
+++ b/OrthancServer/PrepareDatabase.sql	Thu Sep 20 13:41:18 2012 +0200
@@ -17,7 +17,8 @@
 CREATE TABLE Series(
        uuid TEXT PRIMARY KEY,
        parentStudy TEXT REFERENCES Studies(uuid) ON DELETE CASCADE,
-       dicomSeries TEXT
+       dicomSeries TEXT,
+       numberOfInstances INTEGER
        );
 
 CREATE TABLE Instances(
@@ -27,7 +28,8 @@
        fileUuid TEXT,
        fileSize INTEGER,
        jsonUuid TEXT,
-       distantAet TEXT
+       distantAet TEXT,
+       instanceIndex INTEGER
        );
 
 CREATE TABLE MainDicomTags(
@@ -55,6 +57,9 @@
 CREATE INDEX DicomInstanceIndex ON Instances(dicomInstance);
 
 CREATE INDEX MainDicomTagsIndex ON MainDicomTags(uuid);
+CREATE INDEX MainDicomTagsGroupElement ON MainDicomTags(tagGroup, tagElement);
+CREATE INDEX MainDicomTagsValues ON MainDicomTags(value COLLATE BINARY);
+
 CREATE INDEX ChangesIndex ON Changes(uuid);
 
 CREATE TRIGGER InstanceRemoved