Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/Resources/DatabaseStructure17.1.sql =================================================================== diff -u -r873bd2b6b7b9d0737dde2ed16ff5d10a66795a2f -r7a4c657ec5fdedf42347b2f46f7b8b2d5b16db2f --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/Resources/DatabaseStructure17.1.sql (.../DatabaseStructure17.1.sql) (revision 873bd2b6b7b9d0737dde2ed16ff5d10a66795a2f) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/Resources/DatabaseStructure17.1.sql (.../DatabaseStructure17.1.sql) (revision 7a4c657ec5fdedf42347b2f46f7b8b2d5b16db2f) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 07-mrt-2017 08:22:26 */ +/* Created On : 09-Mar-2017 11:11:11 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -204,9 +204,12 @@ DROP TABLE IF EXISTS 'DuneLocationOutputEntity' ; -DROP TABLE IF EXISTS 'BackgroundMapDataEntity' +DROP TABLE IF EXISTS 'BackgroundDataEntity' ; +DROP TABLE IF EXISTS 'BackgroundDataMetaEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -1336,20 +1339,30 @@ ) ; -CREATE TABLE 'BackgroundMapDataEntity' +CREATE TABLE 'BackgroundDataEntity' ( - 'BackgroundMapDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'BackgroundDataEntityId' 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, + 'IsConfigured' TINYINT (1) NOT NULL, -- true or false + 'BackgroundDataType' TINYINT (1) NOT NULL, -- Enum: 0 = Wmts, 1 = WellKnown CONSTRAINT 'FK_WmtsMapDataEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; +CREATE TABLE 'BackgroundDataMetaEntity' +( + 'BackgroundDataMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'BackgroundDataEntityId' INTEGER NOT NULL, + 'Key' TEXT NOT NULL, + 'Value' TEXT NOT NULL, + CONSTRAINT 'FK_BackgroundDataMetaEntity_BackgroundDataEntity' FOREIGN KEY ('BackgroundDataEntityId') REFERENCES 'BackgroundDataEntity' ('BackgroundDataEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_BackgroundDataEntityId_Key' UNIQUE ('BackgroundDataEntityId','Key') +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity' @@ -1705,5 +1718,9 @@ ; CREATE INDEX 'IXFK_WmtsMapDataEntity_AssessmentSectionEntity' - ON 'BackgroundMapDataEntity' ('AssessmentSectionEntityId' ASC) + ON 'BackgroundDataEntity' ('AssessmentSectionEntityId' ASC) ; + +CREATE INDEX 'IXFK_BackgroundDataMetaEntity_BackgroundDataEntity' + ON 'BackgroundDataMetaEntity' ('BackgroundDataEntityId' ASC) +; Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/Resources/Migration_5_17.1.sql =================================================================== diff -u -r873bd2b6b7b9d0737dde2ed16ff5d10a66795a2f -r7a4c657ec5fdedf42347b2f46f7b8b2d5b16db2f --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/Resources/Migration_5_17.1.sql (.../Migration_5_17.1.sql) (revision 873bd2b6b7b9d0737dde2ed16ff5d10a66795a2f) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/Resources/Migration_5_17.1.sql (.../Migration_5_17.1.sql) (revision 7a4c657ec5fdedf42347b2f46f7b8b2d5b16db2f) @@ -200,15 +200,19 @@ SELECT FailureMechanismEntityId, 2.0 FROM FailureMechanismEntity WHERE FailureMechanismType = 8; -INSERT INTO BackgroundMapDataEntity ( +INSERT INTO BackgroundDataEntity ( [AssessmentSectionEntityId], [Name], [IsVisible], - [Transparency]) + [Transparency], + [IsConfigured], + [BackgroundDataType]) SELECT AssessmentSectionEntityId, "", 0, - 0.0 + 0.0, + 0, + 0 FROM AssessmentSectionEntity; DETACH SOURCEPROJECT;