Index: build/DatabaseStructure.sql =================================================================== diff -u -r8e5f037ed7df5263d26ba1ada373be196e7a354b -rbae43849319d185f843b75146d0087bf7996e880 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8e5f037ed7df5263d26ba1ada373be196e7a354b) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision bae43849319d185f843b75146d0087bf7996e880) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 20-Jan-2017 8:34:09 AM */ +/* Created On : 27-Jan-2017 13:54:00 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -204,6 +204,9 @@ DROP TABLE IF EXISTS 'DuneLocationOutputEntity' ; +DROP TABLE IF EXISTS 'WmtsMapDataEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -1328,6 +1331,19 @@ ) ; +CREATE TABLE 'WmtsMapDataEntity' +( + 'WmtsMapDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'Name' TEXT NOT NULL, + 'SourceCapabilitiesUrl' TEXT NOT NULL, + 'SelectedCapabilityName' TEXT NOT NULL, + 'IsVisible' TINYINT (1) NOT NULL, -- true or false + 'Transparency' REAL NOT NULL, + CONSTRAINT 'FK_WmtsMapDataEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity' @@ -1681,3 +1697,7 @@ CREATE INDEX 'IXFK_DuneLocationOutputEntity_DuneLocationEntity' ON 'DuneLocationOutputEntity' ('DuneLocationEntityId' ASC) ; + +CREATE INDEX 'IXFK_WmtsMapDataEntity_AssessmentSectionEntity' + ON 'WmtsMapDataEntity' ('AssessmentSectionEntityId' ASC) +;