Mercurial > hg > orthanc
diff 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 |
line wrap: on
line diff
--- a/OrthancServer/PrepareDatabase.sql Mon Sep 24 10:33:41 2012 +0200 +++ b/OrthancServer/PrepareDatabase.sql Mon Sep 24 14:05:19 2012 +0200 @@ -3,6 +3,11 @@ value TEXT ); +CREATE TABLE Resources( + uuid TEXT PRIMARY KEY, + resourceType INTEGER + ); + CREATE TABLE Patients( uuid TEXT PRIMARY KEY, dicomPatientId TEXT @@ -65,6 +70,7 @@ CREATE TRIGGER InstanceRemoved AFTER DELETE ON Instances FOR EACH ROW BEGIN + DELETE FROM Resources WHERE uuid = old.uuid; DELETE FROM MainDicomTags WHERE uuid = old.uuid; DELETE FROM Changes WHERE uuid = old.uuid; SELECT DeleteFromFileStorage(old.fileUuid); @@ -75,6 +81,7 @@ CREATE TRIGGER SeriesRemoved AFTER DELETE ON Series FOR EACH ROW BEGIN + DELETE FROM Resources WHERE uuid = old.uuid; DELETE FROM MainDicomTags WHERE uuid = old.uuid; DELETE FROM Changes WHERE uuid = old.uuid; SELECT SignalDeletedLevel(2, old.parentStudy); @@ -83,6 +90,7 @@ CREATE TRIGGER StudyRemoved AFTER DELETE ON Studies FOR EACH ROW BEGIN + DELETE FROM Resources WHERE uuid = old.uuid; DELETE FROM MainDicomTags WHERE uuid = old.uuid; DELETE FROM Changes WHERE uuid = old.uuid; SELECT SignalDeletedLevel(1, old.parentPatient); @@ -91,6 +99,7 @@ CREATE TRIGGER PatientRemoved AFTER DELETE ON Patients FOR EACH ROW BEGIN + DELETE FROM Resources WHERE uuid = old.uuid; DELETE FROM MainDicomTags WHERE uuid = old.uuid; DELETE FROM Changes WHERE uuid = old.uuid; SELECT SignalDeletedLevel(0, "");