Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r741fcc00e47a7ff8fa01bbf15edbaedf8dec2e57 -r8aaa7b9a8a2826cf8da31d0fd136f2d559933afe --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 741fcc00e47a7ff8fa01bbf15edbaedf8dec2e57) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8aaa7b9a8a2826cf8da31d0fd136f2d559933afe) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 14-sep-2016 14:06:31 */ +/* Created On : 14-sep-2016 16:49:31 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -129,6 +129,9 @@ DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOutputEntity' ; +DROP TABLE IF EXISTS 'ForeshoreProfileEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -640,6 +643,23 @@ ) ; +CREATE TABLE 'ForeshoreProfileEntity' +( + 'ForeshoreProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Name' VARCHAR (260), + 'Orientation' REAL, + 'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall 2 = Caisson 3 = Dam + 'BreakWaterHeight' REAL, + 'GeometryXml' TEXT NOT NULL, + 'X' REAL, + 'Y' REAL, + 'X0' REAL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_ForeshoreProfileEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' @@ -821,3 +841,7 @@ CREATE INDEX 'IXFK_GrassCoverErosionInwardsOutput_ProbabilisticOutputEntity' ON 'GrassCoverErosionInwardsOutputEntity' ('ProbabilisticOutputEntityId' ASC) ; + +CREATE INDEX 'IXFK_ForeshoreProfileEntity_FailureMechanismEntity' + ON 'ForeshoreProfileEntity' ('FailureMechanismEntityId' ASC) +;