Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql
===================================================================
diff -u -rebe7034bade41cc060e7674a24966af8d3c603b2 -rc9c2f50266a38f2eda8566eafe019d18b63f3f03
--- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql (.../DatabaseStructure21.2.sql) (revision ebe7034bade41cc060e7674a24966af8d3c603b2)
+++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql (.../DatabaseStructure21.2.sql) (revision c9c2f50266a38f2eda8566eafe019d18b63f3f03)
@@ -1,6 +1,6 @@
/* ---------------------------------------------------- */
/* Generated by Enterprise Architect Version 14.1 */
-/* Created On : 18-nov-2021 14:44:51 */
+/* Created On : 24-nov-2021 08:16:09 */
/* DBMS : SQLite */
/* ---------------------------------------------------- */
@@ -2332,7 +2332,7 @@
CREATE INDEX 'IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity'
ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteFailureMechanismEntity_RemoveFailureMechanismSectionEntityId]
+CREATE TRIGGER [TR_AfterDeleteFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId]
AFTER DELETE
ON FailureMechanismFailureMechanismSectionEntity
FOR EACH ROW
@@ -2575,15 +2575,15 @@
CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity'
ON 'HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionEntity_RemoveHydraulicLocationCalculationEntity]
+CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity]
AFTER DELETE
- ON HydraulicLocationCalculationCollectionEntity
+ ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
FOR EACH ROW
BEGIN
DELETE
- FROM HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
- WHERE OLD.HydraulicLocationCalculationCollectionEntityId IS NOT NULL
- AND HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntityId;
+ FROM HydraulicLocationCalculationEntity
+ WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL
+ AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId;
END;
;
@@ -2602,13 +2602,13 @@
CREATE INDEX 'IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity'
ON 'HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionEntity_RemoveHydraulicLocationCalculationEntity]
+CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity]
AFTER DELETE
- ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
+ ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity
FOR EACH ROW
BEGIN
DELETE
- FROM HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
+ FROM HydraulicLocationCalculationEntity
WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL
AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId;
END;
@@ -2799,7 +2799,7 @@
CREATE INDEX 'IXFK_SpecificFailurePathFailureMechanismSectionEntity_SpecificFailurePathEntity'
ON 'SpecificFailurePathFailureMechanismSectionEntity' ('SpecificFailurePathEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathEntity_RemoveFailureMechanismSectionEntityId]
+CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId]
AFTER DELETE
ON SpecificFailurePathFailureMechanismSectionEntity
FOR EACH ROW
Index: Riskeer/Storage/src/Riskeer.Storage.Core/DbContext/RiskeerEntities.edmx.diagram
===================================================================
diff -u -r9099e41b33604471cb47ab0c3cf1f93a9394f720 -rc9c2f50266a38f2eda8566eafe019d18b63f3f03
--- Riskeer/Storage/src/Riskeer.Storage.Core/DbContext/RiskeerEntities.edmx.diagram (.../RiskeerEntities.edmx.diagram) (revision 9099e41b33604471cb47ab0c3cf1f93a9394f720)
+++ Riskeer/Storage/src/Riskeer.Storage.Core/DbContext/RiskeerEntities.edmx.diagram (.../RiskeerEntities.edmx.diagram) (revision c9c2f50266a38f2eda8566eafe019d18b63f3f03)
@@ -53,103 +53,103 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
-
+
+
+
+
+
-
-
-
-
-
+
+
+
+
+
Index: Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk
===================================================================
diff -u -rebe7034bade41cc060e7674a24966af8d3c603b2 -rc9c2f50266a38f2eda8566eafe019d18b63f3f03
Binary files differ
Index: build/DatabaseStructure.sql
===================================================================
diff -u -rebe7034bade41cc060e7674a24966af8d3c603b2 -rc9c2f50266a38f2eda8566eafe019d18b63f3f03
--- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ebe7034bade41cc060e7674a24966af8d3c603b2)
+++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision c9c2f50266a38f2eda8566eafe019d18b63f3f03)
@@ -1,6 +1,6 @@
/* ---------------------------------------------------- */
/* Generated by Enterprise Architect Version 14.1 */
-/* Created On : 18-nov-2021 14:44:51 */
+/* Created On : 24-nov-2021 08:16:09 */
/* DBMS : SQLite */
/* ---------------------------------------------------- */
@@ -2332,15 +2332,15 @@
CREATE INDEX 'IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity'
ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteFailureMechanismEntity_RemoveFailureMechanismSectionEntityId]
- AFTER DELETE
- ON FailureMechanismFailureMechanismSectionEntity
- FOR EACH ROW
+CREATE TRIGGER [TR_AfterDeleteFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId]
+ AFTER DELETE
+ ON FailureMechanismFailureMechanismSectionEntity
+ FOR EACH ROW
BEGIN
- DELETE
- FROM FailureMechanismSectionEntity
- WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL
- AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
+ DELETE
+ FROM FailureMechanismSectionEntity
+ WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL
+ AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
END;
;
@@ -2575,15 +2575,15 @@
CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity'
ON 'HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionEntity_RemoveHydraulicLocationCalculationEntity]
- AFTER DELETE
- ON HydraulicLocationCalculationCollectionEntity
- FOR EACH ROW
+CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity]
+ AFTER DELETE
+ ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
+ FOR EACH ROW
BEGIN
- DELETE
- FROM HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
- WHERE OLD.HydraulicLocationCalculationCollectionEntityId IS NOT NULL
- AND HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntityId;
+ DELETE
+ FROM HydraulicLocationCalculationEntity
+ WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL
+ AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId;
END;
;
@@ -2602,15 +2602,15 @@
CREATE INDEX 'IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity'
ON 'HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionEntity_RemoveHydraulicLocationCalculationEntity]
- AFTER DELETE
- ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
- FOR EACH ROW
+CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity]
+ AFTER DELETE
+ ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity
+ FOR EACH ROW
BEGIN
- DELETE
- FROM HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity
- WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL
- AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId;
+ DELETE
+ FROM HydraulicLocationCalculationEntity
+ WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL
+ AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId;
END;
;
@@ -2799,15 +2799,15 @@
CREATE INDEX 'IXFK_SpecificFailurePathFailureMechanismSectionEntity_SpecificFailurePathEntity'
ON 'SpecificFailurePathFailureMechanismSectionEntity' ('SpecificFailurePathEntityId' ASC)
;
-CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathEntity_RemoveFailureMechanismSectionEntityId]
- AFTER DELETE
- ON SpecificFailurePathFailureMechanismSectionEntity
- FOR EACH ROW
+CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId]
+ AFTER DELETE
+ ON SpecificFailurePathFailureMechanismSectionEntity
+ FOR EACH ROW
BEGIN
- DELETE
- FROM FailureMechanismSectionEntity
- WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL
- AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
+ DELETE
+ FROM FailureMechanismSectionEntity
+ WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL
+ AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
END;
;
Index: design/DatabaseDesign.eap
===================================================================
diff -u -rebe7034bade41cc060e7674a24966af8d3c603b2 -rc9c2f50266a38f2eda8566eafe019d18b63f3f03
Binary files differ