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
Thursday 07 Sep 2017
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.
Tuesday 27 Jun 2017
3:36 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -64
    • +250
    ./DatabaseStructure.sql
  2. … 21 more files in changeset.
Friday 16 Jun 2017
4:34 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -2
    • +1
    ./DatabaseStructure.sql
  2. … 9 more files in changeset.
Wednesday 07 Jun 2017
11:39 am

Robert Tangerman <robert.tangerman@deltares.nl>

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

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

Robert Tangerman <robert.tangerman@deltares.nl>

Renamed database table. Related to Issue [WTI-1266]

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

Former-commit-id: 27b0aef4f7c260cb90fbcb1066d4539ef7bc070e

Former-commit-id: ae35982f665e7dd2ab5a331a86a1404eeeb52778

Options
    • -4
    • +4
    ./DatabaseStructure.sql
  2. … 20 more files in changeset.
Monday 29 May 2017
11:07 am

Marten Janssen <marten.janssen@deltares.nl>

Review related changes - Set *StructureEntity* to be Id and Name *NOT NULL* - Removed redundant {{SELECT}} query on the database - Renamed stabilityPointStructuresSourcePath to sourcePath - Added similar tests for Closing and Height structures Related to Issue [WTI-1183]

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

Former-commit-id: 840340cfff90a1604726e0165b957577676067cc

Former-commit-id: d779f6997c09b4106d287e9ba9178240d9159892

Options
    • -7
    • +7
    ./DatabaseStructure.sql
  2. … 8 more files in changeset.
Wednesday 24 May 2017
10:00 am

Dennis Tang <dennis.tang@deltares.nl>

Add location of last selected stability point structures file: - Updated Database: -- Added uniqueness constraint to prevent non-unique items in the StabilityPointStructureCollection -- Added StabilityPointStructureCollectionSourcePath to store the sourcepath -- Updated documentation Related to Issue [WTI-1183]

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

Former-commit-id: 5a3fea67496e2a50cd99e70b6df25e2fb11858ed

Former-commit-id: e270e8b7a5a567f6e9468e793539a092d2208cd3

Options
    • -2
    • +4
    ./DatabaseStructure.sql
  2. … 6 more files in changeset.
Friday 05 May 2017
10:01 am

Joël van den Berg

Updated database structure for the uniqueness of height structure id's (in a failure mechanism) and the source path of the height structures. Related to Issue [WTI-1177]

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

Former-commit-id: f80af8ecb3d75a6690af6e417544b0a38c719477

Former-commit-id: 9b55851fd0aa8baca27c85094a13de1173673857

Options
    • -2
    • +4
    ./DatabaseStructure.sql
  2. … 7 more files in changeset.
Thursday 04 May 2017
1:23 pm

Marten Janssen <marten.janssen@deltares.nl>

Ensured uniqueness of FailureMechanismEntityId and Id in HeightStructureEntity Related to Issue [WTI-1171]

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

Former-commit-id: ebeaacbf72ef7c227a1416cc9398326a2f7a6740

Former-commit-id: 1ab5f780cc2b9c84b1b41401cfbbe35eb30a8e3d

Options
    • -2
    • +3
    ./DatabaseStructure.sql
  2. … 2 more files in changeset.
Tuesday 02 May 2017
1:47 pm

Dennis Tang <dennis.tang@deltares.nl>

Add persistent storage for the file location of "VoorlandProfiel" : - Corrected inconsistent column names in the database: XSourcePath --> XCollectionSourcepath for the surfacelines and stochastic soil models in Piping -- Corrected affected tests - Corrected inconsistent naming of the primary key column in the table of StabilityPointStructuresFailureMechanismMetaEntity -- Corrected affected tests - Added MetaEntities for the failure mechanisms WaveImpactAsphaltCover and StabilityStoneCover - Updated project file Ringtoets 17.2.rtd

Related to Issue [WTI-1112]

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

Former-commit-id: 06a39b1bcf6dbc7deb6b9574239c2748e553d905

Former-commit-id: 2524a81e6f9b299264ce453646304eed557fe475

Options
    • -80
    • +117
    ./DatabaseStructure.sql
  2. … 23 more files in changeset.
8:04 am

Marten Janssen <marten.janssen@deltares.nl>

Updated database structure to be able to store Height Structure source path Related to Issue [WTI-1171]

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

Former-commit-id: c00784fd15cd4832e1cb7174c210dc900bcacb5c

Former-commit-id: 2ea9760df4935174b572288f17399073635fac55

Options
    • -1
    • +2
    ./DatabaseStructure.sql
  2. … 7 more files in changeset.
Thursday 13 Apr 2017
10:36 am

Joël van den Berg

Changed type of the Permeability and D70 for piping from Stochasts with Standard Deviation to Stochasts with Coefficient of Variation. Updated test data where required. Performed cleanup over some files Related to Issue [WTI-1238]

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

Former-commit-id: 3a76d5669162ce88fb78512a671fee1b6582a885

Former-commit-id: e5f3f1d2a3a720bb9515c25d788ddf4f0206f73d

Options
    • -3
    • +3
    ./DatabaseStructure.sql
  2. … 48 more files in changeset.
Wednesday 12 Apr 2017
3:34 pm

Dennis Tang <dennis.tang@deltares.nl>

Merged all revision(s) from branches/UpdateDikeProfilesFeature

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

Former-commit-id: 5f84130acb4bd2113b949015b4049e0c0b5795c4

Former-commit-id: 86ce2960f4b2cd6be35b62d7b6608749e29f1022

Options
    • -2
    • +4
    ./DatabaseStructure.sql
  2. … 147 more files in changeset.