Index: build/DatabaseStructure.sql =================================================================== diff -u -rf8ca05b943cbe9d7fca76ffe6e61b11ca4bbde5a -ra26f8ba0067df146397c8505ec9dc98dda1c94fd --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f8ca05b943cbe9d7fca76ffe6e61b11ca4bbde5a) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a26f8ba0067df146397c8505ec9dc98dda1c94fd) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 31-Jan-2017 07:54:01 */ +/* Created On : 30-Jan-2017 11:15:35 */ /* 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' @@ -322,12 +325,6 @@ 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune 'ReferenceLinePointXml' TEXT, 'Order' INT (4) NOT NULL, - 'WmtsName' TEXT NOT NULL, - 'SourceCapabilitesUrl' TEXT, - 'SelectedCapabilityName' TEXT, - 'PreferredFormat' VARCHAR (255), - 'BackgroundMapDataIsVisible' TINYINT (1) NOT NULL, -- true or false - 'BackgroundMapDataTransparency' REAL NOT NULL, CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1334,6 +1331,20 @@ ) ; +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, + 'PreferredFormat' VARCHAR (255) 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' @@ -1687,3 +1698,7 @@ CREATE INDEX 'IXFK_DuneLocationOutputEntity_DuneLocationEntity' ON 'DuneLocationOutputEntity' ('DuneLocationEntityId' ASC) ; + +CREATE INDEX 'IXFK_WmtsMapDataEntity_AssessmentSectionEntity' + ON 'WmtsMapDataEntity' ('AssessmentSectionEntityId' ASC) +;