Attribute DAO

[modules/gde.git] / projects / GDE_App / src / GDE_DB_Init.sql

diff --git a/projects/GDE_App/src/GDE_DB_Init.sql b/projects/GDE_App/src/GDE_DB_Init.sql
index 369f5a9e35d165c78ee8adbfa49e96a7791874dd..10ecb1638f958ea42b2077b2ebe84d9998ae025e 100644 (file)
--- a/projects/GDE_App/src/GDE_DB_Init.sql
+++ b/projects/GDE_App/src/GDE_DB_Init.sql
@@ -53,8 +53,8 @@ CREATE TABLE attribute (
 
 DROP TABLE IF EXISTS attribute_group_attribute CASCADE;
 CREATE TABLE attribute_group_attribute (
-    attributegroup_id bigint REFERENCES attribute_group (id),
-    attribute_id bigint REFERENCES attribute(id)
+    attributegroup_id bigint REFERENCES attribute_group (id) on delete cascade,
+    attribute_id bigint REFERENCES attribute(id) on delete cascade
 );
 CREATE INDEX attribute_group_attribute_idx1 on attribute_group_attribute(attributegroup_id);
 CREATE INDEX attribute_group_attribute_idx2 on attribute_group_attribute(attribute_id);