Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql =================================================================== diff -u -rdea5708b2c085512ce1724cf19eab59e79bc78c6 -r8e8b21164018eea7caf740234fff33a7ea9c5157 --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql (.../DatabaseStructure23.1.sql) (revision dea5708b2c085512ce1724cf19eab59e79bc78c6) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql (.../DatabaseStructure23.1.sql) (revision 8e8b21164018eea7caf740234fff33a7ea9c5157) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 05-mei-2023 15:02:30 */ +/* Created On : 12-mei-2023 15:15:12 */ /* 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: Automatic = 1, Manual = 2 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 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: Automatic = 1, Manual = 2 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 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: build/DatabaseStructure.sql =================================================================== diff -u -rdea5708b2c085512ce1724cf19eab59e79bc78c6 -r8e8b21164018eea7caf740234fff33a7ea9c5157 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision dea5708b2c085512ce1724cf19eab59e79bc78c6) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8e8b21164018eea7caf740234fff33a7ea9c5157) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 05-mei-2023 15:02:30 */ +/* Created On : 12-mei-2023 15:15:12 */ /* 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: Automatic = 1, Manual = 2 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 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: Automatic = 1, Manual = 2 + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 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 -rd6d9201c17fc7f8479c86722c8f9cd1b3b68f18b -r8e8b21164018eea7caf740234fff33a7ea9c5157 Binary files differ