Index: build/DatabaseStructure.sql =================================================================== diff -u -r0a47a2db79679de5ee099ee626c4322d311ade29 -rebe7034bade41cc060e7674a24966af8d3c603b2 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 0a47a2db79679de5ee099ee626c4322d311ade29) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ebe7034bade41cc060e7674a24966af8d3c603b2) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 12-nov-2021 10:26:25 */ +/* Created On : 18-nov-2021 14:44:51 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -359,7 +359,6 @@ 'NormativeNormType' TINYINT (1) NOT NULL, -- EnumType: 1 = LowerLimit, 2 = Signaling 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune 'ReferenceLinePointXml' TEXT NULL, - 'Order' INT (4) NOT NULL, CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity1Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity2Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade, @@ -1259,7 +1258,7 @@ 'HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NOT NULL, 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL, CONSTRAINT 'PK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity' PRIMARY KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId','HydraulicLocationCalculationEntityId'), - CONSTRAINT 'HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntityId' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntityId' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntityId' FOREIGN KEY ('HydraulicLocationCalculationEntityId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE No Action ) ; @@ -2335,7 +2334,7 @@ ; CREATE TRIGGER [TR_AfterDeleteFailureMechanismEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE - ON FailureMechanismEntity + ON FailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN DELETE @@ -2582,9 +2581,9 @@ FOR EACH ROW BEGIN DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; + FROM HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity + WHERE OLD.HydraulicLocationCalculationCollectionEntityId IS NOT NULL + AND HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntityId; END; ; @@ -2605,11 +2604,11 @@ ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionEntity_RemoveHydraulicLocationCalculationEntity] AFTER DELETE - ON HydraulicLocationCalculationForTargetProbabilityCollectionEntity + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity FOR EACH ROW BEGIN DELETE - FROM HydraulicLocationCalculationEntity + FROM HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; END; @@ -2796,9 +2795,13 @@ CREATE INDEX 'IXFK_SpecificFailurePathFailureMechanismSectionEntity_FailureMechanismSectionEntity' ON 'SpecificFailurePathFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC) ; + +CREATE INDEX 'IXFK_SpecificFailurePathFailureMechanismSectionEntity_SpecificFailurePathEntity' + ON 'SpecificFailurePathFailureMechanismSectionEntity' ('SpecificFailurePathEntityId' ASC) +; CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE - ON SpecificFailurePathEntity + ON SpecificFailurePathFailureMechanismSectionEntity FOR EACH ROW BEGIN DELETE