Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 82:9eb40cad7935

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fixes
author Sebastien Jodogne <s.jodogne@gmail.com>
date Mon, 24 Sep 2012 14:05:19 +0200
parents 6212bf978584
children
comparison
equal deleted inserted replaced
81:0ec5e2e327b1 82:9eb40cad7935
1 CREATE TABLE GlobalProperties( 1 CREATE TABLE GlobalProperties(
2 name TEXT PRIMARY KEY, 2 name TEXT PRIMARY KEY,
3 value TEXT 3 value TEXT
4 );
5
6 CREATE TABLE Resources(
7 uuid TEXT PRIMARY KEY,
8 resourceType INTEGER
4 ); 9 );
5 10
6 CREATE TABLE Patients( 11 CREATE TABLE Patients(
7 uuid TEXT PRIMARY KEY, 12 uuid TEXT PRIMARY KEY,
8 dicomPatientId TEXT 13 dicomPatientId TEXT
63 CREATE INDEX ChangesIndex ON Changes(uuid); 68 CREATE INDEX ChangesIndex ON Changes(uuid);
64 69
65 CREATE TRIGGER InstanceRemoved 70 CREATE TRIGGER InstanceRemoved
66 AFTER DELETE ON Instances 71 AFTER DELETE ON Instances
67 FOR EACH ROW BEGIN 72 FOR EACH ROW BEGIN
73 DELETE FROM Resources WHERE uuid = old.uuid;
68 DELETE FROM MainDicomTags WHERE uuid = old.uuid; 74 DELETE FROM MainDicomTags WHERE uuid = old.uuid;
69 DELETE FROM Changes WHERE uuid = old.uuid; 75 DELETE FROM Changes WHERE uuid = old.uuid;
70 SELECT DeleteFromFileStorage(old.fileUuid); 76 SELECT DeleteFromFileStorage(old.fileUuid);
71 SELECT DeleteFromFileStorage(old.jsonUuid); 77 SELECT DeleteFromFileStorage(old.jsonUuid);
72 SELECT SignalDeletedLevel(3, old.parentSeries); 78 SELECT SignalDeletedLevel(3, old.parentSeries);
73 END; 79 END;
74 80
75 CREATE TRIGGER SeriesRemoved 81 CREATE TRIGGER SeriesRemoved
76 AFTER DELETE ON Series 82 AFTER DELETE ON Series
77 FOR EACH ROW BEGIN 83 FOR EACH ROW BEGIN
84 DELETE FROM Resources WHERE uuid = old.uuid;
78 DELETE FROM MainDicomTags WHERE uuid = old.uuid; 85 DELETE FROM MainDicomTags WHERE uuid = old.uuid;
79 DELETE FROM Changes WHERE uuid = old.uuid; 86 DELETE FROM Changes WHERE uuid = old.uuid;
80 SELECT SignalDeletedLevel(2, old.parentStudy); 87 SELECT SignalDeletedLevel(2, old.parentStudy);
81 END; 88 END;
82 89
83 CREATE TRIGGER StudyRemoved 90 CREATE TRIGGER StudyRemoved
84 AFTER DELETE ON Studies 91 AFTER DELETE ON Studies
85 FOR EACH ROW BEGIN 92 FOR EACH ROW BEGIN
93 DELETE FROM Resources WHERE uuid = old.uuid;
86 DELETE FROM MainDicomTags WHERE uuid = old.uuid; 94 DELETE FROM MainDicomTags WHERE uuid = old.uuid;
87 DELETE FROM Changes WHERE uuid = old.uuid; 95 DELETE FROM Changes WHERE uuid = old.uuid;
88 SELECT SignalDeletedLevel(1, old.parentPatient); 96 SELECT SignalDeletedLevel(1, old.parentPatient);
89 END; 97 END;
90 98
91 CREATE TRIGGER PatientRemoved 99 CREATE TRIGGER PatientRemoved
92 AFTER DELETE ON Patients 100 AFTER DELETE ON Patients
93 FOR EACH ROW BEGIN 101 FOR EACH ROW BEGIN
102 DELETE FROM Resources WHERE uuid = old.uuid;
94 DELETE FROM MainDicomTags WHERE uuid = old.uuid; 103 DELETE FROM MainDicomTags WHERE uuid = old.uuid;
95 DELETE FROM Changes WHERE uuid = old.uuid; 104 DELETE FROM Changes WHERE uuid = old.uuid;
96 SELECT SignalDeletedLevel(0, ""); 105 SELECT SignalDeletedLevel(0, "");
97 END; 106 END;
98 107