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
Friday 30 Mar 2018
8:42 am

Dennis Tang <dennis.tang@deltares.nl>

Adjusted database design for the proposed solution: - Removed obsolete failure mechanism specific hydraulic boundary location tables. -- Regenerated database entities

WTI-1657

Options
    • -119
    • +57
    ./DatabaseStructure.sql
  2. … 10 more files in changeset.
Thursday 29 Mar 2018
4:06 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted database design for the proposed solution: - Regenerated database entities

WTI-1657

Options
    • -10
    • +69
    ./DatabaseStructure.sql
  2. … 5 more files in changeset.
Wednesday 28 Mar 2018
12:01 pm

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Removed constraint on the combination of FKs of calculation collections (constraint was not present in the previous implementation)

WTI-1656

Options
    • -2
    • +1
    ./DatabaseStructure.sql
  2. … 5 more files in changeset.
Thursday 22 Mar 2018
11:38 am

Dennis Tang <dennis.tang@deltares.nl>

Finalized database design: - Added comments to indicate which FK represents which type of calculation - Adjusted read and create extensions on the assessment section to maintain consistency with the comments

WTI-1656

Options
    • -9
    • +9
    ./DatabaseStructure.sql
  2. … 6 more files in changeset.
8:41 am

Dennis Tang <dennis.tang@deltares.nl>

Cleaned up database related files: - Removed trigger from association table between the calculation collection and the calculation - Renamed names of foreign key according to the naming conventions - Added uniqueness constraint for: -- the association table on the calculations -- the uniqueness of the FK entries of the assessment section entity - Removed two obsolete table entities from the .eap file - Updated the .sql file --> added HydraulicBoundaryLocationCalculationCollection entities should be autonumbered - Removed obsolete lines from the edmx.diagram - Added additional load logic for the PartialRingtoetsEntities in order to fully load the project

WTI-1656

Options
    • -31
    • +29
    ./DatabaseStructure.sql
  2. … 8 more files in changeset.
Tuesday 20 Mar 2018
2:42 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted database design: - Regenerated entities

WTI-1656

Options
    • -203
    • +165
    ./DatabaseStructure.sql
  2. … 8 more files in changeset.
Friday 02 Feb 2018
8:30 am

Robert Tangerman <robert.tangerman@deltares.nl>

Removed derived output from storage. WTI-1591

Options
    • -131
    • +67
    ./DatabaseStructure.sql
  2. … 31 more files in changeset.
Tuesday 30 Jan 2018
5:29 pm

Dennis Tang <dennis.tang@deltares.nl>

Added comments for the FKs to indicate which calculations they represent

WTI-1579

Options
    • -9
    • +9
    ./DatabaseStructure.sql
  2. … 2 more files in changeset.
4:40 pm

Carlos Lubbers

Add delta L property to storage WTI-1531

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

Carlos Lubbers

Add delta L property to storage WTI-1531

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

Dennis Tang <dennis.tang@deltares.nl>

Merge branch '1579'

# Conflicts:

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

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql

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

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

# Application/Ringtoets/test/Application.Ringtoets.Migration.Core.Test/test-data/FullTestProject181.rtd

# Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

Options
    • -60
    • +217
    ./DatabaseStructure.sql
  2. … 107 more files in changeset.
8:51 am

Dennis Tang <dennis.tang@deltares.nl>

Updated database design: - Renamed PK of HydraulicLocationOutputEntity to match with the current naming conventions -- Updated migration script and integration test - Updated triggers of the HydraulicLocationEntity to match with the current naming convention and exhibit the correct behaviour

WTI-1579

Options
    • -2786
    • +2786
    ./DatabaseStructure.sql
  2. … 9 more files in changeset.
Monday 29 Jan 2018
1:09 pm

Carlos Lubbers

Adapt storage with the N parameter for the Piping Structure failure mechanism WTI-1531

Options
    • -16
    • +32
    ./DatabaseStructure.sql
  2. … 21 more files in changeset.
Friday 26 Jan 2018
5:00 pm

Carlos Lubbers

Adapt storage to include the macro stability outwards probability assessment input WTI-1531

Options
    • -91
    • +107
    ./DatabaseStructure.sql
  2. … 35 more files in changeset.
1:32 pm

Dennis Tang <dennis.tang@deltares.nl>

Resolved by: - Discarding their changes on binary files - Merging .sql files

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.diagram

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

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

Options
    • -5
    • +5
    ./DatabaseStructure.sql
  2. … 5 more files in changeset.
8:02 am

Dennis Tang <dennis.tang@deltares.nl>

Regenerated context files related to the Ringtoets project files: - Regenerated with digit suffixes instead of written out digits

WTI-1579

Options
    • -2553
    • +2553
    ./DatabaseStructure.sql
  2. … 7 more files in changeset.
Thursday 25 Jan 2018
4:54 pm

Carlos Lubbers

Adapt N parameter in stability point structures failure mechanism to be a double on the data model and storage WTI-1531

Options
    • -2
    • +2
    ./DatabaseStructure.sql
  2. … 16 more files in changeset.
12:59 pm

Carlos Lubbers

Add N parameter to the grass cover erosion inwards, outwards and height structures failuremechanism database entities WTI-1531

Options
    • -4
    • +4
    ./DatabaseStructure.sql
  2. … 23 more files in changeset.
8:06 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1
    • +2
    ./DatabaseStructure.sql
  2. … 5 more files in changeset.
Wednesday 24 Jan 2018
11:46 am

Carlos Lubbers

Add N parameter to the database for the stability stone cover failure mechanism WTI-1531

Options
    • -1
    • +2
    ./DatabaseStructure.sql
  2. … 21 more files in changeset.
Tuesday 23 Jan 2018
4:07 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design: - Added updated .sql database structure scripts to the solution - Generated new context objects

WTI-1579

Options
    • -25
    • +182
    ./DatabaseStructure.sql
  2. … 10 more files in changeset.
Tuesday 21 Nov 2017
11:48 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1
    • +4
    ./DatabaseStructure.sql
  2. … 6 more files in changeset.
Monday 20 Nov 2017
4:37 pm

Elmar Kleijn

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

Options
    • -1
    • +4
    ./DatabaseStructure.sql
  2. … 88 more files in changeset.
Thursday 16 Nov 2017
2:32 pm

Robert Tangerman <robert.tangerman@deltares.nl>

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

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

Robert Tangerman <robert.tangerman@deltares.nl>

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

Options
    • -1
    • +3
    ./DatabaseStructure.sql
  2. … 5 more files in changeset.
Friday 10 Nov 2017
10:39 am

Elmar Kleijn

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

Options
    • -1
    • +18
    ./DatabaseStructure.sql
  2. … 245 more files in changeset.
Tuesday 07 Nov 2017
10:09 am

Carlos Lubbers

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

Options
    • -4
    • +4
    ./DatabaseStructure.sql
  2. … 7 more files in changeset.
Monday 06 Nov 2017
3:48 pm

Carlos Lubbers

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

Options
    • -4
    • +4
    ./DatabaseStructure.sql
  2. … 21 more files in changeset.
Saturday 04 Nov 2017
10:20 pm

Robert Tangerman <robert.tangerman@deltares.nl>

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

Options
    • -1
    • +18
    ./DatabaseStructure.sql
  2. … 8 more files in changeset.
Tuesday 31 Oct 2017
11:05 am

Marten Janssen <marten.janssen@deltares.nl>

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

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