Index: build/DatabaseStructure.sql =================================================================== diff -u -ra25ab906f08e5e263ebb35920acc3ee1bdd928df -r10b1af154bf9c4253cb5db37cf8a55419068b8a7 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a25ab906f08e5e263ebb35920acc3ee1bdd928df) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 10b1af154bf9c4253cb5db37cf8a55419068b8a7) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 06-nov-2017 14:27:01 */ +/* Created On : 07-nov-2017 9:04:53 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -294,6 +294,9 @@ DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity' ; +DROP TABLE IF EXISTS 'HydraRingPreprocessorEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -1924,6 +1927,16 @@ ) ; +CREATE TABLE 'HydraRingPreprocessorEntity' +( + 'HydraRingPreprocessorEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'UsePreprocessor' TINYINT (1) NOT NULL, + 'PreprocessorDirectory' TEXT NOT NULL, + CONSTRAINT 'FK_HydraRingPreprocessorEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' @@ -2610,3 +2623,7 @@ AND MacroStabilityInwardsSoilLayerTwoDEntity IS OLD.MacroStabilityInwardsSoilLayerTwoDEntity; END; ; + +CREATE INDEX 'IXFK_HydraRingPreprocessorEntity_AssessmentSectionEntity' + ON 'HydraRingPreprocessorEntity' ('AssessmentSectionEntityId' ASC) +;