Mercurial > hg > orthanc

diff OrthancServer/PrepareDatabase2.sql @ 189:ccbc2cf64a0d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
record main dicom tags and changes
author Sebastien Jodogne <s.jodogne@gmail.com>
date Mon, 12 Nov 2012 18:03:48 +0100
parents baada606da3c
children b6cef9d45cc3
line wrap: on
line diff
--- a/OrthancServer/PrepareDatabase2.sql	Mon Nov 12 17:43:12 2012 +0100
+++ b/OrthancServer/PrepareDatabase2.sql	Mon Nov 12 18:03:48 2012 +0100
@@ -38,7 +38,7 @@
 CREATE TABLE Changes(
        seq INTEGER PRIMARY KEY AUTOINCREMENT,
        changeType INTEGER,
-       publicId TEXT,
+       internalId INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE,
        resourceType INTEGER,
        date TEXT
        );
@@ -61,7 +61,7 @@
 CREATE INDEX MainDicomTagsIndex2 ON MainDicomTags(tagGroup, tagElement);
 CREATE INDEX MainDicomTagsIndexValues ON MainDicomTags(value COLLATE BINARY);
 
-CREATE INDEX ChangesIndex ON Changes(publicId);
+CREATE INDEX ChangesIndex ON Changes(internalId);
 
 CREATE TRIGGER AttachedFileDeleted
 AFTER DELETE ON AttachedFiles