Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r4f6e0fc5af40cbeb6497e6141eba1d932bd2589c -r064bde9be43cb16a736faaad8694f00270a30ec1 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 4f6e0fc5af40cbeb6497e6141eba1d932bd2589c) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 064bde9be43cb16a736faaad8694f00270a30ec1) @@ -1,11 +1,17 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 22-Mar-2016 9:03:41 AM */ +/* Created On : 22-Mar-2016 9:13:29 AM */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ /* Drop Tables */ +DROP TABLE IF EXISTS 'Version' +; + +DROP TABLE IF EXISTS 'ProjectEntity' +; + DROP TABLE IF EXISTS 'DikeAssessmentSectionEntity' ; @@ -18,10 +24,24 @@ DROP TABLE IF EXISTS 'ReferenceLinePointEntity' ; -DROP TABLE IF EXISTS 'Version' +/* 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 +) ; -/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ +CREATE TABLE 'ProjectEntity' +( + 'ProjectEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Description' VARCHAR (260), + 'LastUpdated' INTEGER DEFAULT CURRENT_TIMESTAMP +) +; CREATE TABLE 'DikeAssessmentSectionEntity' ( @@ -69,15 +89,6 @@ ) ; -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'