Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -re1413d482cd37476c01aaea03ae16efc50433f3e -r7c766c291e763a54ef8ce4e2b9cadabda9e8296d --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision e1413d482cd37476c01aaea03ae16efc50433f3e) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 7c766c291e763a54ef8ce4e2b9cadabda9e8296d) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 23-mei-2016 13:26:35 */ +/* Created On : 24-mei-2016 15:08:44 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -24,6 +24,9 @@ DROP TABLE IF EXISTS 'FailureMechanismSectionPointEntity' ; +DROP TABLE IF EXISTS 'CalculationGroupEntity' +; + DROP TABLE IF EXISTS 'HydraulicLocationEntity' ; @@ -114,6 +117,19 @@ ) ; +CREATE TABLE 'CalculationGroupEntity' +( + 'CalculationGroupEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'ParentCalculationGroupEntityId' INTEGER, + 'Name' VARCHAR (255), + 'IsEditable' TEXT, + 'Order' TEXT, + CONSTRAINT 'FK_CalculationGroupEntity_CalculationGroupEntity' FOREIGN KEY ('ParentCalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_CalculationGroupEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE No Action ON UPDATE Cascade +) +; + CREATE TABLE 'HydraulicLocationEntity' ( 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -227,6 +243,14 @@ ON 'FailureMechanismSectionPointEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity' + ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_CalculationGroupEntity_FailureMechanismEntity' + ON 'CalculationGroupEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_HydraulicLocationEntity_AssessmentSectionEntity' ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ;