Index: build/DatabaseStructure.sql =================================================================== diff -u -rb90a0c4497995c69bc4443bf0213f8d8fae96680 -rf8ca05b943cbe9d7fca76ffe6e61b11ca4bbde5a --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision b90a0c4497995c69bc4443bf0213f8d8fae96680) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f8ca05b943cbe9d7fca76ffe6e61b11ca4bbde5a) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 30-Jan-2017 11:15:35 */ +/* Created On : 31-Jan-2017 07:54:01 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -204,9 +204,6 @@ DROP TABLE IF EXISTS 'DuneLocationOutputEntity' ; -DROP TABLE IF EXISTS 'WmtsMapDataEntity' -; - /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -325,6 +322,12 @@ '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 ) ; @@ -1331,20 +1334,6 @@ ) ; -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' @@ -1698,7 +1687,3 @@ CREATE INDEX 'IXFK_DuneLocationOutputEntity_DuneLocationEntity' ON 'DuneLocationOutputEntity' ('DuneLocationEntityId' ASC) ; - -CREATE INDEX 'IXFK_WmtsMapDataEntity_AssessmentSectionEntity' - ON 'WmtsMapDataEntity' ('AssessmentSectionEntityId' ASC) -;