DatabaseStructure.sql

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Regenerated context files related to the Ringtoets project files: - Regenerated with digit suffixes instead of written out digits

WTI-1579

    • -2553
    • +2553
    ./DatabaseStructure.sql
  1. … 7 more files in changeset.
Adapt N parameter in stability point structures failure mechanism to be a double on the data model and storage WTI-1531

  1. … 16 more files in changeset.
Add N parameter to the grass cover erosion inwards, outwards and height structures failuremechanism database entities WTI-1531

  1. … 23 more files in changeset.
Resolved by: - temporarily discarding their changes when concerning a binary file - .sql files were merged accordingly

Merge branch 'master' into 1579

# Conflicts:

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql

# Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx

# Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram

# Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

  1. … 5 more files in changeset.
Add N parameter to the database for the stability stone cover failure mechanism WTI-1531

  1. … 21 more files in changeset.
Updated database design: - Added updated .sql database structure scripts to the solution - Generated new context objects

WTI-1579

  1. … 10 more files in changeset.
Added 3 properties related to zoning to the database design: - Updated empty 17.2 file

Note: some tests will fail, because 17.2 database structure was not updated yet. This is done in a subsequent merge action from the release branch.

Related to Issue [WTI-1469]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12926 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: e782c72e944e62b1668e0a4d649a0bd39389960b

Former-commit-id: 80f90ca2deb565ebf66f9a3df0bd346176b08db7

  1. … 6 more files in changeset.
Merged revision(s) 12858-12859, 12861, 12864, 12867, 12870-12873, 12877, 12881, 12883, 12885, 12888-12893 from branches/Release/17_2_Development

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/Release/17_2@12917 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: b171c3f8193be7784084a70966d2080f7c5a0cb5

Former-commit-id: e8596e3fab5614b7b8197409f84380503cbbd5e0

  1. … 88 more files in changeset.
Updated database design to add zone boundaries type for macro stability inwards. Related to Issue [WTI-1469]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/Release/17_2_Development@12872 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 28db99aedc22a3b402509af308a0738ebd3bac37

Former-commit-id: b47822ddb55ac1c62440598e65996376f716cae7

  1. … 5 more files in changeset.
Updated database design to add zone boundaries for macro stability inwards. Related to Issue [WTI-1469]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/Release/17_2_Development@12867 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 1468b7ff1bbb34dcf79ead04d86d5b4a410cf93a

Former-commit-id: 2413ff4f3a4dcfc26cea23ab1666e1049a88ab00

  1. … 5 more files in changeset.
Merged revision(s) from branches/1444

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12811 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: cf752322c5967ec6824f11c711b243f30bf67f0e

Former-commit-id: 9753484fe13d42b8eb5a3c526c4d37f40ca70446

  1. … 245 more files in changeset.
Merged revision(s) 12660 from trunk: Update data model to allow for null values for soil layer colors. A NULL Color translates to Color.Empty, before both Color.Empty and a color with values (0;0;0;0) were both stored as 0 (Empty should be displayed as white, (0;0;0;0) as fully transparent black)

........

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/1444@12700 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: e456a20057277be562177b52dada7b0655fe65a1

Former-commit-id: 96174e36bb23fe8ef47ea1824d9667c9cba0bdb8

  1. … 7 more files in changeset.
Update data model to allow for null values for soil layer colors. A NULL Color translates to Color.Empty, before both Color.Empty and a color with values (0;0;0;0) were both stored as 0 (Empty should be displayed as white, (0;0;0;0) as fully transparent black) Related to Issue [WTI-1298]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12660 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: b513037bae8a5683ad007ab66164741d2efd5fab

Former-commit-id: 4b61dd2b15f07a22245de42732e1e8fe591a9add

  1. … 21 more files in changeset.
Updated database design for preprocessor. Related to Issue [WTI-1477]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/1444@12630 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: a9f3102a48f096d752bf26240b343806a8a53c65

Former-commit-id: e1bb793559785375c920dfc9632624a879b4378c

  1. … 8 more files in changeset.
Made MacroStabilityInwardsSoilLayerTwoDEntity.Color not NULL Related to Issue [WTI-1451]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12475 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 31830864433b88af11dc4588a7bd11ce3e9f84a1

Former-commit-id: 25e3ef0e31b67336511b139aaf17f61718444b02

  1. … 5 more files in changeset.
- Created an intermediate table for the relation between MacroStabilityInwardsSoilLayerTwoDEntity and MacroStabilityInwardsSoilProfileTwoDEntity. - Extended MacroStabilityInwardsSoilLayerTwoDEntity with a self reference. This is intended for the nested layers Related to Issue [WTI-1451]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12390 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 5240691c06b921bb614015c40fbcbac27ed0cf65

Former-commit-id: b27a4656de02fd2fc81d9757c4ae9788acf147d5

  1. … 9 more files in changeset.
Removed MacroStabilityInwardsSoilLayer2D.Holes from the database Related to Issue [WTI-1451]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12387 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8f30fd927afd13372df981e85304deb3b30a93fd

Former-commit-id: 7145a25add623fd0bd2f1d95f34933563cce7f4d

  1. … 12 more files in changeset.
