Index: build/DatabaseStructure.sql =================================================================== diff -u -rfe88135b797eda12b8e4d9b829036d2d7a52b10f -r56ac4eb28f5fcc5b20117474e9e4030399d6806a --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision fe88135b797eda12b8e4d9b829036d2d7a52b10f) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 56ac4eb28f5fcc5b20117474e9e4030399d6806a) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 10-Apr-2017 13:58:22 */ +/* Created On : 11-Apr-2017 10:44:39 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -464,6 +464,7 @@ 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' INT (4) NOT NULL, + 'DikeProfileCollectionSourcePath' TEXT, CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -841,7 +842,8 @@ 'Y' REAL, 'X0' REAL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_DikeProfileEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_DikeProfileEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'UQ_DikeProfileEntity_IdFailureMechanismEntityId' UNIQUE ('Id','FailureMechanismEntityId') ) ;