Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r4adf3910b91fba2fe6e7f7766836082046ab769a -re7acba10209b18e88bf89d9211f6fc031d0f992e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 4adf3910b91fba2fe6e7f7766836082046ab769a) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision e7acba10209b18e88bf89d9211f6fc031d0f992e) @@ -1,23 +1,11 @@ -- --- File generated with SQLiteStudio v3.0.7 on Fri Jan 29 11:47:02 2016 +-- File generated with SQLiteStudio v3.0.7 on Thu Feb 4 14:00:37 2016 -- -- Text encoding used: windows-1252 -- PRAGMA foreign_keys = off; BEGIN TRANSACTION; --- Table: Version -DROP TABLE IF EXISTS Version; - -CREATE TABLE Version ( - VersionId INTEGER PRIMARY KEY AUTOINCREMENT - NOT NULL, - FromVersion VARCHAR (16), - ToVersion VARCHAR (16), - Timestamp NUMERIC -); - - -- Table: ProjectEntity DROP TABLE IF EXISTS ProjectEntity; @@ -29,6 +17,21 @@ ); +-- Table: DuneAssessmentSectionEntity +DROP TABLE IF EXISTS DuneAssessmentSectionEntity; + +CREATE TABLE DuneAssessmentSectionEntity ( + DuneAssessmentSectionEntityId INTEGER PRIMARY KEY AUTOINCREMENT + NOT NULL, + ProjectEntityId INTEGER REFERENCES ProjectEntity (ProjectEntityId) ON DELETE CASCADE + ON UPDATE CASCADE + NOT NULL, + Name VARCHAR (260) NOT NULL, + Norm INT NOT NULL, + [Order] INT NOT NULL +); + + -- Table: DikeAssessmentSectionEntity DROP TABLE IF EXISTS DikeAssessmentSectionEntity; @@ -38,10 +41,23 @@ ProjectEntityId INTEGER REFERENCES ProjectEntity (ProjectEntityId) ON DELETE CASCADE ON UPDATE CASCADE NOT NULL, - Name VARCHAR (260), - Norm INT + Name VARCHAR (260) NOT NULL, + Norm INT NOT NULL, + [Order] INT (0) NOT NULL ); +-- Table: Version +DROP TABLE IF EXISTS Version; + +CREATE TABLE Version ( + VersionId INTEGER PRIMARY KEY AUTOINCREMENT + NOT NULL, + FromVersion VARCHAR (16), + ToVersion VARCHAR (16), + Timestamp NUMERIC +); + + COMMIT TRANSACTION; PRAGMA foreign_keys = on;