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