- Removed TrafficLoadInside and TrafficLoadOutside from our data model. - - Only the CharacteristicPointsCsvReader in Ringtoets.Common.IO.SurfaceLines has knowledge of the existence of these traffic load properties Related to Issue [WTI-1443]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12258 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 81160300b03498fde6c5dd16d23a54992961ea78

Former-commit-id: 18cd599b8704c1b45334953e1fbe944524939564

  1. … 33 more files in changeset.
Updated database: - Renamed column DikeSoilScenarioType to DikeSoilScenario -- DikeSoilScenario does not really represent a type and scenario already indicates there are different kinds of options, hence the property was not renamed in the input class

Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12207 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 1888ef4a07dabd5f8178255499f19e63f9f06385

Former-commit-id: 60c4800f4e414da42a68e707a1b6dc8ea30375de

  1. … 9 more files in changeset.
Corrected implementation to improve coverage: - Removed unused columns in the MacroStabilityInwardsCalculationEntity => these are being split in the LocationInputExtreme and -Daily respectively

Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12157 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 2119baaa5c741498b5af4ac3c9b40d3e1cc36939

Former-commit-id: d36bf05606a1b18bcca0a611a0c41ebd72b7e7d4

  1. … 5 more files in changeset.
- Removed obsolete columns for the output entity: -- GridAutomaticallyCalculated -- ForbiddenZonesAutomaticallyCalculated - Renamed TangentLinesXml to SlipPlaneTangentLinesXml to indicate it belongs to a slipplane - Cleaned up test Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12110 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8820f65107597f06dc52f25ff51b5faa9b7de68e

Former-commit-id: 2659f888f976aff2e2757017d09468b89a5cc3a7

  1. … 6 more files in changeset.
Added TangentLineNumber column to the calculation table for macro stability inwards Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12102 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: a4d96dac162a5674e50efb16128178381fa31a81

Former-commit-id: 0f951701a6cab45f52b31fa8477d4f0d81333783

  1. … 5 more files in changeset.
Added read and create extensions: - Done for the semi probabilistic output - Renamed column name for the factor of stability -- Updated database, entities and sql files - Synchronised implementations of piping with MacroStabilityInwards => when NULL arguments are passed, ArgumentNullException thrown Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12097 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 74daeaea7a3522e36dc91931346a65599610abdc

Former-commit-id: ee9127a39b16e5ca0897c8f87bc54ca442c107b0

  1. … 15 more files in changeset.
Added factor of stability for the semi probabilistic output Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12093 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 42f9b351027b5c2407bc50c1f68d7e38173b91af

Former-commit-id: b344d467570e985fc4db1efe1108918a5f8ef42c

  1. … 5 more files in changeset.
Updated database design to enable NaN values for the stochastic distribution properties of preconsolidation stresses: - Updated Create and Read extensions - Regenerated affected entities

Related to Issue [WTI-1341]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12091 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 941b6380ef22f6ecbc2ad888f86259ac97d1f131

Former-commit-id: 7b36beb1a8a2b33c953ede3bcec0ba3a0511ef68

  1. … 9 more files in changeset.
Added entities for storing macrostability calculations and output Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12089 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: a1a79229c9eb111d274c713bc64872f668ca417a

Former-commit-id: 91ddd35549632b924df218099ba154f42c485a23

  1. … 12 more files in changeset.
Removed MacroStabilityInwardsSectionResultEntity.LayerTwoA from database Refactored MacroStabilityInwardsSectionResultEntityReadExtensionsTest.cs Removed redundant cast to RoundedDouble, since the MacroStabilityInwardsFailureMechanismSectionResult.AssessmentLayerThree is a double Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11944 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 0b5b77b702e87bae619860a184111114b2996ef9

Former-commit-id: 5685148d8e3970f65ae9b63fc7001e92ac975e1c

  1. … 8 more files in changeset.
Changed order of MacroStabilityInwardsCharacteristicPointType Added XMLdoc for methods where exceptions can be thrown Introduced MacroStabilityInwardsSoilLayer2DTestFactory Split tests Added typeof asserts for test factories tests to ensure no derived class is returned Related to Issue [WTI-1378]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11795 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 4d58850fe95d97a907f357520f8e9338bc147cf8

Former-commit-id: 5fba5fe8edbc57fed83a0daecc88bb8ca7167783

  1. … 17 more files in changeset.
Grouped BelowPhreaticLevel properties in PipingSoilLayerEntity Updated XMLdoc Updated legacy code to newer standards Reverted any changes on Empty valid Release 17.1.rtd

Related to Issue [WTI-1378]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11782 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 0e39134125c1ede94ce32c4db48ca9c8323eff45

Former-commit-id: cd332c0cbb0f37aee26c89e3704b166a312ef342

  1. … 10 more files in changeset.
Renamed PipingCalculationEntity.StochasticSoilProfileEntityId to PipingCalculationEntity.PipingStochasticSoilProfileEntityId Changed enum note of MacroStabilityInwardsSoilLayer*DEntity.ShearStrengthModel Set XML properties to NOT NULL Removed SectionLength form storage Updated format of database triggers Added NULL check for PipingSoilLayerCreateExtensions Refactored static call to TestHelper.SolutionRoot to a method that is called while running the test Related to Issue [WTI-1378]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11781 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: ffc212f543edb5fe3e4647c5f87ebed29cbce0dc

Former-commit-id: 31f4b4630ce9bdade4eedf7b1adf7488748df9d9

  1. … 19 more files in changeset.