aboutsummaryrefslogtreecommitdiffstats
path: root/kubernetes/clamp/resources/config/mariadb/docker-entrypoint-initdb.d/drop/clds-drop-db-objects.sql
blob: 478eaf0e099b78fdbd766881cebcd04860616988 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
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;