Riskeer / build

DatabaseStructure.sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 26 Nov
Commits this week: 0

Lines of code count not available

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated a few seconds ago
All Commits Reviews
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 10 Oct 2017
3:37 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -18
    • +177
    ./DatabaseStructure.sql
  2. … 12 more files in changeset.
Thursday 28 Sep 2017
3:31 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -2
    • +1
    ./DatabaseStructure.sql
  2. … 8 more files in changeset.
Thursday 21 Sep 2017
12:13 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -2
    • +2
    ./DatabaseStructure.sql
  2. … 17 more files in changeset.
Wednesday 20 Sep 2017
11:05 am

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -2
    • +2
    ./DatabaseStructure.sql
  2. … 10 more files in changeset.
10:45 am

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -19
    • +22
    ./DatabaseStructure.sql
  2. … 19 more files in changeset.
Friday 15 Sep 2017
11:35 am

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -3
    • +3
    ./DatabaseStructure.sql
  2. … 12 more files in changeset.
Thursday 14 Sep 2017
12:58 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -2
    • +1
    ./DatabaseStructure.sql
  2. … 6 more files in changeset.
Wednesday 13 Sep 2017
2:20 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -1
    • +33
    ./DatabaseStructure.sql
  2. … 10 more files in changeset.
12:02 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -86
    • +103
    ./DatabaseStructure.sql
  2. … 54 more files in changeset.
Monday 11 Sep 2017
11:09 am

Marten Janssen <marten.janssen@deltares.nl>

- 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

Options
    • -3
    • +3
    ./DatabaseStructure.sql
  2. … 13 more files in changeset.
10:16 am

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -13
    • +13
    ./DatabaseStructure.sql
  2. … 7 more files in changeset.
Thursday 07 Sep 2017
3:37 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -122
    • +278
    ./DatabaseStructure.sql
  2. … 16 more files in changeset.
2:05 pm

Marten Janssen <marten.janssen@deltares.nl>

- 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

Options
    • -24
    • +24
    ./DatabaseStructure.sql
  2. … 68 more files in changeset.
Friday 01 Sep 2017
5:54 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -1
    • +1
    ./DatabaseStructure.sql
  2. … 3 more files in changeset.
4:41 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -2
    • +4
    ./DatabaseStructure.sql
  2. … 11 more files in changeset.
Thursday 17 Aug 2017
3:18 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -2
    • +2
    ./DatabaseStructure.sql
  2. … 99 more files in changeset.
11:45 am

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -2
    • +2
    ./DatabaseStructure.sql
  2. … 3 more files in changeset.
Wednesday 16 Aug 2017
8:34 am

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -3
    • +3
    ./DatabaseStructure.sql
  2. … 17 more files in changeset.
Monday 07 Aug 2017
1:53 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1
    • +9
    ./DatabaseStructure.sql
1:14 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1208
    • +1099
    ./DatabaseStructure.sql
  2. … 19 more files in changeset.
Friday 04 Aug 2017
4:03 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1
    • +1
    ./DatabaseStructure.sql
  2. … 11 more files in changeset.
Tuesday 01 Aug 2017
2:20 pm

Marten Janssen <marten.janssen@deltares.nl>

- 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

Options
    • -1082
    • +1238
    ./DatabaseStructure.sql
  2. … 3 more files in changeset.
Thursday 13 Jul 2017
3:42 pm

Marten Janssen <marten.janssen@deltares.nl>

- 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

Options
    • -30
    • +71
    ./DatabaseStructure.sql
  2. … 8 more files in changeset.
2:49 pm

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -53
    • +219
    ./DatabaseStructure.sql
  2. … 16 more files in changeset.
Wednesday 05 Jul 2017
11:51 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -3
    • +3
    ./DatabaseStructure.sql
  2. … 15 more files in changeset.
Monday 03 Jul 2017
5:43 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -2
    • +1
    ./DatabaseStructure.sql
  2. … 9 more files in changeset.
3:23 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -60
    • +60
    ./DatabaseStructure.sql
  2. … 90 more files in changeset.
Friday 30 Jun 2017
4:11 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -181
    • +164
    ./DatabaseStructure.sql
  2. … 52 more files in changeset.
Wednesday 28 Jun 2017
11:50 am

Marten Janssen <marten.janssen@deltares.nl>

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

Options
    • -4
    • +4
    ./DatabaseStructure.sql
  2. … 11 more files in changeset.
9:07 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1
    • +9
    ./DatabaseStructure.sql
  2. … 13 more files in changeset.