Code Review
/
clamp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
Rework the Clamp db model
[clamp.git]
/
extra
/
sql
/
drop
/
clds-drop-db-objects.sql
diff --git
a/extra/sql/drop/clds-drop-db-objects.sql
b/extra/sql/drop/clds-drop-db-objects.sql
index
487aa49
..
478eaf0
100644
(file)
--- 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;
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
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;
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 model_instance;
DROP TABLE model_blueprint;
DROP TABLE model_properties;