summaryrefslogtreecommitdiffstats
path: root/extra/sql/drop
diff options
context:
space:
mode:
authorDeterme, Sebastien (sd378r) <sd378r@intl.att.com>2017-08-08 02:58:27 -0700
committerSébastien Determe <sd378r@intl.att.com>2017-08-08 12:34:18 +0000
commitb3a21f74c5c31644eeef9634e33dde8a6972e3f8 (patch)
tree887149ac05a73987c318e93a7bfb79212b0d5e3f /extra/sql/drop
parent08673dc040d7483e159a6e705993690538d7b117 (diff)
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>
Diffstat (limited to 'extra/sql/drop')
-rw-r--r--extra/sql/drop/clds-drop-db-objects.sql7
1 files changed, 4 insertions, 3 deletions
diff --git a/extra/sql/drop/clds-drop-db-objects.sql b/extra/sql/drop/clds-drop-db-objects.sql
index 487aa49d..478eaf0e 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 @@ ALTER TABLE template
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
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;