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; +;