Index: build/DatabaseStructure.sql =================================================================== diff -u -ra26f8ba0067df146397c8505ec9dc98dda1c94fd -rec9f45c99b375218d00a89df1ac1e187ebf54070 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a26f8ba0067df146397c8505ec9dc98dda1c94fd) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ec9f45c99b375218d00a89df1ac1e187ebf54070) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 30-Jan-2017 11:15:35 */ +/* Created On : 31-Jan-2017 10:19:09 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -204,7 +204,7 @@ DROP TABLE IF EXISTS 'DuneLocationOutputEntity' ; -DROP TABLE IF EXISTS 'WmtsMapDataEntity' +DROP TABLE IF EXISTS 'BackgroundMapDataEntity' ; /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ @@ -1331,14 +1331,14 @@ ) ; -CREATE TABLE 'WmtsMapDataEntity' +CREATE TABLE 'BackgroundMapDataEntity' ( - 'WmtsMapDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'BackgroundMapDataEntityId' 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, + '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 @@ -1700,5 +1700,5 @@ ; CREATE INDEX 'IXFK_WmtsMapDataEntity_AssessmentSectionEntity' - ON 'WmtsMapDataEntity' ('AssessmentSectionEntityId' ASC) + ON 'BackgroundMapDataEntity' ('AssessmentSectionEntityId' ASC) ;