Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql =================================================================== diff -u -r9e87591d99c3f1a53f2c93e4dbba8c8ebae492a3 -rf8d9feb1ef04c6ac0e066961f9cf5f63e2817a35 --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql (.../DatabaseStructure18.1.sql) (revision 9e87591d99c3f1a53f2c93e4dbba8c8ebae492a3) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql (.../DatabaseStructure18.1.sql) (revision f8d9feb1ef04c6ac0e066961f9cf5f63e2817a35) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 30-Mar-2018 08:11:27 */ +/* Created On : 04-Apr-2018 13:01:32 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -2713,3 +2713,13 @@ CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionToHydraulicCalculationEntity_HydraulicLocationCalculationEntity' ON 'HydraulicLocationCalculationCollectionToHydraulicCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC) ; +CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionEntity_RemoveHydraulicLocationCalculationEntities] + AFTER DELETE + ON HydraulicLocationCalculationCollectionEntity + FOR EACH ROW +BEGIN + DELETE + FROM HydraulicLocationCalculationEntity + WHERE HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; +END; +; Index: Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd =================================================================== diff -u -rf2de3d7dc89f96fd652a166c5b75c41e22485f21 -rf8d9feb1ef04c6ac0e066961f9cf5f63e2817a35 Binary files differ Index: build/DatabaseStructure.sql =================================================================== diff -u -rf2de3d7dc89f96fd652a166c5b75c41e22485f21 -rf8d9feb1ef04c6ac0e066961f9cf5f63e2817a35 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f2de3d7dc89f96fd652a166c5b75c41e22485f21) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f8d9feb1ef04c6ac0e066961f9cf5f63e2817a35) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 30-Mar-2018 08:11:27 */ +/* Created On : 04-Apr-2018 13:01:32 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -2713,3 +2713,13 @@ CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionToHydraulicCalculationEntity_HydraulicLocationCalculationEntity' ON 'HydraulicLocationCalculationCollectionToHydraulicCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC) ; +CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionEntity_RemoveHydraulicLocationCalculationEntities] + AFTER DELETE + ON HydraulicLocationCalculationCollectionEntity + FOR EACH ROW +BEGIN + DELETE + FROM HydraulicLocationCalculationEntity + WHERE HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; +END; +; Index: design/DatabaseDesign.eap =================================================================== diff -u -rcd1a608f9617250f44c1398f382b2bc76c0191a0 -rf8d9feb1ef04c6ac0e066961f9cf5f63e2817a35 Binary files differ