Index: Application/Ringtoets/src/Application.Ringtoets.Migration/Resources/DatabaseStructure17.1.sql =================================================================== diff -u -ra26f8ba0067df146397c8505ec9dc98dda1c94fd -r03a263822252a5020135a7de96ea8e50d5eb5cc6 --- Application/Ringtoets/src/Application.Ringtoets.Migration/Resources/DatabaseStructure17.1.sql (.../DatabaseStructure17.1.sql) (revision a26f8ba0067df146397c8505ec9dc98dda1c94fd) +++ Application/Ringtoets/src/Application.Ringtoets.Migration/Resources/DatabaseStructure17.1.sql (.../DatabaseStructure17.1.sql) (revision 03a263822252a5020135a7de96ea8e50d5eb5cc6) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 12-Jan-2017 2:31:23 PM */ +/* Created On : 31-Jan-2017 10:19:09 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -204,6 +204,9 @@ DROP TABLE IF EXISTS 'DuneLocationOutputEntity' ; +DROP TABLE IF EXISTS 'BackgroundMapDataEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -1328,6 +1331,20 @@ ) ; +CREATE TABLE 'BackgroundMapDataEntity' +( + 'BackgroundMapDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'Name' TEXT NOT NULL, + 'SourceCapabilitiesUrl' TEXT, + 'SelectedCapabilityName' TEXT, + 'PreferredFormat' VARCHAR (255), + '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 +1698,7 @@ CREATE INDEX 'IXFK_DuneLocationOutputEntity_DuneLocationEntity' ON 'DuneLocationOutputEntity' ('DuneLocationEntityId' ASC) ; + +CREATE INDEX 'IXFK_WmtsMapDataEntity_AssessmentSectionEntity' + ON 'BackgroundMapDataEntity' ('AssessmentSectionEntityId' ASC) +;