Index: build/DatabaseStructure.sql =================================================================== diff -u -r2567eb40f5f9295f478057c81ce8126a9f4936b5 -r04216c97c279210b0db65a092a531387e6fe2666 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 2567eb40f5f9295f478057c81ce8126a9f4936b5) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 04216c97c279210b0db65a092a531387e6fe2666) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 25-mrt-2020 07:43:12 */ +/* Created On : 13-mei-2020 08:33:49 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -413,13 +413,13 @@ CREATE TABLE 'HydraulicLocationEntity' ( 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'HydraulicBoundaryDatabaseEntityId' INTEGER NOT NULL, 'LocationId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, 'LocationX' REAL NULL, 'LocationY' REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity' FOREIGN KEY ('HydraulicBoundaryDatabaseEntityId') REFERENCES 'HydraulicBoundaryDatabaseEntity' ('HydraulicBoundaryDatabaseEntity') ON DELETE No Action ON UPDATE No Action ) ; @@ -2116,8 +2116,8 @@ ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_AssessmentSectionEntity' - ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity' + ON 'HydraulicLocationEntity' ('HydraulicBoundaryDatabaseEntityId' ASC) ; CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity'