Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r2ae1c9433c3c28b32105b9778b682b5e512a0f00 -r306028f53543223cc68a988fe9c82b7341e78948 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 2ae1c9433c3c28b32105b9778b682b5e512a0f00) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 306028f53543223cc68a988fe9c82b7341e78948) @@ -1,17 +1,11 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 17-Mar-2016 6:10:08 PM */ +/* Created On : 21-Mar-2016 11:00:48 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ /* Drop Tables */ -DROP TABLE IF EXISTS 'Version' -; - -DROP TABLE IF EXISTS 'ProjectEntity' -; - DROP TABLE IF EXISTS 'DikeAssessmentSectionEntity' ; @@ -21,28 +15,17 @@ DROP TABLE IF EXISTS 'HydraulicLocationEntity' ; -DROP TABLE IF EXISTS 'ReferenceLinePointEntity' +DROP TABLE IF EXISTS 'ProjectEntity' ; -/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ - -CREATE TABLE 'Version' -( - 'VersionId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FromVersion' TEXT, - 'ToVersion' TEXT, - 'Timestamp' NUMERIC -) +DROP TABLE IF EXISTS 'ReferenceLinePointEntity' ; -CREATE TABLE 'ProjectEntity' -( - 'ProjectEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Description' VARCHAR (260), - 'LastUpdated' INTEGER DEFAULT CURRENT_TIMESTAMP -) +DROP TABLE IF EXISTS 'Version' ; +/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ + CREATE TABLE 'DikeAssessmentSectionEntity' ( 'DikeAssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -70,6 +53,7 @@ ( 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY, 'DikeAssessmentSectionEntityId' INTEGER NOT NULL, + 'LocationId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, 'LocationX' NUMERIC NOT NULL, 'LocationY' NUMERIC NOT NULL, @@ -78,6 +62,14 @@ ) ; +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, @@ -89,6 +81,15 @@ ) ; +CREATE TABLE 'Version' +( + 'VersionId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FromVersion' TEXT, + 'ToVersion' TEXT, + 'Timestamp' NUMERIC +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_AssessmentSection_ProjectEntity'