extra/sql/drop/clds-drop-db-objects.sql


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
34
35
36
37
38
39

#
# 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;

DROP TABLE dictionary_elements;
DROP TABLE dictionary;
DROP TABLE tosca_model_revision;
DROP TABLE tosca_model;