Index: build/DatabaseStructure.sql =================================================================== diff -u -r97c9190ed248b48cdec74d092f53ef28e8ad4530 -rc0387d79bcdc500558362264d5bc08834ebe6db5 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 97c9190ed248b48cdec74d092f53ef28e8ad4530) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision c0387d79bcdc500558362264d5bc08834ebe6db5) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 17-Mar-2017 10:26:22 */ +/* Created On : 20-Mar-2017 07:58:30 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1348,8 +1348,8 @@ '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 + 'BackgroundDataType' TINYINT (1) NOT NULL, -- Enum: 1 = Wmts, 2 = WellKnown + CONSTRAINT 'FK_BackgroundDataEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1718,7 +1718,7 @@ ON 'DuneLocationOutputEntity' ('DuneLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_WmtsMapDataEntity_AssessmentSectionEntity' +CREATE INDEX 'IXFK_BackgroundDataEntity_AssessmentSectionEntity' ON 'BackgroundDataEntity' ('AssessmentSectionEntityId' ASC) ;