Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql =================================================================== diff -u -r9b1054e6de58690d04ccbcb430295b337b56dcfc -r57551b0c385bb67f7b8baa69a483cf3a27f62ea2 --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 9b1054e6de58690d04ccbcb430295b337b56dcfc) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 57551b0c385bb67f7b8baa69a483cf3a27f62ea2) @@ -283,10 +283,20 @@ SELECT [MacroStabilityInwardsSectionResultEntityId], [FailureMechanismSectionEntityId], + CASE + WHEN [LayerOne] = 3 + THEN 4 + ELSE + [LayerOne] + END, 1, - 1, - 1, - NULL, + CASE + WHEN [LayerThree] IS NOT NULL + THEN 3 + ELSE + 1 + END, + [LayerThree], 0, NULL FROM [SOURCEPROJECT].MacroStabilityInwardsSectionResultEntity; @@ -350,10 +360,20 @@ SELECT [PipingSectionResultEntityId], [FailureMechanismSectionEntityId], + CASE + WHEN [LayerOne] = 3 + THEN 4 + ELSE + [LayerOne] + END, 1, - 1, - 1, - NULL, + CASE + WHEN [LayerThree] IS NOT NULL + THEN 3 + ELSE + 1 + END, + [LayerThree], 0, NULL FROM [SOURCEPROJECT].PipingSectionResultEntity;