Mercurial > hg > orthanc
comparison OrthancServer/PrepareDatabase.sql @ 82:9eb40cad7935
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 |