Index: build/DatabaseStructure.sql =================================================================== diff -u -r40793165416093e9d2fefb6b12acf82fbd8a84c2 -r97c9190ed248b48cdec74d092f53ef28e8ad4530 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 40793165416093e9d2fefb6b12acf82fbd8a84c2) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 97c9190ed248b48cdec74d092f53ef28e8ad4530) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 09-Mar-2017 11:11:11 */ +/* Created On : 17-Mar-2017 10:26:22 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -548,7 +548,7 @@ 'StochasticSoilModelSegmentPointXml' TEXT NOT NULL, 'Order' INT (4) NOT NULL, CONSTRAINT 'FK_StochasticSoilModelEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'UQ_StochasticSoilModelEntity_Name' UNIQUE ('Name') + CONSTRAINT 'UQ_StochasticSoilModelEntity_NameFailureMechanismEntityId' UNIQUE ('Name','FailureMechanismEntityId') ) ; @@ -561,7 +561,8 @@ 'ReferenceLineIntersectionY' REAL, 'PointsXml' TEXT NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'UQ_SurfaceLineEntity_NameFailureMechanismEntityId' UNIQUE ('Name','FailureMechanismEntityId') ) ;