Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql =================================================================== diff -u -r6dce1253e4bce745b1f158fec8cf0264bee650df -r73dab689d69a691763c42186ea4f3d89e2f8d5b4 --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 6dce1253e4bce745b1f158fec8cf0264bee650df) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 73dab689d69a691763c42186ea4f3d89e2f8d5b4) @@ -1426,8 +1426,8 @@ ) USING (DuneErosionFailureMechanismMetaEntityId); -- Migrate the dune location outputs -INSERT INTO DuneLocationOutputEntity ( - [DuneLocationOutputEntityId], +INSERT INTO DuneLocationCalculationOutputEntity ( + [DuneLocationCalculationOutputEntityId], [DuneLocationCalculationEntityId], [WaterLevel], [WaveHeight], Index: Application/Ringtoets/test/Application.Ringtoets.Migration.Core.Test/test-data/MigrationTestProject181.rtd =================================================================== diff -u -r3625160ddb993ed77a484529349aad7983479e5f -r73dab689d69a691763c42186ea4f3d89e2f8d5b4 Binary files differ Index: Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs =================================================================== diff -u -r6dce1253e4bce745b1f158fec8cf0264bee650df -r73dab689d69a691763c42186ea4f3d89e2f8d5b4 --- Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 6dce1253e4bce745b1f158fec8cf0264bee650df) +++ Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 73dab689d69a691763c42186ea4f3d89e2f8d5b4) @@ -147,7 +147,6 @@ "DuneErosionFailureMechanismMetaEntity", "DuneErosionSectionResultEntity", "DuneLocationEntity", - "DuneLocationOutputEntity", "FailureMechanismEntity", "FailureMechanismSectionEntity", "FaultTreeIllustrationPointEntity", @@ -2015,7 +2014,7 @@ { return "SELECT COUNT() = 0 " + GetDuneLocationCalculationsQuery(calculationType) + - "JOIN DuneLocationOutputEntity USING(DuneLocationCalculationEntityId);"; + "JOIN DuneLocationCalculationOutputEntity USING(DuneLocationCalculationEntityId);"; } /// @@ -2040,8 +2039,8 @@ $"WHERE NormativeNormType = {(int)normType} " + ") " + GetDuneLocationCalculationsQuery(ConvertToCalculationType(normType)) + - "JOIN DuneLocationOutputEntity NEW USING(DuneLocationCalculationEntityId) " + - "JOIN [SOURCEPROJECT].DuneLocationOutputEntity OLD USING(DuneLocationOutputEntityId) " + + "JOIN DuneLocationCalculationOutputEntity NEW USING(DuneLocationCalculationEntityId) " + + "JOIN [SOURCEPROJECT].DuneLocationOutputEntity OLD ON OLD.DuneLocationOutputEntityId = NEW.DuneLocationCalculationOutputEntityId " + "WHERE NEW.WaterLevel IS OLD.WaterLevel " + "AND NEW.WaveHeight IS OLD.WaveHeight " + "AND NEW.WavePeriod IS OLD.WavePeriod " +