Mercurial > hg > orthanc

comparison 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
comparison
equal deleted inserted replaced
188:090cefdab1d1 189:ccbc2cf64a0d
36 ); 36 );
37 37
38 CREATE TABLE Changes( 38 CREATE TABLE Changes(
39 seq INTEGER PRIMARY KEY AUTOINCREMENT, 39 seq INTEGER PRIMARY KEY AUTOINCREMENT,
40 changeType INTEGER, 40 changeType INTEGER,
41 publicId TEXT, 41 internalId INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE,
42 resourceType INTEGER, 42 resourceType INTEGER,
43 date TEXT 43 date TEXT
44 ); 44 );
45 45
46 CREATE TABLE ExportedInstances( 46 CREATE TABLE ExportedInstances(
59 59
60 CREATE INDEX MainDicomTagsIndex1 ON MainDicomTags(id); 60 CREATE INDEX MainDicomTagsIndex1 ON MainDicomTags(id);
61 CREATE INDEX MainDicomTagsIndex2 ON MainDicomTags(tagGroup, tagElement); 61 CREATE INDEX MainDicomTagsIndex2 ON MainDicomTags(tagGroup, tagElement);
62 CREATE INDEX MainDicomTagsIndexValues ON MainDicomTags(value COLLATE BINARY); 62 CREATE INDEX MainDicomTagsIndexValues ON MainDicomTags(value COLLATE BINARY);
63 63
64 CREATE INDEX ChangesIndex ON Changes(publicId); 64 CREATE INDEX ChangesIndex ON Changes(internalId);
65 65
66 CREATE TRIGGER AttachedFileDeleted 66 CREATE TRIGGER AttachedFileDeleted
67 AFTER DELETE ON AttachedFiles 67 AFTER DELETE ON AttachedFiles
68 BEGIN 68 BEGIN
69 SELECT SignalFileDeleted(old.uuid); 69 SELECT SignalFileDeleted(old.uuid);