Index: build/DatabaseStructure.sql =================================================================== diff -u -rf18e15506f15ac89e88f9c587c7efa02b9458470 -r34aa6a0f45a01de68ecc6f1c2856874afced1f84 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f18e15506f15ac89e88f9c587c7efa02b9458470) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 34aa6a0f45a01de68ecc6f1c2856874afced1f84) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 10-Sep-2018 10:04:29 */ +/* Created On : 09-jan-2019 16:28:46 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -300,6 +300,9 @@ DROP TABLE IF EXISTS 'DuneLocationCalculationEntity' ; +DROP TABLE IF EXISTS 'HydraulicBoundaryDatabaseEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -364,8 +367,6 @@ 'LowerLimitNorm' REAL NOT NULL, 'SignalingNorm' REAL NOT NULL, 'NormativeNormType' TINYINT (1) NOT NULL, -- EnumType: 1 = LowerLimit, 2 = Signaling - 'HydraulicDatabaseVersion' TEXT, - 'HydraulicDatabaseLocation' TEXT, 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune 'ReferenceLinePointXml' TEXT, 'Order' INT (4) NOT NULL, @@ -2016,6 +2017,26 @@ ) ; +CREATE TABLE 'HydraulicBoundaryDatabaseEntity' +( + 'HydraulicBoundaryDatabaseEntity' INTEGER NOT NULL PRIMARY KEY, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'HydraulicBoundaryDatabaseVersion' TEXT NOT NULL, + 'HydraulicBoundaryDatabaseFilePath' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsFilePath' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsScenarioName' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsYear' INTEGER NOT NULL, + 'HydraulicLocationConfigurationSettingsScope' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsSeaLevel' TEXT, + 'HydraulicLocationConfigurationSettingsRiverDischarge' TEXT, + 'HydraulicLocationConfigurationSettingsLakeLevel' TEXT, + 'HydraulicLocationConfigurationSettingsWindDirection' TEXT, + 'HydraulicLocationConfigurationSettingsWindSpeed' TEXT, + 'HydraulicLocationConfigurationSettingsComment' TEXT, + CONSTRAINT 'FK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' @@ -2823,3 +2844,7 @@ CREATE INDEX 'IXFK_DuneLocationCalculationEntity_DuneLocationEntity' ON 'DuneLocationCalculationEntity' ('DuneLocationEntityId' ASC) ; + +CREATE INDEX 'IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' + ON 'HydraulicBoundaryDatabaseEntity' ('AssessmentSectionEntityId' ASC) +;