summaryrefslogtreecommitdiffstats
path: root/kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop
diff options
context:
space:
mode:
authorAlexis de Talhouƫt <alexis.de_talhouet@bell.ca>2018-01-24 14:50:21 +0000
committerGerrit Code Review <gerrit@onap.org>2018-01-24 14:50:21 +0000
commit2e533498b23e25d7e5fa31862f0f73e9c2329b11 (patch)
tree1d262ec9f0b9e8a80d6a28cde4a1318288dd3670 /kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop
parent85091152dd3a572f1ef33c73ff07446af1b97a57 (diff)
parenta2608a283531785a7595b122f9f406da99925a25 (diff)
Merge "clamp config seg"
Diffstat (limited to 'kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop')
-rw-r--r--kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql33
1 files changed, 33 insertions, 0 deletions
diff --git a/kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql b/kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql
new file mode 100644
index 0000000000..478eaf0e09
--- /dev/null
+++ b/kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql
@@ -0,0 +1,33 @@
+#
+# Drop CLDS database objects (tables, etc.)
+#
+
+
+ALTER TABLE template
+ DROP FOREIGN KEY template_image_id_fkey01;
+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
+ DROP FOREIGN KEY model_prop_id_fkey01;
+ALTER TABLE model
+ DROP FOREIGN KEY model_blueprint_id_fkey01;
+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;
+DROP TABLE event;
+DROP TABLE model;
+
+DROP TABLE template_doc;
+DROP TABLE template_image;
+DROP TABLE template_bpmn;
+DROP TABLE template;