diff options
author | 2018-03-19 05:45:47 +0000 | |
---|---|---|
committer | 2018-03-21 14:20:44 -0400 | |
commit | f67e418cca95ef2c07e61bf65ea0334ac5ca9b1c (patch) | |
tree | 2d49e7177b4c23c91685ce15d366323f70405822 /kubernetes/clamp/charts/mariadb/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql | |
parent | a68cf4f3da292a9b41b6570067470bb456ca41c6 (diff) |
Add Helm Chart Standardization for Clamp
Issue-ID: OOM-735
Change-Id: Id5789742b4c930dcb2bebebbaa2cf82182949ee3
Signed-off-by: vaibhav_16dec <vaibhav.chopra@amdocs.com>
Signed-off-by: Mike Elliott <mike.elliott@amdocs.com>
Diffstat (limited to 'kubernetes/clamp/charts/mariadb/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql')
-rw-r--r-- | kubernetes/clamp/charts/mariadb/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/kubernetes/clamp/charts/mariadb/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql b/kubernetes/clamp/charts/mariadb/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/charts/mariadb/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; |