Rework the Clamp db model
Rework the DB model + new SQL associated to that
Change-Id: Ibfa6e0bc9942f8b51a1681fab98502c462d34def
Issue-Id: CLAMP-1
Signed-off-by: Determe, Sebastien (sd378r) <sd378r@intl.att.com>
diff --git a/extra/sql/drop/clds-drop-db-objects.sql b/extra/sql/drop/clds-drop-db-objects.sql
index 487aa49..478eaf0 100644
--- a/extra/sql/drop/clds-drop-db-objects.sql
+++ b/extra/sql/drop/clds-drop-db-objects.sql
@@ -1,6 +1,5 @@
-#
-# Drop CLDS database objects (tables, etc.)
#
+# Drop CLDS database objects (tables, etc.)
#
@@ -10,7 +9,7 @@
DROP FOREIGN KEY template_bpmn_id_fkey01;
ALTER TABLE template
DROP FOREIGN KEY template_doc_id_fkey01;
-
+
ALTER TABLE model
DROP FOREIGN KEY template_id_fkey01;
ALTER TABLE model
@@ -20,6 +19,8 @@
ALTER TABLE model
DROP FOREIGN KEY event_id_fkey01;
+DROP TABLE clds_service_cache;
+
DROP TABLE model_instance;
DROP TABLE model_blueprint;
DROP TABLE model_properties;