Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/AssessmentSectionEntity.cs =================================================================== diff -u -r3dbf451144dc23d8abe649913baee1a5e544c48c -r0a615fd8fff795947585c1a7388a7cd205b6e57e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/AssessmentSectionEntity.cs (.../AssessmentSectionEntity.cs) (revision 3dbf451144dc23d8abe649913baee1a5e544c48c) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/AssessmentSectionEntity.cs (.../AssessmentSectionEntity.cs) (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -46,6 +46,14 @@ public long AssessmentSectionEntityId { get; set; } public long ProjectEntityId { get; set; } + public long HydraulicLocationCalculationCollectionEntity1Id { get; set; } + public long HydraulicLocationCalculationCollectionEntity2Id { get; set; } + public long HydraulicLocationCalculationCollectionEntity3Id { get; set; } + public long HydraulicLocationCalculationCollectionEntity4Id { get; set; } + public long HydraulicLocationCalculationCollectionEntity5Id { get; set; } + public long HydraulicLocationCalculationCollectionEntity6Id { get; set; } + public long HydraulicLocationCalculationCollectionEntity7Id { get; set; } + public long HydraulicLocationCalculationCollectionEntity8Id { get; set; } public string Id { get; set; } public string Name { get; set; } public string Comments { get; set; } @@ -59,6 +67,14 @@ public int Order { get; set; } public virtual ProjectEntity ProjectEntity { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity1 { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity2 { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity3 { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity4 { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity5 { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity6 { get; set; } + public virtual HydraulicLocationCalculationCollectionEntity HydraulicLocationCalculationCollectionEntity7 { get; set; } [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection BackgroundDataEntities { get; set; } Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationCalculationCollectionEntity.cs =================================================================== diff -u --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationCalculationCollectionEntity.cs (revision 0) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationCalculationCollectionEntity.cs (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -0,0 +1,81 @@ +// Copyright (C) Stichting Deltares 2017. All rights reserved. +// +// This file is part of Ringtoets. +// +// Ringtoets is free software: you can redistribute it and/or modify +// it under the terms of the GNU General Public License as published by +// the Free Software Foundation, either version 3 of the License, or +// (at your option) any later version. +// +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. +// +// You should have received a copy of the GNU General Public License +// along with this program. If not, see . +// +// All names, logos, and references to "Deltares" are registered trademarks of +// Stichting Deltares and remain full property of Stichting Deltares at all times. +// All rights reserved. + +//------------------------------------------------------------------------------ +// +// This code was generated from a template. +// +// Manual changes to this file may cause unexpected behavior in your application. +// Manual changes to this file will be overwritten if the code is regenerated. +// +//------------------------------------------------------------------------------ + +using System.Collections.Generic; +using System.Diagnostics.CodeAnalysis; + +namespace Application.Ringtoets.Storage.DbContext +{ + public class HydraulicLocationCalculationCollectionEntity + { + [SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] + public HydraulicLocationCalculationCollectionEntity() + { + AssessmentSectionEntities = new HashSet(); + AssessmentSectionEntities1 = new HashSet(); + AssessmentSectionEntities2 = new HashSet(); + AssessmentSectionEntities3 = new HashSet(); + AssessmentSectionEntities4 = new HashSet(); + AssessmentSectionEntities5 = new HashSet(); + AssessmentSectionEntities6 = new HashSet(); + AssessmentSectionEntities7 = new HashSet(); + HydraulicLocationCalculationEntities = new HashSet(); + } + + public long HydraulicLocationCalculationCollectionEntityId { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities1 { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities2 { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities3 { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities4 { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities5 { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities6 { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection AssessmentSectionEntities7 { get; set; } + + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection HydraulicLocationCalculationEntities { get; set; } + } +} \ No newline at end of file Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationCalculationEntity.cs =================================================================== diff -u -r33b1979ea5681dcaef595262bbe14e5c274fdfc2 -r0a615fd8fff795947585c1a7388a7cd205b6e57e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationCalculationEntity.cs (.../HydraulicLocationCalculationEntity.cs) (revision 33b1979ea5681dcaef595262bbe14e5c274fdfc2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationCalculationEntity.cs (.../HydraulicLocationCalculationEntity.cs) (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -38,45 +38,20 @@ [SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] public HydraulicLocationCalculationEntity() { - HydraulicLocationEntities = new HashSet(); - HydraulicLocationEntities1 = new HashSet(); - HydraulicLocationEntities2 = new HashSet(); - HydraulicLocationEntities3 = new HashSet(); - HydraulicLocationEntities4 = new HashSet(); - HydraulicLocationEntities5 = new HashSet(); - HydraulicLocationEntities6 = new HashSet(); - HydraulicLocationEntities7 = new HashSet(); HydraulicLocationOutputEntities = new HashSet(); + HydraulicLocationCalculationCollectionEntities = new HashSet(); } public long HydraulicLocationCalculationEntityId { get; set; } public byte ShouldIllustrationPointsBeCalculated { get; set; } + public long HydraulicLocationEntityId { get; set; } - [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities { get; set; } + public virtual HydraulicLocationEntity HydraulicLocationEntity { get; set; } [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities1 { get; set; } + public virtual ICollection HydraulicLocationOutputEntities { get; set; } [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities2 { get; set; } - - [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities3 { get; set; } - - [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities4 { get; set; } - - [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities5 { get; set; } - - [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities6 { get; set; } - - [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationEntities7 { get; set; } - - [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HydraulicLocationOutputEntities { get; set; } + public virtual ICollection HydraulicLocationCalculationCollectionEntities { get; set; } } } \ No newline at end of file Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs =================================================================== diff -u -r3dbf451144dc23d8abe649913baee1a5e544c48c -r0a615fd8fff795947585c1a7388a7cd205b6e57e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs (.../HydraulicLocationEntity.cs) (revision 3dbf451144dc23d8abe649913baee1a5e544c48c) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs (.../HydraulicLocationEntity.cs) (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -41,6 +41,7 @@ ClosingStructuresCalculationEntities = new HashSet(); GrassCoverErosionInwardsCalculationEntities = new HashSet(); HeightStructuresCalculationEntities = new HashSet(); + HydraulicLocationCalculationEntities = new HashSet(); MacroStabilityInwardsCalculationEntities = new HashSet(); PipingCalculationEntities = new HashSet(); StabilityPointStructuresCalculationEntities = new HashSet(); @@ -50,14 +51,6 @@ public long HydraulicLocationEntityId { get; set; } public long AssessmentSectionEntityId { get; set; } - public long HydraulicLocationCalculationEntity1Id { get; set; } - public long HydraulicLocationCalculationEntity2Id { get; set; } - public long HydraulicLocationCalculationEntity3Id { get; set; } - public long HydraulicLocationCalculationEntity4Id { get; set; } - public long HydraulicLocationCalculationEntity5Id { get; set; } - public long HydraulicLocationCalculationEntity6Id { get; set; } - public long HydraulicLocationCalculationEntity7Id { get; set; } - public long HydraulicLocationCalculationEntity8Id { get; set; } public long LocationId { get; set; } public string Name { get; set; } public double? LocationX { get; set; } @@ -75,14 +68,8 @@ [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection HeightStructuresCalculationEntities { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity1 { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity2 { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity3 { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity4 { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity5 { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity6 { get; set; } - public virtual HydraulicLocationCalculationEntity HydraulicLocationCalculationEntity7 { get; set; } + [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection HydraulicLocationCalculationEntities { get; set; } [SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection MacroStabilityInwardsCalculationEntities { get; set; } Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs =================================================================== diff -u -rbca00b0e437aeea92c5ef6fd0947ac64acf359cf -r0a615fd8fff795947585c1a7388a7cd205b6e57e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs (.../RingtoetsEntities.Context.cs) (revision bca00b0e437aeea92c5ef6fd0947ac64acf359cf) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs (.../RingtoetsEntities.Context.cs) (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -76,6 +76,7 @@ public virtual DbSet HeightStructuresOutputEntities { get; set; } public virtual DbSet HeightStructuresSectionResultEntities { get; set; } public virtual DbSet HydraRingPreprocessorEntities { get; set; } + public virtual DbSet HydraulicLocationCalculationCollectionEntities { get; set; } public virtual DbSet HydraulicLocationEntities { get; set; } public virtual DbSet HydraulicLocationOutputEntities { get; set; } public virtual DbSet IllustrationPointResultEntities { get; set; } Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx =================================================================== diff -u -rbca00b0e437aeea92c5ef6fd0947ac64acf359cf -r0a615fd8fff795947585c1a7388a7cd205b6e57e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision bca00b0e437aeea92c5ef6fd0947ac64acf359cf) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -4,13 +4,21 @@ - + + + + + + + + + @@ -623,11 +631,26 @@ + + + + + + + + + + + + + + + @@ -636,14 +659,6 @@ - - - - - - - - @@ -1484,6 +1499,102 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -2264,103 +2375,43 @@ - + - + - - - - - - - - - - + - - - - - - + + + - - + + - - + + - - - + + + - - + + - - + + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + @@ -3221,6 +3272,8 @@ + + @@ -3279,6 +3332,38 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -3539,39 +3624,19 @@ - + - + - - - + + + - - + - - - - - - - - - - - - - - - - - - - - + @@ -3890,6 +3955,7 @@ + @@ -3946,6 +4012,38 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -3958,7 +4056,7 @@ - + @@ -4314,38 +4412,10 @@ - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -4486,6 +4556,10 @@ + + + + @@ -4497,22 +4571,25 @@ - - - - - - - - + + + + + + + + + + + @@ -4525,10 +4602,18 @@ + + + + + + + + - + @@ -5244,37 +5329,37 @@ + + + + + + + + + + + + + + + - - - - - - - - - + - - - - - - - - + @@ -6204,6 +6289,102 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -6240,7 +6421,7 @@ - + @@ -7308,102 +7489,18 @@ - - - + + + - - + + - - + + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -7792,6 +7889,10 @@ + + + + @@ -7805,6 +7906,7 @@ + @@ -7824,6 +7926,14 @@ + + + + + + + + @@ -8436,6 +8546,13 @@ + + + + + + + @@ -8444,14 +8561,6 @@ - - - - - - - - @@ -9354,6 +9463,14 @@ + + + + + + + + Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram =================================================================== diff -u -rbca00b0e437aeea92c5ef6fd0947ac64acf359cf -r0a615fd8fff795947585c1a7388a7cd205b6e57e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision bca00b0e437aeea92c5ef6fd0947ac64acf359cf) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -336,103 +336,112 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + Index: Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd =================================================================== diff -u -rbca00b0e437aeea92c5ef6fd0947ac64acf359cf -r0a615fd8fff795947585c1a7388a7cd205b6e57e Binary files differ Index: build/DatabaseStructure.sql =================================================================== diff -u -rbca00b0e437aeea92c5ef6fd0947ac64acf359cf -r0a615fd8fff795947585c1a7388a7cd205b6e57e --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision bca00b0e437aeea92c5ef6fd0947ac64acf359cf) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 0a615fd8fff795947585c1a7388a7cd205b6e57e) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 01-Feb-2018 15:56:25 */ +/* Created On : 20-Mar-2018 14:36:05 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -21,10 +21,10 @@ DROP TABLE IF EXISTS 'AssessmentSectionEntity' ; -DROP TABLE IF EXISTS 'MacroStabilityOutwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' ; -DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' +DROP TABLE IF EXISTS 'MacroStabilityOutwardsFailureMechanismMetaEntity' ; DROP TABLE IF EXISTS 'FailureMechanismEntity' @@ -51,27 +51,27 @@ DROP TABLE IF EXISTS 'PipingCalculationEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'StabilityPointStructuresFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ; DROP TABLE IF EXISTS 'DuneErosionFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' ; -DROP TABLE IF EXISTS 'PipingSoilLayerEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ; DROP TABLE IF EXISTS 'HeightStructuresFailureMechanismMetaEntity' ; +DROP TABLE IF EXISTS 'PipingSoilLayerEntity' +; + DROP TABLE IF EXISTS 'PipingSoilProfileEntity' ; @@ -300,6 +300,12 @@ DROP TABLE IF EXISTS 'HydraulicLocationCalculationEntity' ; +DROP TABLE IF EXISTS 'HydraulicLocationCalculationCollectionToHydraulicCalculationEntity' +; + +DROP TABLE IF EXISTS 'HydraulicLocationCalculationCollectionEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -350,6 +356,14 @@ ( 'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'ProjectEntityId' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity1Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity2Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity3Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity4Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity5Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity6Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity7Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntity8Id' INTEGER NOT NULL, 'Id' TEXT, 'Name' VARCHAR (260), 'Comments' TEXT, @@ -361,19 +375,19 @@ 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune 'ReferenceLinePointXml' TEXT, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity1Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_02' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity2Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_03' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity3Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_04' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity4Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_05' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity5Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_06' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity6Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_07' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity7Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_08' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity8Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'UQ_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntities' UNIQUE ('HydraulicLocationCalculationCollectionEntity1Id','HydraulicLocationCalculationCollectionEntity2Id','HydraulicLocationCalculationCollectionEntity3Id','HydraulicLocationCalculationCollectionEntity4Id','HydraulicLocationCalculationCollectionEntity5Id','HydraulicLocationCalculationCollectionEntity6Id','HydraulicLocationCalculationCollectionEntity7Id','HydraulicLocationCalculationCollectionEntity8Id') ) ; -CREATE TABLE 'MacroStabilityOutwardsFailureMechanismMetaEntity' -( - 'MacroStabilityOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'A' REAL NOT NULL, - CONSTRAINT 'FK_MacroStabilityOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'FailureMechanismSectionEntity' ( 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -384,6 +398,15 @@ ) ; +CREATE TABLE 'MacroStabilityOutwardsFailureMechanismMetaEntity' +( + 'MacroStabilityOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'A' REAL NOT NULL, + CONSTRAINT 'FK_MacroStabilityOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'FailureMechanismEntity' ( 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -520,36 +543,12 @@ ( 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity1Id' INTEGER NOT NULL, -- Represents DesignWaterLevelCalculation1 - 'HydraulicLocationCalculationEntity2Id' INTEGER NOT NULL, -- Represents DesignWaterLevelCalculation2 - 'HydraulicLocationCalculationEntity3Id' INTEGER NOT NULL, -- Represents DesignWaterLevelCalculation3 - 'HydraulicLocationCalculationEntity4Id' INTEGER NOT NULL, -- Represents DesignWaterLevelCalculation4 - 'HydraulicLocationCalculationEntity5Id' INTEGER NOT NULL, -- Represents WaveHeightCalculation1 - 'HydraulicLocationCalculationEntity6Id' INTEGER NOT NULL, -- Represents WaveHeightCalculation2 - 'HydraulicLocationCalculationEntity7Id' INTEGER NOT NULL, -- Represents WaveHeightCalculation3 - 'HydraulicLocationCalculationEntity8Id' INTEGER NOT NULL, -- Represents WaveHeightCalculation4 'LocationId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, 'LocationX' REAL, 'LocationY' REAL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity1' FOREIGN KEY ('HydraulicLocationCalculationEntity1Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity2' FOREIGN KEY ('HydraulicLocationCalculationEntity2Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity3' FOREIGN KEY ('HydraulicLocationCalculationEntity3Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity4' FOREIGN KEY ('HydraulicLocationCalculationEntity4Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity5' FOREIGN KEY ('HydraulicLocationCalculationEntity5Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity6' FOREIGN KEY ('HydraulicLocationCalculationEntity6Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity7' FOREIGN KEY ('HydraulicLocationCalculationEntity7Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity8' FOREIGN KEY ('HydraulicLocationCalculationEntity8Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity2Id' UNIQUE ('HydraulicLocationCalculationEntity2Id'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity4Id' UNIQUE ('HydraulicLocationCalculationEntity4Id'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity3Id' UNIQUE ('HydraulicLocationCalculationEntity3Id'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity1Id' UNIQUE ('HydraulicLocationCalculationEntity1Id'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity6Id' UNIQUE ('HydraulicLocationCalculationEntity6Id'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity8Id' UNIQUE ('HydraulicLocationCalculationEntity8Id'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity7Id' UNIQUE ('HydraulicLocationCalculationEntity7Id'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity5Id' UNIQUE ('HydraulicLocationCalculationEntity5Id') + CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -580,6 +579,17 @@ ) ; +CREATE TABLE 'StabilityPointStructuresFailureMechanismMetaEntity' +( + 'StabilityPointStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL NOT NULL, + 'ForeshoreProfileCollectionSourcePath' TEXT, + 'StabilityPointStructureCollectionSourcePath' TEXT, + CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ( 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -590,14 +600,12 @@ ) ; -CREATE TABLE 'StabilityPointStructuresFailureMechanismMetaEntity' +CREATE TABLE 'DuneErosionFailureMechanismMetaEntity' ( - 'StabilityPointStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'DuneErosionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT, - 'StabilityPointStructureCollectionSourcePath' TEXT, - CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -629,22 +637,24 @@ ) ; -CREATE TABLE 'DuneErosionFailureMechanismMetaEntity' +CREATE TABLE 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ( - 'DuneErosionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverErosionOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, - CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'ForeshoreProfileCollectionSourcePath' TEXT, + CONSTRAINT 'FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' +CREATE TABLE 'HeightStructuresFailureMechanismMetaEntity' ( - 'GrassCoverErosionOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'HeightStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, + 'HeightStructureCollectionSourcePath' TEXT, 'ForeshoreProfileCollectionSourcePath' TEXT, - CONSTRAINT 'FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -668,17 +678,6 @@ ) ; -CREATE TABLE 'HeightStructuresFailureMechanismMetaEntity' -( - 'HeightStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'HeightStructureCollectionSourcePath' TEXT, - 'ForeshoreProfileCollectionSourcePath' TEXT, - CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'PipingSoilProfileEntity' ( 'PipingSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1932,10 +1931,28 @@ CREATE TABLE 'HydraulicLocationCalculationEntity' ( 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL -- True or false + 'HydraulicLocationEntityId' INTEGER NOT NULL, + 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- True or false + CONSTRAINT 'FK_HydraulicLocationCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; +CREATE TABLE 'HydraulicLocationCalculationCollectionToHydraulicCalculationEntity' +( + 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL, + 'HydraulicLocationCalculationCollectionEntityId' INTEGER NOT NULL, + CONSTRAINT 'PK_HydraulicLocationCalculationCollectionToHydraulicCalculationEntity' PRIMARY KEY ('HydraulicLocationCalculationEntityId','HydraulicLocationCalculationCollectionEntityId'), + CONSTRAINT 'FK_HydraulicLocationCalculationCollectionToHydraulicCalculationEntity_HydraulicLocationCalculationCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntityId') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationCalculationCollectionToHydraulicCalculationEntity_HydraulicLocationCalculationEntity' FOREIGN KEY ('HydraulicLocationCalculationEntityId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'HydraulicLocationCalculationCollectionEntity' +( + 'HydraulicLocationCalculationCollectionEntityId' INTEGER NOT NULL PRIMARY KEY +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' @@ -1961,18 +1978,67 @@ ON 'MacroStabilityInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity1Id' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_02' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity2Id' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_03' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity3Id' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_04' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity4Id' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_05' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity5Id' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_06' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity6Id' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_07' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity7Id' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity_08' + ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity8Id' ASC) +; + CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity' ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC) ; - -CREATE INDEX 'IXFK_MacroStabilityOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MacroStabilityOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE TRIGGER [TR_AfterDeleteAssessmentSectionEntity_RemoveHydraulicLocationCalculationCollectionEntities] + AFTER DELETE + ON AssessmentSectionEntity + FOR EACH ROW +BEGIN + DELETE + FROM HydraulicLocationCalculationCollectionEntity + WHERE HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity1Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity2Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity3Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity4Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity5Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity6Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity7Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity8Id; +END; ; CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) ; +CREATE INDEX 'IXFK_MacroStabilityOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'MacroStabilityOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_FailureMechanismEntity_AssessmentSectionEntity' ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) ; @@ -2017,133 +2083,6 @@ ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity1Id' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_02' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity2Id' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_03' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity3Id' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_04' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity4Id' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_05' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity5Id' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_06' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity6Id' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_07' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity7Id' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_08' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity8Id' ASC) -; -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity2] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity2Id; -END; -; - -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity4] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity4Id; -END; -; - -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity3] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity3Id; -END; -; - -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity1] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity1Id; -END; -; - -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity6] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity6Id; -END; -; - -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity8] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity8Id; -END; -; - -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity7] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity7Id; -END; -; - -CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_CalculationEntity5] - AFTER DELETE - ON HydraulicLocationEntity - FOR EACH ROW -BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntity1Id IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntity5Id; -END; -; - CREATE INDEX 'IXFK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' ON 'PipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) ; @@ -2160,12 +2099,16 @@ ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; +CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'StabilityPointStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StabilityPointStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' @@ -2180,10 +2123,6 @@ ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' ON 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2757,3 +2696,26 @@ CREATE INDEX 'IXFK_HydraRingPreprocessorEntity_AssessmentSectionEntity' ON 'HydraRingPreprocessorEntity' ('AssessmentSectionEntityId' ASC) ; + +CREATE INDEX 'IXFK_HydraulicLocationCalculationEntity_HydraulicLocationEntity' + ON 'HydraulicLocationCalculationEntity' ('HydraulicLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionToHydraulicCalculationEntity_HydraulicLocationCalculationCollectionEntity' + ON 'HydraulicLocationCalculationCollectionToHydraulicCalculationEntity' ('HydraulicLocationCalculationCollectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionToHydraulicCalculationEntity_HydraulicLocationCalculationEntity' + ON 'HydraulicLocationCalculationCollectionToHydraulicCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC) +; +CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionEntity_RemoveHydraulicLocationCalculationEntity] + AFTER DELETE + ON HydraulicLocationCalculationCollectionEntity + FOR EACH ROW +BEGIN + DELETE + FROM HydraulicLocationCalculationEntity + WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL + AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; +END; +;