Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r9e1b97e9540df6cbd635120135c83de0260aa6d1 -re1413d482cd37476c01aaea03ae16efc50433f3e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 9e1b97e9540df6cbd635120135c83de0260aa6d1) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision e1413d482cd37476c01aaea03ae16efc50433f3e) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 23-mei-2016 8:51:48 */ +/* Created On : 23-mei-2016 13:26:35 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -179,7 +179,7 @@ CREATE TABLE 'SurfaceLineEntity' ( - 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY, + 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'Name' VARCHAR (255) NOT NULL, 'ReferenceLineIntersectionX' NUMERIC NOT NULL, @@ -202,7 +202,7 @@ CREATE TABLE 'CharacteristicPointEntity' ( - 'CharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY, + 'CharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'CharacteristicPointType' SMALLINT NOT NULL, -- Enum: 1 = DikeToeAtRiver 2 = DikeToeAtPolder 3 = DitchDikeSide 4 = BottomDitchDikeSide 5 = BottomDitchPolderSide 6 = DitchPolderSide 'SurfaceLinePointEntityId' INTEGER NOT NULL, CONSTRAINT 'FK_CharacteristicPointEntity_SurfaceLinePointEntity' FOREIGN KEY ('SurfaceLinePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action