Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r306028f53543223cc68a988fe9c82b7341e78948 -r4f6e0fc5af40cbeb6497e6141eba1d932bd2589c --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 306028f53543223cc68a988fe9c82b7341e78948) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 4f6e0fc5af40cbeb6497e6141eba1d932bd2589c) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 21-Mar-2016 11:00:48 */ +/* Created On : 22-Mar-2016 9:03:41 AM */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -15,9 +15,6 @@ DROP TABLE IF EXISTS 'HydraulicLocationEntity' ; -DROP TABLE IF EXISTS 'ProjectEntity' -; - DROP TABLE IF EXISTS 'ReferenceLinePointEntity' ; @@ -62,21 +59,12 @@ ) ; -CREATE TABLE 'ProjectEntity' -( - 'ProjectEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Description' VARCHAR (260), - 'LastUpdated' INTEGER DEFAULT CURRENT_TIMESTAMP -) -; - CREATE TABLE 'ReferenceLinePointEntity' ( - 'ReferenceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY, - 'DikeAssessmentSectionEntityId' INTEGER, - 'X' NUMERIC, - 'Y' NUMERIC, - 'Order' INT (4), + 'DikeAssessmentSectionEntityId' INTEGER NOT NULL, + 'X' NUMERIC NOT NULL, + 'Y' NUMERIC NOT NULL, + 'Order' INT (4) NOT NULL, CONSTRAINT 'FK_ReferenceLinePointEntity_DikeAssessmentSectionEntity' FOREIGN KEY ('DikeAssessmentSectionEntityId') REFERENCES 'DikeAssessmentSectionEntity' ('DikeAssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ;