Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r28fb1b160a865640e7a069cb594862563e18add5 -re5d6efe604b27b59ac7c5d5315a446f63ea133be --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 28fb1b160a865640e7a069cb594862563e18add5) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision e5d6efe604b27b59ac7c5d5315a446f63ea133be) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 08-dec-2016 09:02:46 */ +/* Created On : 08-Dec-2016 10:22:38 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -657,7 +657,7 @@ ( 'GrassCoverErosionOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -745,7 +745,7 @@ ( 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -756,7 +756,7 @@ ( 'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade