Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r86e3c1e3b6568eea578004f3d9d93114cdb351b8 -r24cf947dc2fc0c56fb917b989bc4ad2ccb27bcae --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 86e3c1e3b6568eea578004f3d9d93114cdb351b8) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 24cf947dc2fc0c56fb917b989bc4ad2ccb27bcae) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 18-mei-2016 9:09:40 */ +/* Created On : 18-mei-2016 13:30:01 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -179,6 +179,20 @@ 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY, 'FailureMechanismEntityId' INTEGER NOT NULL, 'Name' VARCHAR (255) NOT NULL, + 'ReferenceLineIntersectionX' NUMERIC NOT NULL, + 'ReferenceLineIntersectionY' NUMERIC NOT NULL, + 'DitchPolderSidePointEntityId' INTEGER, + 'BottomDitchPolderSidePointEntityId' INTEGER, + 'BottomDitchDikeSidePointEntityId' INTEGER, + 'DitchDikeSidePointEntityId' INTEGER, + 'DikeToeAtRiverEntityId' INTEGER, + 'DikeToeAtPolderEntityId' INTEGER, + CONSTRAINT 'FK_BottomDitchDikeSidePointEntity_SurfaceLinePointEntity' FOREIGN KEY ('BottomDitchDikeSidePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'FK_BottomDitchPolderSidePointEntity_SurfaceLinePointEntity' FOREIGN KEY ('BottomDitchPolderSidePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'FK_DikeToeAtPolderPointEntity_SurfaceLinePointEntity' FOREIGN KEY ('DikeToeAtPolderEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'FK_DikeToeAtRiverPointEntity_SurfaceLinePointEntity' FOREIGN KEY ('DikeToeAtRiverEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'FK_DitchDikeSidePointEntity_SurfaceLinePointEntity' FOREIGN KEY ('DitchDikeSidePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'FK_DitchPolderSidePointEntity_SurfaceLinePointEntity' FOREIGN KEY ('DitchPolderSidePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action, CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE No Action ON UPDATE No Action ) ; @@ -190,6 +204,7 @@ 'X' NUMERIC NOT NULL, 'Y' NUMERIC NOT NULL, 'Order' INT (4) NOT NULL, + 'Z' NUMERIC NOT NULL, CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE No Action ON UPDATE No Action ) ; @@ -236,6 +251,30 @@ ON 'SurfaceLineEntity' ('FailureMechanismEntityId' ASC) ; +CREATE INDEX 'IXFK_SurfaceLineEntity_SurfaceLinePointEntity' + ON 'SurfaceLineEntity' ('DitchPolderSidePointEntityId' ASC) +; + +CREATE INDEX 'IXFK_SurfaceLineEntity_SurfaceLinePointEntity_02' + ON 'SurfaceLineEntity' ('BottomDitchPolderSidePointEntityId' ASC) +; + +CREATE INDEX 'IXFK_SurfaceLineEntity_SurfaceLinePointEntity_03' + ON 'SurfaceLineEntity' ('BottomDitchDikeSidePointEntityId' ASC) +; + +CREATE INDEX 'IXFK_SurfaceLineEntity_SurfaceLinePointEntity_04' + ON 'SurfaceLineEntity' ('DitchDikeSidePointEntityId' ASC) +; + +CREATE INDEX 'IXFK_SurfaceLineEntity_SurfaceLinePointEntity_05' + ON 'SurfaceLineEntity' ('DikeToeAtRiverEntityId' ASC) +; + +CREATE INDEX 'IXFK_SurfaceLineEntity_SurfaceLinePointEntity_06' + ON 'SurfaceLineEntity' ('DikeToeAtPolderEntityId' ASC) +; + CREATE INDEX 'IXFK_SurfaceLinePointEntity_SurfaceLineEntity' ON 'SurfaceLinePointEntity' ('SurfaceLineEntityId' ASC) ;