Index: build/DatabaseStructure.sql =================================================================== diff -u -ra123f54a925708cd0178ff835b1393f65a1f816f -r62365fed1bd7533a3dfbb9171c8e8d463f0b1bcc --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a123f54a925708cd0178ff835b1393f65a1f816f) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 62365fed1bd7533a3dfbb9171c8e8d463f0b1bcc) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 15.2 */ -/* Created On : 21-jan-2022 07:28:21 */ +/* Created On : 21-jan-2022 08:08:08 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -784,7 +784,7 @@ 'ClosingStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'AdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false 'RefinedSectionProbability' REAL NULL, @@ -827,7 +827,7 @@ 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'NonAdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false 'RefinedSectionProbability' REAL NULL, @@ -1039,7 +1039,7 @@ 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'AdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false @@ -1249,7 +1249,7 @@ 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'AdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false 'RefinedSectionProbability' REAL NULL, @@ -1509,7 +1509,7 @@ 'MacroStabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'AdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false @@ -1687,7 +1687,7 @@ 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'AdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbablity = 3 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbablity = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false @@ -1712,7 +1712,7 @@ 'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'NonAdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false 'RefinedSectionProbability' REAL NULL, @@ -1975,7 +1975,7 @@ 'StabilityPointStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'AdoptableInitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false 'RefinedSectionProbability' REAL NULL,