DatabaseStructure.sql

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Renamed NormativeNorm to NormativeNormType Related to Issue [WTI-1364]

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

Former-commit-id: 648ab2a9ae6b3c9a7e3ffb8dc5e02de9ece81c11

Former-commit-id: cd4dc0cbb7ea8f26e048512d8e3978eb7d991fb7

  1. … 12 more files in changeset.
Removed MacroStabilityInwardsFailureMechanismMetaEntity parameter B from database Related to Issue [WTI-1378]

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

Former-commit-id: 4af883cff3b3d99a9f9b2d38a3577097c2d21cd3

Former-commit-id: 3b048029a680f81bd24f08072fcb8d7b6cf43ebf

  1. … 6 more files in changeset.
Added trigger for MacroStabilityInwardsStochasticSoilProfileEntity such that it can be guaranteed that either Added Order property for MacroStabilityInwardsPreconsolidationStressEntity Related to Issue [WTI-1378]

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

Former-commit-id: 75a9b442c22f2c41b19341c2cc8a31b8f352d538

Former-commit-id: ea4ac59ed20f71ea2dc23118883f19e5d03b91e0

  1. … 10 more files in changeset.
Changed database table names to no longer contain a numeric value, so that Entity Framework is able to prularize it. Related to Issue [WTI-1378]

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

Former-commit-id: c10c99fdfeabe77617f31bb071f08cd0ce301bcd

Former-commit-id: ad10811df4ea76bb497712d24add740a15b2546e

  1. … 54 more files in changeset.
- Updated property names - Created MacroStabilityInwardsSoilLayer1DCreateExtensions - Updated PipingSoilLayerCreateExtensions Related to Issue [WTI-1378]

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

Former-commit-id: c1666baf3b502ff456deb41f39aa9795b6e716ef

Former-commit-id: 0a95832cf4992a61bb736ea6361decc2d03c45e5

  1. … 13 more files in changeset.
Updated property names Related to Issue [WTI-1378]

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

Former-commit-id: 209f639e6c361939c40aea3e9caf835c752eaaf5

Former-commit-id: 857e1cedd4e7638fe4286a99b9ee26712cf9b2ef

  1. … 7 more files in changeset.
Added MacroStabilityInwards tables Related to Issue [WTI-1378]

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

Former-commit-id: 1aba6bdff419b5a53477041d4b2d0ea296cfb890

Former-commit-id: f178c56ee4e1d0d8329645c0953cfb9e09f2b2c6

  1. … 16 more files in changeset.
- Cleaned up storage classes - Updated XMLdocs - Removed unused references - prefixed Piping specific tables with "Piping" - - Renamed classes accordingly Related to Issue [WTI-1378]

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

Former-commit-id: 3d9e5d4d5719b5cc1c65322e9979fe82d9455d5c

Former-commit-id: 849fa061b4cbc4f128046b60ce800aa9bc8f4521

  1. … 68 more files in changeset.
Updated database design to make traject id NOT NULL Introduced temp table with signaling and lower limit norm to use later on Related to Issue [WTI-1364]

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

Former-commit-id: f1b560ae8eba928e9f0cd3033549632342469e4b

Former-commit-id: 5da0fefac7ed2d2da293bb66d97b15e9e61425a4

  1. … 3 more files in changeset.
Updated database design to store both Signaling and LowerLimit Norm Related to Issue [WTI-1364]

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

Former-commit-id: 16d9a5df0c1888856fb9c27197cc114d2e753eec

Former-commit-id: 1d602d2a75cf42648bfc09e77e8844874db64ff1

  1. … 11 more files in changeset.
Initialized MechanismSurfaceLineBase.Name from constructor and added check for Null Related to Issue [WTI-1343]

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

Former-commit-id: 2e9213487250cbc814b3b91307890cf7b5979f23

Former-commit-id: 1af404f013ac6e0a765c468b3c13ec22aa80a186

  1. … 99 more files in changeset.
Set SoilProfileEntity.Name to be not null Related to Issue [WTI-1343]

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

Former-commit-id: e97e925d1e5f2d25d11f65496dbb566aca98356a

Former-commit-id: c9392fd939ffe39f33d1a7c8f8eba64ae146bdac

  1. … 3 more files in changeset.
Moved 'Type' from StochasticSoilProfileEntity to 'SourceType' SoilProfileEntity in database Ran Cleanup for storage Related to Issue [WTI-1343]

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

Former-commit-id: 5390416ecba199da438854b0481ab20184862a17

Former-commit-id: 2102fe55684e8b3215a87aa15960a2dd62b27852

  1. … 17 more files in changeset.
Updated database design to store the general results for all the grass cover erosion inwards calculation outputs - Fixed failing tests: -- Restored accidentally removed columns in the DatabaseStructure.sql Related to Issue [WTI-1319]

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

Former-commit-id: f58d35ca21b41410200daa3045db0b4f7cd4f15b

Former-commit-id: c3002057971a05c28cee11ece4265e6b9496dcce

Updated database design to store the general results for all the grass cover erosion inwards calculation outputs - Updated Migration script: -- Row value for calculating the illustration points is per default FALSE -- Row value for the general result entity of the grass output is per default NULL Related to Issue [WTI-1319]

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

Former-commit-id: a6e32f96b906b4b64510c63345178cd50eafc2be

Former-commit-id: 4479e2a1d1daeae1b11d7c1a71f5930cf1a3eaab

    • -1208
    • +1099
    ./DatabaseStructure.sql
  1. … 19 more files in changeset.
