Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r97b905a386a23f1b200a86ea29bcd699c33bf537 -r8f13852513ec66f8725df3da17aa0c1895b04382 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 97b905a386a23f1b200a86ea29bcd699c33bf537) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8f13852513ec66f8725df3da17aa0c1895b04382) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 14-Mar-2016 11:53:27 AM */ +/* Created On : 17-Mar-2016 11:55:25 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -12,6 +12,9 @@ DROP TABLE IF EXISTS 'FailureMechanismEntity' ; +DROP TABLE IF EXISTS 'HydraulicLocationEntity' +; + DROP TABLE IF EXISTS 'ProjectEntity' ; @@ -27,6 +30,8 @@ 'Name' VARCHAR NOT NULL, 'Norm' INT(4) NOT NULL, 'Order' INT(4) NOT NULL, + 'HydraulicDatabaseVersion' TEXT, + 'HydraulicDatabaseLocation' TEXT, CONSTRAINT 'FK_AssessmentSection_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -41,6 +46,18 @@ ) ; +CREATE TABLE 'HydraulicLocationEntity' +( + 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY, + 'DikeAssessmentSectionEntityId' INTEGER NOT NULL, + 'Name' TEXT NOT NULL, + 'LocationX' NUMERIC NOT NULL, + 'LocationY' NUMERIC NOT NULL, + 'DesignWaterLevel' REAL, + CONSTRAINT 'FK_HydraulicLocationEntity_DikeAssessmentSectionEntity' FOREIGN KEY ('DikeAssessmentSectionEntityId') REFERENCES 'DikeAssessmentSectionEntity' ('DikeAssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'ProjectEntity' ( 'ProjectEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -67,3 +84,7 @@ CREATE INDEX 'IXFK_FailureMechanismEntity_AssessmentSectionEntity' ON 'FailureMechanismEntity' ('DikeAssessmentSectionEntityId' ASC) ; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_DikeAssessmentSectionEntity' + ON 'HydraulicLocationEntity' ('DikeAssessmentSectionEntityId' ASC) +;