Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -rb809769cd89b011d6746bf0b9b99eff1abd49f60 -r86e3c1e3b6568eea578004f3d9d93114cdb351b8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision b809769cd89b011d6746bf0b9b99eff1abd49f60) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 86e3c1e3b6568eea578004f3d9d93114cdb351b8) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 29-apr-2016 13:25:01 */ +/* Created On : 18-mei-2016 9:09:40 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -42,6 +42,12 @@ DROP TABLE IF EXISTS 'StochasticSoilModelEntity' ; +DROP TABLE IF EXISTS 'SurfaceLineEntity' +; + +DROP TABLE IF EXISTS 'SurfaceLinePointEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -168,6 +174,26 @@ ) ; +CREATE TABLE 'SurfaceLineEntity' +( + 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Name' VARCHAR (255) NOT NULL, + CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE No Action ON UPDATE No Action +) +; + +CREATE TABLE 'SurfaceLinePointEntity' +( + 'SurfaceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SurfaceLineEntityId' INTEGER NOT NULL, + 'X' NUMERIC NOT NULL, + 'Y' NUMERIC NOT NULL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE No Action ON UPDATE No Action +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity' @@ -205,3 +231,11 @@ CREATE INDEX 'IXFK_StochasticSoilModelEntity_FailureMechanismEntity' ON 'StochasticSoilModelEntity' ('FailureMechanismEntityId' ASC) ; + +CREATE INDEX 'IXFK_SurfaceLineEntity_FailureMechanismEntity' + ON 'SurfaceLineEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_SurfaceLinePointEntity_SurfaceLineEntity' + ON 'SurfaceLinePointEntity' ('SurfaceLineEntityId' ASC) +;