Incorporated comments review 2000 - Removed superfluous GeneralResult assertions - Added missing assertions - Renamed variables and fixed typos

Paired with ~janssen

Related to Issue [WTI-1309]

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

Former-commit-id: 66ce181cb0df03c034bbe0d0b71960ce91f8f964

Former-commit-id: 99935a220f1560d9d3aa04f6aad2269d90f96065

  1. … 11 more files in changeset.
- Updated 'True/false' indicators in DatabaseDesign.eap - Formatted DatabaseStructure.sql to use tabs instead of spaces - Formatted Migration_17.1_17.2.sql to use tabs instead of spaces Related to Issue [WTI-1309]

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

Former-commit-id: e40073342b4fe78e16730f3208b96c508097e18d

Former-commit-id: 4dc1221ed9f91fdd176934e8ebf3915698ae8ac7

    • -1082
    • +1238
    ./DatabaseStructure.sql
  1. … 3 more files in changeset.
- Updated database structure to allow illustration points checkbox to be saved for closing, height, and stability point structures - cleaned up SQL scripts for triggers Related to Issue [WTI-1309]

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

Former-commit-id: 8ad836dabcae087b9fe2f6795744585b25cfe61a

Former-commit-id: 3ff9f166b319dedf175816064d437a1ca6048694

  1. … 8 more files in changeset.
Updated database structure to allow illustration points to be saved for closing, height, and stability point structures Related to Issue [WTI-1309]

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

Former-commit-id: be8c916f68ddeb29afdb2bb13805fcafea3d3e66

Former-commit-id: 160e78924ef4560ed5b7f4b86ce0eb9b6e0c3319

  1. … 16 more files in changeset.
Updated database items: - Renamed ShouldWaterLevelIllustrationPointsBeCalculated to ShouldDesignWaterLevelIllustrationPointsBeCalculated for consistency - Migration script updated Related to Issue [WTI-1305]

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

Former-commit-id: dfd8709b8f04316ff5f4d057765601383e8fc9e1

Former-commit-id: ecbc3f3561b1fcafc99e54520552bbec7f1c70d6

  1. … 15 more files in changeset.
Updated database items: - Removed obsolete column Beta from the TopLevelSubMechanismIllustrationPoint: beta is stored in the children - Updated all string based properties: the database entity property should have an AreEqualButNotSame assert and implementation

Related to Issue [WTI-1305]

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

Former-commit-id: 8006b700370e30dd3a5e2569de77172fe7c27366

Former-commit-id: 1e9b3abb2f1dd84dc47b0e5452b5514459bd582a

  1. … 9 more files in changeset.
Renamed Submechanism<X> to SubMechanism<X> for the illustration points: - Initial commit - Performed on the RT side only - Updated database and migration scripts with the updated names

Related to Issue [WTI-1305]

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

Former-commit-id: b4e245c45841961f67a8e6a215a8ddc0108b06d0

Former-commit-id: 9551680e9783a3e8a70dd77616fb14872b7ebcde

  1. … 90 more files in changeset.
Updated database design: - Incorporated new proposed design for the HBL: -- Removed obsolete functions, interfaces and partial classes - Adjusted migration script --> HBL output entities contain 10 instead of 9 columns, 10 column is filled with a NULL value as it is a FK referring to a general result. This result is not available in prior versions - Made final adjustments in the .eap file

Related to Issue [WTI-1305]

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

Former-commit-id: a3794269143bbcedac08b328c29405ee9381d62f

Former-commit-id: 71d06472bab4af5854e1bba0119db7a626652c83

  1. … 52 more files in changeset.
Updated database design: - GrassCoverErosionOutwardsHydraulicLocationGeneralResultEntityId NOT NULL - HydraulicLocationWindDirectionClosingSituationIllustrationPointEntityId.Name --> IllustrationPointName - GrassCoverErosionOutwardsHydraulicLocationWindDirectionClosingSituationIllustrationPointEntity.Name --> IllustrationPointName Related to Issue [WTI-1305]

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

Former-commit-id: 3da96a93828cb50dae0e84cf2fa10f8ebd52b5fb

Former-commit-id: e8ce056c878fd3818e395ffda68c998aafe254b6

  1. … 11 more files in changeset.
Updated DatabaseDesign: - Added Order property for tables that represent items in a list

Related to Issue [WTI-1305]

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

Former-commit-id: 2efddb53739e7e899f2e123701991e12f09ffae9

Former-commit-id: 467bb1ef02a72497007b67c646f1bec786f0672d

  1. … 13 more files in changeset.
Updated DatabaseDesign: - Generated SQL file - Updated migration script Related to Issue [WTI-1305]

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

Former-commit-id: 4c47ec5f0a8173acea93e1c9d7b684fb3b1a2b22

Former-commit-id: 1f3fb774a5674842b27dfd9e20cce583eefce32f

  1. … 21 more files in changeset.
Removed the SegmentName from the database for piping: - Updated migration script to provide the correct data - Updated the RTD file - Updated documentation Related to Issue [WTI-1285]

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

Former-commit-id: 5384406e34cbb3cfd7f2181aa46e414ea2af7950

Former-commit-id: 45d55e1a1c1b70d793a12ddf8ea82921516fedb9

  1. … 9 more files in changeset.
Renamed database columns and keys.

Related to Issue [WTI-1266]

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

Former-commit-id: 38c4104b226a70a4180c320f5c585d642641a785

Former-commit-id: d08029f20d4f5b3a9bea596655729f09bea949c6

  1. … 6 more files in changeset.