Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r0a571f01845e933a1c290776f90b23df394debd6 -rac7fcdda3d4fc6f28d2d466055769ff03f7580fd --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 0a571f01845e933a1c290776f90b23df394debd6) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ac7fcdda3d4fc6f28d2d466055769ff03f7580fd) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 27-okt-2016 15:12:09 */ +/* Created On : 27-Oct-2016 3:40:01 PM */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -509,9 +509,11 @@ ( 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'HeightStructuresCalculationEntityId' INTEGER, 'LayerOne' TINYINT (1) NOT NULL, -- true or false 'LayerThree' REAL, - CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' FOREIGN KEY ('HeightStructuresCalculationEntityId') REFERENCES 'HeightStructuresCalculationEntity' ('HeightStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade ) ; @@ -1014,7 +1016,7 @@ 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, 'FlowWidthAtBottomProtectionMean' REAL, 'FlowWidthAtBottomProtectionStandardDeviation' REAL, - 'ProbabilityOpenStructureBeforeFlooding' REAL, + 'ProbabilityOpenStructureBeforeFlooding' REAL NOT NULL, 'FailureProbabilityOpenStructure' REAL NOT NULL, 'IdenticalApertures' INT (4) NOT NULL, 'FailureProbablityReparation' REAL NOT NULL, @@ -1212,6 +1214,10 @@ ON 'HeightStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' + ON 'HeightStructuresSectionResultEntity' ('HeightStructuresCalculationEntityId' ASC) +; + CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' ON 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ;