Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/CalculationGroupEntity.cs =================================================================== diff -u -r5bc0f359a6f5e045c4361a76714fd33cdef448ca -r3e1fd2b47f21d13d88ef644978ca4c28ace81994 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/CalculationGroupEntity.cs (.../CalculationGroupEntity.cs) (revision 5bc0f359a6f5e045c4361a76714fd33cdef448ca) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/CalculationGroupEntity.cs (.../CalculationGroupEntity.cs) (revision 3e1fd2b47f21d13d88ef644978ca4c28ace81994) @@ -39,6 +39,7 @@ public CalculationGroupEntity() { this.CalculationGroupEntity1 = new HashSet(); + this.FailureMechanismEntities = new HashSet(); } public long CalculationGroupEntityId { get; set; } @@ -47,9 +48,10 @@ public byte IsEditable { get; set; } public long Order { get; set; } - public virtual FailureMechanismEntity FailureMechanismEntity { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection CalculationGroupEntity1 { get; set; } public virtual CalculationGroupEntity CalculationGroupEntity2 { get; set; } + [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] + public virtual ICollection FailureMechanismEntities { get; set; } } } Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r5bc0f359a6f5e045c4361a76714fd33cdef448ca -r3e1fd2b47f21d13d88ef644978ca4c28ace81994 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 5bc0f359a6f5e045c4361a76714fd33cdef448ca) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 3e1fd2b47f21d13d88ef644978ca4c28ace81994) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 26-mei-2016 14:48:57 */ +/* Created On : 27-mei-2016 15:23:56 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -94,6 +94,7 @@ 'IsRelevant' TINYINT (1) NOT NULL, -- true or false 'CalculationGroupEntityId' INTEGER, CONSTRAINT 'FK_FailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_FailureMechanismEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'UI_AssessmentSectionEntityId_FailureMechanismType' UNIQUE ('FailureMechanismType','AssessmentSectionEntityId') ) ; @@ -125,8 +126,7 @@ 'Name' VARCHAR (255) NOT NULL, 'IsEditable' TINYINT (1) NOT NULL, -- true or false 'Order' INTEGER NOT NULL, - CONSTRAINT 'FK_CalculationGroupEntity_CalculationGroupEntity' FOREIGN KEY ('ParentCalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_CalculationGroupEntity_FailureMechanismEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE No Action ON UPDATE No Action + CONSTRAINT 'FK_CalculationGroupEntity_CalculationGroupEntity' FOREIGN KEY ('ParentCalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -235,6 +235,10 @@ ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_FailureMechanismEntity_CalculationGroupEntity' + ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) +; + CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) ; @@ -247,10 +251,6 @@ ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_CalculationGroupEntity_FailureMechanismEntity' - ON 'CalculationGroupEntity' ('CalculationGroupEntityId' ASC) -; - CREATE INDEX 'IXFK_HydraulicLocationEntity_AssessmentSectionEntity' ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ; Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx =================================================================== diff -u -r5bc0f359a6f5e045c4361a76714fd33cdef448ca -r3e1fd2b47f21d13d88ef644978ca4c28ace81994 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision 5bc0f359a6f5e045c4361a76714fd33cdef448ca) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision 3e1fd2b47f21d13d88ef644978ca4c28ace81994) @@ -171,19 +171,7 @@ - - - - - - - - - - - - @@ -207,6 +195,18 @@ + + + + + + + + + + + + @@ -360,18 +360,18 @@ - - - - + + + + @@ -441,7 +441,7 @@ - + @@ -454,12 +454,12 @@ - + - + - + @@ -511,7 +511,7 @@ - + @@ -524,9 +524,9 @@ - - - + + + @@ -546,8 +546,8 @@ - - + + @@ -693,7 +693,7 @@ - + @@ -730,26 +730,26 @@ - + - - - - + + + + - + - + - - + + Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram =================================================================== diff -u -r5bc0f359a6f5e045c4361a76714fd33cdef448ca -r3e1fd2b47f21d13d88ef644978ca4c28ace81994 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision 5bc0f359a6f5e045c4361a76714fd33cdef448ca) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision 3e1fd2b47f21d13d88ef644978ca4c28ace81994) @@ -5,28 +5,28 @@ - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + - + - + Index: Application/Ringtoets/test/Application.Ringtoets.Storage.Test/Create/CalculationGroupCreateExtensionsTest.cs =================================================================== diff -u -ra760d63747f5c44e99f4e747ace1b4e51c040362 -r3e1fd2b47f21d13d88ef644978ca4c28ace81994 --- Application/Ringtoets/test/Application.Ringtoets.Storage.Test/Create/CalculationGroupCreateExtensionsTest.cs (.../CalculationGroupCreateExtensionsTest.cs) (revision a760d63747f5c44e99f4e747ace1b4e51c040362) +++ Application/Ringtoets/test/Application.Ringtoets.Storage.Test/Create/CalculationGroupCreateExtensionsTest.cs (.../CalculationGroupCreateExtensionsTest.cs) (revision 3e1fd2b47f21d13d88ef644978ca4c28ace81994) @@ -69,7 +69,7 @@ Assert.AreEqual(order, entity.Order); CollectionAssert.IsEmpty(entity.CalculationGroupEntity1); - Assert.IsNull(entity.FailureMechanismEntity); + CollectionAssert.IsEmpty(entity.FailureMechanismEntities); Assert.IsNull(entity.ParentCalculationGroupEntityId); }