Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure17.2.sql =================================================================== diff -u -r755360927a67d206d503b10e0d4c40d5426c4a3b -r5eefb1e7166380719c39d6c20504d3cc5625dd13 --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure17.2.sql (.../DatabaseStructure17.2.sql) (revision 755360927a67d206d503b10e0d4c40d5426c4a3b) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure17.2.sql (.../DatabaseStructure17.2.sql) (revision 5eefb1e7166380719c39d6c20504d3cc5625dd13) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 02-May-2017 11:13:54 */ +/* Created On : 04-May-2017 1:17:02 PM */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1095,7 +1095,8 @@ 'StorageStructureAreaCoefficientOfVariation' REAL, 'AllowedLevelIncreaseStorageMean' REAL, 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - CONSTRAINT 'FK_HeightStructure_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_HeightStructure_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_Id_FailureMechanismEntityId' UNIQUE ('FailureMechanismEntityId','Id') ) ; Index: build/DatabaseStructure.sql =================================================================== diff -u -r755360927a67d206d503b10e0d4c40d5426c4a3b -r5eefb1e7166380719c39d6c20504d3cc5625dd13 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 755360927a67d206d503b10e0d4c40d5426c4a3b) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 5eefb1e7166380719c39d6c20504d3cc5625dd13) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 02-May-2017 11:13:54 */ +/* Created On : 04-May-2017 1:17:02 PM */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1095,7 +1095,8 @@ 'StorageStructureAreaCoefficientOfVariation' REAL, 'AllowedLevelIncreaseStorageMean' REAL, 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - CONSTRAINT 'FK_HeightStructure_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_HeightStructure_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_Id_FailureMechanismEntityId' UNIQUE ('FailureMechanismEntityId','Id') ) ; Index: design/DatabaseDesign.eap =================================================================== diff -u -r755360927a67d206d503b10e0d4c40d5426c4a3b -r5eefb1e7166380719c39d6c20504d3cc5625dd13 Binary files differ