Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql =================================================================== diff -u -r8e8b21164018eea7caf740234fff33a7ea9c5157 -rc3f8f8f9ce4133a7651b3270417168c3857aa68c --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql (.../DatabaseStructure23.1.sql) (revision 8e8b21164018eea7caf740234fff33a7ea9c5157) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql (.../DatabaseStructure23.1.sql) (revision c3f8f8f9ce4133a7651b3270417168c3857aa68c) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 12-mei-2023 15:15:12 */ +/* Created On : 25-mei-2023 12:58:18 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -360,7 +360,7 @@ InAssemblyOutputComments TEXT NULL COLLATE NOCASE, NotInAssemblyComments TEXT NULL COLLATE NOCASE, CalculationsInputComments TEXT NULL COLLATE NOCASE, - FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 3, Manual = 4 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, CONSTRAINT FK_FailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_FailureMechanismEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, @@ -386,7 +386,7 @@ Name VARCHAR (260) NULL, 'Order' INT (4) NOT NULL, CONSTRAINT FK_CalculationGroupEntity_CalculationGroupEntity FOREIGN KEY (ParentCalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE HydraulicLocationEntity @@ -399,7 +399,7 @@ LocationY REAL NULL, 'Order' INT (4) NOT NULL, CONSTRAINT FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity FOREIGN KEY (HydraulicBoundaryDatabaseEntityId) REFERENCES HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDatabaseEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE GrassCoverErosionInwardsFailureMechanismMetaEntity @@ -437,7 +437,7 @@ CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE GrassCoverErosionInwardsCalculationEntity @@ -469,7 +469,7 @@ CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity FOREIGN KEY (DikeProfileEntityId) REFERENCES DikeProfileEntity (DikeProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE GrassCoverSlipOffInwardsFailureMechanismMetaEntity @@ -510,7 +510,7 @@ PermeabilityCoefficientOfVariation REAL NULL, 'Order' INT (4) NOT NULL, CONSTRAINT FK_PipingSoilLayerEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE PipingSoilProfileEntity @@ -531,7 +531,7 @@ 'Order' INT (4) NOT NULL, CONSTRAINT FK_PipingStochasticSoilProfileEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE PipingScenarioConfigurationPerFailureMechanismSectionEntity @@ -552,7 +552,7 @@ 'Order' INT (4) NOT NULL, CONSTRAINT FK_StochasticSoilModelEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT UQ_StochasticSoilModelEntity_NameFailureMechanismEntityId UNIQUE (Name,FailureMechanismEntityId) - ) +) ; CREATE TABLE SurfaceLineEntity @@ -566,7 +566,7 @@ 'Order' INT (4) NOT NULL, CONSTRAINT FK_SurfaceLineEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT UQ_SurfaceLineEntity_NameFailureMechanismEntityId UNIQUE (Name,FailureMechanismEntityId) - ) +) ; CREATE TABLE PipingCharacteristicPointEntity @@ -689,7 +689,7 @@ InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert CONSTRAINT FK_ClosingStructureEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) - ) +) ; CREATE TABLE ClosingStructuresCalculationEntity @@ -745,7 +745,7 @@ CONSTRAINT FK_ClosingStructuresCalculationEntity_ClosingStructureEntity FOREIGN KEY (ClosingStructureEntityId) REFERENCES ClosingStructureEntity (ClosingStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_ClosingStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE ClosingStructuresOutputEntity @@ -778,7 +778,7 @@ 'Order' INT (4) NOT NULL, CONSTRAINT FK_DikeProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT UQ_DikeProfileEntity_IdFailureMechanismEntityId UNIQUE (Id,FailureMechanismEntityId) - ) +) ; CREATE TABLE DuneErosionFailureMechanismMetaEntity @@ -807,7 +807,7 @@ 'Order' INT (4) NOT NULL, TargetProbability REAL NOT NULL, CONSTRAINT FK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity FOREIGN KEY (DuneErosionFailureMechanismMetaEntityId) REFERENCES DuneErosionFailureMechanismMetaEntity (DuneErosionFailureMechanismMetaEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE DuneLocationCalculationOutputEntity @@ -840,7 +840,7 @@ 'Order' INT (4) NOT NULL, 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 - ) +) ; CREATE TABLE FailureMechanismFailureMechanismSectionEntity @@ -862,7 +862,7 @@ CombinationType TINYINT (1) NOT NULL, -- Enum: 1 = Or, 2 = And 'Order' INT (4) NOT NULL, CONSTRAINT FK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint FOREIGN KEY (ParentFaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE FaultTreeIllustrationPointStochastEntity @@ -901,7 +901,7 @@ 'Order' INT (4) NOT NULL, CONSTRAINT FK_ForeshoreProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT UQ_ForeshoreProfileEntity_IdFailureMechanismEntityId UNIQUE (Id,FailureMechanismEntityId) - ) +) ; CREATE TABLE GeneralResultFaultTreeIllustrationPointEntity @@ -969,7 +969,7 @@ CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity FOREIGN KEY (GrassCoverErosionInwardsCalculationEntityId) REFERENCES GrassCoverErosionInwardsCalculationEntity (GrassCoverErosionInwardsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT U_GrassCoverErosionInwardsCalculationEntity UNIQUE (GrassCoverErosionInwardsCalculationEntityId) - ) +) ; CREATE TABLE GrassCoverErosionInwardsOvertoppingRateOutputEntity @@ -1015,7 +1015,7 @@ CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE GrassCoverErosionOutwardsWaveConditionsOutputEntity @@ -1035,7 +1035,7 @@ CalculatedReliability REAL NULL, CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity FOREIGN KEY (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId) REFERENCES GrassCoverErosionOutwardsWaveConditionsCalculationEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE GrassCoverSlipOffOutwardsFailureMechanismMetaEntity @@ -1073,7 +1073,7 @@ AllowedLevelIncreaseStorageStandardDeviation REAL NULL, CONSTRAINT FK_HeightStructure_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) - ) +) ; CREATE TABLE HeightStructuresCalculationEntity @@ -1114,7 +1114,7 @@ CONSTRAINT FK_HeightStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_HeightStructuresCalculationEntity_HeightStructureEntity FOREIGN KEY (HeightStructureEntityId) REFERENCES HeightStructureEntity (HeightStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_HeightStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE HeightStructuresFailureMechanismMetaEntity @@ -1149,7 +1149,7 @@ UsePreprocessorClosure TINYINT (1) NOT NULL, -- True or false 'Order' INT (4) NOT NULL, CONSTRAINT FK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity FOREIGN KEY (HydraulicBoundaryDataEntityId) REFERENCES HydraulicBoundaryDataEntity (HydraulicBoundaryDataEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE HydraulicBoundaryDataEntity @@ -1203,7 +1203,7 @@ HydraulicBoundaryLocationCalculationType TINYINT (1) NOT NULL, -- Enum: 1 = Waterlevel 2 = Waveheight TargetProbability REAL NOT NULL, CONSTRAINT FK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity @@ -1241,7 +1241,7 @@ Value REAL NOT NULL, 'Order' INT (4) NOT NULL, CONSTRAINT FK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE MacroStabilityInwardsCalculationEntity @@ -1314,7 +1314,7 @@ CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity FOREIGN KEY (MacroStabilityInwardsStochasticSoilProfileEntityId) REFERENCES MacroStabilityInwardsStochasticSoilProfileEntity (MacroStabilityInwardsStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE MacroStabilityInwardsCalculationOutputEntity @@ -1393,7 +1393,7 @@ PreconsolidationStressCoefficientOfVariation REAL NULL, 'Order' INT (4) NOT NULL, CONSTRAINT FK_MacroStabilityInwardsPreconsolidationStressEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE MacroStabilityInwardsSoilLayerOneDEntity @@ -1424,7 +1424,7 @@ PopCoefficientOfVariation REAL NULL, 'Order' INT (4) NOT NULL, CONSTRAINT FK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE MacroStabilityInwardsSoilLayerTwoDEntity @@ -1455,7 +1455,7 @@ OuterRingXml TEXT NOT NULL COLLATE NOCASE, 'Order' INT (4) NOT NULL, CONSTRAINT FK_MacroStabilityInwardsSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity FOREIGN KEY (ParentMacroStabilityInwardsSoilLayerTwoDEntityId) REFERENCES MacroStabilityInwardsSoilLayerTwoDEntity (MacroStabilityInwardsSoilLayerTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE MacroStabilityInwardsSoilProfileOneDEntity @@ -1494,7 +1494,7 @@ CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE MicrostabilityFailureMechanismMetaEntity @@ -1581,7 +1581,7 @@ CONSTRAINT FK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE ProbabilisticPipingCalculationOutputEntity @@ -1601,7 +1601,7 @@ CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action, CONSTRAINT U_ProbabilisticPipingCalculationEntity UNIQUE (ProbabilisticPipingCalculationEntityId) - ) +) ; CREATE TABLE SemiProbabilisticPipingCalculationOutputEntity @@ -1619,7 +1619,7 @@ SellmeijerReducedFall REAL NULL, CONSTRAINT FK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity FOREIGN KEY (SemiProbabilisticPipingCalculationEntityId) REFERENCES SemiProbabilisticPipingCalculationEntity (SemiProbabilisticPipingCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT U_SemiProbabilisticPipingCalculationEntity UNIQUE (SemiProbabilisticPipingCalculationEntityId) - ) +) ; CREATE TABLE SpecificFailureMechanismEntity @@ -1635,11 +1635,11 @@ InAssemblyOutputComments TEXT NULL COLLATE NOCASE, NotInAssemblyComments TEXT NULL COLLATE NOCASE, N REAL NOT NULL, - FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 3, Manual = 4 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_SpecificFailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE SpecificFailureMechanismFailureMechanismSectionEntity @@ -1707,7 +1707,7 @@ InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = LowSill, 2 = FloodedCulvert CONSTRAINT FK_StabilityPointStructureEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) - ) +) ; CREATE TABLE StabilityPointStructuresCalculationEntity @@ -1782,7 +1782,7 @@ CONSTRAINT FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity FOREIGN KEY (StabilityPointStructureEntityId) REFERENCES StabilityPointStructureEntity (StabilityPointStructureEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE StabilityPointStructuresFailureMechanismMetaEntity @@ -1845,7 +1845,7 @@ CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE StabilityStoneCoverWaveConditionsOutputEntity @@ -1865,7 +1865,7 @@ CalculatedReliability REAL NULL, CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged CONSTRAINT FK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity FOREIGN KEY (StabilityStoneCoverWaveConditionsCalculationEntityId) REFERENCES StabilityStoneCoverWaveConditionsCalculationEntity (StabilityStoneCoverWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE StochastEntity @@ -1875,7 +1875,7 @@ Duration REAL NOT NULL, Alpha REAL NOT NULL, 'Order' INT (4) NOT NULL - ) +) ; CREATE TABLE SubMechanismIllustrationPointEntity @@ -1884,7 +1884,7 @@ Name TEXT NOT NULL COLLATE NOCASE, Beta REAL NOT NULL, 'Order' INT (4) NOT NULL - ) +) ; CREATE TABLE SubMechanismIllustrationPointStochastEntity @@ -1898,7 +1898,7 @@ Realization REAL NOT NULL, 'Order' INT (4) NOT NULL, CONSTRAINT FK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action - ) +) ; CREATE TABLE TopLevelFaultTreeIllustrationPointEntity @@ -1912,7 +1912,7 @@ 'Order' INT (4) NOT NULL, CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE TopLevelSubMechanismIllustrationPointEntity @@ -1926,7 +1926,7 @@ 'Order' INT (4) NOT NULL, CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; CREATE TABLE WaveImpactAsphaltCoverWaveConditionsCalculationEntity @@ -1954,7 +1954,7 @@ CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade - ) +) ; CREATE TABLE WaveImpactAsphaltCoverWaveConditionsOutputEntity @@ -1973,792 +1973,792 @@ CalculatedReliability REAL NULL, CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity FOREIGN KEY (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId) REFERENCES WaveImpactAsphaltCoverWaveConditionsCalculationEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade - ) +) ; /* Create Indexes and Triggers */ CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1 - ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity1Id ASC) + ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity1Id ASC) ; CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2 - ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity2Id ASC) + ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity2Id ASC) ; CREATE INDEX IXFK_AssessmentSectionEntity_ProjectEntity - ON AssessmentSectionEntity (ProjectEntityId ASC) + ON AssessmentSectionEntity (ProjectEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteAssessmentSectionEntity_RemoveHydraulicLocationCalculationCollectionEntities] AFTER DELETE -ON AssessmentSectionEntity + ON AssessmentSectionEntity FOR EACH ROW BEGIN -DELETE -FROM HydraulicLocationCalculationCollectionEntity -WHERE HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity1Id - OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity2Id; + DELETE + FROM HydraulicLocationCalculationCollectionEntity + WHERE HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity1Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity2Id; END; ; CREATE INDEX IXFK_FailureMechanismEntity_AssessmentSectionEntity - ON FailureMechanismEntity (AssessmentSectionEntityId ASC) + ON FailureMechanismEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismEntity_CalculationGroupEntity - ON FailureMechanismEntity (CalculationGroupEntityId ASC) + ON FailureMechanismEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity - ON ClosingStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON ClosingStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_CalculationGroupEntity_CalculationGroupEntity - ON CalculationGroupEntity (ParentCalculationGroupEntityId ASC) + ON CalculationGroupEntity (ParentCalculationGroupEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity - ON HydraulicLocationEntity (HydraulicBoundaryDatabaseEntityId ASC) + ON HydraulicLocationEntity (HydraulicBoundaryDatabaseEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity - ON SemiProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity - ON SemiProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity - ON SemiProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity - ON SemiProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity - ON GrassCoverErosionInwardsCalculationEntity (CalculationGroupEntityId ASC) + ON GrassCoverErosionInwardsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity - ON GrassCoverErosionInwardsCalculationEntity (DikeProfileEntityId ASC) + ON GrassCoverErosionInwardsCalculationEntity (DikeProfileEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity - ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) + ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_SoilProfileEntity - ON PipingStochasticSoilProfileEntity (PipingSoilProfileEntityId ASC) + ON PipingStochasticSoilProfileEntity (PipingSoilProfileEntityId ASC) ; CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity - ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) + ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) + ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_StochasticSoilModelEntity_FailureMechanismEntity - ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) + ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SurfaceLineEntity_FailureMechanismEntity - ON SurfaceLineEntity (FailureMechanismEntityId ASC) + ON SurfaceLineEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SurfaceLinePointEntity_SurfaceLineEntity - ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) + ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON AdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON AdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_BackgroundDataEntity_AssessmentSectionEntity - ON BackgroundDataEntity (AssessmentSectionEntityId ASC) + ON BackgroundDataEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_BackgroundDataMetaEntity_BackgroundDataEntity - ON BackgroundDataMetaEntity (BackgroundDataEntityId ASC) + ON BackgroundDataMetaEntity (BackgroundDataEntityId ASC) ; CREATE INDEX IXFK_ClosingStructureEntity_FailureMechanismEntity - ON ClosingStructureEntity (FailureMechanismEntityId ASC) + ON ClosingStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_CalculationGroupEntity - ON ClosingStructuresCalculationEntity (CalculationGroupEntityId ASC) + ON ClosingStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ClosingStructureEntity - ON ClosingStructuresCalculationEntity (ClosingStructureEntityId ASC) + ON ClosingStructuresCalculationEntity (ClosingStructureEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity - ON ClosingStructuresCalculationEntity (ForeshoreProfileEntityId ASC) + ON ClosingStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_HydraulicLocationEntity - ON ClosingStructuresCalculationEntity (HydraulicLocationEntityId ASC) + ON ClosingStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity - ON ClosingStructuresOutputEntity (ClosingStructuresCalculationEntityId ASC) + ON ClosingStructuresOutputEntity (ClosingStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteClosingStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE -ON ClosingStructuresOutputEntity + ON ClosingStructuresOutputEntity FOR EACH ROW BEGIN -DELETE -FROM GeneralResultFaultTreeIllustrationPointEntity -WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; + DELETE + FROM GeneralResultFaultTreeIllustrationPointEntity + WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_DikeProfileEntity_FailureMechanismEntity - ON DikeProfileEntity (FailureMechanismEntityId ASC) + ON DikeProfileEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity - ON DuneErosionFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON DuneErosionFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity - ON DuneLocationCalculationEntity (DuneLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON DuneLocationCalculationEntity (DuneLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationEntity - ON DuneLocationCalculationEntity (DuneLocationEntityId ASC) + ON DuneLocationCalculationEntity (DuneLocationEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity - ON DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneErosionFailureMechanismMetaEntityId ASC) + ON DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneErosionFailureMechanismMetaEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity - ON DuneLocationCalculationOutputEntity (DuneLocationCalculationEntityId ASC) + ON DuneLocationCalculationOutputEntity (DuneLocationCalculationEntityId ASC) ; CREATE INDEX IXFK_DuneLocationEntity_FailureMechanismEntity - ON DuneLocationEntity (FailureMechanismEntityId ASC) + ON DuneLocationEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneLocationEntity_HydraulicLocationEntity - ON DuneLocationEntity (HydraulicLocationEntityId ASC) + ON DuneLocationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity - ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismEntityId ASC) + ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) + ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE -ON FailureMechanismFailureMechanismSectionEntity + ON FailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN -DELETE -FROM FailureMechanismSectionEntity -WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL - AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; + DELETE + FROM FailureMechanismSectionEntity + WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL + AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; END; ; CREATE INDEX IXFK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint - ON FaultTreeIllustrationPointEntity (ParentFaultTreeIllustrationPointEntityId ASC) + ON FaultTreeIllustrationPointEntity (ParentFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint - ON FaultTreeIllustrationPointStochastEntity (FaultTreeIllustrationPointEntityId ASC) + ON FaultTreeIllustrationPointStochastEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_StochastEntity - ON FaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) + ON FaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE -ON FaultTreeIllustrationPointStochastEntity + ON FaultTreeIllustrationPointStochastEntity FOR EACH ROW BEGIN -DELETE -FROM StochastEntity -WHERE OLD.StochastEntityId IS NOT NULL - AND StochastEntityId IS OLD.StochastEntityId; + DELETE + FROM StochastEntity + WHERE OLD.StochastEntityId IS NOT NULL + AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity - ON FaultTreeSubmechanismIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) + ON FaultTreeSubmechanismIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity - ON FaultTreeSubmechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) + ON FaultTreeSubmechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeSubmechanismIllustrationPointEntity_RemoveSubmechanismIllustrationPointEntity] AFTER DELETE -ON FaultTreeSubmechanismIllustrationPointEntity + ON FaultTreeSubmechanismIllustrationPointEntity FOR EACH ROW BEGIN -DELETE -FROM SubmechanismIllustrationPointEntity -WHERE OLD.SubmechanismIllustrationPointEntityId IS NOT NULL - AND SubmechanismIllustrationPointEntityId IS OLD.SubmechanismIllustrationPointEntityId; + DELETE + FROM SubmechanismIllustrationPointEntity + WHERE OLD.SubmechanismIllustrationPointEntityId IS NOT NULL + AND SubmechanismIllustrationPointEntityId IS OLD.SubmechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_ForeshoreProfileEntity_FailureMechanismEntity - ON ForeshoreProfileEntity (FailureMechanismEntityId ASC) + ON ForeshoreProfileEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GeneralResultFaultTreeIllustrationPointStochastEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GeneralResultFaultTreeIllustrationPointStochastEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity - ON GeneralResultFaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) + ON GeneralResultFaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE -ON GeneralResultFaultTreeIllustrationPointStochastEntity + ON GeneralResultFaultTreeIllustrationPointStochastEntity FOR EACH ROW BEGIN -DELETE -FROM StochastEntity -WHERE OLD.StochastEntityId IS NOT NULL - AND StochastEntityId IS OLD.StochastEntityId; + DELETE + FROM StochastEntity + WHERE OLD.StochastEntityId IS NOT NULL + AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity - ON GeneralResultSubMechanismIllustrationPointStochastEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) + ON GeneralResultSubMechanismIllustrationPointStochastEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity - ON GeneralResultSubMechanismIllustrationPointStochastEntity (StochastEntityId ASC) + ON GeneralResultSubMechanismIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultSubMechanismIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE -ON GeneralResultSubMechanismIllustrationPointStochastEntity + ON GeneralResultSubMechanismIllustrationPointStochastEntity FOR EACH ROW BEGIN -DELETE -FROM StochastEntity -WHERE OLD.StochastEntityId IS NOT NULL - AND StochastEntityId IS OLD.StochastEntityId; + DELETE + FROM StochastEntity + WHERE OLD.StochastEntityId IS NOT NULL + AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GrassCoverErosionInwardsDikeHeightOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GrassCoverErosionInwardsDikeHeightOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity - ON GrassCoverErosionInwardsDikeHeightOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) + ON GrassCoverErosionInwardsDikeHeightOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsDikeHeightOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE -ON GrassCoverErosionInwardsDikeHeightOutputEntity + ON GrassCoverErosionInwardsDikeHeightOutputEntity FOR EACH ROW BEGIN -DELETE -FROM GeneralResultFaultTreeIllustrationPointEntity -WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; + DELETE + FROM GeneralResultFaultTreeIllustrationPointEntity + WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GrassCoverErosionInwardsOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GrassCoverErosionInwardsOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity - ON GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsCalculationEntityId ASC) + ON GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE -ON GrassCoverErosionInwardsOutputEntity + ON GrassCoverErosionInwardsOutputEntity FOR EACH ROW BEGIN -DELETE -FROM GeneralResultFaultTreeIllustrationPointEntity -WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; + DELETE + FROM GeneralResultFaultTreeIllustrationPointEntity + WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity - ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) + ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOvertoppingRateOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE -ON GrassCoverErosionInwardsOvertoppingRateOutputEntity + ON GrassCoverErosionInwardsOvertoppingRateOutputEntity FOR EACH ROW BEGIN -DELETE -FROM GeneralResultFaultTreeIllustrationPointEntity -WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; + DELETE + FROM GeneralResultFaultTreeIllustrationPointEntity + WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity - ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructure_FailureMechanismEntity - ON HeightStructureEntity (FailureMechanismEntityId ASC) + ON HeightStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity - ON HeightStructuresCalculationEntity (CalculationGroupEntityId ASC) + ON HeightStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_ForeshoreProfileEntity - ON HeightStructuresCalculationEntity (ForeshoreProfileEntityId ASC) + ON HeightStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_HeightStructureEntity - ON HeightStructuresCalculationEntity (HeightStructureEntityId ASC) + ON HeightStructuresCalculationEntity (HeightStructureEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity - ON HeightStructuresCalculationEntity (HydraulicLocationEntityId ASC) + ON HeightStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity - ON HeightStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON HeightStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity - ON HeightStructuresOutputEntity (HeightStructuresCalculationEntityId ASC) + ON HeightStructuresOutputEntity (HeightStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHeightStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE -ON HeightStructuresOutputEntity + ON HeightStructuresOutputEntity FOR EACH ROW BEGIN -DELETE -FROM GeneralResultFaultTreeIllustrationPointEntity -WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; + DELETE + FROM GeneralResultFaultTreeIllustrationPointEntity + WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity - ON HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDataEntityId ASC) + ON HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDataEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity - ON HydraulicBoundaryDataEntity (AssessmentSectionEntityId ASC) + ON HydraulicBoundaryDataEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntity - ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationCollectionEntityId ASC) + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationCollectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity - ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] AFTER DELETE -ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity FOR EACH ROW BEGIN -DELETE -FROM HydraulicLocationCalculationEntity -WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; + DELETE + FROM HydraulicLocationCalculationEntity + WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL + AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; END; ; CREATE INDEX IXFK_HydraulicLocationCalculationEntity_HydraulicLocationEntity - ON HydraulicLocationCalculationEntity (HydraulicLocationEntityId ASC) + ON HydraulicLocationCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity - ON HydraulicLocationCalculationForTargetProbabilityCollectionEntity (AssessmentSectionEntityId ASC) + ON HydraulicLocationCalculationForTargetProbabilityCollectionEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity - ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity - ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) + ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] AFTER DELETE -ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity + ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity FOR EACH ROW BEGIN -DELETE -FROM HydraulicLocationCalculationEntity -WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; + DELETE + FROM HydraulicLocationCalculationEntity + WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL + AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; END; ; CREATE INDEX IXFK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity - ON HydraulicLocationOutputEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) + ON HydraulicLocationOutputEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity - ON HydraulicLocationOutputEntity (HydraulicLocationCalculationEntityId ASC) + ON HydraulicLocationOutputEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationOutputEntity_RemoveGeneralResultSubMechanismIllustrationPointEntity] AFTER DELETE -ON HydraulicLocationOutputEntity + ON HydraulicLocationOutputEntity FOR EACH ROW BEGIN -DELETE -FROM GeneralResultSubMechanismIllustrationPointEntity -WHERE OLD.GeneralResultSubMechanismIllustrationPointEntityId IS NOT NULL - AND GeneralResultSubMechanismIllustrationPointEntityId IS OLD.GeneralResultSubMechanismIllustrationPointEntityId; + DELETE + FROM GeneralResultSubMechanismIllustrationPointEntity + WHERE OLD.GeneralResultSubMechanismIllustrationPointEntityId IS NOT NULL + AND GeneralResultSubMechanismIllustrationPointEntityId IS OLD.GeneralResultSubMechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity - ON IllustrationPointResultEntity (SubMechanismIllustrationPointEntityId ASC) + ON IllustrationPointResultEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity - ON MacroStabilityInwardsCalculationEntity (CalculationGroupEntityId ASC) + ON MacroStabilityInwardsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity - ON MacroStabilityInwardsCalculationEntity (HydraulicLocationEntityId ASC) + ON MacroStabilityInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity - ON MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsStochasticSoilProfileEntityId ASC) + ON MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity - ON MacroStabilityInwardsCalculationOutputEntity (MacroStabilityInwardsCalculationEntityId ASC) + ON MacroStabilityInwardsCalculationOutputEntity (MacroStabilityInwardsCalculationEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityCharacteristicPointEntity_SurfaceLineEntity - ON MacroStabilityInwardsCharacteristicPointEntity (SurfaceLineEntityId ASC) + ON MacroStabilityInwardsCharacteristicPointEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON MacroStabilityInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON MacroStabilityInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity - ON MacroStabilityInwardsSoilLayerOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId ASC) + ON MacroStabilityInwardsSoilLayerOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteMacroStabilityInwardsSoilProfileTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity] AFTER DELETE -ON MacroStabilityInwardsSoilProfileTwoDEntity + ON MacroStabilityInwardsSoilProfileTwoDEntity FOR EACH ROW BEGIN -DELETE -FROM MacroStabilityInwardsSoilLayerTwoDEntity -WHERE OLD.MacroStabilityInwardsSoilLayerTwoDEntity IS NOT NULL - AND MacroStabilityInwardsSoilLayerTwoDEntity IS OLD.MacroStabilityInwardsSoilLayerTwoDEntity; + DELETE + FROM MacroStabilityInwardsSoilLayerTwoDEntity + WHERE OLD.MacroStabilityInwardsSoilLayerTwoDEntity IS NOT NULL + AND MacroStabilityInwardsSoilLayerTwoDEntity IS OLD.MacroStabilityInwardsSoilLayerTwoDEntity; END; ; CREATE INDEX IXFK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity - ON MacroStabilityInwardsStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) + ON MacroStabilityInwardsStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; CREATE TRIGGER [TR_BeforeInsertMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] BEFORE INSERT ON MacroStabilityInwardsStochasticSoilProfileEntity FOR EACH ROW BEGIN -SELECT - CASE - WHEN - ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL - ) OR ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL - ) - THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') + SELECT + CASE + WHEN + ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL + ) OR ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL + ) + THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') END; END; ; CREATE TRIGGER [TR_BeforeUpdateMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] BEFORE UPDATE - ON MacroStabilityInwardsStochasticSoilProfileEntity - FOR EACH ROW + ON MacroStabilityInwardsStochasticSoilProfileEntity + FOR EACH ROW BEGIN -SELECT - CASE - WHEN - ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL - ) OR ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL - ) - THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') + SELECT + CASE + WHEN + ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL + ) OR ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL + ) + THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') END; END; ; CREATE INDEX IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity - ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity - ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity - ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity - ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) + ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity - ON ProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) + ON ProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity - ON ProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) + ON ProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity - ON ProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) + ON ProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity - ON ProbabilisticPipingCalculationOutputEntity (ProbabilisticPipingCalculationEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProbabilisticPipingCalculationEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity - ON SemiProbabilisticPipingCalculationOutputEntity (SemiProbabilisticPipingCalculationEntityId ASC) + ON SemiProbabilisticPipingCalculationOutputEntity (SemiProbabilisticPipingCalculationEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismEntity_AssessmentSectionEntity - ON SpecificFailureMechanismEntity (AssessmentSectionEntityId ASC) + ON SpecificFailureMechanismEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON SpecificFailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) + ON SpecificFailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity - ON SpecificFailureMechanismFailureMechanismSectionEntity (SpecificFailureMechanismEntityId ASC) + ON SpecificFailureMechanismFailureMechanismSectionEntity (SpecificFailureMechanismEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteSpecificFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE -ON SpecificFailureMechanismFailureMechanismSectionEntity + ON SpecificFailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN -DELETE -FROM FailureMechanismSectionEntity -WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL - AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; + DELETE + FROM FailureMechanismSectionEntity + WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL + AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; END; ; CREATE INDEX IXFK_StabilityPointStructureEntity_FailureMechanismEntity - ON StabilityPointStructureEntity (FailureMechanismEntityId ASC) + ON StabilityPointStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity - ON StabilityPointStructuresCalculationEntity (CalculationGroupEntityId ASC) + ON StabilityPointStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity - ON StabilityPointStructuresCalculationEntity (ForeshoreProfileEntityId ASC) + ON StabilityPointStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity - ON StabilityPointStructuresCalculationEntity (HydraulicLocationEntityId ASC) + ON StabilityPointStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity - ON StabilityPointStructuresCalculationEntity (StabilityPointStructureEntityId ASC) + ON StabilityPointStructuresCalculationEntity (StabilityPointStructureEntityId ASC) ; CREATE INDEX IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity - ON StabilityPointStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON StabilityPointStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity - ON StabilityPointStructuresOutputEntity (StabilityPointStructuresCalculationEntityId ASC) + ON StabilityPointStructuresOutputEntity (StabilityPointStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteStabilityPointStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE -ON StabilityPointStructuresOutputEntity + ON StabilityPointStructuresOutputEntity FOR EACH ROW BEGIN -DELETE -FROM GeneralResultFaultTreeIllustrationPointEntity -WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; + DELETE + FROM GeneralResultFaultTreeIllustrationPointEntity + WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON StabilityStoneCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON StabilityStoneCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity - ON StabilityStoneCoverWaveConditionsOutputEntity (StabilityStoneCoverWaveConditionsCalculationEntityId ASC) + ON StabilityStoneCoverWaveConditionsOutputEntity (StabilityStoneCoverWaveConditionsCalculationEntityId ASC) ; CREATE INDEX IXFK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity - ON SubMechanismIllustrationPointStochastEntity (SubMechanismIllustrationPointEntityId ASC) + ON SubMechanismIllustrationPointStochastEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity - ON TopLevelFaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) + ON TopLevelFaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity - ON TopLevelFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON TopLevelFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelFaultTreeIllustrationPointEntity_RemoveFaultTreeIllustrationPointEntity] AFTER DELETE -ON TopLevelFaultTreeIllustrationPointEntity + ON TopLevelFaultTreeIllustrationPointEntity FOR EACH ROW BEGIN -DELETE -FROM FaultTreeIllustrationPointEntity -WHERE OLD.FaultTreeIllustrationPointEntityId IS NOT NULL - AND FaultTreeIllustrationPointEntityId IS OLD.FaultTreeIllustrationPointEntityId; + DELETE + FROM FaultTreeIllustrationPointEntity + WHERE OLD.FaultTreeIllustrationPointEntityId IS NOT NULL + AND FaultTreeIllustrationPointEntityId IS OLD.FaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity - ON TopLevelSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) + ON TopLevelSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity - ON TopLevelSubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) + ON TopLevelSubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelSubMechanismIllustrationPointEntity_RemoveSubMechanismIllustrationPointEntity] AFTER DELETE -ON TopLevelSubMechanismIllustrationPointEntity + ON TopLevelSubMechanismIllustrationPointEntity FOR EACH ROW BEGIN -DELETE -FROM SubMechanismIllustrationPointEntity -WHERE OLD.SubMechanismIllustrationPointEntityId IS NOT NULL - AND SubMechanismIllustrationPointEntityId IS OLD.SubMechanismIllustrationPointEntityId; + DELETE + FROM SubMechanismIllustrationPointEntity + WHERE OLD.SubMechanismIllustrationPointEntityId IS NOT NULL + AND SubMechanismIllustrationPointEntityId IS OLD.SubMechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity - ON WaveImpactAsphaltCoverWaveConditionsOutputEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsOutputEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId ASC) ; Index: build/DatabaseStructure.sql =================================================================== diff -u -r8e8b21164018eea7caf740234fff33a7ea9c5157 -rc3f8f8f9ce4133a7651b3270417168c3857aa68c --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8e8b21164018eea7caf740234fff33a7ea9c5157) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision c3f8f8f9ce4133a7651b3270417168c3857aa68c) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 12-mei-2023 15:15:12 */ +/* Created On : 25-mei-2023 12:58:18 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -360,7 +360,7 @@ InAssemblyOutputComments TEXT NULL COLLATE NOCASE, NotInAssemblyComments TEXT NULL COLLATE NOCASE, CalculationsInputComments TEXT NULL COLLATE NOCASE, - FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 3, Manual = 4 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, CONSTRAINT FK_FailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT FK_FailureMechanismEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, @@ -1635,7 +1635,7 @@ InAssemblyOutputComments TEXT NULL COLLATE NOCASE, NotInAssemblyComments TEXT NULL COLLATE NOCASE, N REAL NOT NULL, - FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 3, Manual = 4 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_SpecificFailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade Index: design/DatabaseDesign.eap =================================================================== diff -u -r8e8b21164018eea7caf740234fff33a7ea9c5157 -rc3f8f8f9ce4133a7651b3270417168c3857aa68c Binary files differ