Index: Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk =================================================================== diff -u -r04216c97c279210b0db65a092a531387e6fe2666 -rcc13aeee33b7ad5a23538215fe6e8613ca49a5ec Binary files differ Index: build/DatabaseStructure.sql =================================================================== diff -u -r04216c97c279210b0db65a092a531387e6fe2666 -rcc13aeee33b7ad5a23538215fe6e8613ca49a5ec --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 04216c97c279210b0db65a092a531387e6fe2666) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision cc13aeee33b7ad5a23538215fe6e8613ca49a5ec) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 13-mei-2020 08:33:49 */ +/* Created On : 13-mei-2020 11:52:00 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -419,7 +419,7 @@ 'LocationX' REAL NULL, 'LocationY' REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity' FOREIGN KEY ('HydraulicBoundaryDatabaseEntityId') REFERENCES 'HydraulicBoundaryDatabaseEntity' ('HydraulicBoundaryDatabaseEntity') ON DELETE No Action ON UPDATE No Action + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity' FOREIGN KEY ('HydraulicBoundaryDatabaseEntityId') REFERENCES 'HydraulicBoundaryDatabaseEntity' ('HydraulicBoundaryDatabaseEntity') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -840,7 +840,7 @@ ( 'DuneLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, - 'LocationId' INTEGER NOT NULL, + 'HydraulicLocationEntityId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, 'LocationX' REAL NULL, 'LocationY' REAL NULL, @@ -849,7 +849,8 @@ 'Orientation' REAL NULL, 'D50' REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_DuneLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_DuneLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_DuneLocationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -2334,6 +2335,10 @@ ON 'DuneLocationEntity' ('FailureMechanismEntityId' ASC) ; +CREATE INDEX 'IXFK_DuneLocationEntity_HydraulicLocationEntity' + ON 'DuneLocationEntity' ('HydraulicLocationEntityId' ASC) +; + CREATE INDEX 'IXFK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint' ON 'FaultTreeIllustrationPointEntity' ('ParentFaultTreeIllustrationPointEntityId' ASC) ; Index: design/DatabaseDesign.eap =================================================================== diff -u -r04216c97c279210b0db65a092a531387e6fe2666 -rcc13aeee33b7ad5a23538215fe6e8613ca49a5ec Binary files differ